/// <summary>
/// 更新BOM和子件信息
/// </summary>
/// <param name="model"></param>
/// <param name="UpdateID"></param>
/// <returns></returns>
public static bool UpdateManufactureTaskInfo(ManufactureTaskModel model, Hashtable ht, string UpdateID)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
try
{
bool succ = false;
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
LogInfoModel logModel = InitLogInfo(model.TaskNo, 0);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
succ = ManufactureTaskDBHelper.UpdateManufactureTaskInfo(model, ht, loginUserID, UpdateID);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (Exception ex)
{
WriteSystemLog(userInfo, 0, ex);
return(false);
}
}
/// <summary>
/// 确认或结单
/// </summary>
/// <param name="model"></param>
/// <param name="isConfirm"></param>
/// <returns></returns>
public static bool ConfirmOrCompleteManufactureTask(ManufactureTaskModel model, int OperateType)
{
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
//string loginUserID = "admin";//[待修改]
return(ManufactureTaskDBHelper.ConfirmOrCompleteManufactureTask(model, loginUserID, OperateType));
}
/// <summary>
/// 打印生产月报表
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="DeptID"></param>
/// <param name="QueryDate"></param>
/// <param name="orderColumn"></param>
/// <param name="orderType"></param>
/// <returns></returns>
public static DataTable GetManufactureTaskMonthBycondition_Operating_Print(string CompanyCD, int DeptID, string QueryDate, string orderColumn, string orderType)
{
try
{
return(ManufactureTaskDBHelper.GetManufactureTaskMonthBycondition_Operating_Print(CompanyCD, DeptID, QueryDate, orderColumn, orderType));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 生产月报表
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="DeptID"></param>
/// <param name="QueryDate"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="OrderBy"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetManufactureTaskMonthBycondition_Operating(string CompanyCD, int DeptID, string QueryDate, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(ManufactureTaskDBHelper.GetManufactureTaskMonthBycondition_Operating(CompanyCD, DeptID, QueryDate, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 运营模式:打印在制品价值汇总表
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="CheckDateStart"></param>
/// <param name="CheckDateEnd"></param>
/// <param name="orderColumn"></param>
/// <param name="orderType"></param>
/// <returns></returns>
public static DataTable GetRoadStorageProductValueBycondition_Operating_Print(string CompanyCD, int ProductID, string orderColumn, string orderType)
{
try
{
return(ManufactureTaskDBHelper.GetRoadStorageProductValueBycondition_Operating_Print(CompanyCD, ProductID, orderColumn, orderType));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 运营模式:在制品价值汇总表
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="CheckDateStart"></param>
/// <param name="CheckDateEnd"></param>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="OrderBy"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static DataTable GetRoadStorageProductValueBycondition_Operating(string CompanyCD, int ProductID, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(ManufactureTaskDBHelper.GetRoadStorageProductValueBycondition_Operating(CompanyCD, ProductID, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 运营模式:打印生产任务单执行汇总表
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="DeptID"></param>
/// <param name="ConfirmDateStart"></param>
/// <param name="ConfirmDateEnd"></param>
/// <param name="orderColumn"></param>
/// <param name="orderType"></param>
/// <returns></returns>
public static DataTable GetManufactureTaskListBycondition_Operating_Print(string CompanyCD, int DeptID, string ConfirmDateStart, string ConfirmDateEnd, string orderColumn, string orderType)
{
try
{
return(ManufactureTaskDBHelper.GetManufactureTaskListBycondition_Operating_Print(CompanyCD, DeptID, ConfirmDateStart, ConfirmDateEnd, orderColumn, orderType));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 是否被领料单引用
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="ID"></param>
/// <param name="TableName"></param>
/// <returns></returns>
public static int CountRefrenceTakeMaterial(string CompanyCD, string ID, string TableName)
{
try
{
return(ManufactureTaskDBHelper.CountRefrenceTakeMaterial(CompanyCD, ID, TableName, "TaskID"));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 判断要删除的ID是否已经被引用
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="ID"></param>
/// <param name="TableName"></param>
/// <returns></returns>
public static int CountRefrence(string CompanyCD, string ID, string TableName)
{
try
{
return(ManufactureTaskDBHelper.CountRefrence(CompanyCD, ID, TableName, "FromBillNo"));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 通过检索条件查询生产任务单信息
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetManufactureTaskListBycondition(ManufactureTaskModel model, int FlowStatus, int BillTypeFlag, int BillTypeCode, string CreateDate, string EFIndex, string EFDesc, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
try
{
return(ManufactureTaskDBHelper.GetManufactureTaskListBycondition(model, FlowStatus, BillTypeFlag, BillTypeCode, CreateDate, EFIndex, EFDesc, pageIndex, pageCount, OrderBy, ref totalCount));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 主生产计划中是来源自生产的明细
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetMasterProductScheduleFromPlan(string CompanyCD, string strPlanID)
{
try
{
return(ManufactureTaskDBHelper.GetMasterProductScheduleFromPlan(CompanyCD, strPlanID));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 生产任务单明细详细信息
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetTaskDetailInfo(ManufactureTaskModel model)
{
try
{
return(ManufactureTaskDBHelper.GetTaskDetailInfo(model));
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 删除主生产任务
/// </summary>
/// <param name="ID"></param>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static bool DeleteManufactureTask(string ID, string CompanyCD)
{
if (string.IsNullOrEmpty(ID))
{
return(false);
}
if (string.IsNullOrEmpty(CompanyCD))
{
CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
bool isSucc = ManufactureTaskDBHelper.DeleteManufactureTask(ID, CompanyCD);
//定义变量
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
//获取删除的编号列表
string[] noList = ID.Split(',');
//遍历所有编号，登陆操作日志
for (int i = 0; i < noList.Length; i++)
{
//获取编号
string no = noList[i];
//替换两边的 '
no = no.Replace("'", string.Empty);
//操作日志
LogInfoModel logModel = InitLogInfo("生产任务单ID：" + no, 1);
//涉及关键元素 这个需要根据每个页面具体设置，本页面暂时设置为空
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置操作成功标识
logModel.Remark = remark;
//登陆日志
LogDBHelper.InsertLog(logModel);
}
return(isSucc);
}
/// <summary>
/// 取消确认
/// </summary>
/// <param name="model"></param>
/// <param name="isConfirm"></param>
/// <returns></returns>
public static bool CancelConfirmTask(ManufactureTaskModel model, int BillTypeFlag, int BillTypeCode)
{
string loginUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
return(ManufactureTaskDBHelper.CancelConfirmOperate(model, BillTypeFlag, BillTypeCode, loginUserID));
}
