public ActionResult UserOrgAdd(CIUserOrg userorg)
{
//CIUserOrg model = new CIUserOrg();
//model.OrgName = PressRequest.GetFormString("orgname");
//model.OrgCode = PressRequest.GetFormString("orgcode");
_userorgService.InsertUserOrg(userorg);
return(Redirect(Url.Action("UserOrgList", "UserOrg")));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="CIUserOrg"></param>
/// <returns></returns>
public int Delete(CIUserOrg CIUserOrg)
{
string cmdText = "DELETE FROM CIUserOrg WHERE OrgCode = @OrgCode";
using (var conn = new DapperHelper().OpenConnection())
{
return(conn.Execute(cmdText, CIUserOrg));
}
}
public ActionResult UserOrgEdit(CIUserOrg userorg)
{
//CIUserOrg model = new CIUserOrg();
//model.OrgName = userorg.OrgName;
//model.OrgCode = userorg.OrgCode;
var orgcode = PressRequest.GetFormString("hdOrgCode");
_userorgService.UpdateUserOrgBystringCode(userorg, orgcode);
return(Redirect(Url.Action("UserOrgList", "UserOrg")));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="CIUserOrg"></param>
/// <returns></returns>
public int Insert(CIUserOrg CIUserOrg)
{
string cmdText = @"INSERT INTO CIUserOrg (OrgName,OrgCode,ParentCode) VALUES
(@OrgName,@OrgCode,@ParentCode)";
using (var conn = new DapperHelper().OpenConnection())
{
return(conn.Execute(cmdText, CIUserOrg));
}
}
/// <summary>
/// 更新小组信息
/// </summary>
/// <param name="CIUserOrg"></param>
/// <returns></returns>
public int UpdateUserOrg(CIUserOrg userorg, string orgcode)
{
string cmdText = @"UPDATE CIUserOrg SET
OrgName = @OrgName ,
OrgCode = @OrgCode,
ParentCode = @ParentCode
WHERE OrgCode = '" + orgcode + "'";
using (var conn = new DapperHelper().OpenConnection())
{
return(conn.Execute(cmdText, userorg));
}
}
/// <summary>
/// 修改小组信息
/// </summary>
/// <param name="_userorg"></param>
/// <returns></returns>
public int UpdateUserOrgBystringCode(CIUserOrg _userorg, string OrgCode)
{
return(_userorgRepositotry.UpdateUserOrg(_userorg, OrgCode));
}
/// <summary>
/// 修改小组信息
/// </summary>
/// <param name="_userorg"></param>
/// <returns></returns>
public int UpdateUserOrg(CIUserOrg _userorg)
{
return(_userorgRepositotry.Update(_userorg));
}
/// <summary>
/// 添加小组
/// </summary>
/// <returns></returns>
public int InsertUserOrg(CIUserOrg _userorg)
{
return(_userorgRepositotry.Insert(_userorg));
}
