/// <summary> /// 增加一条数据 /// </summary> /// <returns>最后插入记录主键值</returns> public int Save(RoleActionInfo mod) { using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction tran = conn.BeginTransaction()) { try { using (DbCommand cmd = db.GetStoredProcCommand("SP_RoleAction_Add")) { db.AddInParameter(cmd, "@State", DbType.Int32, mod.State); db.AddInParameter(cmd, "@IsDeleted", DbType.Int32, mod.IsDeleted); db.AddInParameter(cmd, "@Sort", DbType.Int32, mod.Sort); int id = Convert.ToInt32(db.ExecuteScalar(cmd)); tran.Commit(); return(id); } } catch (Exception e) { tran.Rollback(); throw e; } finally { conn.Close(); } } } }
/// <summary> /// 更新数据 /// </summary> /// <param name="mod">RoleActionInfo</param> /// <returns>受影响行数</returns> public int Update(RoleActionInfo mod) { using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction tran = conn.BeginTransaction()) { try { using (DbCommand cmd = db.GetStoredProcCommand("SP_RoleAction_Update")) { db.AddInParameter(cmd, "@RoleID", DbType.Int32, mod.RoleID); db.AddInParameter(cmd, "@ActionID", DbType.Int32, mod.ActionID); db.AddInParameter(cmd, "@State", DbType.Int32, mod.State); db.AddInParameter(cmd, "@IsDeleted", DbType.Int32, mod.IsDeleted); db.AddInParameter(cmd, "@Sort", DbType.Int32, mod.Sort); tran.Commit(); return(db.ExecuteNonQuery(cmd)); } } catch (Exception e) { tran.Rollback(); throw e; } finally { conn.Close(); } } } }
/// <summary> /// 更新数据 /// </summary> /// <param name="mod">RoleActionInfo</param> /// <returns>受影响行数</returns> public int Update(RoleActionInfo mod) { using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction tran = conn.BeginTransaction()) { try { using (DbCommand cmd = db.GetStoredProcCommand("SP_RoleAction_Update")) { db.AddInParameter(cmd, "@RoleID", DbType.Int32, mod.RoleID); db.AddInParameter(cmd, "@ActionID", DbType.Int32, mod.ActionID); db.AddInParameter(cmd, "@State", DbType.Int32, mod.State); db.AddInParameter(cmd, "@IsDeleted", DbType.Int32, mod.IsDeleted); db.AddInParameter(cmd, "@Sort", DbType.Int32, mod.Sort); tran.Commit(); return db.ExecuteNonQuery(cmd); } } catch (Exception e) { tran.Rollback(); throw e; } finally { conn.Close(); } } } }
/// <summary> /// 根据分页获得数据列表 /// </summary> /// <param name="TbFields">返回字段</param> /// <param name="strWhere">查询条件</param> /// <param name="OrderField">排序字段</param> /// <param name="PageIndex">页码</param> /// <param name="PageSize">页尺寸</param> /// <param name="TotalCount">返回总记录数</param> /// <returns>IList<RoleActionInfo></returns> public IList <RoleActionInfo> Find(string tbFields, string strWhere, string orderField, int pageIndex, int pageSize, out int totalCount) { IList <RoleActionInfo> list = new List <RoleActionInfo>(); using (DbCommand cmd = db.GetStoredProcCommand("SP_SqlPagenation")) { db.AddInParameter(cmd, "@TbName", DbType.String, "RoleAction"); db.AddInParameter(cmd, "@TbFields", DbType.String, tbFields); db.AddInParameter(cmd, "@StrWhere", DbType.String, strWhere); db.AddInParameter(cmd, "@OrderField", DbType.String, orderField); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageIndex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pageSize); db.AddOutParameter(cmd, "@Total", DbType.Int32, int.MaxValue); using (DataTable dt = db.ExecuteDataSet(cmd).Tables[0]) { if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { RoleActionInfo model = new RoleActionInfo(); model.LoadFromDataRow(dr); list.Add(model); } } } totalCount = (int)db.GetParameterValue(cmd, "@Total"); return(list); } }
public ActionResult SetRoleAction(int RoleID, string ActID) { string result = "ok"; var model = roleActService.FirstOrDefault(c => c.RoleID == RoleID); try { if (model != null) //更新 { model.ActionID = ActID; roleActService.Save(); } else //添加 { RoleActionInfo model2 = new RoleActionInfo(); model2.RoleID = RoleID; model2.ActionID = ActID; roleActService.Save(); } } catch { result = "no"; } return(Content(result)); }
/// <summary> /// 增加一条数据 /// </summary> /// <returns>最后插入记录主键值</returns> public int Save(RoleActionInfo mod) { using (DbConnection conn = db.CreateConnection()) { conn.Open(); using (DbTransaction tran = conn.BeginTransaction()) { try { using (DbCommand cmd = db.GetStoredProcCommand("SP_RoleAction_Add")) { db.AddInParameter(cmd, "@State", DbType.Int32, mod.State); db.AddInParameter(cmd, "@IsDeleted", DbType.Int32, mod.IsDeleted); db.AddInParameter(cmd, "@Sort", DbType.Int32, mod.Sort); int id = Convert.ToInt32(db.ExecuteScalar(cmd)); tran.Commit(); return id; } } catch (Exception e) { tran.Rollback(); throw e; } finally { conn.Close(); } } } }
private void SerializeInternal(RoleActionInfo model, IDictionary<string, object> result) { result.Add("roleid", model.RoleID); result.Add("actionid", model.ActionID); result.Add("state", model.State); result.Add("isdeleted", model.IsDeleted); result.Add("sort", model.Sort); }
/// <summary> /// 获得实体 /// </summary> /// <param name="keyValue">编号</param> /// <returns>RoleActionInfo</returns> public RoleActionInfo Get(int keyValue) { RoleActionInfo model = null; using (DbCommand cmd = db.GetStoredProcCommand("SP_GetRecord")) { db.AddInParameter(cmd, "@TableName", DbType.String, "RoleAction"); db.AddInParameter(cmd, "@KeyName", DbType.String, "RoleID"); db.AddInParameter(cmd, "@KeyValue", DbType.Int32, keyValue); using (DataTable dt = db.ExecuteDataSet(cmd).Tables[0]) { if (dt.Rows.Count > 0) { model = new RoleActionInfo(); model.LoadFromDataRow(dt.Rows[0]); } } return(model); } }
public ActionResult GetCheckActMsg(int id) { List <int> list = new List <int>(); RoleActionInfo model = roleActService.FirstOrDefault(c => c.RoleID == id); if (model != null) { string str = model.ActionID; if (str.Length > 0) { string[] strN = str.Split(','); for (int i = 0; i < strN.Length; i++) { int n = int.Parse(strN[i]); list.Add(n); } } } return(Json(list, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据分页获得数据列表 /// </summary> /// <param name="TbFields">返回字段</param> /// <param name="strWhere">查询条件</param> /// <param name="OrderField">排序字段</param> /// <param name="PageIndex">页码</param> /// <param name="PageSize">页尺寸</param> /// <param name="TotalCount">返回总记录数</param> /// <returns>IList<RoleActionInfo></returns> public IList<RoleActionInfo> Find(string tbFields, string strWhere, string orderField, int pageIndex, int pageSize, out int totalCount) { IList<RoleActionInfo> list = new List<RoleActionInfo>(); using (DbCommand cmd = db.GetStoredProcCommand("SP_SqlPagenation")) { db.AddInParameter(cmd, "@TbName", DbType.String, "RoleAction"); db.AddInParameter(cmd, "@TbFields", DbType.String, tbFields); db.AddInParameter(cmd, "@StrWhere", DbType.String, strWhere); db.AddInParameter(cmd, "@OrderField", DbType.String, orderField); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageIndex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pageSize); db.AddOutParameter(cmd, "@Total", DbType.Int32, int.MaxValue); using (DataTable dt = db.ExecuteDataSet(cmd).Tables[0]) { if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { RoleActionInfo model = new RoleActionInfo(); model.LoadFromDataRow(dr); list.Add(model); } } } totalCount = (int)db.GetParameterValue(cmd, "@Total"); return list; } }
/// <summary> /// 获得实体 /// </summary> /// <param name="keyValue">编号</param> /// <returns>RoleActionInfo</returns> public RoleActionInfo Get(int keyValue) { RoleActionInfo model = null; using (DbCommand cmd = db.GetStoredProcCommand("SP_GetRecord")) { db.AddInParameter(cmd, "@TableName", DbType.String, "RoleAction"); db.AddInParameter(cmd, "@KeyName", DbType.String, "RoleID"); db.AddInParameter(cmd, "@KeyValue", DbType.Int32, keyValue); using (DataTable dt = db.ExecuteDataSet(cmd).Tables[0]) { if (dt.Rows.Count > 0) { model = new RoleActionInfo(); model.LoadFromDataRow(dt.Rows[0]); } } return model; } }