private void UseCheck_Load(object sender, EventArgs e)
{
label1.Text = DB.GetPivasAllSetValue2("打印-打印确认-打印完成后调用画面");
label2.Text = CheckPro();
}
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());
}
