//根据制单号返回该制单相关信息
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);
}
}
