/// <summary> /// 调用接口前需初始化参数; /// 从数据库或配置文件中加载配置 /// </summary> /// <returns></returns> private static bool InitConfig() { try { loadalready(); IsOtherLabel = dbHelp.GetPivasAllSet("第三方瓶签");//获取第三方瓶签的设置 if (IsOtherLabel == "1") { LabelLength = int.Parse(dbHelp.GetPivasAllSetValue2("第三方瓶签")); //获取瓶签长度 LabelBS = dbHelp.GetPivasAllSetValue3("第三方瓶签"); //获取瓶签标识 InternalLogger.Log.Debug("LabelLength" + LabelLength.ToString() + "LabelBS" + LabelBS.ToString()); } //读取计费配置值并获取接口对象 IsCharge = dbHelp.IniReadValuePivas("Charge", "PZ") == "1"; #region 测试 charge = ChargeFactory.GetCharge(HOSPITAL_TYPE); #endregion return(true); } catch (Exception ex) { InternalLogger.Log.Error("初始化发生错误,请检查配置;" + ex.Message); } return(false); }
public ToHIS(List <string> p, string userID) { this.p = p; this.userID = userID; int.TryParse(dbHelp.GetPivasAllSet("打印-打印计费-弹窗设置"), out ind); InitializeComponent(); }
private void BatchUpdate_Load(object sender, EventArgs e) { if (GetPivasLimit.Instance.Limit(UserID, "PrintBatchUpdate")) { XiuGai = db.GetPivasAllSet("批次-修改-打印画面"); if (XiuGai == "1") { Fs = db.GetPivasAllSetValue2("批次-修改-打印画面"); Dy = db.GetPivasAllSetValue3("批次-修改-打印画面"); } else { Fs = "0"; Dy = "0"; } DataSet Ds = db.GetPIVAsDB("select IVStatus from IVRecord where labelno = '" + LabelNO.Trim() + "' "); if (Ds != null && Ds.Tables[0].Rows.Count > 0) { IVstatus = int.Parse(Ds.Tables[0].Rows[0]["IVStatus"].ToString()); } else { MessageBox.Show(" 瓶签号错误!!! "); this.Dispose(); } if (XiuGai == "0") { MessageBox.Show(" 打印画面瓶签不能修改批次,若要修改需要修改配置。(批次-修改-打印画面:value1)"); this.Dispose(); } else if (Fs == "0" && XiuGai == "1") { MessageBox.Show(" < 已发送 > 瓶签不能修改,若要修改需要修改配置。(批次-修改-打印画面:value2)"); this.Dispose(); } else if (IVstatus >= 3 && Dy == "0" && XiuGai == "1") { MessageBox.Show(" < 已打印 > 瓶签不能修改,若要修改需要修改配置。(批次-修改-打印画面:value3)"); this.Dispose(); } else { label1.Text = LabelNO; addPici(); patientInfo(); newdgv1(); AddReason(); //listBox1.Visible = false; textBox5.Visible = false; } } else { this.Dispose(); } }
private void PIVASMate_Load(object sender, EventArgs e) { try { this.ControlBox = false; this.Text = this.Text + " (" + EmpName + ")"; this.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); this.WindowState = FormWindowState.Maximized; NowDate.Text = "PIVAS MATE 3.0 " + DateTime.Now.ToString(); FormPath(DEmployeeID); labelLoginer.Text = EmpName + "(" + EmpCode + ")"; //*****************张建双2014-07-16**********************// try { IniRemTime = Convert.ToInt32(dbHelp.IniReadValuePivas("Remind", "RemindTime")) * 60; keeptime = Convert.ToInt32(dbHelp.IniReadValuePivas("Remind", "KeepTime")); remindtime = IniRemTime; } catch { IniRemTime = 180; remindtime = IniRemTime; keeptime = 5; dbHelp.IniWriteValuePivas("Remind", "RemindTime", "3"); dbHelp.IniWriteValuePivas("Remind", "KeepTime", "5"); } //判断气泡消息框是否可用 if (dbHelp.GetPivasAllSet("主画面_气泡消息框") == "0") { QiPao = true;//执行不可用 } else { QiPao = false; } //判断气泡消息框是否可用 if (dbHelp.GetPivasAllSetValue2("主画面_气泡消息框") == "0") { QiPaoShuangJi = true;//执行不可用 } else { QiPaoShuangJi = false; } ShanShuo(); } catch (Exception ex) { ShowMsgHelper.ShowError("主窗体加载出错:" + ex.Message); } }
private void ShenFangCL_Load(object sender, EventArgs e) { label2.Text = DateTime.Now.ToString(); tag = 60; timer1.Enabled = true; if (DB.GetPivasAllSet("护士站-系统审方-强制执行") == "0") { comboBox1.Items.RemoveAt(5); } if (DB.GetPivasAllSet("护士站-系统审方处理") == "0") { button2.Visible = false; } else { button2.Visible = true; } LoadPrescription(WardCode, "2"); }
//private string currentRowLabelNo = ""; private void QianShou_Load(object sender, EventArgs e) { //同步签收表 db.SetPIVAsDB("exec bl_synSignForm 0"); labelType = db.GetPivasAllSet("第三方瓶签"); time = int.Parse(label12.Text); LoadBatch(); LoadPrescription(); tLabelCount(); }
/// <summary> /// 获取药品算入液体总量的dosage限制 /// </summary> private void GetDosageLimit() { try { DosageLimit = Convert.ToInt32(db.GetPivasAllSet("批次-病人明细模式-液体总量计算")); } catch (Exception ex) { DosageLimit = 50; MessageBox.Show(ex.Message + "请设置 批次-病人明细模式-液体总量计算"); } }
////插入LongOrder表 //private void button_SC_Click(object sender, EventArgs e) //{ // SetTimeNO(); // string InsertSql = " insert into LongOrder(WardCode,OrderDate,DCode) values ('" + Txt_ward.Tag + "', GETDATE(),'" + EmployeeID + "')"; // int a = db.SetPIVAsDB(InsertSql); // IsEnble(); //} private void NurseWorkStation_Load(object sender, EventArgs e) { try { if (!JugeRight()) { Application.Exit(); } //label7_Click(null, null); IsEnble(); } catch (Exception ex) { MessageBox.Show(ex.Message); } try { IniRemTime = Convert.ToInt32(dbHelp.IniReadValuePivas("Remind", "RemindTime")) * 60; keeptime = Convert.ToInt32(dbHelp.IniReadValuePivas("Remind", "KeepTime")); remindtime = IniRemTime; } catch (Exception ex) { IniRemTime = 180; remindtime = IniRemTime; keeptime = 5; dbHelp.IniWriteValuePivas("Remind", "RemindTime", "3"); dbHelp.IniWriteValuePivas("Remind", "KeepTime", "5"); } if (dbHelp.GetPivasAllSet("护士站_气泡消息框") == "0") { QiPao = false; } else { QiPao = true; } if (dbHelp.GetPivasAllSetValue2("护士站-按钮一") == "1") { btn1.Visible = true; btn1.Text = dbHelp.GetPivasAllSet("护士站-按钮一"); Match m = Regex.Match(dbHelp.GetPivasAllSetValue3("护士站-按钮一"), "^([0-9]{0,3},){2}[0-9]{0,3}$"); if (m.Success) { string[] a = dbHelp.GetPivasAllSetValue3("护士站-按钮一").Split(','); btn1.ForeColor = Color.FromArgb(Convert.ToInt32(a[0]), Convert.ToInt32(a[1]), Convert.ToInt32(a[2])); } } if (dbHelp.GetPivasAllSetValue2("护士站-按钮二") == "1") { btn2.Visible = true; btn2.Text = dbHelp.GetPivasAllSet("护士站-按钮二"); Match m = Regex.Match(dbHelp.GetPivasAllSetValue3("护士站-按钮二"), "^([0-9]{0,3},){2}[0-9]{0,3}$"); if (m.Success) { string[] a = dbHelp.GetPivasAllSetValue3("护士站-按钮二").Split(','); btn2.ForeColor = Color.FromArgb(Convert.ToInt32(a[0]), Convert.ToInt32(a[1]), Convert.ToInt32(a[2])); } } if (dbHelp.GetPivasAllSetValue2("护士站-按钮三") == "1") { btn3.Visible = true; btn3.Text = dbHelp.GetPivasAllSet("护士站-按钮三"); Match m = Regex.Match(dbHelp.GetPivasAllSetValue3("护士站-按钮三"), "^([0-9]{0,3},){2}[0-9]{0,3}$"); if (m.Success) { string[] a = dbHelp.GetPivasAllSetValue3("护士站-按钮三").Split(','); btn3.ForeColor = Color.FromArgb(Convert.ToInt32(a[0]), Convert.ToInt32(a[1]), Convert.ToInt32(a[2])); } } if (dbHelp.GetPivasAllSet("护士站-标题显示-1") == "0") { label3.Visible = false; } else { label3.Visible = true; } if (dbHelp.GetPivasAllSetValue2("护士站-标题显示-1") == "0") { label5.Visible = false; } else { label5.Visible = true; } if (dbHelp.GetPivasAllSetValue3("护士站-标题显示-1") == "0") { label6.Visible = false; } else { label6.Visible = true; } if (dbHelp.GetPivasAllSet("护士站-标题显示-2") == "0") { label7.Visible = false; } else { label7.Visible = true; } if (dbHelp.GetPivasAllSetValue2("护士站-标题显示-2") == "0") { label8.Visible = false; } else { label8.Visible = true; } if (dbHelp.GetPivasAllSetValue3("护士站-标题显示-2") == "0") { label4.Visible = false; } else { label4.Visible = true; } //是否闪烁 ShanShuo(); }
void IMenuManager.menuBeforeSelect() { if (db.GetPivasAllSet("核对-摆药核对-按钮显示") == "0") { btnBaiyao.Visible = false; } else { btnBaiyao.Visible = true; } if (db.GetPivasAllSet("核对-排药核对-按钮显示") == "0") { btnPaiyao.Visible = false; } else { btnPaiyao.Visible = true; } if (db.GetPivasAllSet("核对-进仓核对-按钮显示") == "0") { btnJinCang.Visible = false; } else { btnJinCang.Visible = true; } if (db.GetPivasAllSet("核对-配置核对-按钮显示") == "0") { btnConfiguration.Visible = false; } else { btnConfiguration.Visible = true; } if (db.GetPivasAllSet("核对-出仓核对-按钮显示") == "0") { btnChuCang.Visible = false; } else { btnChuCang.Visible = true; } if (db.GetPivasAllSet("核对-打包核对-按钮显示") == "0") { btnPackage.Visible = false; } else { btnPackage.Visible = true; } if (db.GetPivasAllSet("核对-贴签核对-按钮显示") == "0") { btnTieQian.Visible = false; } else { btnTieQian.Visible = true; } }
private void button1_Click(object sender, EventArgs e) { if (txtDoc.Text.Trim() == "") { MessageBox.Show("请输入账户名"); txtDoc.Focus(); return; } //else if (txtPas.Text.Trim()=="") //{ // MessageBox.Show("请输入密码"); // txtPas.Focus(); // return; //} if (comboBox1.Text.Trim() == "" && rBRun.Checked) { MessageBox.Show("请填写说明"); comboBox1.Focus(); return; } string str = "SELECT * FROM DEmployee WHERE AccountID='" + txtDoc.Text + "' AND Pas ='******'"; if (DB.GetPIVAsDB(str).Tables[0].Rows.Count == 0) { MessageBox.Show("账户或密码错误"); return; } if (rBAccept.Checked) { Operate = "2"; //str = "UPDATE CPRecord SET DoctorExplain = '接受退单',CheckDCode = '" + AccountID + "', DoctorOperate = " + Operate // + "WHERE CPRecordID = " + CPRecordID; str = "IF EXISTS (SELECT * FROM CPRecord WHERE CPRecordID = " + CPRecordID + " ) " + "UPDATE CPRecord SET DoctorExplain = '接受退单',CheckDCode = '" + AccountID + "', DoctorOperate = 2 " + "WHERE CPRecordID = " + CPRecordID + " ELSE " + "INSERT INTO CPRecord VALUES ('" + PreID + "',0,GETDATE(),'接受退单','" + AccountID + "',GETDATE(),1,2)"; } else { Operate = "1"; //str = "UPDATE CPRecord SET DoctorExplain = '" + comboBox1.Text + "',CheckDCode = '" + AccountID + "', DoctorOperate = " + Operate // + "WHERE CPRecordID = " + CPRecordID; str = "IF EXISTS (SELECT * FROM CPRecord WHERE CPRecordID = " + CPRecordID + " ) " + "UPDATE CPRecord SET DoctorExplain = '" + comboBox1.Text + "',CheckDCode = '" + AccountID + "', DoctorOperate = 1 " + "WHERE CPRecordID = " + CPRecordID + " " + "ELSE " + "INSERT INTO CPRecord VALUES ('" + PreID + "',0,GETDATE(),'" + comboBox1.Text + "','" + AccountID + "',GETDATE(),1,1)"; if (DB.GetPivasAllSet("护士站-系统审方-强制执行") == "1") { string sql = "update Prescription set PStatus=1 where PrescriptionID='" + PreID + "'"; DB.SetPIVAsDB(sql); } } DB.SetPIVAsDB(str); this.DialogResult = DialogResult.OK; }
/// <summary> /// 一些基础数据插入。 /// </summary> private void SetDate() { try { db.GetPivasAllSet("排批次-#"); db.GetPivasAllSet("排批次-L#"); db.GetPivasAllSet("排批次-K"); db.GetPivasAllSet("排批次-LK"); db.GetPivasAllSet("SaveLabelDay"); db.GetPivasAllSet("同步-药品目录-画面显示"); db.GetPivasAllSet("同步-病区-画面显示"); db.GetPivasAllSet("同步-员工-画面显示"); db.GetPivasAllSet("同步-剂量单位-画面显示"); db.GetPivasAllSet("同步-频次-画面显示"); db.GetPivasAllSet("同步-患者-画面显示"); db.GetPivasAllSet("同步-医嘱-画面显示"); db.GetPivasAllSet("同步-药单-画面显示"); db.GetPivasAllSet("同步-患者身高体重-画面显示"); db.GetPivasAllSet("同步-临床诊断-画面显示"); db.GetPivasAllSet("同步-统药单-画面显示"); db.GetPivasAllSet("第三方瓶签"); } catch { MessageBox.Show("程序综合设置,基础数据插入维护出错。"); } }
private void frmScanPre_Load(object sender, EventArgs e) { if (GetPivasLimit.Instance.Limit(EmployeeID, "ScanPre")) { cbbStatus.SelectedIndex = 1; comboBox2.SelectedIndex = 0; cb1.Checked = true; cb2.Checked = true; cb3.Checked = true; cbP.Checked = true; cbK.Checked = true; cbH.Checked = true; cbY.Checked = true; cbZ.Checked = true; newdgvWard(P); TraversalDgvWard(); newdgvPre(); try { dtp1.Text = DateTime.Now.AddDays(int.Parse(DB.GetPivasAllSet("医嘱查询-默认开始时间/结束时间-画面显示"))).ToString(); dtp2.Text = DateTime.Now.AddDays(int.Parse(DB.GetPivasAllSetValue2("医嘱查询-默认开始时间/结束时间-画面显示"))).ToString(); } catch { MessageBox.Show(" 综合设置中:<医嘱查询-默认开始时间/结束时间-画面显示> 设置项请设置数字。 "); } //画面初始大小设置 if (DB.GetPivasAllSet("医嘱查询-画面初始最大化") == "1") { MaximizedBounds = Screen.PrimaryScreen.WorkingArea; this.FormBorderStyle = FormBorderStyle.None; this.WindowState = FormWindowState.Maximized; this.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); Panel_Max_None.BackgroundImage = global::ScanPre.Properties.Resources.还原; } //普抗化营筛选显示设置 if (DB.GetPivasAllSet("医嘱查询-普抗化营筛选-画面显示") == "0") { cbP.Visible = false; cbK.Visible = false; cbH.Visible = false; cbY.Visible = false; cbZ.Visible = false; } //长期临时筛选显示设置 if (DB.GetPivasAllSet("医嘱查询-长期临时筛选-画面显示") == "0") { cb1.Visible = false; cb2.Visible = false; } //今日生有生成瓶签 筛选显示设置 string Xianshi = DB.GetPivasAllSet("医嘱查询-今日有瓶签勾选-画面显示"); string GouXuan = DB.GetPivasAllSetValue2("医嘱查询-今日有瓶签勾选-画面显示"); if (Xianshi == "0") { checkBox1.Visible = false; checkBox1.Checked = false; } else if (Xianshi == "1" && GouXuan == "1") { checkBox1.Visible = true; checkBox1.Checked = true; } else if (Xianshi == "1" && GouXuan == "0") { checkBox1.Visible = true; checkBox1.Checked = false; } else { checkBox1.Visible = false; checkBox1.Checked = false; MessageBox.Show(" 综合设置中:<医嘱查询-今日有瓶签勾选-画面显示> 设置项 设置不正确。 "); } //模糊查询框 显示设置 if (DB.GetPivasAllSet("医嘱查询-模糊查询框-画面显示") == "0") { txtName.Visible = false; } //病区默认勾选 if (DB.GetPivasAllSet("医嘱查询-画面初始病区勾选") == "0") { P = 0; newdgvWard(P); TraversalDgvWard(); newdgvPre(); } else if (DB.GetPivasAllSet("医嘱查询-画面初始病区勾选") == "2") { P = 2; newdgvWard(P); TraversalDgvWard(); newdgvPre(); } else if (DB.GetPivasAllSet("医嘱查询-画面初始病区勾选") == "1") { P = 1; newdgvWard(P); TraversalDgvWard(); newdgvPre(); } else { newdgvWard(P); TraversalDgvWard(); newdgvPre(); MessageBox.Show(" 综合设置中:<医嘱查询-画面初始病区勾选> 设置项 设置不正确。 "); } } else { this.Dispose(); } }
/// <summary> /// 病人列表模式下。查询病人瓶签详细信息 /// </summary> /// <param name="WardCode"></param> /// <param name="dt"></param> /// <param name="s">BatchSaved</param> /// <param name="tags"></param> /// <param name="SelectText"></param> /// <param name="LabelOrderBy"></param> /// <returns></returns> public string IVRecordPatient(string WardCode, string dt, int s, bool tags, string SelectText, int LabelOrderBy) { string send = db.GetPivasAllSet("批次-病人明细模式-未发送-已发送已打印瓶签"); string print = db.GetPivasAllSetValue2("批次-病人明细模式-未发送-已发送已打印瓶签"); StringBuilder str = new StringBuilder(); str.Length = 0; str.Append(" select Count(LabelNo),patcode,patname from IVRecord i "); //str.Append(" where WardCode in (" + WardCode + ") "); //str.Append(" and LabelNo like '" + dt + "%'"); str.Append(" where LabelNo like '" + dt + "%'"); str.Append(" and patcode='" + SelectText + "'"); str.Append(" and IsBatch=1"); if (WardCode != "") { str.Append(" and WardCode in (" + WardCode + ") "); } if (s == 2) { str.Append(" and ivstatus >=3 "); } else { if (tags) { str.Append(" and ivstatus=1"); } else { str.Append(" and ivstatus=0"); //if (s != 2) //{ str.Append(" and BatchSaved=" + s); //} } } if (SelectText != "") { str.Append("and patcode='" + SelectText + "'"); } str.Append(" and LabelOver>=0 "); str.Append(" and (i.Remark2 <> '-1' or i.Remark2 is null or i.Remark2 <> '-2') "); str.Append(" group by patcode,PatName"); str.Append(" select distinct i.PatCode,Batch,BatchRule,OC.OrderColor,OC.OrderTColor as TColor,P.UsageName, TeamNumber,i.WardCode,i.WardName,i.GroupNo,LabelNo,i.IsSame,"); str.Append(" FreqName,id.Spec,id.DrugName,pa.PatName,pa.BedNo,CASE WHEN pa.sex= '1' THEN '男' WHEN pa.sex= '2' THEN '女' ELSE '其他' END sex,"); str.Append(" pa.age,pa.AgeSTR, i.InsertDT,case BatchSaved when 0 then '未发送' else '已发送' end BatchSaved,DgNo,"); str.Append(" case IVStatus when 0 then '未打印' else '已打印' end IVStatus,"); str.Append(" case BatchSaved when 0 then '未发送' else '已发送' end IsCommand,"); str.Append(" case when cast(id.Dosage as float) > cast(cast(id.Dosage as float) as INT) then cast(id.Dosage as float)"); str.Append(" else cast(cast(id.Dosage as float) as int) end as Dosage,"); str.Append(" case when id.DosageUnit is null then '' else id.DosageUnit end AS DosageUnit "); str.Append(" , CASE id.DosageUnit WHEN 'ml' THEN id.Dosage WHEN 'l' THEN (1000 * id.Dosage) "); str.Append(" ELSE isnull(dd.Capacity, 0) * id.DgNo END AS Remark9,dd.CapacityUnit "); str.Append(" from dbo.IVRecord i"); str.Append(" left join Patient pa on pa.PatCode=i.PatCode "); str.Append(" left join IVRecordDetail id on i.IVRecordID=id.IVRecordID "); str.Append(" left join DDrug dd on dd.DrugCode=id.DrugCode "); str.Append(" left join OrderColor OC on OC.OrderID=i.TeamNumber"); str.Append(" inner join Prescription P on i.GroupNo=P.GroupNo "); str.Append(" where LabelNo like '" + dt + "%'"); str.Append(" and IsBatch=1 "); if (WardCode != "") { str.Append(" and i.WardCode in (" + WardCode + ") "); } if (s == 2) { str.Append(" and ivstatus >=3 "); } else { if (tags) { str.Append(" and ivstatus=1"); } else { if (print == "0") { str.Append(" and ivstatus=0"); } if (send == "0") { str.Append(" and BatchSaved=" + s); } } } if (SelectText != "") { str.Append(" and i.patcode='" + SelectText + "'"); } str.Append(" and LabelOver>=0 "); str.Append(" and ((i.Remark2 <> '-1' and i.Remark2 <> '-2') or i.Remark2 is null ) "); str.Append(" order by TeamNumber,"); if (LabelOrderBy == 0) { str.Append("i.LabelNo,"); } else if (LabelOrderBy == 1) { str.Append("i.FreqCode,"); } else { str.Append("i.GroupNo,"); } str.Append("i.PatCode,DgNo"); return(str.ToString()); }
string IsCheck = "1";//默认需要确认 private void DXTuiYao_Load(object sender, EventArgs e) { IsCheck = db.GetPivasAllSet("护士站-单项退药-确认"); LabelOverFor = NurseFormSet(); BangdingDvg(); }
string IsCheck = "1";//默认需要确认 private void TiQianDB_Load(object sender, EventArgs e) { IsCheck = db.GetPivasAllSet("护士站-提前打包-确认"); LabelOverFor = NurseFormSet(); BangdingDvg(); }