/// <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); } }