/// <summary> /// 获取库存明细数据 /// </summary> /// <param name="objvalue_Param">查询条件</param> /// <param name="dtbResult">返回的结果集</param> /// <param name="m_objStatValue">统计数据</param> /// <param name="blnQueryFlag">查询标志</param> /// <returns></returns> public long m_mthGetStorageDetailData(ref clsStorageDetail_SqlConditionQueryParam_VO objvalue_Param, bool p_blnAccount, out DataTable dtbResult, ref clsStorageDetail_Stat_VO m_objStatValue, List <string> lstMedicineType, bool blnQueryFlag) { long lngRes = 0; try { //调用Com+服务端 m_objStatValue.m_decCallSumTotal = 0; m_objStatValue.m_decRetailSumTotal = 0; m_objStatValue.m_decWholesaleSumTotal = 0; DataTable Query_dtbResult = new DataTable();//数据库返回的结果集 clsDomainController_StorageDetailQuery objDomain = new clsDomainController_StorageDetailQuery(); lngRes = objDomain.m_lngGetResultByConditionStorageDetail(ref objvalue_Param, p_blnAccount, lstMedicineType, ref Query_dtbResult); if (lngRes > 0) { DataTable Stat_dtbResult = new DataTable();//处理后生成的统计表 //统计查询 if (blnQueryFlag == true) { m_GroupSum(objvalue_Param.m_strStorageName, ref Query_dtbResult, ref Stat_dtbResult, ref m_objStatValue); dtbResult = Stat_dtbResult; Query_dtbResult = null; } else//明细查询 { m_DetailQuery(objvalue_Param.m_strStorageName, ref Query_dtbResult, ref m_objStatValue); dtbResult = Query_dtbResult; } } else { dtbResult = null; } return(lngRes); }//try catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); MessageBox.Show("查询失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop); } dtbResult = null; return(lngRes); }
/// <summary> /// 查询库存明细信息 /// </summary> /// <param name="objvalue_Param"></param> /// <param name="lstMedicineType"></param> /// <param name="dtbResult"></param> /// <param name="p_strProductor"></param> /// <param name="p_objPrepTypeArr"></param> /// <returns></returns> public long m_lngGetResultByConditionStorageDetail(ref clsStorageDetail_SqlConditionQueryParam_VO objvalue_Param, List <string> lstMedicineType, ref DataTable dtbResult, string p_strProductor, clsMEDICINEPREPTYPE_VO[] p_objPrepTypeArr) { long lngRes = 0; com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_Supported_SVC objSvc = (com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_Supported_SVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_Supported_SVC)); lngRes = objSvc.m_lngGetStorageDetailData(objPrincipal, ref objvalue_Param, lstMedicineType, ref dtbResult, p_strProductor, p_objPrepTypeArr); return(lngRes); }
public long m_lngGetResultByConditionStorageDetail(ref clsStorageDetail_SqlConditionQueryParam_VO objvalue_Param, bool p_blnAccount, List <string> lstMedicineType, ref DataTable dtbResult) { long lngRes = 0; //com.digitalwave.iCare.middletier.HIS.clsDemoMiddleTierSVC objSvc =(com.digitalwave.iCare.middletier.HIS.clsDemoMiddleTierSVC)clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.HIS.clsDemoMiddleTierSVC)); //创建中间件COM对象 com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddleTier_StorageDetailQuerySVC objSvc = (com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddleTier_StorageDetailQuerySVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddleTier_StorageDetailQuerySVC)); lngRes = objSvc.m_lngGetStorageDetailData(objPrincipal, p_blnAccount, ref objvalue_Param, lstMedicineType, ref dtbResult); return(lngRes); }
public long m_lngGetStorageDetailData(System.Security.Principal.IPrincipal p_objPrincipal, bool p_blnAccount, ref clsStorageDetail_SqlConditionQueryParam_VO objvalue_Param, List <string> p_lstMedicineType, ref DataTable dtbResult) { long lngRes = 0; string strAccountId = ""; if (!p_blnAccount) { m_lngGetMaxAccountId(null, out strAccountId); } //权限控制,clsPrivilegeHandleService为权限处理服务类 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.MedicineStoreService.clsMiddleTier_StorageDetailQuerySVC", "m_lngGetStorageDetailData"); if (lngRes < 0) { dtbResult = null; return(-1); } //创建COM对象 com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); StringBuilder strSQL = new StringBuilder(@"select b.canprovide,b.storagerackid_chr,b.medicineid_chr, c.assistcode_chr, b.medicinename_vchr, b.medspec_vchr, case when b.lotno_vchr = 'UNKNOWN' then '' else b.lotno_vchr end lotno_vchr, d.medicinetypename_vchr, realgross_int, availagross_int, b.opunit_vchr, b.callprice_int, b.retailprice_int, b.wholesaleprice_int, b.validperiod_dat, e.medicinepreptypename_vchr, b.productorid_chr, v.vendorname_vchr, f.endamount_int from t_ms_storage_detail b inner join t_bse_medicine c on b.medicineid_chr = c.medicineid_chr left join t_bse_storage h on h.storageid_chr = b.storageid_chr inner join t_aid_medicinetype d on c.medicinetypeid_chr = d.medicinetypeid_chr left outer join t_aid_medicinepreptype e on c.medicinepreptype_chr = e.medicinepreptype_chr left outer join t_bse_vendor v on b.vendorid_chr = v.vendorid_chr left outer join t_ms_account_detail f on b.medicineid_chr = f.medicineid_chr and f.accountid_chr like ? and f.lotno_vchr = b.lotno_vchr and b.instorageid_vchr = f.instorageid_vchr and b.callprice_int = f.callprice_int and b.validperiod_dat = f.validperiod_dat and f.isend_int = 1 and f.state_int > 0 and f.storageid_chr = b.storageid_chr left join t_ms_storagerackset g on g.storagerackid_chr = b.storagerackid_chr" ); //g.storagerackname_vchr, try { int m_intParamCount = 1; StringBuilder m_strbCondition = new StringBuilder(""); clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; IDataParameter[] tmp_objDPArr = null; objHRPServ.CreateDatabaseParameter(13 + p_lstMedicineType.Count, out tmp_objDPArr); tmp_objDPArr[0].Value = strAccountId + "%"; strSQL.Append(@" where (b.storageid_chr = ?)"); tmp_objDPArr[1].Value = objvalue_Param.m_strStorageID; ++m_intParamCount; if (objvalue_Param.m_strValidBeginDate.Trim().Length == 10) { strSQL.Append(@" and (b.validperiod_dat>=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = Convert.ToDateTime(objvalue_Param.m_strValidBeginDate); tmp_objDPArr[m_intParamCount - 1].DbType = DbType.Date; } if (objvalue_Param.m_strValidEndDate.Trim().Length == 10) { strSQL.Append(@" and (b.validperiod_dat<=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = Convert.ToDateTime(objvalue_Param.m_strValidEndDate); tmp_objDPArr[m_intParamCount - 1].DbType = DbType.Date; } if (objvalue_Param.m_strMedicineID.Trim().Length > 0) { strSQL.Append(@" and (b.medicineid_chr = ?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = objvalue_Param.m_strMedicineID; } else { if (objvalue_Param.m_strAssistCode.Length > 0) { strSQL.Append(@" and ((b.medicineid_chr like ?) or (c.assistcode_chr like ?) or (b.medicinename_vchr like ?) or (c.pycode_chr like ?) or (c.wbcode_chr like ?))"); for (int i1 = 0; i1 < 5; i1++) { tmp_objDPArr[m_intParamCount + i1].Value = objvalue_Param.m_strAssistCode; } m_intParamCount = m_intParamCount + 5; } } if (p_lstMedicineType.Count > 0) { strSQL.Append(@" and ((c.medicinetypeid_chr=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = p_lstMedicineType[0].ToString(); for (int i1 = 1; i1 < p_lstMedicineType.Count; i1++) { strSQL.Append(@" or (c.medicinetypeid_chr=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = p_lstMedicineType[i1].ToString(); } strSQL.Append(@")"); } if (objvalue_Param.m_blnZeroGross == false) { strSQL.Append(@" and (b.realgross_int<>?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = 0; } strSQL.Append(@" and (b.status=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = 1; //strSQL.Append(@" ORDER BY B.MEDICINEID_CHR ASC"); strSQL.Append(@" order by c.assistcode_chr asc"); objHRPServ.CreateDatabaseParameter(m_intParamCount, out objDPArr); for (int i1 = 0; i1 < m_intParamCount; i1++) { objDPArr[i1].Value = tmp_objDPArr[i1].Value; objDPArr[i1].DbType = tmp_objDPArr[i1].DbType; } lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL.ToString(), ref dtbResult, objDPArr); //合拼药品 只分药品ID和批号,不管入库单据号 double intRealGross = 0; double intAvailaGross = 0; double intEndamount = 0; double intTemA; double intTemR; double intTemE; DataTable dtbTemp = dtbResult.Clone(); for (int intRow = 0; intRow < dtbResult.Rows.Count; intRow++) { DataRow dtrTemp = dtbResult.Rows[intRow]; if (dtbResult.Rows[intRow]["Endamount_int"] == DBNull.Value) { dtbResult.Rows[intRow]["Endamount_int"] = 0; } if ((intRow + 1 >= dtbResult.Rows.Count) || (dtbResult.Rows[intRow]["assistcode_chr"].ToString() != dtbResult.Rows[intRow + 1]["assistcode_chr"].ToString() || dtbResult.Rows[intRow]["lotno_vchr"].ToString() != dtbResult.Rows[intRow + 1]["lotno_vchr"].ToString() || Convert.ToDouble(dtbResult.Rows[intRow]["callprice_int"]) != Convert.ToDouble(dtbResult.Rows[intRow + 1]["callprice_int"]) || Convert.ToDouble(dtbResult.Rows[intRow]["retailprice_int"]) != Convert.ToDouble(dtbResult.Rows[intRow + 1]["retailprice_int"]))) { if (intRealGross > 0) { intTemR = Convert.ToDouble(dtbResult.Rows[intRow]["realgross_int"]); intTemA = Convert.ToDouble(dtbResult.Rows[intRow]["availagross_int"]); intTemE = Convert.ToDouble(dtbResult.Rows[intRow]["Endamount_int"]); dtrTemp["realgross_int"] = intTemR + intRealGross; dtrTemp["availagross_int"] = intTemA + intAvailaGross; dtrTemp["Endamount_int"] = intTemE + intEndamount; } dtbTemp.Rows.Add(dtrTemp.ItemArray); intRealGross = 0; intAvailaGross = 0; intEndamount = 0; } else { intRealGross += Convert.ToDouble(dtrTemp["realgross_int"]); intAvailaGross += Convert.ToDouble(dtrTemp["availagross_int"]); intEndamount += Convert.ToDouble(dtrTemp["Endamount_int"]); } } dtbResult = dtbTemp; objHRPSvc.Dispose(); } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); dtbResult = null; } objHRPSvc.Dispose(); return(lngRes); }
public long m_lngGetStorageDetailData(System.Security.Principal.IPrincipal p_objPrincipal, ref clsStorageDetail_SqlConditionQueryParam_VO objvalue_Param, List <string> p_lstMedicineType, ref DataTable dtbResult, string p_strProductor, clsMEDICINEPREPTYPE_VO[] p_objPrepTypeArr) { long lngRes = 0; //权限控制,clsPrivilegeHandleService为权限处理服务类 com.digitalwave.security.clsPrivilegeHandleService objHandle = new clsPrivilegeHandleService(); lngRes = objHandle.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsDrugStorageQuery_SVC", "m_lngGetStorageDetailData"); if (lngRes < 0) { dtbResult = null; return(-1); } bool m_blnIsHospital = false; m_lngCheckIsHospital(p_objPrincipal, objvalue_Param.m_strStorageID, out m_blnIsHospital); StringBuilder strSQL = new StringBuilder(); if (m_blnIsHospital) { strSQL.Append(@"select b.medicineid_chr, c.assistcode_chr, c.medicinename_vchr, b.medspec_vchr, case when b.lotno_vchr = 'UNKNOWN' then '' else b.lotno_vchr end lotno_vchr, d.medicinetypename_vchr, decode(c.ipchargeflg_int, 0, round(b.iprealgross_int / b.packqty_dec, 2), b.iprealgross_int) realgross_int, decode(c.ipchargeflg_int, 0, round(b.ipavailablegross_num / b.packqty_dec, 2), b.ipavailablegross_num) availagross_int, b.opunit_chr, decode(c.ipchargeflg_int, 0, b.opretailprice_int, round(b.opretailprice_int / b.packqty_dec, 4)) retailprice_int, decode(c.ipchargeflg_int, 0, b.opwholesaleprice_int, round(b.opwholesaleprice_int / b.packqty_dec, 4)) wholesaleprice_int, b.validperiod_dat, e.medicinepreptypename_vchr, c.productorid_chr, b.storagerackid_chr, f.storagerackname_vchr, b.canprovide_int, b.oprealgross_int, b.opavailablegross_num opavailagross_int, b.opretailprice_int, b.opwholesaleprice_int, b.iprealgross_int, b.ipavailablegross_num ipavailagross_int, b.ipunit_chr, b.ipretailprice_int, b.ipwholesaleprice_int, decode(c.ipchargeflg_int, 0, b.opunit_chr, b.ipunit_chr) unit_chr, b.packqty_dec, h.ifstop_int, h.noqtyflag_int, c.pycode_chr, c.wbcode_chr, b.seriesid_int,c.opchargeflg_int,c.ipchargeflg_int from t_ds_storage_detail b left join t_ds_storage h on b.medicineid_chr = h.medicineid_chr and b.drugstoreid_chr = h.drugstoreid_chr left join t_bse_medicine c on b.medicineid_chr = c.medicineid_chr left join t_aid_medicinetype d on c.medicinetypeid_chr = d.medicinetypeid_chr left outer join t_aid_medicinepreptype e on c.medicinepreptype_chr = e.medicinepreptype_chr left join t_ms_storagerackset f on f.storagerackid_chr = b.storagerackid_chr left join t_bse_medstore g on g.deptid_chr = b.drugstoreid_chr" ); } else { strSQL.Append(@"select b.medicineid_chr, c.assistcode_chr, c.medicinename_vchr, b.medspec_vchr, case when b.lotno_vchr = 'UNKNOWN' then '' else b.lotno_vchr end lotno_vchr, d.medicinetypename_vchr, decode(c.opchargeflg_int, 0, round(b.iprealgross_int / b.packqty_dec, 2), b.iprealgross_int) realgross_int, decode(c.opchargeflg_int, 0, round(b.ipavailablegross_num / b.packqty_dec, 2), b.ipavailablegross_num) availagross_int, b.opunit_chr, decode(c.opchargeflg_int, 0, b.opretailprice_int, round(b.opretailprice_int / b.packqty_dec, 4)) retailprice_int, decode(c.opchargeflg_int, 0, b.opwholesaleprice_int, round(b.opwholesaleprice_int / b.packqty_dec, 4)) wholesaleprice_int, b.validperiod_dat, e.medicinepreptypename_vchr, c.productorid_chr, b.storagerackid_chr, f.storagerackname_vchr, b.canprovide_int, b.oprealgross_int, b.opavailablegross_num opavailagross_int, b.opretailprice_int, b.opwholesaleprice_int, b.iprealgross_int, b.ipavailablegross_num ipavailagross_int, b.ipunit_chr, b.ipretailprice_int, b.ipwholesaleprice_int, decode(c.opchargeflg_int, 0, b.opunit_chr, b.ipunit_chr) unit_chr, b.packqty_dec, h.ifstop_int, h.noqtyflag_int, c.pycode_chr, c.wbcode_chr, b.seriesid_int,c.opchargeflg_int,c.ipchargeflg_int from t_ds_storage_detail b left join t_ds_storage h on b.medicineid_chr = h.medicineid_chr and b.drugstoreid_chr = h.drugstoreid_chr left join t_bse_medicine c on b.medicineid_chr = c.medicineid_chr left join t_aid_medicinetype d on c.medicinetypeid_chr = d.medicinetypeid_chr left outer join t_aid_medicinepreptype e on c.medicinepreptype_chr = e.medicinepreptype_chr left join t_ms_storagerackset f on f.storagerackid_chr = b.storagerackid_chr left join t_bse_medstore g on g.deptid_chr = b.drugstoreid_chr" ); } try { int m_intParamCount = 1; StringBuilder m_strbCondition = new StringBuilder(""); clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; IDataParameter[] tmp_objDPArr = null; objHRPServ.CreateDatabaseParameter(12 + p_lstMedicineType.Count, out tmp_objDPArr); strSQL.Append(@" where b.status=1 and (g.medstoreid_chr = ?) and h.ifstop_int = 0"); tmp_objDPArr[0].Value = objvalue_Param.m_strStorageID; if (objvalue_Param.m_strValidBeginDate.Trim().Length == 10 && objvalue_Param.m_strValidEndDate.Trim().Length != 10) { strSQL.Append(@" and (b.validperiod_dat>=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = Convert.ToDateTime(objvalue_Param.m_strValidBeginDate); tmp_objDPArr[m_intParamCount - 1].DbType = DbType.Date; } if (objvalue_Param.m_strValidEndDate.Trim().Length == 10 && objvalue_Param.m_strValidBeginDate.Trim().Length != 10) { strSQL.Append(@" and (b.validperiod_dat<=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = Convert.ToDateTime(objvalue_Param.m_strValidEndDate); tmp_objDPArr[m_intParamCount - 1].DbType = DbType.Date; } if (objvalue_Param.m_strValidBeginDate.Trim().Length == 10 && objvalue_Param.m_strValidEndDate.Trim().Length == 10) { strSQL.Append(@" and (b.validperiod_dat between ? and ?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = Convert.ToDateTime(objvalue_Param.m_strValidBeginDate); tmp_objDPArr[m_intParamCount - 1].DbType = DbType.Date; ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = Convert.ToDateTime(objvalue_Param.m_strValidEndDate); tmp_objDPArr[m_intParamCount - 1].DbType = DbType.Date; } if (objvalue_Param.m_strMedicineID.Trim().Length > 0) { strSQL.Append(@" and (b.medicineid_chr = ?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = objvalue_Param.m_strMedicineID; } else { if (objvalue_Param.m_strAssistCode.Length > 0) { strSQL.Append(@" and ((b.medicineid_chr like ?) or (c.assistcode_chr like ?) or (c.medicinename_vchr like ?) or (c.pycode_chr like ?) or (c.wbcode_chr like ?))"); for (int i1 = 0; i1 < 5; i1++) { tmp_objDPArr[m_intParamCount + i1].Value = objvalue_Param.m_strAssistCode; } m_intParamCount = m_intParamCount + 5; } } if (p_lstMedicineType.Count > 0) { strSQL.Append(@" and ((c.medicinetypeid_chr=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = p_lstMedicineType[0].ToString(); for (int i1 = 1; i1 < p_lstMedicineType.Count; i1++) { strSQL.Append(@" or (c.medicinetypeid_chr=?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = p_lstMedicineType[i1].ToString(); } strSQL.Append(@")"); } if (objvalue_Param.m_blnZeroGross == false) { strSQL.Append(@" and (b.oprealgross_int<>?)"); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = 0; } if (p_strProductor.Length > 0) { strSQL.Append(@" and c.productorid_chr like ? "); ++m_intParamCount; tmp_objDPArr[m_intParamCount - 1].Value = p_strProductor + "%"; } //if (p_strPrepType.Length > 0) //{ // strSQL.Append(@" and c.medicinepreptype_chr = ? "); // ++m_intParamCount; // tmp_objDPArr[m_intParamCount - 1].Value = p_strPrepType; //} string strType = string.Empty; string strPrepType = string.Empty; bool blnAll = false; if (p_objPrepTypeArr != null && p_objPrepTypeArr.Length > 0) { for (int i1 = 0; i1 < p_objPrepTypeArr.Length; i1++) { if (p_objPrepTypeArr[i1].m_strMEDICINEPREPTYPE_CHR.Length == 0) { blnAll = true; break; } else { strPrepType += p_objPrepTypeArr[i1].m_strMEDICINEPREPTYPE_CHR + ","; } } if (!blnAll) { strType = " and c.medicinepreptype_chr in (" + strPrepType.Substring(0, strPrepType.Length - 1) + ")"; strSQL.Append(strType); } } strSQL.Append(@" order by c.medicineid_chr,c.assistcode_chr,lotno_vchr"); objHRPServ.CreateDatabaseParameter(m_intParamCount, out objDPArr); for (int i1 = 0; i1 < m_intParamCount; i1++) { objDPArr[i1].Value = tmp_objDPArr[i1].Value; objDPArr[i1].DbType = tmp_objDPArr[i1].DbType; } lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL.ToString(), ref dtbResult, objDPArr); objHRPServ.Dispose(); objHRPServ = null; //合并药品 20080116 暂取消合并功能(考虑到可修改库存量的功能及此需求尚未有客户提出) by shaowei.zheng //double intRealGross = 0; //double intAvailaGross = 0; //double intTemA; //double intTemR; //double intIPRealGross = 0; //double intIPAvailaGross = 0; //double intIPTemA; //double intIPTemR; //DataTable dtbTemp = dtbResult.Clone(); //for (int intRow = 0; intRow < dtbResult.Rows.Count; intRow++) //{ // DataRow dtrTemp = dtbResult.Rows[intRow]; // if ((intRow + 1 >= dtbResult.Rows.Count) || (dtbResult.Rows[intRow]["assistcode_chr"].ToString() != dtbResult.Rows[intRow + 1]["assistcode_chr"].ToString() // || dtbResult.Rows[intRow]["lotno_vchr"].ToString() != dtbResult.Rows[intRow + 1]["lotno_vchr"].ToString() // || Convert.ToDouble(dtbResult.Rows[intRow]["wholesaleprice_int"]) != Convert.ToDouble(dtbResult.Rows[intRow + 1]["wholesaleprice_int"]) // || Convert.ToDouble(dtbResult.Rows[intRow]["retailprice_int"]) != Convert.ToDouble(dtbResult.Rows[intRow + 1]["retailprice_int"]))) // { // if (intRealGross > 0) // { // double.TryParse(Convert.ToString(dtbResult.Rows[intRow]["realgross_int"]),out intTemR); // double.TryParse(Convert.ToString(dtbResult.Rows[intRow]["availagross_int"]),out intTemA); // double.TryParse(Convert.ToString(dtbResult.Rows[intRow]["iprealgross_int"]), out intIPTemR); // double.TryParse(Convert.ToString(dtbResult.Rows[intRow]["ipavailagross_int"]), out intIPTemA); // dtrTemp["realgross_int"] = intTemR + intRealGross; // dtrTemp["availagross_int"] = intTemA + intAvailaGross; // dtrTemp["iprealgross_int"] = intIPTemR + intIPRealGross; // dtrTemp["ipavailagross_int"] = intIPTemA + intIPAvailaGross; // } // dtbTemp.Rows.Add(dtrTemp.ItemArray); // intRealGross = 0; // intAvailaGross = 0; // intIPRealGross = 0; // intIPAvailaGross = 0; // } // else // { // double.TryParse(Convert.ToString(dtrTemp["realgross_int"]), out intTemR); // double.TryParse(Convert.ToString(dtrTemp["availagross_int"]), out intTemA); // double.TryParse(Convert.ToString(dtrTemp["iprealgross_int"]), out intIPTemR); // double.TryParse(Convert.ToString(dtrTemp["ipavailagross_int"]), out intIPTemA); // intRealGross += intTemR; // intAvailaGross += intTemA; // intIPRealGross += intIPTemR; // intIPAvailaGross += intIPTemA; // } //} //dtbResult = dtbTemp; } catch (Exception objEx) { string strTmp = objEx.Message; com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogError(objEx); dtbResult = null; } return(lngRes); }