private void btnShowLog_Click(object sender, EventArgs e)
{
var f = new UploadLog();
f.OnImportUploadList += list =>
{
var dal = new T_JCXX_DAL();
var count = 0;
var tempList = new List <string>();
_lstJcxx = new List <T_JCXX>();
foreach (string blh in list)
{
tempList.Add(blh);
//每次用in查出500条
if (tempList.Count == 500 || list[list.Count - 1] == blh)
{
var blhString = "";
tempList.ForEach(o => blhString += $"'{o}',");
blhString = blhString.TrimEnd(',');
var sqlWhere = $" and f_blh in ({blhString}) ";
_lstJcxx.AddRange(dal.GetBySqlWhere(sqlWhere));
tempList.Clear();
}
}
BindData();
lblStatus.Text = $"等待上传,共{_lstJcxx.Count}条";
};
f.ShowDialog();
}
public void Query()
{
dataLayoutControl1.Validate();
T_JCXX_DAL dal = new T_JCXX_DAL();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
var list1 = new List <T_JCXX>();
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
var sqlWhere = "1 =1 ";
sqlWhere += $" and f_bz<>'' ";
if (sqlFilter.Blk != null && (sqlFilter.Blk != "全部" && sqlFilter.Blk != ""))
{
sqlWhere += $" and f_blk='{sqlFilter.Blk}' ";
}
if (sqlFilter.Bgrq1.HasValue)
{
//收到日期
sqlWhere += $" and CONVERT(datetime,f_bgrq) >= CONVERT(datetime,'{sqlFilter.Bgrq1.Value.Date}') ";
}
if (sqlFilter.Bgrq2.HasValue)
{
sqlWhere += $" and CONVERT(datetime,f_bgrq) <=CONVERT(datetime,'{sqlFilter.Bgrq2.Value.Date.AddDays(1)}') ";
}
if (!string.IsNullOrEmpty(sqlFilter.CrisisText))
{
sqlWhere += $" and f_bz like '%{sqlFilter.CrisisText}%' ";
}
list1 = T_JCXX_DAL.GetBySqlWhere(sqlWhere, "f_bgrq");
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
if (list1.Any() == false)
{
XtraMessageBox.Show("没有找到任何结果!");
}
tJCXXBindingSource.DataSource = list1;
gridView1.RefreshData();
gridView1.ExpandAllGroups();
gridView1.BestFitColumns();
}
public void Query()
{
dataLayoutControl1.Validate();
T_JCXX_DAL dal = new T_JCXX_DAL();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
var list1 = dal.GetJcxxTbsList(sqlFilter);
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
foreach (T_JCXX jcxx in list1)
{
SplashScreenManager.ShowDefaultWaitForm($"分析二次诊断数据 {list1.IndexOf(jcxx)}/{list1.Count}");
T_JCXX jcxxPre = dal.GetPreJcxx(jcxx);
jcxx.PreJcxx = jcxxPre;
}
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
//去掉没有上次检验的
list1 = list1.Where(o => o.PreJcxx != null && string.IsNullOrEmpty(o.PreJcxx.F_BLH) == false).ToList();
//差异值过滤
if (sqlFilter != null && sqlFilter.ValueDiff > 0)
{
list1 = list1.Where(o => Math.Abs(o.TBS_VALUE_DIFF) >= Math.Abs(sqlFilter.ValueDiff)).ToList();
}
if (list1.Any() == false)
{
XtraMessageBox.Show("没有找到任何结果!");
}
tJCXXBindingSource.DataSource = list1;
gridView1.RefreshData();
gridView1.BestFitColumns();
}
/// <summary>
/// 如果JCXX状态为已审核,则回传结果
/// 否则若病人类型为门诊,则进行门诊确费
/// </summary>
/// <param name="pathoNo">病理号</param>
/// <param name="aa"></param>
public void SendResult(string pathoNo)
{
T_JCXX jcxx = null;
try
{
jcxx = new T_JCXX_DAL().GetModel(pathoNo);
}
catch (Exception e)
{
throw new Exception("没有找到该结果,病理号为:" + pathoNo);
}
if (jcxx == null)
{
throw new Exception("没有找到该结果,病理号为:" + pathoNo);
}
log.WriteMyLog("进入sendResult" + jcxx.F_SJKS);
try
{
if (jcxx.F_BGZT == "已审核") //如果已审核,执行回传结果
{
SendResult(jcxx);
}
else if (string.IsNullOrEmpty(jcxx.F_MZH.Trim()) == false) //如果不是已审核且科室为门诊,执行门诊确费
{
log.WriteMyLog("进入OutCheckFee");
OutCheckFee(jcxx);
}
}
catch (Exception e)
{
//该接口陈程要求所有报错都不弹窗,只记录log
}
}
public void Query()
{
dataLayoutControl1.Validate();
T_JCXX_DAL dal = new T_JCXX_DAL();
List <T_YH> yhList = null;
var dataEntities = new List <DataEntity>();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
string sqlCg = " select f_bgys bgys,f_fzys fzys from [dbo].[T_JCXX] t where F_BZ like '疑难病例' ";
string sqlBc =
"select f_bc_bgys bgys,F_BC_FZYS fzys from [dbo].[T_BCBG] bc inner join t_jcxx t on t.f_blh=bc.f_blh where F_BC_BZ like '疑难病例' and F_BC_BGXH='1' ";
string sqlWhereBc = "";
string sqlWhereCg = "";
if (sqlFilter.Blk != null && (sqlFilter.Blk != "全部" && sqlFilter.Blk != ""))
{
sqlWhereCg += $" and t.f_blk='{sqlFilter.Blk}' ";
sqlWhereBc += $" and t.f_blk='{sqlFilter.Blk}' ";
}
if (sqlFilter.Sdrq1.HasValue)
{
//收到日期
sqlWhereBc += $" and CONVERT(datetime,t.f_sdrq) >= CONVERT(datetime,'{sqlFilter.Sdrq1.Value.Date}') ";
sqlWhereCg += $" and CONVERT(datetime,t.f_sdrq) >= CONVERT(datetime,'{sqlFilter.Sdrq1.Value.Date}') ";
}
if (sqlFilter.Sdrq2.HasValue)
{
sqlWhereBc += $" and CONVERT(datetime,t.f_sdrq) <=CONVERT(datetime,'{sqlFilter.Sdrq2.Value.Date.AddDays(1)}') ";
sqlWhereCg += $" and CONVERT(datetime,t.f_sdrq) <=CONVERT(datetime,'{sqlFilter.Sdrq2.Value.Date.AddDays(1)}') ";
}
//如果输入医生姓名,取单一的医生姓名,否则取用户列表
if (!string.IsNullOrEmpty(sqlFilter.医生姓名))
{
yhList = new List <T_YH>();
yhList.Add(new T_YH()
{
F_YHMC = sqlFilter.医生姓名
});
}
else
{
yhList = T_YH_DAL.GetList("");
}
var dtCg = CommonDAL.GetTableBySql(sqlCg + sqlWhereCg);
var dtBc = CommonDAL.GetTableBySql(sqlBc + sqlWhereBc);
var dtCgEnumerable = dtCg.Rows.Cast <DataRow>().ToList();
var dtBcEnumerable = dtBc.Rows.Cast <DataRow>().ToList();
foreach (T_YH yh in yhList)
{
DataEntity entity = new DataEntity();
entity.医生姓名 = yh.F_YHMC;
entity.常规初诊 = dtCgEnumerable.Count(dr => dr["bgys"].ToString().Contains(yh.F_YHMC));
entity.常规复诊 = dtCgEnumerable.Count(dr => dr["fzys"].ToString().Contains(yh.F_YHMC) && dr["bgys"].ToString().Contains(yh.F_YHMC) == false);
entity.补充初诊 = dtBcEnumerable.Count(dr => dr["bgys"].ToString().Contains(yh.F_YHMC));
entity.补充复诊 = dtBcEnumerable.Count(dr => dr["fzys"].ToString().Contains(yh.F_YHMC) && dr["bgys"].ToString().Contains(yh.F_YHMC) == false);
if (entity.常规初诊 + entity.常规复诊 + entity.补充初诊 + entity.补充复诊 > 0)
{
dataEntities.Add(entity);
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
if (dataEntities.Any() == false)
{
XtraMessageBox.Show("没有找到任何结果!");
}
tJCXXBindingSource.DataSource = dataEntities;
gridView1.RefreshData();
gridView1.ExpandAllGroups();
gridView1.BestFitColumns();
}
public void Query()
{
dataLayoutControl1.Validate();
var dal = new T_JCXX_DAL();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
var list1 = new List <T_JCXX>();
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
var sqlWhere = "1 =1 ";
//病例库
if (sqlFilter.Blk != null && sqlFilter.Blk != "全部" && sqlFilter.Blk != "")
{
sqlWhere += $" and f_blk='{sqlFilter.Blk}' ";
}
//收到日期
if (sqlFilter.Sdrq1.HasValue)
{
sqlWhere += $" and CONVERT(datetime,f_sdrq) >= CONVERT(datetime,'{sqlFilter.Sdrq1.Value.Date}') ";
}
if (sqlFilter.Sdrq2.HasValue)
{
sqlWhere +=
$" and CONVERT(datetime,f_sdrq) <=CONVERT(datetime,'{sqlFilter.Sdrq2.Value.Date.AddDays(1)}') ";
}
//报告状态
if (sqlFilter.Bgzt != Bgzts.全部)
{
sqlWhere += $" and f_bgzt = '{sqlFilter.Bgzt}' ";
}
else
{
sqlWhere += $" and f_bgzt in ('已写报告','已审核') ";
}
//医嘱项目
if (string.IsNullOrEmpty(sqlFilter.Yzxm) == false && sqlFilter.Yzxm != "全部")
{
sqlWhere += $" and f_yzxm = '{sqlFilter.Yzxm}' ";
}
//项目分类
if (sqlFilter.Xmfl != null && (sqlFilter.Xmfl != "全部" && sqlFilter.Xmfl.Trim() != ""))
{
sqlWhere += $" and f_bblx='{sqlFilter.Xmfl}' ";
}
list1 = T_JCXX_DAL.GetBySqlWhere(sqlWhere);
//处理报告发放天数
foreach (T_JCXX jcxx in list1)
{
jcxx.发放天数 = GetDays(jcxx);
//去掉项目前面的编号
if (jcxx.F_YZXM.Split('^').Length > 1)
{
jcxx.F_YZXM = jcxx.F_YZXM.Split('^')[1];
}
}
//获得合计
var reportCountList = (from o in list1
group o by o.发放天数
into g
orderby Convert.ToInt32(g.Key)
select new
{
工作日 = g.Key.ToString(),
数量 = g.Count()
}
).ToList();
var totalCount = reportCountList.Sum(o => o.数量);
reportCountList.Add(new { 工作日 = "合计", 数量 = totalCount });
gridControl2.DataSource = reportCountList;
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
if (list1.Any() == false)
{
XtraMessageBox.Show("没有找到任何结果!");
}
tJCXXBindingSource.DataSource = list1;
gridView1.RefreshData();
gridView1.ExpandAllGroups();
gridView1.BestFitColumns();
}
public void Query()
{
dataLayoutControl1.Validate();
var dal = new T_JCXX_DAL();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
var list = new List <ReportItem>();
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
var sqlWhere = "1 =1 ";
//报告日期
if (sqlFilter.Bgrq1.HasValue)
{
sqlWhere += $" and CONVERT(datetime,f_sdrq) >= CONVERT(datetime,'{sqlFilter.Bgrq1.Value.Date}') ";
}
if (sqlFilter.Bgrq2.HasValue)
{
sqlWhere +=
$" and CONVERT(datetime,f_sdrq) <=CONVERT(datetime,'{sqlFilter.Bgrq2.Value.Date.AddDays(1)}') ";
}
sqlWhere += $" and f_blk in ('常规','小标本','细胞学','病理会诊','细针穿刺','肾穿1','肾穿2') ";
string sql = $" select count(*) c,case when ltrim(rtrim(f_zyh))='' then '0' else '1' end as zy, f_blk,F_SJDW,F_SFFH,f_sjks from t_jcxx" +
$" where {sqlWhere} " +
$" group by f_blk,f_sjks,F_SJDW,F_SFFH,case when ltrim(rtrim(f_zyh))='' then '0' else '1' end ";
var dtSource = CommonDAL.GetTableBySql(sql);
//处理数据
var queryableSource = from o in dtSource.Rows.Cast <DataRow>()
select new
{
count = Convert.ToInt32(o["c"]),
blk = o["f_blk"].ToString(),
sjdw = o["f_sjdw"].ToString(),
sffh = o["f_sffh"].ToString(),
zy = o["zy"].ToString(),
sjks = o["f_sjks"].ToString().Trim()
};
//常规检查
var commonItem = new ReportItem();
list.Add(commonItem);
var queryableCommon = queryableSource.Where(o => o.blk == "常规" || o.blk == "小标本");
commonItem.序号 = 1;
commonItem.类别 = "病理检查(常规)";
commonItem.总人次数 = queryableCommon.Sum(o => o.count);
commonItem.诊断符合人次数 = queryableCommon.Where(o => o.sffh != "不符合").Sum(o => o.count);
//常规检查_院外
var commonItemOutside = new ReportItem();
list.Add(commonItemOutside);
var queryableCommonOutSide = queryableSource.Where(o => o.blk == "常规" || o.blk == "小标本").Where(o => o.sjdw != "中山大学附一院");
commonItemOutside.序号 = 1;
commonItemOutside.类别 = "院外";
commonItemOutside.总人次数 = queryableCommonOutSide.Sum(o => o.count);
commonItemOutside.诊断符合人次数 = queryableCommonOutSide.Where(o => o.sffh != "不符合").Sum(o => o.count);
//常规检查_院内
var commonItemInside = new ReportItem();
list.Add(commonItemInside);
var queryableCommonInSide = queryableSource.Where(o => o.blk == "常规" || o.blk == "小标本").Where(o => o.sjdw == "中山大学附一院");
commonItemInside.序号 = 1;
commonItemInside.类别 = "院内合计";
commonItemInside.总人次数 = queryableCommonInSide.Sum(o => o.count);
commonItemInside.诊断符合人次数 = queryableCommonInSide.Where(o => o.sffh != "不符合").Sum(o => o.count);
//常规检查_院内_门诊
var commonItemInsideMz = new ReportItem();
list.Add(commonItemInsideMz);
var queryableCommonInSideMz = queryableCommonInSide.Where(o => o.zy != "1");
commonItemInsideMz.序号 = 1;
commonItemInsideMz.类别 = "院内门诊";
commonItemInsideMz.总人次数 = queryableCommonInSideMz.Sum(o => o.count);
commonItemInsideMz.诊断符合人次数 = queryableCommonInSideMz.Where(o => o.sffh != "不符合").Sum(o => o.count);
//常规检查_院内_门诊
var commonItemInsideZy = new ReportItem();
list.Add(commonItemInsideZy);
var queryableCommonInSideZy = queryableCommonInSide.Where(o => o.zy == "1");
commonItemInsideZy.序号 = 1;
commonItemInsideZy.类别 = "院内住院";
commonItemInsideZy.总人次数 = queryableCommonInSideZy.Sum(o => o.count);
commonItemInsideZy.诊断符合人次数 = queryableCommonInSideZy.Where(o => o.sffh != "不符合").Sum(o => o.count);
//非妇科细胞学涂片
var itemCell = new ReportItem();
list.Add(itemCell);
var queryableCell = queryableSource.Where(o => o.blk == "细胞学");
itemCell.序号 = 2;
itemCell.类别 = "非妇科细胞学涂片";
itemCell.总人次数 = queryableCell.Sum(o => o.count);
itemCell.诊断符合人次数 = queryableCell.Where(o => o.sffh != "不符合").Sum(o => o.count);
//会诊病例
var itemHz = new ReportItem();
list.Add(itemHz);
var queryableHz = queryableSource.Where(o => o.blk == "病理会诊");
itemHz.序号 = 6;
itemHz.类别 = "会诊病例";
itemHz.总人次数 = queryableHz.Sum(o => o.count);
itemHz.诊断符合人次数 = queryableHz.Where(o => o.sffh != "不符合").Sum(o => o.count);
//本院肾穿
var itemInSc = new ReportItem();
list.Add(itemInSc);
var queryableInSc = queryableSource.Where(o => o.blk == "肾穿1" || (o.blk == "肾穿2" && o.sjks.Trim() != ""));
itemInSc.序号 = 9;
itemInSc.类别 = "本院肾穿";
itemInSc.总人次数 = queryableInSc.Sum(o => o.count);
itemInSc.诊断符合人次数 = queryableInSc.Where(o => o.sffh != "不符合").Sum(o => o.count);
//外院肾穿
var itemOutSc = new ReportItem();
list.Add(itemOutSc);
var queryableOutSc = queryableSource.Where(o => o.blk == "肾穿2" && o.sjks.Trim() == "");
itemOutSc.序号 = 9;
itemOutSc.类别 = "外院肾穿";
itemOutSc.总人次数 = queryableOutSc.Sum(o => o.count);
itemOutSc.诊断符合人次数 = queryableOutSc.Where(o => o.sffh != "不符合").Sum(o => o.count);
//细针穿刺
var itemCC = new ReportItem();
list.Add(itemCC);
var queryableCC = queryableSource.Where(o => o.blk == "细针穿刺");
itemCC.序号 = 10;
itemCC.类别 = "细针穿刺";
itemCC.总人次数 = queryableCC.Sum(o => o.count);
itemCC.诊断符合人次数 = queryableCC.Where(o => o.sffh != "不符合").Sum(o => o.count);
//合计
var itemAll = new ReportItem();
var queryableAll = queryableSource;
var 合计类别 = new string[] { "病理检查(常规)", "细针穿刺", "外院肾穿", "本院肾穿", "会诊病例", "非妇科细胞学涂片" };
itemAll.序号 = 99;
itemAll.类别 = "总计";
itemAll.总人次数 = list.Where(o => 合计类别.Contains(o.类别)).Sum(o => o.总人次数);
itemAll.诊断符合人次数 = list.Where(o => 合计类别.Contains(o.类别)).Sum(o => o.诊断符合人次数);
list.Add(itemAll);
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
if (list.Count == 0)
{
XtraMessageBox.Show("没有找到任何结果!");
}
reportItemBindingSource.DataSource = list;
gridView1.RefreshData();
gridView1.ExpandAllGroups();
gridView1.BestFitColumns();
}
public void Query()
{
dataLayoutControl1.Validate();
T_JCXX_DAL dal = new T_JCXX_DAL();
List <T_YH> yhList = null;
var dataEntities = new List <DataEntity>();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
string sqlCg = " select f_bgys bgys,f_fzys fzys from [dbo].[T_JCXX] t where F_BZ like '疑难病例' ";
string sqlWhereCg = "";
string sqlQC =
"select t.F_QCYS qcys,count(distinct t.f_blh) lishu,count(*) heshu from t_jcxx t left join T_QCMX q on t.F_BLH=q.F_BLH ";
string sqlWhereQc = " where 1=1 ";
string sqlGroupQc = " group by t.F_QCYS ";
if (sqlFilter.Blk != null && (sqlFilter.Blk != "全部" && sqlFilter.Blk != ""))
{
sqlWhereCg += $" and t.f_blk='{sqlFilter.Blk}' ";
sqlWhereQc += $" and t.f_blk='{sqlFilter.Blk}' ";
}
if (sqlFilter.Sdrq1.HasValue)
{
//收到日期
sqlWhereCg += $" and CONVERT(datetime,t.f_sdrq) >= CONVERT(datetime,'{sqlFilter.Sdrq1.Value.Date}') ";
sqlWhereQc += $" and CONVERT(datetime,t.f_sdrq) >= CONVERT(datetime,'{sqlFilter.Sdrq1.Value.Date}') ";
}
if (sqlFilter.Sdrq2.HasValue)
{
sqlWhereCg += $" and CONVERT(datetime,t.f_sdrq) <=CONVERT(datetime,'{sqlFilter.Sdrq2.Value.Date.AddDays(1)}') ";
sqlWhereQc += $" and CONVERT(datetime,t.f_sdrq) <=CONVERT(datetime,'{sqlFilter.Sdrq2.Value.Date.AddDays(1)}') ";
}
//如果输入医生姓名,取单一的医生姓名,否则取用户列表
if (!string.IsNullOrEmpty(sqlFilter.医生姓名))
{
yhList = new List <T_YH>();
yhList.Add(new T_YH()
{
F_YHMC = sqlFilter.医生姓名
});
}
else
{
yhList = T_YH_DAL.GetList("");
}
var dtCg = CommonDAL.GetTableBySql(sqlCg + sqlWhereCg);
var dtQc = CommonDAL.GetTableBySql(sqlQC + sqlWhereQc + sqlGroupQc);
var dtCgEnumerable = dtCg.Rows.Cast <DataRow>().ToList();
var dtQcEnumerable = dtQc.Rows.Cast <DataRow>().ToList();
foreach (T_YH yh in yhList)
{
DataEntity entity = new DataEntity();
entity.医生姓名 = yh.F_YHMC;
entity.常规初诊 = dtCgEnumerable.Count(dr => dr["bgys"].ToString().Contains(yh.F_YHMC));
entity.常规复诊 = dtCgEnumerable.Count(dr => dr["fzys"].ToString().Contains(yh.F_YHMC) && dr["bgys"].ToString().Contains(yh.F_YHMC) == false);
object lishu = dtQcEnumerable.SingleOrDefault(dr => dr["qcys"].ToString() == yh.F_YHMC)?["lishu"];
if (lishu != null)
{
entity.取材_例 = (int)lishu;
}
object heshu = dtQcEnumerable.SingleOrDefault(dr => dr["qcys"].ToString() == yh.F_YHMC)?["heshu"];
if (heshu != null)
{
entity.取材_盒 = (int)heshu;
}
if (entity.常规初诊 + entity.常规复诊 + entity.取材_例 + entity.取材_盒 > 0)
{
dataEntities.Add(entity);
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
if (dataEntities.Any() == false)
{
XtraMessageBox.Show("没有找到任何结果!");
}
tJCXXBindingSource.DataSource = dataEntities;
gridView1.RefreshData();
gridView1.ExpandAllGroups();
gridView1.BestFitColumns();
}
public void Query()
{
dataLayoutControl1.Validate();
var dal = new T_JCXX_DAL();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
var list1 = new List <T_JCXX>();
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
var sqlWhere = "1 =1 ";
//病例库
if (sqlFilter.Blk != null && sqlFilter.Blk != "全部" && sqlFilter.Blk != "")
{
sqlWhere += $" and f_blk='{sqlFilter.Blk}' ";
}
//收到日期
if (sqlFilter.Sdrq1.HasValue)
{
sqlWhere += $" and CONVERT(datetime,f_sdrq) >= CONVERT(datetime,'{sqlFilter.Sdrq1.Value.Date}') ";
}
if (sqlFilter.Sdrq2.HasValue)
{
sqlWhere +=
$" and CONVERT(datetime,f_sdrq) <=CONVERT(datetime,'{sqlFilter.Sdrq2.Value.Date.AddDays(1)}') ";
}
//报告状态
if (sqlFilter.Bgzt != Bgzts.全部)
{
sqlWhere += $" and f_bgzt = '{sqlFilter.Bgzt}' ";
}
//项目分类
if (sqlFilter.Xmfl != null && (sqlFilter.Xmfl != "全部" && sqlFilter.Xmfl.Trim() != ""))
{
sqlWhere += $" and f_bblx='{sqlFilter.Xmfl}' ";
}
//医嘱项目
if (string.IsNullOrEmpty(sqlFilter.Yzxm.Trim()) == false && sqlFilter.Yzxm != "全部")
{
sqlWhere += $" and f_yzxm = '{sqlFilter.Yzxm}' ";
}
sqlWhere += " and ( ltrim(rtrim(f_WFBGYY))!='' or ltrim(rtrim(f_spare9))!= '' )";
list1 = T_JCXX_DAL.GetBySqlWhere(sqlWhere);
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
if (list1.Any() == false)
{
XtraMessageBox.Show("没有找到任何结果!");
}
tJCXXBindingSource.DataSource = list1;
gridView1.RefreshData();
gridView1.ExpandAllGroups();
gridView1.BestFitColumns();
}
public static void Send(string[] args)
{
Logger.Debug("接口exe被调用,入参:" + args[0]);
IniFiles f = new IniFiles("sz.ini");
var blh = "";
var bglx = ""; //cg/bd/bc
var reportNumber = "";
var czlb = ""; //new/old
var dz = ""; //save/qxsh/dy/qxdy
EditType editType;
PisAction pisAction;
string hospName;
ReportType reportType;
#region 处理入参
//处理入参
try
{
string[] aa = args[0].Split('^');
blh = aa[0];
bglx = aa[1].ToLower(); //cg/bd/bc
reportNumber = aa[2];
czlb = aa[3].ToLower(); //new/old
dz = aa[4].ToLower(); //save/qxsh/dy/qxdy
reportType = ReportType.常规报告;
switch (bglx)
{
case "cg":
default:
reportType = ReportType.常规报告;
break;
case "bd":
reportType = ReportType.冰冻报告;
break;
case "bc":
reportType = ReportType.补充报告;
break;
}
editType = czlb == "new" ? EditType.新建 : EditType.修改;
switch (dz)
{
case "save":
if (editType == EditType.新建)
{
pisAction = PisAction.新登记;
}
else
{
pisAction = PisAction.保存;
}
break;
case "qxsh":
pisAction = PisAction.取消审核;
break;
case "dy":
pisAction = PisAction.打印;
break;
case "qxdy":
pisAction = PisAction.取消打印;
break;
default:
pisAction = PisAction.未知;
break;
}
hospName = f.ReadString("savetohis", "yymc", "123").Replace("\0", "");
}
catch (Exception e)
{
Logger.Error("传入参数解析出错:" + e);
MessageBox.Show("回传EXE入参错误:" + e);
return;
}
#endregion
Logger.Debug("EXE接口查询jcxx,病理号:" + blh);
T_JCXX jcxx = T_JCXX_DAL.GetModel(blh);
Logger.Debug("尝试获取接口实例,医院名称:" + hospName);
var sender = Factory.GetSendToThirdPartyByHisName(hospName);
if (sender == null)
{
Logger.Error("获取接口实例失败!");
}
Logger.Info($"开始调用EXE接口,病理号:{blh},操作类型:{pisAction},报告状态:{jcxx.F_BGZT}");
switch (pisAction)
{
case PisAction.新登记:
sender.OnAddReport(jcxx, reportType);
break;
case PisAction.保存:
if (jcxx.F_BGZT == "已审核")
{
sender.OnCheckReport(jcxx, reportType);
}
else
{
sender.OnSaveReport(jcxx, reportType);
}
break;
case PisAction.取消审核:
sender.OnCancelCheckReport(jcxx, reportType);
break;
case PisAction.打印:
sender.OnPrintReport(jcxx, reportType);
break;
case PisAction.取消打印:
sender.OnCancelPrintReport(jcxx, reportType);
break;
default:
throw new Exception("接口调用失败,无法解析PIS给的入参.");
}
}
public void Query()
{
dataLayoutControl1.Validate();
var dal = new T_JCXX_DAL();
var sqlFilter = sqlFilterBindingSource.Current as SqlFilter;
var list1 = new List <T_JCXX>();
SplashScreenManager.ShowDefaultWaitForm($"正在查询");
try
{
var sqlWhere = "1 =1 ";
//病例库
if (sqlFilter.Blk != null && sqlFilter.Blk != "全部" && sqlFilter.Blk != "")
{
sqlWhere += $" and f_blk='{sqlFilter.Blk}' ";
}
//报告日期
if (sqlFilter.Bgrq1.HasValue)
{
sqlWhere += $" and CONVERT(datetime,f_bgrq) >= CONVERT(datetime,'{sqlFilter.Bgrq1.Value.Date}') ";
}
if (sqlFilter.Bgrq2.HasValue)
{
sqlWhere +=
$" and CONVERT(datetime,f_bgrq) <=CONVERT(datetime,'{sqlFilter.Bgrq2.Value.Date.AddDays(1)}') ";
}
//收到日期
if (sqlFilter.Sdrq1.HasValue)
{
sqlWhere += $" and CONVERT(datetime,f_sdrq) >= CONVERT(datetime,'{sqlFilter.Sdrq1.Value.Date}') ";
}
if (sqlFilter.Sdrq2.HasValue)
{
sqlWhere +=
$" and CONVERT(datetime,f_sdrq) <=CONVERT(datetime,'{sqlFilter.Sdrq2.Value.Date.AddDays(1)}') ";
}
//报告状态
if (sqlFilter.Bgzt != Bgzts.全部)
{
sqlWhere += $" and f_bgzt = '{sqlFilter.Bgzt}' ";
}
//项目分类
if (sqlFilter.Xmfl != null && (sqlFilter.Xmfl != "全部" && sqlFilter.Xmfl.Trim() != ""))
{
sqlWhere += $" and f_bblx='{sqlFilter.Xmfl}' ";
}
//检测项目(医嘱项目)
if (string.IsNullOrEmpty(sqlFilter.Yzxm.Trim()) == false && sqlFilter.Yzxm != "全部")
{
sqlWhere += $" and f_yzxm = '{sqlFilter.Yzxm}' ";
}
//临床诊断
if (string.IsNullOrEmpty(sqlFilter.Lczd.Trim()) == false)
{
sqlWhere += $" and f_lczd like '%{sqlFilter.Lczd}%' ";
}
//是否阳性
if (sqlFilter.IsPositive == false)
{
sqlWhere += "and not";
}
else
{
sqlWhere += " and ";
}
sqlWhere +=
" ((f_fz_blzd like '%突变型%' or F_FZ_BLZD like '%阳性%' or F_FZ_BLZD like '%不稳定%' )and( f_fz_blzd not LIKE '%未见%' and f_fz_blzd not LIKE '%微卫星稳定%')) ";
string sql =
$"select t.*,t2.f_fz_blzd,t2.F_dnazk,t2.F_RNAZK from t_jcxx t inner join (select f_blh,f_fz_blzd,F_dnazk,F_RNAZK from T_TBS_BG) t2 on t.F_BLH=t2.F_BLH where ";
sql += sqlWhere;
var dt1 = CommonDAL.GetTableBySql(sql);
foreach (DataRow dr in dt1.Rows)
{
var jcxx = T_JCXX_DAL.DataRowToModel(dr);
jcxx.F_FZ_BLZD = dr["f_fz_blzd"].ToString();
jcxx.F_DNAZK = dr["F_dnazk"].ToString();
jcxx.F_RNAZK = dr["F_RNAZK"].ToString();
list1.Add(jcxx);
}
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
return;
}
finally
{
try
{
SplashScreenManager.CloseDefaultWaitForm();
}
catch
{
}
}
if (list1.Any() == false)
{
XtraMessageBox.Show("没有找到任何结果!");
}
tJCXXBindingSource.DataSource = list1;
gridView1.RefreshData();
gridView1.ExpandAllGroups();
gridView1.BestFitColumns();
}