/// <summary>
/// 获取角色信息业务实体
/// </summary>
/// <param name="jueSeId">角色编号</param>
/// <returns></returns>
public EyouSoft.Model.MYongHuJueSeInfo GetInfo(string jueSeId)
{
EyouSoft.Model.MYongHuJueSeInfo info = null;
var cmd = _db.GetSqlStringCommand("SELECT * FROM [tbl_YongHuJueSe] WHERE [JueSeId]=@JueSeId");
_db.AddInParameter(cmd, "@JueSeId", DbType.AnsiStringFixedLength, jueSeId);
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
info = new EyouSoft.Model.MYongHuJueSeInfo();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.GongSiId = rdr["GongSiId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JueSeId = rdr["JueSeId"].ToString();
info.MiaoShu = rdr["MiaoShu"].ToString();
info.Name = rdr["Name"].ToString();
info.Privs = Utils.Split2(rdr["Privs"].ToString(), ",");
info.Status = (EyouSoft.Model.YongHuJueSeStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
}
}
return(info);
}
/// <summary>
/// get form info
/// </summary>
/// <returns></returns>
EyouSoft.Model.MYongHuJueSeInfo GetFormInfo()
{
var info = new EyouSoft.Model.MYongHuJueSeInfo();
info.CaoZuoRenId = YongHuInfo.YongHuId;
info.GongSiId = YongHuInfo.GongSiId;
info.IssueTime = DateTime.Now;
info.JueSeId = EditId;
info.MiaoShu = string.Empty;
info.Name = Utils.GetFormValue(txtName.UniqueID);
info.Privs = new List <int>();
info.Status = EyouSoft.Model.YongHuJueSeStatus.可用;
var chkPrivs1 = Utils.GetFormValues("chkPrivs1");
if (chkPrivs1 != null && chkPrivs1.Length > 0)
{
for (var i = 0; i < chkPrivs1.Length; i++)
{
info.Privs.Add(Utils.GetInt(chkPrivs1[i]));
}
}
return(info);
}
/// <summary>
/// 用户角色修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int JueSe_U(EyouSoft.Model.MYongHuJueSeInfo info)
{
var cmd = _db.GetSqlStringCommand("UPDATE [tbl_YongHuJueSe] SET [Name]=@Name,[MiaoShu]=@MiaoShu,[Status]=@Status,[Privs]=@Privs WHERE [JueSeId]=@JueSeId");
_db.AddInParameter(cmd, "@JueSeId", DbType.AnsiStringFixedLength, info.JueSeId);
_db.AddInParameter(cmd, "@Name", DbType.String, info.Name);
_db.AddInParameter(cmd, "@MiaoShu", DbType.String, info.MiaoShu);
_db.AddInParameter(cmd, "@Status", DbType.Int32, info.Status);
_db.AddInParameter(cmd, "@Privs", DbType.String, GetSqlIn(info.Privs));
DbHelper.ExecuteSql(cmd, _db);
return(1);
}
/// <summary>
/// 用户角色添加，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int JueSe_C(EyouSoft.Model.MYongHuJueSeInfo info)
{
var cmd = _db.GetSqlStringCommand("INSERT INTO [tbl_YongHuJueSe]([JueSeId],[Name],[GongSiId],[MiaoShu],[Status],[Privs],[CaoZuoRenId],[IssueTime]) VALUES (@JueSeId,@Name,@GongSiId,@MiaoShu,@Status,@Privs,@CaoZuoRenId,@IssueTime)");
_db.AddInParameter(cmd, "@JueSeId", DbType.AnsiStringFixedLength, info.JueSeId);
_db.AddInParameter(cmd, "@Name", DbType.String, info.Name);
_db.AddInParameter(cmd, "@GongSiId", DbType.AnsiStringFixedLength, info.GongSiId);
_db.AddInParameter(cmd, "@MiaoShu", DbType.String, info.MiaoShu);
_db.AddInParameter(cmd, "@Status", DbType.Int32, info.Status);
_db.AddInParameter(cmd, "@Privs", DbType.String, GetSqlIn(info.Privs));
_db.AddInParameter(cmd, "@CaoZuoRenId", DbType.AnsiStringFixedLength, info.CaoZuoRenId);
_db.AddInParameter(cmd, "@IssueTime", DbType.DateTime, info.IssueTime);
DbHelper.ExecuteSql(cmd, _db);
return(1);
}
/// <summary>
/// 获取角色信息集合
/// </summary>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <EyouSoft.Model.MYongHuJueSeInfo> GetJueSes(int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.MYongHuJueSeChaXunInfo chaXun)
{
IList <EyouSoft.Model.MYongHuJueSeInfo> items = new List <EyouSoft.Model.MYongHuJueSeInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "tbl_YongHuJueSe";
string orderByString = " IssueTime DESC ";
string heJiString = "";
#region sql
sql.Append(" 1=1 ");
if (chaXun != null)
{
if (!string.IsNullOrEmpty(chaXun.Name))
{
sql.AppendFormat(" AND Name LIKE '%{0}%' ", chaXun.Name);
}
if (!string.IsNullOrEmpty(chaXun.GongSiId))
{
sql.AppendFormat(" AND GongSiId='{0}' ", chaXun.GongSiId);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, sql.ToString(), orderByString, heJiString))
{
while (rdr.Read())
{
var info = new EyouSoft.Model.MYongHuJueSeInfo();
info.CaoZuoRenId = rdr["CaoZuoRenId"].ToString();
info.GongSiId = rdr["GongSiId"].ToString();
info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
info.JueSeId = rdr["JueSeId"].ToString();
info.MiaoShu = rdr["MiaoShu"].ToString();
info.Name = rdr["Name"].ToString();
info.Privs = Utils.Split2(rdr["Privs"].ToString(), ",");
info.Status = (EyouSoft.Model.YongHuJueSeStatus)rdr.GetInt32(rdr.GetOrdinal("Status"));
items.Add(info);
}
}
return(items);
}
/// <summary>
/// 用户角色修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int JueSe_U(EyouSoft.Model.MYongHuJueSeInfo info)
{
if (info == null ||
string.IsNullOrEmpty(info.GongSiId) ||
string.IsNullOrEmpty(info.CaoZuoRenId) ||
string.IsNullOrEmpty(info.Name) ||
string.IsNullOrEmpty(info.JueSeId))
{
return(0);
}
info.IssueTime = DateTime.Now;
int dalRetCode = dal.JueSe_U(info);
if (dalRetCode == 1)
{
var logInfo = new EyouSoft.Model.MCaoZuoLogInfo();
logInfo.BiaoTi = "修改用户角色";
logInfo.NeiRong = "修改用户角色，角色编号：" + info.JueSeId + "。";
logInfo.GuanLianId = info.JueSeId;
BCaoZuoLog.Log_C(logInfo);
}
return(dalRetCode);
}
