public void FillSiteTrainJiaolus(DataTable table, TRsSiteInfo Site) { sTrainJiaolu t = null; foreach (DataRow row in table.Rows) { t = new sTrainJiaolu(); t.strTrainJiaoluGUID = row["strTrainJiaoluGUID"].ToString(); Site.TrainJiaolus.Add(t); } }
public void FillSiteJobLimits(DataTable table, TRsSiteInfo Site) { RRsJobLimit jobLimit = new RRsJobLimit(); foreach (DataRow row in table.Rows) { jobLimit = new RRsJobLimit(); jobLimit.Job = (TRsSiteJob)(Convert.ToInt32(row["nJobID"])); jobLimit.Limimt = (TRsJobLimit)(Convert.ToInt32(row["nJobLimit"])); Site.JobLimits.Add(jobLimit); } }
public Client_Out GetSiteByIP(string input) { Client_Out json = new Client_Out(); Client_In model = null; try { model = Newtonsoft.Json.JsonConvert.DeserializeObject <Client_In>(input); string strSql = string.Format("select * from TAB_Base_Site where strSiteIP=@strSiteIP"); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("strSiteIP", model.localIP), }; DataTable table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; if (table != null && table.Rows.Count > 0) { DataRow row = table.Rows[0]; string strSiteGUID = row["strSiteGUID"].ToString(); TRsSiteInfo Site = new TRsSiteInfo(); ADOQueryToData(row, Site); strSql = string.Format("select * from TAB_Base_TrainJiaoluInSite where strSiteGUID=@strSiteGUID"); sqlParameters = new SqlParameter[] { new SqlParameter("strSiteGUID", strSiteGUID), }; table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; FillSiteTrainJiaolus(table, Site); strSql = string.Format("select * from TAB_Base_Site_Limit where strSiteGUID=@strSiteGUID"); table = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0]; FillSiteJobLimits(table, Site); json.data = Site; json.result = "0"; json.resultStr = "获取用户信息成功"; } else { json.result = "1"; json.resultStr = "该客户端没有在服务器上注册"; } } catch (Exception ex) { TF.CommonUtility.LogClass.logex(ex, ""); throw ex; } return(json); }
public void ADOQueryToData(DataRow row, TRsSiteInfo Site) { Site.strSiteGUID = row["strSiteGUID"].ToString(); Site.strSiteNumber = row["strSiteNumber"].ToString(); Site.strSiteName = row["strSiteName"].ToString(); Site.strAreaGUID = row["strAreaGUID"].ToString(); if (row["nSiteEnable"] != DBNull.Value) { int.TryParse(row["nSiteEnable"].ToString(), out Site.nSiteEnable); } Site.strSiteIP = row["strSiteIP"].ToString(); if (row["nSiteJob"] != DBNull.Value) { int.TryParse(row["nSiteJob"].ToString(), out Site.nSiteJob); } Site.strStationGUID = row["strStationGUID"].ToString(); Site.WorkShopGUID = row["strWorkShopGUID"].ToString(); Site.Tmis = row["strTMIS"].ToString(); }