コード例 #1
0
        //根据制单号返回该制单相关信息
        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);
            }
        }
コード例 #2
0
        //根据制单号返回该制单相关信息
        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);
            }
        }