private 客户量体 generateUserShape() { 客户 ush = new 客户(); ush.Usershape.Lingwei = this.lingwei.Text; ush.Usershape.Yaowei = this.yaowei.Text; ush.Usershape.Jiankuan = this.jiankuan.Text; ush.Usershape.Bigenwei = this.bigenwei.Text; ush.Usershape.Wanwei = this.wanwei.Text; ush.Usershape.Tixing = this.tixing.Text; ush.Usershape.Jianxing = this.jianxing.Text; ush.Usershape.Fuxing = this.fuxing.Text; ush.Usershape.Beixing = this.beixing.Text; if (shentitezheng.GetItemChecked(0)) { ush.Usershape.Shentitezheng.Add(0); } if (shentitezheng.GetItemChecked(1)) { ush.Usershape.Shentitezheng.Add(1); } if (shentitezheng.GetItemChecked(2)) { ush.Usershape.Shentitezheng.Add(2); } if (shentitezheng.GetItemChecked(3)) { ush.Usershape.Shentitezheng.Add(3); } if (shentitezheng.GetItemChecked(4)) { ush.Usershape.Shentitezheng.Add(4); } if (shentitezheng.GetItemChecked(5)) { ush.Usershape.Shentitezheng.Add(5); } if (angshoutingxiong.Checked) { ush.Usershape.Angshoutingxiong = true; } else { ush.Usershape.Angshoutingxiong = false; } //ush.Pctup1 = new Bitmap(pctup1); //int ist = new int(); //ist = DBUtil.DoExecute( //"INSERT INTO chunshan_kehuliangti(id,kehu_id,lingwei,yaowei,jiankuan,bigenwei,wanwei,tixing,jianxing,fuxing,beixing,shentitezheng,angshoutingxiong)VALUES (uuid_generate_v4(), '" + customer.Name + "', '" + ush.Lingwei + "', '" + ush.Yaowei + "', '" + ush.Jiankuan + "', '" + ush.Bigenwei + "','" + ush.Wanwei + "','" + ush.Tixing + "','" + ush.Jianxing + "','" + ush.Fuxing+ "','" + ush.Beixing + "', '" + ush.Shentitezheng+"', '"+ush.Angshoutingxiong+"')"); return(ush.Usershape); }
//private List<xinxi> nl = new List<xinxi>(); // 初始化数据 private void initData() { this.customer = new 客户("", "", "", "", "", "", ""); DataTable dt = new DataTable(); //dt = DBUtil.GetDataTable("select * from a_customer_p where MOBILE='" + form.shj+"'"); customer.Id = dt.Rows[0]["CUSTOMER_ID"].ToString(); customer.Name = dt.Rows[0]["CUSTOMER_FIRST_NAME"].ToString(); //customer.Shengao = dt.Rows[0]["shengao"].ToString(); customer.Shouji = dt.Rows[0]["MOBILE"].ToString(); customer.Xingbie = dt.Rows[0]["SEX_CD"].ToString(); //customer.Tizhong = dt.Rows[0]["tizhong"].ToString(); customer.Dizhi = dt.Rows[0]["ADDRESS_DETAIL"].ToString(); }