public long GetSysSetting(System.Security.Principal.IPrincipal p_objPrincipal, string p_setId, out string p_setStatus)
{
long lngRes = 0;
string strSQL;
strSQL = @"SELECT SETSTATUS_INT FROM T_SYS_SETTING WHERE SETID_CHR = '" + p_setId + "'";
System.Data.DataTable dtbResult = new System.Data.DataTable();
p_setStatus = "0";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbResult);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbResult.Rows.Count > 0)
{
p_setStatus = dtbResult.Rows[0][0].ToString().Trim();
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
private string GetNextNewId()
{
long lngRes = 0;
string strSQL;
strSQL = @"SELECT SEQ_PREPAYBALANCE.NEXTVAL FROM dual";
System.Data.DataTable dtbResult = new System.Data.DataTable();
string newId = "0";
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult);
objHRPSvc.Dispose();
if (lngRes > 0 && dtbResult != null)
{
newId = dtbResult.Rows[0][0].ToString().Trim();
}
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(newId);
}
public string m_lngGetMaxId()
{
DataTable m_dtb = null;
try
{
string strSql = "select max(storagerackid_chr) as maxId from t_ms_storagerackset";
clsHRPTableService objHRPServ = new clsHRPTableService();
long lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSql, ref m_dtb);
if (m_dtb == null || m_dtb.Rows[0]["maxId"] == DBNull.Value)
{
return("0001");
}
int i_Id = Convert.ToInt16(m_dtb.Rows[0]["maxId"].ToString());
string i_maxId = Convert.ToString(i_Id + 1);
return(i_maxId.PadLeft(4, '0'));
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(null);
}
public long GetAllRole(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtResult)
{
p_dtResult = new DataTable();
string strSQL;
strSQL = @" SELECT ROLEID_CHR,
NAME_VCHR,
DESC_VCHR,
DEPTID_CHR
FROM T_SYS_ROLE ORDER BY ROLEID_CHR ";
long lngRes = -1;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngCheckIsHospital(System.Security.Principal.IPrincipal p_objPrincipal, string p_strDrugStoreID, out bool p_blnIsHospital)
{
p_blnIsHospital = false;
DataTable dtbTemp = new DataTable();
long lngRes = 0;
try
{
string strSQL = @"select a.medstoretype_int
from t_bse_medstore a
where a.medstoreid_chr = ?";
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objParam = null;
objHRPServ.CreateDatabaseParameter(1, out objParam);
objParam[0].Value = p_strDrugStoreID;
objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbTemp, objParam);
if (dtbTemp != null && dtbTemp.Rows.Count > 0)
{
if (Convert.ToInt16(dtbTemp.Rows[0]["medstoretype_int"]) == 2)
{
p_blnIsHospital = true;
}
}
objHRPServ.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngCheckHasAccount(System.Security.Principal.IPrincipal p_objPrincipal, string p_strStorageID, out bool p_blnHasAccountPeriod)
{
p_blnHasAccountPeriod = false;
if (string.IsNullOrEmpty(p_strStorageID))
{
return(-1);
}
DataTable dtResult = new DataTable();
long lngRes = 0;
try
{
string strSQL = @"select count(*) from t_ms_accountperiod a where a.storageid_chr = ?";
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objDPArr = null;
objHRPServ.CreateDatabaseParameter(1, out objDPArr);
objDPArr[0].Value = p_strStorageID;
lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr);
objHRPServ.Dispose();
objHRPServ = null;
if (dtResult != null && dtResult.Rows.Count > 0)
{
p_blnHasAccountPeriod = Convert.ToInt32(dtResult.Rows[0][0]) > 0;
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetMedStroge(bool p_blnIsStore, out DataTable dtExp)
{
long lngRes = -1;
string strSQL = "";
if (p_blnIsStore)
{
strSQL = @"select t.deptid_chr medicineroomid,t.medstorename_vchr medicineroomname from t_bse_medstore t
order by t.medstoreid_chr";
}
else
{
strSQL = @"select distinct t.medicineroomid medicineroomid,
t.medicineroomname medicineroomname
from t_ms_medicinestoreroomset t
order by t.medicineroomid ";
}
dtExp = new DataTable();
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.DoGetDataTable(strSQL, ref dtExp);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 获取一个序列号
/// </summary>
/// <param name="p_objPrincipal"></param>
/// <param name="p_strSeqName"></param>
/// <param name="p_lngSeqId"></param>
/// <returns></returns>
public static long m_lngGetSequence(string p_strSeqName, out long p_lngSeqId)
{
p_lngSeqId = 0;
long lngRes = 0;
if (string.IsNullOrEmpty(p_strSeqName))
{
return(lngRes);
}
try
{
if (clsHRPTableService.bytDatabase_Selector == (byte)clsHRPTableService.enumDatabase_Selector.bytOracle)
{
string strSQL = "select " + p_strSeqName + ".nextval from dual";
clsHRPTableService objHRPServ = new clsHRPTableService();
DataTable dtResult = null;
lngRes = objHRPServ.DoGetDataTable(strSQL, ref dtResult);
if (dtResult != null && dtResult.Rows.Count == 1)
{
p_lngSeqId = Convert.ToInt64(dtResult.Rows[0][0]);
}
else
{
p_lngSeqId = 1;
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogDetailError(objEx, true);
}
return(lngRes);
}
public long m_lngGetExptypeAndVendor(bool p_blnForDrugStore, out DataTable dtExp, out DataTable dtVendor, out DataTable dtMedType)
{
long lngRes = -1;
dtExp = null;
dtVendor = null;
dtMedType = null;
string strSQL = "";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = this.m_lngGetMedStroge(p_blnForDrugStore, out dtExp);
strSQL = @"select t.vendorid_chr id, t.vendorname_vchr name, t.usercode_chr code,t.pycode_chr,t.wbcode_chr
from t_bse_vendor t where vendortype_int = 2 or vendortype_int = 3 order by t.usercode_chr ";
lngRes = objHRPSvc.DoGetDataTable(strSQL, ref dtVendor);
lngRes = this.m_lngGetMedType(p_blnForDrugStore, out dtMedType);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetItemID(string p_strMedicineID, out string p_strItemID)
{
p_strItemID = string.Empty;
long lngRes = -1;
DataTable p_dtbTemp = null;
string strSQL = @"select a.itemid_chr from t_bse_chargeitem a where a.itemsrcid_vchr = ?";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
objHRPSvc.CreateDatabaseParameter(1, out ParamArr);
ParamArr[0].Value = p_strMedicineID;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtbTemp, ParamArr);
if (p_dtbTemp != null && p_dtbTemp.Rows.Count > 0)
{
p_strItemID = p_dtbTemp.Rows[0][0].ToString();
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetTableMedicineList(ref DataTable p_dtMedicineList)
{
long lngRes = -1;
string strSQL = @"select a.itemid_chr,
a.itemcode_vchr,
a.itempycode_chr,
a.itemwbcode_chr,
a.itemname_vchr,
a.itemcommname_vchr,
a.itemengname_vchr
from t_bse_chargeitem a, t_bse_medicine b
where a.itemsrcid_vchr = b.medicineid_chr
and b.multiunitflag_int = 1
and a.ifstop_int = 0";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtMedicineList);
int x = p_dtMedicineList.Rows.Count;
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
// public DateTime m_dtmGetServerDate()
// {
// long lngRes = 0;
// System.DateTime datResult = System.DateTime.Now;
// string strSQL = @"select sysdate
// from dual";
// System.Data.DataTable dtbResult = new System.Data.DataTable();
// try
// {
// com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
// lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult);
// if (lngRes > 0 && dtbResult != null)
// {
// datResult = System.DateTime.Parse(dtbResult.Rows[0]["sysdate"].ToString());
// }
// objHRPSvc.Dispose();
// }
// catch (Exception objEx)
// {
// string strTmp = objEx.Message;
// com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
// bool blnRes = objLogger.LogError(objEx);
// }
// return datResult;
// }
public string m_dtmGetServerDate()
{
long lngRes = 0;
//System.DateTime datResult = System.DateTime.Now;
string datResult = "";
string strSQL = @"select sysdate
from dual";
System.Data.DataTable dtbResult = new System.Data.DataTable();
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult);
if (lngRes > 0 && dtbResult != null)
{
datResult = dtbResult.Rows[0]["sysdate"].ToString();
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(datResult);
}
public long m_lngGetBaseMedicine(System.Security.Principal.IPrincipal p_objPrincipal, string p_strAssistCode, string p_strDrugType, out DataTable p_dtbMedicine)
{
p_dtbMedicine = null;
long lngRes = 0;
if (p_strAssistCode == null)
{
p_strAssistCode = string.Empty;
}
try
{
string strSQL = @"select t.assistcode_chr,
t.medicinename_vchr,
t.medspec_vchr,
t.opunit_chr,
t.ipunit_chr,
t.packqty_dec,
t.productorid_chr,
t.pycode_chr,
t.wbcode_chr,
t.medicineid_chr,
t.ispoison_chr,
t.ischlorpromazine2_chr,
t.unitprice_mny,
t.medicinetypeid_chr,
t.tradeprice_mny,
t.limitunitprice_mny,
t.opchargeflg_int,
t.ipchargeflg_int,
t.ifstop_int,
b.itemname_vchr as aliasname_vchr,
b.pycode_vchr as aliaspycode_vchr,
b.wbcode_vchr as aliaswbcode_vchr
from t_bse_medicine t
left join t_bse_chargeitem a on t.medicineid_chr = a.itemsrcid_vchr
left join t_bse_itemalias_drug b on a.itemid_chr = b.itemid_chr
and b.status_int = 1
and b.flag_int = 1
where t.assistcode_chr like ?
and t.medicinetypeid_chr = ? and t.deleted_int=0
order by t.assistcode_chr,t.medicineid_chr";
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objDPArr = null;
objHRPServ.CreateDatabaseParameter(2, out objDPArr);
objDPArr[0].Value = p_strAssistCode + "%";
objDPArr[1].Value = p_strDrugType;
lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref p_dtbMedicine, objDPArr);
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long GetAllApplyType(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtResult)
{
p_dtResult = new DataTable();
string strSQL;
strSQL = @" SELECT TYPEID,
TYPETEXT,
DELETED,
ORDERSEQ_INT
FROM AR_APPLY_TYPELIST ORDER BY ORDERSEQ_INT";
long lngRes = -1;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngCheckExistsInitialID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strStorageID, out string p_strInitialID)
{
p_strInitialID = string.Empty;
long lngRes = 0;
DataTable dtTemp = null;
string strSQL = @"select initialid_chr
from (select a.initialid_chr
from t_ms_initial a
where a.storageid_chr = ?
order by a.seriesid_int)
where rownum = 1";
try
{
clsHRPTableService objHRPServ = new clsHRPTableService();
System.Data.IDataParameter[] objParm = null;
objHRPServ.CreateDatabaseParameter(1, out objParm);
objParm[0].Value = p_strStorageID;
lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtTemp, objParm);
objHRPServ.Dispose();
objHRPServ = null;
if (lngRes > 0 && dtTemp.Rows.Count == 1)
{
p_strInitialID = dtTemp.Rows[0][0].ToString();
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long GetOrderBookByDate(System.Security.Principal.IPrincipal p_objPrincipal, string p_beginDate, string p_endDate, out DataTable p_dtResult)
{
p_dtResult = new DataTable();
string strSQL;
strSQL = SQL_SELECT + @" AND a.OPERATE_DAT>to_date('" + p_beginDate + @"','YYYY-MM-DD HH24:MI:SS')
AND a.OPERATE_DAT<to_date('" + p_endDate + @"','YYYY-MM-DD HH24:MI:SS')
ORDER BY d2.CODE_VCHR,e.code_chr";
long lngRes = -1;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetMaxAccountId(System.Security.Principal.IPrincipal p_objPrincipal, out string p_strAccountId)
{
p_strAccountId = "";
DataTable p_dtbVendor = new DataTable();
long lngRes = 0;
try
{
string strSQL = @"select max(a.accountid) accountid from t_ms_account a";
clsHRPTableService objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref p_dtbVendor);
if (p_dtbVendor != null)
{
p_strAccountId = p_dtbVendor.Rows[0]["accountid"].ToString();
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long GetOrderBookById(System.Security.Principal.IPrincipal p_objPrincipal, string p_bookId, out DataTable p_dtResult)
{
p_dtResult = new DataTable();
string strSQL;
strSQL = SQL_SELECT + @" AND a.BOOKID_INT = " + p_bookId;
long lngRes = -1;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long GetOrderBookByAPPLYID(System.Security.Principal.IPrincipal p_objPrincipal, string APPLYID, out DataTable p_dtResult)
{
p_dtResult = new DataTable();
string strSQL;
strSQL = SQL_SELECT + @" AND APPLYID=?
ORDER BY d2.CODE_VCHR,e.code_chr";
long lngRes = -1;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] arrParams = null;
objHRPSvc.CreateDatabaseParameter(1, out arrParams);
arrParams[0].Value = APPLYID;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtResult, arrParams);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngOutStorageDetailReport_Dept_Med(System.Security.Principal.IPrincipal p_objPrincipal, string p_strStorageID, string p_strAskDeptID, string p_strMedicineID, DateTime p_dtmBegin, DateTime p_dtmEnd, out DataTable p_dtbOutDetail)
{
p_dtbOutDetail = null;
if (string.IsNullOrEmpty(p_strStorageID) || string.IsNullOrEmpty(p_strMedicineID) || string.IsNullOrEmpty(p_strAskDeptID))
{
return(-1);
}
long lngRes = 0;
try
{
string strSQL = @"select t.retailprice_int,
t.netamount_int,
t.opunit_chr,
t.medspec_vchr,
d.deptid_chr,
d.deptname_vchr,
b.medicinename_vchr,
b.assistcode_chr,
m.examdate_dat prodate
from t_ms_outstorage_detail t,
t_ms_outstorage m,
t_bse_deptdesc d,
t_bse_medicine b
where m.storageid_chr = ?
and m.status > 1
and m.formtype = 1
and m.seriesid_int = t.seriesid2_int
and t.status = 1
and m.askdept_chr = d.deptid_chr
and t.medicineid_chr = b.medicineid_chr
and m.examdate_dat between ? and ?
and t.medicineid_chr = ?
and m.askdept_chr = ?
order by d.deptname_vchr, m.examdate_dat";
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objDPArr = null;
objHRPServ.CreateDatabaseParameter(5, out objDPArr);
objDPArr[0].Value = p_strStorageID;
objDPArr[1].DbType = DbType.DateTime;
objDPArr[1].Value = p_dtmBegin;
objDPArr[2].DbType = DbType.DateTime;
objDPArr[2].Value = p_dtmEnd;
objDPArr[3].Value = p_strMedicineID;
objDPArr[4].Value = p_strAskDeptID;
lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref p_dtbOutDetail, objDPArr);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public static long m_lngGetSequenceArr(string p_strSeqName, int p_intNumber, out long[] p_lngSeqIdArr)
{
p_lngSeqIdArr = null;
long lngRes = 0;
if (p_intNumber <= 0 || string.IsNullOrEmpty(p_strSeqName))
{
return(lngRes);
}
try
{
if (clsHRPTableService.bytDatabase_Selector == (byte)clsHRPTableService.enumDatabase_Selector.bytOracle)
{
string strSQL = "select getseq(?,?) from dual";
clsHRPTableService objHRPServ = new clsHRPTableService();
DataTable dtValue = null;
IDataParameter[] objDPArr = null;
objHRPServ.CreateDatabaseParameter(2, out objDPArr);
objDPArr[0].Value = p_strSeqName;
objDPArr[1].Value = p_intNumber;
lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtValue, objDPArr);
if (lngRes > 0 && dtValue != null && dtValue.Rows.Count == 1)
{
p_lngSeqIdArr = new long[p_intNumber];
long m_lngSeqId = Convert.ToInt64(dtValue.Rows[0][0]);
for (int index = p_intNumber - 1; index >= 0; index--)
{
p_lngSeqIdArr[index] = m_lngSeqId--;
}
}
else
{
p_lngSeqIdArr = new long[1];
p_lngSeqIdArr[0] = 1;
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogDetailError(objEx, true);
}
return(lngRes);
}
public long m_lngGetTableMultiUnitList(string p_strMedId, out DataTable p_dtMultiUnit)
{
long lngRes = -1;
p_dtMultiUnit = null;
string strSQL = @"select a.itemid_chr,
a.unit_vchr,
a.package_dec,
case
when a.curruseflag_int = 0 then
'否'
else
'是'
end as curruseflag_int,
case
when a.status_int = 0 then
'停用'
else
'启用'
end as status_int
from t_bse_itemmultiunit_drug a, t_bse_chargeitem b
where b.itemsrcid_vchr = ?
and a.itemid_chr = b.itemid_chr ";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
objHRPSvc.CreateDatabaseParameter(1, out ParamArr);
ParamArr[0].Value = p_strMedId;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref p_dtMultiUnit, ParamArr);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetAmountBySeriesID(System.Security.Principal.IPrincipal p_objPrincipal, long p_intSeriesID, out clsDS_StorageHistory_VO p_objHistory)
{
p_objHistory = new clsDS_StorageHistory_VO();
long lngRes = 0;
try
{
DataTable m_dtbTemp = new DataTable();
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objParamArr = null;
string strSQL = @"select a.opavailablegross_num,
a.ipavailablegross_num,
a.opunit_chr,
a.ipunit_chr,
a.drugstoreid_chr,
a.medicineid_chr
from t_ds_storage_detail a
where a.seriesid_int = ?";
objHRPServ.CreateDatabaseParameter(1, out objParamArr);
objParamArr[0].Value = p_intSeriesID;
objHRPServ.lngGetDataTableWithParameters(strSQL, ref m_dtbTemp, objParamArr);
if (m_dtbTemp != null && m_dtbTemp.Rows.Count > 0)
{
p_objHistory.m_lngSERIESID2_INT = p_intSeriesID;
p_objHistory.m_dblOPAVAILABLEGROSS_NUM = Convert.ToDouble(m_dtbTemp.Rows[0]["opavailablegross_num"]);
p_objHistory.m_dblIPAVAILABLEGROSS_NUM = Convert.ToDouble(m_dtbTemp.Rows[0]["ipavailablegross_num"]);
p_objHistory.m_strOPUNIT_CHR = m_dtbTemp.Rows[0]["opunit_chr"].ToString();
p_objHistory.m_strIPUNIT_CHR = m_dtbTemp.Rows[0]["ipunit_chr"].ToString();
p_objHistory.m_strDRUGSTOREID_CHR = m_dtbTemp.Rows[0]["drugstoreid_chr"].ToString();
p_objHistory.m_strMEDICINEID_CHR = m_dtbTemp.Rows[0]["medicineid_chr"].ToString();
}
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngGetAllMedicine(System.Security.Principal.IPrincipal p_objPrincipal, string p_strStorageID, out DataTable p_dtbMedicine)
{
p_dtbMedicine = null;
long lngRes = -1;
try
{
string strSQL = @"select t.medicineid_chr,t.assistcode_chr,
t.medicinename_vchr,
t.medspec_vchr,
t.opunit_chr,
t.tiptoplimit_int,
t.neaplimit_int,
sum(s.realgross_int) realgross_int,
t.pycode_chr
from t_bse_medicine t left join t_ms_storage_detail s
on t.medicineid_chr = s.medicineid_chr
where exists (select r.medicineroomid
from t_ms_medicinestoreroomset r
where r.medicinetypeid_chr = t.medicinetypeid_chr
and r.medicineroomid = ?) and t.assistcode_chr is not null
group by t.medicineid_chr,t.assistcode_chr,
t.medicinename_vchr,
t.medspec_vchr,
t.opunit_chr,
t.tiptoplimit_int,
t.neaplimit_int,
t.pycode_chr
order by t.assistcode_chr";
clsHRPTableService objHRPServ = new clsHRPTableService();
IDataParameter[] objDPArr = null;
objHRPServ.CreateDatabaseParameter(1, out objDPArr);
objDPArr[0].Value = p_strStorageID;
lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref p_dtbMedicine, objDPArr);
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 处方信息列表
/// </summary>
/// <param name="m_dtbResult"></param>
/// <param name="m_objDetailInfo"></param>
public void m_mthlsvDetailInfo(DataTable m_dtbResult, ref List <clsRecipeDetailVO> m_objDetailInfoList)
{
if (m_dtbResult.Rows.Count > 0)
{
try
{
m_objDetailInfoList = new List <clsRecipeDetailVO>();
clsRecipeDetailVO m_objDetailInfo;
DataView dv = new DataView(m_dtbResult);
dv.Sort = "treatdate_dat desc";
m_dtbResult = dv.ToTable();
int iRowCount = m_dtbResult.Rows.Count;
for (int j2 = 0; j2 < iRowCount; j2++)
{
m_objDetailInfo = new clsRecipeDetailVO();
m_objDetailInfo.treatdate_dat = Convert.ToDateTime(m_dtbResult.Rows[j2]["treatdate_dat"]).ToString("yyyy-MM-dd HH:mm");
m_objDetailInfo.outpatrecipeid_chr = m_dtbResult.Rows[j2]["outpatrecipeid_chr"].ToString();
m_objDetailInfo.patientcardid_chr = m_dtbResult.Rows[j2]["patientcardid_chr"].ToString();
m_objDetailInfo.patientname = m_dtbResult.Rows[j2]["patientname"].ToString();
m_objDetailInfo.invoiceno_vchr = m_dtbResult.Rows[j2]["invoiceno_vchr"].ToString();
m_objDetailInfo.diagdrname = m_dtbResult.Rows[j2]["diagdrname"].ToString();
m_objDetailInfo.diagdeptname = m_dtbResult.Rows[j2]["diagdeptname"].ToString();
m_objDetailInfo.treatempname = m_dtbResult.Rows[j2]["treatempname"].ToString();
m_objDetailInfo.sendempname = m_dtbResult.Rows[j2]["sendempname"].ToString();
m_objDetailInfo.medstorename_vchr = m_dtbResult.Rows[j2]["medstorename_vchr"].ToString();
m_objDetailInfo.treatwinname = m_dtbResult.Rows[j2]["treatwinname"].ToString();
m_objDetailInfo.sendwinname = m_dtbResult.Rows[j2]["sendwinname"].ToString();
m_objDetailInfo.sid_int = m_dtbResult.Rows[j2]["sid_int"].ToString();
m_objDetailInfo.medstoreid_chr = m_dtbResult.Rows[j2]["medstoreid_chr"].ToString();
m_objDetailInfoList.Add(m_objDetailInfo);
}
}
catch (Exception ex)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(ex);
}
}
}
/// <summary>
/// 处方信息列表
/// </summary>
//public void m_mthSelectRecipeInfo()
//{
// //if (this.m_objViewer.m_lsvTreatEmp.SelectedItems.Count == 0)
// // return;
// //int m_strTreatIndex = this.m_objViewer.m_lsvTreatEmp.SelectedItems[0].Index;
// clsTreatEmpRecipeVO obj = (clsTreatEmpRecipeVO)this.m_objViewer.m_lsvTreatEmp.Items[m_strTreatIndex].Tag;
// List<clsRecipeDetailVO> m_objDetail = obj.m_objRecipeDetailList;
// try
// {
// this.m_objViewer.m_lsvRecipeInfo.Items.Clear();
// this.m_objViewer.m_lsvRecipeDetailInfo.Items.Clear();
// this.m_objViewer.m_lsvRecipeInfo.BeginUpdate();
// ListViewItem lsiTemp = null;
// for (int i1 = 0; i1 < m_objDetail.Count; i1++)
// {
// lsiTemp = new ListViewItem(m_objDetail[i1].treatdate_dat);
// lsiTemp.SubItems.Add(m_objDetail[i1].outpatrecipeid_chr);
// lsiTemp.SubItems.Add(m_objDetail[i1].patientcardid_chr);
// lsiTemp.SubItems.Add(m_objDetail[i1].patientname);
// lsiTemp.SubItems.Add(m_objDetail[i1].invoiceno_vchr);
// lsiTemp.SubItems.Add(m_objDetail[i1].diagdrname);
// lsiTemp.SubItems.Add(m_objDetail[i1].diagdeptname);
// lsiTemp.SubItems.Add(m_objDetail[i1].treatempname);
// lsiTemp.SubItems.Add(m_objDetail[i1].sendempname);
// lsiTemp.SubItems.Add(m_objDetail[i1].medstorename_vchr);
// lsiTemp.SubItems.Add(m_objDetail[i1].treatwinname);
// lsiTemp.SubItems.Add(m_objDetail[i1].sendwinname);
// lsiTemp.Tag = m_objDetail[i1];
// this.m_objViewer.m_lsvRecipeInfo.Items.Add(lsiTemp);
// }
// this.m_objViewer.m_lsvRecipeInfo.EndUpdate();
// }
// catch (Exception ex)
// {
// com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
// bool blnRes = objLogger.LogError(ex);
// }
// if (this.m_objViewer.m_lsvRecipeInfo.Items.Count > 0)
// {
// this.m_objViewer.m_lsvRecipeInfo.Items[0].Selected = true;
// }
//}
#endregion
#region 绑定处方明细信息数据
/// <summary>
/// 绑定处方明细信息数据
/// </summary>
/// <param name="m_dtbDetail"></param>
private void m_mthlsvRecipeDetailData(DataTable m_dtbDetail)
{
if (m_dtbDetail.Rows.Count > 0)
{
try
{
if (this.m_objViewer.m_lsvRecipeDetailInfo.Items.Count > 0)
{
this.m_objViewer.m_lsvRecipeDetailInfo.Items.Clear();
}
this.m_objViewer.m_lsvRecipeDetailInfo.BeginUpdate();
ListViewItem lsiTempDetail = null;
for (int i1 = 0; i1 < m_dtbDetail.Rows.Count; i1++)
{
/// itemname_vchr itemspec_vchr dosage_dec dosageunit_chr usagename_vchr freqname_chr(频率)
/// days_int1 qty_dec unitid_chr price_mny tolprice_mny itemcode_vchr
lsiTempDetail = new ListViewItem(m_dtbDetail.Rows[i1]["itemname_vchr"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["itemspec_vchr"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["dosage_dec"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["dosageunit_chr"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["usagename_vchr"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["freqname_chr"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["days_int1"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["qty_dec"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["unitid_chr"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["price_mny"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["tolprice_mny"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["itemcode_vchr"].ToString());
lsiTempDetail.SubItems.Add(m_dtbDetail.Rows[i1]["productorid_chr"].ToString());
this.m_objViewer.m_lsvRecipeDetailInfo.Items.Add(lsiTempDetail);
}
this.m_objViewer.m_lsvRecipeDetailInfo.EndUpdate();
}
catch (Exception ex)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(ex);
}
}
}
public long m_lngGetMedicineType(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtbResult)
{
p_dtbResult = null;
long lngRes = 0;
try
{
string strSQL = @"select medicinetypeid_chr,medicinetypename_vchr from t_aid_medicinetype";
clsHRPTableService objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref p_dtbResult);
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long GetBySearchSentence(System.Security.Principal.IPrincipal p_objPrincipal, string p_strSQL, out DataTable p_dtResult)
{
p_dtResult = new DataTable();
long lngRes = -1;
try
{
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
lngRes = objHRPSvc.lngGetDataTableWithoutParameters(p_strSQL, ref p_dtResult);
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngSaveStorageRack(System.Security.Principal.IPrincipal p_objPrincipal, Dictionary <string, string> p_dicStorageRack)
{
long lngRes = 0;
try
{
string strSQL = @"update t_ds_storage_detail a set a.storagerackid_chr = ?
where a.medicineid_chr = ? and a.lotno_vchr = ?";
clsHRPTableService objHRPServ = new clsHRPTableService();
DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String };
object[][] objValues = new object[3][];
int intItemCount = p_dicStorageRack.Count;
for (int j = 0; j < objValues.Length; j++)
{
objValues[j] = new object[intItemCount];//初始化
}
int iRow = 0;
foreach (KeyValuePair <string, string> kvp in p_dicStorageRack)
{
objValues[0][iRow] = kvp.Value;
objValues[1][iRow] = kvp.Key.Substring(0, 10);
objValues[2][iRow] = kvp.Key.Substring(10);
iRow++;
}
lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes);
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public bool m_blnQueryByIndex(string strSeledMedId, string p_strUnit, int p_intPackage_Dec, int p_CurruseFlag_Int)
{
bool blnIsFind = false;
string strSQL = @"select a.itemid_chr, a.unit_vchr,a.status_int
from t_bse_itemmultiunit_drug a
where a.itemid_chr = ?
and a.unit_vchr = ?
and a.package_dec = ?
and a.curruseflag_int = ?";
try
{
clsHRPTableService objHRPSvc = new clsHRPTableService();
IDataParameter[] ParamArr = null;
objHRPSvc.CreateDatabaseParameter(4, out ParamArr);
ParamArr[0].Value = strSeledMedId;
ParamArr[1].Value = p_strUnit;
ParamArr[2].DbType = DbType.Int16;
ParamArr[2].Value = p_intPackage_Dec;
ParamArr[3].DbType = DbType.Int16;
ParamArr[3].Value = p_CurruseFlag_Int;
DataTable dtValue = new DataTable();
long lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtValue, ParamArr);
if (dtValue != null && dtValue.Rows.Count > 0)
{
blnIsFind = true;
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(blnIsFind);
}