public static IEnumerable<DeviceInfoResult> GetInfoList(DateTime? lastModifyDate = null) { SqlParameter pLastModifyDate = new SqlParameter() { ParameterName = "last_modify_date", SqlValue = lastModifyDate, SqlDbType = SqlDbType.Date }; var dt = Db.UnitProg.ExecuteQueryStoredProcedure("get_device_info", pLastModifyDate); var list = new List<DeviceInfoResult>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { var info = new DeviceInfoResult(); info.DeviceId = Db.DbHelper.GetValueIntOrNull(row, "id_device"); info.DeviceSerialNum = Db.DbHelper.GetValueString(row, "serial_num"); info.ContractorStr = Db.DbHelper.GetValueString(row, "contractor_name"); info.ContractStr = Db.DbHelper.GetValueString(row, "contract_number"); info.AddressStr = Db.DbHelper.GetValueString(row, "device_address"); info.DeviceStr = Db.DbHelper.GetValueString(row, "device_name"); info.DescrStr = Db.DbHelper.GetValueString(row, "descr"); list.Add(info); } } return list; }
public static DeviceInfoResult GetInfo(string serialNum) { SqlParameter pSerialNum = new SqlParameter() { ParameterName = "serial_num", SqlValue = serialNum, SqlDbType = SqlDbType.NVarChar }; var dt = Db.UnitProg.ExecuteQueryStoredProcedure("get_device_info", pSerialNum); var result= new DeviceInfoResult(); if (dt.Rows.Count > 0) { var row = dt.Rows[0]; result.DeviceId = Db.DbHelper.GetValueIntOrNull(row, "id_device"); result.DeviceSerialNum = Db.DbHelper.GetValueString(row, "serial_num"); result.ContractorStr = Db.DbHelper.GetValueString(row, "contractor_name"); result.ContractStr = Db.DbHelper.GetValueString(row, "contract_number"); result.AddressStr = Db.DbHelper.GetValueString(row, "device_address"); result.DeviceStr = Db.DbHelper.GetValueString(row, "device_name"); result.DescrStr = Db.DbHelper.GetValueString(row, "descr"); } return result; }