public LINESBBD getLineDemarcateInf(string station, string line)
{
LINESBBD model = new LINESBBD();
string sql = "select * from [设备标定] where STATIONID='" + station + "' and LINEID='" + line + "'";
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
model.STATIONID = dt.Rows[0]["STATIONID"].ToString();
model.LINEID = dt.Rows[0]["LINEID"].ToString();
model.HXBD = dt.Rows[0]["HXBD"].ToString();
model.HXENABLE = dt.Rows[0]["HXENABLE"].ToString();
model.JSGLBD = dt.Rows[0]["JSGLBD"].ToString();
model.JSGLENABLE = dt.Rows[0]["JSGLENABLE"].ToString();
model.GLBD = dt.Rows[0]["GLBD"].ToString();
model.GLENABLE = dt.Rows[0]["GLENABLE"].ToString();
model.YRDATE = DateTime.Parse(dt.Rows[0]["YRDATE"].ToString());
model.YRENABLE = dt.Rows[0]["YRENABLE"].ToString();
model.FXYBD = dt.Rows[0]["FXYBD"].ToString();
model.FXYENALBE = dt.Rows[0]["FXYENABLE"].ToString();
model.LLJBD = dt.Rows[0]["LLJBD"].ToString();
model.LLJENABLE = dt.Rows[0]["LLJENABLE"].ToString();
}
else
{
model.STATIONID = "-2"; //当服务器上没有找到本线时，本线编号置为-2，以免为0
}
}
catch (Exception)
{
throw;
}
return(model);
}
public LINESBBD getLineDemarcateInf(string station, string line)
{
LINESBBD model = new LINESBBD();
string sql = "select * from [设备标定] where STATIONID='" + station + "' and LINEID='" + line + "'";
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text);
if (dt.Rows.Count > 0)
{
model.STATIONID = dt.Rows[0]["STATIONID"].ToString();
model.LINEID = dt.Rows[0]["LINEID"].ToString();
model.Hxdate = DateTime.Parse(dt.Rows[0]["HXDATE"].ToString());
model.Hxenable = (dt.Rows[0]["HXENABLE"].ToString() == "Y");
model.Jsgldate = DateTime.Parse(dt.Rows[0]["JSGLDATE"].ToString());
model.Jsglenable = (dt.Rows[0]["JSGLENABLE"].ToString() == "Y");
model.Gldate = DateTime.Parse(dt.Rows[0]["GLDATE"].ToString());
model.Glenable = (dt.Rows[0]["GLENABLE"].ToString() == "Y");
model.Yrdate = DateTime.Parse(dt.Rows[0]["YRDATE"].ToString());
model.Yrenable = (dt.Rows[0]["YRENABLE"].ToString() == "Y");
model.Zjdate = DateTime.Parse(dt.Rows[0]["ZJDATE"].ToString());
model.Zjenable = (dt.Rows[0]["ZJENABLE"].ToString() == "Y");
model.Fxylowdate = DateTime.Parse(dt.Rows[0]["FXYLOWDATE"].ToString());
model.Fxylowenable = (dt.Rows[0]["FXYLOWENABLE"].ToString() == "Y");
model.Fxyhighdate = DateTime.Parse(dt.Rows[0]["FXYHIGHDATE"].ToString());
model.Fxyhighenable = (dt.Rows[0]["FXYHIGHENABLE"].ToString() == "Y");
model.Fxymiddate = DateTime.Parse(dt.Rows[0]["FXYMIDDATE"].ToString());
model.Fxymidenable = (dt.Rows[0]["FXYMIDENABLE"].ToString() == "Y");
model.Fxylowmiddate = DateTime.Parse(dt.Rows[0]["FXYLOWMIDDATE"].ToString());
model.Fxylowmidenable = (dt.Rows[0]["FXYLOWMIDENABLE"].ToString() == "Y");
model.Fxyhighmiddate = DateTime.Parse(dt.Rows[0]["FXYHIGHMIDDATE"].ToString());
model.Fxyhighmidenable = (dt.Rows[0]["FXYHIGHMIDENABLE"].ToString() == "Y");
model.Ydjdate = DateTime.Parse(dt.Rows[0]["YDJDATE"].ToString());
model.Ydjenable = (dt.Rows[0]["YDJENABLE"].ToString() == "Y");
model.Lljdate = DateTime.Parse(dt.Rows[0]["LLJDATE"].ToString());
model.Lljenable = (dt.Rows[0]["LLJENABLE"].ToString() == "Y");
model.Yljdate = DateTime.Parse(dt.Rows[0]["YLJDATE"].ToString());
model.Yljenable = (dt.Rows[0]["YLJENABLE"].ToString() == "Y");
model.Sddate = DateTime.Parse(dt.Rows[0]["SDDATE"].ToString());
model.Sdenable = (dt.Rows[0]["SDENABLE"].ToString() == "Y");
model.Hjcsdate = DateTime.Parse(dt.Rows[0]["HJCSDATE"].ToString());
model.Hjcsenable = (dt.Rows[0]["HJCSENABLE"].ToString() == "Y");
model.Zsjdate = DateTime.Parse(dt.Rows[0]["ZSJDATE"].ToString());
model.Zsjenable = (dt.Rows[0]["ZSJENABLE"].ToString() == "Y");
model.Jldate = DateTime.Parse(dt.Rows[0]["JLDATE"].ToString());
model.Jlenable = (dt.Rows[0]["JLENABLE"].ToString() == "Y");
}
else
{
model.STATIONID = station;
model.LINEID = line;
model.Hxdate = DateTime.Now;
model.Hxenable = true;
model.Jsgldate = DateTime.Now;
model.Jsglenable = true;
model.Gldate = DateTime.Now;
model.Glenable = true;
model.Yrdate = DateTime.Now;
model.Yrenable = true;
model.Zjdate = DateTime.Now;
model.Zjenable = true;
model.Fxylowdate = DateTime.Now;
model.Fxylowenable = true;
model.Fxyhighdate = DateTime.Now;
model.Fxyhighenable = true;
model.Fxymiddate = DateTime.Now;
model.Fxymidenable = true;
model.Fxylowmiddate = DateTime.Now;
model.Fxylowmidenable = false;
model.Fxyhighmiddate = DateTime.Now;
model.Fxyhighmidenable = false;
model.Ydjdate = DateTime.Now;
model.Ydjenable = true;
model.Lljdate = DateTime.Now;
model.Lljenable = true;
model.Yljdate = DateTime.Now;
model.Yljenable = true;
model.Sddate = DateTime.Now;
model.Sdenable = true;
model.Hjcsdate = DateTime.Now;
model.Hjcsenable = true;
model.Zsjdate = DateTime.Now;
model.Zsjenable = true;
model.Jldate = DateTime.Now;
model.Jlenable = true;
}
}
catch (Exception)
{
model.STATIONID = station;
model.LINEID = line;
model.Hxdate = DateTime.Now;
model.Hxenable = true;
model.Jsgldate = DateTime.Now;
model.Jsglenable = true;
model.Gldate = DateTime.Now;
model.Glenable = true;
model.Yrdate = DateTime.Now;
model.Yrenable = true;
model.Zjdate = DateTime.Now;
model.Zjenable = true;
model.Fxylowdate = DateTime.Now;
model.Fxylowenable = true;
model.Fxyhighdate = DateTime.Now;
model.Fxyhighenable = true;
model.Fxymiddate = DateTime.Now;
model.Fxymidenable = true;
model.Fxylowmiddate = DateTime.Now;
model.Fxylowmidenable = false;
model.Fxyhighmiddate = DateTime.Now;
model.Fxyhighmidenable = false;
model.Ydjdate = DateTime.Now;
model.Ydjenable = true;
model.Lljdate = DateTime.Now;
model.Lljenable = true;
model.Yljdate = DateTime.Now;
model.Yljenable = true;
model.Sddate = DateTime.Now;
model.Sdenable = true;
model.Hjcsdate = DateTime.Now;
model.Hjcsenable = true;
model.Zsjdate = DateTime.Now;
model.Zsjenable = true;
model.Jldate = DateTime.Now;
model.Jlenable = true;
}
return(model);
}
