protected void Page_Load(object sender, System.EventArgs e) { this.gridHelper = new GridHelper(this.gridItem2Route); //Laws Lu,2006/09/26 获取产品 if (Request.QueryString["ItemCode"] != null) { ItemCode = Request.QueryString["ItemCode"].Trim(); txtItemCodeQuery.Text = ItemCode; } moFac = new FacadeFactory(base.DataProvider).CreateMOFacade(); Domain.MOModel.DefaultItem2Route dItem2Route = null; object objOld = moFac.GetDefaultItem2Route(ItemCode); this.gridHelper.BuildGridRowhandle = new BuildGridRowDelegate(this.GetGridRow); this.gridHelper.GetRowCountHandle = new GetRowCountDelegate(this.GetRowCount); this.gridHelper.LoadDataSourceHandle = new LoadDataSourceDelegate(this.LoadDataSource); if (!this.IsPostBack) { this.InitWebGrid(); this.InitPageLanguage(this.languageComponent1, false); this.cmdQuery_ServerClick(null, null); } if (objOld != null) { dItem2Route = objOld as Domain.MOModel.DefaultItem2Route; } if (dItem2Route != null) { lblDefaultRoute.Text = languageComponent1.GetString("$Current_Default_Route ") + dItem2Route.RouteCode; } if (!this.Page.IsStartupScriptRegistered("SelectableTextBox_Startup_js")) { string scriptString = string.Format("<script>var STB_Virtual_Path = \"{0}\";</script><script src='{0}SelectQuery/selectableTextBox.js'></script>", this.VirtualHostRoot); this.Page.RegisterStartupScript("SelectableTextBox_Startup_js", scriptString); } }
protected override void ImportData(Excel.Worksheet sheet, string[] strHeader) { DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(ApplicationService.DataProvider); ImportDataEngine impEng = new ImportDataEngine(ApplicationService.DataProvider, this.configObjList, this.configMatchType, ApplicationService.LoginUserCode, dbDateTime); impEng.ImportDataMapping = Properties.Settings.Default.DataMappingType; impEng.UpdateRepeatData = Properties.Settings.Default.DataRepeat; ApplicationService.DataProvider.BeginTransaction(); try { int iRow = 2; int iImportedCount = 0; while (true) { string[] strRow = ReadExcelRow(sheet, iRow, strHeader.Length); if (strRow == null) { break; } // 导入产品 try { // 产品途程主资料 BenQGuru.eMES.MOModel.MOFacade moFacade = new BenQGuru.eMES.MOModel.MOFacade(ApplicationService.DataProvider); BenQGuru.eMES.MOModel.ItemFacade itemFacade = new BenQGuru.eMES.MOModel.ItemFacade(ApplicationService.DataProvider); BenQGuru.eMES.Domain.MOModel.Item2Route itemRoute = new BenQGuru.eMES.Domain.MOModel.Item2Route(); itemRoute.ItemCode = strRow[0].Trim().ToUpper(); itemRoute.RouteCode = strRow[1].Trim().ToUpper(); itemRoute.OrganizationID = int.Parse(strRow[2].Trim().ToUpper()); itemRoute.IsReference = "0"; itemRoute.MaintainUser = ApplicationService.LoginUserCode; itemRoute.MaintainDate = dbDateTime.DBDate; itemRoute.MaintainTime = dbDateTime.DBTime; object ir = itemFacade.GetItem2Route(itemRoute.ItemCode, itemRoute.RouteCode, itemRoute.OrganizationID.ToString()); if (ir == null) { ApplicationService.DataProvider.Insert(itemRoute); } else { ApplicationService.DataProvider.Update(itemRoute); } // 产品默认途程 BenQGuru.eMES.Domain.MOModel.DefaultItem2Route defRoute = null; BenQGuru.eMES.Domain.MOModel.DefaultItem2Route dr = moFacade.GetDefaultItem2Route(itemRoute.ItemCode) as BenQGuru.eMES.Domain.MOModel.DefaultItem2Route; if (dr != null) { defRoute = dr; } else { defRoute = new BenQGuru.eMES.Domain.MOModel.DefaultItem2Route(); } defRoute.ItemCode = itemRoute.ItemCode; if (strRow[3].Trim().ToUpper() == "YES") { defRoute.RouteCode = itemRoute.RouteCode; } if (defRoute.RouteCode != null && defRoute.RouteCode != "") { defRoute.MDate = dbDateTime.DBDate; defRoute.MTime = dbDateTime.DBTime; if (dr == null) { ApplicationService.DataProvider.Insert(defRoute); } else { ApplicationService.DataProvider.Update(defRoute); } } // 产品途程工序列表 //将原来的删除 string strSql = string.Format("delete tblitemroute2op where itemcode = '{0}' and routecode='{1}' and orgid = {2}", itemRoute.ItemCode, itemRoute.RouteCode, itemRoute.OrganizationID.ToString()); ApplicationService.DataProvider.CustomExecute(new SQLCondition(strSql)); strSql = "insert into tblitemroute2op (opid,routecode,opcode,opseq,opcontrol,idmergetype,idmergerule,muser,mdate,mtime,itemcode,orgid) "; strSql += "select routecode||opcode||'{0}',routecode,opcode,opseq,opcontrol,'idmergetype_idmerge',1,muser,mdate,mtime,'{0}',{2} "; strSql += "from tblroute2op where routecode='{1}' "; strSql = string.Format(strSql, itemRoute.ItemCode, itemRoute.RouteCode, itemRoute.OrganizationID.ToString()); ApplicationService.DataProvider.CustomExecute(new SQLCondition(strSql)); iImportedCount++; } catch (Exception ex) { string strResult = ex.Message; if (strResult == "$DATA_REPEAT_CANCEL") // 如果是重复数据,并设置终止 { throw new Exception(strResult); } else if (strResult != "$Import_Unique_Data_Exist") // $Import_Unique_Data_Exist表示重复数据,设置忽略 { if (Properties.Settings.Default.DataError == ImportDataEngine.OnErrorDeal.Cancel) { throw new Exception(strResult); } } } iRow++; } ApplicationService.DataProvider.CommitTransaction(); MessageBox.Show(UserControl.MutiLanguages.ParserMessage("$CycleImport_Success [" + iImportedCount.ToString() + "]"), this.MainForm.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { ApplicationService.DataProvider.RollbackTransaction(); MessageBox.Show(UserControl.MutiLanguages.ParserMessage(ex.Message), this.MainForm.Text, MessageBoxButtons.OK, MessageBoxIcon.Stop); } }