/// <summary>
/// PopupForm
/// </summary>
/// <param name="vo"></param>
void PopupForm(EntityContagionDisplay vo)
{
if (vo == null)
{
vo = new EntityContagionDisplay();
vo.isNew = true;
}
vo.reportId = Viewer.ReportId;
frmContagionEdit frm = new frmContagionEdit(vo);
frm.Text = Viewer.Text;
using (ProxyContagion proxy = new ProxyContagion())
{
if (Function.Int(vo.rptId) > 0)
{
string Role = proxy.Service.GetContagionRole(GlobalLogin.objLogin.EmpNo);
frm.blbiSave.Enabled = false;
if (Role != string.Empty || vo.SHR == null)
{
frm.blbiSave.Enabled = true;
}
}
}
frm.ShowDialog();
if (frm.IsSave)
{
this.Query();
}
}
/// <summary>
/// EditReport
/// </summary>
internal void EditReport()
{
EntityContagionDisplay vo = GetRowObject();
if (vo != null)
{
this.PopupForm(vo);
}
}
/// <summary>
/// 构造
/// </summary>
public frmContagionEdit(EntityContagionDisplay _ContagionDisplayVo)
{
InitializeComponent();
if (!DesignMode)
{
this.defaultLookAndFeel.LookAndFeel.SkinName = GlobalLogin.SkinName;
DevExpress.LookAndFeel.UserLookAndFeel.Default.SetSkinStyle(GlobalLogin.SkinName);
((ctlContagionEdit)Controller).ContagionDisplayVo = _ContagionDisplayVo;
}
}
/// <summary>
/// Print
/// </summary>
internal void Print()
{
EntityContagionDisplay vo = GetRowObject();
if (vo != null && Function.Dec(vo.rptId) > 0)
{
frmPrintDocumentSimple frm = new frmPrintDocumentSimple(GetXR(Function.Dec(vo.rptId)));
frm.ShowDialog();
}
}
/// <summary>
/// Export
/// </summary>
internal void Export()
{
EntityContagionDisplay vo = GetRowObject();
if (vo != null && Function.Dec(vo.rptId) > 0)
{
XtraReport xr = GetXR(Function.Dec(vo.rptId));
if (xr != null && xr.DataSource != null)
{
xr.Name = Viewer.Text;
uiHelper.Export(xr);
}
}
}
/// <summary>
/// DelReport
/// </summary>
internal void DelReport()
{
EntityContagionDisplay vo = GetRowObject();
if (vo != null && Function.Dec(vo.rptId) > 0)
{
if (DialogBox.Msg("确定是否删除当前记录？？", MessageBoxIcon.Question) == DialogResult.Yes)
{
using (ProxyContagion proxy = new ProxyContagion())
{
if (proxy.Service.DelContagion(Function.Dec(vo.rptId)) > 0)
{
DialogBox.Msg("删除传染病记录成功！");
this.Query();
}
else
{
DialogBox.Msg("删除传染病记录失败。");
}
}
}
}
}
/// <summary>
/// 获取传染病列表
/// </summary>
/// <param name="dicParm"></param>
/// <returns></returns>
internal List <EntityContagionDisplay> GetContagionList(List <EntityParm> dicParm)
{
string Sql = string.Empty;
string Sql1 = string.Empty;
string xmlData = string.Empty;
Dictionary <string, string> dicData = new Dictionary <string, string>();
List <EntityContagionDisplay> data = new List <EntityContagionDisplay>();
SqlHelper svc = null;
try
{
#region Sql
svc = new SqlHelper(EnumBiz.onlineDB);
Sql = @"select t.rptId,
t.reportId,
t.reportTime,
t.reportOperCode,
t.reportOperName,
t.registerCode,
t.patno,
t.patname,
t.patsex,
t.birthday,
t.contacttel,
t.deptcode,
b.DEPT_NAME as deptName,
c.xmlData
from rptContagion t
left join code_department b
on t.deptcode = b.DEPT_CODE
left join rptContagionData c
on t.rptId = c.rptId
where t.status = 1
and t.reportId = ?
";
Sql1 = @"select t.rptId,
t.reportId,
t.reportTime,
t.reportOperCode,
t.reportOperName,
t.registerCode,
t.patno,
t.patname,
t.patsex,
t.birthday,
t.contacttel,
t.deptcode,
b.DEPT_NAME as deptName,
c.xmlData
from rptContagion t
inner join patientinfo a
on t.patno = a.CARD_NO
left join code_department b
on t.deptcode = b.DEPT_CODE
left join rptContagionData c
on t.rptId = c.rptId
where t.status = 1
and t.reportId = ?
";
#endregion
#region 条件
string strSub = string.Empty;
List <IDataParameter> lstParm = new List <IDataParameter>();
// 默认参数
IDataParameter parm = svc.CreateParm();
parm.Value = dicParm.FirstOrDefault(t => t.key == "reportId").value;
lstParm.Add(parm);
foreach (EntityParm po in dicParm)
{
parm = svc.CreateParm();
string keyValue = po.value;
parm.Value = keyValue;
switch (po.key)
{
case "reportDate":
IDataParameter parm1 = svc.CreateParm();
parm1.Value = keyValue.Split('|')[0] + " 00:00:00";
lstParm.Add(parm1);
IDataParameter parm2 = svc.CreateParm();
parm2.Value = keyValue.Split('|')[1] + " 23:59:59";
lstParm.Add(parm2);
strSub += " and (t.reportTime between ? and ?)";
break;
case "deptCode":
if (keyValue.IndexOf("','") > 0)
{
strSub += " and (t.deptCode in (" + keyValue + "))";
}
else
{
parm.Value = parm.Value.ToString().Replace("'", "");
lstParm.Add(parm);
strSub += " and (t.deptCode = ?)";
}
break;
case "cardNo":
lstParm.Add(parm);
strSub += " and (t.patno= ?)";
break;
case "patName":
Sql = Sql1;
parm.Value = "%" + keyValue + "%";
lstParm.Add(parm);
strSub += " and (a.name like ?)";
break;
default:
break;
}
}
#endregion
#region 赋值
// 组合条件
Sql += strSub;
DataTable dt = svc.GetDataTable(Sql, lstParm.ToArray());
if (dt != null)
{
EntityContagionDisplay vo = null;
foreach (DataRow dr in dt.Rows)
{
vo = new EntityContagionDisplay();
vo.rptId = dr["rptId"].ToString();
vo.reportTime = dr["reportTime"].ToString();
vo.reportOperCode = dr["reportOperCode"].ToString();
vo.reportOperName = dr["reportOperName"].ToString();
vo.registerCode = dr["registerCode"].ToString();
vo.patNo = dr["patNo"].ToString();
vo.patName = dr["patName"].ToString();
vo.patSex = dr["patSex"].ToString() == "1" ? "男" : "女";
if (dr["birthday"] != DBNull.Value)
{
vo.patBirthDay = dr["birthday"].ToString();
vo.patAge = CalcAge.GetAge(Function.Datetime(dr["birthday"]));
}
vo.contactTel = dr["contactTel"].ToString();
vo.deptName = dr["deptName"].ToString();
xmlData = dr["xmlData"].ToString();
if (!string.IsNullOrEmpty(xmlData))
{
dicData = Function.ReadXmlNodes(xmlData, "FormData");
if (dicData.ContainsKey("XSHR") && dicData["XSHR"] != "")
{
vo.SH = "已审核";
vo.SHR = dicData["XSHR"];
}
if (dicData.ContainsKey("XSHD") && dicData["XSHD"] != "")
{
vo.SHSJ = dicData["XSHD"];
}
if (dicData.ContainsKey("XBKS") && dicData["XBKS"] != "")
{
vo.reportDept = dicData["XBKS"];
}
}
data.Add(vo);
}
}
#endregion
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
}
finally
{
svc = null;
}
return(data);
}
