private void ClientInfo_Load(object sender, System.EventArgs e) { if (_opearType == "修改") { var selectsql = SelectSQL.SelectClientWithId(_clientId); var dt = DLL.BindData.ReturnDataTable(selectsql); if (dt != null && dt.Rows.Count > 0) { txtClientName.Text = dt.Rows[0]["ClientName"].ToString(); txtClientPhone.Text = dt.Rows[0]["ClientPhone"].ToString(); } button1.Text = "修改"; } }
private void ProductInfo_Load(object sender, EventArgs e) { if (_opearType == "修改") { var selectsql = SelectSQL.SelectProductWithId(_productId); var dt = BindData.ReturnDataTable(selectsql); if (dt != null && dt.Rows.Count > 0) { //绑定页面数据 txtProductName.Text = dt.Rows[0]["ProductName"].ToString(); txtProductCode.Text = dt.Rows[0]["ProductCode"].ToString(); txtInPrice.Text = dt.Rows[0]["InPrice"].ToString(); txtOutPrice.Text = dt.Rows[0]["OutPrice"].ToString(); txtProductNum.Text = dt.Rows[0]["ProductNum"].ToString(); txtRemark.Text = dt.Rows[0]["Remark"].ToString(); _clientId = int.Parse(dt.Rows[0]["ClientInfo"].ToString()); _pictureId = dt.Rows[0]["PictureInfo"].ToString(); //绑定客户数据 selectsql = SelectSQL.SelectClientWithId(_clientId); dt = BindData.ReturnDataTable(selectsql); if (dt != null && dt.Rows.Count > 0) { lblClientName.Text = dt.Rows[0]["ClientName"].ToString(); lblClientPhone.Text = dt.Rows[0]["ClientPhone"].ToString(); } //绑定图片数据 selectsql = SelectSQL.SelectPictureWithId(_pictureId); dt = BindData.ReturnDataTable(selectsql); if (dt != null && dt.Rows.Count > 0) { pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; pictureBox1.ImageLocation = dt.Rows[0]["PicturePath"].ToString(); } } button1.Text = "修改商品"; } }