private void dataGridView1_Click(object sender, EventArgs e) { try { if (dataGridView1.Rows.Count > 0) { Guid fpid = new Guid(Convertor.IsNull(this.dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells["fpid"].Value.ToString(), Guid.Empty.ToString())); DataTable dt = MZYF.SelectMzcfk(menuTag.Function_Name, InstanceForm.BCurrentDept.DeptId, Guid.Empty, "", "", 0, "", "", 0, 0, "", "", "", 0, "", "", 0, 0, "", "", "", 0, 0, fpid, Guid.Empty, 0, InstanceForm.BDatabase); this.dataGridView2.DataSource = dt; //隐藏不需要显示的数据 this.dataGridView2.Columns[0].Visible = false; this.dataGridView2.Columns[1].Visible = false; this.dataGridView2.Columns[2].Visible = false; this.dataGridView2.Columns[4].Visible = false; this.dataGridView2.Columns[5].Visible = false; this.dataGridView2.Columns[8].Visible = false; this.dataGridView2.Columns[14].Visible = false; this.dataGridView2.Columns[15].Visible = false; this.dataGridView2.Columns[16].Visible = false; for (int i = 40; i <= 65; i++) { this.dataGridView2.Columns[i].Visible = false; } } } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); } }
private void Frmpyck_Load(object sender, EventArgs e) { DataTable tb = MZYF.Get_fyck("", "", InstanceForm.BDatabase); tb.TableName = "tab"; cmbpyck.DataSource = tb; cmbpyck.ValueMember = "CODE"; cmbpyck.DisplayMember = "NAME"; cmbpyck.Text = ""; }
private void InitFyck() { DataTable dt = MZYF.Get_fyck("", "", InstanceForm.BDatabase); dt.TableName = "tab"; comboBox1.DataSource = dt; comboBox1.ValueMember = "CODE"; comboBox1.DisplayMember = "NAME"; //comboBox1.Text = ""; }
private void butok_Click(object sender, EventArgs e) { DataTable tb = MZYF.Get_fyck("", Convertor.IsNull(cmbpyck.SelectedValue, ""), InstanceForm.BDatabase); string add = TrasenClasses.GeneralClasses.PubStaticFun.GetMacAddress().Trim(); if (tb.Rows.Count != 0 && radioButton2.Checked == false) { if (tb.Rows[0]["bzybz"].ToString() == "1") { if (add != tb.Rows[0]["wkdz"].ToString().Trim() && tb.Rows[0]["wkdz"].ToString().Trim() != "") { MessageBox.Show("这个窗口正在使用,您不能选择它"); return; } } if (tb.Rows[0]["bscbz"].ToString() == "1") { MessageBox.Show("该窗口已停用,您不能选择它"); return; } } if (radioButton1.Checked == true && Convertor.IsNull(cmbpyck.SelectedValue, "") == "") { MessageBox.Show("请选择当前发药窗口", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string fyckdm = ""; string fyckmc = ""; if (radioButton1.Checked == true) { fyckdm = cmbpyck.SelectedValue.ToString(); fyckmc = cmbpyck.Text.Trim(); MZYF.Update_fyck(add, fyckdm, 1, InstanceForm.BDatabase); } Frmcffy f = new Frmcffy(_menuTag, _chineseName, _mdiParent); f._Fyckh = Convertor.IsNull(fyckdm, ""); f._Fyckmc = Convertor.IsNull(fyckmc, ""); this.Close(); if (_mdiParent != null) { f.MdiParent = _mdiParent; } f.Show(); }
private void butcx_Click(object sender, EventArgs e) { try { string _cfrq1 = chkcfrq.Checked == true?dtprq1.Value.ToShortDateString() + " 00:00:00" : ""; string _cfrq2 = chkcfrq.Checked == true?dtprq2.Value.ToShortDateString() + " 23:59:59" : ""; DataTable tb = MZYF.Select_TY_Cf(InstanceForm.BCurrentDept.DeptId, _brxxid, _cfrq1, _cfrq2, _mzh, _dnlsh, _fph, Guid.Empty, InstanceForm.BDatabase); /* * update code by pengy 7-31 */ gridTable = tb; DataTable tbx = (DataTable)dataGridView1.DataSource; tbx.Rows.Clear(); int x = 0; for (int i = 0; i <= tb.Rows.Count - 1; i++) { DataRow row = tbx.NewRow(); x = x + 1; row["ÐòºÅ"] = x.ToString(); row["Ñ¡Ôñ"] = (_fph != "0" || _dnlsh > 0) == true ? (short)1 : (short)0; row["ÃÅÕïºÅ"] = tb.Rows[i]["²¡ÀúºÅ"]; row["·¢Æ±ºÅ"] = tb.Rows[i]["·¢Æ±ºÅ"]; row["Á÷Ë®ºÅ"] = tb.Rows[i]["jssjh"]; row["ÐÕÃû"] = tb.Rows[i]["ÐÕÃû"]; row["½ð¶î"] = tb.Rows[i]["½ð¶î"]; row["·¢Ò©¿ÆÊÒ"] = tb.Rows[i]["·¢Ò©¿ÆÊÒ"]; row["·¢Ò©ÈÕÆÚ"] = tb.Rows[i]["·¢Ò©ÈÕÆÚ"]; row["id"] = tb.Rows[i]["id"]; tbx.Rows.Add(row); } dataGridView1.DataSource = tbx; } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void DataPrint(DataRow row) { if (row == null) { return; } //int bk = this.rdodq.Checked == true ? 0 : 1; int fybz = cbyfyjs.Checked == false ? 0 : 1; string sfrq1 = ""; string sfrq2 = ""; string fyrq1 = ""; string fyrq2 = ""; string brxxid = row["brxxid"].ToString(); string fph = row["发票号"].ToString(); sfrq1 = dateTimePicker1.Value.ToShortDateString(); sfrq2 = dateTimePicker1.Value.ToShortDateString(); fyrq1 = ""; fyrq2 = ""; //this.cfmxTable = MZYF.SelectMzcfk("Fun_ts_yf_mzfy", InstanceForm.BCurrentDept.DeptId, Guid.Empty, row["姓名"].ToString(), //fph, 0, fyrq1, fyrq2, 0, fybz, "", sfrq1, sfrq2, 0, "", "", 0, 0, "", "", "", 0, 0, Guid.Empty, new Guid(brxxid), 0, InstanceForm.BDatabase); //if (cfmxTable == null || cfmxTable.Rows.Count == 0) // return; //DataTable datalist = this.cfmxTable.Copy(); DataTable retTable = MZYF.SelectMzcfk("Fun_ts_yf_mzfy", InstanceForm.BCurrentDept.DeptId, Guid.Empty, row["姓名"].ToString(), fph, 0, fyrq1, fyrq2, 0, fybz, "", sfrq1, sfrq2, 0, "", "", 0, 0, "", "", "", 0, 0, Guid.Empty, new Guid(brxxid), 0, InstanceForm.BDatabase); this.cfmxTable = retTable.Clone(); DataRow[] retRows = retTable.Select(string.Format(" cfxh = '{0}'", row["处方ID"])); if (retRows != null && retRows.Length > 0) { foreach (DataRow tmp in retRows) { this.cfmxTable.Rows.Add(tmp.ItemArray); } } if (this.cfmxTable.Rows.Count == 0) { MessageBox.Show("未找到处方明细", "提示"); return; } DataTable datalist = this.cfmxTable.Copy(); #region //this.AddPresc(dataSouce); //YpConfig ypconfig = new YpConfig(InstanceForm.BCurrentDept.DeptId, InstanceForm.BDatabase); ////分组处方 //DataRow[] selrow; //if (ypconfig.门诊发药后才能打印处方 == true) // selrow = tb.Select("( 发药='√') and ypid<>''"); //else // selrow = tb.Select("(发药='◆' or 发药='√') and ypid<>''"); //DataTable tbsel = tb.Clone(); //for (int w = 0; w <= selrow.Length - 1; w++) // tbsel.ImportRow(selrow[w]); #endregion DataTable tbcf; if (cbyfyjs.Checked == false) //如果为未发药就取总金额,已发药则取求和值 { string[] GroupbyField = { "cfxh", "发票号", "总金额", "诊断", "门诊号" }; string[] ComputeField = { }; string[] CField = { }; tbcf = FunBase.GroupbyDataTable(datalist, GroupbyField, ComputeField, CField, null); } else { string[] GroupbyField = { "cfxh", "发票号", "诊断", "门诊号" }; string[] ComputeField = { "金额" }; string[] CField = { "sum" }; tbcf = FunBase.GroupbyDataTable(datalist, GroupbyField, ComputeField, CField, null); } //SystemCfg cfg8035 = new SystemCfg(8035); //if (cfg8035.Config == "1") //{ //处方 for (int i = 0; i <= tbcf.Rows.Count - 1; i++) { TrasenFrame.Forms.UcReportView urv = new UcReportView(); this.PrintCf(tbcf.Rows[i], 1, urv); } //} //else //{ // //处方 // for (int i = 0; i <= tbcf.Rows.Count - 1; i++) // { // this.PrintCf(tbcf.Rows[i], 1); // } //} }
private void Dgv_Ysf_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (Dgv_Ysf.CurrentCell == null) { return; } if (e.RowIndex <= -1) { return; } if (Dgv_Ysf.Columns[Dgv_Ysf.CurrentCell.ColumnIndex].Name == "申请退费") { /*如果项目的数量大于1 则show出窗体选择需退数量,否则直接向退费申请表插入记录*/ DataTable dt = (DataTable)Dgv_Ysf.DataSource; int rowindex = Dgv_Ysf.CurrentCell.RowIndex; int xmly = Convert.ToInt32(dt.Rows[rowindex]["项目来源"]); MZ_TF_Record tf_apply = new MZ_TF_Record(); tf_apply.TFSQID = Guid.Empty; tf_apply.CFID = new Guid(dt.Rows[rowindex]["CFID"].ToString()); tf_apply.CFMXID = new Guid(Convertor.IsNull(dt.Rows[rowindex]["cfmxid"].ToString(), Guid.Empty.ToString())); tf_apply.XMMC = Convertor.IsNull(dt.Rows[rowindex]["项目名称"], ""); tf_apply.XMID = Convert.ToInt32(dt.Rows[rowindex]["项目编号"]); tf_apply.TCID = Convert.ToInt32(Convertor.IsNull(dt.Rows[rowindex]["套餐编号"], "0")); tf_apply.XMGG = Convertor.IsNull(dt.Rows[rowindex]["规格"], ""); tf_apply.XMDW = Convertor.IsNull(dt.Rows[rowindex]["单位"], ""); tf_apply.YDJ = Convert.ToDecimal(dt.Rows[rowindex]["单价"]); tf_apply.YSL = Convert.ToDecimal(dt.Rows[rowindex]["数量"]); tf_apply.YJE = Convert.ToDecimal(dt.Rows[rowindex]["金额"]); tf_apply.KDKS = Convert.ToInt32(Convertor.IsNull(dt.Rows[rowindex]["科室编号"], "0")); tf_apply.TFSQKS = InstanceForm.BCurrentDept.DeptId; tf_apply.DJY = InstanceForm.BCurrentUser.EmployeeId; tf_apply.KH = txtkh.Text.Trim(); tf_apply.GHXXID = ghxxid; tf_apply.FPID = new Guid(dt.Rows[rowindex]["FPID"].ToString()); tf_apply.YZID = Convert.ToInt32(Convertor.IsNull(dt.Rows[rowindex]["yzid"], "0")); string sffy = Convert.ToString(dt.Rows[rowindex]["是否发药"]); if (Convert.ToString(dt.Rows[rowindex]["是否发药"]) == "1" || Convert.ToString(dt.Rows[rowindex]["是否确认"]) == "1") { tf_apply.SHBZ = 0; tf_apply.SHY = 0; tf_apply.SHSJ = System.DateTime.Now.ToString(); } else { tf_apply.SHBZ = 1; tf_apply.SHY = InstanceForm.BCurrentUser.EmployeeId; tf_apply.SHSJ = System.DateTime.Now.ToString(); } tf_apply.TSL = Convert.ToDecimal(dt.Rows[rowindex]["可退数量"]); #region MODIFY BY CC 可以部分退费 /*在进行退费申请前 需要验证当前费用是否已在退费申请表有了记录*/ if (!MZ_TF_Record.CheckIsYFy(tf_apply, dt.Rows[rowindex], InstanceForm.BDatabase)) { MessageBox.Show("当前记录已经进行了申请退费,可在待退费记录中查询!", "提示"); return; } if (Convert.ToInt32(dt.Rows[rowindex]["可退数量"]) == 1) { tf_apply.TSL = Convert.ToDecimal(dt.Rows[rowindex]["可退数量"]); /*在进行退费申请前 需要验证当前费用是否已在退费申请表有了记录*/ if (!MZ_TF_Record.CheckIsYFy(tf_apply, dt.Rows[rowindex], InstanceForm.BDatabase)) { MessageBox.Show("当前记录已经进行了申请退费,可在待退费记录中查询!", "提示"); return; } } else { /*弹出选择框 进行输入数量*/ decimal _ysl = Convert.ToDecimal(dt.Rows[rowindex]["可退数量"]); DlgInputBox Dlg_Add = new DlgInputBox("0", "退费数量", "退费数量"); Dlg_Add.ShowDialog(); // if(Dlg_Add.DialogResult!= DialogResult.OK)return; decimal tfs = 0; if (!decimal.TryParse(DlgInputBox.DlgValue, out tfs)) { MessageBox.Show("退费数必须为数值类型!", "提示"); return; } if (tfs != _ysl && xmly != 1)//如果退费数不等于原数量同时不为药品 则必须退费数为整数 { int _value = 0; if (!int.TryParse(DlgInputBox.DlgValue, out _value)) { MessageBox.Show("退费数必须为整数类型!", "提示"); return; } } if (tfs < 0)// Add by zp 2013-12-27 { MessageBox.Show("退费数必须大于0!", "提示"); return; } if (tfs == 0) { //MessageBox.Show("退费数不能为0!", "提示"); return; } if (tfs > _ysl) { MessageBox.Show("退费数不能大于收费原数量!", "提示"); return; } tf_apply.TSL = tfs; } #endregion try { bool isQr = false; //if (dt.Rows[rowindex]["执行科室编号"].ToString() == InstanceForm.BCurrentDept.DeptId.ToString()) //{ // isQr = true; //} // bool isQr = Fun.IsQr(new Guid(Convertor.IsNull(dt.Rows[rowindex]["cfmxid"].ToString(), Guid.Empty.ToString())),Convert.ToInt32(Convertor.IsNull(dt.Rows[rowindex]["套餐编号"], "0")), InstanceForm.BDatabase); MZ_TF_Record.Save(ref tf_apply, isQr, InstanceForm.BDatabase); #region 注释代码 MODIFY BY CC if (xmly == 1 && sffy == "1") //如果是退药 则需要向yf_fymx插入记录 { long fph = Convert.ToInt64(Convertor.IsNull(dt.Rows[rowindex]["发票号"], "0")); string bm = Convertor.IsNull(dt.Rows[rowindex]["编码"], ""); string pm = Convertor.IsNull(dt.Rows[rowindex]["项目名称"], ""); string spm = Convertor.IsNull(dt.Rows[rowindex]["商品名"], ""); string cj = Convertor.IsNull(dt.Rows[rowindex]["厂家"], ""); decimal ydwbl = Convert.ToDecimal(Convertor.IsNull(dt.Rows[rowindex]["YDWBL"], "1")); decimal tyl = tf_apply.YSL * -1; int ts = Convert.ToInt32(dt.Rows[rowindex]["天数"]); decimal pfj = Convert.ToDecimal(Convertor.IsNull(dt.Rows[rowindex]["批发价"], "0")); decimal pfje = Convert.ToDecimal(Convertor.IsNull(dt.Rows[rowindex]["批发金额"], "0")); decimal lsj = Convert.ToDecimal(Convertor.IsNull(dt.Rows[rowindex]["单价"], "0")); long yfid = Convert.ToInt32(dt.Rows[rowindex]["执行科室编号"]); string ps = Convertor.IsNull(dt.Rows[rowindex]["皮试"], ""); string yf = Convertor.IsNull(dt.Rows[rowindex]["用法"], ""); DataTable dt_fyxx = MZ_TF_Record.GetFymxInfo(tf_apply.CFID, tf_apply.CFMXID, InstanceForm.BDatabase); Guid _fymxid = Guid.Empty; string pc = ""; Guid NewFyid = Guid.Empty; int err_code = 0; string err_text = ""; if (dt_fyxx.Rows.Count > 0) { pc = MZYF.SeekFymxPh(_fymxid, InstanceForm.BCurrentDept.DeptId, InstanceForm.BDatabase); YpClass.MZYF.SaveFymx(Guid.Empty, fph, tf_apply.CFID, tf_apply.XMID, bm, pm, spm, tf_apply.XMGG, cj, tf_apply.XMDW, ydwbl, tyl, ts, pfj, pfj * tyl * ts, lsj, Math.Round(lsj * tyl * ts, 2), 0, 0, yfid, Guid.Empty, "", Guid.Empty, tf_apply.CFMXID, ps, yf, "", "", "", "", "", 0, 0, 0, "sp_yf_fymx", out NewFyid, out err_code, out err_text, InstanceForm.BDatabase); } } #endregion KeyPressEventArgs ee = new KeyPressEventArgs((char)Keys.Enter); object o = this.txtmzh; txtkh_KeyPress(o, ee); } catch (Exception ea) { InstanceForm.BDatabase.RollbackTransaction(); throw ea; } } } catch (Exception ea) { MessageBox.Show("出现异常!原因:" + ea.Message, "提示"); } }
public bool Print(string brkh, int Dept_Id, out string reslutMsg) { int fybz = 0; string sfrq1 = ""; string sfrq2 = ""; string fyrq1 = ""; string fyrq2 = ""; string fph = ""; sfrq1 = DateTime.Now.ToShortDateString(); sfrq2 = DateTime.Now.ToShortDateString(); fyrq1 = ""; fyrq2 = ""; string sql = string.Format("select distinct BRXXID from YY_KDJB where KH= '{0}'", brkh); DataTable brxxInfo = DB.GetDataTable(sql); if (brxxInfo == null || brxxInfo.Rows.Count == 0) { reslutMsg = "未找到病人信息"; return(false); } brxxid = brxxInfo.Rows[0][0].ToString(); sql = string.Format("select NAME from JC_DEPT_PROPERTY where DEPT_ID = {0}", Dept_Id); DataTable deptInfo = DB.GetDataTable(sql); if (deptInfo == null || deptInfo.Rows.Count == 0) { reslutMsg = "未找到科室"; return(false); } deptName = deptInfo.Rows[0][0].ToString(); //this.cfmxTable = MZYF.SelectMzcfk("Fun_ts_yf_mzfy", Dept_Id, Guid.Empty, "", fph, 0, fyrq1, fyrq2, 0, fybz, "", sfrq1, sfrq2, 0, "", "", 0, 0, "", "", "", 0, 0, Guid.Empty, new Guid(brxxid), 0, DB); this.cfmxTable = MZYF.PrintMzcfk("Fun_ts_yf_mzfy", Dept_Id, Guid.Empty, "", fph, 0, fyrq1, fyrq2, 0, fybz, "", sfrq1, sfrq2, 0, "", "", 0, 0, "", "", "", 0, 0, Guid.Empty, new Guid(brxxid), 0, DB); DataRow[] retRows = cfmxTable.Select(" byscf = 1"); //只打印电子处方 2014-12-16 DataTable datalist = this.cfmxTable.Clone(); if (retRows != null && retRows.Length > 0) { foreach (DataRow tmpRow in retRows) { datalist.ImportRow(tmpRow); } } else { reslutMsg = "未找到电子处方明细"; return(false); } #region //this.AddPresc(dataSouce); //YpConfig ypconfig = new YpConfig(InstanceForm.BCurrentDept.DeptId, InstanceForm.BDatabase); ////分组处方 //DataRow[] selrow; //if (ypconfig.门诊发药后才能打印处方 == true) // selrow = tb.Select("( 发药='√') and ypid<>''"); //else // selrow = tb.Select("(发药='◆' or 发药='√') and ypid<>''"); //DataTable tbsel = tb.Clone(); //for (int w = 0; w <= selrow.Length - 1; w++) // tbsel.ImportRow(selrow[w]); #endregion //if (cbyfyjs.Checked == false) //如果为未发药就取总金额,已发药则取求和值 //{ string[] GroupbyField = { "cfxh", "发票号", "总金额", "诊断", "门诊号" }; string[] ComputeField = { }; string[] CField = { }; DataTable tbcf = FunBase.GroupbyDataTable(datalist, GroupbyField, ComputeField, CField, null); //} //else //{ // string[] GroupbyField ={ "cfxh", "发票号", "诊断", "门诊号" }; // string[] ComputeField ={ "金额" }; // string[] CField ={ "sum" }; // tbcf = FunBase.GroupbyDataTable(datalist, GroupbyField, ComputeField, CField, null); //} //SystemCfg cfg8035 = new SystemCfg(8035); //if (cfg8035.Config == "1") //{ //处方 int number = 0; for (int i = 0; i < tbcf.Rows.Count; i++) { UcReportView urv = new UcReportView(); urv.db = PrescriptionPrint.DB; if (this.PrintCf(tbcf.Rows[i], 1, urv) == false) { number++; } } reslutMsg = ""; if (number == tbcf.Rows.Count) { return(false); } else { return(true); } //} //else //{ // //处方 // for (int i = 0; i <= tbcf.Rows.Count - 1; i++) // { // this.PrintCf(tbcf.Rows[i], 1); // } //} }
/// <summary> /// 根据函数名称实例化窗体 /// </summary> public void InstanceWorkForm() { if (_functionName == "") { throw new Exception("引出函数名不能为空!"); } //Frmmzfy Frmmzfy = null; //★需要调用的窗口类 switch (_functionName) { case "Fun_ts_yf_mzfy": case "Fun_ts_yf_mzfy_ZCY": case "Fun_ts_yf_mzfy_YFFY": case "Fun_ts_yf_mzfy_eyf": // Frmmzfy=new Frmmzfy(_menuTag,_chineseName,_mdiParent); // Frmmzfy.MdiParent=_mdiParent; // Frmmzfy.Show(); //Frmcffy Frmcffy = new Frmcffy(_menuTag, _chineseName, _mdiParent); //Frmcffy.MdiParent = _mdiParent; //Frmcffy.Show(); YpConfig s = new YpConfig(TrasenFrame.Forms.FrmMdiMain.CurrentDept.DeptId, InstanceForm.BDatabase); string add = TrasenClasses.GeneralClasses.PubStaticFun.GetMacAddress(); DataTable tb = MZYF.Get_fyck(add, "", InstanceForm.BDatabase); if (tb.Rows.Count == 0) { if (s.配药模式 == true) { Frmpyck f = new Frmpyck(_menuTag, _chineseName, _mdiParent); f.ShowDialog(); return; } } if (tb.Rows.Count > 0) { if (tb.Rows[0]["bscbz"].ToString() == "1") { MessageBox.Show("该窗口已被停用,如需使用请重新启用它!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); if (s.配药模式 == true) { Frmpyck f = new Frmpyck(_menuTag, _chineseName, _mdiParent); f.ShowDialog(); return; } } } string fyckh = ""; string fyckmc = ""; if (tb.Rows.Count != 0) { fyckh = tb.Rows[0]["CODE"].ToString().Trim(); } if (tb.Rows.Count != 0) { fyckmc = tb.Rows[0]["name"].ToString().Trim(); } Frmcffy Frmcffy = new Frmcffy(_menuTag, _chineseName, _mdiParent); Frmcffy._Fyckh = fyckh.Trim(); Frmcffy._Fyckmc = fyckmc; MZYF.Update_fyck(add, Frmcffy._Fyckh, 1, InstanceForm.BDatabase); if (_mdiParent != null) { Frmcffy.MdiParent = _mdiParent; } Frmcffy.Show(); break; case "Fun_ts_yf_SetFyckUse": FrmSetFyckUse frm = new FrmSetFyckUse(_menuTag, _chineseName, _mdiParent); if (_mdiParent != null) { frm.MdiParent = _mdiParent; } frm.Show(); break; default: throw new Exception("引出函数名错误!"); } }