//根据制单号返回该制单相关信息 public Gps_ManuOrderParam selectManuOrderParamByzhidanDAL(string ZhidanNum, int NullInt) { SqlConnection conn1 = new SqlConnection(conStr); conn1.Open(); Gps_ManuOrderParam list = new Gps_ManuOrderParam(); using (SqlCommand command = conn1.CreateCommand()) { command.CommandText = "SELECT * FROM dbo.Gps_ManuOrderParam WHERE ZhiDan='" + ZhidanNum + "'"; SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { list.SoftModel = dr.GetString(2); list.SN1 = dr.GetString(3); list.SN2 = dr.GetString(4); list.SN3 = dr.IsDBNull(5) ? "" : dr.GetString(5); list.Box_No1 = dr.GetString(6); list.Box_No2 = dr.GetString(7); list.ProductDate = dr.GetString(8); list.Color = dr.GetString(9); list.Weight = dr.GetString(10); list.Qty = dr.GetString(11); list.ProductNo = dr.GetString(12); list.Version = dr.GetString(13); list.IMEIStart = dr.GetString(14); list.IMEIEnd = dr.GetString(15); list.SIMStart = dr.IsDBNull(16) ? "" : dr.GetString(16); list.SIMEnd = dr.IsDBNull(17) ? "" : dr.GetString(17); list.BATStart = dr.IsDBNull(18) ? "" : dr.GetString(18); list.BATEnd = dr.IsDBNull(19) ? "" : dr.GetString(19); list.VIPStart = dr.IsDBNull(20) ? "" : dr.GetString(20); list.VIPEnd = dr.IsDBNull(21) ? "" : dr.GetString(21); list.IMEIRel = dr.GetInt32(22).ToString(); list.Remark1 = dr.IsDBNull(25) ? "" : dr.GetString(25); list.Remark5 = dr.IsDBNull(29) ? "" : dr.GetString(29); list.status = dr.GetInt32(30); list.JST_template = dr.IsDBNull(32) ? "" : dr.GetString(32); list.CHT_template1 = dr.IsDBNull(33) ? "" : dr.GetString(33); list.CHT_template2 = dr.IsDBNull(34) ? "" : dr.GetString(34); list.BAT_prefix = dr.IsDBNull(35) ? "" : dr.GetString(35); list.BAT_digits = dr.IsDBNull(36) ? "" : dr.GetString(36); list.SIM_prefix = dr.IsDBNull(37) ? "" : dr.GetString(37); list.SIM_digits = dr.IsDBNull(38) ? "" : dr.GetString(38); list.VIP_prefix = dr.IsDBNull(39) ? "" : dr.GetString(39); list.VIP_digits = dr.IsDBNull(40) ? "" : dr.GetString(40); list.ICCID_prefix = dr.IsDBNull(41) ? "" : dr.GetString(41); list.ICCID_digits = dr.IsDBNull(42) ? "" : dr.GetString(42); list.IMEIPrints = dr.IsDBNull(43) ? "" : dr.GetString(43); list.MAC_prefix = dr.IsDBNull(44) ? "" : dr.GetString(44); list.MAC_digits = dr.IsDBNull(45) ? "" : dr.GetString(45); list.Equipment_prefix = dr.IsDBNull(46) ? "" : dr.GetString(46); list.Equipment_digits = dr.IsDBNull(47) ? "" : dr.GetString(47); } return(list); } }
//根据制单号返回该制单相关信息 public Gps_ManuOrderParam selectManuOrderParamByzhidanDAL(string ZhidanNum, int NullInt) { SqlConnection conn1 = new SqlConnection(conStr); conn1.Open(); Gps_ManuOrderParam list = new Gps_ManuOrderParam(); using (SqlCommand command = conn1.CreateCommand()) { //command.CommandText = "SELECT * FROM dbo.Gps_ManuOrderParam WHERE ZhiDan='" + ZhidanNum + "'"; command.CommandText = "SELECT " + "SoftModel , SN1 , SN2 , SN3 , BoxNo1 , BoxNo2 , ProductDate , Color , Weight , Qty , ProductNo , Version , IMEIStart , IMEIEnd , SIMStart , SIMEnd , " + " BATStart , BATEnd , VIPStart , VIPEnd , IMEIRel , Remark1 , Remark5 , status , JST_template , CHT_template1 , CHT_template2, BAT_prefix , BAT_digits , SIM_prefix , SIM_digits , VIP_prefix , " + " VIP_digits , ICCID_prefix , ICCID_digits , IMEIPrints , MAC_prefix , MAC_digits , Equipment_prefix , Equipment_digits , RFID_Start , RFID_End , RFID_prefix , RFID_digits FROM dbo.Gps_ManuOrderParam WHERE ZhiDan='" + ZhidanNum + "'AND (Status = 0 or Status =1 or Status = 2)"; SqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { list.SoftModel = dr.GetString(0); list.SN1 = dr.GetString(1); list.SN2 = dr.GetString(2); list.SN3 = dr.IsDBNull(3) ? "" : dr.GetString(3); list.Box_No1 = dr.GetString(4); list.Box_No2 = dr.GetString(5); list.ProductDate = dr.GetString(6); list.Color = dr.GetString(7); list.Weight = dr.GetString(8); list.Qty = dr.GetString(9); list.ProductNo = dr.GetString(10); list.Version = dr.GetString(11); list.IMEIStart = dr.GetString(12); list.IMEIEnd = dr.GetString(13); list.SIMStart = dr.IsDBNull(14) ? "" : dr.GetString(14); list.SIMEnd = dr.IsDBNull(15) ? "" : dr.GetString(15); list.BATStart = dr.IsDBNull(16) ? "" : dr.GetString(16); list.BATEnd = dr.IsDBNull(17) ? "" : dr.GetString(17); list.VIPStart = dr.IsDBNull(18) ? "" : dr.GetString(18); list.VIPEnd = dr.IsDBNull(19) ? "" : dr.GetString(19); list.IMEIRel = dr.GetInt32(20).ToString(); list.Remark1 = dr.IsDBNull(21) ? "" : dr.GetString(21); list.Remark5 = dr.IsDBNull(22) ? "" : dr.GetString(22); list.status = dr.GetInt32(23); list.JST_template = dr.IsDBNull(24) ? "" : dr.GetString(24); list.CHT_template1 = dr.IsDBNull(25) ? "" : dr.GetString(25); list.CHT_template2 = dr.IsDBNull(26) ? "" : dr.GetString(26); list.BAT_prefix = dr.IsDBNull(27) ? "" : dr.GetString(27); list.BAT_digits = dr.IsDBNull(28) ? "" : dr.GetString(28); list.SIM_prefix = dr.IsDBNull(29) ? "" : dr.GetString(29); list.SIM_digits = dr.IsDBNull(30) ? "" : dr.GetString(30); list.VIP_prefix = dr.IsDBNull(31) ? "" : dr.GetString(31); list.VIP_digits = dr.IsDBNull(32) ? "" : dr.GetString(32); list.ICCID_prefix = dr.IsDBNull(33) ? "" : dr.GetString(33); list.ICCID_digits = dr.IsDBNull(34) ? "" : dr.GetString(34); list.IMEIPrints = dr.IsDBNull(35) ? "" : dr.GetString(35); list.MAC_prefix = dr.IsDBNull(36) ? "" : dr.GetString(36); list.MAC_digits = dr.IsDBNull(37) ? "" : dr.GetString(37); list.Equipment_prefix = dr.IsDBNull(38) ? "" : dr.GetString(38); list.Equipment_digits = dr.IsDBNull(39) ? "" : dr.GetString(39); list.RFIDStart = dr.IsDBNull(40) ? "" : dr.GetString(40); list.RFIDEnd = dr.IsDBNull(41) ? "" : dr.GetString(41); list.RFID_prefix = dr.IsDBNull(42) ? "" : dr.GetString(42); list.RFID_digits = dr.IsDBNull(43) ? "" : dr.GetString(43); } return(list); } }