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