/// <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); } Line2Crew line2Crew = (Line2Crew)_facade.GetLine2Crew(FormatHelper.TODateInt(this.DateEdit.Text), FormatHelper.CleanString(this.txtSSEdit.Text.ToUpper()), FormatHelper.CleanString(this.txtShiftCodeEdit.Text.ToUpper())); if (line2Crew != null) { WebInfoPublish.Publish(this, "$The_Same_DateAndSSCodeAndSHiftCode_Is_Exist", this.languageComponent1); return; } this._facade.AddLine2Crew((Line2Crew)domainObject); }
private void RefreshControlValue() { DBDateTime nowDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider); OnOffPostEnvirenment env = new OnOffPostEnvirenment(); if (env.Init(this.DataProvider, ApplicationService.Current().ResourceCode, nowDateTime)) { ucLabelEditDate.Value = FormatHelper.ToDateString(env.ShiftDate); ucLabelEditShiftCode.Value = env.Shift.ShiftCode; ucLabelEditBigSSCode.Value = env.StepSequence.BigStepSequenceCode; Line2Crew line2Crew = (Line2Crew)_PerformanceFacade.GetLine2Crew(env.ShiftDate, env.StepSequence.StepSequenceCode, env.Shift.ShiftCode); if (line2Crew != null) { ucLabelEditCrewCode.Value = line2Crew.CrewCode; } } }
protected override object GetEditObject() { if (_facade == null) { _facade = new PerformanceFacade(base.DataProvider); } DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(this.DataProvider); Line2Crew line2Crew = this._facade.CreateNewLine2Crew(); line2Crew.ShiftDate = FormatHelper.TODateInt(this.DateEdit.Text); line2Crew.SSCode = FormatHelper.CleanString(this.txtSSEdit.Text.ToUpper(), 40); line2Crew.ShiftCode = FormatHelper.CleanString(this.txtShiftCodeEdit.Text.ToUpper()); line2Crew.CrewCode = FormatHelper.CleanString(this.txtCrewCodeEdit.Text.ToUpper()); line2Crew.MaintainUser = this.GetUserCode(); line2Crew.MaintainDate = dbDateTime.DBDate; line2Crew.MaintainTime = dbDateTime.DBTime; return(line2Crew); }
/// <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); } }