public override string QueryResult()
{
JsonModel jsonModel = new JsonModel();
try
{
ParamModel paramModel = Newtonsoft.Json.JsonConvert.DeserializeObject <ParamModel>(this.Data);
TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace bllPlace = new TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace();
string strTrainJiaolu = paramModel.data.trainjiaoluID;
string strSite = paramModel.data.siteID;
List <TF.RunSafty.Model.VIEW_Base_Site_DutyPlace> placeList = bllPlace.GetPlaceOfClient(strTrainJiaolu, strSite);
jsonModel.result = 0;
jsonModel.resultStr = "提交成功";
jsonModel.data = GetPlaceList(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
jsonModel.result = 1;
jsonModel.resultStr = "提交失败";
}
string result = Newtonsoft.Json.JsonConvert.SerializeObject(jsonModel);
return(result);
}
/// <summary>
/// 获取指定时间段内已下发的行车计划
/// </summary>
/// <param name="clientGUID"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="strTrainJiaoluGUID"></param>
/// <returns></returns>
public List <TF.RunSafty.Model.InterfaceModel.PlansOfClient> GetTrainjiaoluPlansSentOfClient(string clientGUID, string startTime, string endTime, string strTrainJiaoluGUID)
{
//先根据clientID,trainjiaoluGUID,查找出勤点的编号
System.Text.StringBuilder builder = new System.Text.StringBuilder();
TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace bllPlace = new TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace();
string strWhere = string.Format(" strSiteGUID='{0}' and strTrainJiaoluGUID='{1}' ", clientGUID, strTrainJiaoluGUID);
DataTable table = bllPlace.GetList(strWhere).Tables[0];
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
builder.AppendFormat("'{0}'", table.Rows[i]["strPlaceID"].ToString());
if (i < table.Rows.Count - 1)
{
builder.Append(",");
}
}
}
else
{
TF.CommonUtility.LogClass.log("wwwwwwwwwwwwwddddddddddddddddw" + clientGUID + startTime + endTime + strTrainJiaoluGUID);
throw new Exception("该客户端下的行车区段没有出勤点");
}
string placeIDs = builder.ToString();
string strJlCondition = string.Empty;
if (strTrainJiaoluGUID != string.Empty)
{
strJlCondition = " and (strTrainJiaoluGUID = '{0}' or strTrainJiaoluGUID in (select strSubTrainJiaoluGUID from TAB_Base_TrainJiaolu_SubDetail where strTrainJiaoluGUID = '{0}'))";
strJlCondition = string.Format(strJlCondition, strTrainJiaoluGUID);
}
else
{
strJlCondition = " and (strTrainJiaoluGUID in (select strTrainJiaoluGUID from TAB_Base_TrainJiaoluInSite where strSiteGUID='{0}') ) ";
strJlCondition = string.Format(strJlCondition, clientGUID);
}
strWhere = string.Format(" (dtStartTime >='{0}' or dtStartTime <= 36524)and dtStartTime <= '{1}' and nPlanState <> 0 {2} and nPlanState >=2 and strPlaceID in ({3}) order by dtStartTime asc,nid asc", startTime, endTime, strJlCondition, placeIDs);
DataSet set = dal.GetList(strWhere);
return(GetPlans(DataTableToList(set.Tables[0])));
}
public Client_Out GetPlaceOfClient(string data)
{
Client_Out json = new Client_Out();
try
{
Client_In input = Newtonsoft.Json.JsonConvert.DeserializeObject <Client_In>(data);
TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace bllPlace = new TF.RunSafty.BLL.Place.VIEW_Base_Site_DutyPlace();
List <TF.RunSafty.Model.VIEW_Base_Site_DutyPlace> placeList = bllPlace.GetPlaceOfClient(input.trainjiaoluID, input.siteID);
json.result = "0";
json.resultStr = "提交成功";
json.data = GetPlaceListOfClient(placeList);
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
json.result = "1";
json.resultStr = "提交失败" + ex.Message;
}
return(json);
}
