コード例 #1
0
 public static void Insert(VarEquip row)
 {
     using (var conn = CacheManager.CreateConnection())
     {
         insert.Connection = conn;
         conn.Open();
         InsertRow(row);
         insert.Connection = null;
     }
 }
コード例 #2
0
 public static void Insert(System.Data.DataTable dt)
 {
     using (var conn = CacheManager.CreateConnection())
     {
         insert.Connection = conn;
         conn.Open();
         using (var t = conn.BeginTransaction())
         {
             for (var i = 0; i < dt.Rows.Count; i++)
             {
                 var row  = dt.Rows[i];
                 var data = VarEquip.FromDataRow(row);
                 InsertRow(data);
             }
             t.Commit();
         }
         insert.Connection = null;
     }
 }
コード例 #3
0
        public static VarEquip GetById(int varEquipId)
        {
            VarEquip result = null;

            using (var conn = CacheManager.CreateConnection())
            {
                using (var cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "SELECT * FROM VarEquip WHERE ID = @ID";
                    cmd.Parameters.AddWithValue("@ID", varEquipId);
                    conn.Open();
                    using (var reader = cmd.ExecuteReader(CommandBehavior.SingleRow))
                    {
                        if (reader.Read())
                        {
                            result = VarEquip.FromDataReader(reader);
                        }
                    }
                }
            }
            return(result);
        }
コード例 #4
0
 public static void Insert(VarEquip row)
 {
     using (var conn = CacheManager.CreateConnection())
     {
         insert.Connection = conn;
         conn.Open();
         InsertRow(row);
         insert.Connection = null;
     }
 }
コード例 #5
0
        public static VarEquip FromDataRow(System.Data.DataRow row)
        {
            if (row == null) { throw new ArgumentNullException("row"); }

            VarEquip result = new VarEquip()
            {
                ID = (int)row["ID"],
                C0 = (float)row["0"],
                C1 = (float)row["1"],
                C2 = (float)row["2"],
                C3 = (float)row["3"],
                C4 = (float)row["4"],
                C5 = (float)row["5"],
                C6 = (float)row["6"],
                C7 = (float)row["7"],
                C8 = (float)row["8"],
                C9 = (float)row["9"],
                C10 = (float)row["10"],
                C11 = (float)row["11"],
                C12 = (float)row["12"],
                C13 = (float)row["13"],
                C14 = (float)row["14"],
                C15 = (float)row["15"],
                C16 = (float)row["16"],
                C17 = (float)row["17"],
                C18 = (float)row["18"],
                C19 = (float)row["19"],
                C20 = (float)row["20"],
                C21 = (float)row["21"],
                C22 = (float)row["22"],
                C23 = (float)row["23"],
                C24 = (float)row["24"],
                C25 = (float)row["25"],
                C26 = (float)row["26"],
                C27 = (float)row["27"],
                C28 = (float)row["28"],
                C29 = (float)row["29"],
                C30 = (float)row["30"],
                C31 = (float)row["31"],
                C32 = (float)row["32"],
                C33 = (float)row["33"],
                C34 = (float)row["34"],
                C35 = (float)row["35"],
                C36 = (float)row["36"],
                C37 = (float)row["37"],
                C38 = (float)row["38"],
                C39 = (float)row["39"],
                C40 = (float)row["40"],
                C41 = (float)row["41"],
                C42 = (float)row["42"],
                C43 = (float)row["43"],
                C44 = (float)row["44"],
                C45 = (float)row["45"],
                C46 = (float)row["46"],
                C47 = (float)row["47"],
                C48 = (float)row["48"],
                C49 = (float)row["49"],
                C50 = (float)row["50"],
                C51 = (float)row["51"],
                C52 = (float)row["52"],
                C53 = (float)row["53"],
                C54 = (float)row["54"],
                C55 = (float)row["55"],
                C56 = (float)row["56"],
                C57 = (float)row["57"],
                C58 = (float)row["58"],
                C59 = (float)row["59"],
                C60 = (float)row["60"],
                C61 = (float)row["61"],
                C62 = (float)row["62"],
                C63 = (float)row["63"],
                C64 = (float)row["64"],
                C65 = (float)row["65"],
                C66 = (float)row["66"],
                C67 = (float)row["67"],
                C68 = (float)row["68"],
                C69 = (float)row["69"],
                C70 = (float)row["70"],
                C71 = (float)row["71"],
                C72 = (float)row["72"],
                C73 = (float)row["73"],
                C74 = (float)row["74"],
                C75 = (float)row["75"],
                PgrpA = (bool)row["76"],
                PgrpB = (bool)row["77"],
                PgrpC = (bool)row["78"],
                PgrpD = (bool)row["79"],
                PgrpE = (bool)row["80"],
                PgrpF = (bool)row["81"],
                PgrpG = (bool)row["82"],
                PgrpH = (bool)row["83"],
                PgrpI = (bool)row["84"],
                PgrpJ = (bool)row["85"],
                PgrpK = (bool)row["86"],
                PgrpL = (bool)row["87"],
                PgrpM = (bool)row["88"],
                PgrpN = (bool)row["89"],
                PgrpO = (bool)row["90"],
                PgrpP = (bool)row["91"],
                TexPathID = (int)row["108"],
                Texture = (int)row["109"],
                C110 = (int)row["110"]
            };

            return result;
        }
コード例 #6
0
        public static VarEquip FromDataReader(SQLiteDataReader reader)
        {
            if (reader == null) { throw new ArgumentNullException("reader"); }

            VarEquip result = new VarEquip();
            result.ID = (int)reader["ID"];
            result.C0 = (float)reader["C0"];
            result.C1 = (float)reader["C1"];
            result.C2 = (float)reader["C2"];
            result.C3 = (float)reader["C3"];
            result.C4 = (float)reader["C4"];
            result.C5 = (float)reader["C5"];
            result.C6 = (float)reader["C6"];
            result.C7 = (float)reader["C7"];
            result.C8 = (float)reader["C8"];
            result.C9 = (float)reader["C9"];
            result.C10 = (float)reader["C10"];
            result.C11 = (float)reader["C11"];
            result.C12 = (float)reader["C12"];
            result.C13 = (float)reader["C13"];
            result.C14 = (float)reader["C14"];
            result.C15 = (float)reader["C15"];
            result.C16 = (float)reader["C16"];
            result.C17 = (float)reader["C17"];
            result.C18 = (float)reader["C18"];
            result.C19 = (float)reader["C19"];
            result.C20 = (float)reader["C20"];
            result.C21 = (float)reader["C21"];
            result.C22 = (float)reader["C22"];
            result.C23 = (float)reader["C23"];
            result.C24 = (float)reader["C24"];
            result.C25 = (float)reader["C25"];
            result.C26 = (float)reader["C26"];
            result.C27 = (float)reader["C27"];
            result.C28 = (float)reader["C28"];
            result.C29 = (float)reader["C29"];
            result.C30 = (float)reader["C30"];
            result.C31 = (float)reader["C31"];
            result.C32 = (float)reader["C32"];
            result.C33 = (float)reader["C33"];
            result.C34 = (float)reader["C34"];
            result.C35 = (float)reader["C35"];
            result.C36 = (float)reader["C36"];
            result.C37 = (float)reader["C37"];
            result.C38 = (float)reader["C38"];
            result.C39 = (float)reader["C39"];
            result.C40 = (float)reader["C40"];
            result.C41 = (float)reader["C41"];
            result.C42 = (float)reader["C42"];
            result.C43 = (float)reader["C43"];
            result.C44 = (float)reader["C44"];
            result.C45 = (float)reader["C45"];
            result.C46 = (float)reader["C46"];
            result.C47 = (float)reader["C47"];
            result.C48 = (float)reader["C48"];
            result.C49 = (float)reader["C49"];
            result.C50 = (float)reader["C50"];
            result.C51 = (float)reader["C51"];
            result.C52 = (float)reader["C52"];
            result.C53 = (float)reader["C53"];
            result.C54 = (float)reader["C54"];
            result.C55 = (float)reader["C55"];
            result.C56 = (float)reader["C56"];
            result.C57 = (float)reader["C57"];
            result.C58 = (float)reader["C58"];
            result.C59 = (float)reader["C59"];
            result.C60 = (float)reader["C60"];
            result.C61 = (float)reader["C61"];
            result.C62 = (float)reader["C62"];
            result.C63 = (float)reader["C63"];
            result.C64 = (float)reader["C64"];
            result.C65 = (float)reader["C65"];
            result.C66 = (float)reader["C66"];
            result.C67 = (float)reader["C67"];
            result.C68 = (float)reader["C68"];
            result.C69 = (float)reader["C69"];
            result.C70 = (float)reader["C70"];
            result.C71 = (float)reader["C71"];
            result.C72 = (float)reader["C72"];
            result.C73 = (float)reader["C73"];
            result.C74 = (float)reader["C74"];
            result.C75 = (float)reader["C75"];
            result.PgrpA = (bool)reader["PgrpA"];
            result.PgrpB = (bool)reader["PgrpB"];
            result.PgrpC = (bool)reader["PgrpC"];
            result.PgrpD = (bool)reader["PgrpD"];
            result.PgrpE = (bool)reader["PgrpE"];
            result.PgrpF = (bool)reader["PgrpF"];
            result.PgrpG = (bool)reader["PgrpG"];
            result.PgrpH = (bool)reader["PgrpH"];
            result.PgrpI = (bool)reader["PgrpI"];
            result.PgrpJ = (bool)reader["PgrpJ"];
            result.PgrpK = (bool)reader["PgrpK"];
            result.PgrpL = (bool)reader["PgrpL"];
            result.PgrpM = (bool)reader["PgrpM"];
            result.PgrpN = (bool)reader["PgrpN"];
            result.PgrpO = (bool)reader["PgrpO"];
            result.PgrpP = (bool)reader["PgrpP"];
            result.TexPathID = (int)reader["TexPathID"];
            result.Texture = (int)reader["Texture"];
            result.C110 = (int)reader["C110"];

            return result;
        }
コード例 #7
0
        private static void InsertRow(VarEquip row)
        {
            insert.Parameters["@ID"].Value = row.ID;
            insert.Parameters["@Texture"].Value = row.Texture;
            insert.Parameters["@TexPathID"].Value = row.TexPathID;
            insert.Parameters["@C110"].Value = row.C110;
            insert.Parameters["@PgrpA"].Value = row.PgrpA;
            insert.Parameters["@PgrpB"].Value = row.PgrpB;
            insert.Parameters["@PgrpC"].Value = row.PgrpC;
            insert.Parameters["@PgrpD"].Value = row.PgrpD;
            insert.Parameters["@PgrpE"].Value = row.PgrpE;
            insert.Parameters["@PgrpF"].Value = row.PgrpF;
            insert.Parameters["@PgrpG"].Value = row.PgrpG;
            insert.Parameters["@PgrpH"].Value = row.PgrpH;
            insert.Parameters["@PgrpI"].Value = row.PgrpI;
            insert.Parameters["@PgrpJ"].Value = row.PgrpJ;
            insert.Parameters["@PgrpK"].Value = row.PgrpK;
            insert.Parameters["@PgrpL"].Value = row.PgrpL;
            insert.Parameters["@PgrpM"].Value = row.PgrpM;
            insert.Parameters["@PgrpN"].Value = row.PgrpN;
            insert.Parameters["@PgrpO"].Value = row.PgrpO;
            insert.Parameters["@PgrpP"].Value = row.PgrpP;
            insert.Parameters["@C0"].Value = row.C0;
            insert.Parameters["@C1"].Value = row.C1;
            insert.Parameters["@C2"].Value = row.C2;
            insert.Parameters["@C3"].Value = row.C3;
            insert.Parameters["@C4"].Value = row.C4;
            insert.Parameters["@C5"].Value = row.C5;
            insert.Parameters["@C6"].Value = row.C6;
            insert.Parameters["@C7"].Value = row.C7;
            insert.Parameters["@C8"].Value = row.C8;
            insert.Parameters["@C9"].Value = row.C9;
            insert.Parameters["@C10"].Value = row.C10;
            insert.Parameters["@C11"].Value = row.C11;
            insert.Parameters["@C12"].Value = row.C12;
            insert.Parameters["@C13"].Value = row.C13;
            insert.Parameters["@C14"].Value = row.C14;
            insert.Parameters["@C15"].Value = row.C15;
            insert.Parameters["@C16"].Value = row.C16;
            insert.Parameters["@C17"].Value = row.C17;
            insert.Parameters["@C18"].Value = row.C18;
            insert.Parameters["@C19"].Value = row.C19;
            insert.Parameters["@C20"].Value = row.C20;
            insert.Parameters["@C21"].Value = row.C21;
            insert.Parameters["@C22"].Value = row.C22;
            insert.Parameters["@C23"].Value = row.C23;
            insert.Parameters["@C24"].Value = row.C24;
            insert.Parameters["@C25"].Value = row.C25;
            insert.Parameters["@C26"].Value = row.C26;
            insert.Parameters["@C27"].Value = row.C27;
            insert.Parameters["@C28"].Value = row.C28;
            insert.Parameters["@C29"].Value = row.C29;
            insert.Parameters["@C30"].Value = row.C20;
            insert.Parameters["@C31"].Value = row.C31;
            insert.Parameters["@C32"].Value = row.C32;
            insert.Parameters["@C33"].Value = row.C33;
            insert.Parameters["@C34"].Value = row.C34;
            insert.Parameters["@C35"].Value = row.C35;
            insert.Parameters["@C36"].Value = row.C36;
            insert.Parameters["@C37"].Value = row.C37;
            insert.Parameters["@C38"].Value = row.C38;
            insert.Parameters["@C39"].Value = row.C39;
            insert.Parameters["@C40"].Value = row.C40;
            insert.Parameters["@C41"].Value = row.C41;
            insert.Parameters["@C42"].Value = row.C42;
            insert.Parameters["@C43"].Value = row.C43;
            insert.Parameters["@C44"].Value = row.C44;
            insert.Parameters["@C45"].Value = row.C45;
            insert.Parameters["@C46"].Value = row.C46;
            insert.Parameters["@C47"].Value = row.C47;
            insert.Parameters["@C48"].Value = row.C48;
            insert.Parameters["@C49"].Value = row.C49;
            insert.Parameters["@C50"].Value = row.C50;
            insert.Parameters["@C51"].Value = row.C51;
            insert.Parameters["@C52"].Value = row.C52;
            insert.Parameters["@C53"].Value = row.C53;
            insert.Parameters["@C54"].Value = row.C54;
            insert.Parameters["@C55"].Value = row.C55;
            insert.Parameters["@C56"].Value = row.C56;
            insert.Parameters["@C57"].Value = row.C57;
            insert.Parameters["@C58"].Value = row.C58;
            insert.Parameters["@C59"].Value = row.C59;
            insert.Parameters["@C60"].Value = row.C60;
            insert.Parameters["@C61"].Value = row.C61;
            insert.Parameters["@C62"].Value = row.C62;
            insert.Parameters["@C63"].Value = row.C63;
            insert.Parameters["@C64"].Value = row.C64;
            insert.Parameters["@C65"].Value = row.C65;
            insert.Parameters["@C66"].Value = row.C66;
            insert.Parameters["@C67"].Value = row.C67;
            insert.Parameters["@C68"].Value = row.C68;
            insert.Parameters["@C69"].Value = row.C69;
            insert.Parameters["@C70"].Value = row.C70;
            insert.Parameters["@C71"].Value = row.C71;
            insert.Parameters["@C72"].Value = row.C72;
            insert.Parameters["@C73"].Value = row.C73;
            insert.Parameters["@C74"].Value = row.C74;
            insert.Parameters["@C75"].Value = row.C75;

            insert.ExecuteNonQuery();
        }
コード例 #8
0
        private static void InsertRow(VarEquip row)
        {
            insert.Parameters["@ID"].Value        = row.ID;
            insert.Parameters["@Texture"].Value   = row.Texture;
            insert.Parameters["@TexPathID"].Value = row.TexPathID;
            insert.Parameters["@C110"].Value      = row.C110;
            insert.Parameters["@PgrpA"].Value     = row.PgrpA;
            insert.Parameters["@PgrpB"].Value     = row.PgrpB;
            insert.Parameters["@PgrpC"].Value     = row.PgrpC;
            insert.Parameters["@PgrpD"].Value     = row.PgrpD;
            insert.Parameters["@PgrpE"].Value     = row.PgrpE;
            insert.Parameters["@PgrpF"].Value     = row.PgrpF;
            insert.Parameters["@PgrpG"].Value     = row.PgrpG;
            insert.Parameters["@PgrpH"].Value     = row.PgrpH;
            insert.Parameters["@PgrpI"].Value     = row.PgrpI;
            insert.Parameters["@PgrpJ"].Value     = row.PgrpJ;
            insert.Parameters["@PgrpK"].Value     = row.PgrpK;
            insert.Parameters["@PgrpL"].Value     = row.PgrpL;
            insert.Parameters["@PgrpM"].Value     = row.PgrpM;
            insert.Parameters["@PgrpN"].Value     = row.PgrpN;
            insert.Parameters["@PgrpO"].Value     = row.PgrpO;
            insert.Parameters["@PgrpP"].Value     = row.PgrpP;
            insert.Parameters["@C0"].Value        = row.C0;
            insert.Parameters["@C1"].Value        = row.C1;
            insert.Parameters["@C2"].Value        = row.C2;
            insert.Parameters["@C3"].Value        = row.C3;
            insert.Parameters["@C4"].Value        = row.C4;
            insert.Parameters["@C5"].Value        = row.C5;
            insert.Parameters["@C6"].Value        = row.C6;
            insert.Parameters["@C7"].Value        = row.C7;
            insert.Parameters["@C8"].Value        = row.C8;
            insert.Parameters["@C9"].Value        = row.C9;
            insert.Parameters["@C10"].Value       = row.C10;
            insert.Parameters["@C11"].Value       = row.C11;
            insert.Parameters["@C12"].Value       = row.C12;
            insert.Parameters["@C13"].Value       = row.C13;
            insert.Parameters["@C14"].Value       = row.C14;
            insert.Parameters["@C15"].Value       = row.C15;
            insert.Parameters["@C16"].Value       = row.C16;
            insert.Parameters["@C17"].Value       = row.C17;
            insert.Parameters["@C18"].Value       = row.C18;
            insert.Parameters["@C19"].Value       = row.C19;
            insert.Parameters["@C20"].Value       = row.C20;
            insert.Parameters["@C21"].Value       = row.C21;
            insert.Parameters["@C22"].Value       = row.C22;
            insert.Parameters["@C23"].Value       = row.C23;
            insert.Parameters["@C24"].Value       = row.C24;
            insert.Parameters["@C25"].Value       = row.C25;
            insert.Parameters["@C26"].Value       = row.C26;
            insert.Parameters["@C27"].Value       = row.C27;
            insert.Parameters["@C28"].Value       = row.C28;
            insert.Parameters["@C29"].Value       = row.C29;
            insert.Parameters["@C30"].Value       = row.C20;
            insert.Parameters["@C31"].Value       = row.C31;
            insert.Parameters["@C32"].Value       = row.C32;
            insert.Parameters["@C33"].Value       = row.C33;
            insert.Parameters["@C34"].Value       = row.C34;
            insert.Parameters["@C35"].Value       = row.C35;
            insert.Parameters["@C36"].Value       = row.C36;
            insert.Parameters["@C37"].Value       = row.C37;
            insert.Parameters["@C38"].Value       = row.C38;
            insert.Parameters["@C39"].Value       = row.C39;
            insert.Parameters["@C40"].Value       = row.C40;
            insert.Parameters["@C41"].Value       = row.C41;
            insert.Parameters["@C42"].Value       = row.C42;
            insert.Parameters["@C43"].Value       = row.C43;
            insert.Parameters["@C44"].Value       = row.C44;
            insert.Parameters["@C45"].Value       = row.C45;
            insert.Parameters["@C46"].Value       = row.C46;
            insert.Parameters["@C47"].Value       = row.C47;
            insert.Parameters["@C48"].Value       = row.C48;
            insert.Parameters["@C49"].Value       = row.C49;
            insert.Parameters["@C50"].Value       = row.C50;
            insert.Parameters["@C51"].Value       = row.C51;
            insert.Parameters["@C52"].Value       = row.C52;
            insert.Parameters["@C53"].Value       = row.C53;
            insert.Parameters["@C54"].Value       = row.C54;
            insert.Parameters["@C55"].Value       = row.C55;
            insert.Parameters["@C56"].Value       = row.C56;
            insert.Parameters["@C57"].Value       = row.C57;
            insert.Parameters["@C58"].Value       = row.C58;
            insert.Parameters["@C59"].Value       = row.C59;
            insert.Parameters["@C60"].Value       = row.C60;
            insert.Parameters["@C61"].Value       = row.C61;
            insert.Parameters["@C62"].Value       = row.C62;
            insert.Parameters["@C63"].Value       = row.C63;
            insert.Parameters["@C64"].Value       = row.C64;
            insert.Parameters["@C65"].Value       = row.C65;
            insert.Parameters["@C66"].Value       = row.C66;
            insert.Parameters["@C67"].Value       = row.C67;
            insert.Parameters["@C68"].Value       = row.C68;
            insert.Parameters["@C69"].Value       = row.C69;
            insert.Parameters["@C70"].Value       = row.C70;
            insert.Parameters["@C71"].Value       = row.C71;
            insert.Parameters["@C72"].Value       = row.C72;
            insert.Parameters["@C73"].Value       = row.C73;
            insert.Parameters["@C74"].Value       = row.C74;
            insert.Parameters["@C75"].Value       = row.C75;

            insert.ExecuteNonQuery();
        }
コード例 #9
0
        public static VarEquip FromDataReader(SQLiteDataReader reader)
        {
            if (reader == null)
            {
                throw new ArgumentNullException("reader");
            }

            VarEquip result = new VarEquip();

            result.ID        = (int)reader["ID"];
            result.C0        = (float)reader["C0"];
            result.C1        = (float)reader["C1"];
            result.C2        = (float)reader["C2"];
            result.C3        = (float)reader["C3"];
            result.C4        = (float)reader["C4"];
            result.C5        = (float)reader["C5"];
            result.C6        = (float)reader["C6"];
            result.C7        = (float)reader["C7"];
            result.C8        = (float)reader["C8"];
            result.C9        = (float)reader["C9"];
            result.C10       = (float)reader["C10"];
            result.C11       = (float)reader["C11"];
            result.C12       = (float)reader["C12"];
            result.C13       = (float)reader["C13"];
            result.C14       = (float)reader["C14"];
            result.C15       = (float)reader["C15"];
            result.C16       = (float)reader["C16"];
            result.C17       = (float)reader["C17"];
            result.C18       = (float)reader["C18"];
            result.C19       = (float)reader["C19"];
            result.C20       = (float)reader["C20"];
            result.C21       = (float)reader["C21"];
            result.C22       = (float)reader["C22"];
            result.C23       = (float)reader["C23"];
            result.C24       = (float)reader["C24"];
            result.C25       = (float)reader["C25"];
            result.C26       = (float)reader["C26"];
            result.C27       = (float)reader["C27"];
            result.C28       = (float)reader["C28"];
            result.C29       = (float)reader["C29"];
            result.C30       = (float)reader["C30"];
            result.C31       = (float)reader["C31"];
            result.C32       = (float)reader["C32"];
            result.C33       = (float)reader["C33"];
            result.C34       = (float)reader["C34"];
            result.C35       = (float)reader["C35"];
            result.C36       = (float)reader["C36"];
            result.C37       = (float)reader["C37"];
            result.C38       = (float)reader["C38"];
            result.C39       = (float)reader["C39"];
            result.C40       = (float)reader["C40"];
            result.C41       = (float)reader["C41"];
            result.C42       = (float)reader["C42"];
            result.C43       = (float)reader["C43"];
            result.C44       = (float)reader["C44"];
            result.C45       = (float)reader["C45"];
            result.C46       = (float)reader["C46"];
            result.C47       = (float)reader["C47"];
            result.C48       = (float)reader["C48"];
            result.C49       = (float)reader["C49"];
            result.C50       = (float)reader["C50"];
            result.C51       = (float)reader["C51"];
            result.C52       = (float)reader["C52"];
            result.C53       = (float)reader["C53"];
            result.C54       = (float)reader["C54"];
            result.C55       = (float)reader["C55"];
            result.C56       = (float)reader["C56"];
            result.C57       = (float)reader["C57"];
            result.C58       = (float)reader["C58"];
            result.C59       = (float)reader["C59"];
            result.C60       = (float)reader["C60"];
            result.C61       = (float)reader["C61"];
            result.C62       = (float)reader["C62"];
            result.C63       = (float)reader["C63"];
            result.C64       = (float)reader["C64"];
            result.C65       = (float)reader["C65"];
            result.C66       = (float)reader["C66"];
            result.C67       = (float)reader["C67"];
            result.C68       = (float)reader["C68"];
            result.C69       = (float)reader["C69"];
            result.C70       = (float)reader["C70"];
            result.C71       = (float)reader["C71"];
            result.C72       = (float)reader["C72"];
            result.C73       = (float)reader["C73"];
            result.C74       = (float)reader["C74"];
            result.C75       = (float)reader["C75"];
            result.PgrpA     = (bool)reader["PgrpA"];
            result.PgrpB     = (bool)reader["PgrpB"];
            result.PgrpC     = (bool)reader["PgrpC"];
            result.PgrpD     = (bool)reader["PgrpD"];
            result.PgrpE     = (bool)reader["PgrpE"];
            result.PgrpF     = (bool)reader["PgrpF"];
            result.PgrpG     = (bool)reader["PgrpG"];
            result.PgrpH     = (bool)reader["PgrpH"];
            result.PgrpI     = (bool)reader["PgrpI"];
            result.PgrpJ     = (bool)reader["PgrpJ"];
            result.PgrpK     = (bool)reader["PgrpK"];
            result.PgrpL     = (bool)reader["PgrpL"];
            result.PgrpM     = (bool)reader["PgrpM"];
            result.PgrpN     = (bool)reader["PgrpN"];
            result.PgrpO     = (bool)reader["PgrpO"];
            result.PgrpP     = (bool)reader["PgrpP"];
            result.TexPathID = (int)reader["TexPathID"];
            result.Texture   = (int)reader["Texture"];
            result.C110      = (int)reader["C110"];

            return(result);
        }
コード例 #10
0
        public static VarEquip FromDataRow(System.Data.DataRow row)
        {
            if (row == null)
            {
                throw new ArgumentNullException("row");
            }

            VarEquip result = new VarEquip()
            {
                ID        = (int)row["ID"],
                C0        = (float)row["0"],
                C1        = (float)row["1"],
                C2        = (float)row["2"],
                C3        = (float)row["3"],
                C4        = (float)row["4"],
                C5        = (float)row["5"],
                C6        = (float)row["6"],
                C7        = (float)row["7"],
                C8        = (float)row["8"],
                C9        = (float)row["9"],
                C10       = (float)row["10"],
                C11       = (float)row["11"],
                C12       = (float)row["12"],
                C13       = (float)row["13"],
                C14       = (float)row["14"],
                C15       = (float)row["15"],
                C16       = (float)row["16"],
                C17       = (float)row["17"],
                C18       = (float)row["18"],
                C19       = (float)row["19"],
                C20       = (float)row["20"],
                C21       = (float)row["21"],
                C22       = (float)row["22"],
                C23       = (float)row["23"],
                C24       = (float)row["24"],
                C25       = (float)row["25"],
                C26       = (float)row["26"],
                C27       = (float)row["27"],
                C28       = (float)row["28"],
                C29       = (float)row["29"],
                C30       = (float)row["30"],
                C31       = (float)row["31"],
                C32       = (float)row["32"],
                C33       = (float)row["33"],
                C34       = (float)row["34"],
                C35       = (float)row["35"],
                C36       = (float)row["36"],
                C37       = (float)row["37"],
                C38       = (float)row["38"],
                C39       = (float)row["39"],
                C40       = (float)row["40"],
                C41       = (float)row["41"],
                C42       = (float)row["42"],
                C43       = (float)row["43"],
                C44       = (float)row["44"],
                C45       = (float)row["45"],
                C46       = (float)row["46"],
                C47       = (float)row["47"],
                C48       = (float)row["48"],
                C49       = (float)row["49"],
                C50       = (float)row["50"],
                C51       = (float)row["51"],
                C52       = (float)row["52"],
                C53       = (float)row["53"],
                C54       = (float)row["54"],
                C55       = (float)row["55"],
                C56       = (float)row["56"],
                C57       = (float)row["57"],
                C58       = (float)row["58"],
                C59       = (float)row["59"],
                C60       = (float)row["60"],
                C61       = (float)row["61"],
                C62       = (float)row["62"],
                C63       = (float)row["63"],
                C64       = (float)row["64"],
                C65       = (float)row["65"],
                C66       = (float)row["66"],
                C67       = (float)row["67"],
                C68       = (float)row["68"],
                C69       = (float)row["69"],
                C70       = (float)row["70"],
                C71       = (float)row["71"],
                C72       = (float)row["72"],
                C73       = (float)row["73"],
                C74       = (float)row["74"],
                C75       = (float)row["75"],
                PgrpA     = (bool)row["76"],
                PgrpB     = (bool)row["77"],
                PgrpC     = (bool)row["78"],
                PgrpD     = (bool)row["79"],
                PgrpE     = (bool)row["80"],
                PgrpF     = (bool)row["81"],
                PgrpG     = (bool)row["82"],
                PgrpH     = (bool)row["83"],
                PgrpI     = (bool)row["84"],
                PgrpJ     = (bool)row["85"],
                PgrpK     = (bool)row["86"],
                PgrpL     = (bool)row["87"],
                PgrpM     = (bool)row["88"],
                PgrpN     = (bool)row["89"],
                PgrpO     = (bool)row["90"],
                PgrpP     = (bool)row["91"],
                TexPathID = (int)row["108"],
                Texture   = (int)row["109"],
                C110      = (int)row["110"]
            };

            return(result);
        }