/// <summary> /// 获取派班写实记录 /// </summary> public InterfaceOutPut GetXSTrainmanPlans(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetXSTrainmanPlans InParams = javaScriptSerializer.Deserialize <InGetXSTrainmanPlans>(Data); OutGetXSTrainmanPlans OutParams = new OutGetXSTrainmanPlans(); string[] jiaolus = InParams.jiaolus.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); string strJiaolus = ""; for (int i = 0; i < jiaolus.Length; i++) { if (strJiaolus == "") { strJiaolus = "'" + jiaolus[i] + "'"; } else { strJiaolus += "," + "'" + jiaolus[i] + "'"; } } if (strJiaolus != "") { strJiaolus = string.Format("and strTrainJiaoluGUID in ({0}) ", strJiaolus); } string strSql = @"select * from VIEW_Plan_Trainman as p where dtStartTime >=@BeginTime and dtStartTime <= @EndTime and nPlanState >= 4 " + strJiaolus + " order by dtStartTime "; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("BeginTime", InParams.dtBeginTime), new SqlParameter("EndTime", InParams.dtEndTime) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { MD.TrainmanPlan tmPlan = new MD.TrainmanPlan(); PS.PSPlan.TrainmanPlanFromDB(tmPlan, dt.Rows[i]); OutParams.Plans.Add(tmPlan); } output.data = OutParams; output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.GetXSTrainmanPlans:" + ex.Message); throw ex; } return(output); }
//从数据行中读取数据到TrainPlan中 public static void TrainmanPlanFromDB(TF.RunSafty.Plan.MD.TrainmanPlan Plan, DataRow dr) { TrainPlanFromDB(Plan.trainPlan, dr); GroupFromDB(Plan.group, dr); RestFromDB(Plan.rest, dr); }