/// <summary>
/// 取车辆信息
/// </summary>
/// <param name="carNO">车牌号</param>
/// <returns></returns>
private Mod.DZ_全市车辆 FF_取车辆信息(string carNO)
{
DAL dal = new DAL();
string sql = "SELECT [使用登记证],[安装气瓶数量],[应用类型] FROM [CNGQT].[dbo].[DZ_全市车辆] WHERE 车牌号='" + carNO + "'";
sql = string.Format(sql, carNO);
DataRow qp = dal.RunSqlDataRow(sql);
if (qp == null) { return null; }
Mod.DZ_全市车辆 fqp = new Mod.DZ_全市车辆();
fqp.SX_使用登记证 = (string)qp["使用登记证"];
fqp.SX_安装气瓶数量 = (int)qp["安装气瓶数量"];
fqp.SX_应用类型 = (string)qp["应用类型"];
return (fqp);
}
/// <summary>
/// 取气瓶信息
/// </summary>
/// <param name="carNO">车牌号</param>
/// <returns></returns>
private Mod.DZ_全市气瓶 FF_取气瓶信息(string carNO)
{
DAL dal = new DAL();
string sql = "SELECT top 1 [气瓶使用编号],[气瓶类型],[下次检验日期] FROM [CNGQT].[dbo].[DZ_全市气瓶] where 所属车辆='{0}' order by 下次检验日期";
sql = string.Format(sql, carNO);
DataRow qp = dal.RunSqlDataRow(sql);
if (qp == null) { return null; }
Mod.DZ_全市气瓶 fqp = new Mod.DZ_全市气瓶();
fqp.SX_下次检验日期 = (DateTime)qp["下次检验日期"];
fqp.SX_气瓶类型 = (string)qp["气瓶类型"];
fqp.SX_气瓶使用编号 = (string)qp["气瓶使用编号"];
return (fqp);
}
