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