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