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(), "保存出现异常，请检查！");
}
}
