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));
}
