public InterfaceRet Find(string Data) { try { _Ret.Clear(); _Ret.result = 0; _Ret.resultStr = ""; NpSearchResult ret = new NpSearchResult(); ret.Find = false; JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InGetTrainman InParams = javaScriptSerializer.Deserialize <InGetTrainman>(Data); //获取人员基本信息 TmInfo tm = GetTmInfo(InParams.Number); if (tm != null) { Dictionary <string, TmJl> jlDict = GetJlDict(); ret.Find = true; ret.TmState = tm.State; ret.JlID = tm.TMJLID; //通过人员id获取机组id,机组状态,交路id NamePlate np = GetNamePlate(tm.TMID); if (null != np) { ret.GrpID = np.strGroupGUID; ret.TxState = np.nTXState; } if (jlDict.ContainsKey(ret.JlID)) { ret.JlName = jlDict[ret.JlID].Name; //轮乘交路,获取出勤点 if (jlDict[ret.JlID].JlType == 3) { Place p = GetPlace(tm.TMID); if (p != null) { ret.PlaceID = p.strPlaceID; ret.PlaceName = p.strPlaceName; } } } else { if (tm.State == 1) { ret.TmState = 7; } } } _Ret.data = ret; } catch (Exception ex) { _Ret.resultStr = ex.Message; LogClass.log("Interface.Find:" + ex.Message); throw ex; } return(_Ret); }
public TmInfo GetTmInfo(string Number) { string strSql = "select top 1 strTrainmanName,strTrainmanNumber,strTrainmanGUID,nTrainmanState,strTrainmanJiaoluGUID from TAB_Org_Trainman where strTrainmanNumber = '" + Number + "'"; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql).Tables[0]; if (dt.Rows.Count > 0) { TmInfo Ti = new TmInfo(); Ti.Number = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanNumber"]); Ti.State = ObjectConvertClass.static_ext_int(dt.Rows[0]["nTrainmanState"]); Ti.Name = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanName"]); Ti.TMID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanGUID"]); Ti.TMJLID = ObjectConvertClass.static_ext_string(dt.Rows[0]["strTrainmanJiaoluGUID"]); return(Ti); } return(null); }