/// <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;
}
}
