/// <summary> /// 更新汇报单 /// </summary> /// <param name="model">汇报单</param> /// <param name="detailList">明细</param> /// <param name="SortID"></param> /// <param name="htExtAttr">扩展属性</param> /// <returns></returns> public static bool UpdateReport(StorageQualityCheckReportModel model, List <StorageQualityCheckReportDetailModel> detailList, string[] SortID, Hashtable htExtAttr) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.ReportNo); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; succ = CheckReportDBHelper.UpdateReport(model, detailList, SortID, htExtAttr); 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, ex); return(false); } }
/// <summary> /// 添加质检 /// </summary> /// <param name="model">质检申请单</param> /// <param name="detailList">明细信息</param> /// <param name="htExtAttr">扩展属性</param> /// <returns></returns> public static bool AddReport(StorageQualityCheckReportModel model, List <StorageQualityCheckReportDetailModel> detail, Hashtable htExtAttr) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; try { bool result = false; LogInfoModel logModel = InitLogInfo(model.ReportNo); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; result = CheckReportDBHelper.AddReport(model, detail, htExtAttr); if (!result) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; model.ID = IDIdentityUtil.GetIDIdentity("officedba.QualityCheckReport"); } LogDBHelper.InsertLog(logModel); return(result); } catch (Exception ex) { WriteSystemLog(userInfo, ex); return(false); } }
/// <summary> /// 获取报告单明细详细信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public static DataTable GetReportDetailInfo(StorageQualityCheckReportModel model) { try { return(CheckReportDBHelper.GetReportDetailInfo(model)); } catch (System.Exception ex) { throw ex; } }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; StorageQualityCheckReportModel model = new StorageQualityCheckReportModel(); model.CompanyCD = companyCD; model.Title = this.txtSubject.Text.Trim(); model.ReportNo = this.txtReportNo.Text.Trim(); model.FromType = sltFromType.Value.Trim(); model.FromReportNo = this.tbReportNo.Value; model.CheckType = sltCheckType.Value.Trim(); model.CheckMode = sltCheckMode.Value.Trim(); model.Checker = int.Parse(hiddenChecker.Value); model.ApplyDeptID = int.Parse(hiddenCheckDept.Value); string FlowStatus = ddlFlowStatus.Value; string theBeginTime = BeginTime.Value; string theEndTime = EndTime.Value; model.BillStatus = this.sltBillStatus.Value; int TotalCount = 0; model.Attachment = " ID Desc"; if (this.hiddenOrder.Value != "0") { string[] myOrder = this.hiddenOrder.Value.Split('_'); if (myOrder[1] == "a") { model.Attachment = myOrder[0] + " asc "; } else { model.Attachment = myOrder[0] + " desc "; } } model.Creator = -100; model.Confirmor = -100; string EFIndex = GetBillExAttrControl1.GetExtIndexValue; string EFDesc = GetBillExAttrControl1.GetExtTxtValue; DataTable dt = CheckReportBus.SearchReport(model, theBeginTime, theEndTime, FlowStatus, EFIndex, EFDesc, ref TotalCount); //导出标题 string headerTitle = "单据编号|单据主题|源单类型|往来单位|往来单位类别|质检类别|检验方式|报检人员|报检部门|报检日期|单据状态|审批状态"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "ReportNo|Title|FromTypeName|OtherCorpName|BigTypeName|CheckTypeName|CheckModeName|EmployeeName|DeptName|CheckDate|BillStatus|FlowStatus"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "质检报告单列表"); }
public static string GetCheckSave(StorageQualityCheckReportModel model) { return(CheckReportDBHelper.GetCheckSave(model)); }
/// <summary> /// 确认回写时候 判断已检数量和报检数量 /// </summary> /// <param name="model"></param> /// <returns></returns> public static string CheckConfirm(StorageQualityCheckReportModel model) { return(CheckReportDBHelper.GetCheckConfirm(model)); }
/// <summary> /// 取消确认 /// </summary> /// <param name="model"></param> /// <param name="ID"></param> /// <returns></returns> public static bool UnConfirm(StorageQualityCheckReportModel model) { return(CheckReportDBHelper.UnConfirm(model)); }
public static bool CloseBill(StorageQualityCheckReportModel model, string method) { return(CheckReportDBHelper.CloseBill(model, method)); }
public static bool ConfirmBill(StorageQualityCheckReportModel model) { return(CheckReportDBHelper.ConfirmBill(model)); }
/// <summary> /// 回写生产任务 /// </summary> /// <param name="model"></param> /// <param name="ID"></param> /// <returns></returns> public static bool UpdateMan(StorageQualityCheckReportModel model) { return(CheckReportDBHelper.UpdateManufa(model)); }
/// <summary> /// 检索质检报告 /// </summary> /// <param name="model"></param> /// <param name="BeginTime"></param> /// <param name="EndTime"></param> /// <param name="FlowStatus"></param> /// <param name="ReportID"></param> /// <returns></returns> public static DataTable SearchReport(StorageQualityCheckReportModel model, string BeginTime, string EndTime, string FlowStatus, string EFIndex, string EFDesc, ref int TotalCount) { return(CheckReportDBHelper.GetAllReport(model, BeginTime, EndTime, FlowStatus, EFIndex, EFDesc, ref TotalCount)); }