/// <summary> /// 查询门诊明细信息 /// </summary> /// <param name="sqlParam">处方号 REC_NO</param> public static void selectZYMX(Dictionary <string, string> sqlParam) { //--门诊明细信息 string sql = " select " + " a.rec_no, " // --处方号 + " a.item_code," //--HIS项目编码 + " a.price," // --HIS项目单价 + " a.qty, " // --项目数量 + " a.total, " //--项目总金额 + " b.item_name," // --HIS项目名称 + " b.item_cls," // --项目类型(1,2,3:药品 4,5,6,7,8,9:其他) + " c.standard," // --规格 + " c.small_unit, " // --单位 + " d.DR_CODE, " //--开单医生 + " (select oper_name from code_operator where oper_code=d.dr_code) as oper_name, " //--医生名称 + " d.dept_code," // --开单科室 + " (select dept_name from CODE_DEPARTMENT where dept_code=d.dept_code) as dept_name " //--科室名称 + " from CL_RECENTRY a,code_item b,plus_item c ,cl_recipe d " // + " where a.item_code<>'9999' " // + " and a.row_status='0' and a.rec_no='$REC_NO$' " //此处替换处方号(带空格) + " and a.rec_no = d.REC_NO" + " and a.item_code=b.item_code and b.item_code=c.item_code and c.type=2"; try { sql = sql.Replace("$REC_NO$", (sqlParam.ContainsKey("REC_NO") == true ? sqlParam["REC_NO"] : "")); DataTable dt = DBUtil.queryExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
/// <summary> /// 更新数据库操作 /// </summary> /// <param name="updateSql">更新SQL</param> /// <returns>修改的行数</returns> public static int updateExecute(string updateSql) { OracleConnection conn = null; OracleCommand cmd = null; try { conn = new OracleConnection(oracleConnString); conn.Open(); cmd = new OracleCommand(updateSql, conn); return(cmd.ExecuteNonQuery()); } catch (Exception ex) { XnhLogger.log("DBUtil.updateExecute" + ex.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } if (conn != null) { conn.Close(); } } return(-1); }
public string upload() { string retStr = ""; try { //单独传明细(调用保存药品交易) RJZ_Save_Row saveRow = new RJZ_Save_Row(); Dictionary <string, string> paramDict = new Dictionary <string, string>(); paramDict.Add("D505_02", ""); //住院登记流水号 paramDict.Add("COME_AREA", ""); //地区代码(医疗机构) paramDict.Add("AREA_CODE", ""); //病人地区编码(取前台选择的地区编码) paramDict.Add("D505_04", ""); //收费项目编码组合(此处因药品可能是多个,药品编码和下一个药品编码用分号分隔(下面的数量、单价、比例、收费项目唯一ID也一样) paramDict.Add("D505_08", ""); //收费项目数量组合 paramDict.Add("D505_07", ""); //收费项目单价组合 paramDict.Add("D505_09", ""); //收费项目比例组合 paramDict.Add("D505_ID_HIS", ""); //收费项目唯一ID组合(对应HIS) paramDict.Add("USER_ID", ""); //当前操作员id paramDict.Add("D504_14", ""); //诊治单位代码 paramDict.Add("USER_NAME", ""); //操作员姓名 paramDict.Add("LEVEL", ""); //诊治单位级别 saveRow.executeSql(paramDict); Dictionary <string, string> retDict = saveRow.getResponseResultWrapperMap(); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); } return(retStr); }
//create table zybc //(D401_10 VARCHAR2(18), 医疗证号 // D401_21 CHAR(2), 成员序号 // D504_01 VARCHAR2(24), 住院登记流水号(打印住院补偿凭据用到) // D504_21 VARCHAR2(40) 入院诊断 (费用上传会用) //) /// <summary> /// 根据选择的人员来来显示基础人员信息存储成员序号、医疗证号 /// </summary> /// <param name="sqlParam"></param> public static void insertZYBC(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("insertZYBC sqlParam参数为空"); return; } string sql = "insert into zybc(D401_10,D401_21,D504_21,D504_01,AREA_CODE) " + "select '$D401_10$','$D401_21$','$D504_01$','$D504_21$','$AREA_CODE$' from dual " + "where not exists (select * from zybc t where t.D401_10='$D401_10$' and t.D401_21='$D401_21$' )"; try { sql = sql.Replace("$D401_10$", (sqlParam.ContainsKey("D401_10") == true ? sqlParam["D401_10"] : "")); sql = sql.Replace("$D401_21$", (sqlParam.ContainsKey("D401_21") == true ? sqlParam["D401_21"] : "")); sql = sql.Replace("$D504_21$", (sqlParam.ContainsKey("D504_21") == true ? sqlParam["D504_21"] : "")); sql = sql.Replace("$D504_01$", (sqlParam.ContainsKey("D504_01") == true ? sqlParam["D504_01"] : "")); sql = sql.Replace("$AREA_CODE$", (sqlParam.ContainsKey("AREA_CODE") == true ? sqlParam["AREA_CODE"] : "")); DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
public string getMemberInfoDetail(string USER_ID, string AREA_NO, string D401_21) { string retStr = ""; try { //根据USER_ID获取缓存的新医疗卡号信息 string D401_10 = BufferUtil.getBufferByKey(USER_ID, "D401_10"); //查询成员基本信息 MZBC_Get_Member_Information getMemberInfo = new MZBC_Get_Member_Information(); getMemberInfo.executeSql( new Dictionary <string, string>() { { "AREA_NO", AREA_NO }, { "D401_10", D401_10 }, { "D401_21", D401_21 } } ); Dictionary <string, string> memberBaseInfo = getMemberInfo.getResponseResultWrapperMap(); //成员基本信息 retStr = DataConvert.Dict2Json(memberBaseInfo); retStr = DataConvert.getReturnJson("0", retStr); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } return(retStr); }
/// <summary> /// 入院登记保存时存储入院诊断、住院登记流水号 /// </summary> /// <param name="sqlParam"></param> public static void bcZYBC(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("bcZYBC sqlParam参数为空"); return; } //UPDATE zybc SET D504_21=D504_21,D504_01=D504_01 WHERE D401_10 = D401_10 AND D401_21 = D401_21; string sql = "UPDATE zybc t SET t.D504_21='$D504_21$',t.D504_01='$D504_01$',t.D504_09='$D504_09$' WHERE t.D401_10 = '$D401_10$' AND t.D401_21 = '$D401_21$'"; try { sql = sql.Replace("$D401_10$", (sqlParam.ContainsKey("D401_10") == true ? sqlParam["D401_10"] : "")); //医疗证号 sql = sql.Replace("$D401_21$", (sqlParam.ContainsKey("D401_21") == true ? sqlParam["D401_21"] : "")); //成员序号 sql = sql.Replace("$D504_21$", (sqlParam.ContainsKey("D504_21") == true ? sqlParam["D504_21"] : "")); //疾病代码 sql = sql.Replace("$D504_01$", (sqlParam.ContainsKey("D504_01") == true ? sqlParam["D504_01"] : "")); //住院登记流水号(农合返回的) sql = sql.Replace("$D504_09$", (sqlParam.ContainsKey("D504_09") == true ? sqlParam["D504_09"] : "")); //住院号 DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
public string getRYZD(string query) { string retStr = ""; try { //触发模糊查询的语句 string sql = "select t.BZ_CODE from XCYB_ML_ZG_BZML t where t.bz_name like '%" + query + "%'" + " or t.py_code like '%" + query + "%'"; //如果要限制返回结果的条数,比如限制每次返回前10条 //select t.BZ_CODE from XCYB_ML_ZG_BZML t where ( t.bz_name like '%1%' or t.py_code like '%1%') and rownum < 11 string sqlLimit = "select t.BZ_CODE from XCYB_ML_ZG_BZML t where (t.bz_name like '%" + query + "%'" + " or t.py_code like '%" + query + "%') and rownum < 11"; //返回查询结果,供前台绑定 DataTable dt = DBUtil.queryExecute(sql); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { retStr += dr["BZ_CODE"].ToString() + ","; } retStr = retStr.Substring(0, retStr.Length - 1); } } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } return(retStr); }
public string bclb(string AREA_NO) { string retStr = ""; try { RJZ_Get_S301_06_Zy zy = new RJZ_Get_S301_06_Zy(); zy.executeSql(new Dictionary <string, string>() { { "AREA_NO", AREA_NO } }); if (zy.getExecuteStatus() == true && zy.getExecuteResultPlainString().Length > 2) { // 0 成功 // 1 失败 未找到该信息 // 成功返回: // S_Returns=0;ITEM_CODE/ ITEM_NAME; ITEM_CODE/ ITEM_NAME // ITEM_CODE:VARCHAR2(3) 补偿类别编码 // ITEM_NAME:VARCHAR2(64) 补偿类别名称 retStr = DataConvert.getReturnJson("0", zy.getExecuteResultPlainString().Substring(2)); } else { retStr = DataConvert.getReturnJson("-1", zy.getExecuteResultPlainString()); } } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } return(retStr); }
/// <summary> /// 存储住院结算返回费用,后期做报表 /// create table ZYJS /// ( NAME VARCHAR2(16), -- 姓名() /// IP_NO VARCHAR2(24), -- 住院号() /// D504_01 VARCHAR2(24),-- 住院登记流水号 /// TOTAL_COSTS NUMBER(8,2), -- 住院总费用 /// ZF_COSTS NUMBER(8,2), --自费金额 /// TOTAL_CHAGE NUMBER(8,2), -- 住院可补偿金额 /// D506_23 NUMBER(8,2), -- 实际补偿额 /// D506_18 NUMBER(8,2), -- 核算补偿金额 /// BEGINPAY NUMBER(8,2), --起伏线 /// SCALE NUMBER(3,2), --报销比例 /// HEAV_REDEEM_SUM NUMBER(8,2), --大病支付金额 /// REDEEM_TOTAL NUMBER(8,2), --单次补偿合计 /// BILL_TIME CHAR(30), --结算时间(取结算系统时间) /// AREA_CODE VARCHAR2(24) --地区编码 /// ) /// </summary> /// <param name="sqlParam"></param> public static void CCZYJS(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("ZYJS sqlParam参数为空"); return; } string sql = "insert into ZYJS(NAME,IP_NO,D504_01,TOTAL_COSTS,ZF_COSTS,TOTAL_CHAGE,D506_23,D506_18,BEGINPAY,HEAV_REDEEM_SUM,BILL_TIME,AREA_CODE) " + "values ('$NAME$','$IP_NO$','$D504_01$','$TOTAL_COSTS$','$ZF_COSTS$','$TOTAL_CHAGE$','$D506_23$','$D506_18$','$BEGINPAY$','$HEAV_REDEEM_SUM$','$BILL_TIME$','$AREA_CODE$')"; try { sql = sql.Replace("$NAME$", (sqlParam.ContainsKey("NAME") == true ? sqlParam["NAME"] : "")); sql = sql.Replace("$IP_NO$", (sqlParam.ContainsKey("IP_NO") == true ? sqlParam["IP_NO"] : "")); sql = sql.Replace("$D504_01$", (sqlParam.ContainsKey("D504_01") == true ? sqlParam["D504_01"] : "")); sql = sql.Replace("$TOTAL_COSTS$", (sqlParam.ContainsKey("TOTAL_COSTS") == true ? sqlParam["TOTAL_COSTS"] : "")); sql = sql.Replace("$ZF_COSTS$", (sqlParam.ContainsKey("ZF_COSTS") == true ? sqlParam["ZF_COSTS"] : "")); sql = sql.Replace("$TOTAL_CHAGE$", (sqlParam.ContainsKey("TOTAL_CHAGE") == true ? sqlParam["TOTAL_CHAGE"] : "")); sql = sql.Replace("$D506_23$", (sqlParam.ContainsKey("D506_23") == true ? sqlParam["D506_23"] : "")); sql = sql.Replace("$D506_18$", (sqlParam.ContainsKey("D506_18") == true ? sqlParam["D506_18"] : "")); sql = sql.Replace("$BEGINPAY$", (sqlParam.ContainsKey("BEGINPAY") == true ? sqlParam["BEGINPAY"] : "")); sql = sql.Replace("$SCALE$", (sqlParam.ContainsKey("SCALE") == true ? sqlParam["SCALE"] : "")); sql = sql.Replace("$HEAV_REDEEM_SUM$", (sqlParam.ContainsKey("HEAV_REDEEM_SUM") == true ? sqlParam["HEAV_REDEEM_SUM"] : "")); sql = sql.Replace("$REDEEM_TOTAL$", (sqlParam.ContainsKey("REDEEM_TOTAL") == true ? sqlParam["REDEEM_TOTAL"] : "")); sql = sql.Replace("$BILL_TIME$", (sqlParam.ContainsKey("BILL_TIME") == true ? sqlParam["BILL_TIME"] : "")); sql = sql.Replace("$AREA_CODE$", (sqlParam.ContainsKey("AREA_CODE") == true ? sqlParam["AREA_CODE"] : "")); DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
///以对吗 public static DataTable fetchHIS2() { string sql = ""; try { sql = "select * from (select a.item_code, " //--his编码 + "a.item_name, " // --his项目名称 + "(select wydm from xnh_dm where xnh_dm.item_code = a.item_code) as nh_code, " // --农合中心编码 + " (select ypmc from xnh_ypzl,xnh_dm where xnh_ypzl.wydm = xnh_dm.wydm and xnh_dm.item_code = a.item_code) as nh_name, " //--农合名称 + " a.item_cls, " //--项目类别123药品,其他诊疗 + " a.py_code, " // --拼音码 + " b.standard, " //--规格 + "b.small_unit, " // --单位 + " b.ret_price " // --价格 + " from code_item a,plus_item b " + " where b.type = '3' and a.item_code = b.item_code order by a.item_code) h where h.nh_code is not null"; DataTable dt = DBUtil.queryExecute(sql); return(dt); } catch (Exception ex) { XnhLogger.log("his药品数据提取:sql=" + sql + " 异常:" + ex.StackTrace); } return(null); }
///提取农合药品编码 /// </summary> public static DataTable fetchXNH(string ypdm) { string sql = ""; try { sql = "select cxgjz, " // --拼音码 + "wydm, " //--农合中心编码 + " ypfl," //--药品分类 + " ypmc, " //--药品名称 + " gg, " //--规格 + " dw, " //--单位 + " dj, " //--单价 + " bxbl, " //--报销比例 + " bnbw, " //--1报内0保外 + "jyl, " //--甲乙类(0:甲类,1乙类,2:不区分) + "jyfjy " //--基药非基药(0:基药 1:非基药) + " from xnh_ypzl a " + " where a.cxgjz like '%" + ypdm + "%' or a.wydm like '%" + ypdm + "%' or a.ypmc like '%" + ypdm + "%' "; DataTable dt = DBUtil.queryExecute(sql); return(dt); } catch (Exception ex) { XnhLogger.log("农合药品数据提取:sql=" + sql + " 异常:" + ex.StackTrace); } return(null); }
/// <summary> /// 数据库查询 /// </summary> /// <param name="querySql">查询SQL</param> /// <returns>DataTable</returns> public static DataTable queryExecute(string querySql) { OracleConnection conn = null; OracleCommand cmd = null; try { conn = new OracleConnection(oracleConnString); conn.Open(); cmd = new OracleCommand(querySql, conn); OracleDataAdapter oda = new OracleDataAdapter(cmd); DataTable dt = new DataTable(); oda.Fill(dt); return(dt); } catch (Exception ex) { XnhLogger.log("DBUtil.queryExecute" + ex.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } if (conn != null) { conn.Close(); } } return(null); }
public string zydj(string user_id) { string retStr = ""; try { ZYBC_PROC_NEW_NOTICE newNotice = new ZYBC_PROC_NEW_NOTICE(); Dictionary <string, string> paramDict = new Dictionary <string, string>(); //todo:参数需要HIS传值 paramDict.Add("COME_AREA", ""); //医疗机构所在地区编码(取用户所在机构地区编码AREA_CODE) paramDict.Add("AREA_CODE", ""); //地区代码(病人所在地区编码)取前台选择的地区编码 paramDict.Add("D401_10", ""); //医疗证号 paramDict.Add("D504_02", ""); //个人编号 paramDict.Add("D504_03", ""); //姓名 paramDict.Add("D504_04", ""); //性别(1:男 2:女)传代码 paramDict.Add("D504_05", ""); //身份证号 paramDict.Add("D504_06", ""); //年龄 paramDict.Add("D504_21", ""); //疾病代码 paramDict.Add("D504_09", ""); //住院号 paramDict.Add("D504_10", ""); //就诊类型代码(对应s301_05.xls) paramDict.Add("D504_11", ""); //入院时间(格式为YYYY-MM-DD) paramDict.Add("D504_14", ""); //就医机构代码=DEP_ID paramDict.Add("D504_19", ""); //入院状态代码 (对应S301-02.xls) paramDict.Add("D504_16", ""); //入院科室代码(对应S201-03.xls) paramDict.Add("D504_28", ""); //病人联系电话 newNotice.executeSql(paramDict); if (newNotice.getExecuteStatus() == true) { //保存成功:S_Returns= 0;D504_01 //D504_01:VARCHAR2(24) 住院登记流水号 //保存失败: S_Returns= 1;错误信息 (分号分隔) Dictionary <string, string> dictRet = newNotice.getResponseResultWrapperMap(); string D504_01 = dictRet["D504_01"]; //缓存住院登记流水号D504_01 BufferUtil.setBuffer(user_id, "D504_01", D504_01); retStr = DataConvert.getReturnJson("0", "success"); } else { retStr = DataConvert.getReturnJson("-1", "fail"); } } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } return(retStr); }
public string qxzydj(string user_id) { string retStr = ""; try { //retStr = DataConvert.getReturnJson("0", user_id); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } XnhLogger.log(retStr); return(retStr); }
public string plcmx(string data) { string retStr = ""; try { //todo:由HIS提供字段信息 retStr = DataConvert.getReturnJson("-1", "data=" + data + " 待由HIS提供字段数据"); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } return(retStr); }
public string czlpcx(string query) { string retStr = ""; try { //todo:由HIS提供视图或查询字段绑定 retStr = DataConvert.getReturnJson("-1", "query=" + query + " 冲正理赔查询待由HIS提供视图或查询字段完成数据绑定"); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } return(retStr); }
public string login(string name, string pwd) { string retVal = ""; try { //todo:HIS系统先验证用户名和密码 //调用接口认证 LoginAuth service = new LoginAuth(); //直接塞参数进入Dictionary,由框架自动组装顺序 Dictionary <string, string> requestParam = new Dictionary <string, string>(); requestParam.Add("USER_CODE", name); requestParam.Add("USER_PASS", pwd); //使用executeSql重载的Dictionary参数方法 string response = service.executeSql(requestParam); Dictionary <string, string> responseDict = service.getResponseResultWrapperMap(); //登录失败 if (service.getExecuteStatus() == false) { retVal = ""; //记日志 XnhLogger.log(this.GetType().ToString() + service.getExecuteResultPlainString()); } else { //登录成功,缓存用户信息,服务器缓存以每个用户的user_id作为区分的cookie string user_id = responseDict["USER_ID"]; foreach (KeyValuePair <string, string> item in responseDict) { BufferUtil.setBuffer(user_id, item.Key, item.Value); } retVal = MsgConvert.Dict2Json(responseDict); } } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retVal = ""; } return(retVal); }
public string getBCLB(string AREA_NO) { try { MZBC_Get_S301_06 s301 = new MZBC_Get_S301_06(); //补偿类别返回结果 0;ITEM_CODE/ITEM_NAME;ITEM_CODE/ITEM_NAME string retStr = s301.executeSql(new Dictionary <string, string>() { { "AREA_NO", AREA_NO } }); //返回格式ITEM_CODE/ITEM_NAME;ITEM_CODE/ITEM_NAME return((string)s301.getResponseResultOtherWrapper()); }catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " getBCLB " + ex.StackTrace); } return(""); }
public static DataTable getMZMX(Dictionary <string, string> sqlParam) { DataTable dt = null; string sql = ""; try { //门诊明细信息 sql = "select" + " a.rec_no," //处方号 + " a.item_code," //HIS项目编码 + " a.price," //HIS项目单价 + "(select wydm from xnh_dm where xnh_dm.item_code = b.item_code ) as nh_bm, " // --农合编码 + "(select bxbl from xnh_ypzl ,xnh_dm where xnh_ypzl.wydm = xnh_dm.wydm and xnh_dm.item_code = b.item_code) as nh_bnw," //报销比例 + " a.qty," //项目数量 + " a.total," //项目总金额 + " b.item_name," //HIS项目名称 + " b.item_cls," //项目类型(1,2,3:药品 4,5,6,7,8,9:其他) + " c.standard," //规格 + " c.small_unit," //单位 + " d.DR_CODE," //开单医生 + " (select oper_name from code_operator where oper_code=d.dr_code) as oper_name," //医生名称 + " d.dept_code," //开单科室 + " (select dept_name from CODE_DEPARTMENT where dept_code=d.dept_code) as dept_name" //科室名称 + " from CL_RECENTRY a,code_item b,plus_item c ,cl_recipe d" + " where a.item_code<>'9999'" + " and a.row_status='0' and a.rec_no='$REC_NO$' and a.item_code = '$ITEM_CODE$' " + " and a.rec_no = d.REC_NO" + " and a.item_code=b.item_code and b.item_code=c.item_code and c.type=2"; sql = sql.Replace("$REC_NO$", (sqlParam.ContainsKey("REC_NO") == true ? sqlParam["REC_NO"] : "")); sql = sql.Replace("$ITEM_CODE$", (sqlParam.ContainsKey("ITEM_CODE") == true ? sqlParam["ITEM_CODE"] : "")); dt = DBUtil.queryExecute(sql); } catch (Exception ex) { XnhLogger.log("sql=" + sql + " 异常:" + ex.ToString()); } return(dt); }
///门诊冲正删除存储的费用信息 /// </summary> public static void deleteCCMZJS(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("deleteCCMZJS sqlParam参数为空"); return; } string sql = "delete from MZJS where T_D502_01 = T_D502_01 and D401_02 = D401_02"; try { sql = sql.Replace("$T_D502_01$", (sqlParam.ContainsKey("T_D502_01") == true ? sqlParam["T_D502_01"] : "")); sql = sql.Replace("$D401_02$", (sqlParam.ContainsKey("D401_02") == true ? sqlParam["D401_02"] : "")); DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
public string charge(string user_id, string DIAGNOSIS_CODE) { try { //(1)收费 RJZ_shoufei shoufei = new RJZ_shoufei(); Dictionary <string, string> paramDict = new Dictionary <string, string>(); paramDict.Add("AREA_CODE", ""); //病人地区编码(取前台选择的地区编码) paramDict.Add("D504_01", ""); //住院登记流水号 paramDict.Add("D504_12", ""); //出院时间(格式为YYYY-MM-DD) paramDict.Add("D504_15", ""); //就医机构级别(相关数据代码标准:S201-06) paramDict.Add("D504_17", ""); //出院科室(相关数据代码标准:S201-03) paramDict.Add("D504_18", ""); //经治医生 paramDict.Add("D504_20", ""); //出院状态(相关数据代码标准:S301-03) paramDict.Add("D504_22", ""); //并发症(为空时传’NULL’) paramDict.Add("D506_03", ""); //总费用(TOTAL_COSTS 总费用)试算得到 paramDict.Add("D506_13", ""); //可补偿住院医药费(TOTAL_CHAGE 合理费用)试算得到 paramDict.Add("D506_18", ""); //核算补偿金额(D506_18 核算补偿金额(实际补偿合计额))试算得到 paramDict.Add("D506_15", ""); //补偿类别代码 paramDict.Add("D506_14", ""); //补偿账户类别(相关数据代码标准:S301-09) paramDict.Add("D506_16", ""); //核算机构(代码) paramDict.Add("D506_17", ""); //核算人 paramDict.Add("D506_23", ""); //实际补偿额(D506_23 实际补偿金额)试算得到 paramDict.Add("D506_26", ""); //付款人 paramDict.Add("D506_27", ""); //中途结算标志(相关数据代码标准:S701-01) paramDict.Add("SELF_PAY", ""); //自费金额(ZF_COSTS 自费费用)试算得到 paramDict.Add("HEAV_REDEEM_SUM", ""); //大病支付金额(HEAV_REDEEM_SUM 大病支付额)试算得到 paramDict.Add("BEGINPAY", ""); //本次起付额(BEGINPAY 本次起伏线)试算得到 paramDict.Add("D504_29", ""); //出院诊断(疾病代码) shoufei.executeSql(paramDict); //(2)收费成功后将相应的信息保存到数据库中,并修改HIS中补偿标志(供以后制作报表查询使用) } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " diagnosisCheck " + ex.StackTrace); } return(null); }
/// <summary> ///门诊冲正修改his标记 /// </summary> public static void modifyMZCZBJ(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("modifyMZCZBJ sqlParam参数为空"); return; } string sql = "UPDATE cl_recipe SET yb_up = '0' where rec_no = '$REC_NO$' and reg_no = '$REG_NO$' "; try { sql = sql.Replace("0", (sqlParam.ContainsKey("yb_up") == true ? sqlParam["yb_up"] : "")); sql = sql.Replace("$REC_NO$", (sqlParam.ContainsKey("rec_no") == true ? sqlParam["rec_no"] : "")); sql = sql.Replace("$REG_NO$", (sqlParam.ContainsKey("reg_no") == true ? sqlParam["reg_no"] : "")); DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
/// <summary> /// 删除入院登记 /// </summary> /// <param name="sqlParam"></param> public static void scZYBC(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("scZYBC sqlParam参数为空"); return; } //delete from zybc where D504_01 = D504_01; string sql = "delete from zybc where D504_01 = '$D504_01$'"; try { sql = sql.Replace("$D504_01$", (sqlParam.ContainsKey("D504_01") == true ? sqlParam["D504_01"] : "")); DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
public string delete_item() { string retStr = ""; try { RJZ_PROC_DELETE_PRICE_LIST deleteList = new RJZ_PROC_DELETE_PRICE_LIST(); Dictionary <string, string> paramDict = new Dictionary <string, string>(); paramDict.Add("AREA_CODE", ""); //病人地区编码(取前台选择的地区编码) paramDict.Add("D504_01", ""); //住院登记流水号 paramDict.Add("START_DATE", ""); //收费项目录入起始时间(为空时传’NULL’) (格式为YYYY-MM-DD) paramDict.Add("END_DATE", ""); //收费项目录入结束时间(为空时传’NULL’) (格式为YYYY-MM-DD) deleteList.executeSql(paramDict); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); } return(retStr); }
public string zuofei() { string retStr = ""; try { //作废单个收费项目 RJZ_PROC_DELETE_PRICE_LIST_PER deleteListPer = new RJZ_PROC_DELETE_PRICE_LIST_PER(); Dictionary <string, string> paramDict = new Dictionary <string, string>(); paramDict.Add("AREA_CODE", ""); //病人地区编码(取前台选择的地区编码) paramDict.Add("D504_01", ""); //住院登记流水号 paramDict.Add("HIS_ID", ""); //对应HIS项目唯一ID deleteListPer.executeSql(paramDict); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); } return(retStr); }
public string getRYZD(string query) { string retStr = ""; try { //触发模糊查询的语句 string sql = "select t.BZ_CODE from XCYB_ML_ZG_BZML t where t.bz_name like '%" + query + "%'" + " or t.py_code like '%" + query + "%'"; //如果要限制返回结果的条数,比如限制每次返回前10条 //select t.BZ_CODE from XCYB_ML_ZG_BZML t where ( t.bz_name like '%1%' or t.py_code like '%1%') and rownum < 11 string sqlLimit = "select t.BZ_CODE,t.BZ_NAME,t.PY_CODE from XCYB_ML_ZG_BZML t where (t.bz_name like '%" + query + "%'" + " or t.py_code like '%" + query + "%') and rownum < 21"; //日志查询后台SQL XnhLogger.log(sqlLimit); //返回查询结果,供前台绑定 DataTable dt = DBUtil.queryExecute(sqlLimit); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { string BZ_CODE = dr["BZ_CODE"] as string; string BZ_NAME = dr["BZ_NAME"] as string; string PY_CODE = dr["PY_CODE"] as string; if (string.IsNullOrEmpty(BZ_CODE) == false && BZ_CODE.Trim() != "") { retStr += BZ_CODE.Trim() + "|" + BZ_NAME + "|" + PY_CODE + ","; } } retStr = retStr.Substring(0, retStr.Length - 1); } //XnhLogger.log(retStr); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = "查询错误,请查看日志"; } return(retStr); }
/// <summary> ///增加取消对码功能 /// </summary> /// <param name="sqlParam"></param> public static void qxdmgn(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("bcZYBC sqlParam参数为空"); return; } //UPDATE zybc SET D504_21=D504_21,D504_01=D504_01 WHERE D401_10 = D401_10 AND D401_21 = D401_21; string sql = "delete from xnh_dm where item_code = '$HIS$' and wydm = '$NH$' "; try { sql = sql.Replace("$HIS$", (sqlParam.ContainsKey("item_code") == true ? sqlParam["item_code"] : "")); sql = sql.Replace("$NH$", (sqlParam.ContainsKey("wydm") == true ? sqlParam["wydm"] : "")); DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
/// <summary> ///增加对码功能 /// </summary> /// <param name="sqlParam"></param> public static void zjdmgn(Dictionary <string, string> sqlParam) { if (sqlParam == null || sqlParam.Count == 0) { XnhLogger.log("bcZYBC sqlParam参数为空"); return; } string sql = "insert into xnh_dm (item_code,wydm) values ('$HIS$','$NH$')"; try { sql = sql.Replace("$HIS$", (sqlParam.ContainsKey("HIS") == true ? sqlParam["HIS"] : "")); sql = sql.Replace("$NH$", (sqlParam.ContainsKey("NH") == true ? sqlParam["NH"] : "")); DBUtil.updateExecute(sql); } catch (Exception ex) { XnhLogger.log(ex.ToString() + " SQL:" + sql); } }
public string zhyChaxun(string zyh) { string retStr = ""; try { //todo:查询HIS string sql = ""; //查询HIS的SQL DataTable dt = new DataTable(); dt = DBUtil.queryExecute(sql); //todo:返回的DataTable数据,可以通过调用DataTable2Json转为JSON格式,方便前台JavaScript处理和绑定 string msg = DataConvert.DataTable2Json(dt); retStr = DataConvert.getReturnJson("0", msg); } catch (Exception ex) { XnhLogger.log(this.GetType().ToString() + " " + ex.StackTrace); retStr = DataConvert.getReturnJson("-1", ex.ToString()); } return(retStr); }
/// 查询住院明细 public static DataTable cxzymx1(string reg_no) { string sql = ""; try { sql = "select " + "b.ip_no, " //--住院号 + "a.reg_no, " + "a.item_code, " //--HIS项目编码 + "price, " //--HIS项目单价 + "(select wydm from xnh_dm where xnh_dm.item_code = a.item_code) as nh_bm, " //农合编码 + "(select bxbl from xnh_ypzl where xnh_ypzl.wydm = d.wydm and d.item_code = a.item_code) as nh_bnw, " //--报销比例 + "qty, " //--HIS项目数量 + "total, " //--HIS项目总价格 + "bill_time, " //--记账时间 + "a.basic_cls, " //多条同批次缺库存,其他批次收费标志 + "pre_no, " //--医嘱编号 + "a.up_flag, " //--上传标志 + "standard, " //--规格 + "small_unit, " //--单位 + "(select item_cls from code_item where item_code=a.item_code ) as item_cls, " //--项目类型(1,2,3:药品 4,5,6,7,8,9:其他) + "(select item_name from code_item where item_code=a.item_code ) as item_name " //--项目名称 + "from " + "IP_BILL a left join IP_REGISTER b on a.reg_no=b.reg_no ,plus_item c left join xnh_dm d on c.item_code = d.item_code " + "where " + "c.item_code=a.item_code and c.type=3 and a.reg_no='" + reg_no + "' " + "order by bill_time,a.item_code "; DataTable dt = DBUtil.queryExecute(sql); return(dt); } catch (Exception ex) { XnhLogger.log("查询住院明细:sql=" + sql + " 异常:" + ex.StackTrace); } return(null); }