首页
Homepage
课程选择
Course select
实践乐园
Praticse
学霸专栏
Coolman
个人中心
Manager
通知
News
理论考试
Test
实验组作品
Student Work
注册
Registe
资料查看下载交界面
班级名称:
Label
课程名称:
C sharp程序设计
320
CK2R04A
标 题：
文档实例：库存明细示例
<p> <br /> </p> <p class="MsoNormal"> <b><span style="font-family:宋体;color:#FF0000;font-weight:bold;font-size:14.0000pt;"><span>补充技术点：</span></span></b><b><span style="font-family:宋体;color:#FF0000;font-weight:bold;font-size:14.0000pt;"></span></b> </p> <p class="MsoNormal" style="text-align:left;"> <span style="font-family:宋体;font-size:10.5000pt;">1<span>）、更新库存数量：</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal" style="text-align:left;"> <span style="font-family:'Times New Roman';font-size:10.5000pt;">Y</span><span style="font-family:宋体;font-size:10.5000pt;">uankucun <span>读取：类似于读取密码一样根据“产品编号”从“姓名</span></span><span style="font-family:'Times New Roman';font-size:10.5000pt;">_</span><span style="font-family:宋体;font-size:10.5000pt;"><span>产品基本信息表</span>”中读取字段“库存数量”的值。</span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:新宋体;font-size:9.5000pt;">K</span><span style="font-family:宋体;font-size:9.5000pt;">ucunshuliang = yunakucun int.Parse(</span><span style="font-family:宋体;font-size:10.5000pt;"><span>入库数量</span>.Text</span><span style="font-family:宋体;font-size:9.5000pt;">); //</span><span style="font-family:宋体;font-size:10.5000pt;"><span>出库改为减</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal" style="text-align:left;"> <span style="font-family:新宋体;font-size:9.5000pt;">strsql = </span><span style="font-family:新宋体;color:#A31515;font-size:9.5000pt;">“update</span><span style="font-family:宋体;color:#A31515;font-size:9.5000pt;"> </span><span style="font-family:宋体;font-size:10.5000pt;"><span>姓名</span></span><span style="font-family:'Times New Roman';font-size:10.5000pt;">_</span><span style="font-family:宋体;font-size:10.5000pt;"><span>产品基本信息表</span> </span><span style="font-family:新宋体;color:#A31515;font-size:9.5000pt;">set</span><span style="font-family:宋体;color:#A31515;font-size:9.5000pt;"> </span><span style="font-family:宋体;font-size:10.5000pt;"><span>库存数量</span></span><span style="font-family:新宋体;color:#A31515;font-size:9.5000pt;">=”</span><span style="font-family:新宋体;font-size:9.5000pt;"> </span><span style="font-family:宋体;font-size:9.5000pt;">kucunshuliang</span><span style="font-family:新宋体;font-size:9.5000pt;"> </span><span style="font-family:新宋体;color:#A31515;font-size:9.5000pt;">“</span><span style="font-family:宋体;color:#A31515;font-size:9.5000pt;"> where </span><span style="font-family:宋体;font-size:10.5000pt;"><span>产品编号</span>=</span><span style="font-family:'Times New Roman';font-size:10.5000pt;">’”</span><span style="font-family:宋体;font-size:10.5000pt;"> <span>产品编号</span><span>.Text </span></span><span style="font-family:'Times New Roman';font-size:10.5000pt;">”’”</span><span style="font-family:新宋体;font-size:9.5000pt;">;</span><span style="font-family:新宋体;font-size:9.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;"> </span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;">2)<span>、根据时间查询统计</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;"><span>时间的条件如下</span>(<span>注意时间只能用井字符号括起来，不能用单引号</span><span>) </span><span>：</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:'Times New Roman';font-size:10.5000pt;">S</span><span style="font-family:宋体;font-size:10.5000pt;">elect * from <span>姓名</span><span>_</span><span>入库表 </span></span><span style="font-family:'Times New Roman';font-size:10.5000pt;">W</span><span style="font-family:宋体;font-size:10.5000pt;">here <span>入库时间</span><span>>#2013-3-3#</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;"> </span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;">3)<span>、下拉框的表格绑定：</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;"><span>下拉框控件名：</span></span><span style="font-family:'Times New Roman';font-size:10.5000pt;">comboBox1</span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;"> string strsql = "select <span>姓名 </span><span>from employee";//</span><span>读取数据的</span><span>SQL</span><span>语句</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:'Times New Roman';font-size:10.5000pt;"> DataTable dt = new DataTable();</span><span style="font-family:'Times New Roman';font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:宋体;font-size:10.5000pt;"> dt = me.getTable(strsql);//<span>调用读数据的函数进行读，并把读取的表返回。</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:'Times New Roman';font-size:10.5000pt;"> </span><span style="font-family:宋体;font-size:10.5000pt;"> comboBox1.DisplayMember = "<span>姓名</span>";//<span>要显示的字段名</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p class="MsoNormal"> <span style="font-family:'Times New Roman';font-size:10.5000pt;"> comboBox1.DataSource = dt;</span><span style="font-family:宋体;font-size:10.5000pt;">//<span>绑定表格。</span></span><span style="font-family:宋体;font-size:10.5000pt;"></span> </p> <p> <br /> </p> <p> 3、mysql 连接字符串 </p> <p> <br /> </p> <p> conStr = "Database=tempdatabase; User ID=root;Password=boby888; Host=localhost; Port= 3306;Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0;Charset=utf8"; </p>
Copyright ? 2015 All Rights Reserved.
备案：
浙ICP备16014922