/// <summary>
/// 保存
/// </summary>
/// <param name="roleInfo"></param>
/// <returns></returns>
public JsonResult SaveRole(SYS_ROLE roleInfo)
{
if (roleInfo == null)
{
return(Json(new { result = "error", mesage = "角色数据为空" }));
}
string errMsg = "";
if (roleInfo.ID == 0)
{
roleInfo.CREATETIME = DateTime.Now;
//add
roleBll.AddRole(roleInfo, ref errMsg);
//Common.LogHelper.InsertLog(String.Format("新增角色,ID-{0}", roleInfo.ID.ToString()), 52, "角色列表");
}
else
{
//edit
roleBll.EditRole(roleInfo, ref errMsg);
//Common.LogHelper.InsertLog(String.Format("编辑角色,ID-{0}", roleInfo.ID.ToString()), 52, "角色列表");
}
var result = new { result = "ok", message = "操作成功" };
if (!string.IsNullOrEmpty(errMsg))
{
result = new { result = "error", message = errMsg };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="roleInfo"></param>
/// <param name="errMsg"></param>
public void AddRole(SYS_ROLE roleInfo, ref string errMsg)
{
try
{
using (HISDataEntities appEntities = new HISDataEntities())
{
roleInfo.FLAG = 1;
roleInfo.CREATETIME = DateTime.Now;
//判断角色编码不能重复
var existRole = appEntities.SYS_ROLE.Where(o => (o.ROLENUM == roleInfo.ROLENUM || o.ROLENAME == roleInfo.ROLENAME) && o.FLAG != -1).FirstOrDefault();
if (existRole != null)
{
errMsg = "角色编码/名称不能重复";
return;
}
roleInfo.ROLENUM = CreateRoleNum(roleInfo);
appEntities.SYS_ROLE.Add(roleInfo);
appEntities.SaveChanges();
}
}
catch (Exception e)
{
errMsg = e.Message;
}
}
/// <summary>
/// 编辑角色
/// </summary>
/// <param name="roleInfo"></param>
/// <param name="errMsg"></param>
public void EditRole(SYS_ROLE roleInfo, ref string errMsg)
{
try
{
using (HISDataEntities appEntities = new HISDataEntities())
{
SYS_ROLE roleItem = appEntities.SYS_ROLE.Where(o => o.ID == roleInfo.ID).FirstOrDefault();
if (roleItem == null)
{
errMsg = "查无数据";
return;
}
//检查用户编码不能重复
if (appEntities.SYS_ROLE.Where(o => o.ROLENUM == roleInfo.ROLENUM && o.ID != roleInfo.ID).Count() > 0)
{
errMsg = "角色编码不能重复";
return;
}
roleItem.ROLENAME = roleInfo.ROLENAME;
roleItem.ROLENUM = roleInfo.ROLENUM;
//roleItem.Disc = roleInfo.Disc;
appEntities.SaveChanges();
}
}
catch (Exception e)
{
errMsg = e.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region 外部传入 非主键参数
#endregion
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request["ids"]))
{
SYS_ROLE roleOld = new SYS_ROLE();
roleOld.Where(SYS_ROLE.Attribute.ROLE_ID, Request["ids"].ToString());
listObj = BLLTable <SYS_ROLE> .Factory(conn).Select(valObj, roleOld);
for (int i = 0; i < listObj.Count; i++)
{
if (i > 0)
{
hidOld.Value += ",";
hidInitIDS.Value += ",";
}
hidOld.Value += "{ID:'" + listObj[i].ROLE_ID + "',Name:'" + listObj[i].ROLE_NAME + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].ROLE_ID;
}
}
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
Page.Title = title + LanguageService.GetLanguageString("Choose", "选择");
aspPager.PageSize = 15;
BindList(condObj, 1);
aspPager.CurrentPageIndex = 1;
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region �ⲿ���� ����������
#endregion
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request["ids"]))
{
SYS_ROLE roleOld = new SYS_ROLE();
roleOld.Where(SYS_ROLE.Attribute.ROLE_ID, Request["ids"].ToString());
listObj = BLLTable<SYS_ROLE>.Factory(conn).Select(valObj, roleOld);
for (int i = 0; i < listObj.Count; i++)
{
if (i > 0)
{
hidOld.Value += ",";
hidInitIDS.Value += ",";
}
hidOld.Value += "{ID:'" + listObj[i].ROLE_ID + "',Name:'" + listObj[i].ROLE_NAME + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].ROLE_ID;
}
}
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
Page.Title = title + LanguageService.GetLanguageString("Choose", "ѡ��");
aspPager.PageSize = 15;
BindList(condObj, 1);
aspPager.CurrentPageIndex = 1;
}
}
private void dgvrole_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
SYS_ROLE roleobj = new SYS_ROLE();
if (dgvrole.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == null)
{
MessageBox.Show("请输入角色名称！", "系统提示");
//dgvrole.CurrentCell = dgvrole[e.RowIndex,e.ColumnIndex];
return;
}
//判断编辑前后的值是否一样（是否修改了内容）
if (Object.Equals(cellTempValue, dgvrole.Rows[e.RowIndex].Cells[e.ColumnIndex].Value))
{
return;
}
//判断用户是否确定修改
//if (MessageBox.Show("确定要修改吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.None) != DialogResult.OK)
//{
// dgvrole.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = cellTempValue;
// return;
//}
//dgvrole.Columns[0].DataPropertyName; //所选单元格列名
roleobj.ROLE_NAME = dgvrole.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); //所选单元格修改后的值
roleobj.ROLE_CODE = dgvrole.Rows[e.RowIndex].Cells[1].Value.ToString();
roleobj.ID = Convert.ToInt32(dgvrole.Rows[e.RowIndex].Cells[2].Value);
blls.Update(roleobj);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <SYS_ROLE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<SYS_ROLE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnSetPageNum_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageNum.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <SYS_ROLE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnSetPageNum_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageNum.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<SYS_ROLE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
private void BindList(SYS_ROLE condObj)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(SYS_ROLE.Attribute.ROLE_ID, Order.Desc);
listObj = BLLTable<SYS_ROLE>.Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
private void BindList(SYS_ROLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(SYS_ROLE.Attribute.ROLE_ID, Order.Desc);
}
listObj = BLLTable <SYS_ROLE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
private void BindList(SYS_ROLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
condObj.af_PageBy(SYS_ROLE.Attribute.ROLE_ID, Order.Desc);
condObj.PID = decimal.Parse(pid);
listObj = BLLTable<SYS_ROLE>.Factory(conn).SelectByPage(valObj, condObj, 20, curPage, ref recount);
cdcatalog.DataSource = listObj;
cdcatalog.DataBind();
// aspPager.RecordCount = recount; hidCondition.Value = condObj.ToJson(20);
}
private void BindList(SYS_ROLE condObj)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(SYS_ROLE.Attribute.ROLE_ID, Order.Desc);
}
listObj = BLLTable <SYS_ROLE> .Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
public ActionResult Edit(string id)
{
int ID = int.Parse(id);
SYS_ROLE Role = DA_Role.Instance.GetById(ID);
if (Role == null)
{
return(HttpNotFound());
}
RepairToShow(ID);
return(View(Role));
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new SYS_ROLE();
if(txtROLE_NAME.Value !="" )
condObj.Like(SYS_ROLE.Attribute.ROLE_NAME, Convert.ToString(txtROLE_NAME.Value));
if(txtCREATER.Value !="" )
condObj.Like(SYS_ROLE.Attribute.CREATER, Convert.ToString(txtCREATER.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
public string GetRoleNameFromID(int RoleID)
{
string name = "";
using (var context = (HRM_ROHTOEntities)Activator.CreateInstance(typeof(HRM_ROHTOEntities), _connectionStr))
{
SYS_ROLE role = context.SYS_ROLE.FirstOrDefault(m => m.RoleID == RoleID);
if (role != null)
{
name = role.RoleName;
}
}
return(name);
}
//加载页面
private void yonghuliebiao_Load_1(object sender, EventArgs e)
{
IList <SYS_ROLE> listrole = rolebll.GetList();
SYS_ROLE role = new SYS_ROLE();
role.ROLE_CODE = "";
role.ROLE_NAME = "全部";
listrole.Add(role);
comboBox2.DataSource = listrole;
comboBox2.DisplayMember = "role_name";
comboBox2.ValueMember = "role_code";
comboBox2.SelectedValue = "";
jiazaiList();
}
private void BindList(SYS_ROLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(SYS_ROLE.Attribute.ROLE_ID, Order.Desc);
}
condObj.PID = decimal.Parse(pid);
listObj = BLLTable <SYS_ROLE> .Factory(conn).SelectByPage(valObj, condObj, 20, curPage, ref recount);
cdcatalog.DataSource = listObj;
cdcatalog.DataBind();
// aspPager.RecordCount = recount; hidCondition.Value = condObj.ToJson(20);
}
//验证
private static bool ValidateCUS(SYS_ROLE role, out string errmsg)
{
errmsg = "";
if (role == null)
{
errmsg = "参数错误！";
return(false);
}
if (string.IsNullOrEmpty(role.ROLE_NAME))
{
errmsg = "角色名称不能为空！";
return(false);
}
return(true);
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new SYS_ROLE();
if (txtROLE_NAME.Value != "")
{
condObj.Like(SYS_ROLE.Attribute.ROLE_NAME, Convert.ToString(txtROLE_NAME.Value));
}
if (txtCREATER.Value != "")
{
condObj.Like(SYS_ROLE.Attribute.CREATER, Convert.ToString(txtCREATER.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
////// <summary>
////// 分页查询
////// </summary>
////// <param name="pageIndex"></param>
////// <param name="pageSize"></param>
////// <param name="whLamdba"></param>
////// <param name="recordCount"></param>
////// <param name="pageCount"></param>
////// <returns></returns>
///public List<SYS_ROLE> PageQuery<TKey>(int pageIndex, int pageSize, Expression<Func<SYS_ROLE, bool>> whLamdba,Expression<Func<SYS_ROLE, TKey>> orderByLamdba, out int recordCount, out int pageCount)
///{
/// List<SYS_ROLE> list = null;
/// try
/// {
/// if (pageIndex == 0)
/// {
/// pageIndex = 1;
/// }
/// list = idal.PageQuery(pageIndex, pageSize, out recordCount, out pageCount, whLamdba, orderByLamdba);
/// }
/// catch (Exception ex)
/// {
/// recordCount = 0;
/// pageCount = 0;
/// Logger.Error(string.Format("SYS_ROLE_BLL 分页查询异常，异常信息：{0}", ex.ToString()));
/// }
/// return list;
///}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="modle"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public DataTable PageQuery(SYS_ROLE modle, int pageIndex, int pageSize, out int recordCount, out int pageCount)
{
DataTable dt = new DataTable();
using (var dbcontext = DbFactory.Create())
{
try
{
SearchCondition condition = new SearchCondition();
if (modle != null)
{
#region 组装查询条件
//if (!string.IsNullOrWhiteSpace(modle.PlayerNickname))
//{
// condition.AddCondition("a.PlayerNickname", modle.PlayerNickname, SqlOperator.Like, true);
//}
#endregion
}
PagerInfo pager = new PagerInfo();
#region 组装存储过程调用参数
//pager.curPage = pageIndex;
//pager.pageSize = pageSize;
//pager.isDescending = true;
//pager.fields = "a.*,c.GameName";
//pager.sortField = "a.UploadTime";
//pager.indexField = "a.ID";
//pager.where = null;
//pager.condition = condition;
//pager.tableName = "[ZhpGame].[dbo].[Zhp_GameRecord] a left join [Zhp_OnlineGame] b on a.Gameid=b.Gameid left join [Zhp_GameConfig] c on b.GameCode= c.GameCode ";
#endregion
dt = dbcontext.PageQuery(pager, out recordCount, out pageCount);
}
catch (Exception ex)
{
recordCount = 0;
pageCount = 0;
Logger.Error(string.Format("SYS_ROLE_BLL 分页查询异常，异常信息：{0}", ex.ToString()));
}
}
return(dt);
}
public string addOrUpdateRole()
{
log.Info("RoleInfo:" + Request["r_roleid"] + ",Name=" + Request["r_name"]);
SYS_ROLE r = new SYS_ROLE();
r.ROLE_ID = Request["r_roleid"];
r.ROLE_NAME = Request["r_name"];
if (userService.addOrUpdateRole(r) > 0)
{
return("更新成功!!");
}
else
{
return("更新失敗!!");
}
}
/// <summary>
/// 获取分页用户角色
/// </summary>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">每页显示的记录数</param>
/// <param name="name">用于检索的记录数</param>
/// <param name="userId">用户Id</param>
/// <param name="count"></param>
/// <returns>返回角色列表页</returns>
public List <SYS_ROLE> GetAppUserRoleList(int pageIndex, int pageSize, string name, int userId, ref int count)
{
try
{
using (HISDataEntities appEntities = new HISDataEntities())
{
var query = (from a in appEntities.SYS_ROLE
join b in appEntities.SYS_USERROLEMAPPING on a.ID equals b.ROLEID
join c in appEntities.SYS_USERINFO on b.USERID equals c.ID
where b.USERID == userId && a.FLAG == 1
select new { a });
if (query == null)
{
count = 0;
return(null);
}
//筛选
query = query.Where(o => o.a.ROLENAME.Contains(name));
count = query.Count();
//分页
query = query.OrderByDescending(o => o.a.CREATETIME).Skip((pageIndex - 1) * pageSize).Take(pageSize);
List <SYS_ROLE> roleList = new List <SYS_ROLE>();
foreach (var item in query)
{
SYS_ROLE model = new SYS_ROLE();
model.ID = item.a.ID;
model.ROLENAME = item.a.ROLENAME;
model.ROLENUM = item.a.ROLENUM;
model.CREATETIME = item.a.CREATETIME;
model.FLAG = item.a.FLAG;
//model.Disc = item.a.Disc;
roleList.Add(model);
}
return(roleList);
}
}
catch (Exception e)
{
count = 0;
return(null);
}
}
/// <summary>
/// 根据主键获取实体
/// </summary>
/// <param name="pkId">主键</param>
/// <returns></returns>
public SYS_ROLE GetById(string pkId)
{
SYS_ROLE model = null;
using (var dbcontext = DbFactory.Create())
{
try
{
int id = Convert.ToInt32(pkId);
Expression <Func <SYS_ROLE, bool> > exp = a => a.RoleID == id;
model = dbcontext.Get(exp);
}
catch (Exception ex)
{
Logger.Error(string.Format("SYS_ROLE_BLL 根据主键获取实体异常,异常信息:{0}", ex.ToString()));
}
}
return(model);
}
private string CreateRoleNum(SYS_ROLE role)
{
string actionCount = "01";
string menuNum = "RE";
SYS_ROLE lastMenu = null;
using (HISDataEntities hisEntities = new HISDataEntities())
{
//查询菜单下最大编号不包括自己和已经删除的
lastMenu = hisEntities.SYS_ROLE.OrderByDescending(o => o.ROLENUM).FirstOrDefault();
}
if (lastMenu != null)
{
var str = lastMenu.ROLENUM.Substring(lastMenu.ROLENUM.Length - 2, 2);
int number = Convert.ToInt32(str) + 1;
actionCount = number.ToString().PadLeft(2, '0');
}
return(menuNum + actionCount);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["PID"] != null)
{
pid = Request["PID"];
}
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
txtCREATER.Value = userBase.RealName;
try
{
if (keyid != "")
{
valObj = BLLTable <SYS_ROLE> .Factory(conn).GetRowData(SYS_ROLE.Attribute.ROLE_ID, keyid);
if (valObj == null)
{
return;
}
txtROLE_ID.Value = Convert.ToString(valObj.ROLE_ID); //Convert.ToInt32
txtROLE_NAME.Value = Convert.ToString(valObj.ROLE_NAME); //Convert.ToString
txtCREATER.Value = Convert.ToString(valObj.CREATER); //Convert.ToString
txtSNAME.Value = Convert.ToString(valObj.SNAME); //Convert.ToString
txtRNAME.Value = Convert.ToString(valObj.RNAME); //Convert.ToString
// txtADDTIME.Value = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd HH:mm");
}
}
catch (Exception ex)
{
lbInfo.Text = ex.Message;
}
}
}
//新增角色
public int addOrUpdateRole(SYS_ROLE role)
{
int i = 0;
using (var context = new topmepEntities())
{
try
{
context.SYS_ROLE.AddOrUpdate(role);
i = context.SaveChanges();
}
catch (Exception e)
{
logger.Error("add new role fail:" + e.ToString());
logger.Error(e.StackTrace);
message = e.Message;
}
}
return(i);
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="model">新实体</param>
/// <returns></returns>
public bool Edit(SYS_ROLE model)
{
bool success = false;
using (var dbcontext = DbFactory.Create())
{
try
{
dbcontext.Update(model);
dbcontext.Save();
success = true;
}
catch (Exception ex)
{
success = false;
Logger.Error(string.Format("SYS_ROLE_BLL 编辑记录异常,异常信息:{0}", ex.ToString()));
}
}
return(success);
}
/// <summary>
/// 角色弹窗编辑
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ActionResult Dialog(int Id)
{
if (Id < 1)
{
SYS_ROLE r = new SYS_ROLE()
{
ROLENUM = "自动生成"
};
return(View(r));
}
string errMsg = string.Empty;
SYS_ROLE role = roleBll.GetAppRoleByID(Id, ref errMsg);
if (!string.IsNullOrEmpty(errMsg))
{
return(View(new SYS_ROLE()));
}
return(View(role));
}
/// <summary>
/// 根据条件获取列表
/// </summary>
/// <param name="querymodel">条件</param>
/// <returns></returns>
public List <SYS_ROLE> GetList(SYS_ROLE querymodel)
{
List <SYS_ROLE> list = null;
using (var dbcontext = DbFactory.Create())
{
try
{
int id = Convert.ToInt32(querymodel.RoleID);
Expression <Func <SYS_ROLE, bool> > exp = a => a.RoleID == id;
Expression <Func <SYS_ROLE, bool> > temp = a => 1 == 1;
exp = CompileLinqSearch.AndAlso(exp, temp);
list = dbcontext.Find(exp);
}
catch (Exception ex)
{
Logger.Error(string.Format("SYS_ROLE_BLL 根据条件获取列表异常,异常信息:{0}", ex.ToString()));
}
}
return(list);
}
public void jiazaiList()
{
Cursor.Current = Cursors.WaitCursor;
IList <SYS_USERS> userlist = bll.GetList(textBox1.Text.Trim(), textBox2.Text.Trim(), comboBox2.SelectedValue.ToString());
dgvConditionTreatRecordList.Rows.Clear();//清空列表
try
{
if (userlist != null && userlist.Count > 0)
{
int i = 1;
foreach (SYS_USERS csobj in userlist)
{
string role_name = "";
SYS_ROLE _Role = rolebll.GetByCode(csobj.ROLE_CODE);
if (_Role != null)
{
role_name = _Role.ROLE_NAME;
}
else
{
role_name = csobj.ROLE_CODE;
}
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgvConditionTreatRecordList, new DataGridViewCheckBoxCell().Value, i.ToString(), csobj.USER_CODE
, csobj.USER_NAME, csobj.DEPT_NAME, csobj.DEPT_ID, csobj.PHONE, role_name, csobj.ADDRESS);
row.Tag = csobj;
dgvConditionTreatRecordList.Rows.Add(row);
i++;
}
}
}
finally
{
dgvConditionTreatRecordList.ClearSelection();
Cursor.Current = Cursors.Default;
}
}
/// <summary>
/// 根据ID获取系统角色
/// </summary>
/// <param name="Id"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public SYS_ROLE GetAppRoleByID(int Id, ref string errMsg)
{
try
{
using (HISDataEntities appEntities = new HISDataEntities())
{
SYS_ROLE role = appEntities.SYS_ROLE.Where(o => o.ID == Id).FirstOrDefault();
if (role == null)
{
errMsg = "查无数据";
return(null);
}
return(role);
}
}
catch (Exception e)
{
errMsg = e.Message;
return(null);
}
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="RoleInfo"></param>
/// <returns></returns>
public static AjaxMsgModel Add(SYS_ROLE RoleInfo)
{
AjaxMsgModel amm = new Message().NewAmm;
if (oc.BllSession.ISYS_ROLEService.Entities.Where(m => m.NAME == RoleInfo.NAME).Count() > 0)
{
amm.Statu = AjaxStatu.err;
amm.Msg = string.Format(Message.YesFound, "角色名");
return(amm);
}
if (oc.BllSession.ISYS_ROLEService.AddEntity(RoleInfo) > 0)
{
amm.Statu = AjaxStatu.ok;
amm.Msg = string.Format(Message.OptSussess, "角色", Message.AddOpt);
}
else
{
amm.Statu = AjaxStatu.err;
amm.Msg = string.Format(Message.OptFail, "角色", Message.AddOpt);
}
return(amm);
}
/// <summary>
/// 修改角色
/// </summary>
/// <param name="RoleInfo">角色</param>
/// <returns>AjaxMsgModel实体对象</returns>
public static AjaxMsgModel Edit(SYS_ROLE RoleInfo)
{
AjaxMsgModel amm = new Message().NewAmm;
try
{
int returnValue = 0;
using (TransactionScope ts = new TransactionScope())
{
returnValue = oc.BllSession.ISYS_ROLE_MENU_MAPService.DelByWhere(m => m.ROLE_ID == RoleInfo.ROLE_ID);
returnValue = oc.BllSession.ISYS_ROLE_MENUOPT_MAPService.DelByWhere(m => m.ROLE_ID == RoleInfo.ROLE_ID);
returnValue = oc.BllSession.ISYS_ROLE_MENU_MAPService.AddListEntity(RoleInfo.SYS_ROLE_MENU_MAP.ToList());
returnValue = oc.BllSession.ISYS_ROLE_MENUOPT_MAPService.AddListEntity(RoleInfo.SYS_ROLE_MENUOPT_MAP.ToList());
//Expression<Func<SYS_ROLE, object>>[] ignoreProperties =
// new Expression<Func<SYS_ROLE, object>>[] { p => p.SYS_ROLE_MENU_MAP, p => p.SYS_ROLE_MENUOPT_MAP, p => p.SYS_USER_ROLE_MAP };
returnValue = oc.BllSession.ISYS_ROLEService.UpdateEntity(RoleInfo, new string[] { "NAME", "NOTE" });
ts.Complete();
}
if (returnValue > 0)
{
amm.Statu = AjaxStatu.ok;
amm.Msg = string.Format(Message.OptSussess, "角色", Message.EditOpt);
}
else
{
amm.Statu = AjaxStatu.err;
amm.Msg = string.Format(Message.OptFail, "角色", Message.EditOpt);
}
}
catch (Exception)
{
return(amm);
}
return(amm);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonItem1_Click(object sender, EventArgs e)
{
SYS_ROLE role = new SYS_ROLE();
role.ROLE_NAME = "";
int code = 0;
if (dgvrole.Rows.Count >= 1)
{
code = Convert.ToInt32(dgvrole.Rows[dgvrole.Rows.Count - 1].Cells[1].Value.ToString());
}
if (code < 10)
{
role.ROLE_CODE = "0" + (code + 1).ToString();
}
else
{
role.ROLE_CODE = (code + 1).ToString();
}
if (blls.Add(role))
{
loadRole();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["PID"] != null)
{
pid = Request["PID"];
}
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
txtCREATER.Value = userBase.RealName;
try
{
if (keyid!="")
{
valObj = BLLTable<SYS_ROLE>.Factory(conn).GetRowData(SYS_ROLE.Attribute.ROLE_ID, keyid);
if(valObj==null) return ;
txtROLE_ID.Value = Convert.ToString(valObj.ROLE_ID);//Convert.ToInt32
txtROLE_NAME.Value = Convert.ToString(valObj.ROLE_NAME);//Convert.ToString
txtCREATER.Value = Convert.ToString(valObj.CREATER);//Convert.ToString
txtSNAME.Value = Convert.ToString(valObj.SNAME);//Convert.ToString
txtRNAME.Value = Convert.ToString(valObj.RNAME);//Convert.ToString
// txtADDTIME.Value = (valObj.ADDTIME == DateTime.MinValue) ? "" : valObj.ADDTIME.ToString("yyyy-MM-dd HH:mm");
}
}
catch (Exception ex)
{
lbInfo.Text = ex.Message;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
SYS_ROLE valObj = new SYS_ROLE();
if (txtROLE_ID.Value != "")
valObj.ROLE_ID = Convert.ToInt32(txtROLE_ID.Value);
valObj.ROLE_NAME = Convert.ToString(txtROLE_NAME.Value);
//valObj.CREATER = Convert.ToString(txtCREATER.Value);
valObj.SNAME = Convert.ToString(txtSNAME.Value);
valObj.RNAME = Convert.ToString(txtRNAME.Value);
if (keyid!="")
{
valObj.ROLE_ID = Convert.ToInt32(keyid);
count = RoleHelper.EditRole(valObj);// BLLTable<SYS_ROLE>.Factory(conn).Update(valObj, SYS_ROLE.Attribute.ROLE_ID);
}
else
{
valObj.CREATIME = DateTime.Now;
keyid = RoleHelper.AddRole(valObj, pid);
count = keyid == "" ? 0 : 1;// BLLTable<SYS_ROLE>.Factory(conn).Insert(valObj, SYS_ROLE.Attribute.ROLE_ID);
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
if (lstCol[i] == SYS_ROLE.Attribute.CREATIME) {
continue;
}
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
string re = "re";
if (pid != "")
{
re = "ROLEManage.aspx?PID=" + pid;
}
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + re + "';}else{window.returnValue = '" + re + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + re + "';}else{window.returnValue = '" + re + "';}window.close();", true);
}
}
else
{
txtROLE_NAME.Value = "";
txtCREATER.Value = "";
ViewState["hadSave"] = 1;
}
}
}
catch (Exception ex)
{
lbInfo.Text = ex.Message;
}
}
private void BindList(SYS_ROLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(SYS_ROLE.Attribute.ROLE_ID, Order.Desc);
listObj = BLLTable<SYS_ROLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
