/// <summary>
/// 更新云秒杀记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateDsYmsUser(DsYmsUserModel model)
{
string sql = "update selfstock.DS_YMS_USER set showname=:showname,lastresults=:lastresults,sort=:sort where username=:username";
var commandParameters = new[]
{
new OracleParameter(":showname", OracleDbType.Varchar2),
new OracleParameter(":lastresults", OracleDbType.Decimal),
new OracleParameter(":sort", OracleDbType.Int32),
new OracleParameter(":username", OracleDbType.Varchar2)
};
commandParameters[0].Value = model.ShowName;
commandParameters[1].Value = model.LastResults;
commandParameters[2].Value = model.Sort;
commandParameters[3].Value = model.UserName;
return OracleDataAccess.ExecuteNonQuery(OracleDataAccess.OracleConnectionUpdbString, CommandType.Text, sql, commandParameters);
}
/// <summary>
/// 删除云秒杀记录
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public int DeleteDsYmsUser(string UserName)
{
try
{
string sql = "DELETE FROM selfstock.DS_YMS_USER WHERE USERNAME=:USERNAME";
var commandParameters = new[]
{
new OracleParameter(":USERNAME", OracleDbType.Varchar2)
};
commandParameters[0].Value = UserName;
return OracleDataAccess.ExecuteNonQuery(OracleDataAccess.OracleConnectionUpdbString, CommandType.Text, sql, commandParameters);
}
catch (OracleException ce)
{
Loger.Error(ce);
}
return 0;
}
/// <summary>
/// 插入云秒杀记录
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertDsYmsUser(DsYmsUserModel model)
{
string sql = "INSERT INTO selfstock.DS_YMS_USER (username,showname,lastresults,sort,package)";
sql += " VALUES(:username,:showname,:lastresults,:sort,:package)";
var commandParameters = new[]
{
new OracleParameter(":username", OracleDbType.Varchar2),
new OracleParameter(":showname", OracleDbType.Varchar2),
new OracleParameter(":lastresults", OracleDbType.Decimal),
new OracleParameter(":sort", OracleDbType.Int32),
new OracleParameter(":package", OracleDbType.Varchar2)
};
commandParameters[0].Value = model.UserName;
commandParameters[1].Value = model.ShowName;
commandParameters[2].Value = model.LastResults;
commandParameters[3].Value = model.Sort;
commandParameters[4].Value = model.Package.ToLower();
return OracleDataAccess.ExecuteNonQuery(OracleDataAccess.OracleConnectionUpdbString, CommandType.Text, sql, commandParameters);
}