• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# MSSQL.OutputParameter类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中Shove.Database.MSSQL.OutputParameter的典型用法代码示例。如果您正苦于以下问题:C# MSSQL.OutputParameter类的具体用法?C# MSSQL.OutputParameter怎么用?C# MSSQL.OutputParameter使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



MSSQL.OutputParameter类属于Shove.Database命名空间,在下文中一共展示了MSSQL.OutputParameter类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: P_AccountTransferAccept

 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;
 }
开发者ID:NoobSkie,项目名称:taobao-shop-helper,代码行数:20,代码来源:Procedures.cs


示例2: P_AcceptUserHongbaoPromotion

 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;
 }
开发者ID:NoobSkie,项目名称:taobao-shop-helper,代码行数:20,代码来源:Procedures.cs


示例3: P_CpsGetDayBuyDetailByType

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:24,代码来源:DAL.cs


示例4: P_CpsGetCommendMemberList

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:24,代码来源:DAL.cs


示例5: P_CpsDistillQuash

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:26,代码来源:DAL.cs


示例6: P_CpsDistill

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:31,代码来源:DAL.cs


示例7: P_CpsAdd

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:47,代码来源:DAL.cs


示例8: P_CompensationRateAdd

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:26,代码来源:DAL.cs


示例9: P_CardPasswordAgentAddMoney

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:26,代码来源:DAL.cs


示例10: P_CalculateUserLevel

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:8,代码来源:DAL.cs


示例11: P_Bqcgg

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:38,代码来源:DAL.cs


示例12: P_Bfgg

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:60,代码来源:DAL.cs


示例13: P_BasketSfgg

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:31,代码来源:DAL.cs


示例14: P_BasketSfcgg

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:41,代码来源:DAL.cs


示例15: P_BasketDXFdg

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:32,代码来源:DAL.cs


示例16: P_ChaseTaskStopWhenWin

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:26,代码来源:DAL.cs


示例17: P_ClearSystemLog

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:26,代码来源:DAL.cs


示例18: P_CardPasswordGet

        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;
        }
开发者ID:ichari,项目名称:ichari,代码行数:67,代码来源:DAL.cs


示例19: P_CompensationRateEdit

        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,
  

鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# SidejobModel.SidejobEntities类代码示例发布时间:2022-05-26
下一篇:
C# MSSQL.Field类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap