public static bool ConfirmBill(StorageOutSellModel model, out string retval)
{
retval = "";
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//获取公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//执行删除操作
try
{
//执行更新
isSucc = StorageOutSellDBHelper.ConfirmBill(model, out retval);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//操作日志
LogInfoModel logModel = InitLogInfo(model.ID);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = "确认";
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
/// <summary>
/// 插入销售出库和销售出库明细
/// </summary>
/// <param name="model"></param>
/// <param name="modelList"></param>
/// <returns></returns>
public static bool InsertStorageOutSell(StorageOutSellModel model, List <StorageOutSellDetailModel> modelList, Hashtable ht, out int IndexIDentity)
{
IndexIDentity = 0;
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//获取公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//执行删除操作
try
{
//执行更新
isSucc = StorageOutSellDBHelper.InsertStorageOutSell(model, modelList, ht, out IndexIDentity);
}
catch (Exception ex)
{
//输出日志
WriteSystemLog(userInfo, ex);
}
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//操作日志
LogInfoModel logModel = InitLogInfo(model.OutNo);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
public static DataTable GetStorageOutSellDetailInfo(string ID, string CompanyCD)
{
try
{
return(StorageOutSellDBHelper.GetStorageOutSellDetailInfo(ID, CompanyCD));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取销售发货通知单
/// </summary>
/// <param name="companycd"></param>
/// <returns></returns>
public static DataTable GetSellSendList(SellSendModel model)
{
try
{
return(StorageOutSellDBHelper.GetSellSendList(model));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 根据仓库，商品ID获取批次列表
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetBatchNoList(string StorageID, string ProductID, string CompanyCD)
{
return(StorageOutSellDBHelper.GetBatchNoList(StorageID, ProductID, CompanyCD));
}
/// <summary>
/// 查找出当前单据中明细，所有允许的负库存的物品，然后判断是否出库数量大于负库存
/// </summary>
/// <param name="model">CompanyCD,ID</param>
/// <returns>string:行号数组|对应行号的可用库存</returns>
public static string ISBigUseCountWhenCan(StorageOutSellModel model)
{
return(StorageOutSellDBHelper.ISBigUseCountWhenCan(model));
}
/// <summary>
///
/// </summary>
/// <param name="model">CompanyCD,ID</param>
/// <returns></returns>
public static bool ISConfirmBill(StorageOutSellModel model)
{
return(StorageOutSellDBHelper.ISConfirmBill(model));
}
/// <summary>
/// 获取销售出库详细信息(加载页面的时候)
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageOutSellDetailInfo(StorageOutSellModel model)
{
return(StorageOutSellDBHelper.GetStorageOutSellDetailInfo(model));
}
/// <summary>
/// 根据销售退货单明细中ID数组来获取信息（填充入库单中的明细)
/// </summary>
/// <param name="strDetailIDList"></param>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetInfoByDetalIDList(string strDetailIDList, string CompanyCD)
{
return(StorageOutSellDBHelper.GetInfoByDetalIDList(strDetailIDList, CompanyCD));
}
/// <summary>
/// 销售发货明细列表(弹出层显示)
/// </summary>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetSSDetailInfo(string CompanyCD, string SendNo, string Title)
{
return(StorageOutSellDBHelper.GetSSDetailInfo(CompanyCD, SendNo, Title));
}
public static DataTable GetStorageOutSellTableBycondition(StorageOutSellModel model, string IndexValue, string TxtValue, string timeStart, string timeEnd, string SendNo, string BatchNo, string orderby)
{
return(StorageOutSellDBHelper.GetStorageOutSellTableBycondition(model, IndexValue, TxtValue, timeStart, timeEnd, SendNo, BatchNo, orderby));
}
/// <summary>
/// 查询销售出库单
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageOutSellTableBycondition(StorageOutSellModel model, string timeStart, string timeEnd, string SendNo, string EFIndex, string EFDesc, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(StorageOutSellDBHelper.GetStorageOutSellTableBycondition(model, timeStart, timeEnd, SendNo, EFIndex, EFDesc, pageIndex, pageCount, ord, ref TotalCount));
}