/// <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();
}
