protected override string[] FormatExportRecord(object obj)
{
SMTFeederMaterialImportLog item = (SMTFeederMaterialImportLog)obj;
return(new string[] {
item.ProductCode,
item.StepSequenceCode,
item.ImportUser,
FormatHelper.ToDateString(item.ImportDate),
FormatHelper.ToTimeString(item.ImportTime)
});
}
protected override string[] FormatExportRecord(object obj)
{
SMTFeederMaterialImportLog item = (SMTFeederMaterialImportLog)obj;
if (item.CheckDescription != null && item.CheckDescription != string.Empty && htMsg.ContainsKey(item.CheckDescription) == false)
{
htMsg.Add(item.CheckDescription, this.languageComponent1.GetString(item.CheckDescription));
}
return(new string[] {
item.Sequence.ToString(),
item.ProductCode,
item.StepSequenceCode,
item.MachineCode,
item.MachineStationCode,
item.SourceMaterialCode,
item.MaterialCode,
item.FeederSpecCode,
item.Qty.ToString(),
FormatHelper.StringToBoolean(item.CheckResult).ToString(),
(item.CheckDescription != null && item.CheckDescription != string.Empty ? htMsg[item.CheckDescription].ToString() : string.Empty)
});
}
protected override DataRow GetGridRow(object obj)
{
SMTFeederMaterialImportLog item = (SMTFeederMaterialImportLog)obj;
if (item.CheckDescription != null && item.CheckDescription != string.Empty && htMsg.ContainsKey(item.CheckDescription) == false)
{
htMsg.Add(item.CheckDescription, this.languageComponent1.GetString(item.CheckDescription));
}
//return new Infragistics.WebUI.UltraWebGrid.UltraGridRow(
// new object[]{
// "",
// item.Sequence.ToString(),
// item.ProductCode,
// item.StepSequenceCode,
// item.MachineCode,
// item.MachineStationCode,
// item.SourceMaterialCode,
// item.MaterialCode,
// item.FeederSpecCode,
// item.Qty,
// FormatHelper.StringToBoolean(item.CheckResult).ToString(),
// (item.CheckDescription != null && item.CheckDescription != string.Empty ? htMsg[item.CheckDescription].ToString() : string.Empty)
// });
DataRow row = this.DtSource.NewRow();
row["Sequence"] = item.Sequence.ToString();
row["ProductCode"] = item.ProductCode;
row["sscode"] = item.StepSequenceCode;
row["MachineCode"] = item.MachineCode;
row["MachineItemCode"] = item.MachineStationCode;
row["SourceMaterialCode"] = item.SourceMaterialCode;
row["MaterialCode"] = item.MaterialCode;
row["FeederSpecCode"] = item.FeederSpecCode;
row["Qty"] = String.Format("{0:#,#}", item.Qty);
row["CheckResult"] = FormatHelper.StringToBoolean(item.CheckResult).ToString();
row["CheckDescription"] = (item.CheckDescription != null && item.CheckDescription != string.Empty ? htMsg[item.CheckDescription].ToString() : string.Empty);
return(row);
}
protected override DataRow GetGridRow(object obj)
{
SMTFeederMaterialImportLog item = (SMTFeederMaterialImportLog)obj;
//return new Infragistics.WebUI.UltraWebGrid.UltraGridRow(
// new object[]{
// "",
// item.LOGNO.ToString(),
// item.ProductCode,
// item.StepSequenceCode,
// item.ImportUser,
// FormatHelper.ToDateString(item.ImportDate),
// FormatHelper.ToTimeString(item.ImportTime),
// ""
// });
DataRow row = this.DtSource.NewRow();
row["LogNo"] = item.LOGNO.ToString();
row["ProductCode"] = item.ProductCode;
row["sscode"] = item.StepSequenceCode;
row["ImportUser"] = item.ImportUser;
row["ImportDate"] = FormatHelper.ToDateString(item.ImportDate);
row["ImportTime"] = FormatHelper.ToTimeString(item.ImportTime);
return(row);
}
protected override void AddDomainObject(object domainObject)
{
if (_facade == null)
{
_facade = new SMTFacadeFactory(base.DataProvider).Create();
}
DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
try
{
//判断数据的合法性
ArrayList list = CheckItem(domainObject);
if (list.Count == 0)
{
WebInfoPublish.Publish(this, "$Error_DataMaterial_Right", this.languageComponent1);
return;
}
SMTFeederMaterial item = list[0] as SMTFeederMaterial;
if (item.EAttribute1 != "True")
{
WebInfoPublish.Publish(this, item.EAttribute1, this.languageComponent1);
return;
}
this.DataProvider.BeginTransaction();
//根据产品代码+产线代码得到TBLSMTFEEDERMATERIALIMPLOG最大logno
object obj = _facade.GetSMTFeederMaterialOfMaxLogNo((domainObject as SMTFeederMaterial).ProductCode, (domainObject as SMTFeederMaterial).StepSequenceCode);
if (obj == null || (obj as SMTFeederMaterialImportLog).LOGNO < 1)
{
_facade.UpdateMachineFeeder(item.ProductCode, item.StepSequenceCode);
_facade.AddSMTFeederMaterial(item);
decimal logNo = 1;
object objMaxLotNo = _facade.GetMaxLotNoSmtFeedermateriaLog();
if (objMaxLotNo != null)
{
logNo = (objMaxLotNo as SMTFeederMaterialImportLog).LOGNO + 1;
}
//_facade.ImportSMTFeederMaterial(new object[] { domainObject }, this.GetUserCode());
// 加入Log
SMTFeederMaterialImportLog log = new SMTFeederMaterialImportLog();
log.LOGNO = logNo;
log.Sequence = 1;
log.ImportUser = this.GetUserCode();
log.ImportDate = dbDateTime.DBDate;
log.ImportTime = dbDateTime.DBTime;
log.CheckResult = FormatHelper.BooleanToString(true);
if (Convert.ToBoolean(item.EAttribute1.Split(':')[0]) == false)
{
log.CheckResult = FormatHelper.BooleanToString(false);
log.CheckDescription = item.EAttribute1.Split(':')[1];
}
log.MachineCode = item.MachineCode;
log.MachineStationCode = item.MachineStationCode;
log.ProductCode = item.ProductCode;
log.StepSequenceCode = item.StepSequenceCode;
log.MaterialCode = item.MaterialCode;
log.SourceMaterialCode = item.SourceMaterialCode;
log.FeederSpecCode = item.FeederSpecCode;
log.Qty = item.Qty;
log.TableGroup = item.TableGroup;
log.MaintainUser = item.MaintainUser;
log.MaintainDate = item.MaintainDate;
log.MaintainTime = item.MaintainTime;
_facade.AddSMTFeederMaterialImportLog(log);
}
else
{
object[] objs = _facade.QuerySMTFeederMaterialImportLog((obj as SMTFeederMaterialImportLog).LOGNO, item.ProductCode, item.StepSequenceCode, item.MachineCode, item.MachineStationCode);
if (objs != null && objs.Length > 0)
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.Publish(this, "$Message_FeederMaterialData_Exist", this.languageComponent1);
return;
}
else
{
_facade.UpdateMachineFeeder(item.ProductCode, item.StepSequenceCode);
_facade.AddSMTFeederMaterial(item);
//_facade.ImportSMTFeederMaterial(new object[] { domainObject }, this.GetUserCode());
// 加入Log
decimal sequence = 1;
object objMaxSeq = _facade.GetMaxSeqSmtFeederMaterialLog((obj as SMTFeederMaterialImportLog).LOGNO);
if (objMaxSeq != null)
{
sequence = (objMaxSeq as SMTFeederMaterialImportLog).Sequence + 1;
}
SMTFeederMaterialImportLog log = new SMTFeederMaterialImportLog();
log.LOGNO = (obj as SMTFeederMaterialImportLog).LOGNO;
log.Sequence = sequence;
log.ImportUser = this.GetUserCode();
log.ImportDate = dbDateTime.DBDate;
log.ImportTime = dbDateTime.DBTime;
log.CheckResult = FormatHelper.BooleanToString(true);
if (Convert.ToBoolean(item.EAttribute1.Split(':')[0]) == false)
{
log.CheckResult = FormatHelper.BooleanToString(false);
log.CheckDescription = item.EAttribute1.Split(':')[1];
}
log.MachineCode = item.MachineCode;
log.MachineStationCode = item.MachineStationCode;
log.ProductCode = item.ProductCode;
log.StepSequenceCode = item.StepSequenceCode;
log.MaterialCode = item.MaterialCode;
log.SourceMaterialCode = item.SourceMaterialCode;
log.FeederSpecCode = item.FeederSpecCode;
log.Qty = item.Qty;
log.TableGroup = item.TableGroup;
log.MaintainUser = item.MaintainUser;
log.MaintainDate = item.MaintainDate;
log.MaintainTime = item.MaintainTime;
_facade.AddSMTFeederMaterialImportLog(log);
}
}
this.DataProvider.CommitTransaction();
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.Publish(this, "$Error_Add_FeederMaterial", this.languageComponent1);
}
}
