/// <summary>
/// 提交角色编辑
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public ActionResult EditSysRole(Model.SysRole role)
{
using (EFContext db = new EFContext())
{
if (role.RoleID > 0)
{
bool HasRole = db.SysRole.Any(m => m.RoleCode == role.RoleCode && m.RoleID != role.RoleID);
if (HasRole)
{
return(FailResult(1, "系统已有此代码的角色，请修改角色代码"));
}
var dbSysRole = db.SysRole.Where(m => m.RoleID == role.RoleID).FirstOrDefault();
dbSysRole.RoleModified = DateTime.Now;
dbSysRole.RoleName = role.RoleName;
dbSysRole.RoleCode = role.RoleCode;
dbSysRole.RoleDesc = role.RoleDesc;
db.SaveChanges();
return(SuccessResult("修改成功"));
}
else
{
bool HasRole = db.SysRole.Any(m => m.RoleCode == role.RoleCode);
if (HasRole)
{
return(FailResult(1, "系统已有此代码的角色，请修改角色代码"));
}
db.SysRole.Add(role);
role.RoleCreate = DateTime.Now;
role.RoleModified = DateTime.Now;
LoggerHelper.Info("新增角色：" + GetContent(role), new cuser().usercode);
db.SaveChanges();
return(SuccessResult("添加成功"));
}
}
}
/// <summary>
/// 新增模块
/// </summary>
/// <returns>返回新增模块ID</returns>
/// <param name="Model">模块实体</param>
public int Insert(Model.SysRole Model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" if not exists(select Name from SysRole where Name =@Name ) begin ");
strSql.Append(" insert into SysRole(");
strSql.Append(" Name,Description,State)");
strSql.Append(" values (");
strSql.Append(" @Name,@Description,@State)");
strSql.Append(" ; select @@IDENTITY; ");
strSql.Append(" end ELSE begin SELECT -1 END");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("@State", SqlDbType.Bit, 1)
};
parameters[0].Value = Model.Name;
parameters[1].Value = Model.Description;
parameters[2].Value = Model.State;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public ActionResult New(int?id)
{
int RoleID = id == null ? 0 : (int)id;
Model.SysRole model = new Model.SysRole();
if (RoleID > 0)
{
model = Opr.GetEntity(RoleID);
ViewBag.Title = "正在编辑角色编号： " + model.RoleID;
}
else
{
model.RoleID = 0;
model.State = true;
ViewBag.Title = "后端管理系统-新增角色";
}
return(View(model));
}
/// <summary>
/// 修改模块
/// </summary>
/// <returns>返回影响行数</returns>
/// <param name="Model">模块实体</param>
public int ModifyModel(Model.SysRole Model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update SysRole ");
strSql.Append("Set Name=@Name,Description=@Description ");
strSql.Append("Where RoleID=@RoleID ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Model.RoleID;
parameters[1].Value = Model.Name;
parameters[2].Value = Model.Description;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
public void TestTran()
{
var insertModel = new Model.SysUserInfo()
{
uAddTime = DateTime.Now,
uDepId = 222,
uEmail = "@@#[email protected]",
uGender = false,
uIsDel = true,
uLoginName = "z1z16q",
uPwd = "jsdjf1iu",
uRemark = "cces12i1ff6fdx21"
};
//需要加tran
var res12 = _baseDAL.Insert(insertModel, true);
var res22 = _sysUserInfoDAL.Insert(insertModel, false);
var res33 = _sysUserInfoDAL.Delete(new Model.SysUserInfo()
{
uId = (int)res12
});
var roleModel = new Model.SysRole()
{
rDepId = 1229,
rName = "421d44",
rAddTime = DateTime.Now
};
var res44 = _sysRoleDAL.Insert(roleModel, true);
var res45 = _sysRoleDAL.Delete(new Model.SysRole()
{
rId = res44
});
Console.WriteLine(res12);
Console.WriteLine(res22);
Console.WriteLine(res33);
Console.WriteLine(res44);
Console.WriteLine(res45);
var i = 0;
insertModel.uDepId = 1 / i; //模拟出错
}
/// <summary>
/// 设置实体
/// </summary>
/// <returns>返回对象实体</returns>
/// <param name="dr">行</param>
private Model.SysRole SetEntity(DataRow dr)
{
Model.SysRole model = new Model.SysRole();
if (dr != null)
{
if (dr["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(dr["RoleID"].ToString());
}
model.Name = dr["Name"].ToString();
model.Description = dr["Description"].ToString();
if (dr.Table.Columns.Contains("RoleNum"))
{
if (dr["RoleNum"].ToString() != "")
{
model.RoleNum = int.Parse(dr["RoleNum"].ToString());
}
}
if (dr["State"].ToString() != "")
{
if ((dr["State"].ToString() == "1") || (dr["State"].ToString().ToLower() == "true"))
{
model.State = true;
}
else
{
model.State = false;
}
}
return(model);
}
else
{
return(null);
}
}
public ActionResult New(Model.SysRole model)
{
Helper.ResultInfo <int> rs = new Helper.ResultInfo <int>();
JsonResult jr = new JsonResult();
if (ModelState.IsValid)
{
if (model.RoleID > 0)
{
rs.Data = Opr.ModifyModel(model);
if (rs.Data > 0)
{
rs.Msg = "修改成功.";
rs.Result = true;
}
else
{
rs.Msg = "修改失败.";
rs.Result = false;
}
jr.Data = rs;
return(jr);
}
else
{
rs.Data = Opr.Insert(model);
if (rs.Data > 0)
{
rs.Msg = "新增成功.";
rs.Result = true;
}
else
{
rs.Msg = "新增失败.";
rs.Result = false;
}
jr.Data = rs;
return(jr);
}
}
else
{
System.Text.StringBuilder sbErrors = new System.Text.StringBuilder();
foreach (var item in ModelState.Values)
{
if (item.Errors.Count > 0)
{
for (int i = item.Errors.Count - 1; i >= 0; i--)
{
sbErrors.Append(item.Errors[i].ErrorMessage);
sbErrors.Append("<br/>");
}
}
}
rs.Data = 0;
rs.Msg = sbErrors.ToString();
rs.Result = false;
rs.Url = "";
jr.Data = rs;
return(jr);
}
}
/// <summary>
/// 修改模块
/// </summary>
/// <returns>返回影响行数</returns>
/// <param name="Model">模块实体</param>
public int ModifyModel(Model.SysRole Model)
{
return(dal.ModifyModel(Model));
}
/// <summary>
/// 新增模块
/// </summary>
/// <returns>返回新增模块ID</returns>
/// <param name="Model">模块实体</param>
public int Insert(Model.SysRole Model)
{
return(dal.Insert(Model));
}
/// <summary>
/// 展示调用
/// </summary>
public void Example()
{
#region Insert
var insertModel = new Model.SysUserInfo()
{
uAddTime = DateTime.Now,
uDepId = 2,
uEmail = "*****@*****.**",
uGender = false,
uId = 5,
uIsDel = true,
uLoginName = "zzq",
uPwd = "jsdjfiu",
uRemark = "ceshi1"
};
var res1 = _sysUserInfoBLL.Insert(insertModel, true);
insertModel.uGender = true;
insertModel.uEmail = "222@@@@qq.com";
insertModel.uLoginName = "lisi";
var res2 = _sysUserInfoBLL.Insert(insertModel, false);
Console.WriteLine(res1);
Console.WriteLine(res2);
var user_list = new List <SysUserInfo>
{
new SysUserInfo()
{
uId = 11, uAddTime = DateTime.Now, uDepId = 1, uLoginName = "3", uPwd = "1"
},
new SysUserInfo()
{
uId = 22, uAddTime = DateTime.Now, uDepId = 1, uLoginName = "1", uPwd = "2"
},
new SysUserInfo()
{
uId = 33, uAddTime = DateTime.Now, uDepId = 1, uLoginName = "2", uPwd = "2"
}
};
_baseDAL.BulkCopyToInsert(user_list);
#endregion
#region Update
var updateModel = new Model.SysUserInfo()
{
uAddTime = DateTime.Now.AddYears(2),
uDepId = 21,
uEmail = "*****@*****.**",
uGender = false,
uId = 102,
uIsDel = true,
uLoginName = "zzq23",
uPwd = "123456",
uRemark = "nihao"
};
var res3 = _sysUserInfoBLL.Update(updateModel);
Console.WriteLine(res3);
var dataParams = new DataParameters();
dataParams.Add <SysUserInfo>(p => p.uId, 3);
dataParams.Add <SysUserInfo>(p => p.uLoginName, "cwjl");
dataParams.Add <SysUserInfo>(p => p.uEmail, "*****@*****.**");
dataParams.AddUpdate <SysUserInfo>(p => p.uEmail, "*****@*****.**");
var r1 = _sysUserInfoDAL.UpdatePart <SysUserInfo>(dataParams);
Console.WriteLine(r1);
#endregion
#region Delete
var isOk1 = _sysUserInfoBLL.Delete(new Model.SysUserInfo()
{
uId = 4
});
Console.WriteLine(isOk1);
#endregion
#region Statistics
var res7 = _sysUserInfoDAL.Count <SysUserInfo>(new { udepid = 2 });
Console.WriteLine(res7);
#endregion
#region Query
//匿名类查询
var list_0 = _baseDAL.QueryList <SysUserInfo>(new { uId = 2 });
//dataParamseters多功能的使用
dataParams.Clear();
dataParams.Add <SysUserInfo>(p => p.uLoginName, "zzq");
dataParams.Add <SysUserInfo>(p => p.uRemark, "良", ConditionOperator.Like);
var list_1 = _baseDAL.QueryList <SysUserInfo>(dataParams);
dataParams.Clear();
dataParams.Add <SysUserInfo>(p => p.uLoginName, "zzq");
dataParams.Add <SysUserInfo>(p => p.uLoginName, "zzq", ConditionOperator.NotEqual); //可以多个同字段条件
dataParams.Add <SysUserInfo>(p => p.uEmail, "123");
dataParams.Add <SysUserInfo>(p => p.uRemark, "良", ConditionOperator.Like);
dataParams.AddBetween <SysUserInfo>(p => p.uId, 1, 2000);
var list_2 = _baseDAL.QueryList <SysUserInfo>(dataParams, selectFields: "uloginname");
var dict = new Dictionary <string, object>
{
{ "uloginname", "1zzq" },
{ "uEmail", "*****@*****.**" },
{ "uRemark", "nv100" }
};
var list_1_1 = _baseDAL.QueryList <SysUserInfo>(dict, selectFields: "uloginname,uRemark");
//连表使用
var mainSql = "select u.*,dep.depName from sysUserInfo as u join sysDepartment as dep on dep.depId=u.uDepId";
dataParams.Clear();
dataParams.Add <SysUserInfo>(p => p.uId, 2, tablePrefix: "u");
dataParams.Add <SysUserInfo>(p => p.uRemark, "hi", ConditionOperator.Like, tablePrefix: "u");
dataParams.Add <SysDepartment>(p => p.depId, 6, tablePrefix: "dep");
var list_2_1 = _baseDAL.QueryJoinList <UserInfoWithDep>(mainSql, dataParams, "u.uId asc");
//分页
dataParams.Clear();
dataParams.Add <SysUserInfo>(p => p.uId, 5, ConditionOperator.GreaterThan, tablePrefix: "u");
//dataParams.Add<SysUserInfo>(p => p.uRemark, "hi", ConditionOperator.Like, tablePrefix: "u");
//dataParams.Add<SysDepartment>(p => p.depId, 2, tablePrefix: "dep");
var pcp_n = new PageParameters()
{
PageIndex = 1,
PageSize = 10,
Select = "u.*,dep.depName",
Order = "u.uId asc",
Table = @"sysUserInfo as u join sysDepartment as dep on dep.depId=u.uDepId",
WhereParam = dataParams
};
var pageData = _baseDAL.PageList <UserInfoWithDep>(pcp_n);
#endregion
#region 存储过程
dataParams.Clear();
dataParams.Add("@channelId", 2, DbType.Int32);
dataParams.Add("outstr", "未知错误", DbType.String, direction: ParameterDirection.Output);
_baseDAL.ExecProcedure("sp_test", dataParams);
var outstr = dataParams.GetParamVal <string>("outstr");
Console.WriteLine(outstr);
#endregion
#region 事务
_baseDAL.ExecTransaction(() =>
{
var insertModel2 = new Model.SysUserInfo()
{
uAddTime = DateTime.Now,
uDepId = 2,
uEmail = "*****@*****.**",
uGender = false,
uIsDel = true,
uLoginName = "zz1q",
uPwd = "jsdjf1iu",
uRemark = "ces12i1fffdx21"
};
//需要加tran
var res12 = _sysUserInfoDAL.Insert(insertModel2, true);
var res22 = _sysUserInfoDAL.Insert(insertModel2, true);
var res33 = _sysUserInfoDAL.Delete(new Model.SysUserInfo()
{
uId = (int)res12
});
var roleModel = new Model.SysRole()
{
rDepId = 1,
rName = "444",
rAddTime = DateTime.Now
};
var res44 = _sysRoleDAL.Insert(roleModel, true);
//var res45 = SysRoleDAL.Delete(new Model.SysRole() { rId = res44 });
Console.WriteLine(res12);
Console.WriteLine(res22);
Console.WriteLine(res33);
//var i = 0;
//insertModel2.uDepId = 1 / i; //模拟出错
});
#endregion
#region 事务后在添加
insertModel = new Model.SysUserInfo()
{
uAddTime = DateTime.Now,
uDepId = 2,
uEmail = "*****@*****.**",
uGender = false,
uIsDel = true,
uLoginName = "zzq",
uPwd = "jsdjfiu",
uRemark = "ceshi1"
};
var res21 = _sysUserInfoDAL.Insert(insertModel, true);
#endregion
#region 表别名
var s = _sysRoleBLL.QueryModel <Model.SysRole>(new { });
//SysUserInfoDAL.QueryModel("ffff=11"); //模拟出错,MiniProfiler过滤器中会记录Errored=true
Console.WriteLine(s.rName);
#endregion
}
