/// <summary>
/// 获取病人列表
/// </summary>
/// <param name="qc"></param>
/// <returns></returns>
public override List <PhysicalExaminePatient> GetPatientList(QueryCondiction qc)
{
string sql = "select PatID,VIPID,PatName,Sex,Birth,PTFlag,RegDate,Charge,ChargeFlag from Pat_Info where ChargeFlag=0 and PTFlag='P' ";
if (!string.IsNullOrEmpty(qc.ExamineNo))
{
sql = sql + string.Format(" and PatID='{0}'", qc.ExamineNo);
}
if (!string.IsNullOrEmpty(qc.FileNo))
{
sql = sql + string.Format(" and VIPID='{0}'", qc.FileNo);
}
if (!string.IsNullOrEmpty(qc.Name))
{
sql = sql + string.Format(" and PatName like '{0}%'", qc.Name);
}
if (!string.IsNullOrEmpty(qc.Sex))
{
sql = sql + string.Format(" and Sex='{0}'", qc.Sex);
}
if (qc.ExamineBeginDate != null)
{
sql = sql + string.Format(" and RegDate>='{0} 00:00:00'", qc.ExamineBeginDate.Value.ToString("yyyy-MM-dd"));
}
if (qc.ExamineEndDate != null)
{
sql = sql + string.Format(" and RegDate<='{0} 23:59:59'", qc.ExamineEndDate.Value.ToString("yyyy-MM-dd"));
}
List <PhysicalExaminePatient> list = new List <PhysicalExaminePatient>();
DataTable tbList = pesDb.GetDataTable(sql);
foreach (DataRow row in tbList.Rows)
{
PhysicalExaminePatient pat = new PhysicalExaminePatient();
pat.ExamineNo = Convertor.IsNull(row["PatID"], "");
pat.FileNo = Convertor.IsNull(row["VIPID"], "");
pat.Name = Convertor.IsNull(row["PatName"], "");
pat.ExamineDate = Convert.ToDateTime(row["RegDate"]);
if (Convert.IsDBNull(row["Birth"]))
{
pat.BornDay = Convert.ToDateTime(row["Birth"]);
}
pat.Sex = Convertor.IsNull(row["Sex"], "未知");
pat.TotalCost = Convert.ToDecimal(row["Charge"]);
list.Add(pat);
}
return(list);
}
public override bool ExecCharge(PhysicalExaminePatient patient)
{
return(true);
}
/// <summary>
/// 执行划价
/// </summary>
/// <param name="patient"></param>
/// <returns></returns>
public override bool ExecPricing(PhysicalExaminePatient patient)
{
SystemCfg cfg1146 = new SystemCfg(1146, this.Database);
SystemCfg cfg1148 = new SystemCfg(1148, this.Database);
if (string.IsNullOrEmpty(cfg1146.Config))
{
throw new Exception("进行体检收费发生错误，该体检收费需要设置参数1146");
}
if (!Convertor.IsNumeric(cfg1146.Config))
{
throw new Exception("参数1146设置错误，必须为整数");
}
if (string.IsNullOrEmpty(cfg1148.Config))
{
throw new Exception("进行体检收费发生错误，没有设置体检费的执行科室(参数1148)");
}
if (!Convertor.IsNumeric(cfg1148.Config))
{
throw new Exception("参数1148设置错误，必须为整数");
}
int itemId = Convert.ToInt32(cfg1146.Config);
DataRow rowChargeItem = this.Database.GetDataRow(string.Format("select * from jc_hsitemdiction where jgbm={0} and item_id={1}", CurrentDept.Jgbm, itemId));
DataRow rowOrdrItem = this.Database.GetDataRow(string.Format("select * from JC_HOITEMDICTION where ORDER_ID in ( select HOITEM_ID from JC_HOI_HDI where TC_FLAG = 0 and TCID<=0 and HDITEM_ID = {0} )", itemId));
int tjksdm = Convert.ToInt32(cfg1148.Config); //体检科室代码
DateTime serverDate = DateManager.ServerDateTimeByDBType(Database);
Guid brxxid = Guid.Empty;
Guid ghxxid = Guid.Empty;
List <Guid> hjids = new List <Guid>();
string mzh = "";
try
{
Database.BeginTransaction();
//保存病人信息
ts_mz_class.YY_BRXX brxx = base.SavePatientInfo(patient);
//生成挂号记录
ghxxid = base.SaveRegisterRecord(brxx, tjksdm, 0, 0, serverDate, out mzh);
//生成划价数据
classes.hjcf cf = new classes.hjcf();
#region ...........
cf.hjid = Guid.Empty;
cf.jgbm = base.CurrentDept.Jgbm;
cf.brxxid = brxx.Brxxid;
cf.ghxxid = ghxxid;
cf.blh = mzh;
cf.cfrq = serverDate.ToString("yyyy-MM-dd HH:mm:ss");
cf.hjy = CurrentUser.EmployeeId;
cf.hjck = "";
cf.ysdm = 0;
cf.ksdm = tjksdm;
cf.zyksdm = 0;
cf.cfje = patient.TotalCost;
cf.zxks = tjksdm;
cf.xmly = 2;
cf.cfjs = 1;
cf.byscf = 0;
mz_hj.SaveCf(cf, Database);
if (cf.err_code != 0 || cf.NewHjid == Guid.Empty)
{
throw new Exception("保存划价数据失败:" + cf.err_text);
}
hjids.Add(cf.NewHjid);
#endregion
//生成划价明细
classes.hjcfmx cfmx = new ts_mz_class.classes.hjcfmx();
#region .................
cfmx.hjmxid = Guid.Empty;
cfmx.hjid = cf.NewHjid;
cfmx.pym = "";
cfmx.bm = "";
cfmx.pm = Convertor.IsNull(rowChargeItem["item_name"], "");
cfmx.spm = Convertor.IsNull(rowChargeItem["item_name"], "");
cfmx.gg = "";
cfmx.cj = "";
cfmx.dj = patient.TotalCost;
cfmx.sl = 1;
cfmx.dw = Convertor.IsNull(rowChargeItem["item_unit"], "");
cfmx.ydwbl = 1;
cfmx.js = 1;
cfmx.je = patient.TotalCost;
cfmx.tjdxmdm = Convertor.IsNull(rowChargeItem["statitem_code"], "");
cfmx.xmid = itemId;
cfmx.yl = 1;
cfmx.yldw = Convertor.IsNull(rowChargeItem["item_unit"], "");
cfmx.pcmc = "";
cfmx.ts = 1;
cfmx.zt = "";
cfmx.pxxh = 1;
cfmx.tcid = 0;
cfmx.yzid = Convert.ToInt32(rowOrdrItem["order_id"]);
cfmx.yzmc = Convertor.IsNull(rowOrdrItem["order_name"], "");
mz_hj.SaveCfmx(cfmx, Database);
if (cfmx.err_code != 0 || cfmx.NewHjmxid == Guid.Empty)
{
throw new Exception("保存划价明细失败");
}
#endregion
Database.CommitTransaction();
}
catch (Exception error)
{
Database.RollbackTransaction();
throw error;
}
string sql = string.Format("Update Pat_Info set His_RegNo = '{0}' where ChargeFlag=0 and PTFlag='P' and PatID = '{1}'", mzh, patient.ExamineNo);
pesDb.DoCommand(sql);
InvokeEvent(brxxid, ghxxid, hjids);
return(true);
}
