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