public static DashboardWindowInfo GetDashboardWindowSetting(String WindowId,String StageType) { WindowId = GeneralUtil.Null2String(WindowId); DashboardWindowInfo result = new DashboardWindowInfo(); if (WindowId == "") { return result; } else { DataTable DashboardMainInfo = GetEditDashboardMainByWinId(WindowId); if (DashboardMainInfo.Rows.Count == 0) { ExceptionManager.Throw("The specified item has been removed."); } //还需要进一步转换添加等,注意每一位都要根据新的内容赋值 result.WindowId = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["ID"]); result.WindowName = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["WindowName"]); result.DisplayName = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["DisplayName"]); result.AlertMessage = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["AlertMessage"]); result.RefreshTime = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["RefreshTime"]); TimeInfo timeInfos = new TimeInfo(); if (result.RefreshTime != "") { int freshTime = Int32.Parse(result.RefreshTime); timeInfos = TimeInt2Struct(freshTime); } result.Hour = timeInfos.Hour; result.Second = timeInfos.Second; result.Minute = timeInfos.Minute; result.DataSourceType = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["DataSourceType"]); result.StageTargetId = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["StageTargetId"]); result.StageId = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["StageId"]); result.StageName = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["StageName"]); result.IsStageDisplay = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["IsStageDsp"]); result.StartWorkTime = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["StartWorkTime"]); TimeInfo startWorkInfos = new TimeInfo(); if (result.StartWorkTime != "") { startWorkInfos = TimeString2Struct(result.StartWorkTime); } result.StartWorkTimeHour = startWorkInfos.Hour; result.StartWorkTimeMinute = startWorkInfos.Minute; result.StopWorkTime = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["StopWorkTime"]); TimeInfo stopWorkInfos = new TimeInfo(); if (result.StopWorkTime != "") { stopWorkInfos = TimeString2Struct(result.StopWorkTime); } result.StopWorkTimeHour = stopWorkInfos.Hour; result.StopWorkTimeMinute = stopWorkInfos.Minute; result.DisplayFields = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["DisplayFields"]); StageDisplayFieldInfo displayFieldInfos = new StageDisplayFieldInfo(); if (result.DisplayFields != "") { displayFieldInfos = StageDisplayFieldsString2Struct(result.DisplayFields); } result.IsGoalDisplay = displayFieldInfos.IsGoalDisplay; result.IsInputDisplay = displayFieldInfos.IsInputDisplay; result.IsOutputDisplay = displayFieldInfos.IsOutputDisplay; result.IsRateDisplay = displayFieldInfos.IsRateDisplay; result.Cdt = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["Cdt"]); result.Udt = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["Udt"]); result.Editor = GeneralUtil.Null2String(DashboardMainInfo.Rows[0]["Editor"]); DataTable LineResult = GetEditLineListByWinId(WindowId); for (int i = 0; i < LineResult.Rows.Count; i++) { WindowLineInfo lineInfo = new WindowLineInfo(); lineInfo.LineTargetId = GeneralUtil.Null2String(LineResult.Rows[i]["LineTargetId"]); lineInfo.LineID = GeneralUtil.Null2String(LineResult.Rows[i]["LineId"]); lineInfo.Stage = GeneralUtil.Null2String(LineResult.Rows[i]["SatgeName"]); lineInfo.Line = GeneralUtil.Null2String(LineResult.Rows[i]["LineName"]); //lineInfo.FPYTarget = GeneralUtil.Null2String(LineResult.Rows[i]["FPYTarget"]); //lineInfo.FPYAlert = GeneralUtil.Null2String(LineResult.Rows[i]["FPYAlert"]); //lineInfo.OutputTarget = GeneralUtil.Null2String(LineResult.Rows[i]["OutputTarget"]); lineInfo.StartWork = GeneralUtil.Null2String(LineResult.Rows[i]["StartWorkTime"]); lineInfo.Shift = GeneralUtil.Null2String(LineResult.Rows[i]["Shift"]); String FmlDspField = GeneralUtil.Null2String(LineResult.Rows[i]["FmlDspField"]); if (StageType == Constants.SA_STAGE.ToString()) { SaStationDisplayFieldInfo info = new SaStationDisplayFieldInfo(); info = SaStationDisplayFieldsString2Struct(FmlDspField); lineInfo.IsDefectDsp = info.IsDefectDsp; lineInfo.IsInputDsp = info.IsInputDsp; lineInfo.IsYieldRateDsp = info.IsYieldRateDsp; lineInfo.IsICTDefectDsp = info.IsICTDefectDsp; lineInfo.IsICTInputDsp = info.IsICTInputDsp; lineInfo.IsICTYieldRateDsp = info.IsICTYieldRateDsp; } else { SmtStationDisplayFieldInfo info = new SmtStationDisplayFieldInfo(); info = SmtStationDisplayFieldsString2Struct(FmlDspField); lineInfo.IsDefectDsp = info.IsDefectDsp; lineInfo.IsInputDsp = info.IsInputDsp; lineInfo.IsYieldRateDsp = info.IsYieldRateDsp; lineInfo.IsAOIDefectDsp = info.IsAOIDefectDsp; lineInfo.IsAOIOutputDsp = info.IsAOIOutputDsp; } TimeInfo lineStartWorkInfos = new TimeInfo(); if (lineInfo.StartWork != "") { lineStartWorkInfos = TimeString2Struct(lineInfo.StartWork); } lineInfo.StartWorkHour = lineStartWorkInfos.Hour; lineInfo.StartWorkMinute = lineStartWorkInfos.Minute; lineInfo.StopWork = GeneralUtil.Null2String(LineResult.Rows[i]["StopWorkTime"]); TimeInfo lineStopWorkInfos = new TimeInfo(); if (lineInfo.StopWork != "") { lineStopWorkInfos = TimeString2Struct(lineInfo.StopWork); } lineInfo.StopWorkHour = lineStopWorkInfos.Hour; lineInfo.StopWorkMinute = lineStopWorkInfos.Minute; //lineInfo.StationDisplay = GeneralUtil.Null2String(LineResult.Rows[i]["IsStationDsp"]); lineInfo.Order = GeneralUtil.Null2String(LineResult.Rows[i]["SortOrder"]); List<WindowLineFamilyInfo> StationResult = GetEditStationListByLineAndWinId(WindowId, lineInfo.LineID); lineInfo.WindowLineFamilyInfos = StationResult; result.WindowLineInfos.Add(lineInfo); } return result; } }
public static WindowLineInfo GetLineBaseSettingInfo(String lineId,Boolean isSaStage) { WindowLineInfo result = new WindowLineInfo(); String connectString = DatabaseUtil.GetConnectionString(); String sqlString = "SELECT top 1 [StartWorkTime],[StopWorkTime],[Shift],[FmlDspField] FROM [Dashboard_Line_Target] WHERE [Line]=@param1"; List<ConditionValueSet> paramList = new List<ConditionValueSet>(); ConditionValueSet param1 = new ConditionValueSet(); param1.ParamName = "@param1"; param1.DataType = "char(10)"; param1.ParamValue = lineId; paramList.Add(param1); DataTable sqlResult = DatabaseUtil.GetResultBySQL(sqlString, connectString, paramList); if (sqlResult.Rows.Count > 0) { result.Shift = GeneralUtil.Null2String(sqlResult.Rows[0]["Shift"]); String FmlDspField = GeneralUtil.Null2String(sqlResult.Rows[0]["FmlDspField"]); if (isSaStage == true) { SaStationDisplayFieldInfo displayFieldInfos = new SaStationDisplayFieldInfo(); if (FmlDspField != "") { displayFieldInfos = SaStationDisplayFieldsString2Struct(FmlDspField); result.IsDefectDsp = displayFieldInfos.IsDefectDsp; result.IsICTDefectDsp = displayFieldInfos.IsICTDefectDsp; result.IsICTInputDsp = displayFieldInfos.IsICTInputDsp; result.IsICTYieldRateDsp = displayFieldInfos.IsICTYieldRateDsp; result.IsInputDsp = displayFieldInfos.IsInputDsp; result.IsYieldRateDsp = displayFieldInfos.IsYieldRateDsp; } } else { SmtStationDisplayFieldInfo displayFieldInfos = new SmtStationDisplayFieldInfo(); if (FmlDspField != "") { displayFieldInfos = SmtStationDisplayFieldsString2Struct(FmlDspField); result.IsDefectDsp = displayFieldInfos.IsDefectDsp; result.IsAOIDefectDsp = displayFieldInfos.IsAOIDefectDsp; result.IsAOIOutputDsp = displayFieldInfos.IsAOIOutputDsp; result.IsInputDsp = displayFieldInfos.IsInputDsp; result.IsYieldRateDsp = displayFieldInfos.IsYieldRateDsp; } } String StartWorkTime = GeneralUtil.Null2String(sqlResult.Rows[0]["StartWorkTime"]); String StopWorkTime = GeneralUtil.Null2String(sqlResult.Rows[0]["StopWorkTime"]); TimeInfo startWorkInfos = new TimeInfo(); if (StartWorkTime != "") { startWorkInfos = TimeString2Struct(StartWorkTime); } TimeInfo stopWorkInfos = new TimeInfo(); if (StopWorkTime != "") { stopWorkInfos = TimeString2Struct(StopWorkTime); } result.StartWorkHour = startWorkInfos.Hour; result.StartWorkMinute = startWorkInfos.Minute; result.StopWorkHour = stopWorkInfos.Hour; result.StopWorkMinute = stopWorkInfos.Minute; } return result; }