/// <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);
}
