菜单
  

                getdata(sql);
            }
        }
        private void getdata(string sql)
        {
            DataSet result = new DataSet();
            result = new Class1().hsggetdata(sql);
            if (result != null)
            {
                if (result.Tables[0].Rows.Count > 0)
                {
                    int k = 0;
                    for (k = 0; k < result.Tables[0].Rows.Count; k++)
                    {
                        bh.Items.Add(result.Tables[0].Rows[k]["bh"].ToString().Trim());
                    }
                }
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            string sql;
            sql = "select * from kucun where bh='"+bh.SelectedItem.ToString().Trim()+"'";
            DataSet result = new DataSet();
            result = new Class1().hsggetdata(sql);
            if (result != null)
            {
                if (result.Tables[0].Rows.Count > 0)
                {
                    sql = "update kucun set shuliang=shuliang+"+shuliang.Text.ToString().Trim()+" where bh='"+bh.SelectedItem.ToString().Trim()+"'";

                }
                else
                {
                    sql = "insert into kucun(bh,ggxh,dw,promc,price,shuliang,gys,rkprice) values('" + bh.SelectedItem.ToString().Trim() + "','" + ggxh.Text.ToString().Trim() + "','" + dw.Text.ToString().Trim() + "','" + promc.Text.ToString().Trim() + "'," + price.Text.ToString().Trim() + "," + shuliang.Text.ToString().Trim() + ",'" + gys.Text.ToString().Trim() + "'," + rkprice.Text.ToString().Trim() + ")";
                   
                }
            }
            int result2;
            result2 = new Class1().hsgexucute(sql);
            sql =  "insert into ruku(bh,ggxh,dw,promc,price,shuliang,gys,rkprice) values('" + bh.SelectedItem.ToString().Trim() + "','" + ggxh.Text.ToString().Trim() + "','" + dw.Text.ToString().Trim() + "','" + promc.Text.ToString().Trim() + "'," + price.Text.ToString().Trim() + "," + shuliang.Text.ToString().Trim() + ",'" + gys.Text.ToString().Trim() + "'," + rkprice.Text.ToString().Trim() + ")";
  1. 上一篇:Flash CS4三维游戏设计(赛车)
  2. 下一篇:C#+sqlserver学生MIS平台的设计与开发
  1. ERP软件物料需求计划模块设计

  2. jsp小企业品质在线评分系统设计与实现

  3. php+mysql移动终端企业生产...

  4. Justep基于开放平台的企业...

  5. jsp+mysql企业人事管理系统的设计和实现

  6. 基于IOS的个人时间管理软件

  7. 某钢铁企业能源数据库的设计+VB源程序

  8. 乳业同业并购式全产业链...

  9. 河岸冲刷和泥沙淤积的监测国内外研究现状

  10. 电站锅炉暖风器设计任务书

  11. 酸性水汽提装置总汽提塔设计+CAD图纸

  12. 大众媒体对公共政策制定的影响

  13. 当代大学生慈善意识研究+文献综述

  14. java+mysql车辆管理系统的设计+源代码

  15. 杂拟谷盗体内共生菌沃尔...

  16. 中考体育项目与体育教学合理结合的研究

  17. 十二层带中心支撑钢结构...

  

About

751论文网手机版...

主页:http://www.751com.cn

关闭返回