public long m_lngDoAddNewModule(System.Security.Principal.IPrincipal p_objPrincipal, string p_strModuleName, string p_strEngName, string p_strPYCode, string p_strWBCode, out string p_strID)
{
long lngRes = 0;
p_strID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsUsageSvc", "m_lngDoAddNewModule");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "MODULEID_CHR", "T_SYS_MODULE", out p_strID);
if (lngRes < 0)
{
return(-1);
}
string strSQL = "INSERT INTO T_SYS_MODULE (MODULEID_CHR, MODULENAME_CHR, ENGNAME_CHR, PYCODE_CHR, WBCODE_CHR) VALUES " +
" ('" + p_strID + "' , '" + p_strModuleName + "', '" + p_strEngName + "', '" + p_strPYCode + "', '" + p_strWBCode + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNew(System.Security.Principal.IPrincipal p_objPrincipal, com.digitalwave.iCare.ValueObject.clsHISMedType_VO objTD_VO, out com.digitalwave.iCare.ValueObject.clsHISMedType_VO objTD_VOReturn)
{
long lngRes = 0;
string strRecordID = "";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsHISMedTypeManageSvc", "m_lngAddNew");
lngRes = objHRPSvc.lngGenerateID(5, "PHARMAID_CHR", "T_BSE_PHARMATYPE", out strRecordID);
objTD_VO.m_strPHARMAID_CHR = strRecordID;
//把结果输出：
objTD_VOReturn = objTD_VO;
if (lngRes < 0)
{
return(-1);
}
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO T_BSE_PHARMATYPE (PHARMAID_CHR,PHARMANAME_VCHR,ASSISTCODE_VCHR,PYCODE_VCHR,WBCODE_VCHR,PARENTID_CHR) VALUES (?,?,?,?,?,?)";
try
{
System.Data.IDataParameter[] objLisAddItemRefArr = null;
objHRPSvc.CreateDatabaseParameter(6, out objLisAddItemRefArr);
//Please change the datetime and reocrdid
objLisAddItemRefArr[0].Value = objTD_VO.m_strPHARMAID_CHR;
objLisAddItemRefArr[1].Value = objTD_VO.m_strPHARMANAME_VCHR;
objLisAddItemRefArr[2].Value = objTD_VO.m_strASSISTCODE_VCHR;
objLisAddItemRefArr[3].Value = objTD_VO.m_strPYCODE_VCHR;
objLisAddItemRefArr[4].Value = objTD_VO.m_strWBCODE_VCHR;
objLisAddItemRefArr[5].Value = objTD_VO.m_strPARENTID_CHR;
long lngRecEff = -1;
//往表增加记录
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objLisAddItemRefArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoAddNewChargeItemUsageGroup(System.Security.Principal.IPrincipal p_objPrincipal, out string p_strRecordID, clsChargeItemUsageGroup_VO p_objRecord)
{
long lngRes = 0;
p_strRecordID = "";
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsCmCookingMethodItemGroupSvc", "m_lngDoAddNewChargeItemUsageGroup");
if (lngRes < 0)
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGenerateID(4, "ROWNO_CHR", "t_aid_cmcookingmethoditemgroup", out p_strRecordID);
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO t_aid_cmcookingmethoditemgroup (ROWNO_CHR,USAGEID_CHR,ITEMID_CHR,QTY_DEC,CLINICTYPE_INT,BIHQTY_DEC,BIHTYPE_INT,CONTINUEUSETYPE_INT) VALUES (?,?,?,?,?,?,?,?)";
try
{
System.Data.IDataParameter[] objLisAddItemRefArr = null;
objHRPSvc.CreateDatabaseParameter(8, out objLisAddItemRefArr);
objLisAddItemRefArr[0].Value = p_strRecordID; //p_objRecord.m_strROWNO_CHR;
objLisAddItemRefArr[1].Value = p_objRecord.m_strUsageID;
objLisAddItemRefArr[2].Value = p_objRecord.m_strItemID;
objLisAddItemRefArr[3].Value = p_objRecord.m_strUNITPRICE;
objLisAddItemRefArr[4].Value = p_objRecord.m_intCLINICTYPE_INT;
objLisAddItemRefArr[5].Value = p_objRecord.m_dblBIHQTY_DEC;
objLisAddItemRefArr[6].Value = p_objRecord.m_intBIHTYPE_INT;
objLisAddItemRefArr[7].Value = p_objRecord.m_intCONTINUEUSETYPE_INT;
long lngRecEff = -1;
//往表增加记录
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objLisAddItemRefArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNewPatientPayType(System.Security.Principal.IPrincipal p_objPrincipal, clstPatientPaytype_VO objResult, out string p_strRecordID)
{
long lngRes = 0;
p_strRecordID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngAddNewPatientPayType");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "PAYTYPEID_CHR", "t_bse_patientPaytype", out p_strRecordID);
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = @"INSERT INTO t_bse_patientPaytype (PAYTYPEID_CHR,PAYTYPENAME_VCHR,MEMO_VCHR,PAYLIMIT_MNY,PAYFLAG_DEC,PAYPERCENT_DEC,PAYTYPENO_VCHR,COPAYID_CHR,CHARGEPERCENT_DEC,INTERNALFLAG_INT,COALITIONRECIPEFLAG_INT,BIHLIMITRATE_DEC) VALUES ('" +
p_strRecordID + "','" + objResult.m_strPAYTYPENAME_VCHR + "','" + objResult.m_strMEMO_VCHR + "','" + objResult.m_strPAYLIMIT_MNY + "','" + objResult.m_strPAYFLAG_DEC + "','" + objResult.m_strPAYPERCENT_DEC + "','" +
objResult.m_strPAYTYPENO_VCHR + "','" + objResult.m_strCOPAYID_CHR + "','" +
objResult.m_strCHARGEPERCENT_DEC + "'," + objResult.m_intINTERNALFLAG_INT + "," + objResult.m_strCOALITIONRECIPEFLAG_INT + "," + objResult.m_strBIHLIMITRATE_DEC + ")";
string strSQL2 = "insert into t_aid_InsChargeItem (PRECENT_DEC,ITEMID_CHR,COPAYID_CHR) " +
" select 100 as PRECENT_DEC, ItemID_chr,'" + p_strRecordID + "' as COPAYID_CHR from t_bse_ChargeItem ";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
lngRes = objHRPSvc.DoExcute(strSQL2);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNewINSCOPAY(System.Security.Principal.IPrincipal p_objPrincipal, clsInsPay_VO p_objRecord, out string p_strRecordID)
{
long lngRes = 0;
p_strRecordID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngAddNewINSCOPAY");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "COPAYID_CHR", "T_AID_INSCOPAY", out p_strRecordID);
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO T_AID_INSCOPAY (COPAYID_CHR,COPAYNAME_CHR,PRECENT_DEC,USERCODE_CHR,REMARK_VCHR,PLANID_CHR) VALUES ('" + p_strRecordID + "','" + p_objRecord.m_strCOPAYNAME_CHR + "','" + p_objRecord.m_dblPRECENT_DEC + "','" + p_objRecord.m_strUSERCODE_CHR + "','" + p_objRecord.m_strREMARK_VCHR + "','" + p_objRecord.m_strPLANID_CHR + "')";
string strSQL2 = "insert into t_aid_InsChargeItem (PRECENT_DEC,ITEMID_CHR,COPAYID_CHR) " +
" select 100 as PRECENT_DEC, ItemID_chr,'" + p_strRecordID + "' as COPAYID_CHR from t_bse_ChargeItem ";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
lngRes = objHRPSvc.DoExcute(strSQL2);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoAddNewRegType(System.Security.Principal.IPrincipal p_objPrincipal, clsRegType_VO objResult, out string p_strID)
{
long lngRes = 0;
p_strID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegTypeSvc", "m_lngDoAddNewRegType");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "REGISTERTYPEID_CHR", "T_BSE_REGISTERTYPE", out p_strID);
if (lngRes < 0)
{
return(-1);
}
// string strSQL = "INSERT INTO T_BSE_REGISTERTYPE (REGISTERTYPEID_CHR, REGISTERTYPENAME_VCHR, MEMO_VCHR ,REGISTERTYPENO_VCHR,ISDOCTOR_NUM) VALUES " +
// " ('" + p_strID + "' , '" + objResult.m_strRegTypeName + "', '" + objResult.m_strRegTypeMemo + "', '" + objResult.m_strRegTypeNo+ "', '" + objResult.m_strIsDoctor + "')";
//xigui.peng 修改
string strSQL = "INSERT INTO T_BSE_REGISTERTYPE (REGISTERTYPEID_CHR, REGISTERTYPENAME_VCHR, MEMO_VCHR ,REGISTERTYPENO_VCHR,ISDOCTOR_NUM,URGENCY_INT) VALUES " +
" ('" + p_strID + "' , '" + objResult.m_strRegTypeName + "', '" + objResult.m_strRegTypeMemo + "', '" + objResult.m_strRegTypeNo + "', '" + objResult.m_strIsDoctor + "','" + objResult.m_strIsUrgency + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNewRecipeFrequencyType(System.Security.Principal.IPrincipal p_objPrincipal, clsRecipefreq_VO objResult, out string p_strRecordID)
{
long lngRes = 0;
p_strRecordID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngAddNewRecipeFrequencyType");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "to_number(FREQID_CHR)", "t_aid_recipefreq", out p_strRecordID);
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO t_aid_recipefreq (FREQID_CHR,FREQNAME_CHR ,USERCODE_CHR,TIMES_INT,DAYS_INT,OPFREDESC_VCHR) VALUES ('" + p_strRecordID + "','" + objResult.m_strFREQNAME_CHR + "','" + objResult.m_strUSERCODE_CHR + "','" + objResult.m_intTIMES_INT + "','" + objResult.m_intDAYS_INT + "','" + objResult.m_strOPFreqDesc + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNewINSCOMPANYD(System.Security.Principal.IPrincipal p_objPrincipal, clsInsCompany_VO p_objRecord, out string p_strRecordID)
{
long lngRes = 0;
p_strRecordID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngAddNewRegChargeType");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "COMPANYID_CHR", "T_AID_INSCOMPANY", out p_strRecordID);
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO T_AID_INSCOMPANY (COMPANYID_CHR,COMPANYNAME_CHR,USERCODE_CHR,REMARK_VCHR) VALUES ('" + p_strRecordID + "','" + p_objRecord.m_strCOMPANYNAME_CHR + "','" + p_objRecord.m_strUSERCODE_CHR + "','" + p_objRecord.m_strREMARK_VCHR + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNewRegChargeType(System.Security.Principal.IPrincipal p_objPrincipal, clsRegchargeType_VO objResult, out string p_strRecordID)
{
long lngRes = 0;
p_strRecordID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegChargeTypeSvc", "m_lngAddNewRegChargeType");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(3, "CHARGEID_CHR", "t_bse_registerchargetype", out p_strRecordID);
if (lngRes < 0)
{
return(lngRes);
}
string strSQL = "INSERT INTO t_bse_registerchargetype (CHARGEID_CHR,CHARGENAME_CHR,MEMO_VCHR,CHARGENO_VCHR) VALUES ('" + p_strRecordID + "','" + objResult.m_strCHARGENAME_CHR + "','" + objResult.m_strMEMO_VCHR + "','" + objResult.m_strCHARGENO_VCHR + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngDoAddNewCookMethod(System.Security.Principal.IPrincipal p_objPrincipal, string p_strName, string p_strMNemonic, out string p_strID)
{
long lngRes = 0;
p_strID = "";
//权限类
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
//检查是否有使用些函数的权限
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsRegTypeSvc", "m_lngDoAddNewCookMethod");
if (lngRes < 0) //没有使用的权限
{
return(-1);
}
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
//返回一最大的计划号
lngRes = objHRPSvc.lngGenerateID(4, "COOKINGMETHODID_CHR", "T_AID_CMCOOKINGMETHOD", out p_strID);
if (lngRes < 0)
{
return(-1);
}
string strSQL = "INSERT INTO T_AID_CMCOOKINGMETHOD (COOKINGMETHODID_CHR, COOKINGMETHODNAME_VCHR, MNEMONIC_CHR) VALUES " +
" ('" + p_strID + "' , '" + p_strName + "', '" + p_strMNemonic + "')";
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long SavePrjCommonUseInfo(System.Security.Principal.IPrincipal p_objPrincipal, System.Data.DataTable p_SrcDt, System.Data.DataTable p_DelDt, string strType)
{
long lngRes = 0;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS", "SavePrjCommonUseInfo");
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
if (lngRes < 0)
{
return(-1);
}
string strSQL = "";
if (p_DelDt != null)
{
for (int i1 = 0; i1 < p_DelDt.Rows.Count; i1++)
{
strSQL = "DELETE T_AID_COMUSECHARGEITEM WHERE SEQID_CHR = '" + p_DelDt.Rows[i1]["SEQID_CHR"].ToString().Trim() + "' and TYPE_INT=" + strType;
try
{
lngRes = objHRPSvc.DoExcute(strSQL);
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
}
}
if (p_SrcDt != null)
{
string strSeqid = "";
for (int i1 = 0; i1 < p_SrcDt.Rows.Count; i1++)
{
if (p_SrcDt.Rows[i1].RowState == System.Data.DataRowState.Added)
{
objHRPSvc.lngGenerateID(10, "seqid_chr", "t_aid_comusechargeitem", out strSeqid);
strSQL = @"insert into t_aid_comusechargeitem(seqid_chr,CREATE_DAT ,deptid_chr, itemid_chr, createrid_chr, privilege_int,TYPE_INT) values(?,?,?,?,?,?,?)";
try
{
System.Data.IDataParameter[] paramArr = null;
objHRPSvc.CreateDatabaseParameter(7, out paramArr);
paramArr[0].Value = strSeqid;
paramArr[1].Value = System.DateTime.Now;
paramArr[2].Value = p_SrcDt.Rows[i1]["deptid_chr"].ToString().Trim();
paramArr[3].Value = p_SrcDt.Rows[i1]["itemid_chr"].ToString().Trim();
paramArr[4].Value = p_SrcDt.Rows[i1]["createrid_chr"].ToString().Trim();
paramArr[5].Value = p_SrcDt.Rows[i1]["privilege_int"].ToString().Trim();
paramArr[6].Value = strType;
long lngRecordsAffected = -1;
lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr);
objHRPSvc.Dispose();
p_SrcDt.Rows[i1]["seqid_chr"] = strSeqid;
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
}
}
}
return(lngRes);
}
