/// <summary>
/// 增加一条数据
/// </summary>
public int Add(UserHostInfo model)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@siteip", SqlDbType.VarChar, 50),
new SqlParameter("@sitetype", SqlDbType.TinyInt, 1),
new SqlParameter("@hostName", SqlDbType.VarChar, 200),
new SqlParameter("@hostUrl", SqlDbType.VarChar, 255),
new SqlParameter("@desc", SqlDbType.VarChar, 255),
new SqlParameter("@status", SqlDbType.TinyInt)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.userid;
parameters[2].Value = model.siteip;
parameters[3].Value = model.sitetype;
parameters[4].Value = model.hostName;
parameters[5].Value = model.hostUrl;
parameters[6].Value = model.desc;
parameters[7].Value = 1;
DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_userhost_add", parameters);
return((int)parameters[0].Value);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(0);
}
}
/// <summary>
///
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public UserHostInfo GetCacheModel(int id)
{
UserHostInfo model = new UserHostInfo();
string cacheKey = string.Format(CACHE_KEY, id);
model = (UserHostInfo)viviapi.Cache.WebCache.GetCacheService().RetrieveObject(cacheKey);
if (model == null)
{
IDictionary <string, object> sqldepparms = new Dictionary <string, object>();
sqldepparms.Add("id", id);
SqlDependency sqlDep = DataBase.AddSqlDependency(cacheKey, SQL_TABLE, SQL_FIELDS, "[id]=@id", sqldepparms);
model = GetModel(id);
viviapi.Cache.WebCache.GetCacheService().AddObject(cacheKey, model);
}
return(model);
}
/// <summary>
///
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public static UserHostInfo GetModelFromDs(DataSet ds)
{
UserHostInfo model = new UserHostInfo();
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
}
model.siteip = ds.Tables[0].Rows[0]["siteip"].ToString();
if (ds.Tables[0].Rows[0]["sitetype"].ToString() != "")
{
model.sitetype = int.Parse(ds.Tables[0].Rows[0]["sitetype"].ToString());
}
model.hostName = ds.Tables[0].Rows[0]["hostName"].ToString();
model.hostUrl = ds.Tables[0].Rows[0]["hostUrl"].ToString();
model.desc = ds.Tables[0].Rows[0]["desc"].ToString();
if (ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = (UserHostStatus)int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
else
{
model.status = UserHostStatus.未知;
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Update(UserHostInfo model)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@siteip", SqlDbType.VarChar, 50),
new SqlParameter("@sitetype", SqlDbType.TinyInt, 1),
new SqlParameter("@hostName", SqlDbType.VarChar, 200),
new SqlParameter("@hostUrl", SqlDbType.VarChar, 255),
new SqlParameter("@desc", SqlDbType.VarChar, 255),
new SqlParameter("@status", SqlDbType.TinyInt)
};
parameters[0].Value = model.id;
parameters[1].Value = model.userid;
parameters[2].Value = model.siteip;
parameters[3].Value = model.sitetype;
parameters[4].Value = model.hostName;
parameters[5].Value = model.hostUrl;
parameters[6].Value = model.desc;
parameters[7].Value = (int)model.status;
bool success = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_userhost_update", parameters) > 0;
if (success)
{
ClearCache(model.id);
}
return(success);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(ex);
return(false);
}
}
