public Usermaproleinfo CreateUsermaproleinfo(Usermaproleinfo info)
{
try
{
Management.BeginTransaction();
Management.CreateUsermaproleinfo(info);
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Usermaproleinfo CreateUsermaproleinfo(Usermaproleinfo info)
{
try
{
string sqlCommand = @"INSERT INTO ""USERMAPROLEINFO"" (""USERID"",""ROLEID"",""LASTMODIFIEDDATE"",""LASTMODIFIEDBY"") VALUES (:Userid,:Roleid,:Lastmodifieddate,:Lastmodifiedby)";
this.Database.AddInParameter(":Userid", info.Userid);//DBType:VARCHAR2
this.Database.AddInParameter(":Roleid", info.Roleid);//DBType:VARCHAR2
this.Database.AddInParameter(":Lastmodifieddate", info.Lastmodifieddate);//DBType:DATE
this.Database.AddInParameter(":Lastmodifiedby", info.Lastmodifiedby);//DBType:VARCHAR2
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
///<summary>
///保存
///</summary>
///<param name="sender"></param>
///<param name="e"></param>
protected void BtnSave_Click(object sender, EventArgs e)
{
if (ddlRoleList.SelectedIndex == 0)
{
UIHelper.AlertMessage(this.UpdatePanel1, "请选择角色!");
return;
}
var ownRoles = UsermaproleinfoService.RetrieveUsermaproleinfoByUseridRoleid(
new List<string>() { UserId }, new List<string>());
if(ownRoles.Count>0)
{
UsermaproleinfoService.DeleteUsermaproleinfoByUseridRoleid(new List<string>(){UserId},new List<string>());
}
var mapRoleInfo=new Usermaproleinfo(){Lastmodifieddate =DateTime.Now,Roleid = ddlRoleList.SelectedValue,Userid = UserId};
if(WebContext.Current.CurrentUser!=null)
{
mapRoleInfo.Lastmodifiedby = WebContext.Current.CurrentUser.Username;
}
UsermaproleinfoService.CreateUsermaproleinfo(mapRoleInfo);
UIHelper.AlertMessageGoToURL(this.UpdatePanel1, "保存成功!", ResolveUrl("~/Admin/user_list.aspx"));
}
public Usermaproleinfo UpdateUsermaproleinfoByUseridRoleid(Usermaproleinfo info)
{
try
{
Management.BeginTransaction();
Management.UpdateUsermaproleinfoByUseridRoleid(info);
Management.Commit();
}
catch
{
Management.Rollback();
throw;
}
return info;
}
public Usermaproleinfo UpdateUsermaproleinfoByUseridRoleid(Usermaproleinfo info)
{
try
{
this.Database.AddInParameter(":Userid", info.Userid);//DBType:VARCHAR2
this.Database.AddInParameter(":Roleid", info.Roleid);//DBType:VARCHAR2
this.Database.AddInParameter(":Lastmodifieddate", info.Lastmodifieddate);//DBType:DATE
this.Database.AddInParameter(":Lastmodifiedby", info.Lastmodifiedby);//DBType:VARCHAR2
string sqlCommand = @"UPDATE ""USERMAPROLEINFO"" SET ""LASTMODIFIEDDATE""=:Lastmodifieddate , ""LASTMODIFIEDBY""=:Lastmodifiedby WHERE ""USERID""=:Userid AND ""ROLEID""=:Roleid";
this.Database.ExecuteNonQuery(sqlCommand);
}
finally
{
this.Database.ClearParameter();
}
return info;
}
