protected override bool ValidateInput() { PageCheckManager manager = new PageCheckManager(); manager.Add(new DateCheck(this.lblDate, this.dateDateFrom.Text, true)); manager.Add(new LengthCheck(lblBigSSCodeGroup, txtBigSSCodeGroup, 40, true)); manager.Add(new LengthCheck(lblMOEdit, txtMOEdit, 40, true)); manager.Add(new LengthCheck(lblMactureSeq, txtMactureSeq, 10, true)); manager.Add(new LengthCheck(lblMOSeqEdit, txtMOSeqEdit, 10, true)); manager.Add(new DecimalCheck(lblPlanInQTYEdit, txtPlanInQTYEdit, 0, 9999999999, true)); manager.Add(new TimeRangeCheck(this.lblPlanInStartDateEdit, this.timeFrom.Text, this.timeFrom.Text, true)); if (this.txtMOSeqEdit.Text.Trim().Length > 0) { manager.Add(new NumberCheck(lblMOSeqEdit, txtMOSeqEdit, 0, 9999999999, true)); } if (this.txtMactureSeq.Text.Trim().Length > 0) { manager.Add(new NumberCheck(lblMactureSeq, txtMactureSeq, 0, 9999999999, true)); } if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return(false); } if (_MoFacade == null) { _MoFacade = new MOFacade(base.DataProvider); } object objMo = _MoFacade.GetMO(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOEdit.Text))); if (objMo == null) { WebInfoPublish.Publish(this, "$CS_MO_Not_Exist", languageComponent1); return(false); } if (_Facade == null) { _Facade = new MaterialFacade(base.DataProvider); } ShiftModelFacade shiftModelFacade = new ShiftModelFacade(base.DataProvider); DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(base.DataProvider); WorkPlan GetWorkPlanByKeys = (WorkPlan)_Facade.GetWorkPlan(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtBigSSCodeGroup.Text)), FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMOEdit.Text)), int.Parse(FormatHelper.CleanString(this.txtMOSeqEdit.Text))); WorkPlan GetWorkPlanByUnipues = (WorkPlan)_Facade.GetWorkPlan(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtBigSSCodeGroup.Text)), FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String)), int.Parse(FormatHelper.CleanString(this.txtMactureSeq.Text))); if (GetWorkPlanByKeys == null && GetWorkPlanByUnipues != null) { WebInfoPublish.PublishInfo(this, "$date__isunique", languageComponent1); return(false); } if (GetWorkPlanByKeys != null && GetWorkPlanByUnipues != null) { if (GetWorkPlanByKeys.BigSSCode != GetWorkPlanByUnipues.BigSSCode || GetWorkPlanByKeys.PlanDate != GetWorkPlanByUnipues.PlanDate || GetWorkPlanByKeys.MoCode != GetWorkPlanByUnipues.MoCode || GetWorkPlanByKeys.MoSeq != GetWorkPlanByUnipues.MoSeq) { WebInfoPublish.PublishInfo(this, "$date__isunique", languageComponent1); return(false); } } int shiftDay = shiftModelFacade.GetShiftDayByBigSSCode( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(txtBigSSCodeGroup.Text)), dbDateTime.DateTime); if (FormatHelper.TODateInt(FormatHelper.CleanString(this.dateDateFrom.Date_String)) < shiftDay) { WebInfoPublish.PublishInfo(this, "$if_date_cannotmodify", languageComponent1); return(false); } return(true); }
private object GetEditObject() { if (_facade == null) { _facade = new MOFacade(base.DataProvider); } if (ValidateInput()) { MO mo = (MO)this._facade.GetMO(GetMOCode()); mo.Factory = FormatHelper.CleanString(this.txtFactoryEdit.Text, 40); // this.drpMOTypeEdit.SelectedIndex =0; // this.drpMOStatusEdit.SelectedIndex =0; // this.txtCustomerCodeEdit.Text = string.Empty; // this.txtCustomerOrderNOEdit.Text = string.Empty; // this.txtMemo.Text = string.Empty; // this.drpRouteEdit.SelectedIndex =0; // this.chbLimitItemQtyEdit.Checked = false; // this.txtMOQtyEdit.Text = string.Empty; // this.txtInputQtyEdit.Text = string.Empty; // this.txtCompleteQtyEdit.Text = string.Empty; // this.txtUnCompleteQtyEdit.Text = string.Empty; // this.txtPlanStartDateEdit.Text = string.Empty; // this.txtPlanEndDateEdit.Text = string.Empty; // this.txtActualStartDateEdit.Text = string.Empty; // this.txtActualEndDateEdit.Text = string.Empty; // this.txtMOUserEdit.Text = string.Empty; // this.txtMODownloadDateEdit.Text = string.Empty; // this.txtScrapeQtyEdit.Text = string.Empty; mo.MOType = FormatHelper.CleanString(this.drpMOTypeEdit.SelectedValue, 40); mo.MOPlanStartDate = FormatHelper.TODateInt(this.txtPlanStartDateEdit.Text); mo.MOPlanEndDate = FormatHelper.TODateInt(this.txtPlanEndDateEdit.Text); mo.CustomerOrderNO = FormatHelper.CleanString(this.txtCustomerOrderNOEdit.Text, 40); mo.CustomerCode = FormatHelper.CleanString(this.txtCustomerCodeEdit.Text, 40); mo.MODownloadDate = FormatHelper.TODateInt(this.txtMODownloadDateEdit.Text); mo.MOUser = FormatHelper.CleanString(this.txtMOUserEdit.Text, 40); mo.MOStatus = FormatHelper.CleanString(this.drpMOStatusEdit.SelectedValue, 40); mo.MOActualStartDate = (this.txtActualStartDateEdit.Text == "") ? 0 : FormatHelper.TODateInt(this.txtActualStartDateEdit.Text); //modify by Simone mo.MOActualEndDate = (this.txtActualEndDateEdit.Text == "") ? 0 : FormatHelper.TODateInt(this.txtActualEndDateEdit.Text); mo.ItemCode = FormatHelper.CleanString(this.txtItemCodeEdit.Text, 40); mo.MaintainUser = this.GetUserCode(); mo.IsControlInput = FormatHelper.BooleanToString(this.chbLimitItemQtyEdit.Checked); mo.IDMergeRule = System.Int32.Parse(FormatHelper.CleanString(this.txtDenominatorEdit.Text)); mo.MOPendingCause = FormatHelper.CleanString(this.txtPendingCause.Text, 50); mo.MOPlanQty = System.Decimal.Parse(FormatHelper.CleanString(this.txtMOQtyEdit.Text)); mo.MOBIOSVersion = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtBIOSVersion.Text)); mo.MOPCBAVersion = FormatHelper.CleanString(this.txtPCBAVersion.Text); //Laws Lu,2006/07/05 support RMA mo.RMABillCode = FormatHelper.CleanString(this.txtRMABillNo.Text); mo.IsCompareSoft = (true == this.chbBIOSVersion.Checked) ? 1 : 0; mo.BOMVersion = this.txtMOBomEdit.Text.Trim(); mo.MOMemo = FormatHelper.CleanString(this.txtMemo.Text, 100); mo.MORemark = FormatHelper.CleanString(this.txtMORemarkEdit.Text, 500); if (mo.MORemark == "") { mo.MORemark = " "; } return(mo); } else { return(null); } }
protected void cmdMOExport_ServerClick(object sender, System.EventArgs e) { string downloadPhysicalPath = this.Request.PhysicalApplicationPath + @"upload\"; if (!Directory.Exists(downloadPhysicalPath)) { Directory.CreateDirectory(downloadPhysicalPath); } string filename = string.Format("{0}_{1}", FormatHelper.TODateInt(System.DateTime.Now).ToString(), FormatHelper.TOTimeInt(System.DateTime.Now).ToString()); string filepath = string.Format(@"{0}{1}{2}", downloadPhysicalPath, filename, ".csv"); while (File.Exists(filepath)) { filename = string.Format("{0}_{1}", filename, "0"); filepath = string.Format(@"{0}{1}{2}", downloadPhysicalPath, filename, ".csv"); } StreamWriter writer = new StreamWriter(filepath, false, System.Text.Encoding.GetEncoding("GB2312")); writer.WriteLine("工单代码" + "," + "计划数量" + "," + "工单别" + "," + "工单BOM" + "," + "计划开工日期" + "," + "计划开工时间" + "," + "计划完工日期" + "," + "计划完工时间" + "," + "计划生产产线" + "," + "客户代码" + "," + "客户名称" + "," + "客户订单号" + "," + "客户料号" + "," + "订单号" + "," + "订单项次" + "," + "预留栏位1" + "," + "预留栏位4" + "," + "预留栏位5" + "," + "预留栏位6"); if (_facade == null) { _facade = new MOFacade(base.DataProvider); } ArrayList array = this.gridHelper.GetCheckedRows(); if (array.Count > 0) { ArrayList objs = new ArrayList(array.Count); foreach (GridRecord row in array) { object obj = this.GetEditObject(row); if (obj != null) { MO objMO = obj as MO; writer.WriteLine(ReplaceStr(objMO.MOCode) + "," + ReplaceStr(objMO.MOPlanQty.ToString()) + "," + ReplaceStr(objMO.MOMemo) + "," + ReplaceStr(objMO.BOMVersion) + "," + ReplaceStr(objMO.MOPlanStartDate.ToString()) + "," + ReplaceStr(objMO.MOPlanStartTime.ToString()) + "," + ReplaceStr(objMO.MOPlanEndDate.ToString()) + "," + ReplaceStr(objMO.MOPlanEndTime.ToString()) + "," + ReplaceStr(objMO.MOPlanLine) + "," + ReplaceStr(objMO.CustomerCode) + "," + ReplaceStr(objMO.CustomerName) + "," + ReplaceStr(objMO.CustomerOrderNO) + "," + ReplaceStr(objMO.CustomerItemCode) + "," + ReplaceStr(objMO.OrderNO) + "," + ReplaceStr(objMO.OrderSequence.ToString()) + "," + ReplaceStr(objMO.EAttribute1) + "," + ReplaceStr(objMO.EAttribute4) + "," + ReplaceStr(objMO.EAttribute5) + "," + ReplaceStr(objMO.EAttribute6)); } } } writer.Flush(); writer.Close(); this.DownloadFile(filename); //Response.Write(@"<iframe width='0' height='0' src=" // + string.Format(@"{0}FDownload.aspx", pageVirtualHostRoot) // + "?fileName=" + string.Format(@"{0}{1}", pageVirtualHostRoot + "upload/", filename + ".csv") // + "></iframe><script language=javascript>window.setTimeout('history.back()',2000);</script>" // ); }
private void SetMOStatus(string newStatus) { if (_facade == null) { _facade = new MOFacade(base.DataProvider); } ModelFacade modelFacade = new FacadeFactory(base.DataProvider).CreateModelFacade(); ArrayList array = this.gridHelper.GetCheckedRows(); if (array.Count > 0) { ArrayList objs = new ArrayList(array.Count); foreach (GridRecord row in array) { object obj = this.GetEditObject(row); MO mo = null; if (obj != null) { mo = obj as MO; mo.MOStatus = newStatus; mo.MaintainUser = this.GetUserCode(); if (mo.EAttribute3 == AlertJob.alertJob) { ExceptionManager.Raise(this.GetType(), string.Format("$MOCode = {0}, $MO_STATUS_CHANGE", mo.MOCode)); return; } if (newStatus == MOManufactureStatus.MOSTATUS_RELEASE) { string itemCode = mo.ItemCode; object model = modelFacade.GetModelByItemCode(itemCode); if (model == null) { ExceptionManager.Raise(this.GetType(), string.Format("$Domain_ItemCode = {0}, $Error_Item_Not_Maintain_Model", itemCode)); return; } mo.MOReleaseDate = FormatHelper.TODateInt(DateTime.Now); mo.MOReleaseTime = FormatHelper.TOTimeInt(DateTime.Now); SystemSettingFacade systemSettingFacade = new SystemSettingFacade(this.DataProvider); if (mo.MOMemo == null || mo.MOMemo.Trim().Length <= 0) { //如果下发时momemo字段为空,从系统参数中抓取 string moMemo = systemSettingFacade.GetParameterAlias("DEFAULT_MO_PRODUCT_TYPE", "MPR"); if (moMemo.Trim().Length > 0) { mo.MOMemo = moMemo.Trim(); } } else { //检查是否该值和维护在参数中的一致,包括大小写也需要一致。 //如果不一致,则提示:工单类别维护错误,请检查。 object[] parameterList = systemSettingFacade.QueryParameter(string.Empty, "MO_PRODUCT_TYPE", int.MinValue, int.MaxValue); bool found = false; if (parameterList != null) { foreach (Domain.BaseSetting.Parameter parameter in parameterList) { if (string.Compare(mo.MOMemo, parameter.ParameterAlias, false) == 0) { found = true; break; } } } if (!found) { ExceptionManager.Raise(this.GetType(), "$CS_WrongMOMemo $MOCode=" + mo.MOCode); } } } if (newStatus == MOManufactureStatus.MOSTATUS_INITIAL) { mo.MOReleaseDate = 0; mo.MOReleaseTime = 0; } if (newStatus == MOManufactureStatus.MOSTATUS_CLOSE) { mo.MOActualEndDate = FormatHelper.TODateInt(DateTime.Now); } objs.Add(mo); } } if (objs.Count == 0) { return; } this._facade.MOStatusChanged((MO[])objs.ToArray(typeof(MO))); this.RequestData(); } }
private int GetRowCount() { if (this.txtActstarDateFrom.Text.Trim() != string.Empty) { PageCheckManager manager = new PageCheckManager(); manager.Add(new LengthCheck(this.lblActstarDateFrom, this.txtActstarDateFrom, 5, false)); manager.Add(new NumberCheck(this.lblActstarDateFrom, this.txtActstarDateFrom, false)); if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return(0); } } if (this.txtActstarDateTo.Text.Trim() != string.Empty) { PageCheckManager manager = new PageCheckManager(); manager.Add(new LengthCheck(this.lblActstarDateTo, this.txtActstarDateTo, 5, false)); manager.Add(new NumberCheck(this.lblActstarDateTo, this.txtActstarDateTo, false)); if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return(0); } } if (this.txtActstarDateFrom.Text.Trim() != string.Empty && this.txtActstarDateTo.Text.Trim() != string.Empty) { if (Convert.ToInt32(this.txtActstarDateTo.Text.Trim()) - Convert.ToInt32(this.txtActstarDateFrom.Text.Trim()) < 0) { WebInfoPublish.Publish(this, "$CS_ActstarDate_Must_Over_Zero", this.languageComponent1); return(0); } } int ActstarDateFrom = 0; if (this.txtActstarDateTo.Text.Trim() != string.Empty) { ActstarDateFrom = FormatHelper.TODateInt(DateTime.Now.Date.AddDays(-Convert.ToInt32(this.txtActstarDateTo.Text.Trim()))); } int ActstarDateTo = 0; if (this.txtActstarDateFrom.Text.Trim() != string.Empty && Convert.ToInt32(this.txtActstarDateFrom.Text.Trim()) != 0) { ActstarDateTo = FormatHelper.TODateInt(DateTime.Now.Date.AddDays(-Convert.ToInt32(this.txtActstarDateFrom.Text.Trim()))); } if (_facade == null) { _facade = new MOFacade(base.DataProvider); } if (this.chbImportDate.Checked && this.chbUseDate.Checked) { return(this._facade.QueryMOIllegibilityCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), FormatHelper.TODateInt(this.dateInDateFromQuery.Text), FormatHelper.TODateInt(this.dateInDateToQuery.Text), FormatHelper.TODateInt(this.ImportDateFrom.Text), FormatHelper.TODateInt(this.ImportDateTo.Text), ActstarDateFrom, ActstarDateTo)); } else if (this.chbImportDate.Checked && !this.chbUseDate.Checked) { return(this._facade.QueryMOIllegibilityCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), 0, 0, FormatHelper.TODateInt(this.ImportDateFrom.Text), FormatHelper.TODateInt(this.ImportDateTo.Text), ActstarDateFrom, ActstarDateTo)); } else if (!this.chbImportDate.Checked && this.chbUseDate.Checked) { return(this._facade.QueryMOIllegibilityCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), FormatHelper.TODateInt(this.dateInDateFromQuery.Text), FormatHelper.TODateInt(this.dateInDateToQuery.Text), 0, 0, ActstarDateFrom, ActstarDateTo)); } return(this._facade.QueryMOIllegibilityCount( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), 0, 0, 0, 0, ActstarDateFrom, ActstarDateTo)); }
private object[] LoadDataSource(int inclusive, int exclusive) { /* modified by jessie lee, 2005/12/8 * CS187 工单的查询结果栏位增加“导入日期”栏位。 * 工单的查询条件增加“导入日期过滤”开关项,打开后,导入起始日期默认为10天前,导入结束日期默认为当天。 * 执行查询,依据导入日期的范围对工单记录进行过滤。 */ if (this.chbImportDate.Checked) { PageCheckManager manager = new PageCheckManager(); manager.Add(new DateRangeCheck(this.lblEnterDate, this.ImportDateFrom.Text, this.ImportDateTo.Text, false)); if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return(null); } } if (this.chbUseDate.Checked) { PageCheckManager manager = new PageCheckManager(); manager.Add(new DateRangeCheck(this.lblInDateFromQuery, this.dateInDateFromQuery.Text, this.dateInDateToQuery.Text, false)); if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return(null); } } if (this.txtActstarDateFrom.Text.Trim() != string.Empty) { PageCheckManager manager = new PageCheckManager(); manager.Add(new LengthCheck(this.lblActstarDateFrom, this.txtActstarDateFrom, 5, false)); manager.Add(new NumberCheck(this.lblActstarDateFrom, this.txtActstarDateFrom, false)); if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return(null); } } if (this.txtActstarDateTo.Text.Trim() != string.Empty) { PageCheckManager manager = new PageCheckManager(); manager.Add(new LengthCheck(this.lblActstarDateTo, this.txtActstarDateTo, 5, false)); manager.Add(new NumberCheck(this.lblActstarDateTo, this.txtActstarDateTo, false)); if (!manager.Check()) { WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1); return(null); } } if (this.txtActstarDateFrom.Text.Trim() != string.Empty && this.txtActstarDateTo.Text.Trim() != string.Empty) { if (Convert.ToInt32(this.txtActstarDateTo.Text.Trim()) - Convert.ToInt32(this.txtActstarDateFrom.Text.Trim()) < 0) { WebInfoPublish.Publish(this, "$CS_ActstarDate_Must_Over_Zero", this.languageComponent1); return(null); } } int ActstarDateFrom = 0; if (this.txtActstarDateTo.Text.Trim() != string.Empty) { ActstarDateFrom = FormatHelper.TODateInt(DateTime.Now.Date.AddDays(-Convert.ToInt32(this.txtActstarDateTo.Text.Trim()))); } int ActstarDateTo = 0; if (this.txtActstarDateFrom.Text.Trim() != string.Empty && Convert.ToInt32(this.txtActstarDateFrom.Text.Trim()) != 0) { ActstarDateTo = FormatHelper.TODateInt(DateTime.Now.Date.AddDays(-Convert.ToInt32(this.txtActstarDateFrom.Text.Trim()))); } if (_facade == null) { _facade = new MOFacade(this.DataProvider); } if (this.chbImportDate.Checked && this.chbUseDate.Checked) { return(this._facade.QueryMOIllegibility( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), FormatHelper.TODateInt(this.dateInDateFromQuery.Text), FormatHelper.TODateInt(this.dateInDateToQuery.Text), FormatHelper.TODateInt(this.ImportDateFrom.Text), FormatHelper.TODateInt(this.ImportDateTo.Text), ActstarDateFrom, ActstarDateTo, inclusive, exclusive)); } else if (this.chbImportDate.Checked && !this.chbUseDate.Checked) { return(this._facade.QueryMOIllegibility( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), 0, 0, FormatHelper.TODateInt(this.ImportDateFrom.Text), FormatHelper.TODateInt(this.ImportDateTo.Text), ActstarDateFrom, ActstarDateTo, inclusive, exclusive)); } else if (!this.chbImportDate.Checked && this.chbUseDate.Checked) { return(this._facade.QueryMOIllegibility( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), FormatHelper.TODateInt(this.dateInDateFromQuery.Text), FormatHelper.TODateInt(this.dateInDateToQuery.Text), 0, 0, ActstarDateFrom, ActstarDateTo, inclusive, exclusive)); } return(this._facade.QueryMOIllegibility( FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text)), FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text)), FormatHelper.CleanString(this.txtItemDescription.Text), FormatHelper.CleanString(this.drpMoTypeQuery.SelectedValue), FormatHelper.CleanString(this.drpMoStatusQuery.SelectedValue), string.Empty, FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFactoryQuery.Text)), 0, 0, 0, 0, ActstarDateFrom, ActstarDateTo, inclusive, exclusive)); }
protected void cmdDownload_ServerClick(object sender, System.EventArgs e) { if (facade == null) { facade = new FacadeFactory(base.DataProvider).CreateMOFacade(); } if (this.ViewState["UploadedFileName"] == null) { ExceptionManager.Raise(this.GetType().BaseType, "$Error_NOExamineFile"); } ArrayList array = this.gridHelper.GetCheckedRows(); if (array.Count > 0) { ArrayList moCodes = new ArrayList(array.Count); foreach (GridRecord row in array) { moCodes.Add(row.Items.FindItemByKey("MOCode").Value.ToString()); } this.RequestData(); this.DataProvider.BeginTransaction(); try { foreach (MO mo in this.mos) { foreach (string code in moCodes) { if (mo.MOCode == code) { /*CS187 工单增加“导入日期”栏位*/ //DateTime newDT = DateTime.Now; //mo.MOImportDate = FormatHelper.TODateInt(newDT); //mo.MOImportTime = FormatHelper.TOTimeInt(newDT); DBDateTime dbTime = FormatHelper.GetNowDBDateTime(this.DataProvider); mo.MOImportDate = dbTime.DBDate; mo.MOImportTime = dbTime.DBTime; mo.IDMergeRule = 1; //mo.MORemark = string.Empty; mo.OrganizationID = GlobalVariables.CurrentOrganizations.First().OrganizationID; //清空提示信息 mo.EAttribute6 = string.Empty; try { facade.AddMO(mo); continue; } catch (Exception) { this.DataProvider.RollbackTransaction(); WebInfoPublish.Publish(this, "$MoCode_Import_Filed", this.languageComponent1); this.cmdEnter.Disabled = true; } } } } } catch (Exception ex) { this.DataProvider.RollbackTransaction(); ExceptionManager.Raise(this.GetType().BaseType, ex.Message); } this.DataProvider.CommitTransaction(); this.gridWebGrid.Rows.Clear(); WebInfoPublish.Publish(this, "$MoCode_Import_Success", this.languageComponent1); this.cmdEnter.Disabled = true; } }