/// <summary>
/// 添加数据
/// </summary>
/// <param name="userID"></param>
/// <param name="phone"></param>
/// <param name="code"></param>
/// <returns></returns>
public Message RegisterUser(long userID, string phone, string code)
{
try
{
#region 第一种参数传递
//MySqlParameter[] parameters = {
// new MySqlParameter("@UserID", userID),
// new MySqlParameter("@Phone", phone),
// new MySqlParameter("@Code", code)
//};
//parameters[3].Direction = ParameterDirection.Output;
#endregion
#region 第二种参数传递
List<MySqlParameter> paramArray = new List<MySqlParameter>();
paramArray.Add(new MySqlParameter("@UserID", userID));
paramArray.Add(new MySqlParameter("@Phone", phone));
paramArray.Add(new MySqlParameter("@Code", code));
输出参数
//MySqlParameter outStr = new MySqlParameter("@outStr", MySqlDbType.VarChar, 64);
//paramArray.Add(outStr);
//outStr.Direction = ParameterDirection.Output;
存储过程返回的值
//MySqlParameter returnValue = new MySqlParameter("@return_value", MySqlDbType.Int32, 4);
//paramArray.Add(returnValue);
//returnValue.Direction = ParameterDirection.ReturnValue;
#endregion
var result = FruitGameDBHelper.ExecuteProc("p_web_insertUser", paramArray.ToArray());
if (Convert.ToInt32(result) > 0)
{
message.Success = true;
}
else
{
message.Success = false;
}
}
catch (Exception ex)
{
message.Success = false;
message.ReturnString = ex.ToString();
}
return message;
}
/// <summary>
/// 查询列表
/// </summary>
/// <returns></returns>
public DataTable GetList()
{
DataTable table = new DataTable();
try
{
MySqlParameter parameters = new MySqlParameter();
table = FruitGameDBHelper.ProcDataTable("p_web_getList", parameters);
}
catch (Exception ex)
{
message.Success = false;
message.ReturnString = ex.ToString();
}
return table;
}