本文整理汇总了C#中Shove.Database.MSSQL.OutputParameter类的典型用法代码示例。如果您正苦于以下问题：C# MSSQL.OutputParameter类的具体用法？C# MSSQL.OutputParameter怎么用？C# MSSQL.OutputParameter使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
MSSQL.OutputParameter类属于Shove.Database命名空间，在下文中一共展示了MSSQL.OutputParameter类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}示例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;
}