示例#1
0
 public static void INSERT_ITEM_GHI_CHEP(string string_0, string string_1, string string_2, string string_3, double double_0, int int_0, string string_4, int int_1, string string_5, int int_2, string string_6)
 {
     if (World.ITEM_GHI_CHEP == 1)
     {
         string         str = string.Format("INSERT INTO ITEM_GHI_CHEP (UserId,UserName,ToUserId,ToUserName,Toan_bo_ID,Item_ID,Item_ten,Item_so_luong,Item_thuoc_tinh,So_tien,Loai_hinh) VALUES (@UserId,@UserName,@ToUserId,@ToUserName,@Toan_bo_ID,@Item_ID,@Item_ten,@Item_so_luong,@Item_thuoc_tinh,@So_tien,@Loai_hinh)", new object[0]);
         SqlParameter[] sqlParameterArray = new SqlParameter[] { SqlDBA.MakeInParam("@UserId", SqlDbType.VarChar, 30, string_0), SqlDBA.MakeInParam("@UserName", SqlDbType.VarChar, 30, string_1), SqlDBA.MakeInParam("@ToUserId", SqlDbType.VarChar, 30, string_2), SqlDBA.MakeInParam("@ToUserName", SqlDbType.VarChar, 30, string_3), SqlDBA.MakeInParam("@Toan_bo_ID", SqlDbType.VarChar, 30, double_0), SqlDBA.MakeInParam("@Item_ID", SqlDbType.VarChar, 30, int_0), SqlDBA.MakeInParam("@Item_ten", SqlDbType.VarChar, 30, string_4), SqlDBA.MakeInParam("@Item_so_luong", SqlDbType.Int, 4, int_1), SqlDBA.MakeInParam("@Item_thuoc_tinh", SqlDbType.VarChar, 100, string_5), SqlDBA.MakeInParam("@So_tien", SqlDbType.Int, 4, int_2), SqlDBA.MakeInParam("@Loai_hinh", SqlDbType.VarChar, 10, string_6) };
         DbPool_Class   dbPoolClass       = new DbPool_Class()
         {
             Conn  = DBA.smethod_3(null),
             Prams = sqlParameterArray,
             Sql   = str,
             Type  = 1
         };
         World.queue_1.Enqueue(dbPoolClass);
     }
 }
示例#2
0
 public static void INSERT_DANG_NHAP_GHI_CHEP(string string_0, string string_1, string string_2, string string_3)
 {
     if (World.DANG_NHAP_GHI_CHEP == 1)
     {
         string         str = string.Format("INSERT INTO DANG_NHAP_GHI_CHEP (UserId,UserName,UserIp,Loai_hinh) VALUES (@UserId,@UserName,@UserIp,@Loai_hinh)", new object[0]);
         SqlParameter[] sqlParameterArray = new SqlParameter[] { SqlDBA.MakeInParam("@UserId", SqlDbType.VarChar, 30, string_0), SqlDBA.MakeInParam("@UserName", SqlDbType.VarChar, 30, string_1), SqlDBA.MakeInParam("@UserIp", SqlDbType.VarChar, 30, string_2), SqlDBA.MakeInParam("@Loai_hinh", SqlDbType.VarChar, 30, string_3) };
         DbPool_Class   dbPoolClass       = new DbPool_Class()
         {
             Conn  = DBA.smethod_3(null),
             Prams = sqlParameterArray,
             Sql   = str,
             Type  = 1
         };
         World.queue_1.Enqueue(dbPoolClass);
     }
 }
示例#3
0
        public void method_1()
        {
            SqlParameter[] sqlParameterArray = new SqlParameter[] { SqlDBA.MakeInParam("@id", SqlDbType.VarChar, 20, this.long_0.ToString()), SqlDBA.MakeInParam("@name", SqlDbType.VarChar, 20, this.Name), SqlDBA.MakeInParam("@level", SqlDbType.Int, 0, this.FLD_LEVEL), SqlDBA.MakeInParam("@zcd", SqlDbType.Int, 10, this.FLD_ZCD), SqlDBA.MakeInParam("@job", SqlDbType.Int, 0, this.FLD_JOB), SqlDBA.MakeInParam("@job_level", SqlDbType.Int, 0, this.FLD_JOB_LEVEL), null, null, null, null, null, null, null };
            long           fLDEXP            = this.FLD_EXP;

            sqlParameterArray[6]  = SqlDBA.MakeInParam("@exp", SqlDbType.VarChar, 50, fLDEXP.ToString());
            sqlParameterArray[7]  = SqlDBA.MakeInParam("@hp", SqlDbType.Int, 0, this.FLD_HP);
            sqlParameterArray[8]  = SqlDBA.MakeInParam("@mp", SqlDbType.Int, 0, this.FLD_MP);
            sqlParameterArray[9]  = SqlDBA.MakeInParam("@strWearitem", SqlDbType.VarBinary, 365, this.method_2());
            sqlParameterArray[10] = SqlDBA.MakeInParam("@strItem", SqlDbType.VarBinary, 1168, this.method_3());
            sqlParameterArray[11] = SqlDBA.MakeInParam("@strKongfu", SqlDbType.VarBinary, 128, this.method_4());
            sqlParameterArray[12] = SqlDBA.MakeInParam("@bs", SqlDbType.Int, 0, this.Bs);
            SqlParameter[] sqlParameterArray1 = sqlParameterArray;
            DbPool_Class   dbPoolClass        = new DbPool_Class()
            {
                Conn  = DBA.smethod_3(null),
                Prams = sqlParameterArray1,
                Sql   = "XWWL_UPDATE_Cw_DATA"
            };

            World.queue_1.Enqueue(dbPoolClass);
        }