public static bool InsertPurchaseReject(PurchaseRejectModel model, string DetailProductID, string DetailProductNo, string DetailProductName, string DetailUnitID, string DetailProductCount, string DetailBackCount, string DetailApplyReason, string DetailUnitPrice, string DetailTaxPrice, string DetailDiscount, string DetailTaxRate, string DetailTotalPrice, string DetailTotalFee, string DetailTotalTax, string DetailRemark, string DetailFromBillID, string DetailFromLineNo, string DetailUsedUnitCount, string DetailUsedUnitID, string DetailUsedPrice, string length, out string ID, Hashtable hd)
{
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.RejectNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PurchaseReject_Add;
succ = PurchaseRejectDBHelper.InsertPurchaseReject(model, DetailProductID, DetailProductNo, DetailProductName, DetailUnitID, DetailProductCount, DetailBackCount, DetailApplyReason, DetailUnitPrice, DetailTaxPrice, DetailDiscount, DetailTaxRate, DetailTotalPrice, DetailTotalFee, DetailTotalTax, DetailRemark, DetailFromBillID, DetailFromLineNo, DetailUsedUnitCount, DetailUsedUnitID, DetailUsedPrice, length, out ID, hd);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static bool UpdatePurchaseReject(PurchaseRejectModel model, string DetailProductID, string DetailProductNo, string DetailProductName, string DetailUnitID, string DetailProductCount, string DetailBackCount, string DetailApplyReason, string DetailUnitPrice, string DetailTaxPrice, string DetailDiscount, string DetailTaxRate, string DetailTotalPrice, string DetailTotalFee, string DetailTotalTax, string DetailRemark, string DetailFromBillID, string DetailFromBillNo, string DetailFromLineNo, string DetailUsedUnitCount, string DetailUsedUnitID, string DetailUsedPrice, string length, string fflag2, string no, Hashtable ht)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (model.ID <= 0)
{
return(false);
}
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(no);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PurchaseReject_Add;
succ = PurchaseRejectDBHelper.UpdatePurchaseReject(model, DetailProductID, DetailProductNo, DetailProductName, DetailUnitID, DetailProductCount, DetailBackCount, DetailApplyReason, DetailUnitPrice, DetailTaxPrice, DetailDiscount, DetailTaxRate, DetailTotalPrice, DetailTotalFee, DetailTotalTax, DetailRemark, DetailFromBillID, DetailFromBillNo, DetailFromLineNo, DetailUsedUnitCount, DetailUsedUnitID, DetailUsedPrice, length, fflag2, no, ht);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static DataTable Details(int ID, string FormType)
{
try
{
return(PurchaseRejectDBHelper.Details(ID, FormType));
}
catch
{
return(null);
}
}
public static bool IsCitePurchaseReject(int ID)
{
try
{
return(PurchaseRejectDBHelper.IsCitePurchaseReject(ID));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable PurchaseRejectQueryPrint(string ProviderID, string StartConfirmDate, string EndConfirmDate, string CompanyCD)
{
try
{
return(PurchaseRejectDBHelper.PurchaseRejectQueryPrint(ProviderID, StartConfirmDate, EndConfirmDate, CompanyCD));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// </summary>
/// <returns>DataTable</returns>
public static DataTable SelectPurchaseRejectOverviewPrint(string ProductID, string Reason, string StartRejectDate, string EndRejectDate, string orderBy)
{
try
{
return(PurchaseRejectDBHelper.SelectPurchaseRejectOverviewPrint(ProductID, Reason, StartRejectDate, EndRejectDate, orderBy));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable PurchaseRejectQuery(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string ProviderID, string StartConfirmDate, string EndConfirmDate, string CompanyCD)
{
try
{
return(PurchaseRejectDBHelper.PurchaseRejectQuery(pageIndex, pageCount, orderBy, ref TotalCount, ProviderID, StartConfirmDate, EndConfirmDate, CompanyCD));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable SelectReject(int ID)
{
try
{
return(PurchaseRejectDBHelper.SelectReject(ID));
}
catch
{
return(null);
}
}
/// <summary>
/// </summary>
/// <returns>DataTable</returns>
public static DataTable SelectPurchaseRejectOverview(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string ProductID, string Reason, string StartRejectDate, string EndRejectDate)
{
try
{
return(PurchaseRejectDBHelper.SelectPurchaseRejectOverview(pageIndex, pageCount, orderBy, ref TotalCount, ProductID, Reason, StartRejectDate, EndRejectDate));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetPurchaseRejectDetail(string ProductNo, string ProductName, string FromBillNo, string CompanyCD, int ProviderID, int CurrencyTypeID, string Rate, string PurchaseArriveEFIndex, string PurchaseArriveEFDesc)
{
try
{
return(PurchaseRejectDBHelper.GetPurchaseRejectDetail(ProductNo, ProductName, FromBillNo, CompanyCD, ProviderID, CurrencyTypeID, Rate, PurchaseArriveEFIndex, PurchaseArriveEFDesc));
}
catch
{
return(null);
}
}
public static DataTable SelectPurchaseReject(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string RejectNo, string Title, string TypeID, string Purchaser, string FromType, string ProviderID, string BillStatus, string UsedStatus, string DeptID, string ProjectID, string EFIndex, string EFDesc)
{
try
{
return(PurchaseRejectDBHelper.SelectRejectList(pageIndex, pageCount, orderBy, ref TotalCount, RejectNo, Title, TypeID, Purchaser, FromType, ProviderID, BillStatus, UsedStatus, DeptID, ProjectID, EFIndex, EFDesc));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeletePurchaseRejectAll(string DetailNo)
{
LogInfoModel logModel = InitLogInfo(DetailNo);
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PurchaseRejectInfo;
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
string CompanyCD = userInfo.CompanyCD;
//string[] sql = new string[2];
//int index = 0;
//PurchaseRejectDBHelper.DeletePurchaseRejectPrimary(DetailNo, ref sql, index++);
//PurchaseRejectDBHelper.DeletePurchaseRejectDetail(DetailNo, ref sql, index++);
//SqlHelper.ExecuteTransForListWithSQL(sql);
bool isSucc = PurchaseRejectDBHelper.DeletePurchaseRejectPrimary(DetailNo);
//bool isSucc = SqlHelper.Result.OprateCount > 0 ? true : false;
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
logModel.Remark = remark;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
logModel.Remark = remark;
}
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
public static DataTable GetPurchaseRejectSetUpDetails(string companycd, string billstatus, string fromtype, int shstate, string begindate, string enddate, string order, int pageindex, int pagesize, int timeType, string timestr, ref int recordCount)
{
return(PurchaseRejectDBHelper.GetPurchaseRejectSetUpDetails(companycd, billstatus, fromtype, shstate, begindate, enddate, order, pageindex, pagesize, timeType, timestr, ref recordCount));
}
public static DataTable GetPurchaseRejectSetUp(string companycd, string billStatus, string FromType, int shState, string begindate, string enddate, int timeType)
{
return(PurchaseRejectDBHelper.GetPurchaseRejectSetUp(companycd, billStatus, FromType, shState, begindate, enddate, timeType));
}
/// <summary>
/// 绑定采购类别
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetddlTypeID()
{
DataTable dt = PurchaseRejectDBHelper.GetddlTypeID();
return(dt);
}
public static bool CancelConfirmPurchaseReject(PurchaseRejectModel Model, string DetailBackCount, string DetailFromBillNo, string DetailFromLineNo, string DetailProductNo, string length, out string strMsg)
{
return(PurchaseRejectDBHelper.CancelConfirmPurchaseReject(Model, DetailBackCount, DetailFromBillNo, DetailFromLineNo, DetailProductNo, length, out strMsg));
}
/// <summary>
/// 退货物品走势
/// </summary>
public static DataTable GetRejectByProductTrend(string ProviderID, string DeptID, string BeginDate, string EndDate, string DateType, string StatType, string ProductID)
{
return(PurchaseRejectDBHelper.GetRejectByProductTrend(ProviderID, DeptID, BeginDate, EndDate, DateType, StatType, ProductID));
}
public static bool CancelClosePurchaseReject(PurchaseRejectModel Model)
{
return(PurchaseRejectDBHelper.CancelClosePurchaseReject(Model));
}
public static DataTable GetPurchaseRejectProductDetail(string ProviderID, string DeptID, string BeginDate, string EndDate, string DateType, string StatType, string ProductID, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(PurchaseRejectDBHelper.GetPurchaseRejectProductDetail(ProviderID, DeptID, BeginDate, EndDate, DateType, StatType, ProductID, pageIndex, pageCount, ord, ref TotalCount));
}
public static DataTable GetDrpApplyReason()
{
DataTable dt = PurchaseRejectDBHelper.GetDrpApplyReason();
return(dt);
}
