/// <summary>
/// 判断是否可以删除角色
/// 当 用户没有使用该角色时方可删除
/// </summary>
/// <param name="roleID"></param>
/// <returns></returns>
public bool IsCanDelRole(int roleID)
{
bool isCanDel = false;
try
{
SqlParameter[] prms =
{
new SqlParameter("@User_RoleID", roleID)
};
string sql = "SELECT COUNT(*) FROM M_System_User_Role_Rel WHERE User_RoleID=@User_RoleID";
object result = SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, sql, prms);
if (result != null && Convert.ToInt32(result) == 0)
{
isCanDel = true;
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isCanDel);
}
/// <summary>
/// 分页查询所有已分配角色用户信息
/// </summary>
/// <remarks>
/// author: zp
/// createtime: 2010.07.13
/// </remarks>
/// <param name="PageSize">页面大小</param>
/// <param name="PageIndex">页码</param>
/// <param name="Records">返回总页数</param>
/// <returns></returns>
public DataSet GetUserWithHaveFunForPage(String sqlwhere, int PageSize, int PageIndex, out int Records)
{
SqlParameter[] prms =
{
new SqlParameter("@TableName", "M_V_System_User"),
new SqlParameter("@Fields", "*"),
new SqlParameter("@OrderField", "Role_ID"),
new SqlParameter("@sqlWhere", sqlwhere),
new SqlParameter("@pageSize", PageSize),
new SqlParameter("@pageIndex", PageIndex),
new SqlParameter("@Records", 0)
};
try
{
prms[6].Direction = ParameterDirection.Output;
DataSet ds = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "dbo.sp_pager06", prms);
Records = Convert.ToInt32(prms[6].Value.ToString());
return(ds);
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
Records = 0;
return(new DataSet());
}
}
/// <summary>
/// 更新浏览次数
/// </summary>
/// <param name="eventItemGuid"></param>
/// <returns></returns>
public bool UpdateBrowserCnt(Guid eventItemGuid)
{
bool isSuccess = false;
StringBuilder sbSql = new StringBuilder();
sbSql.Append("IF EXISTS (SELECT * FROM M_EventItemBrowseCnts WHERE EventItemGUID=@EventItemGUID)");
sbSql.Append(" UPDATE M_EventItemBrowseCnts SET BrowseCnt=BrowseCnt+1 WHERE EventItemGUID=@EventItemGUID");
sbSql.Append(" ELSE");
sbSql.Append(" INSERT INTO M_EventItemBrowseCnts(EventItemGUID,BrowseCnt) VALUES (@EventItemGUID,@BrowseCnt)");
SqlParameter[] prms =
{
new SqlParameter("@EventItemGUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@BrowseCnt", SqlDbType.Int)
};
prms[0].Value = eventItemGuid;
prms[1].Value = 1;
try
{
isSuccess = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, sbSql.ToString(), prms) > 0;
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isSuccess);
}
/// <summary>
/// 设置用户角色
/// </summary>
/// <remarks>
/// author: zp
/// createtime: 2010.07.13
/// </remarks>
/// <param name="userid">用户编号</param>
/// <param name="roleid">角色编号</param>
/// <returns></returns>
public bool SetUserRole(String userid, int roleid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"IF EXISTS(SELECT * FROM M_System_User_Role_Rel WHERE User_ID=@userid)
UPDATE M_System_User_Role_Rel SET User_RoleID = @roleid WHERE USER_ID =@userid
ELSE
INSERT INTO M_System_User_Role_Rel(User_ID,User_RoleID,User_ShowName) VALUES(@userid,@roleid,'')");
SqlParameter[] prms =
{
new SqlParameter("@userid", userid),
new SqlParameter("@roleid", roleid)
};
try
{
int i = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), prms);
if (i == 0)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
}
/// <summary>
/// 查询分页/不分页两种
/// </summary>
/// <param name="entity"></param>
/// <param name="totalcnt"></param>
/// <returns></returns>
public DataTable QueryAdminTable(AdminSearchEntity entity, out int totalcnt)
{
DataTable table = null;
totalcnt = 0;
try
{
SqlParameter[] prms = ParseToSqlParameters(entity).ToArray();
if (entity.UseDBPagination)
{
table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "sp_pager06", prms).Tables[0];
totalcnt = int.Parse(prms[prms.Length - 1].Value.ToString());
}
else
{
throw new NotImplementedException();
}
}
catch (Exception ex)
{
totalcnt = -1;
LogUtil.WriteLog(ex);
}
return(table);
}
/// <summary>
/// 更新发送状态
/// </summary>
/// <param name="mailID"></param>
/// <param name="enumMailStatus"></param>
/// <returns></returns>
public bool UpdateSendStatus(int mailID, string remark, UserMailStatus enumMailStatus)
{
bool isSuccess = false;
string updateSQL = "Update M_User_Mail Set MailStatus=@MailStatus, SendDate=@SendDate,Remark=@Remark Where MailID=@MailID";
SqlParameter[] prms =
{
new SqlParameter("@MailStatus", (int)enumMailStatus),
new SqlParameter("@SendDate", DateTime.Now),
new SqlParameter("@MailID", mailID),
new SqlParameter("@Remark", remark)
};
try
{
isSuccess = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, updateSQL, prms) > 0;
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isSuccess);
}
/// <summary>
/// 为信息维护员添加某一节点的权限
/// </summary>
/// <remarks>
/// create by perry
/// create time 2010-07-22
/// </remarks>
/// <param name="userid"></param>
/// <returns></returns>
public Boolean AddInfoManagerWithFun(String userid, int functionid)
{
SqlParameter[] prms =
{
new SqlParameter("@userid", userid),
new SqlParameter("@functionid", functionid)
};
try
{
int i = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, "insert into M_System_User_Fun_Rel(UFRel_FunctionID,UFRel_UserID) values(@functionid,@userid)", prms);
if (i == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
}
/// <summary>
/// 添加回复
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public OperationResult <AddReplyCommonEntity> ArticleReply_Insert(EventItemReplyEntity entity)
{
try
{
AddReplyCommonEntity acEntity = new AddReplyCommonEntity();
ReplyCommonEntity rcEntity = new ReplyCommonEntity();
using (SqlConnection con = new SqlConnection(SQlHelper.MyConnectStr))
{
SqlTransaction trans = null;
con.Open();
trans = con.BeginTransaction();
DateTime? nowDate = entity.ReplyTime == null ? DateTime.Now : entity.ReplyTime;
SqlParameter[] prms =
{
new SqlParameter("@ReplyID", entity.ReplyID),
new SqlParameter("@CommentID", entity.CommentID),
new SqlParameter("@UserID", entity.UserID),
new SqlParameter("@IsAnonymous", entity.IsAnonymous),
new SqlParameter("@ReplyParentID", entity.ReplyParentID),
new SqlParameter("@ReplyContent", entity.ReplyContent),
new SqlParameter("@ReplyTime", nowDate),
new SqlParameter("@CheckTypeID", entity.CheckTypeID),
new SqlParameter("@ViewStateID", entity.ViewStateID)
};
SqlParameter[] commPrms =
{
new SqlParameter("@CommentID", entity.CommentID),
new SqlParameter("@UserID", entity.UserID),
};
prms[0].Direction = ParameterDirection.Output;
int state = SQlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "M_EventItemReply_Insert", prms);
trans.Commit();
DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "M_ReplyCommon_Get", commPrms).Tables[0];
if (table != null && table.Rows.Count != 0)
{
rcEntity = ConvertDataTable <ReplyCommonEntity> .ConvertToList(table)[0];
}
acEntity.ReplyID = prms[0].Value.ToInt();
acEntity.ReplyTime = nowDate;
acEntity.ReviewLikeCount = rcEntity.ReviewLikeCount;
acEntity.IsReviewLike = rcEntity.IsReviewLike;
acEntity.ReplyCount = rcEntity.ReplyCount;
if (state > 0)
{
return(new OperationResult <AddReplyCommonEntity>(OperationResultType.Success, "回复完成！", acEntity));
}
else
{
return(new OperationResult <AddReplyCommonEntity>(OperationResultType.NoChanged, "评论已被删除,无法回复！", acEntity));
}
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(new OperationResult <AddReplyCommonEntity>(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection)));
}
}
/// <summary>
/// 添加文章评论
/// </summary>
/// <returns></returns>
public OperationResult <ReviewCommonEntity> ArticleComments_Insert(EventItemCommentEntity entity)
{
try
{
ReviewCommonEntity rcEntity = new ReviewCommonEntity();
SqlParameter[] prms =
{
new SqlParameter("@EventItemID", entity.EventItemID),
new SqlParameter("@UserID", entity.UserID),
new SqlParameter("@IsAnonymous", entity.IsAnonymous),
new SqlParameter("@CommentContent", entity.CommentContent),
new SqlParameter("@CommentTime", entity.CommentTime == null ? DateTime.Now:entity.CommentTime),
new SqlParameter("@CheckTypeID", entity.CheckTypeID),
new SqlParameter("@ViewStateID", entity.ViewStateID)
};
DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "M_EventItemComments_Insert", prms).Tables[0];
if (table != null && table.Rows.Count != 0)
{
rcEntity.ReviewCount = table.Rows[0]["ReviewCount"].ToInt();
rcEntity.ArticleLikeCount = table.Rows[0]["ArticleLikeCount"].ToInt();
rcEntity.IsArticleLike = table.Rows[0]["IsArticleLike"].ToInt() == 0 ? false : true;
}
return(new OperationResult <ReviewCommonEntity>(OperationResultType.Success, "添加文章评论完成！", rcEntity));
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(new OperationResult <ReviewCommonEntity>(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection)));
}
}
public bool UpdateUser(UserEntity info)
{
SqlParameter[] prms =
{
new SqlParameter("@EMail", info.EMail),
new SqlParameter("@Name", info.Name),
new SqlParameter("@Company", info.Company),
new SqlParameter("@Position", info.Position),
new SqlParameter("@Department", info.Department),
new SqlParameter("@Address", info.Address),
new SqlParameter("@UserID", info.UserID),
new SqlParameter("@NickName", info.NickName)
};
string sql = "update M_User set NickName=@NickName, EMail = @EMail,Name = @Name,Company = @Company,Position = @Position,Department = @Department,Address = @Address where UserID = @UserID";
try
{
SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, sql, prms);
return(true);
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
}
/// <summary>
/// 根据展场id 查找属于这次展场的展商和活动的标题信息
/// </summary>
/// <param name="ExhibitionID">展场id</param>
/// <returns></returns>
public DataTable GetSearchKeyWordTable(int exhibitionID)
{
DataTable table = null;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"SELECT ee.ExhibitorName AS SearchName,
ee.ExhibitorPinYin AS SearchPinYin,
1 AS SearchType
FROM
dbo.M_Exhibition_Exhibitors AS ee
INNER JOIN dbo.M_Exhibition_Main AS em ON em.ExhibitionID = ee.ExhibitionID
WHERE ee.StateTypeID=1 AND em.StateTypeID = 1 AND em.ExhibitionID = {0}
UNION
SELECT ea.ActivityTitle AS SearchName,
'' AS SearchPinYin,
2 AS SearchType
FROM dbo.M_Exhibition_Activity AS ea
LEFT JOIN dbo.M_Exhibition_Exhibitors AS ee ON ee.ExhibitorID = ea.ExhibitorID
INNER JOIN dbo.M_Exhibition_Main AS em ON em.ExhibitionID = ea.ExhibitionID
WHERE ea.StateTypeID = 1 AND ((ee.ExhibitorID IS NOT NULL AND ee.StateTypeID=1) OR ee.ExhibitorID IS NULL) AND em.StateTypeID =1 AND em.ExhibitionID = {0} AND ea.ParentID=0"
, exhibitionID.ToString());
DataSet ds = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), null);
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
table = ds.Tables[0];
}
}
return(table);
}
public int WriteNumber(int recommendId, string phoneNum)
{
int returnValue = 0;
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"INSERT INTO dbo.M_User_Recommend_Mobile
( RecommendID, Mobile )
VALUES ( {0},'{1}');
SELECT @@IDENTITY;"
, recommendId.ToString()
, phoneNum);
try
{
object obj = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), null);
if (obj != null)
{
returnValue = int.Parse(obj.ToString());
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
}
return(returnValue);
}
public bool CheckSmsCode(string phone, string code, SqlTransaction trans)
{
try
{
SqlParameter[] prms =
{
new SqlParameter("@Phone", phone),
new SqlParameter("@VCode", code)
};
string sql = "SELECT count(1) FROM [dbo].[M_SmsCodes] WHERE Phone=@Phone AND VCode=@VCode AND ExpriedTime>=GETDATE()";
if (trans != null)
{
return(int.Parse(SQlHelper.ExecuteScalar(trans, CommandType.Text, sql, prms).ToString()) > 0);
}
else
{
return(int.Parse(SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, sql, prms).ToString()) > 0);
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
}
/// <summary>
/// 添加分组关联项
/// </summary>
/// <param name="groupEntity"></param>
/// <param name="groupRelEntityList"></param>
/// <returns></returns>
public bool InsertGroupRel(EventItemGroupEntity groupEntity, List <EventItemGroupRelEntity> groupRelEntityList)
{
bool isSuccess = false;
SqlTransaction trans = null;
try
{
StringBuilder sbInsert = new StringBuilder();
string insertGroupSQL = "INSERT INTO M_EventItemGroups(GroupEventName,PublishTime,CreatedTime,GroupState) VALUES (@GroupEventName,@PublishTime,@CreatedTime,@GroupState);SELECT @@IDENTITY;";
string insertRelSQL = "INSERT INTO M_EventItem_Group_Rel(EventGroupID,EventItemID,DisplayOrder) VALUES({0},{1},{2});";
SqlParameter[] prms =
{
new SqlParameter("@GroupEventName", SqlDbType.VarChar, 100),
new SqlParameter("@PublishTime", SqlDbType.DateTime),
new SqlParameter("@CreatedTime", SqlDbType.DateTime),
new SqlParameter("@GroupState", SqlDbType.Int)
};
prms[0].Value = groupEntity.GroupEventName;
prms[1].Value = groupEntity.PublishTime;
prms[2].Value = groupEntity.CreatedTime;
prms[3].Value = groupEntity.GroupState;
//去除重专题文章
//groupRelEntityList = groupRelEntityList.Distinct(new EventItemGroupRelEntityDistinct()).ToList();
using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr))
{
conn.Open();
trans = conn.BeginTransaction();
int groupEventID = Convert.ToInt32(SQlHelper.ExecuteScalar(trans, CommandType.Text, insertGroupSQL, prms));
if (groupRelEntityList != null && groupRelEntityList.Count > 0)
{
foreach (EventItemGroupRelEntity groupRelEntity in groupRelEntityList)
{
sbInsert.AppendFormat(insertRelSQL, groupEventID, groupRelEntity.EventItemID, groupRelEntity.DisplayOrder);
}
int num2 = SQlHelper.ExecuteNonQuery(trans, CommandType.Text, sbInsert.ToString());
}
isSuccess = true;
trans.Commit();
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
if (trans != null)
{
trans.Rollback();
}
return(false);
}
return(isSuccess);
}
public bool Insert(UserMailEntity entity)
{
bool isSuccess = false;
string insertSQL = "INSERT INTO M_User_Mail(UserID,EventItemID,CreateDate,MailStatus,Remark) VALUES (@UserID,@EventItemID,@CreateDate,@MailStatus,@Remark)";
SqlParameter[] prms = new SqlParameter[] {
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@EventItemID", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@MailStatus", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500)
};
prms[0].Value = entity.UserID;
prms[1].Value = entity.EventItemID;
prms[2].Value = entity.CreateDate;
prms[3].Value = entity.MailStatus;
prms[4].Value = entity.Remark;
try
{
isSuccess = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, insertSQL, prms) > 0;
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isSuccess);
}
/// <summary>
/// 文章点赞数与评论数
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public OperationResult <ReviewCommonEntity> ReviewCommon_Get(EventItemCommentEntity entity)
{
try
{
ReviewCommonEntity rcEntity = new ReviewCommonEntity();
SqlParameter[] commPrms =
{
new SqlParameter("@EventItemID", entity.EventItemID),
new SqlParameter("@UserID", entity.UserID)
};
DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "M_ReviewCommon_Get", commPrms).Tables[0];
if (table != null && table.Rows.Count != 0)
{
rcEntity.ReviewCount = table.Rows[0]["ReviewCount"].ToInt();
rcEntity.ArticleLikeCount = table.Rows[0]["ArticleLikeCount"].ToInt();
rcEntity.IsArticleLike = table.Rows[0]["IsArticleLike"].ToInt() == 0 ? false : true;
}
return(new OperationResult <ReviewCommonEntity>(OperationResultType.Success, "评论和点赞数抓取完成！", rcEntity));
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(new OperationResult <ReviewCommonEntity>(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection)));
}
}
public bool Update(UserMailEntity entity)
{
bool isSuccess = false;
string insertSQL = "UPDATE M_User_Mail SET UserID=@UserID,EventItemID=@EventItemID,CreateDate=@CreateDate,MailStatus=@MailStatus,Remark=@Remark,SendDate=@SendDate WHERE MailID=@MailID";
SqlParameter[] prms = new SqlParameter[] {
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@EventItemID", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@MailStatus", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@SendDate", SqlDbType.DateTime),
new SqlParameter("@MailID", SqlDbType.Int, 4)
};
prms[0].Value = entity.UserID;
prms[1].Value = entity.EventItemID;
prms[2].Value = entity.CreateDate;
prms[3].Value = entity.MailStatus;
prms[4].Value = entity.Remark;
prms[5].Value = entity.SendDate;
prms[6].Value = entity.MailID;
try
{
isSuccess = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, insertSQL, prms) > 0;
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isSuccess);
}
public int Insert(PictureEntity entity)
{
int returnValue = 0;
string sql = "Insert Into M_Pictures(PictureServerID,PicturePath,PictureState) Values(@PictureServerID,@PicturePath,@PictureState);SELECT @@IDENTITY;";
SqlParameter[] prms =
{
new SqlParameter("@PictureServerID", SqlDbType.Int),
new SqlParameter("@PicturePath", SqlDbType.NVarChar,200),
new SqlParameter("@PictureState", SqlDbType.Int)
};
prms[0].Value = entity.PictureServerID;
prms[1].Value = entity.PicturePath;
prms[2].Value = entity.PictureState;
try
{
object obj = SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, sql, prms);
if (obj != null)
{
returnValue = obj.ToInt();
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
}
return(returnValue);
}
/// <summary>
/// 判断该菜单项是可否删除 true可删除 false不可删除
/// </summary>
/// <param name="functionID"></param>
/// <returns></returns>
public bool IsCanDelFunction(int functionID)
{
bool isCandel = false;
StringBuilder sbSql = new StringBuilder();
sbSql.Append(" SELECT COUNT(fun.Function_ID) FROM M_System_Function fun");
sbSql.Append(" INNER JOIN M_System_User_Fun_Rel userfun ON fun.Function_ID=userfun.UFRel_FunctionID");
sbSql.Append(" INNER JOIN M_V_System_User us ON us.[User_ID]=userfun.UFRel_UserID");
sbSql.Append(" WHERE fun.Function_ID=@Function_ID");
SqlParameter[] prms =
{
new SqlParameter("@Function_ID", functionID)
};
try
{
object result = SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, sbSql.ToString(), prms);
if (Convert.ToInt32(result) == 0)
{
isCandel = true;
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isCandel);
}
/// <summary>
/// 判断分类是否可以添加
/// </summary>
/// <param name="pid"></param>
/// <param name="fname"></param>
/// <param name="id"></param>
/// <returns></returns>
public bool IsUserable(int pid, string fname, int id)
{
bool flg = false;
if (pid == 0)
{
pid = -1;
}
string str = "select * from M_CalendarType where ParentCalendarTypeID=@ParentCalendarTypeID and CalendarTypeName=@CalendarTypeName and CalendarTypeID <> @CalendarTypeID";
SqlParameter[] pars = { new SqlParameter("@ParentCalendarTypeID", pid),
new SqlParameter("@CalendarTypeName", fname),
new SqlParameter("@CalendarTypeID", id) };
try
{
using (SqlConnection conn = new SqlConnection(SQlHelper.MyConnectStr))
{
DataTable db = SQlHelper.ExecuteDataset(conn, CommandType.Text, str, pars).Tables[0];
if (db.Rows.Count > 0)
{
flg = false;
}
else
{
flg = true;
}
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
}
return(flg);
}
/// <summary>
/// 根据用户编号修改角色
/// </summary>
/// <remarks>
/// author: zp
/// createtime: 2010.07.13
/// </remarks>
/// <param name="userid">用户编号</param>
/// <param name="roleid">修改后的角色编号</param>
/// <returns></returns>
public bool UpdateUserRole(String userid, int roleid)
{
SqlParameter[] prms =
{
new SqlParameter("@userid", userid),
new SqlParameter("@roleid", roleid)
};
try
{
int i = SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, "update M_System_User_Role_Rel set User_RoleID=@roleid where User_ID=@userid", prms);
if (i != 1)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
}
/// <summary>
/// 根据版本号，判断是否进行审核
/// </summary>
/// <param name="versionCode"></param>
/// <returns></returns>
public bool IsVersionCheck(string versionCode)
{
bool returnValue = true;
StringBuilder strSql = new StringBuilder();
try
{
strSql.AppendFormat(@"SELECT [VerState] FROM [M_Version_CheckState] WHERE VersionCode = '{0}'"
, versionCode);
object obj = SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), null);
if (obj != null)
{
if (int.Parse(obj.ToString()) == 0)
{
returnValue = false;
}
}
else
{
returnValue = false;
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(true);
}
return(returnValue);
}
/// <summary>
/// 登录判断
/// </summary>
/// <param name="username"></param>
/// <param name="pwd"></param>
/// <param name="userid"></param>
/// <returns></returns>
public bool TryLogin(string username, string pwd, out string userid)
{
userid = "0";
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT User_ID FROM M_System_User WHERE User_Name=@User_Name AND User_Pwd=@User_Pwd");
SqlParameter[] prms =
{
new SqlParameter("@User_Name", username),
new SqlParameter("@User_Pwd", pwd)
};
try
{
DataTable dt = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.Text, sb.ToString(), prms).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
userid = dt.Rows[0]["User_ID"].ToString();
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
}
/// <summary>
/// 获取单条订阅明细
/// </summary>
/// <param name="userID"></param>
/// <param name="subID"></param>
/// <returns></returns>
public OperationResult <SubscriptionEntity> Subscription_Get(int userID, int subID)
{
try
{
string sql = string.Empty;
sql += " SELECT s.SubID,s.SubName,s.PinYin,s.[Description],s.SubShortName,fp.PicturePath ,fp.Domain,s.CreateTime ";
sql += " ,(SELECT CAST(COUNT(1) AS BIT) FROM [dbo].[M_User_Subscription] WHERE USERID={0} AND SubID =s.SubID) AS IsAlready ";
sql += " FROM M_Subscription AS s ";
sql += " LEFT JOIN [dbo].[M_V_Picture] AS fp ON s.PictureID= fp.PictureID ";
sql += " WHERE s.SubID={1} ";
sql = string.Format(sql, userID, subID);
List <SubscriptionEntity> entitys = new List <SubscriptionEntity>();
DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.Text, sql).Tables[0];
entitys = ConvertDataTable <SubscriptionEntity> .ConvertToList(table);
if (entitys != null && entitys.Count == 1)
{
return(new OperationResult <SubscriptionEntity>(OperationResultType.Success, "订阅信息获取完成！", entitys[0]));
}
else
{
return(new OperationResult <SubscriptionEntity>(OperationResultType.NoChanged, "请求的订阅号不存在！"));
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(new OperationResult <SubscriptionEntity>(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection)));
}
}
/// <summary>
/// 判断用户是否可以注册
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public bool IsUseableByUsername(string username)
{
bool isUseable = false; //true 可用 false已存在
try
{
SqlParameter[] prms =
{
new SqlParameter("@User_Name", SqlDbType.NVarChar, 20)
};
prms[0].Value = username;
string sql = "SELECT COUNT(User_Name) FROM M_System_User WHERE User_Name=@User_Name";
object result = SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, sql, prms);
if (result != null && Convert.ToInt32(result) == 0)
{
isUseable = true;
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(false);
}
return(isUseable);
}
/// <summary>
/// 查询订阅结果集
/// </summary>
/// <param name="userID">用户id</param>
/// <param name="subID">末尾订阅ID</param>
/// <param name="strWhere">查询条件 用于查询是否订阅条件</param>
/// <param name="pageSize">页面大小</param>
/// <param name="pageIndex">起始页 默认为1</param>
/// <param name="type">YES 已订阅 NO 未订阅</param>
/// <returns></returns>
public OperationResult <List <SubscriptionEntity> > Subscription_GetList(int userID, int subID, int pageSize, string strWhere, int pageIndex, SubQueryType type)
{
try
{
List <SubscriptionEntity> entitys = new List <SubscriptionEntity>();
SqlParameter[] prms =
{
new SqlParameter("@UserID", userID),
new SqlParameter("@SubID", subID),
new SqlParameter("@StrWhere", strWhere),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@QueryType", (int)type)
};
DataTable table = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.StoredProcedure, "M_Subscription_GetList", prms).Tables[0];
entitys = ConvertDataTable <SubscriptionEntity> .ConvertToList(table);
return(new OperationResult <List <SubscriptionEntity> >(OperationResultType.Success, "订阅列表获取完成！", entitys));
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(new OperationResult <List <SubscriptionEntity> >(OperationResultType.NoConnection, Description.EnumDescription(OperationResultType.NoConnection)));
}
}
public bool UpdateNewWordState(Dictionary <int, string> wordList)
{
bool returnValue = false;
if (wordList != null)
{
string ids = "";
foreach (int _id in wordList.Keys)
{
ids += _id + ",";
}
ids = ids.TrimEnd(',');
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"UPDATE dbo.M_System_SensitiveWords SET IsNeedRecheck=0 WHERE SWID IN ({0})"
, ids);
try
{
if (SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), null) > 0)
{
returnValue = true;
}
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
}
}
return(returnValue);
}
/// <summary>
/// 获取费用分配数据底层调用
/// </summary>
/// <param name="CurrorPage"></param>
/// <param name="PageSize"></param>
/// <param name="Total"></param>
/// <param name="sortStr"></param>
/// <param name="condition"></param>
/// <param name="DataID"></param>
/// <returns></returns>
public static DataTable FindByPage(int CurrorPage, int PageSize, out int Total, string sortStr, Cost_PerCondition condition, string DataID = null)
{
SqlParameter[] sqlParas = new SqlParameter[] {
new SqlParameter("@SourceID ", SqlDbType.VarChar, 100)
, new SqlParameter("@LangType", SqlDbType.VarChar, 20)
, new SqlParameter("@Sect_RID", SqlDbType.VarChar, 50)
, new SqlParameter("@Emp_No", SqlDbType.VarChar, 10)
, new SqlParameter("@Effect_Date", SqlDbType.VarChar, 20)
, new SqlParameter("@Effect_Date_To", SqlDbType.VarChar, 20)
, new SqlParameter("@CursorPage", SqlDbType.Int)
, new SqlParameter("@PageSize", SqlDbType.Int)
, new SqlParameter("@SortStr", SqlDbType.NVarChar, 200)
, new SqlParameter("@DataID", SqlDbType.VarChar, 50)
, new SqlParameter("@CheckDate", SqlDbType.VarChar, 20)
, new SqlParameter("@ActiveVal", SqlDbType.VarChar, 10)
};
sqlParas[0].Value = "getPagerData";
sqlParas[1].Value = "CN"; // LangType;
sqlParas[2].Value = condition.Sect_RID_Value; // this.SelectTree.GetItem("value");
sqlParas[3].Value = condition.Emp_No;
sqlParas[4].Value = condition.Effect_DateFrom;
sqlParas[5].Value = condition.Effect_DateTo;
sqlParas[6].Value = CurrorPage;
sqlParas[7].Value = PageSize;
sqlParas[8].Value = sortStr;
sqlParas[9].Value = DataID;
sqlParas[10].Value = condition.CheckDate;
sqlParas[11].Value = condition.ActiveVal;
DataSet ds = SQlHelper.ExecuteToDataSet("p_HRIS424SearchData", CommandType.StoredProcedure, sqlParas);
DataTable dt = ds.Tables[1];
Total = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
return(dt);
}
/// <summary>
/// 获取文章浏览次数
/// </summary>
/// <param name="eventItemGuid"></param>
/// <returns></returns>
public int GetBrowserCnt(Guid eventItemGuid)
{
int broCnts = 0;
StringBuilder sbSql = new StringBuilder();
sbSql.Append("IF EXISTS (SELECT * FROM M_EventItemBrowseCnts WHERE EventItemGUID=@EventItemGUID)");
sbSql.Append(" SELECT 0");
sbSql.Append(" ELSE");
sbSql.Append(" SELECT BrowseCnt FROM M_EventItemBrowseCnts WHERE EventItemGUID=@EventItemGUID");
SqlParameter[] prms =
{
new SqlParameter("@EventItemGUID", SqlDbType.UniqueIdentifier, 16)
};
prms[0].Value = eventItemGuid;
try
{
object result = SQlHelper.ExecuteScalar(SQlHelper.MyConnectStr, CommandType.Text, sbSql.ToString(), prms);
int.TryParse(result.ToString(), out broCnts);
}
catch (Exception ex)
{
LogUtil.WriteLog(ex);
return(0);
}
return(broCnts);
}
public DataTable GetTable(int id)
{
DataTable table = null;
StringBuilder strSql = new StringBuilder();
strSql.Append(" select a.* ");
strSql.Append(" FROM M_Exhibition_Activity AS a ");
strSql.Append(" WHERE a.ActivityID =@ActivityID ");
SqlParameter[] parameters =
{
new SqlParameter("@ActivityID", SqlDbType.Int, 4)
};
parameters[0].Value = id;
DataSet ds = SQlHelper.ExecuteDataset(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
table = ds.Tables[0];
}
}
return(table);
}
