public void LoadOWCChart() { _UserOWCPivotTable.SetDataSource(_DataSource, GetOWCSchema()); _UserOWCPivotTable.ClearFieldSet(); foreach (string property in _RowPropertyList) { _UserOWCPivotTable.AddRowFieldSet(property, true); } foreach (string property in _ColumnPropertyList) { _UserOWCPivotTable.AddColumnFieldSet(property, true); } for (int i = 0; i < _DataPropertyList.Length; i++) { string property = _DataPropertyList[i]; string format = string.Empty; if (i < _DataPropertyFormatList.Length) { format = _DataPropertyFormatList[i]; } if (_IsPercent) { _UserOWCPivotTable.AddTotalField(_LanguageComponent.GetString(property), property, PivotTotalFunctionType.Sum, NumberFormat.Percent); } else if (format.Trim().Length > 0) { _UserOWCPivotTable.AddTotalField(_LanguageComponent.GetString(property), property, PivotTotalFunctionType.Sum, format); } else { _UserOWCPivotTable.AddTotalField(_LanguageComponent.GetString(property), property, PivotTotalFunctionType.Sum); } } _UserOWCChart.DataSource = _UserOWCPivotTable.PivotTableName; if (_UserOWCChartType == NewReportDisplayType.LineChart) { _UserOWCChart.ChartType = OWCChartType.LineMarkers; } else if (_UserOWCChartType == NewReportDisplayType.HistogramChart) { _UserOWCChart.ChartType = OWCChartType.ColumnClustered; } else if (_UserOWCChartType == NewReportDisplayType.PieChart) { _UserOWCChart.ChartType = OWCChartType.Pie; } }
public static string TranslateParseType(string parseType, LanguageComponent languageComponent1) { string returnValue = string.Empty; string[] parseTypeList = parseType.Trim().ToLower().Split(new char[] { ',' }); if (parseTypeList != null) { foreach (string part in parseTypeList) { returnValue += "," + languageComponent1.GetString(part.Trim().ToLower()); //if (part == OPBOMDetailParseType.PARSE_PRODUCT && checkStatus) //{ // returnValue += "(" + languageComponent1.GetString("parse_product_checkstatus") + ")"; //} } } if (returnValue.Length > 0) { returnValue = returnValue.Substring(1); } return(returnValue); }
private string Translate(string key) { string returnValue = key; object obj = _LanguageTable[key]; if (obj == null) { if (_LanguageComponent != null) { string lang = _LanguageComponent.GetString(key); if (lang.Trim().Length > 0) { returnValue = lang; _LanguageTable.Add(key, lang); } } } else { returnValue = obj.ToString(); } return(returnValue); }
public static string TranslateCheckType(string checkType, LanguageComponent languageComponent1) { string returnValue = string.Empty; string[] checkTypeList = checkType.Trim().ToLower().Split(new char[] { ',' }); if (checkTypeList != null) { foreach (string part in checkTypeList) { returnValue += "," + languageComponent1.GetString(part.Trim().ToLower()); } } if (returnValue.Length > 0) { returnValue = returnValue.Substring(1); } return(returnValue); }
private void CheckWorkPlan() { int count = this._ImportDataTable.Rows.Count; Hashtable checkedRow = new Hashtable(); ShiftModelFacade shiftModelFacade = new ShiftModelFacade(this._DataProvider); MaterialFacade materialFacade = new MaterialFacade(this._DataProvider); DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(this._DataProvider); for (int i = count - 1; i >= 0; i--) { DataRow row = this._ImportDataTable.Rows[i]; GridRecord gridRow = this._ImportGridRow[i] as GridRecord; string moCode = row["MOCODE"].ToString(); string bigSSCode = row["BIGSSCODE"].ToString(); string planDate = row["PLANDATE"].ToString(); string planSeq = row["PLANSEQ"].ToString(); string moSeq = row["MOSEQ"].ToString(); string planStartTime = (Convert.ToDateTime(row["PLANSTARTTIME"])).ToString("HH:mm:ss"); string planQty = row["PLANQTY"].ToString(); if (string.IsNullOrEmpty(moCode)) { if (!checkedRow.ContainsKey(moCode)) { checkedRow.Add(moCode, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = _LanguageComponent1.GetString("$CS_MO_NotExit"); gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if (string.IsNullOrEmpty(bigSSCode)) { if (!checkedRow.ContainsKey(bigSSCode)) { checkedRow.Add(bigSSCode, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = _LanguageComponent1.GetString("$BIGSSCODE_IS_NOT_EXIT"); gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if (string.IsNullOrEmpty(planDate)) { if (!checkedRow.ContainsKey(planDate)) { checkedRow.Add(planDate, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划日期不能为空"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } try { DateTime planDateTime = Convert.ToDateTime(FormatHelper.ToDateString(int.Parse(planDate), "-")); } catch { if (!checkedRow.ContainsKey(planDate)) { checkedRow.Add(planDate, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划日期错误"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if (string.IsNullOrEmpty(planSeq)) { if (!checkedRow.ContainsKey(planSeq)) { checkedRow.Add(planSeq, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "生产顺序不能为空"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if (string.IsNullOrEmpty(moSeq)) { if (!checkedRow.ContainsKey(moSeq)) { checkedRow.Add(moSeq, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "工单项次不能为空"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if (string.IsNullOrEmpty(planStartTime)) { if (!checkedRow.ContainsKey(planStartTime)) { checkedRow.Add(planStartTime, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划开始时间不能为空"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } try { int numplanSeq = int.Parse(planSeq); if (numplanSeq < 0) { if (!checkedRow.ContainsKey(planSeq)) { checkedRow.Add(planSeq, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "生产顺序不应小于0"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } } catch { if (!checkedRow.ContainsKey(planSeq)) { checkedRow.Add(planSeq, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "生产顺序格式错误"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } try { int nummoSeq = int.Parse(moSeq); if (nummoSeq < 0) { if (!checkedRow.ContainsKey(moSeq)) { checkedRow.Add(moSeq, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "工单项次不应小于0"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } } catch { if (!checkedRow.ContainsKey(moSeq)) { checkedRow.Add(moSeq, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "工单项次格式错误"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } try { decimal numplanQty = decimal.Parse(planQty); if (numplanQty < 0) { if (!checkedRow.ContainsKey(planQty)) { checkedRow.Add(planQty, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划数量不应小于0"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } } catch { if (!checkedRow.ContainsKey(planQty)) { checkedRow.Add(planQty, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划数量格式错误"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } //planDate try { int numplanDate = FormatHelper.TODateInt(planDate.Insert(4, "-").Insert(7, "-")); } catch { if (!checkedRow.ContainsKey(planDate)) { checkedRow.Add(planDate, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划日期格式错误"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } //planStartTime try { int numplanStartTime = FormatHelper.TOTimeInt(planStartTime.ToString()); } catch { if (!checkedRow.ContainsKey(planStartTime)) { checkedRow.Add(planStartTime, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划开始时间格式错误"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } int shiftDay = shiftModelFacade.GetShiftDayByBigSSCode(bigSSCode, dbDateTime.DateTime); object[] objs = _DataProvider.CustomQuery(typeof(BenQGuru.eMES.Domain.MOModel.Model), new SQLParamCondition(@"select mocode from tblmo where 1=1 " + GlobalVariables.CurrentOrganizations.GetSQLCondition() + @" and mocode=$MOCODE", new SQLParameter[] { new SQLParameter("$MOCODE", typeof(string), moCode.ToUpper()) })); if (objs == null) { if (!checkedRow.ContainsKey(moCode)) { checkedRow.Add(moCode, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = _LanguageComponent1.GetString("$CS_MO_NotExit"); gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } object[] objss = _DataProvider.CustomQuery(typeof(BenQGuru.eMES.Domain.BaseSetting.StepSequence), new SQLParamCondition(@"select distinct bigsscode from tblss where 1=1 " + GlobalVariables.CurrentOrganizations.GetSQLCondition() + @" and bigsscode=$BIGSSCODE", new SQLParameter[] { new SQLParameter("$BIGSSCODE", typeof(string), bigSSCode.ToUpper()) })); if (objss == null) { if (!checkedRow.ContainsKey(bigSSCode)) { checkedRow.Add(bigSSCode, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = _LanguageComponent1.GetString("$BIGSSCODE_IS_NOT_EXIT"); gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if (_MaterialFacade == null) { _MaterialFacade = new MaterialFacade(_DataProvider); } object objWorkPlanFromDB = _MaterialFacade.GetWorkPlan(bigSSCode, int.Parse(planDate), moCode, decimal.Parse(moSeq)); if (objWorkPlanFromDB != null) { //修改的投入数量必须大于等于实际数量 if (decimal.Parse(planQty) < ((WorkPlan)objWorkPlanFromDB).ActQty) { if (!checkedRow.ContainsKey(planQty)) { checkedRow.Add(planQty, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = _LanguageComponent1.GetString("$planqty_isnotequ_actqty"); gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if ((((WorkPlan)objWorkPlanFromDB).ActionStatus == WorkPlanActionStatus.WorkPlanActionStatus_Close)) //执行状态为待投产或生产中才update { if (!checkedRow.ContainsKey(planDate)) { checkedRow.Add(planDate, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = _LanguageComponent1.GetString("$status_error"); gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } } if (int.Parse(planDate) < shiftDay) { if (!checkedRow.ContainsKey(planDate)) { checkedRow.Add(planDate, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "计划日期不能早于当前日期"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } WorkPlan GetworkPlanByKeys = (WorkPlan)materialFacade.GetWorkPlan(bigSSCode, int.Parse(planDate), moCode, decimal.Parse(moSeq)); WorkPlan GetworkPlanByUniques = (WorkPlan)materialFacade.GetWorkPlan(bigSSCode, int.Parse(planDate), int.Parse(planSeq)); if (GetworkPlanByKeys == null && GetworkPlanByUniques != null) { if (!checkedRow.ContainsKey(moCode)) { checkedRow.Add(moCode, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "请检查日期+线别+投产顺序的唯一性"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } if (GetworkPlanByKeys != null && GetworkPlanByUniques != null) { if (GetworkPlanByKeys.BigSSCode != GetworkPlanByUniques.BigSSCode || GetworkPlanByKeys.PlanDate != GetworkPlanByUniques.PlanDate || GetworkPlanByKeys.MoCode != GetworkPlanByUniques.MoCode || GetworkPlanByKeys.MoSeq != GetworkPlanByUniques.MoSeq) { if (!checkedRow.ContainsKey(moCode)) { checkedRow.Add(moCode, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = false; gridRow.Items.FindItemByKey("ImportResult").Text = "请检查日期+线别+投产顺序的唯一性"; gridRow.Items.FindItemByKey("ImportResult").CssClass = "MsgYellow"; this._ImportDataTable.Rows.Remove(row); this._ImportGridRow.Remove(gridRow); continue; } } if (!checkedRow.ContainsKey(moCode)) { checkedRow.Add(moCode, false); } gridRow.Items.FindItemByKey(gridHelper.CheckColumnKey).Value = true; } }
private void InitItemType() { this.ddlItemType.Items.Clear(); this.ddlItemType.Items.Add(new ListItem(_LanguageComponent1.GetString(ItemType.ITEMTYPE_FINISHEDPRODUCT), ItemType.ITEMTYPE_FINISHEDPRODUCT)); this.ddlItemType.Items.Add(new ListItem(_LanguageComponent1.GetString(ItemType.ITEMTYPE_SEMIMANUFACTURE), ItemType.ITEMTYPE_SEMIMANUFACTURE)); }
/// <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); } }
private void ddlGoodSemiGoodWhere_Load(object sender, System.EventArgs e) { this.ddlGoodSemiGoodWhere.Items.Clear(); this.ddlGoodSemiGoodWhere.Items.Add(new ListItem("", "")); this.ddlGoodSemiGoodWhere.Items.Add(new ListItem(_LanguageComponent.GetString(ItemType.ITEMTYPE_FINISHEDPRODUCT), ItemType.ITEMTYPE_FINISHEDPRODUCT)); this.ddlGoodSemiGoodWhere.Items.Add(new ListItem(_LanguageComponent.GetString(ItemType.ITEMTYPE_SEMIMANUFACTURE), ItemType.ITEMTYPE_SEMIMANUFACTURE)); }