/// <summary>
/// 新建门店销售退货单
/// </summary>
/// <param name="model"></param>
/// <param name="htExtAttr">扩展属性</param>
/// <param name="DetailProductID"></param>
/// <param name="DetailProductNo"></param>
/// <param name="DetailProductName"></param>
/// <param name="DetailUnitID"></param>
/// <param name="DetailProductCount"></param>
/// <param name="DetailBackCount"></param>
/// <param name="DetailUnitPrice"></param>
/// <param name="DetailTaxPrice"></param>
/// <param name="DetailDiscount"></param>
/// <param name="DetailTaxRate"></param>
/// <param name="DetailTotalPrice"></param>
/// <param name="DetailTotalFee"></param>
/// <param name="DetailTotalTax"></param>
/// <param name="DetailStorageID"></param>
/// <param name="DetailFromBillID"></param>
/// <param name="DetailFromLineNo"></param>
/// <param name="DetailRemark"></param>
/// <param name="length"></param>
/// <param name="ID"></param>
/// <returns></returns>
public static bool InsertSubSellBack(SubSellBackModel model, Hashtable htExtAttr, string DetailProductID, string DetailProductNo, string DetailProductName, string DetailUnitID, string DetailProductCount, string DetailBackCount, string DetailUnitPrice, string DetailTaxPrice, string DetailDiscount, string DetailTaxRate, string DetailTotalPrice, string DetailTotalFee, string DetailTotalTax, string DetailStorageID, string DetailFromBillID, string DetailFromLineNo, string DetailRemark, string DetailUsedUnitID, string DetailUsedUnitCount, string DetailUsedPrice, string DetailExRate, string DetailBatchNo, string length, out string ID)
{
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.BackNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSELLBACKADD;
succ = SubSellBackDBHelper.InsertSubSellBack(model, htExtAttr, DetailProductID, DetailProductNo, DetailProductName, DetailUnitID, DetailProductCount, DetailBackCount, DetailUnitPrice, DetailTaxPrice, DetailDiscount, DetailTaxRate, DetailTotalPrice, DetailTotalFee, DetailTotalTax, DetailStorageID, DetailFromBillID, DetailFromLineNo, DetailRemark, DetailUsedUnitID, DetailUsedUnitCount, DetailUsedPrice, DetailExRate, DetailBatchNo, length, out ID);
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 SubSellBack(int ID)
{
try
{
return(SubSellBackDBHelper.SubSellBack(ID));
}
catch
{
return(null);
}
}
public static DataTable SelectSubSellBack(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string BackNo, string Title, string OrderID, string CustName, string CustTel, string DeptID, string Seller, string BusiStatus, string BillStatus, string CustAddr, string EFIndex, string EFDesc)
{
try
{
return(SubSellBackDBHelper.SelectSubSellBack(pageIndex, pageCount, orderBy, ref TotalCount, BackNo, Title, OrderID, CustName, CustTel, DeptID, Seller, BusiStatus, BillStatus, CustAddr, EFIndex, EFDesc));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetSubSellBackDetail(int DeptID, string OrderNo, string SendMode, string CompanyCD, int CurrencyTypeID, string Rate)
{
try
{
return(SubSellBackDBHelper.GetSubSellBackDetail(DeptID, OrderNo, SendMode, CompanyCD, CurrencyTypeID, Rate));
}
catch
{
return(null);
}
}
public static DataTable Details(int ID)
{
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
try
{
return(SubSellBackDBHelper.Details(ID, CompanyCD));
}
catch
{
return(null);
}
}
public static bool DeleteSubSellBack(string IDs, string BackNos, string CompanyCD)
{
var BIANHAO = BackNos.Replace("'", "");//此方法当编号规则里不存在'时可以
LogInfoModel logModel = InitLogInfo(BIANHAO);
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSELLBACKLIST;
ArrayList lstDelete = new ArrayList();
SqlCommand deletePri = SubSellBackDBHelper.DeleteSubSellBack(IDs);
lstDelete.Add(deletePri);
SqlCommand deleteDeteil = SubSellBackDBHelper.DeleteSubSellBackDetail(BackNos, CompanyCD);
lstDelete.Add(deleteDeteil);
bool isSucc = SqlHelper.ExecuteTransWithArrayList(lstDelete);
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);
}
/// <summary>
/// 绑定门店仓库
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetdrpStorageID()
{
DataTable dt = SubSellBackDBHelper.GetdrpStorageID();
return(dt);
}
public static bool JiesuanubSellBack(SubSellBackModel model)
{
return(SubSellBackDBHelper.JiesuanubSellBack(model));
}
public static bool RukuSubSellBack(SubSellBackModel model, string DetailBackCount, string DetailStorageID, string DetailProductID, string DetailUnitPrice, string DetailBatchNo, string length)
{
return(SubSellBackDBHelper.RukuSubSellBack(model, DetailBackCount, DetailStorageID, DetailProductID, DetailUnitPrice, DetailBatchNo, length));
}
public static bool QxConfirmSubSellBack(SubSellBackModel model, string DetailBackCount, string DetailFromBillNo, string DetailFromLineNo, string length)
{
return(SubSellBackDBHelper.QxConfirmSubSellBack(model, DetailBackCount, DetailFromBillNo, DetailFromLineNo, length));
}
