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