/// <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));
}
