public Get_Out GetGroupOrder(string data)
{
Get_Out json = new Get_Out();
try
{
Get_In input = Newtonsoft.Json.JsonConvert.DeserializeObject <Get_In>(data);
string strTrainmanJiaoLuGUID = input.TrainmanJiaoluGUID;
string strWorkShopGUID = input.WorkShopGUID;
TF.Api.BLL.BanXuBLL bllBanXu = new TF.Api.BLL.BanXuBLL();
json.Content = new List <GroupItem>();
DataTable table = bllBanXu.GetBanXuByJiaoLuGUID(strWorkShopGUID, strTrainmanJiaoLuGUID);
SimpleTrainman man = null;
if (table != null)
{
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
GroupItem record = new GroupItem();
DateTime endWorkTime;
string strEndWorkTime = row["dtLastEndWorkTime1"] == null ? "" : row["dtLastEndWorkTime1"].ToString();
if (DateTime.TryParse(strEndWorkTime, out endWorkTime))
{
record.EndWorkTime = endWorkTime.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
record.EndWorkTime = "";
}
record.Index = (i + 1).ToString();
record.TrainmanList = new SimpleTrainmanList();
json.Content.Add(record);
for (int j = 1; j < 5; j++)
{
man = new SimpleTrainman();
man.TrainmanName = row["strTrainmanName" + j.ToString()].ToString();
man.TrainmanNo = row["strTrainmanNumber" + j.ToString()].ToString();
man.trianmanGUID = row["strTrainmanGUID" + j.ToString()].ToString();
record.TrainmanList.Add(man);
}
}
}
json.result = "0";
json.resultStr = "返回成功";
}
catch (Exception ex)
{
json.result = "1";
json.resultStr = "提交失败：" + ex.Message;
}
return(json);
}
public override string QueryResult()
{
DataModel dataModel = Newtonsoft.Json.JsonConvert.DeserializeObject <DataModel>(this.Data);
string strTrainmanJiaoLuGUID = dataModel.TrainmanJiaoluGUID;
string strWorkShopGUID = dataModel.WorkShopGUID;
TF.Api.BLL.BanXuBLL bllBanXu = new TF.Api.BLL.BanXuBLL();
JsonModel jsonModel = new JsonModel();
jsonModel.Content = new List <Record>();
TrainMan man = null;
DataTable table = bllBanXu.GetBanXuByJiaoLuGUID(strWorkShopGUID, strTrainmanJiaoLuGUID);
if (table != null)
{
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
Record record = new Record();
DateTime endWorkTime;
string strEndWorkTime = row["dtLastEndWorkTime1"] == null ? "" : row["dtLastEndWorkTime1"].ToString();
if (DateTime.TryParse(strEndWorkTime, out endWorkTime))
{
record.EndWorkTime = endWorkTime.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
record.EndWorkTime = "";
}
record.Index = (i + 1).ToString();
record.TrainmanList = new List <TrainMan>();
jsonModel.Content.Add(record);
for (int j = 1; j < 5; j++)
{
man = new TrainMan();
man.TrainmanName = row["strTrainmanName" + j.ToString()].ToString();
man.TrainmanNo = row["strTrainmanNumber" + j.ToString()].ToString();
man.trianmanGUID = row["strTrainmanGUID" + j.ToString()].ToString();
record.TrainmanList.Add(man);
}
}
}
jsonModel.result = "0";
jsonModel.resultStr = "返回成功";
Newtonsoft.Json.Converters.IsoDateTimeConverter timeConverter = new Newtonsoft.Json.Converters.IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
return(Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel, timeConverter));
}