public stationInfModel getStationInf(string stationid)
{
stationInfModel model = new stationInfModel();
string sql = "select * from stationNormalInf";
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
model.STATIONID = dt.Rows[0]["STATIONID"].ToString();
model.STATIONADD = dt.Rows[0]["STATIONADD"].ToString();
model.STATIONNAME = dt.Rows[0]["STATIONNAME"].ToString();
model.STATIONPERSON = dt.Rows[0]["STATIONPERSON"].ToString();
model.STATIONPHONE = dt.Rows[0]["STATIONPHONE"].ToString();
model.STATIONDATE = dt.Rows[0]["STATIONDATE"].ToString();
model.STATIONJCFF = dt.Rows[0]["STATIONJCFF"].ToString();
model.STANDARD = dt.Rows[0]["STANDARD"].ToString();
model.STATIONNET = dt.Rows[0]["STATIONNET"].ToString();
model.StationCompany = dt.Rows[0]["STATIONCOMPANY"].ToString();
}
else
{
model.STATIONID = "-2"; //当服务器上没有找到本线时，本线编号置为-2，以免为0
}
}
catch (Exception)
{
throw;
}
return(model);
}
public stationInfModel getStationInf(string stationid)
{
stationInfModel model = new stationInfModel();
string sql = "select * from stationNormalInf";
DateTime datetimemodel;
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
model.STATIONID = dt.Rows[0]["STATIONID"].ToString();
model.STATIONADD = dt.Rows[0]["STATIONADD"].ToString();
model.STATIONNAME = dt.Rows[0]["STATIONNAME"].ToString();
model.STATIONPERSON = dt.Rows[0]["STATIONPERSON"].ToString();
model.STATIONPHONE = dt.Rows[0]["STATIONPHONE"].ToString();
model.STATIONDATE = dt.Rows[0]["STATIONDATE"].ToString();
model.STATIONJCFF = dt.Rows[0]["STATIONJCFF"].ToString();
model.STANDARD = dt.Rows[0]["STANDARD"].ToString();
model.STATIONNET = dt.Rows[0]["STATIONNET"].ToString();
model.StationCompany = dt.Rows[0]["STATIONCOMPANY"].ToString();
model.JCZXKZH = dt.Rows[0]["JCZXKZH"].ToString();
model.SBHZBH = dt.Rows[0]["SBHZBH"].ToString();
if (DateTime.TryParse(dt.Rows[0]["YXQSTARTTIME"].ToString(), out datetimemodel))
{
model.YXQSTARTTIME = datetimemodel;
}
else
{
model.YXQSTARTTIME = DateTime.Now;
}
if (DateTime.TryParse(dt.Rows[0]["YXQENDTIME"].ToString(), out datetimemodel))
{
model.YXQENDTIME = datetimemodel;
}
else
{
model.YXQENDTIME = DateTime.Now;
}
model.ISLOCK = (dt.Rows[0]["ISLOCK"].ToString() == "Y");
model.LOCKREASON = dt.Rows[0]["LOCKREASON"].ToString();
if (dt.Columns.Contains("CLEARMODE"))
{
model.CLEARMODE = dt.Rows[0]["CLEARMODE"].ToString();
}
else
{
model.CLEARMODE = "Y";
}
if (dt.Columns.Contains("JJLX"))
{
model.JJLX = dt.Rows[0]["JJLX"].ToString();
model.LXR = dt.Rows[0]["LXR"].ToString();
model.FZR = dt.Rows[0]["FZR"].ToString();
if (DateTime.TryParse(dt.Rows[0]["ZCSJ"].ToString(), out datetimemodel))
{
model.ZCSJ = datetimemodel;
}
else
{
model.ZCSJ = DateTime.Now;
}
}
else
{
model.JJLX = "";
model.LXR = "";
model.FZR = "";
model.ZCSJ = DateTime.Now;
}
if (dt.Columns.Contains("JCXS"))
{
model.JCXS = dt.Rows[0]["JCXS"].ToString();
}
else
{
model.JCXS = "";
}
if (dt.Columns.Contains("STATIONCOUNTDATE"))
{
if (DateTime.TryParse(dt.Rows[0]["STATIONCOUNTDATE"].ToString(), out datetimemodel))
{
model.STATIONCOUNTDATE = datetimemodel;
}
else
{
model.STATIONCOUNTDATE = DateTime.Now.AddDays(-1);
}
if (DateTime.TryParse(dt.Rows[0]["LOGINCOUNTDATE"].ToString(), out datetimemodel))
{
model.LOGINCOUNTDATE = datetimemodel;
}
else
{
model.LOGINCOUNTDATE = DateTime.Now.AddDays(-1);
}
}
else
{
model.STATIONCOUNTDATE = DateTime.Now.AddDays(-1);
model.LOGINCOUNTDATE = DateTime.Now.AddDays(-1);
}
if (dt.Columns.Contains("LSHRULE"))
{
model.LSHRULE = dt.Rows[0]["LSHRULE"].ToString();
if (model.LSHRULE == "")
{
model.LSHRULE = "通用";
}
}
else
{
model.LSHRULE = "通用";
}
}
else
{
model.STATIONID = "-2"; //当服务器上没有找到本线时，本线编号置为-2，以免为0
}
}
catch (Exception)
{
throw;
}
return(model);
}
