/// <summary>
/// 补充空缺的不允许为空的栏位
/// </summary>
/// <param name="obj">导入对象的引用</param>
private void GetImportObjectType(ref object obj, string importtype)
{
if (obj == null)
{
return;
}
switch (importtype)
{
case "IndirectManCount":
IndirectManCount indirectManCount = obj as IndirectManCount;
indirectManCount.MaintainUser = UserCode;
indirectManCount.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
indirectManCount.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
break;
case "Line2Crew":
Line2Crew line2Crew = obj as Line2Crew;
line2Crew.MaintainUser = UserCode;
line2Crew.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
line2Crew.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
break;
default:
break;
}
}
protected override void AddDomainObject(object domainObject)
{
if (_facade == null)
{
_facade = new PerformanceFacade(base.DataProvider);
}
IndirectManCount indirectManCount = (IndirectManCount)_facade.GetIndirectManCount(FormatHelper.TODateInt(this.DateEdit.Text),
FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtShiftCodeEdit.Text)),
FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtCrewCodeEdit.Text)),
FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtFACCodeEdit.Text)),
this.drpFirstClassEdit.SelectedValue);
if (indirectManCount != null)
{
WebInfoPublish.Publish(this, "$The_Same_Date_Is_Exist", this.languageComponent1);
return;
}
this._facade.AddIndirectManCount((IndirectManCount)domainObject);
}
protected override object GetEditObject()
{
if (_facade == null)
{
_facade = new PerformanceFacade(base.DataProvider);
}
DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
IndirectManCount indirectManCount = this._facade.CreateNewIndirectManCount();
indirectManCount.ShiftDate = FormatHelper.TODateInt(this.DateEdit.Text);
indirectManCount.ShiftCode = FormatHelper.CleanString(this.txtShiftCodeEdit.Text.ToUpper());
indirectManCount.CrewCode = FormatHelper.CleanString(this.txtCrewCodeEdit.Text.ToUpper());
indirectManCount.FactoryCode = FormatHelper.CleanString(this.txtFACCodeEdit.Text.ToUpper(), 40);
indirectManCount.FirstClass = this.drpFirstClassEdit.SelectedValue;
indirectManCount.ManCount = int.Parse(this.txtManCountEdit.Text.Trim());
indirectManCount.Duration = Convert.ToInt32(Convert.ToDecimal(this.txtDurationEdit.Text.Trim()) * 3600);
indirectManCount.MaintainUser = this.GetUserCode();
indirectManCount.MaintainDate = dbDateTime.DBDate;
indirectManCount.MaintainTime = dbDateTime.DBTime;
return(indirectManCount);
}
/// <summary>
///
/// </summary>
/// <param name="isRollBack">true:出错就回滚；false:出错skip到下一个</param>
public void Import(bool isRollBack)
{
ShiftModelFacade shiftModelFacade = new ShiftModelFacade(this._dataProvider);
DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(this._dataProvider);
object[] objDt = null;
if (string.Compare(ImportType, "IndirectManCount", true) == 0)
{
objDt = ConvertArrayListToObjectArray(ImportDatatable, "IndirectManCount");
}
if (string.Compare(ImportType, "Line2Crew", true) == 0)
{
objDt = ConvertArrayListToObjectArray(ImportDatatable, "Line2Crew");
}
try
{
_dataProvider.BeginTransaction();
if (string.Compare(ImportType, "IndirectManCount", true) == 0)
{
if (objDt != null)
{
for (int i = 0; i < objDt.Length; i++)
{
try
{
GridRecord row = ImportGridRow[i] as GridRecord;
IndirectManCount IndirectManCountExcel = objDt[i] as IndirectManCount;
if (_Facade == null)
{
_Facade = new PerformanceFacade(_dataProvider);
}
IndirectManCount getWorkPlanFromDB = (IndirectManCount)_Facade.GetIndirectManCount(IndirectManCountExcel.ShiftDate,
IndirectManCountExcel.ShiftCode,
IndirectManCountExcel.CrewCode,
IndirectManCountExcel.FactoryCode,
IndirectManCountExcel.FirstClass);
if (getWorkPlanFromDB != null)
{
((IndirectManCount)objDt[i]).FactoryCode = IndirectManCountExcel.FactoryCode;
((IndirectManCount)objDt[i]).FirstClass = IndirectManCountExcel.FirstClass;
_dataProvider.Update(objDt[i]);
row.Items.FindItemByKey("ImportResult").Text = _languageComponent1.GetString("$CycleImport_Success");
row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
}
else
{
_dataProvider.Insert(objDt[i]);
row.Items.FindItemByKey("ImportResult").Text = _languageComponent1.GetString("$CycleImport_Success");
row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
}
}
catch (Exception ex)
{
GridRecord row = ImportGridRow[i] as GridRecord;
row.Items.FindItemByKey("ImportResult").Text = _languageComponent1.GetString("$CycleImport_Error");
row.Items.FindItemByKey("ImportResult").CssClass = "ForeColorRed";
this.ErrorArray.Add(ex);
}
}
}
}
if (string.Compare(ImportType, "Line2Crew", true) == 0)
{
if (objDt != null)
{
for (int i = 0; i < objDt.Length; i++)
{
try
{
GridRecord row = ImportGridRow[i] as GridRecord;
Line2Crew Line2CrewExcel = objDt[i] as Line2Crew;
if (_Facade == null)
{
_Facade = new PerformanceFacade(_dataProvider);
}
Line2Crew getLine2CrewFromDB = (Line2Crew)_Facade.GetLine2Crew(Convert.ToInt32(Line2CrewExcel.ShiftDate), Line2CrewExcel.SSCode.ToString(), Line2CrewExcel.ShiftCode);
if (getLine2CrewFromDB != null)
{
getLine2CrewFromDB.CrewCode = Line2CrewExcel.CrewCode;
_dataProvider.Update(getLine2CrewFromDB);
row.Items.FindItemByKey("ImportResult").Text = _languageComponent1.GetString("$CycleImport_Success");
row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
}
else
{
_dataProvider.Insert(objDt[i]);
row.Items.FindItemByKey("ImportResult").Text = _languageComponent1.GetString("$CycleImport_Success");
row.Items.FindItemByKey("ImportResult").CssClass = "LinkColorBlue";
}
}
catch (Exception ex)
{
GridRecord row = ImportGridRow[i] as GridRecord;
row.Items.FindItemByKey("ImportResult").Text = _languageComponent1.GetString("$CycleImport_Error");
row.Items.FindItemByKey("ImportResult").CssClass = "ForeColorRed";
this.ErrorArray.Add(ex);
}
}
}
}
_dataProvider.CommitTransaction();
}
catch (Exception ex)
{
_dataProvider.RollbackTransaction();
this.ErrorArray.Add(ex);
}
}
