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); } }
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); } }
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); }