/// <summary>
/// Email地址是否存在
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public static bool EmailExists(string email)
{
string strSQL = "SELECT COUNT(*) FROM Members WHERE Email = @Email";
SqlParameter param = new SqlParameter("Email", email);
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, param)) > 0);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Insert(CompanyNewsInfo model)
{
string strSQL = "DECLARE @MyId AS INT;INSERT INTO CompanyNews(CompanyId,Title,Content,PublishDateTime,ModifyDateTime,CreateDateTime,IsDeleted,Remark,ImageUrl,Tags,[Type]) VALUES(@CompanyId,@Title,@Content,@PublishDateTime,GETDATE(),GETDATE(),0,@Remark,@ImageUrl,@Tags,@Type);SELECT @MyId = @@IDENTITY;UPDATE CompanyNews SET Url = '/company/'+CAST(@CompanyId AS NVARCHAR(255))+'/newsdetail.html?id='+CAST(@MyId AS NVARCHAR(255)) WHERE Id = @MyId; SELECT @MyId;";
SqlParameter[] parms =
{
new SqlParameter("Id", SqlDbType.Int),
new SqlParameter("CompanyId", SqlDbType.Int),
new SqlParameter("Title", SqlDbType.NVarChar),
new SqlParameter("Content", SqlDbType.NVarChar),
new SqlParameter("PublishDateTime", SqlDbType.DateTime),
new SqlParameter("Remark", SqlDbType.NVarChar),
new SqlParameter("ImageUrl", SqlDbType.NVarChar),
new SqlParameter("Tags", SqlDbType.NVarChar),
new SqlParameter("Type", SqlDbType.NVarChar),
};
parms[0].Value = model.Id;
parms[1].Value = model.CompanyId;
parms[2].Value = model.Title;
parms[3].Value = model.Content;
parms[4].Value = model.PublishDateTime <= DateTime.MinValue ? DateTime.Now : model.PublishDateTime;
parms[5].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark;
parms[6].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl;
parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags;
parms[8].Value = string.IsNullOrEmpty(model.Type) ? "news" : model.Type;
int id = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms));
//插入News2Tech表
InsertNews2Tech(id, model.TechIds);
return(id);
}
/// <summary>
/// 发表反馈
/// </summary>
/// <param name="model"></param>
/// <returns>返回ID</returns>
public static int Insert(CompanyFeedbackInfo model)
{
string strSQL = "INSERT INTO CompanyFeedback(UserId,RealName,CompanyName,Phone,Email,[Type],Content,ForCompanyId,IP) VALUES (@UserId,@RealName,@CompanyName,@Phone,@Email,@Type,@Content,@ForCompanyId,@IP);SELECT @@IDENTITY;";
SqlParameter[] parms =
{
new SqlParameter("UserId", SqlDbType.Int),
new SqlParameter("RealName", SqlDbType.NVarChar),
new SqlParameter("CompanyName", SqlDbType.NVarChar),
new SqlParameter("Phone", SqlDbType.NVarChar),
new SqlParameter("Email", SqlDbType.NVarChar),
new SqlParameter("Type", SqlDbType.NVarChar),
new SqlParameter("Content", SqlDbType.NVarChar),
new SqlParameter("ForCompanyId", SqlDbType.Int),
new SqlParameter("IP", SqlDbType.NVarChar),
};
parms[0].Value = model.UserId;
parms[1].Value = model.RealName;
parms[2].Value = model.CompanyName;
parms[3].Value = model.Phone;
parms[4].Value = model.Email;
parms[5].Value = model.Type;
parms[6].Value = model.Content;
parms[7].Value = model.ForCompanyId;
parms[8].Value = model.IP;
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <param name="companyId"></param>
/// <returns></returns>
public static bool Delete(int id, int companyId)
{
if (id == 0 || companyId == 0)
{
return(false);
}
//如果ProductCount =0 可以删除，否则失败
int productCount = Get(id, companyId).ProductCount;
if (productCount > 0)
{
return(false);
}
string strSQL = "UPDATE CompanyProductCategories SET IsDeleted = 1,ProductCount = 0 WHERE Id = @Id AND CompanyId = @CompanyId";
SqlParameter[] parms =
{
new SqlParameter("Id", SqlDbType.Int),
new SqlParameter("CompanyId", SqlDbType.Int),
};
parms[0].Value = id;
parms[1].Value = companyId;
return(SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms) > 0);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Insert(BlogPostInfo model)
{
string strSQL = "INSERT INTO BlogPosts(UserId,Title,Content,ViewCount,CreateDateTime,SystemCategoryId,Tags,UserName,SystemCategoryName) VALUES(@UserId,@Title,@Content,0,GETDATE(),@SystemCategoryId,@Tags,@UserName,@SystemCategoryName);SELECT @@IDENTITY;";
SqlParameter[] parms =
{
new SqlParameter("Id", SqlDbType.Int),
new SqlParameter("UserId", SqlDbType.Int),
new SqlParameter("Title", SqlDbType.NVarChar),
new SqlParameter("Content", SqlDbType.NVarChar),
new SqlParameter("SystemCategoryId", SqlDbType.Int),
new SqlParameter("Tags", SqlDbType.NVarChar),
new SqlParameter("UserName", SqlDbType.NVarChar),
new SqlParameter("SystemCategoryName", SqlDbType.NVarChar),
};
parms[0].Value = model.Id;
parms[1].Value = model.UserId;
parms[2].Value = string.IsNullOrEmpty(model.Title) ? string.Empty : model.Title;
parms[3].Value = string.IsNullOrEmpty(model.Content) ? string.Empty : model.Content;
parms[4].Value = model.SystemCategoryId;
parms[5].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags;
parms[6].Value = model.UserName;
parms[7].Value = model.SystemCategoryName;
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)));
}
/// <summary>
/// 根据GUID获取
/// </summary>
/// <param name="guid"></param>
/// <returns></returns>
public static ResumeInfo GetByGUID(string guid)
{
string strSQL = "SELECT * FROM Resumes WITH(NOLOCK) WHERE [GUID] = @GUID";
SqlParameter parm = new SqlParameter("GUID", guid);
return(GetByRow(SQLPlus.ExecuteDataRow(CommandType.Text, strSQL, parm)));
}
/// <summary>
/// 获取广告位详细信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static AdPositionInfo Get(int id)
{
string strSQL = "SELECT TOP(1)* FROM AdPosition WITH(NOLOCK) WHERE Id = @Id";
SqlParameter param = new SqlParameter("Id", id);
return(GetByRow(SQLPlus.ExecuteDataRow(CommandType.Text, strSQL, param)));
}
/// <summary>
/// 更新回复数
/// </summary>
/// <param name="id"></param>
/// <param name="plus">true:+,false:-</param>
public static void UpdateReplies(int id, bool plus)
{
string strSQL = string.Format("UPDATE Forums SET Replies = Replies {0} 1 WHERE Id = @Id", plus ? "+" : "-");
SqlParameter parm = new SqlParameter("Id", id);
SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parm);
}
public static int AddGroup(ForumGroupInfo model)
{
string strSQL = "INSERT INTO dbo.ForumGroups(Name,Sort,IsDeleted,CreateDateTime) VALUES(@Name,@Sort,@IsDeleted,GETDATE());SELECT @@IDENTITY;";
SqlParameter[] parms = ParameterHelper.GetClassSqlParameters(model);
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)));
}
public override string[] GetUsersInRole(string roleName)
{
SecUtility.CheckParameter(ref roleName, true, true, true, 255, "roleName");
#region - T-SQL -
StringBuilder strSQL = new StringBuilder();
strSQL.Append(" SELECT u.Username FROM dbo.SiteRole AS r");
strSQL.Append(" INNER JOIN dbo.Tech2Type AS t ON r.id = t.TechId");
strSQL.Append(" INNER JOIN dbo.v_User2ID AS u ON u.id = t.TypeId");
strSQL.Append(" WHERE r.RoleName = @rolename;");
strSQL.Append(" AND t.[Type] = 'UsersInRoles'");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@rolename", SqlDbType.VarChar, 50)
};
parms[0].Value = roleName;
#endregion
DataTable oTable = SQLPlus.ExecuteDataTable(CommandType.Text, strSQL.ToString(), parms);
StringCollection sc = new StringCollection();
String[] strReturn;
foreach (DataRow r in oTable.Rows)
{
sc.Add(r[0].ToString().Trim());
}
strReturn = new String[sc.Count];
sc.CopyTo(strReturn, 0);
return(strReturn);
}
public override string[] FindUsersInRole(string roleName, string usernameToMatch)
{
SecUtility.CheckParameter(ref roleName, true, true, true, 255, "roleName");
SecUtility.CheckParameter(ref usernameToMatch, true, true, false, 255, "usernameToMatch");
#region - T-SQL -
StringBuilder strSQL = new StringBuilder();
strSQL.Append(" SELECT u.Username FROM dbo.SiteRole AS r");
strSQL.Append(" INNER JOIN dbo.Tech2Type AS t ON r.id = t.TechId");
strSQL.Append(" INNER JOIN dbo.v_User2ID AS u ON u.id = t.TypeId");
strSQL.Append(" WHERE r.RoleName = @rolename");
strSQL.Append(" AND u.Username LIKE @UserNameToMatch+'%'");
strSQL.Append(" AND t.[Type] = 'UsersInRoles'");
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@rolename", SqlDbType.VarChar, 50),
new SqlParameter("@UserNameToMatch", SqlDbType.VarChar, 20)
};
parms[0].Value = roleName;
parms[1].Value = usernameToMatch;
#endregion
DataTable oTable = SQLPlus.ExecuteDataTable(CommandType.Text, strSQL.ToString(), parms);
return(DataTable2Array(oTable));
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="roleName"></param>
/// <param name="throwOnPopulatedRole">是否确认用户</param>
/// <returns></returns>
public override bool DeleteRole(string roleName, bool throwOnPopulatedRole)
{
SecUtility.CheckParameter(ref roleName, true, true, true, 255, "roleName");
StringBuilder strSQL = new StringBuilder();
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@rolename", SqlDbType.VarChar, 50)
};
parms[0].Value = roleName;
if (throwOnPopulatedRole == true)
{
#region - T-SQL -
strSQL.Append(" SELECT COUNT(u.ID) FROM dbo.SiteRole AS r");
strSQL.Append(" INNER JOIN dbo.Tech2Type AS t ON r.id = t.TechId");
strSQL.Append(" INNER JOIN dbo.v_User2ID AS u ON u.id = t.TypeId");
strSQL.Append(" WHERE r.RoleName = @rolename");
strSQL.Append(" AND t.[Type] = 'UsersInRoles'");
#endregion
int i = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL.ToString(), parms));
if (i > 0)
{
throw new ProviderException("Role is not empty");
}
}
strSQL = new StringBuilder("DELETE FROM dbo.SiteRole WHERE RoleName = @rolename;");
int j = Convert.ToInt32(SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL.ToString(), parms));
return(j == 1);
}
/// <summary>
/// 列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList <MemberInfo> List(SearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.Ascending = false;
fp.TableName = "Members";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = " CreateDateTime DESC";
fp.WithOptions = " WITH(NOLOCK)";
IList <MemberInfo> list = new List <MemberInfo>();
DataTable dt = Goodspeed.Library.Data.SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(GetByRow(dr));
}
}
int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL()));;
return(new PageOfList <MemberInfo>(list, setting.PageIndex, setting.PageSize, count));
}
/// <summary>
/// 删除管理员
/// </summary>
/// <param name="userId"></param>
public static void DeleteAdmin(int userId)
{
string strSQL = "DELETE PagesAdmin WHERE UserId = @UserId";
SqlParameter param = new SqlParameter("UserId", userId);
SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
public static bool IsExistsUserName(string userName)
{
string strSQL = "SELECT COUNT(*) FROM OrderAdmins WITH(NOLOCK) WHERE UserName = @UserName";
SqlParameter parm = new SqlParameter("UserName", userName);
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parm)) > 0);
}
public static void UpdateGroup(ForumGroupInfo model)
{
string strSQL = "UPDATE ForumGroups SET Name = @Name,Sort = @Sort,IsDeleted = @IsDeleted WHERE Id = @ID";
SqlParameter[] parms = ParameterHelper.GetClassSqlParameters(model);
SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms);
}
/// <summary>
/// 还原管理员
/// </summary>
/// <param name="id"></param>
public static void Restore(int id)
{
string strSQL = "UPDATE OrderAdmins SET IsDeleted = 0 WHERE ID = @ID";
SqlParameter parm = new SqlParameter("ID", id);
SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parm);
}
public static int Add(ForumInfo model)
{
string strSQL = "INSERT INTO Forums(GroupId,Name,Info,Sort,IsDeleted) VALUES(@GroupId,@Name,@Info,@Sort,@IsDeleted);SELECT @@IDENTITY;";
SqlParameter[] parms = ParameterHelper.GetClassSqlParameters(model);
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)));
}
/// <summary>
/// 删除（逻辑删除）
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int Delete(int id)
{
string strSQL = "UPDATE Resumes SET IsDeleted = 1 WHERE Id = @Id";
SqlParameter parm = new SqlParameter("id", id);
return(SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parm));
}
/// <summary>
/// 更新播放次数
/// </summary>
/// <param name="videoId"></param>
public static void UpdatePlayCount(int videoId)
{
string strSQL = "UPDATE Videos SET PlayCount = PlayCount + 1 WHERE Id = @Id";
SqlParameter parm = new SqlParameter("Id", videoId);
SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parm);
}
/// <summary>
/// 广告位列表
/// </summary>
/// <param name="setting"></param>
/// <returns></returns>
public static IPageOfList <AdPositionInfo> List(AdSearchSetting setting)
{
FastPaging fp = new FastPaging();
fp.OverOrderBy = " CreateDateTime DESC";
fp.PageIndex = setting.PageIndex;
fp.PageSize = setting.PageSize;
fp.QueryFields = "*";
fp.TableName = "AdPosition";
fp.PrimaryKey = "Id";
fp.WithOptions = " WITH(NOLOCK)";
IList <AdPositionInfo> list = new List <AdPositionInfo>();
AdPositionInfo model = null;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = GetByRow(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, fp.BuildCountSQL()));
return(new PageOfList <AdPositionInfo>(list, setting.PageIndex, setting.PageSize, count));
}
/// <summary>
/// 添加视频
/// </summary>
/// <param name="model"></param>
/// <returns>返回VideoId</returns>
public static int Insert(VideoInfo model)
{
string strSQL = "INSERT INTO Videos(CategoryId,Title,Remark,VideoUrl,ImageUrl,IsTop,Tags,PublishDateTime,IsDeleted) VALUES(@CategoryId,@Title,@Remark,@VideoUrl,@ImageUrl,@IsTop,@Tags,@PublishDateTime,@IsDeleted);SELECT @@IDENTITY;";
SqlParameter[] parms =
{
new SqlParameter("Id", SqlDbType.Int),
new SqlParameter("CategoryId", SqlDbType.Int),
new SqlParameter("Title", SqlDbType.NVarChar),
new SqlParameter("Remark", SqlDbType.NVarChar),
new SqlParameter("VideoUrl", SqlDbType.NVarChar),
new SqlParameter("ImageUrl", SqlDbType.NVarChar),
new SqlParameter("IsTop", SqlDbType.Int),
new SqlParameter("Tags", SqlDbType.NVarChar),
new SqlParameter("PublishDateTime", SqlDbType.DateTime),
new SqlParameter("IsDeleted", SqlDbType.Int),
};
parms[0].Value = model.Id;
parms[1].Value = model.CategoryId;
parms[2].Value = string.IsNullOrEmpty(model.Title) ? string.Empty : model.Title;
parms[3].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark;
parms[4].Value = string.IsNullOrEmpty(model.VideoUrl) ? string.Empty : model.VideoUrl;
parms[5].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl;
parms[6].Value = model.IsTop ? 1 : 0;
parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags;
parms[8].Value = model.PublishDateTime;
parms[9].Value = model.IsDeleted ? 1 : 0;
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)));
}
/// <summary>
/// 获得没有分页的博客列表
/// 默认10条
/// </summary>
/// <param name="userId">0</param>
/// <param name="topCount">默认10条</param>
/// <returns></returns>
public static IList <BlogPostInfo> ListWithoutPage(int userId, int topCount = 10)
{
IList <BlogPostInfo> list = new List <BlogPostInfo>();
BlogPostInfo model = null;
string strSQL = "SELECT TOP(@TopCount) * FROM BlogPosts WITH(NOLOCK) WHERE UserId = @UserId AND IsDeleted = 0 ORDER BY CreateDateTime DESC";
SqlParameter[] parms =
{
new SqlParameter("TopCount", SqlDbType.Int),
new SqlParameter("UserId", SqlDbType.Int),
};
parms[0].Value = topCount;
parms[1].Value = userId;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, strSQL, parms);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = GetByDataRow(dr);
if (model != null)
{
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 更新视频
/// </summary>
/// <param name="model">返回影响的行数</param>
public static int Update(VideoInfo model)
{
string strSQL = "UPDATE Videos SET CategoryId = @CategoryId ,Title = @Title,Remark = @Remark,VideoUrl = @VideoUrl,ImageUrl = @ImageUrl,IsTop = @IsTop,Tags = @Tags ,PublishDateTime = @PublishDateTime ,IsDeleted = @IsDeleted WHERE Id = @Id";
SqlParameter[] parms =
{
new SqlParameter("Id", SqlDbType.Int),
new SqlParameter("CategoryId", SqlDbType.Int),
new SqlParameter("Title", SqlDbType.NVarChar),
new SqlParameter("Remark", SqlDbType.NVarChar),
new SqlParameter("VideoUrl", SqlDbType.NVarChar),
new SqlParameter("ImageUrl", SqlDbType.NVarChar),
new SqlParameter("IsTop", SqlDbType.Int),
new SqlParameter("Tags", SqlDbType.NVarChar),
new SqlParameter("PublishDateTime", SqlDbType.DateTime),
new SqlParameter("IsDeleted", SqlDbType.Int),
};
parms[0].Value = model.Id;
parms[1].Value = model.CategoryId;
parms[2].Value = string.IsNullOrEmpty(model.Title) ? string.Empty : model.Title;
parms[3].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark;
parms[4].Value = string.IsNullOrEmpty(model.VideoUrl) ? string.Empty : model.VideoUrl;
parms[5].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl;
parms[6].Value = model.IsTop ? 1 : 0;
parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags;
parms[8].Value = model.PublishDateTime;
parms[9].Value = model.IsDeleted ? 1 : 0;
return(SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms));
}
/// <summary>
/// 更新浏览数
/// </summary>
/// <param name="postId"></param>
public static void UpdateViewCount(int postId)
{
string strSQL = "UPDATE BlogPosts SET ViewCount = ViewCount + 1 WHERE Id = @Id";
SqlParameter parm = new SqlParameter("Id", postId);
SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parm);
}
public static IPageOfList <OrderAdminInfo> List(SearchSetting settings)
{
FastPaging fp = new FastPaging();
fp.PageIndex = settings.PageIndex;
fp.PageSize = settings.PageSize;
fp.TableName = "OrderAdmins";
fp.TableReName = "p";
fp.PrimaryKey = "ID";
fp.QueryFields = "p.*";
fp.OverOrderBy = " CreateDateTime DESC";
IList <OrderAdminInfo> list = new List <OrderAdminInfo>();
OrderAdminInfo model = null;
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, fp.Build2005());
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
model = Get(dr);
if (model != null)
{
list.Add(model);
}
}
}
int count = Count();
return(new PageOfList <OrderAdminInfo>(list, settings.PageIndex, settings.PageSize, count));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Update(CompanyNewsInfo model)
{
string strSQL = "UPDATE CompanyNews SET Title = @Title ,Content = @Content,PublishDateTime =@PublishDateTime,ModifyDateTime = GETDATE(),Remark = @Remark,ImageUrl = @ImageUrl,Tags = @Tags WHERE Id = @Id AND CompanyId = @CompanyId";
SqlParameter[] parms =
{
new SqlParameter("Id", SqlDbType.Int),
new SqlParameter("CompanyId", SqlDbType.Int),
new SqlParameter("Title", SqlDbType.NVarChar),
new SqlParameter("Content", SqlDbType.NVarChar),
new SqlParameter("PublishDateTime", SqlDbType.DateTime),
new SqlParameter("Remark", SqlDbType.NVarChar),
new SqlParameter("ImageUrl", SqlDbType.NVarChar),
new SqlParameter("Tags", SqlDbType.NVarChar),
};
parms[0].Value = model.Id;
parms[1].Value = model.CompanyId;
parms[2].Value = model.Title;
parms[3].Value = model.Content;
parms[4].Value = model.PublishDateTime;
parms[5].Value = string.IsNullOrEmpty(model.Remark) ? string.Empty : model.Remark;
parms[6].Value = string.IsNullOrEmpty(model.ImageUrl) ? string.Empty : model.ImageUrl;
parms[7].Value = string.IsNullOrEmpty(model.Tags) ? string.Empty : model.Tags;
//插入News2Tech表
InsertNews2Tech(model.Id, model.TechIds);
return(SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, parms));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(OrderAdminInfo model)
{
string strSQL = "INSERT INTO OrderAdmins(UserName,UserPwd,RoleType,IsDeleted,CreateDateTime) VALUES(@UserName,@UserPwd,@RoleType,0,GETDATE());SELECT @@IDENTITY;";
SqlParameter[] parms = ParameterHelper.GetClassSqlParameters(model);
return(Convert.ToInt32(SQLPlus.ExecuteScalar(CommandType.Text, strSQL, parms)));
}
public static IList <ColumnInfo> ColumnListByParentId(int parentId)
{
string strSQL = "SELECT * FROM Categories WITH(NOLOCK) WHERE ParentId = @ParentId ORDER BY Sort";
SqlParameter parm = new SqlParameter("ParentId", parentId);
DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, strSQL, parm);
var list = new List <ColumnInfo>();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
list.Add(new ColumnInfo()
{
Alias = dr.Field <string>("Alias"),
Name = dr.Field <string>("Name"),
IsDeleted = dr.Field <bool>("IsDeleted"),
Id = dr.Field <int>("Id"),
Sort = dr.Field <int>("Sort"),
ParentId = dr.Field <int>("ParentId"),
ParentIds = dr.Field <string>("ParentIds"),
RootId = dr.Field <int>("RootId")
});
}
}
return(list);
}
/// <summary>
/// 根据UserName获得用户信息
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public static MemberInfo Get(string userName)
{
string strSQL = "SELECT * FROM Members WITH(NOLOCK) WHERE UserName = @UserName";
SqlParameter param = new SqlParameter("UserName", userName);
return(GetByRow(SQLPlus.ExecuteDataRow(CommandType.Text, strSQL, param)));
}
