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