public List <V_ICPRBILLMODEL> GetPurchasePlanImport3( hn.Core.Model.User loginUser, hn.Common.Cls_query.P_QueryOrder queryCls ) { try { StringBuilder query = new StringBuilder(); if (loginUser.IsAdmin != 1) { query.AppendFormat(" AND FBRANDID IN (SELECT FBRANDID FROM TB_USERBRAND WHERE FUSERID = '{0}') ", loginUser.FID); } query.AppendFormat(" and FBRANDID ='{0}'", queryCls.brand); if (!string.IsNullOrEmpty(queryCls.address)) { query.AppendFormat(" and FRECEIVINGADDR like '%{0}%'", queryCls.address); } if (!string.IsNullOrEmpty(queryCls.P_BillNo)) { query.AppendFormat(" and FBILLNO like '%{0}%'", queryCls.P_BillNo); } if (queryCls.startTime != DateTime.MinValue) { //query.AppendFormat(" and FBILLDATE >= to_date('{0}','yyyyMMdd')", queryCls.startTime); } if (queryCls.endTime != DateTime.MinValue) { //query.AppendFormat(" and FBILLDATE <= to_date('{0}','yyyyMMdd')", queryCls.endTime); } // query.AppendFormat(" and FSTATUS='7' and FID not in (select FPLANID from icprbillentry where FID in (select FPLANID from ICPOBILLENTRY))", ""); query.AppendFormat(" and FSTATUS='7' and FID in (select FPLANID from icprbillentry where ICPOBILLENTRYID is null or ICPOBILLENTRYID='')", ""); LogHelper.WriteLog(query.ToString()); return(V_ICPRBILLDAL.Instance.GetWhereStr(query.ToString(), "FBILLDATE DESC").ToList()); } catch (Exception ex) { LogHelper.WriteLog(ex); throw ex; } }
public hn.DataAccess.Model.V_ICPRBILLMODEL[] GetPurchasePlanImport3(hn.Core.Model.User loginUser, hn.Common.Cls_query.P_QueryOrder pquery) { return(base.Channel.GetPurchasePlanImport3(loginUser, pquery)); }