private int SAVE() { Dictionary <string, string> beforeVisit = new Dictionary <string, string>(); int result = 0; try { beforeVisit.Add("txtPatid", txtPatid.Controls[0].Text.Trim()); beforeVisit.Add("zhuyuanid", txtZhuYuanNo.Controls[0].Text); beforeVisit.Add("txtPatname", txtPatname.Controls[0].Text); beforeVisit.Add("txtPatage", txtPatage.Controls[0].Text); beforeVisit.Add("cmbSex", txtSex.Controls[0].Text); beforeVisit.Add("txtDepartment", this.txtBingQu.Controls[0].Text); beforeVisit.Add("txtBednumber", txtBednumber.Controls[0].Text); beforeVisit.Add("txtWeight", txtWeight.Controls[0].Text); beforeVisit.Add("txtHeight", txtHeight.Controls[0].Text); beforeVisit.Add("txtNssss", txtNssss.Controls[0].Text); beforeVisit.Add("txtSqzd", txtSqzd.Controls[0].Text); beforeVisit.Add("cmbOroom", cmbOroom.Text.Trim()); beforeVisit.Add("txtSecond", cmbSecond.Text.Trim()); beforeVisit.Add("txtMZFF", cmbMZFF.Text); beforeVisit.Add("txtMZYS", this.txtMZYS.Controls[0].Text); beforeVisit.Add("txtQXHS", this.txtQXHS.Controls[0].Text); beforeVisit.Add("txtXHHS", this.txtXHHS.Controls[0].Text); beforeVisit.Add("dtOSdate", dtOSDate.Value.ToString()); beforeVisit.Add("OS", txtOS.Controls[0].Text); beforeVisit.Add("ostate", "0"); beforeVisit.Add("applyId", txtSQDH.Controls[0].Text); beforeVisit.Add("Cardno", txtCardID.Controls[0].Text); beforeVisit.Add("ReplyDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm")); if (DAL.GetALLPAIBAN(txtPatid.Controls[0].Text).Rows.Count == 0) { result = DAL.InsertPAIBAN(beforeVisit); } else { result = DAL.UpdatePAIBAN(beforeVisit); } return(result); } catch (Exception ex) { return(0); //MessageBox.Show(ex.ToString(), "保存出现异常,请检查!"); } }
private void MZZJ_ZXYJH_Load(object sender, EventArgs e) { txtpatID.Controls[0].Text = patID; txtMzjldid.Controls[0].Text = mzjldID; DataTable dt = new DataTable(); dt = apro.GetALLPAIBAN(patID); txtName.Controls[0].Text = dt.Rows[0]["Patname"].ToString(); txtAge.Controls[0].Text = dt.Rows[0]["Patage"].ToString(); txtSex.Controls[0].Text = dt.Rows[0]["Patsex"].ToString(); SetValues(); DataFromMZJLD(); }
private void SAVE() { Dictionary <string, string> beforeVisit = new Dictionary <string, string>(); int result = 0; try { beforeVisit.Add("txtPatid", txtPatid.Controls[0].Text.Trim()); beforeVisit.Add("zhuyuanid", txtPatid.Controls[0].Text.Trim()); beforeVisit.Add("txtPatname", txtPatname.Controls[0].Text); beforeVisit.Add("txtPatage", txtPatage.Controls[0].Text); beforeVisit.Add("cmbSex", txtSex.Controls[0].Text); beforeVisit.Add("keshi", this.cmbKeshi.Text); beforeVisit.Add("txtBednumber", txtBednumber.Controls[0].Text); beforeVisit.Add("txtWeight", txtWeight.Controls[0].Text); beforeVisit.Add("txtHeight", txtHeight.Controls[0].Text); beforeVisit.Add("txtNssss", txtNssss.Controls[0].Text); beforeVisit.Add("txtSqzd", txtSqzd.Controls[0].Text); beforeVisit.Add("cmbOroom", cmbOroom.Text.Trim()); beforeVisit.Add("txtSecond", tbSecond.Text.Trim()); beforeVisit.Add("txtMZFF", cmbMZFF.Text); beforeVisit.Add("txtMZYS", this.txtMZYS.Controls[0].Text); beforeVisit.Add("txtQXHS", this.txtQXHS.Controls[0].Text); beforeVisit.Add("txtXHHS", this.txtXHHS.Controls[0].Text); beforeVisit.Add("dtOSdate", dtOSDate.Value.ToString("yyyy-MM-dd HH:mm")); beforeVisit.Add("OS", txtOS.Controls[0].Text); if (cbJizhen.Checked) { beforeVisit.Add("isjizhen", "1"); } else { beforeVisit.Add("isjizhen", "0"); } beforeVisit.Add("startTime", dtOSDate.Value.ToString("HH:mm")); beforeVisit.Add("remarks", txtBZ.Controls[0].Text.Trim()); beforeVisit.Add("GR", cmbGR.Text.Trim()); beforeVisit.Add("tiwei", cmbTiwei.Text.Trim()); beforeVisit.Add("nation", txtPatNation.Controls[0].Text.Trim()); //beforeVisit.Add("AP2",""); //beforeVisit.Add("AP3",""); //beforeVisit.Add("OS1",""); //beforeVisit.Add("OS2",""); //beforeVisit.Add("OS3", ""); //beforeVisit.Add("OS4",""); //beforeVisit.Add("ON2", ""); //beforeVisit.Add("SN2",""); if (DAL.GetALLPAIBAN(txtPatid.Controls[0].Text.Trim()).Rows.Count == 0) { result = DAL.InsertPAIBAN(beforeVisit); } else { result = DAL.UpdatePAIBAN(beforeVisit); } if (result > 0) { MessageBox.Show("保存成功!"); paibanDataBind(); } else { MessageBox.Show("保存失败!"); } } catch (Exception ex) { MessageBox.Show(ex.ToString(), "保存出现异常,请检查!"); } }