private void lv_tc_MouseDoubleClick(object sender, MouseEventArgs e) { ListViewItem item = lv_tc.GetItemAt(e.X, e.Y); if (object.Equals(null, item)) { return; } DataTable dt = ywszbiz.Get_tj_tc_dt(item.Tag.ToString().Trim()); tjdjBiz tjglbiz1 = new tjdjBiz(); foreach (DataRow dr in dt.Rows) { ListViewItem item1 = new ListViewItem(); item1.Tag = dr["zhxm"].ToString().Trim(); item1.Text = dr["mc"].ToString().Trim(); if (!Check_lv_checkxm_Exists(item1.Tag.ToString().Trim()))//不存在 { DataTable dt_tj_zhxm_hd = tjglbiz.Get_tj_zhxm_hd(item1.Tag.ToString().Trim()); string str_xh = xtbiz.GetHmz("tjjlbxh", 1);//体检记录本序号 string str_lxbh = dt_tj_zhxm_hd.Rows[0]["tjlx"].ToString().Trim(); string str_tjxmbh = dt_tj_zhxm_hd.Rows[0]["bh"].ToString().Trim(); string str_xmdj = dt_tj_zhxm_hd.Rows[0]["dj"].ToString().Trim(); string str_zxks = dt_tj_zhxm_hd.Rows[0]["tjlx"].ToString().Trim(); string str_xmlx = dt_tj_zhxm_hd.Rows[0]["jcjylx"].ToString().Trim(); string str_sflb = dt_tj_zhxm_hd.Rows[0]["sflb"].ToString().Trim(); tjglbiz1.str_Insert_tj_tjjlb(str_xh, str_tjbh, str_tjcs, str_lxbh, str_tjrq, str_tjxmbh, str_xmdj, "0", "1", str_sflb, str_zxks, str_xmlx); lv_checkxm.Items.Add(item1); } } tjglbiz1.Exec_ArryList(); }
private void tj_mrfz(string str_dwbh)// by zhz { //read if (str_dwbh == "") { return; //没有选择节点 } ywszBiz ywszbiz = new ywszBiz(); DataTable dt_tjtc = ywszbiz.Get_tj_tc_hd(); for (int i = 0; i < dt_tjtc.Rows.Count; i++) { DataRow dr_tc = dt_tjtc.Rows[i]; //体检项目 string str_bh = dr_tc["bh"].ToString().Trim(); DataTable dt_tj_tc_dc = ywszbiz.Get_tj_tc_dt(str_bh); //体检内容 //add txt_fzbh.Text = dr_tc["bh"].ToString().Trim(); txt_fzmc.Text = dr_tc["mc"].ToString().Trim(); //cmb_xb.SelectedValue = dr_tc["xb"].ToString().Trim(); txt_zc.Text = ""; txt_zw.Text = ""; str_fzbh = tjglbiz.Get_proc_get_tjdwfzbh(str_dwbh); tjdjBiz tjblbiz1 = new tjdjBiz(); tjblbiz1.str_Delete_TJ_DWFZ_HD(str_fzbh, str_dwbh); tjblbiz1.str_Insert_TJ_DWFZ_HD(str_fzbh, str_dwbh, txt_fzmc.Text.Trim(), "1", txt_zw.Text.Trim(), txt_zc.Text.Trim());//1 是男士 foreach (DataRow dr_dc in dt_tj_tc_dc.Rows) { string aa = dr_dc["zhxm"].ToString().Trim(); string bb = dr_dc["mc"].ToString().Trim(); tjblbiz1.str_Insert_TJ_DWFZ_DT(str_fzbh, str_dwbh, aa); } tjblbiz1.Exec_ArryList(); } }
/// <summary> /// 批量导入按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bt_input_Click(object sender, EventArgs e) { if (!Check_DGV_Select()) { MessageBox.Show("请选择需要导入的人员名单!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (txt_tjdw.Text.Trim() == "") { MessageBox.Show("请选择需要导入单位!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = bt_tjdw; return; } if (object.Equals(null, cmb_fz.SelectedValue)) { MessageBox.Show("请选择分组!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = cmb_fz; return; } if (object.Equals(null, cmb_ywlx.SelectedValue)) { MessageBox.Show("请选择体检业务类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = bt_tjdw; return; } string str_tjrq = dtp_tjrq.Value.ToString("yyyy-MM-dd"); if (Convert.ToDateTime(str_tjrq) > Convert.ToDateTime(Program.sys_jzzcrq)) { MessageBox.Show("系统使用非法,程序将自动关闭,请联系销售人员:!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Program.sfzc = false; main.Form_reg frm_reg = new PEIS.main.Form_reg(); frm_reg.ShowDialog(); } StringBuilder gzmcs = new StringBuilder(); foreach (DataGridViewRow dgr in dgv_excel.Rows) { string str_dwbh = txt_tjdw.Tag.ToString().Trim(); if (str_dwbh.Length > 4) { str_dwbh = str_dwbh.Substring(0, 4); //单位编号 } //string str_bmbh = txt_tjdw.Tag.ToString().Trim(); //if (str_bmbh.Length == 4) str_bmbh = ""; string str_fzbh = cmb_fz.SelectedValue.ToString().Trim();//分组编号 if (Convert.ToBoolean(dgr.Cells["selected"].Value)) { string str_xm = dgr.Cells["xm"].Value.ToString().Trim(); string str_tjbh = ""; string str_tjcs = ""; //只检查姓名重复,暂不检查身份证重复的情况 DataTable dt_tjdjb = tjglbiz.Get_TJ_TJDJB_XM(str_xm, str_dwbh); if (dt_tjdjb.Rows.Count > 0) { Form_tmqr frm = new Form_tmqr(dt_tjdjb); if (frm.ShowDialog() == DialogResult.OK) { string str_retrun = frm.str_return; if (str_retrun == "2")//同一人 { str_tjbh = frm.str_tjbh; str_tjcs = Convert.ToString(Convert.ToInt32(frm.str_tjcs) + 1); } if (str_retrun == "0")//取消 { continue; } } } if (str_tjbh == "") { str_tjbh = xtbiz.GetHmz("tjbh", 1); str_tjcs = "1"; } string str_xb = dgr.Cells["xb"].Value.ToString().Trim(); str_xb = xtbiz.Get_Xtzd_Bzdm("1", str_xb); //性别 string str_csrq = dgr.Cells["csrq"].Value.ToString().Trim(); //出生 //string str_nl = dgr.Cells["nl"].Value.ToString().Trim();//年龄 if (!str_csrq.Contains("-")) { string s1 = str_csrq.Substring(0, 4); string s2 = str_csrq.Substring(4, 2); string s3 = str_csrq.Substring(6, 2); str_csrq = s1 + "-" + s2 + "-" + s3; } //处理出生日期和年龄的一致性 by zhz //if (str_csrq == "") str_csrq = xtbiz.GetServerDate().AddYears(-Convert.ToInt32(str_nl)).ToString(); string str_nl = Convert.ToString(xtbiz.GetServerDate().Year - Convert.ToDateTime(str_csrq).Year); //string str_hyzk = dgr.Cells["hyzk"].Value.ToString().Trim(); //str_hyzk = xtbiz.Get_Xtzd_Bzdm("12", str_hyzk);//婚姻状况 //string str_sykh = dgr.Cells["sykh"].Value.ToString().Trim();//索引 //string str_mz = dgr.Cells["mz"].Value.ToString().Trim(); //str_mz = xtbiz.Get_Xtzd_Bzdm("2", str_mz);//民族 string str_sfzh = dgr.Cells["sfzh"].Value.ToString().Trim();//身份证 //string str_rylb = dgr.Cells["rylb"].Value.ToString().Trim(); //str_rylb = xtbiz.Get_Xtzd_Bzdm("8", str_rylb);//人员类型 //string str_phone = dgr.Cells["phone"].Value.ToString().Trim(); string str_mobile = dgr.Cells["mobile"].Value.ToString().Trim(); //string str_address = dgr.Cells["lxdz"].Value.ToString().Trim(); //string whcd = dgr.Cells["whcd"].Value.ToString().Trim(); string gzmc = dgr.Cells["gz"].Value.ToString().Trim(); string gz = xtbiz.Get_Xtzd_Bzdm("19", gzmc); //获取工种 //whcd = xtbiz.Get_Xtzd_Bzdm("18", whcd);//获取文化程度 string str_whys = dgr.Cells["whys"].Value.ToString().Trim(); //危害因素 str_whys = xtbiz.Get_Xtzd_Bzdm("20", str_whys); //危害因素 //str_rylb = xtbiz.Get_Xtzd_Bzdm("8", str_rylb);//人员类型 //string sszl = dgr.Cells["sszl"].Value.ToString().Trim();//所属证类 //string bzhy = dgr.Cells["bzhy"].Value.ToString().Trim();//办证行业 //string gl = dgr.Cells["zgl"].Value.ToString().Trim();//总工龄 string jhgl = dgr.Cells["jhgl"].Value.ToString().Trim(); //接害工龄 //string str_gh = dgr.Cells["gh"].Value.ToString().Trim();//工号 string dw = dgr.Cells["dw"].Value.ToString().Trim(); //单位 //string str_bmbh = dgr.Cells["bm"].Value.ToString().Trim();//部门 string str_bmbh = txt_tjdw.Tag.ToString().Trim(); if (str_bmbh.Length == 4) { str_bmbh = ""; //不确定部门是多少 } #region 危害因素必须录入参数控制 if (xtbiz.GetXtCsz("pldjwhyslbpd") == "1") //批量登记危害因素是否判断 { if (str_whys == "") { MessageBox.Show("没找到对应的危害因素", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } #endregion #region 人员类别必须录入参数控制 //if (xtbiz.GetXtCsz("pldjrylbpd") == "1") //批量登记人员类别是否判断 //{ // if (str_rylb == "") // { // MessageBox.Show("没找到对应的人员类别", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; // } //} #endregion #region 工种必须录入参数控制 if (xtbiz.GetXtCsz("pldjgzpd") == "1") //批量登记工种是否判断 { if (gz == "") { MessageBox.Show("没找到对应的工种:" + gzmcs.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } #endregion string str_djlsh = ""; string str_djrq = xtbiz.GetServerDate().ToString(); if (xtbiz.GetXtCsz("djlshgz") == "2") //特殊规则YYMMDD+5位 { str_djlsh = xtbiz.GetHmz("djlsh", 1); } else { str_djlsh = tjdjbiz.Get_proc_get_djlsh(str_tjrq, Program.userid); } string str_ywlx = cmb_ywlx.SelectedValue.ToString().Trim(); //string sfbz = dgr.Cells["sfbz"].Value.ToString().Trim(); //if (sfbz == "是") //{ // str_sfbz = "1"; //} //else //{ // str_sfbz = "0"; //} tjdjBiz tjdjbiz1 = new tjdjBiz(); //tjdjbiz1.str_Insert_TJ_TJDJB(str_tjbh, str_tjcs, str_tjrq, str_djrq, str_xm, str_xb, str_csrq, str_nl, str_hyzk, str_sykh, str_mz, str_sfzh, str_rylb, // "", str_mobile, str_address, str_ywlx, str_djlsh, str_dwbh, str_bmbh, str_fzbh, "", "0", Program.userid, "2",whcd,gz,str_whys,gl,str_sfbz,sszl,bzhy,jhgl); tjdjbiz1.str_Insert_TJ_TJDJB(str_tjbh, str_tjcs, str_tjrq, str_djrq, str_xm, str_xb, str_csrq, str_nl, "", "", "", str_sfzh, "", "", str_mobile, "", str_ywlx, str_djlsh, str_dwbh, str_bmbh, str_fzbh, "", "0", Program.userid, "2", "", gz, str_whys, "", str_sfbz, "", "", jhgl); DataTable dt = null; if (str_dwbh == "9999")//个体体检 { dt = ywszbiz.Get_tj_tc_dt(str_fzbh); } else { dt = tjglbiz.Get_tj_dwfz_dt(str_fzbh); } int flag = 0;//如果不需要x线号 值为0,普通x线号值为1,高仟伏x线号值为2 foreach (DataRow dr in dt.Rows) { if (tjglbiz.CheckSex(dr["zhxm"].ToString().Trim(), str_xb) == 0) { MessageBox.Show("所选择的项目【编号:" + dr["zhxm"].ToString().Trim() + "】存在与性别不匹配,或者组合项目明细为空,请检查!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } DataTable dt_tj_zhxm_hd = tjglbiz.Get_tj_zhxm_hd(dr["zhxm"].ToString().Trim()); string str_xh = xtbiz.GetHmz("tjjlbxh", 1);//体检记录本序号 string str_lxbh = dt_tj_zhxm_hd.Rows[0]["tjlx"].ToString().Trim(); string str_tjxmbh = dt_tj_zhxm_hd.Rows[0]["bh"].ToString().Trim(); string str_xmdj = dt_tj_zhxm_hd.Rows[0]["dj"].ToString().Trim(); string str_zxks = dt_tj_zhxm_hd.Rows[0]["tjlx"].ToString().Trim(); string str_xmlx = dt_tj_zhxm_hd.Rows[0]["jcjylx"].ToString().Trim(); string str_sflb = dt_tj_zhxm_hd.Rows[0]["sflb"].ToString().Trim(); tjdjbiz1.str_Insert_tj_tjjlb(str_xh, str_tjbh, str_tjcs, str_lxbh, str_tjrq, str_tjxmbh, str_xmdj, "0", "1", str_sflb, str_zxks, str_xmlx); //生成x线号***************************************************** //获取套餐里是否有x光相关的东西 /////////*******************************************************88888 string str_zhxm = dr["zhxm"].ToString().Trim(); string str_tjmc = dr["mc"].ToString().Trim(); if (tjdjbiz1.IsNeedGfq(str_zhxm)) { flag = 2; } if (flag == 0 && tjdjbiz1.NeedXhh(str_zhxm)) { flag = 1; } } if (flag == 2) { tjdjbiz1.saveXxh(str_tjbh, str_sfzh, true); } if (flag == 1) { tjdjbiz1.saveXxh(str_tjbh, str_sfzh, false); } if (str_ywlx.Trim() == "01") { //tjdjbiz1.str_Insert_TJ_ZYB_RYXX(str_tjbh, str_tjcs, str_xm, str_xb, str_sfzh, str_csrq, txt_tjdw.Text.Trim(), str_mobile, str_gh, "", dtp_tjrq.Value.ToString("yyyy-MM-dd"), str_rylb, //"", "", dtp_tjrq.Value.ToString("yyyy-MM-dd"), "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", str_address, gz, "", "", "", str_mz, str_hyzk, gl, jhgl, str_whys, ""); tjdjbiz1.str_Insert_TJ_ZYB_RYXX(str_tjbh, str_tjcs, str_xm, str_xb, str_sfzh, str_csrq, txt_tjdw.Text.Trim(), str_mobile, "", "", dtp_tjrq.Value.ToString("yyyy-MM-dd"), "", "", "", dtp_tjrq.Value.ToString("yyyy-MM-dd"), "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", gz, "", "", "", "", "", "", jhgl, str_whys, ""); } tjdjbiz1.Exec_ArryList();//登记表执行成功后在执行记录表 } } MessageBox.Show("批量导入成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); ckb_all.Checked = false; ckb_all_CheckedChanged(null, null); }
private void bt_input_Click(object sender, EventArgs e) { if (!Check_DGV_Select()) { MessageBox.Show("请选择需要导入的人员名单!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (txt_tjdw.Text.Trim() == "") { MessageBox.Show("请选择需要导入单位!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = bt_tjdw; return; } if (object.Equals(null, cmb_fz.SelectedValue)) { MessageBox.Show("请选择分组!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = cmb_fz; return; } if (object.Equals(null, cmb_ywlx.SelectedValue)) { MessageBox.Show("请选择体检业务类型!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.ActiveControl = bt_tjdw; return; } string str_tjrq = dtp_tjrq.Value.ToString("yyyy-MM-dd"); foreach (DataGridViewRow dgr in dgv_excel.Rows) { string str_dwbh = txt_tjdw.Tag.ToString().Trim(); if (str_dwbh.Length > 4) { str_dwbh = str_dwbh.Substring(0, 4); //单位编号 } string str_bmbh = txt_tjdw.Tag.ToString().Trim(); if (str_bmbh.Length == 4) { str_bmbh = ""; } string str_fzbh = cmb_fz.SelectedValue.ToString().Trim();//分组编号 if (Convert.ToBoolean(dgr.Cells["selected"].Value)) { string str_xm = dgr.Cells["xm"].Value.ToString().Trim(); string str_tjbh = ""; string str_tjcs = ""; //只检查姓名重复,暂不检查身份证重复的情况 string dwbh = txt_tjdw.Tag.ToString().Trim(); if (str_dwbh.Length > 4) { str_dwbh = str_dwbh.Substring(0, 4); //单位编号 } DataTable dt_tjdjb = tjglbiz.Get_TJ_TJDJB_XM(str_xm, dwbh); if (dt_tjdjb.Rows.Count > 0) { Form_tmqr frm = new Form_tmqr(dt_tjdjb); if (frm.ShowDialog() == DialogResult.OK) { string str_retrun = frm.str_return; if (str_retrun == "2")//同一人 { str_tjbh = frm.str_tjbh; str_tjcs = Convert.ToString(Convert.ToInt32(frm.str_tjcs) + 1); } if (str_retrun == "0")//取消 { continue; } } } if (str_tjbh == "") { str_tjbh = xtbiz.GetHmz("tjbh", 1); str_tjcs = "1"; } string str_xb = dgr.Cells["xb"].Value.ToString().Trim(); str_xb = xtbiz.Get_Xtzd_Bzdm("1", str_xb);//性别 string str_csrq = dgr.Cells["csrq"].Value.ToString().Trim(); string str_nl = dgr.Cells["nl"].Value.ToString().Trim(); try//处理出生日期和年龄的一致性 { if (str_csrq == "") { str_csrq = xtbiz.GetServerDate().AddYears(-Convert.ToInt32(str_nl)).ToString(); } if (str_nl == "") { str_nl = Convert.ToString(xtbiz.GetServerDate().Year - Convert.ToDateTime(str_csrq).Year); } } catch { } string str_hyzk = dgr.Cells["hyzk"].Value.ToString().Trim(); str_hyzk = xtbiz.Get_Xtzd_Bzdm("12", str_hyzk);//婚姻状况 string str_sykh = dgr.Cells["sykh"].Value == null ? "" : dgr.Cells["sykh"].Value.ToString().Trim(); string str_mz = dgr.Cells["mz"].Value.ToString().Trim(); str_mz = xtbiz.Get_Xtzd_Bzdm("2", str_mz);//民族 string str_sfzh = dgr.Cells["sfzh"].Value.ToString().Trim(); string str_rylb = dgr.Cells["rylb"].Value.ToString().Trim(); str_rylb = xtbiz.Get_Xtzd_Bzdm("8", str_rylb);//人员类型 string str_phone = dgr.Cells["phone"].Value.ToString().Trim(); string str_mobile = dgr.Cells["mobile"].Value.ToString().Trim(); string str_address = dgr.Cells["lxdz"].Value.ToString().Trim(); string str_djrq = xtbiz.GetServerDate().ToString(); string str_djlsh = ""; if (xtbiz.GetXtCsz("djlshgz") == "2") //特殊规则YYMMDD+5位 { str_djlsh = xtbiz.GetHmz("djlsh", 1); } else { str_djlsh = tjdjbiz.Get_proc_get_djlsh(str_tjrq, Program.userid); } string str_tjlb = cmb_ywlx.SelectedValue.ToString().Trim(); string gz = dgr.Cells["gz"].Value == null ? "" : dgr.Cells["gz"].Value.ToString().Trim(); string gzbh = xtbiz.Get_Xtzd_Bzdm("19", gz); if (str_rylb == "") { MessageBox.Show("没找到对应的人员类别", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //if (gz == "") //{ // MessageBox.Show("没找到对应的工种", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} tjdjBiz tjdjbiz1 = new tjdjBiz(); tjdjbiz1.str_Insert_TJ_TJDJB(str_tjbh, str_tjcs, str_tjrq, str_djrq, str_xm, str_xb, str_csrq, str_nl, str_hyzk, str_sykh, str_mz, str_sfzh, str_rylb, str_phone, str_mobile, str_address, str_tjlb, str_djlsh, str_dwbh, str_bmbh, str_fzbh, "", "0", Program.userid, "2", "", gz, "", "", str_sfbz, "", "", ""); DataTable dt = null; if (str_dwbh == "9999")//个体体检 { dt = ywszbiz.Get_tj_tc_dt(str_fzbh); } else { dt = tjglbiz.Get_tj_dwfz_dt(str_fzbh); } int flag = 0; foreach (DataRow dr in dt.Rows) { if (tjglbiz.CheckSex(dr["zhxm"].ToString().Trim(), str_xb) == 0) { MessageBox.Show("所选择的项目【编号:" + dr["zhxm"].ToString().Trim() + "】存在与性别不匹配,或者组合项目明细为空,请检查!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } DataTable dt_tj_zhxm_hd = tjglbiz.Get_tj_zhxm_hd(dr["zhxm"].ToString().Trim()); string str_xh = xtbiz.GetHmz("tjjlbxh", 1);//体检记录本序号 string str_lxbh = dt_tj_zhxm_hd.Rows[0]["tjlx"].ToString().Trim(); string str_tjxmbh = dt_tj_zhxm_hd.Rows[0]["bh"].ToString().Trim(); string str_xmdj = dt_tj_zhxm_hd.Rows[0]["dj"].ToString().Trim(); string str_zxks = dt_tj_zhxm_hd.Rows[0]["tjlx"].ToString().Trim(); string str_xmlx = dt_tj_zhxm_hd.Rows[0]["jcjylx"].ToString().Trim(); string str_sflb = dt_tj_zhxm_hd.Rows[0]["sflb"].ToString().Trim(); tjdjbiz1.str_Insert_tj_tjjlb(str_xh, str_tjbh, str_tjcs, str_lxbh, str_tjrq, str_tjxmbh, str_xmdj, "0", "1", str_sflb, str_zxks, str_xmlx); string str_zhxm = dr["zhxm"].ToString().Trim(); string str_tjmc = dr["mc"].ToString().Trim(); if (tjdjbiz1.IsNeedGfq(str_zhxm)) { flag = 2; } if (flag == 0 && tjdjbiz1.NeedXhh(str_zhxm)) { flag = 1; } } if (flag == 2) { tjdjbiz1.saveXxh(str_tjbh, str_sfzh, true); } if (flag == 1) { tjdjbiz1.saveXxh(str_tjbh, str_sfzh, false); } tjdjbiz1.Exec_ArryList();//登记表执行成功后在执行记录表 } } MessageBox.Show("批量导入成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); ckb_all.Checked = false; ckb_all_CheckedChanged(null, null); }