private void bt_save_Click(object sender, EventArgs e) { if (txt_mbmc.Text.Trim() == "") { MessageBox.Show("请填写模板名称!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = txt_mbmc; return; } if (txt_bh.Text.Trim() == "") { txt_bh.Text = xtbiz.GetHmz("jbmbid", 1); } if (txt_disp_order.Text.Trim() == "") { txt_disp_order.Text = txt_bh.Text; } str_bh = txt_bh.Text.Trim(); ywszBiz ywszbiz1 = new ywszBiz(); ywszbiz1.str_Insert_tj_xmmb_hd(txt_bh.Text.Trim(), txt_disp_order.Text.Trim(), txt_mbmc.Text.Trim(), txt_bz.Text.Trim()); ywszbiz1.Exec_ArryList(); MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); DataBind(); }
private void bt_save1_Click(object sender, EventArgs e) { if (str_tjlx == "" || str_tjxm == "") { return; } ywszBiz ywszbiz1 = new ywszBiz(); ywszbiz1.str_Sqltxt("delete tj_keyword where tjxm='" + str_tjxm + "'"); dt_tj_keyword1.AcceptChanges(); foreach (DataRow dr in dt_tj_keyword1.Rows) { if (dr["bh"].ToString().Trim() == "" || dr["mc"].ToString().Trim() == "") { MessageBox.Show("请填写顺序号、描述!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ywszbiz1.str_Insert_tj_keyword_zf(dr["bh"].ToString().Trim(), dr["mc"].ToString().Trim(), dr["keyword"].ToString().Trim(), dr["into_xj"].ToString().Trim(), dr["mcjrxj"].ToString().Trim(), dr["sfyx"].ToString().Trim(), dr["pyjm"].ToString().Trim(), dr["wbjm"].ToString().Trim(), dr["jglx"].ToString().Trim(), cmb_xb.SelectedValue.ToString().Trim(), str_tjlx,//dr["tjlx"].ToString().Trim(), dr["tjxm"].ToString().Trim()); } string str_jgjrxj = "1"; //结果进入小结 string str_mcjrxj = "1"; //名称进入小结 if (rb_jgsfjrxj1.Checked) { str_jgjrxj = "1"; } else { str_jgjrxj = "0"; } if (rb_xmmcsfjrxj1.Checked) { str_mcjrxj = "1"; } else { str_mcjrxj = "0"; } ywszbiz1.str_Update_tj_tjxmb(str_tjlx, str_tjxm, str_jgjrxj, str_mcjrxj); ywszbiz1.Exec_ArryList(); MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void bt_save_Click(object sender, EventArgs e) { if (txt_flmc.Text.Trim() == "") { MessageBox.Show("请填写分类名称!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = txt_flmc; return; } if (object.Equals(null, cmb_jcjylx.SelectedValue)) { MessageBox.Show("请选择检查类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = cmb_jcjylx; return; } if (cmb_jcjylx.SelectedValue.ToString().Trim() == "0" && object.Equals(null, cmb_bblx.SelectedValue)) { MessageBox.Show("请选择标本类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = cmb_bblx; return; } string str_bblx = ""; try { str_bblx = cmb_bblx.SelectedValue.ToString().Trim(); } catch { } if (txt_flbh.Text.Trim() == "") { txt_flbh.Text = xtbiz.GetHmz("sqdflbh", 1); } if (txt_disp_order.Text.Trim() == "") { txt_disp_order.Text = txt_flbh.Text; } str_flbh = txt_flbh.Text.Trim(); str_jcjylx = cmb_jcjylx.SelectedValue.ToString().Trim(); ywszBiz ywszbiz1 = new ywszBiz(); ywszbiz1.str_Insert_tj_sqdlx_hd(txt_flbh.Text.Trim(), txt_disp_order.Text.Trim(), txt_flmc.Text.Trim(), str_jcjylx, str_bblx, txt_bz.Text.Trim()); ywszbiz1.Exec_ArryList(); MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); DataBind(); }
private void bt_save_Click(object sender, EventArgs e) { if (object.Equals(null, cmb_xb.SelectedValue)) { MessageBox.Show("请选择性别!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = cmb_xb; return; } if (txt_mc.Text.Trim() == "") { MessageBox.Show("请填写套餐名称!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = txt_mc; return; } if (object.Equals(null, cmb_tjywlx.SelectedValue)) { MessageBox.Show("请选择业务类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = cmb_tjywlx; return; } if (lv_tjtcxm.Items.Count <= 0) { MessageBox.Show("体检套餐项目不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //this.ActiveControl = cmb_tjywlx; return; } if (txt_bh.Text.Trim() == "") { str_bh = xtbiz.GetHmz("tcid", 1); txt_bh.Text = str_bh; } ywszBiz ywszbiz1 = new ywszBiz(); ywszbiz1.str_Insert_tj_tc_hd(txt_bh.Text.Trim(), txt_disp_order.Text.Trim(), cmb_xb.SelectedValue.ToString().Trim(), txt_mc.Text.Trim(), txt_jc.Text.Trim(), txt_bzjg.Text.Trim(), txt_jg.Text.Trim(), cmb_tjywlx.SelectedValue.ToString().Trim(), txt_bz.Text.Trim()); ywszbiz1.str_Delete_tj_tc_dc(str_bh); foreach (ListViewItem item in lv_tjtcxm.Items) { ywszbiz1.str_Insert_tj_tc_dc(str_bh, item.Tag.ToString().Trim()); } ywszbiz1.Exec_ArryList(); MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); DataBind(); }
private void bt_delete_Click(object sender, EventArgs e) { if (str_bh == "") { return; } if (DialogResult.Yes == MessageBox.Show("是否真的删除?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)) { ywszBiz ywszbiz1 = new ywszBiz(); ywszbiz1.str_Delete_tj_tc_hd(str_bh); ywszbiz1.str_Delete_tj_tc_dc(str_bh); ywszbiz1.Exec_ArryList(); MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); tv_tc.Nodes.Remove(tv_tc.SelectedNode); ClearControl(); } }
private void bt_savemx_Click(object sender, EventArgs e) { if (txt_bh.Text.Trim() == "") { return; } ywszBiz ywszbiz1 = new ywszBiz(); ywszbiz1.str_Sqltxt("delete tj_zhxm_dt where bh='" + txt_bh.Text.Trim() + "'"); foreach (DataGridViewRow dgr in dgv_tjxmb.Rows) { if (Convert.ToBoolean(dgr.Cells["xz"].Value)) { ywszbiz1.str_Insert_tj_zhxm_dt(txt_bh.Text.Trim(), cmb_ksmc.SelectedValue.ToString().Trim(), dgr.Cells["tjxm"].Value.ToString().Trim(), "1"); } } ywszbiz1.Exec_ArryList(); MessageBox.Show("保存明细成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); }
void DataBind(string str_tjlx) { ywszBiz ywszbiz = new ywszBiz(); if (str_tjlx == "" && str_lclx == "") { dt = ywszbiz.Get_TJ_SUGGESTION2(); } else if (str_tjlx != "" && str_lclx == "") { dt = ywszbiz.Get_TJ_SUGGESTION3(str_tjlx); } else { dt = ywszbiz.Get_TJ_SUGGESTION1(str_tjlx, str_lclx); } if (dt.Rows.Count < 1) { this.ActiveControl = txt_pym; return; } this.dgv_zd.DataSource = dt; this.ActiveControl = dgv_zd; }
private void bt_save3_Click(object sender, EventArgs e) { if (str_tjlx == "" || str_tjxm == "") { return; } dt_tj_keyword3.AcceptChanges(); //if (dt_tj_keyword3.Rows.Count < 1) return; ywszBiz ywszbiz1 = new ywszBiz(); ywszbiz1.str_Sqltxt("delete tj_keyword where tjlx='" + str_tjlx + "' and tjxm='" + str_tjxm + "' and jglx!='10'"); foreach (DataRow dr in dt_tj_keyword3.Rows) { if (Check_GridDataView_Zcfw(dgv_xmjg3)) { MessageBox.Show("请选择一个【是否正常范围】区间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //if (dr["bh"].ToString().Trim() == "" || dr["mc"].ToString().Trim() == "") //{ // MessageBox.Show("请填写顺序号、描述!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} if (Convert.ToDecimal(dr["dy"].ToString().Trim()) > Convert.ToDecimal(dr["xy"].ToString().Trim()) && Convert.ToDecimal(dr["xy"].ToString().Trim()) > 0) { MessageBox.Show("下限值不能大于上限值,请检查!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ywszbiz1.str_Insert_tj_keyword_sz(dr["bh"].ToString().Trim(), dr["nlxx"].ToString().Trim(), dr["nlsx"].ToString().Trim(), dr["dy"].ToString().Trim(), dr["xy"].ToString().Trim(), dr["mc"].ToString().Trim(), dr["sfzc"].ToString().Trim(), dr["keyword"].ToString().Trim(), dr["mcjrxj"].ToString().Trim(), dr["into_xj"].ToString().Trim(), dr["sfyx"].ToString().Trim(), dr["pyjm"].ToString().Trim(), dr["wbjm"].ToString().Trim(), dr["jglx"].ToString().Trim(), "1", dr["tjlx"].ToString().Trim(), dr["tjxm"].ToString().Trim(), dr["spy"].ToString().Trim(), dr["xpy"].ToString().Trim(), dr["whys"].ToString().Trim());//性别1为女性 } string str_jgjrxj = "1"; //结果进入小结 string str_mcjrxj = "1"; //名称进入小结 if (rb_jgsfjrxj1.Checked) { str_jgjrxj = "1"; } else { str_jgjrxj = "0"; } if (rb_xmmcsfjrxj1.Checked) { str_mcjrxj = "1"; } else { str_mcjrxj = "0"; } ywszbiz1.str_Update_tj_tjxmb(str_tjlx, str_tjxm, str_jgjrxj, str_mcjrxj); ywszbiz1.Exec_ArryList(); MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); dt_tj_keyword2 = ywszbiz.Get_tj_keyword_sz_all(str_tjxm); //数值类型男女共用 dt_tj_keyword3 = ywszbiz.Get_tj_keyword_sz_nx(str_tjxm); //数值男性 dt_tj_keyword4 = ywszbiz.Get_tj_keyword_sz_vx(str_tjxm); //数值女性 dgv_xmjg2.DataSource = dt_tj_keyword2; dgv_xmjg3.DataSource = dt_tj_keyword3; dgv_xmjg4.DataSource = dt_tj_keyword4; }