Пример #1
0
 public static int P_AccountTransferAccept(ref DataSet ds, long SiteID, long UserID, long TransferID, long RelatedUserID, string SecurityAnswer, ref int ReturnValue, ref string ReturnDescription)
 {
     MSSQL.OutputParameter outputs = new MSSQL.OutputParameter();
     int num = MSSQL.ExecuteStoredProcedureWithQuery("P_AccountTransferAccept", ref ds, ref outputs, new MSSQL.Parameter[] { new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID), new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID), new MSSQL.Parameter("TransferID", SqlDbType.BigInt, 0, ParameterDirection.Input, TransferID), new MSSQL.Parameter("RelatedUserID", SqlDbType.BigInt, 0, ParameterDirection.Input, RelatedUserID), new MSSQL.Parameter("SecurityAnswer", SqlDbType.VarChar, 0, ParameterDirection.Input, SecurityAnswer), new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, (int) ReturnValue), new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription) });
     try
     {
         ReturnValue = Convert.ToInt32(outputs["ReturnValue"]);
     }
     catch
     {
     }
     try
     {
         ReturnDescription = Convert.ToString(outputs["ReturnDescription"]);
     }
     catch
     {
     }
     return num;
 }
Пример #2
0
 public static int P_AcceptUserHongbaoPromotion(ref DataSet ds, long FromUserID, long ToUserID, long UserHongbaoPromotionID, ref int ReturnValue, ref string ReturnDescription)
 {
     MSSQL.OutputParameter outputs = new MSSQL.OutputParameter();
     int num = MSSQL.ExecuteStoredProcedureWithQuery("P_AcceptUserHongbaoPromotion", ref ds, ref outputs, new MSSQL.Parameter[] { new MSSQL.Parameter("FromUserID", SqlDbType.BigInt, 0, ParameterDirection.Input, FromUserID), new MSSQL.Parameter("ToUserID", SqlDbType.BigInt, 0, ParameterDirection.Input, ToUserID), new MSSQL.Parameter("UserHongbaoPromotionID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserHongbaoPromotionID), new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, (int) ReturnValue), new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription) });
     try
     {
         ReturnValue = Convert.ToInt32(outputs["ReturnValue"]);
     }
     catch
     {
     }
     try
     {
         ReturnDescription = Convert.ToString(outputs["ReturnDescription"]);
     }
     catch
     {
     }
     return num;
 }
Пример #3
0
        public static int P_CpsGetDayBuyDetailByType(string ConnectionString, ref DataSet ds, DateTime DayDate, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CpsGetDayBuyDetailByType", ref ds, ref Outputs,
                new MSSQL.Parameter("DayDate", SqlDbType.DateTime, 0, ParameterDirection.Input, DayDate),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #4
0
        public static int P_CpsGetCommendMemberList(string ConnectionString, long CommmenderID, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_CpsGetCommendMemberList", ref Outputs,
                new MSSQL.Parameter("CommmenderID", SqlDbType.BigInt, 0, ParameterDirection.Input, CommmenderID),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #5
0
        public static int P_CpsDistillQuash(string ConnectionString, ref DataSet ds, long SiteID, long UserID, long DistillID, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CpsDistillQuash", ref ds, ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID),
                new MSSQL.Parameter("DistillID", SqlDbType.BigInt, 0, ParameterDirection.Input, DistillID),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #6
0
        public static int P_CpsDistill(string ConnectionString, ref DataSet ds, long SiteID, long UserID, double Money, double FormalitiesFees, string BankUserName, string BankName, string BankCardNumber, string Memo, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CpsDistill", ref ds, ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID),
                new MSSQL.Parameter("Money", SqlDbType.Money, 0, ParameterDirection.Input, Money),
                new MSSQL.Parameter("FormalitiesFees", SqlDbType.Money, 0, ParameterDirection.Input, FormalitiesFees),
                new MSSQL.Parameter("BankUserName", SqlDbType.VarChar, 0, ParameterDirection.Input, BankUserName),
                new MSSQL.Parameter("BankName", SqlDbType.VarChar, 0, ParameterDirection.Input, BankName),
                new MSSQL.Parameter("BankCardNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, BankCardNumber),
                new MSSQL.Parameter("Memo", SqlDbType.VarChar, 0, ParameterDirection.Input, Memo),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #7
0
        public static int P_CpsAdd(string ConnectionString, long SiteID, long OwnerUserID, string Name, string Url, string LogoUrl, double BonusScale, bool ON, string Company, string Address, string PostCode, string ResponsiblePerson, string ContactPerson, string Telephone, string Fax, string Mobile, string Email, string QQ, string ServiceTelephone, string MD5Key, short Type, long ParentID, string DomainName, long OperatorID, long CommendID, ref long ID, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_CpsAdd", ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("OwnerUserID", SqlDbType.BigInt, 0, ParameterDirection.Input, OwnerUserID),
                new MSSQL.Parameter("Name", SqlDbType.VarChar, 0, ParameterDirection.Input, Name),
                new MSSQL.Parameter("Url", SqlDbType.VarChar, 0, ParameterDirection.Input, Url),
                new MSSQL.Parameter("LogoUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, LogoUrl),
                new MSSQL.Parameter("BonusScale", SqlDbType.Float, 0, ParameterDirection.Input, BonusScale),
                new MSSQL.Parameter("ON", SqlDbType.Bit, 0, ParameterDirection.Input, ON),
                new MSSQL.Parameter("Company", SqlDbType.VarChar, 0, ParameterDirection.Input, Company),
                new MSSQL.Parameter("Address", SqlDbType.VarChar, 0, ParameterDirection.Input, Address),
                new MSSQL.Parameter("PostCode", SqlDbType.VarChar, 0, ParameterDirection.Input, PostCode),
                new MSSQL.Parameter("ResponsiblePerson", SqlDbType.VarChar, 0, ParameterDirection.Input, ResponsiblePerson),
                new MSSQL.Parameter("ContactPerson", SqlDbType.VarChar, 0, ParameterDirection.Input, ContactPerson),
                new MSSQL.Parameter("Telephone", SqlDbType.VarChar, 0, ParameterDirection.Input, Telephone),
                new MSSQL.Parameter("Fax", SqlDbType.VarChar, 0, ParameterDirection.Input, Fax),
                new MSSQL.Parameter("Mobile", SqlDbType.VarChar, 0, ParameterDirection.Input, Mobile),
                new MSSQL.Parameter("Email", SqlDbType.VarChar, 0, ParameterDirection.Input, Email),
                new MSSQL.Parameter("QQ", SqlDbType.VarChar, 0, ParameterDirection.Input, QQ),
                new MSSQL.Parameter("ServiceTelephone", SqlDbType.VarChar, 0, ParameterDirection.Input, ServiceTelephone),
                new MSSQL.Parameter("MD5Key", SqlDbType.VarChar, 0, ParameterDirection.Input, MD5Key),
                new MSSQL.Parameter("Type", SqlDbType.SmallInt, 0, ParameterDirection.Input, Type),
                new MSSQL.Parameter("ParentID", SqlDbType.BigInt, 0, ParameterDirection.Input, ParentID),
                new MSSQL.Parameter("DomainName", SqlDbType.VarChar, 0, ParameterDirection.Input, DomainName),
                new MSSQL.Parameter("OperatorID", SqlDbType.BigInt, 0, ParameterDirection.Input, OperatorID),
                new MSSQL.Parameter("CommendID", SqlDbType.BigInt, 0, ParameterDirection.Input, CommendID),
                new MSSQL.Parameter("ID", SqlDbType.BigInt, 8, ParameterDirection.Output, ID),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ID = System.Convert.ToInt64(Outputs["ID"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #8
0
        public static int P_CompensationRateAdd(string ConnectionString, ref DataSet ds, long OkoooMatchID, string Day, string MatchNumber, ref int RetrunValue, ref string ReturnDescption)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CompensationRateAdd", ref ds, ref Outputs,
                new MSSQL.Parameter("OkoooMatchID", SqlDbType.BigInt, 0, ParameterDirection.Input, OkoooMatchID),
                new MSSQL.Parameter("Day", SqlDbType.VarChar, 0, ParameterDirection.Input, Day),
                new MSSQL.Parameter("MatchNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, MatchNumber),
                new MSSQL.Parameter("RetrunValue", SqlDbType.Int, 4, ParameterDirection.Output, RetrunValue),
                new MSSQL.Parameter("ReturnDescption", SqlDbType.NVarChar, 100, ParameterDirection.Output, ReturnDescption)
                );

            try
            {
                RetrunValue = System.Convert.ToInt32(Outputs["RetrunValue"]);
            }
            catch { }

            try
            {
                ReturnDescption = System.Convert.ToString(Outputs["ReturnDescption"]);
            }
            catch { }

            return CallResult;
        }
Пример #9
0
        public static int P_CardPasswordAgentAddMoney(string ConnectionString, ref DataSet ds, long AgentID, double Amount, string Memo, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CardPasswordAgentAddMoney", ref ds, ref Outputs,
                new MSSQL.Parameter("AgentID", SqlDbType.BigInt, 0, ParameterDirection.Input, AgentID),
                new MSSQL.Parameter("Amount", SqlDbType.Money, 0, ParameterDirection.Input, Amount),
                new MSSQL.Parameter("Memo", SqlDbType.VarChar, 0, ParameterDirection.Input, Memo),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #10
0
        public static int P_CalculateUserLevel(string ConnectionString, ref DataSet ds)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CalculateUserLevel", ref ds, ref Outputs);

            return CallResult;
        }
Пример #11
0
        public static int P_Bqcgg(string ConnectionString, ref DataSet ds, string MatchNumber, string Game, string MainTeam, string GuestTeam, DateTime MatchDate, DateTime stopselltime, double SS, double SP, double SF, double PS, double PP, double PF, double FS, double FP, double FF, ref int ReturnValue, ref string ReturnDescption)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_Bqcgg", ref ds, ref Outputs,
                new MSSQL.Parameter("MatchNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, MatchNumber),
                new MSSQL.Parameter("Game", SqlDbType.VarChar, 0, ParameterDirection.Input, Game),
                new MSSQL.Parameter("MainTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, MainTeam),
                new MSSQL.Parameter("GuestTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, GuestTeam),
                new MSSQL.Parameter("MatchDate", SqlDbType.DateTime, 0, ParameterDirection.Input, MatchDate),
                new MSSQL.Parameter("stopselltime", SqlDbType.DateTime, 0, ParameterDirection.Input, stopselltime),
                new MSSQL.Parameter("SS", SqlDbType.Float, 0, ParameterDirection.Input, SS),
                new MSSQL.Parameter("SP", SqlDbType.Float, 0, ParameterDirection.Input, SP),
                new MSSQL.Parameter("SF", SqlDbType.Float, 0, ParameterDirection.Input, SF),
                new MSSQL.Parameter("PS", SqlDbType.Float, 0, ParameterDirection.Input, PS),
                new MSSQL.Parameter("PP", SqlDbType.Float, 0, ParameterDirection.Input, PP),
                new MSSQL.Parameter("PF", SqlDbType.Float, 0, ParameterDirection.Input, PF),
                new MSSQL.Parameter("FS", SqlDbType.Float, 0, ParameterDirection.Input, FS),
                new MSSQL.Parameter("FP", SqlDbType.Float, 0, ParameterDirection.Input, FP),
                new MSSQL.Parameter("FF", SqlDbType.Float, 0, ParameterDirection.Input, FF),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescption", SqlDbType.NVarChar, 100, ParameterDirection.Output, ReturnDescption)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescption = System.Convert.ToString(Outputs["ReturnDescption"]);
            }
            catch { }

            return CallResult;
        }
Пример #12
0
        public static int P_Bfgg(string ConnectionString, ref DataSet ds, string MatchNumber, string Game, string MainTeam, string GuestTeam, DateTime MatchDate, DateTime stopselltime, double S1_0, double S2_0, double S2_1, double S3_0, double S3_1, double S3_2, double S4_0, double S4_1, double S4_2, double S5_0, double S5_1, double S5_2, double SOther, double P0_0, double P1_1, double P2_2, double P3_3, double POther, double F0_1, double F0_2, double F1_2, double F0_3, double F1_3, double F2_3, double F0_4, double F1_4, double F2_4, double F0_5, double F1_5, double F2_5, double FOther, ref int ReturnValue, ref string ReturnDescption)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_Bfgg", ref ds, ref Outputs,
                new MSSQL.Parameter("MatchNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, MatchNumber),
                new MSSQL.Parameter("Game", SqlDbType.VarChar, 0, ParameterDirection.Input, Game),
                new MSSQL.Parameter("MainTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, MainTeam),
                new MSSQL.Parameter("GuestTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, GuestTeam),
                new MSSQL.Parameter("MatchDate", SqlDbType.DateTime, 0, ParameterDirection.Input, MatchDate),
                new MSSQL.Parameter("stopselltime", SqlDbType.DateTime, 0, ParameterDirection.Input, stopselltime),
                new MSSQL.Parameter("S1_0", SqlDbType.Float, 0, ParameterDirection.Input, S1_0),
                new MSSQL.Parameter("S2_0", SqlDbType.Float, 0, ParameterDirection.Input, S2_0),
                new MSSQL.Parameter("S2_1", SqlDbType.Float, 0, ParameterDirection.Input, S2_1),
                new MSSQL.Parameter("S3_0", SqlDbType.Float, 0, ParameterDirection.Input, S3_0),
                new MSSQL.Parameter("S3_1", SqlDbType.Float, 0, ParameterDirection.Input, S3_1),
                new MSSQL.Parameter("S3_2", SqlDbType.Float, 0, ParameterDirection.Input, S3_2),
                new MSSQL.Parameter("S4_0", SqlDbType.Float, 0, ParameterDirection.Input, S4_0),
                new MSSQL.Parameter("S4_1", SqlDbType.Float, 0, ParameterDirection.Input, S4_1),
                new MSSQL.Parameter("S4_2", SqlDbType.Float, 0, ParameterDirection.Input, S4_2),
                new MSSQL.Parameter("S5_0", SqlDbType.Float, 0, ParameterDirection.Input, S5_0),
                new MSSQL.Parameter("S5_1", SqlDbType.Float, 0, ParameterDirection.Input, S5_1),
                new MSSQL.Parameter("S5_2", SqlDbType.Float, 0, ParameterDirection.Input, S5_2),
                new MSSQL.Parameter("SOther", SqlDbType.Float, 0, ParameterDirection.Input, SOther),
                new MSSQL.Parameter("P0_0", SqlDbType.Float, 0, ParameterDirection.Input, P0_0),
                new MSSQL.Parameter("P1_1", SqlDbType.Float, 0, ParameterDirection.Input, P1_1),
                new MSSQL.Parameter("P2_2", SqlDbType.Float, 0, ParameterDirection.Input, P2_2),
                new MSSQL.Parameter("P3_3", SqlDbType.Float, 0, ParameterDirection.Input, P3_3),
                new MSSQL.Parameter("POther", SqlDbType.Float, 0, ParameterDirection.Input, POther),
                new MSSQL.Parameter("F0_1", SqlDbType.Float, 0, ParameterDirection.Input, F0_1),
                new MSSQL.Parameter("F0_2", SqlDbType.Float, 0, ParameterDirection.Input, F0_2),
                new MSSQL.Parameter("F1_2", SqlDbType.Float, 0, ParameterDirection.Input, F1_2),
                new MSSQL.Parameter("F0_3", SqlDbType.Float, 0, ParameterDirection.Input, F0_3),
                new MSSQL.Parameter("F1_3", SqlDbType.Float, 0, ParameterDirection.Input, F1_3),
                new MSSQL.Parameter("F2_3", SqlDbType.Float, 0, ParameterDirection.Input, F2_3),
                new MSSQL.Parameter("F0_4", SqlDbType.Float, 0, ParameterDirection.Input, F0_4),
                new MSSQL.Parameter("F1_4", SqlDbType.Float, 0, ParameterDirection.Input, F1_4),
                new MSSQL.Parameter("F2_4", SqlDbType.Float, 0, ParameterDirection.Input, F2_4),
                new MSSQL.Parameter("F0_5", SqlDbType.Float, 0, ParameterDirection.Input, F0_5),
                new MSSQL.Parameter("F1_5", SqlDbType.Float, 0, ParameterDirection.Input, F1_5),
                new MSSQL.Parameter("F2_5", SqlDbType.Float, 0, ParameterDirection.Input, F2_5),
                new MSSQL.Parameter("FOther", SqlDbType.Float, 0, ParameterDirection.Input, FOther),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescption", SqlDbType.NVarChar, 100, ParameterDirection.Output, ReturnDescption)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescption = System.Convert.ToString(Outputs["ReturnDescption"]);
            }
            catch { }

            return CallResult;
        }
Пример #13
0
        public static int P_BasketSfgg(string ConnectionString, ref DataSet ds, string MainTeam, string GuestTeam, string MatchNumber, string Game, DateTime MatchDate, DateTime StopSellTime, double MainWin, double Mainlose, ref int ReturnValue, ref string ReturnDescption)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_BasketSfgg", ref ds, ref Outputs,
                new MSSQL.Parameter("MainTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, MainTeam),
                new MSSQL.Parameter("GuestTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, GuestTeam),
                new MSSQL.Parameter("MatchNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, MatchNumber),
                new MSSQL.Parameter("Game", SqlDbType.VarChar, 0, ParameterDirection.Input, Game),
                new MSSQL.Parameter("MatchDate", SqlDbType.DateTime, 0, ParameterDirection.Input, MatchDate),
                new MSSQL.Parameter("StopSellTime", SqlDbType.DateTime, 0, ParameterDirection.Input, StopSellTime),
                new MSSQL.Parameter("MainWin", SqlDbType.Float, 0, ParameterDirection.Input, MainWin),
                new MSSQL.Parameter("Mainlose", SqlDbType.Float, 0, ParameterDirection.Input, Mainlose),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescption", SqlDbType.NVarChar, 100, ParameterDirection.Output, ReturnDescption)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescption = System.Convert.ToString(Outputs["ReturnDescption"]);
            }
            catch { }

            return CallResult;
        }
Пример #14
0
        public static int P_BasketSfcgg(string ConnectionString, string MainTeam, string GuestTeam, string MatchNumber, string Game, DateTime MatchDate, DateTime StopSellTime, double DifferGuest1_5, double DifferGuest6_10, double DifferGuest11_15, double DifferGuest16_20, double DifferGuest21_25, double DifferGuest26, double DifferMain1_5, double DifferMain6_10, double DifferMain11_15, double DifferMain16_20, double DifferMain21_25, double DifferMain26, ref int ReturnValue, ref string ReturnDescption)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_BasketSfcgg", ref Outputs,
                new MSSQL.Parameter("MainTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, MainTeam),
                new MSSQL.Parameter("GuestTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, GuestTeam),
                new MSSQL.Parameter("MatchNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, MatchNumber),
                new MSSQL.Parameter("Game", SqlDbType.VarChar, 0, ParameterDirection.Input, Game),
                new MSSQL.Parameter("MatchDate", SqlDbType.DateTime, 0, ParameterDirection.Input, MatchDate),
                new MSSQL.Parameter("StopSellTime", SqlDbType.DateTime, 0, ParameterDirection.Input, StopSellTime),
                new MSSQL.Parameter("DifferGuest1_5", SqlDbType.Float, 0, ParameterDirection.Input, DifferGuest1_5),
                new MSSQL.Parameter("DifferGuest6_10", SqlDbType.Float, 0, ParameterDirection.Input, DifferGuest6_10),
                new MSSQL.Parameter("DifferGuest11_15", SqlDbType.Float, 0, ParameterDirection.Input, DifferGuest11_15),
                new MSSQL.Parameter("DifferGuest16_20", SqlDbType.Float, 0, ParameterDirection.Input, DifferGuest16_20),
                new MSSQL.Parameter("DifferGuest21_25", SqlDbType.Float, 0, ParameterDirection.Input, DifferGuest21_25),
                new MSSQL.Parameter("DifferGuest26", SqlDbType.Float, 0, ParameterDirection.Input, DifferGuest26),
                new MSSQL.Parameter("DifferMain1_5", SqlDbType.Float, 0, ParameterDirection.Input, DifferMain1_5),
                new MSSQL.Parameter("DifferMain6_10", SqlDbType.Float, 0, ParameterDirection.Input, DifferMain6_10),
                new MSSQL.Parameter("DifferMain11_15", SqlDbType.Float, 0, ParameterDirection.Input, DifferMain11_15),
                new MSSQL.Parameter("DifferMain16_20", SqlDbType.Float, 0, ParameterDirection.Input, DifferMain16_20),
                new MSSQL.Parameter("DifferMain21_25", SqlDbType.Float, 0, ParameterDirection.Input, DifferMain21_25),
                new MSSQL.Parameter("DifferMain26", SqlDbType.Float, 0, ParameterDirection.Input, DifferMain26),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescption", SqlDbType.NVarChar, 100, ParameterDirection.Output, ReturnDescption)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescption = System.Convert.ToString(Outputs["ReturnDescption"]);
            }
            catch { }

            return CallResult;
        }
Пример #15
0
        public static int P_BasketDXFdg(string ConnectionString, string MainTeam, string GuestTeam, string MatchNumber, string Game, DateTime MatchDate, DateTime StopSellTime, double Big, double Small, double BigSmallscore, ref int RetrunValue, ref string ReturnDescption)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_BasketDXFdg", ref Outputs,
                new MSSQL.Parameter("MainTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, MainTeam),
                new MSSQL.Parameter("GuestTeam", SqlDbType.VarChar, 0, ParameterDirection.Input, GuestTeam),
                new MSSQL.Parameter("MatchNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, MatchNumber),
                new MSSQL.Parameter("Game", SqlDbType.VarChar, 0, ParameterDirection.Input, Game),
                new MSSQL.Parameter("MatchDate", SqlDbType.DateTime, 0, ParameterDirection.Input, MatchDate),
                new MSSQL.Parameter("StopSellTime", SqlDbType.DateTime, 0, ParameterDirection.Input, StopSellTime),
                new MSSQL.Parameter("Big", SqlDbType.Float, 0, ParameterDirection.Input, Big),
                new MSSQL.Parameter("Small", SqlDbType.Float, 0, ParameterDirection.Input, Small),
                new MSSQL.Parameter("BigSmallscore", SqlDbType.Float, 0, ParameterDirection.Input, BigSmallscore),
                new MSSQL.Parameter("RetrunValue", SqlDbType.Int, 4, ParameterDirection.Output, RetrunValue),
                new MSSQL.Parameter("ReturnDescption", SqlDbType.NVarChar, 100, ParameterDirection.Output, ReturnDescption)
                );

            try
            {
                RetrunValue = System.Convert.ToInt32(Outputs["RetrunValue"]);
            }
            catch { }

            try
            {
                ReturnDescption = System.Convert.ToString(Outputs["ReturnDescption"]);
            }
            catch { }

            return CallResult;
        }
Пример #16
0
        public static int P_ChaseTaskStopWhenWin(string ConnectionString, ref DataSet ds, long SiteID, long SchemeID, double WinMoney, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_ChaseTaskStopWhenWin", ref ds, ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("SchemeID", SqlDbType.BigInt, 0, ParameterDirection.Input, SchemeID),
                new MSSQL.Parameter("WinMoney", SqlDbType.Money, 0, ParameterDirection.Input, WinMoney),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #17
0
        public static int P_ClearSystemLog(string ConnectionString, long SiteID, long UserID, string IPAddress, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_ClearSystemLog", ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID),
                new MSSQL.Parameter("IPAddress", SqlDbType.VarChar, 0, ParameterDirection.Input, IPAddress),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #18
0
        public static int P_CardPasswordGet(string ConnectionString, ref DataSet ds, int AgentID, long CardPasswordID, ref DateTime DateTime, ref DateTime Period, ref double Money, ref short State, ref long UserID, ref DateTime UseDateTime, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CardPasswordGet", ref ds, ref Outputs,
                new MSSQL.Parameter("AgentID", SqlDbType.Int, 0, ParameterDirection.Input, AgentID),
                new MSSQL.Parameter("CardPasswordID", SqlDbType.BigInt, 0, ParameterDirection.Input, CardPasswordID),
                new MSSQL.Parameter("DateTime", SqlDbType.DateTime, 8, ParameterDirection.Output, DateTime),
                new MSSQL.Parameter("Period", SqlDbType.DateTime, 8, ParameterDirection.Output, Period),
                new MSSQL.Parameter("Money", SqlDbType.Money, 8, ParameterDirection.Output, Money),
                new MSSQL.Parameter("State", SqlDbType.SmallInt, 2, ParameterDirection.Output, State),
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 8, ParameterDirection.Output, UserID),
                new MSSQL.Parameter("UseDateTime", SqlDbType.DateTime, 8, ParameterDirection.Output, UseDateTime),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                DateTime = System.Convert.ToDateTime(Outputs["DateTime"]);
            }
            catch { }

            try
            {
                Period = System.Convert.ToDateTime(Outputs["Period"]);
            }
            catch { }

            try
            {
                Money = System.Convert.ToDouble(Outputs["Money"]);
            }
            catch { }

            try
            {
                State = System.Convert.ToInt16(Outputs["State"]);
            }
            catch { }

            try
            {
                UserID = System.Convert.ToInt64(Outputs["UserID"]);
            }
            catch { }

            try
            {
                UseDateTime = System.Convert.ToDateTime(Outputs["UseDateTime"]);
            }
            catch { }

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #19
0
        public static int P_CompensationRateEdit(string ConnectionString, ref DataSet ds, long OkoooMatchID, string Day, string MatchNumber, double Average99_S, double Average99_P, double Average99_F, double Willhill_S, double Willhill_P, double Willhill_F, double Lad_S, double Lad_P, double Lad_F, double Bet365_S, double Bet365_P, double Bet365_F, double Macau_S, double Macau_P, double Macau_F, ref int RetrunValue, ref string ReturnDescption)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CompensationRateEdit", ref ds, ref Outputs,
                new MSSQL.Parameter("OkoooMatchID", SqlDbType.BigInt, 0, ParameterDirection.Input, OkoooMatchID),
                new MSSQL.Parameter("Day", SqlDbType.VarChar, 0, ParameterDirection.Input, Day),
                new MSSQL.Parameter("MatchNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, MatchNumber),
                new MSSQL.Parameter("Average99_S", SqlDbType.Float, 0, ParameterDirection.Input, Average99_S),
                new MSSQL.Parameter("Average99_P", SqlDbType.Float, 0, ParameterDirection.Input, Average99_P),
                new MSSQL.Parameter("Average99_F", SqlDbType.Float, 0, ParameterDirection.Input, Average99_F),
                new MSSQL.Parameter("Willhill_S", SqlDbType.Float, 0, ParameterDirection.Input, Willhill_S),
                new MSSQL.Parameter("Willhill_P", SqlDbType.Float, 0, ParameterDirection.Input, Willhill_P),
                new MSSQL.Parameter("Willhill_F", SqlDbType.Float, 0, ParameterDirection.Input, Willhill_F),
                new MSSQL.Parameter("Lad_S", SqlDbType.Float, 0, ParameterDirection.Input, Lad_S),
                new MSSQL.Parameter("Lad_P", SqlDbType.Float, 0, ParameterDirection.Input, Lad_P),
                new MSSQL.Parameter("Lad_F", SqlDbType.Float, 0, ParameterDirection.Input, Lad_F),
                new MSSQL.Parameter("Bet365_S", SqlDbType.Float, 0, ParameterDirection.Input, Bet365_S),
                new MSSQL.Parameter("Bet365_P", SqlDbType.Float, 0, ParameterDirection.Input, Bet365_P),
                new MSSQL.Parameter("Bet365_F", SqlDbType.Float, 0, ParameterDirection.Input, Bet365_F),
                new MSSQL.Parameter("Macau_S", SqlDbType.Float, 0, ParameterDirection.Input, Macau_S),
                new MSSQL.Parameter("Macau_P", SqlDbType.Float, 0, ParameterDirection.Input, Macau_P),
                new MSSQL.Parameter("Macau_F", SqlDbType.Float, 0, ParameterDirection.Input, Macau_F),
                new MSSQL.Parameter("RetrunValue", SqlDbType.Int, 4, ParameterDirection.Output, RetrunValue),
                new MSSQL.Parameter("ReturnDescption", SqlDbType.NVarChar, 100, ParameterDirection.Output, ReturnDescption)
                );

            try
            {
                RetrunValue = System.Convert.ToInt32(Outputs["RetrunValue"]);
            }
            catch { }

            try
            {
                ReturnDescption = System.Convert.ToString(Outputs["ReturnDescption"]);
            }
            catch { }

            return CallResult;
        }
Пример #20
0
        public static int P_CardPasswordSetPeriod(string ConnectionString, int AgentID, long CardPasswordID, DateTime Period, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_CardPasswordSetPeriod", ref Outputs,
                new MSSQL.Parameter("AgentID", SqlDbType.Int, 0, ParameterDirection.Input, AgentID),
                new MSSQL.Parameter("CardPasswordID", SqlDbType.BigInt, 0, ParameterDirection.Input, CardPasswordID),
                new MSSQL.Parameter("Period", SqlDbType.DateTime, 0, ParameterDirection.Input, Period),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #21
0
        public static int P_CpsCalculateBonus(string ConnectionString, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_CpsCalculateBonus", ref Outputs,
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #22
0
        public static int P_CardPasswordUse(string ConnectionString, ref DataSet ds, int AgentID, long CardPasswordID, string Number, long SiteID, long UserID, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CardPasswordUse", ref ds, ref Outputs,
                new MSSQL.Parameter("AgentID", SqlDbType.Int, 0, ParameterDirection.Input, AgentID),
                new MSSQL.Parameter("CardPasswordID", SqlDbType.BigInt, 0, ParameterDirection.Input, CardPasswordID),
                new MSSQL.Parameter("Number", SqlDbType.VarChar, 0, ParameterDirection.Input, Number),
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #23
0
        public static int P_CpsDistillNoAccept(string ConnectionString, long SiteID, long UserID, long DistillID, string Memo, long HandleOperatorID, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureNonQuery(ConnectionString, "P_CpsDistillNoAccept", ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID),
                new MSSQL.Parameter("DistillID", SqlDbType.BigInt, 0, ParameterDirection.Input, DistillID),
                new MSSQL.Parameter("Memo", SqlDbType.VarChar, 0, ParameterDirection.Input, Memo),
                new MSSQL.Parameter("HandleOperatorID", SqlDbType.BigInt, 0, ParameterDirection.Input, HandleOperatorID),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #24
0
        public static int P_CelebEdit(string ConnectionString, ref DataSet ds, long SiteID, long ID, string Title, string Intro, string Say, string Comment, string Score, long Order, bool isRecommended, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CelebEdit", ref ds, ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("ID", SqlDbType.BigInt, 0, ParameterDirection.Input, ID),
                new MSSQL.Parameter("Title", SqlDbType.VarChar, 0, ParameterDirection.Input, Title),
                new MSSQL.Parameter("Intro", SqlDbType.VarChar, 0, ParameterDirection.Input, Intro),
                new MSSQL.Parameter("Say", SqlDbType.VarChar, 0, ParameterDirection.Input, Say),
                new MSSQL.Parameter("Comment", SqlDbType.VarChar, 0, ParameterDirection.Input, Comment),
                new MSSQL.Parameter("Score", SqlDbType.VarChar, 0, ParameterDirection.Input, Score),
                new MSSQL.Parameter("Order", SqlDbType.BigInt, 0, ParameterDirection.Input, Order),
                new MSSQL.Parameter("isRecommended", SqlDbType.Bit, 0, ParameterDirection.Input, isRecommended),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #25
0
        public static int P_CpsEdit(string ConnectionString, ref DataSet ds, long SiteID, long CpsID, string UrlName, string Url, string LogoUrl, double BonusScale, bool ON, string Company, string Address, string PostCode, string ResponsiblePerson, string ContactPerson, string Telephone, string Fax, string Mobile, string Email, string QQ, string ServiceTelephone, string MD5Key, short Type, string DomainName, bool IsShow, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CpsEdit", ref ds, ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("CpsID", SqlDbType.BigInt, 0, ParameterDirection.Input, CpsID),
                new MSSQL.Parameter("UrlName", SqlDbType.VarChar, 0, ParameterDirection.Input, UrlName),
                new MSSQL.Parameter("Url", SqlDbType.VarChar, 0, ParameterDirection.Input, Url),
                new MSSQL.Parameter("LogoUrl", SqlDbType.VarChar, 0, ParameterDirection.Input, LogoUrl),
                new MSSQL.Parameter("BonusScale", SqlDbType.Float, 0, ParameterDirection.Input, BonusScale),
                new MSSQL.Parameter("ON", SqlDbType.Bit, 0, ParameterDirection.Input, ON),
                new MSSQL.Parameter("Company", SqlDbType.VarChar, 0, ParameterDirection.Input, Company),
                new MSSQL.Parameter("Address", SqlDbType.VarChar, 0, ParameterDirection.Input, Address),
                new MSSQL.Parameter("PostCode", SqlDbType.VarChar, 0, ParameterDirection.Input, PostCode),
                new MSSQL.Parameter("ResponsiblePerson", SqlDbType.VarChar, 0, ParameterDirection.Input, ResponsiblePerson),
                new MSSQL.Parameter("ContactPerson", SqlDbType.VarChar, 0, ParameterDirection.Input, ContactPerson),
                new MSSQL.Parameter("Telephone", SqlDbType.VarChar, 0, ParameterDirection.Input, Telephone),
                new MSSQL.Parameter("Fax", SqlDbType.VarChar, 0, ParameterDirection.Input, Fax),
                new MSSQL.Parameter("Mobile", SqlDbType.VarChar, 0, ParameterDirection.Input, Mobile),
                new MSSQL.Parameter("Email", SqlDbType.VarChar, 0, ParameterDirection.Input, Email),
                new MSSQL.Parameter("QQ", SqlDbType.VarChar, 0, ParameterDirection.Input, QQ),
                new MSSQL.Parameter("ServiceTelephone", SqlDbType.VarChar, 0, ParameterDirection.Input, ServiceTelephone),
                new MSSQL.Parameter("MD5Key", SqlDbType.VarChar, 0, ParameterDirection.Input, MD5Key),
                new MSSQL.Parameter("Type", SqlDbType.SmallInt, 0, ParameterDirection.Input, Type),
                new MSSQL.Parameter("DomainName", SqlDbType.VarChar, 0, ParameterDirection.Input, DomainName),
                new MSSQL.Parameter("IsShow", SqlDbType.Bit, 0, ParameterDirection.Input, IsShow),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #26
0
        public static int P_ChallengeBetRedAdd(string ConnectionString, ref DataSet ds, long UserID)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_ChallengeBetRedAdd", ref ds, ref Outputs,
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID)
                );

            return CallResult;
        }
Пример #27
0
        public static int P_CpsGetCommendSiteBuyDetail(string ConnectionString, ref DataSet ds, long SiteID, long CommenderID, long CpsID, long MemberID, DateTime FromTime, DateTime ToTime, ref int ReturnValue, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_CpsGetCommendSiteBuyDetail", ref ds, ref Outputs,
                new MSSQL.Parameter("SiteID", SqlDbType.BigInt, 0, ParameterDirection.Input, SiteID),
                new MSSQL.Parameter("CommenderID", SqlDbType.BigInt, 0, ParameterDirection.Input, CommenderID),
                new MSSQL.Parameter("CpsID", SqlDbType.BigInt, 0, ParameterDirection.Input, CpsID),
                new MSSQL.Parameter("MemberID", SqlDbType.BigInt, 0, ParameterDirection.Input, MemberID),
                new MSSQL.Parameter("FromTime", SqlDbType.DateTime, 0, ParameterDirection.Input, FromTime),
                new MSSQL.Parameter("ToTime", SqlDbType.DateTime, 0, ParameterDirection.Input, ToTime),
                new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }
Пример #28
0
        public static int P_ChallengeHotBetAdd(string ConnectionString, ref DataSet ds, long MatchID, long WinCount, long DrawCount, long LostCount)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_ChallengeHotBetAdd", ref ds, ref Outputs,
                new MSSQL.Parameter("MatchID", SqlDbType.BigInt, 0, ParameterDirection.Input, MatchID),
                new MSSQL.Parameter("WinCount", SqlDbType.BigInt, 0, ParameterDirection.Input, WinCount),
                new MSSQL.Parameter("DrawCount", SqlDbType.BigInt, 0, ParameterDirection.Input, DrawCount),
                new MSSQL.Parameter("LostCount", SqlDbType.BigInt, 0, ParameterDirection.Input, LostCount)
                );

            return CallResult;
        }
Пример #29
0
    private int P_Win(SqlConnection conn, ref DataSet ds, long IsuseID, string WinLotteryNumber, string OpenAffiche, long OpenOperatorID, bool isEndTheIsuse, ref int SchemeCount, ref int QuashCount, ref int WinCount, ref int WinNoBuyCount, ref bool isEndOpen, ref int ReturnValue, ref string ReturnDescription)
    {
        MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

        int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(conn, "P_Win", ref ds, ref Outputs,
            new MSSQL.Parameter("IsuseID", SqlDbType.BigInt, 0, ParameterDirection.Input, IsuseID),
            new MSSQL.Parameter("WinLotteryNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, WinLotteryNumber),
            new MSSQL.Parameter("OpenAffiche", SqlDbType.VarChar, 0, ParameterDirection.Input, OpenAffiche),
            new MSSQL.Parameter("OpenOperatorID", SqlDbType.BigInt, 0, ParameterDirection.Input, OpenOperatorID),
            new MSSQL.Parameter("isEndTheIsuse", SqlDbType.Bit, 0, ParameterDirection.Input, isEndTheIsuse),
            new MSSQL.Parameter("SchemeCount", SqlDbType.Int, 4, ParameterDirection.Output, SchemeCount),
            new MSSQL.Parameter("QuashCount", SqlDbType.Int, 4, ParameterDirection.Output, QuashCount),
            new MSSQL.Parameter("WinCount", SqlDbType.Int, 4, ParameterDirection.Output, WinCount),
            new MSSQL.Parameter("WinNoBuyCount", SqlDbType.Int, 4, ParameterDirection.Output, WinNoBuyCount),
            new MSSQL.Parameter("isEndOpen", SqlDbType.Bit, 0, ParameterDirection.Output, isEndOpen),
            new MSSQL.Parameter("ReturnValue", SqlDbType.Int, 4, ParameterDirection.Output, ReturnValue),
            new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 100, ParameterDirection.Output, ReturnDescription)
            );

        try
        {
            SchemeCount = System.Convert.ToInt32(Outputs["SchemeCount"]);
        }
        catch { }

        try
        {
            QuashCount = System.Convert.ToInt32(Outputs["QuashCount"]);
        }
        catch { }

        try
        {
            WinCount = System.Convert.ToInt32(Outputs["WinCount"]);
        }
        catch { }

        try
        {
            WinNoBuyCount = System.Convert.ToInt32(Outputs["WinNoBuyCount"]);
        }
        catch { }

        try
        {
            isEndOpen = System.Convert.ToBoolean(Outputs["isEndOpen"]);
        }
        catch { }

        try
        {
            ReturnValue = System.Convert.ToInt32(Outputs["ReturnValue"]);
        }
        catch { }

        try
        {
            ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
        }
        catch { }

        return CallResult;
    }
Пример #30
0
        public static int P_ChasesAdd(string ConnectionString, ref DataSet ds, long UserID, int LotteryID, int PlayTypeID, int Price, short Type, DateTime StartTime, DateTime EndTime, int IsuseCount, int Multiple, int Nums, short BetType, string LotteryNumber, short StopTypeWhenWin, double StopTypeWhenMoney, double Money, string Title, string ChaseXML, ref int ChaseID, ref string ReturnDescription)
        {
            MSSQL.OutputParameter Outputs = new MSSQL.OutputParameter();

            int CallResult = MSSQL.ExecuteStoredProcedureWithQuery(ConnectionString, "P_ChasesAdd", ref ds, ref Outputs,
                new MSSQL.Parameter("UserID", SqlDbType.BigInt, 0, ParameterDirection.Input, UserID),
                new MSSQL.Parameter("LotteryID", SqlDbType.Int, 0, ParameterDirection.Input, LotteryID),
                new MSSQL.Parameter("PlayTypeID", SqlDbType.Int, 0, ParameterDirection.Input, PlayTypeID),
                new MSSQL.Parameter("Price", SqlDbType.Int, 0, ParameterDirection.Input, Price),
                new MSSQL.Parameter("Type", SqlDbType.SmallInt, 0, ParameterDirection.Input, Type),
                new MSSQL.Parameter("StartTime", SqlDbType.DateTime, 0, ParameterDirection.Input, StartTime),
                new MSSQL.Parameter("EndTime", SqlDbType.DateTime, 0, ParameterDirection.Input, EndTime),
                new MSSQL.Parameter("IsuseCount", SqlDbType.Int, 0, ParameterDirection.Input, IsuseCount),
                new MSSQL.Parameter("Multiple", SqlDbType.Int, 0, ParameterDirection.Input, Multiple),
                new MSSQL.Parameter("Nums", SqlDbType.Int, 0, ParameterDirection.Input, Nums),
                new MSSQL.Parameter("BetType", SqlDbType.SmallInt, 0, ParameterDirection.Input, BetType),
                new MSSQL.Parameter("LotteryNumber", SqlDbType.VarChar, 0, ParameterDirection.Input, LotteryNumber),
                new MSSQL.Parameter("StopTypeWhenWin", SqlDbType.SmallInt, 0, ParameterDirection.Input, StopTypeWhenWin),
                new MSSQL.Parameter("StopTypeWhenMoney", SqlDbType.Money, 0, ParameterDirection.Input, StopTypeWhenMoney),
                new MSSQL.Parameter("Money", SqlDbType.Money, 0, ParameterDirection.Input, Money),
                new MSSQL.Parameter("Title", SqlDbType.VarChar, 0, ParameterDirection.Input, Title),
                new MSSQL.Parameter("ChaseXML", SqlDbType.VarChar, 0, ParameterDirection.Input, ChaseXML),
                new MSSQL.Parameter("ChaseID", SqlDbType.Int, 4, ParameterDirection.Output, ChaseID),
                new MSSQL.Parameter("ReturnDescription", SqlDbType.VarChar, 50, ParameterDirection.Output, ReturnDescription)
                );

            try
            {
                ChaseID = System.Convert.ToInt32(Outputs["ChaseID"]);
            }
            catch { }

            try
            {
                ReturnDescription = System.Convert.ToString(Outputs["ReturnDescription"]);
            }
            catch { }

            return CallResult;
        }