/// <summary>
/// 插入库存报损和库存报损明细
/// </summary>
/// <param name="model"></param>
/// <param name="modelList"></param>
/// <returns></returns>
public static bool InsertStorageLoss(StorageLossModel model, List <StorageLossDetailModel> 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 = StorageLossDBHelper.InsertStorageLoss(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.LossNo);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
/// <summary>
/// 确认
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool CancelCloseBill(StorageLossModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//获取公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//执行删除操作
try
{
//执行更新
isSucc = StorageLossDBHelper.CancelCloseBill(model);
}
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);
}
public static DataTable GetStorageLossDetailInfo(string ID, string CompanyCD)
{
try
{
return(StorageLossDBHelper.GetStorageLossDetailInfo(ID, CompanyCD));
}
catch (Exception)
{
throw;
}
}
public static bool IsDelStorageLoss(string ID, string CompanyCD)
{
return(StorageLossDBHelper.IsDelStorageLoss(ID, CompanyCD));
}
/// <summary>
/// 获取库存报损详细信息(加载页面的时候)
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageLossDetailInfo(StorageLossModel model)
{
return(StorageLossDBHelper.GetStorageLossDetailInfo(model));
}
public static DataTable GetStorageLossTableBycondition(StorageLossModel model, string IndexValue, string TxtValue, string timeStart, string timeEnd, string TotalPriceStart, string TotalPriceEnd, string FlowStatus, string BatchNo, string orderby)
{
return(StorageLossDBHelper.GetStorageLossTableBycondition(model, IndexValue, TxtValue, timeStart, timeEnd, TotalPriceStart, TotalPriceEnd, FlowStatus, BatchNo, orderby));
}
public static bool CancelConfirmBill(StorageLossModel model)
{
return(StorageLossDBHelper.CancelConfirmBill(model));
}
/// <summary>
/// 查询库存报损单
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageLossTableBycondition(StorageLossModel model, string timeStart, string timeEnd, string TotalPriceStart, string TotalPriceEnd, string FlowStatus, string EFIndex, string EFDesc, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(StorageLossDBHelper.GetStorageLossTableBycondition(model, timeStart, timeEnd, TotalPriceStart, TotalPriceEnd, FlowStatus, EFIndex, EFDesc, pageIndex, pageCount, ord, ref TotalCount));
}