private bool Save(out string strMessage) { Boolean result = false; strMessage = string.Empty; Model_SysRole mcd = setModel(check_dict_id); try { if (check_dict_id != "") { if (CheckExists(mcd, "2")) { strMessage = "已存在此项。"; } else { //MS.Authority.clsAuth.AddLogFromBS("Drug_CheckAddOrUpdate", "【修改】【SysRole字典】【操作人】" + txtUserName.Text.Trim() + "【操作内容】:" + mcd.SysRole_Name + ""); result = dal.UpdateSysRoleByID(mcd); if (result) { StringBuilder strLog = new StringBuilder(); strLog.AppendFormat("【修改角色】【ID】: {0}【角色名】:{1} ", mcd.SysRole_ID, mcd.SysRole_Name); new BLL_clsAuth().AddLogFromBS(Module_Id, strLog.ToString()); } } } else { if (txtName.Text.Trim() != "") { if (CheckExists(mcd, "1")) { strMessage = "已存在此项。"; } else { //MS.Authority.clsAuth.AddLogFromBS("Drug_CheckAddOrUpdate", "【添加】【SysRole字典】【操作人】" + txtUserName.Text.Trim() + "【操作内容】:" + mcd.SysRole_Name + ""); result = dal.AddSysRole(mcd); if (result) { StringBuilder strLog = new StringBuilder(); strLog.AppendFormat("【添加角色】【ID】: {0}【角色名】:{1} ", mcd.SysRole_ID, mcd.SysRole_Name); new BLL_clsAuth().AddLogFromBS(Module_Id, strLog.ToString()); } } } else { strMessage = "名称为空。"; result = false; } } } catch { throw; } return(result); }
public bool Update(Model_SysRole model) { StringBuilder builder = new StringBuilder(); builder.Append("update SysRole set "); builder.Append("SysRole_ID=@SysRole_ID,"); builder.Append("SysRole_Name=@SysRole_Name,"); builder.Append("SysRole_Order=@SysRole_Order,"); builder.Append("SysRole_Enable=@SysRole_Enable,"); builder.Append("SysRole_Remark=@SysRole_Remark,"); builder.Append("CreateTime=@CreateTime,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("UpdateTime=@UpdateTime,"); builder.Append("UpdateUser=@UpdateUser"); builder.Append(" where "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysRole_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysRole_Name", SqlDbType.NVarChar, 100), new SqlParameter("@SysRole_Order", SqlDbType.Int, 4), new SqlParameter("@SysRole_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysRole_Remark", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.SysRole_ID; cmdParms[1].Value = model.SysRole_Name; cmdParms[2].Value = model.SysRole_Order; cmdParms[3].Value = model.SysRole_Enable; cmdParms[4].Value = model.SysRole_Remark; cmdParms[5].Value = model.CreateTime; cmdParms[6].Value = model.CreateUser; cmdParms[7].Value = model.UpdateTime; cmdParms[8].Value = model.UpdateUser; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_SysRole GetSysRoleModel(string SysRole_ID) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 * from SysRole "); builder.Append(" where SysRole_ID=@SysRole_ID "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysRole_ID", SqlDbType.Char, 0x24) }; cmdParms[0].Value = SysRole_ID; Model_SysRole role = new Model_SysRole(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return(null); } if ((set.Tables[0].Rows[0]["SysRole_ID"] != null) && (set.Tables[0].Rows[0]["SysRole_ID"].ToString() != "")) { role.SysRole_ID = set.Tables[0].Rows[0]["SysRole_ID"].ToString(); } if ((set.Tables[0].Rows[0]["SysRole_Name"] != null) && (set.Tables[0].Rows[0]["SysRole_Name"].ToString() != "")) { role.SysRole_Name = set.Tables[0].Rows[0]["SysRole_Name"].ToString(); } if ((set.Tables[0].Rows[0]["SysRole_Order"] != null) && (set.Tables[0].Rows[0]["SysRole_Order"].ToString() != "")) { role.SysRole_Order = new int?(int.Parse(set.Tables[0].Rows[0]["SysRole_Order"].ToString())); } if ((set.Tables[0].Rows[0]["SysRole_Enable"] != null) && (set.Tables[0].Rows[0]["SysRole_Enable"].ToString() != "")) { if ((set.Tables[0].Rows[0]["SysRole_Enable"].ToString() == "1") || (set.Tables[0].Rows[0]["SysRole_Enable"].ToString().ToLower() == "true")) { role.SysRole_Enable = true; } else { role.SysRole_Enable = false; } } if ((set.Tables[0].Rows[0]["SysRole_Remark"] != null) && (set.Tables[0].Rows[0]["SysRole_Remark"].ToString() != "")) { role.SysRole_Remark = set.Tables[0].Rows[0]["SysRole_Remark"].ToString(); } if ((set.Tables[0].Rows[0]["CreateTime"] != null) && (set.Tables[0].Rows[0]["CreateTime"].ToString() != "")) { role.CreateTime = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["CreateTime"].ToString())); } if ((set.Tables[0].Rows[0]["CreateUser"] != null) && (set.Tables[0].Rows[0]["CreateUser"].ToString() != "")) { role.CreateUser = set.Tables[0].Rows[0]["CreateUser"].ToString(); } if ((set.Tables[0].Rows[0]["UpdateTime"] != null) && (set.Tables[0].Rows[0]["UpdateTime"].ToString() != "")) { role.UpdateTime = new DateTime?(DateTime.Parse(set.Tables[0].Rows[0]["UpdateTime"].ToString())); } if ((set.Tables[0].Rows[0]["UpdateUser"] != null) && (set.Tables[0].Rows[0]["UpdateUser"].ToString() != "")) { role.UpdateUser = set.Tables[0].Rows[0]["UpdateUser"].ToString(); } return(role); }
public List <Model_SysRole> DataTableToList(DataTable dt) { List <Model_SysRole> list = new List <Model_SysRole>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SysRole item = new Model_SysRole(); if ((dt.Rows[i]["SysRole_ID"] != null) && (dt.Rows[i]["SysRole_ID"].ToString() != "")) { item.SysRole_ID = dt.Rows[i]["SysRole_ID"].ToString(); } if ((dt.Rows[i]["SysRole_Name"] != null) && (dt.Rows[i]["SysRole_Name"].ToString() != "")) { item.SysRole_Name = dt.Rows[i]["SysRole_Name"].ToString(); } if ((dt.Rows[i]["SysRole_Order"] != null) && (dt.Rows[i]["SysRole_Order"].ToString() != "")) { item.SysRole_Order = new int?(int.Parse(dt.Rows[i]["SysRole_Order"].ToString())); } if ((dt.Rows[i]["SysRole_Enable"] != null) && (dt.Rows[i]["SysRole_Enable"].ToString() != "")) { if ((dt.Rows[i]["SysRole_Enable"].ToString() == "1") || (dt.Rows[i]["SysRole_Enable"].ToString().ToLower() == "true")) { item.SysRole_Enable = true; } else { item.SysRole_Enable = false; } } if ((dt.Rows[i]["SysRole_Remark"] != null) && (dt.Rows[i]["SysRole_Remark"].ToString() != "")) { item.SysRole_Remark = dt.Rows[i]["SysRole_Remark"].ToString(); } if ((dt.Rows[i]["CreateTime"] != null) && (dt.Rows[i]["CreateTime"].ToString() != "")) { item.CreateTime = new DateTime?(DateTime.Parse(dt.Rows[i]["CreateTime"].ToString())); } if ((dt.Rows[i]["CreateUser"] != null) && (dt.Rows[i]["CreateUser"].ToString() != "")) { item.CreateUser = dt.Rows[i]["CreateUser"].ToString(); } if ((dt.Rows[i]["UpdateTime"] != null) && (dt.Rows[i]["UpdateTime"].ToString() != "")) { item.UpdateTime = new DateTime?(DateTime.Parse(dt.Rows[i]["UpdateTime"].ToString())); } if ((dt.Rows[i]["UpdateUser"] != null) && (dt.Rows[i]["UpdateUser"].ToString() != "")) { item.UpdateUser = dt.Rows[i]["UpdateUser"].ToString(); } list.Add(item); } } return(list); }
/// <summary> /// 判断是否存在 /// </summary> /// <param name="type">1添加时,2修改时</param> /// <returns>已存在返回true</returns> private bool CheckExists(Model_SysRole mcd, string type) { try { return(new Rc.Cloud.BLL.BLL_SysRole().ExistsSysRole(mcd, type)); } catch (Exception) { return(true); } }
public Model_SysRole DataRowToModel(DataRow row) { Model_SysRole role = new Model_SysRole(); if (row != null) { if (row["SysRole_ID"] != null) { role.SysRole_ID = row["SysRole_ID"].ToString(); } if (row["SysRole_Name"] != null) { role.SysRole_Name = row["SysRole_Name"].ToString(); } if ((row["SysRole_Order"] != null) && (row["SysRole_Order"].ToString() != "")) { role.SysRole_Order = new int?(int.Parse(row["SysRole_Order"].ToString())); } if ((row["SysRole_Enable"] != null) && (row["SysRole_Enable"].ToString() != "")) { if ((row["SysRole_Enable"].ToString() == "1") || (row["SysRole_Enable"].ToString().ToLower() == "true")) { role.SysRole_Enable = true; } else { role.SysRole_Enable = false; } } if (row["SysRole_Remark"] != null) { role.SysRole_Remark = row["SysRole_Remark"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { role.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } if (row["CreateUser"] != null) { role.CreateUser = row["CreateUser"].ToString(); } if ((row["UpdateTime"] != null) && (row["UpdateTime"].ToString() != "")) { role.UpdateTime = new DateTime?(DateTime.Parse(row["UpdateTime"].ToString())); } if (row["UpdateUser"] != null) { role.UpdateUser = row["UpdateUser"].ToString(); } } return(role); }
public List <Model_SysRole> DataTableToList(DataTable dt) { List <Model_SysRole> list = new List <Model_SysRole>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SysRole item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
private Model_SysRole setModel(string Check_Dict_ID) { Model_SysRole mcd = new Model_SysRole(); if (Check_Dict_ID != "" && D_type == "") { mcd.SysRole_ID = Check_Dict_ID; mcd.SysRole_Name = txtName.Text.Trim(); mcd.CreateTime = DateTime.Now; } else { mcd.SysRole_ID = Guid.NewGuid().ToString(); mcd.SysRole_Name = txtName.Text.Trim(); mcd.CreateTime = DateTime.Now; } return(mcd); }
public bool ExistsSysRole(Model_SysRole mcd, string type) { StringBuilder builder = new StringBuilder(); bool flag = false; if (type == "1") { builder.AppendFormat("SELECT COUNT(*) FROM SysRole WHERE SysRole_Name='{0}'", mcd.SysRole_Name); } else if (type == "2") { builder.AppendFormat("SELECT COUNT(*) FROM SysRole WHERE SysRole_ID<>'{0}' and SysRole_Name='{1}'", mcd.SysRole_ID, mcd.SysRole_Name); } if (int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0) { flag = true; } return(flag); }
public bool Add(Model_SysRole model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SysRole("); builder.Append("SysRole_ID,SysRole_Name,SysRole_Order,SysRole_Enable,SysRole_Remark,CreateTime,CreateUser,UpdateTime,UpdateUser)"); builder.Append(" values ("); builder.Append("@SysRole_ID,@SysRole_Name,@SysRole_Order,@SysRole_Enable,@SysRole_Remark,@CreateTime,@CreateUser,@UpdateTime,@UpdateUser)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysRole_ID", SqlDbType.Char, 0x24), new SqlParameter("@SysRole_Name", SqlDbType.NVarChar, 100), new SqlParameter("@SysRole_Order", SqlDbType.Int, 4), new SqlParameter("@SysRole_Enable", SqlDbType.Bit, 1), new SqlParameter("@SysRole_Remark", SqlDbType.NVarChar, 0x3e8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@UpdateUser", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.SysRole_ID; cmdParms[1].Value = model.SysRole_Name; cmdParms[2].Value = model.SysRole_Order; cmdParms[3].Value = model.SysRole_Enable; cmdParms[4].Value = model.SysRole_Remark; cmdParms[5].Value = model.CreateTime; cmdParms[6].Value = model.CreateUser; cmdParms[7].Value = model.UpdateTime; cmdParms[8].Value = model.UpdateUser; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Add(Model_SysRole model) { return(this.dal.Add(model)); }
public bool Update(Model_SysRole model) { return(this.dal.Update(model)); }
public bool ExistsSysRole(Model_SysRole mcd, string type) { return(this.dal.ExistsSysRole(mcd, type)); }