/// <summary>
/// 添加生产完工入库
/// </summary>
/// <returns>DataTable</returns>
public static bool InsertStorageInProcess(StorageInProcessModel model, System.Collections.Generic.List <StorageInProcessDetailModel> modellist, Hashtable htExtAttr, 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 = StorageInProcessDBHelper.InsertStorageInProcess(model, modellist, htExtAttr, 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.InNo);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
public static bool CancelCloseBill(StorageInProcessModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
//定义返回变量
bool isSucc = false;
/*
* 定义日志内容变量
* 增删改相关的日志，需要输出操作日志，该类型日志插入到数据库
* 其他的 如出现异常时，需要输出系统日志，该类型日志保存到日志文件
*/
//获取公司代码
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//执行删除操作
try
{
//执行更新
isSucc = StorageInProcessDBHelper.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 GetStorageInProcessDetailInfo(string ID, string CompanyCD)
{
try
{
return(StorageInProcessDBHelper.GetStorageInProcessDetailInfo(ID, CompanyCD));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取生产任务单
/// </summary>
/// <param name="companycd"></param>
/// <returns></returns>
public static DataTable GetMTList(ManufactureTaskModel model)
{
try
{
return(StorageInProcessDBHelper.GetMTList(model));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取采购入库详细信息(加载页面的时候)
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageInProcessDetailInfo(StorageInProcessModel model)
{
return(StorageInProcessDBHelper.GetStorageInProcessDetailInfo(model));
}
/// <summary>
///
/// </summary>
/// <param name="model">CompanyCD,ID</param>
/// <returns></returns>
public static bool ISConfirmBill(StorageInProcessModel model)
{
return(StorageInProcessDBHelper.ISConfirmBill(model));
}
public static DataTable GetStorageInProcessTableBycondition(string BatchNo, StorageInProcessModel model, string timeStart, string timeEnd, string StorageID, string FromBillNo, string orderby)
{
return(StorageInProcessDBHelper.GetStorageInProcessTableBycondition(BatchNo, model, timeStart, timeEnd, StorageID, FromBillNo, orderby));
}
/// <summary>
/// 查询仓库
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetStorageInProcessTableBycondition(string BatchNo, StorageInProcessModel model, string timeStart, string timeEnd, string StorageID, string FromBillNo, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(StorageInProcessDBHelper.GetStorageInProcessTableBycondition(BatchNo, model, timeStart, timeEnd, StorageID, FromBillNo, pageIndex, pageCount, ord, ref TotalCount));
}
