protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UsersId"] != null)
{
BLL.Users users = new BLL.Users();
Model.Users user = users.GetModel((int)Session["UsersId"]);
BLL.Roles roles = new BLL.Roles();
Model.Roles role = roles.GetModel(user.Fk_Roles_Id.Value);
BLL.PermisssionsNodes permisssionsNodes = new BLL.PermisssionsNodes();
List <Model.PermisssionsNodes> permisssionsNodesList = permisssionsNodes.GetModelList("Fk_Permissions_Id='" + role.Fk_Permissions_Id + "'");
List <Model.Nodes> nodes = new List <Model.Nodes>();
foreach (Model.PermisssionsNodes pn in permisssionsNodesList)
{
BLL.Nodes nodesBLL = new BLL.Nodes();
Model.Nodes node = nodesBLL.GetModel(pn.Fk_Nodes_Id.Value);
if (node != null)
{
if (node.ParentId == 0 && node.IsVisible == true)
{
nodes.Add(node);
}
}
}
Repeater1.DataSource = nodes.OrderBy(p => p.Orders).ToList();
Repeater1.DataBind();
}
}
}
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Repeater Repeater2 = e.Item.FindControl("Repeater2") as Repeater;
Label lblId = e.Item.FindControl("lblId") as Label;
//BLL.Nodes nodes = new BLL.Nodes();
//List<Model.Nodes> list = nodes.GetModelList("ParentId='" + lblId.Text + "' and IsVisible='True'").OrderBy(p => p.Orders).ToList();
BLL.Users users = new BLL.Users();
Model.Users user = users.GetModel((int)Session["UsersId"]);
BLL.Roles roles = new BLL.Roles();
Model.Roles role = roles.GetModel(user.Fk_Roles_Id.Value);
BLL.PermisssionsNodes permisssionsNodes = new BLL.PermisssionsNodes();
List <Model.PermisssionsNodes> permisssionsNodesList = permisssionsNodes.GetModelList("Fk_Permissions_Id='" + role.Fk_Permissions_Id + "'");
List <Model.Nodes> nodes = new List <Model.Nodes>();
foreach (Model.PermisssionsNodes pn in permisssionsNodesList)
{
BLL.Nodes nodesBLL = new BLL.Nodes();
Model.Nodes node = nodesBLL.GetModel(pn.Fk_Nodes_Id.Value);
if (node != null)
{
if (node.ParentId == int.Parse(lblId.Text) && node.IsVisible == true)
{
nodes.Add(node);
}
}
}
Repeater2.DataSource = nodes.OrderBy(p => p.Orders).ToList();
Repeater2.DataBind();
}
}
public static bool Insert(Model.Roles model)
{
string sb = "insert into Roles(RType,RName,CMessage,IsAdmin,CanSH,CanLogin,VState,Super,RColor) values (@RType,@RName,@CMessage,@IsAdmin,@CanSH,@CanLogin,@VState,@Super,@RColor);";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RType", SqlDbType.VarChar, 20),
new SqlParameter("@RName", SqlDbType.VarChar, 20),
new SqlParameter("@CMessage", SqlDbType.Bit, 1),
new SqlParameter("@IsAdmin", SqlDbType.Bit, 1),
new SqlParameter("@CanSH", SqlDbType.Bit, 1),
new SqlParameter("@CanLogin", SqlDbType.Bit, 1),
new SqlParameter("@VState", SqlDbType.Bit, 1),
new SqlParameter("@Super", SqlDbType.Bit, 1),
new SqlParameter("@RColor", SqlDbType.VarChar, 10)
};
para[0].Value = model.RType;
para[1].Value = model.RName;
para[2].Value = model.CMessage;
para[3].Value = model.IsAdmin;
para[4].Value = model.CanSH;
para[5].Value = model.CanLogin;
para[6].Value = model.VState;
para[7].Value = model.Super;
para[8].Value = model.RColor;
DAL.Roles.RolsList = null;
return(DbHelperSQL.ExecuteSql(sb, para) > 0);
}
private static Model.Roles TranEntity(DataRow dr)
{
Model.Roles model = new Model.Roles();
if (dr["RType"].ToString() != "")
{
model.RType = dr["RType"].ToString();
model.PowersList = DAL.RolePowers.GetList("RType='" + model.RType + "'");
}
if (dr["RName"].ToString() != "")
{
model.RName = dr["RName"].ToString();
}
if (dr["CMessage"].ToString() != "")
{
model.CMessage = bool.Parse(dr["CMessage"].ToString());
}
if (dr["IsAdmin"].ToString() != "")
{
model.IsAdmin = bool.Parse(dr["IsAdmin"].ToString());
}
if (dr["CanSH"].ToString() != "")
{
model.CanSH = bool.Parse(dr["CanSH"].ToString());
}
if (dr["CanLogin"].ToString() != "")
{
model.CanLogin = bool.Parse(dr["CanLogin"].ToString());
}
if (dr["VState"].ToString() != "")
{
model.VState = bool.Parse(dr["VState"].ToString());
}
if (dr["Super"].ToString() != "")
{
model.Super = bool.Parse(dr["Super"].ToString());
}
if (dr["RColor"].ToString() != "")
{
model.RColor = dr["RColor"].ToString();
}
if (dr["KeFu"].ToString() != "")
{
model.KeFu = bool.Parse(dr["KeFu"].ToString());
}
if (dr["CaiWu"].ToString() != "")
{
model.CaiWu = bool.Parse(dr["CaiWu"].ToString());
}
if (dr["XingZheng"].ToString() != "")
{
model.XingZheng = bool.Parse(dr["XingZheng"].ToString());
}
return(model);
}
public int UptRoles(Model.Roles a)
{
try
{
string sql = $"update Roles set RoleName='{a.RoleName}' where RoleId={a.RoleId})";
return(DapperHelper.Execute(sql));
}
catch (Exception)
{
throw;
}
}
public int AddRoles(Model.Roles a)
{
try
{
string sql = $"insert into Roles values (null,'{a.RoleName}')";
return(DapperHelper.Execute(sql));
}
catch (Exception)
{
throw;
}
}
public static bool Update(Model.Roles model)
{
StringBuilder sb = new StringBuilder("update Roles set ");
sb.Append("RType=@RType,");
sb.Append("RName=@RName,");
sb.Append("CMessage=@CMessage,");
sb.Append("IsAdmin=@IsAdmin,");
sb.Append("CanSH=@CanSH,");
sb.Append("CanLogin=@CanLogin,");
sb.Append("VState=@VState,");
sb.Append("Super=@Super,");
sb.Append("CaiWu=@CaiWu,");
sb.Append("XingZheng=@XingZheng,");
sb.Append("KeFu=@KeFu,");
sb.Append("RColor=@RColor");
sb.Append(" where ");
sb.Append("RType=@RType");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RType", SqlDbType.VarChar, 20),
new SqlParameter("@RName", SqlDbType.VarChar, 20),
new SqlParameter("@CMessage", SqlDbType.Bit, 1),
new SqlParameter("@IsAdmin", SqlDbType.Bit, 1),
new SqlParameter("@CanSH", SqlDbType.Bit, 1),
new SqlParameter("@CanLogin", SqlDbType.Bit, 1),
new SqlParameter("@VState", SqlDbType.Bit, 1),
new SqlParameter("@Super", SqlDbType.Bit, 1),
new SqlParameter("@RColor", SqlDbType.VarChar, 10),
new SqlParameter("@XingZheng", SqlDbType.Bit, 1),
new SqlParameter("@CaiWu", SqlDbType.Bit, 1),
new SqlParameter("@KeFu", SqlDbType.Bit, 1)
};
para[0].Value = model.RType;
para[1].Value = model.RName;
para[2].Value = model.CMessage;
para[3].Value = model.IsAdmin;
para[4].Value = model.CanSH;
para[5].Value = model.CanLogin;
para[6].Value = model.VState;
para[7].Value = model.Super;
para[8].Value = model.RColor;
para[9].Value = model.XingZheng;
para[10].Value = model.CaiWu;
para[11].Value = model.KeFu;
DAL.Roles.RolsList = null;
return(DbHelperSQL.ExecuteSql(sb.ToString(), para) > 0);
}
protected void SetInfo(out Model.Roles info, SqlDataReader reader)
{
try
{
info = new Model.Roles();
info.Id = CastDBNull.To <string>(reader["Id"], "");
info.Name = CastDBNull.To <string>(reader["Name"], "");
info.IsNew = false;
info.IsDirty = true;
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Insert(Model.Roles model)
{
string sb = "insert into Roles(RType,RName,CMessage,IsAdmin,CanSH,CanLogin,VState,Super,RColor,XingZheng,CaiWu,KeFu,YunYing,DiaoDu,SiJi,XiaoShou) values (@RType,@RName,@CMessage,@IsAdmin,@CanSH,@CanLogin,@VState,@Super,@RColor,@XingZheng,@CaiWu,@KeFu,@YunYing,@DiaoDu,@SiJi,@XiaoShou);";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RType", SqlDbType.VarChar, 20),
new SqlParameter("@RName", SqlDbType.VarChar, 20),
new SqlParameter("@CMessage", SqlDbType.Bit, 1),
new SqlParameter("@IsAdmin", SqlDbType.Bit, 1),
new SqlParameter("@CanSH", SqlDbType.Bit, 1),
new SqlParameter("@CanLogin", SqlDbType.Bit, 1),
new SqlParameter("@VState", SqlDbType.Bit, 1),
new SqlParameter("@Super", SqlDbType.Bit, 1),
new SqlParameter("@RColor", SqlDbType.VarChar, 10),
new SqlParameter("@XingZheng", SqlDbType.Bit, 1),
new SqlParameter("@CaiWu", SqlDbType.Bit, 1),
new SqlParameter("@KeFu", SqlDbType.Bit, 1),
new SqlParameter("@YunYing", SqlDbType.Bit, 1),
new SqlParameter("@DiaoDu", SqlDbType.Bit, 1),
new SqlParameter("@SiJi", SqlDbType.Bit, 1),
new SqlParameter("@XiaoShou", SqlDbType.Bit, 1)
};
para[0].Value = model.RType;
para[1].Value = model.RName;
para[2].Value = model.CMessage;
para[3].Value = model.IsAdmin;
para[4].Value = model.CanSH;
para[5].Value = model.CanLogin;
para[6].Value = model.VState;
para[7].Value = model.Super;
para[8].Value = model.RColor;
para[9].Value = model.XingZheng;
para[10].Value = model.CaiWu;
para[11].Value = model.KeFu;
para[12].Value = model.YunYing;
para[13].Value = model.DiaoDu;
para[14].Value = model.SiJi;
para[15].Value = model.XiaoShou;
DAL.Roles.RolsList = null;
return(DbHelperSQL.ExecuteSql(sb, para) > 0);
}
public override IInfo GetRecord(SmartDB dbInstance, object Id)
{
string sQL_GET = this.SQL_GET;
SqlParameter[] array = new SqlParameter[]
{
new SqlParameter(this.PARM_ID, SqlDbType.NVarChar)
};
array[0].Value = Id;
Model.Roles bizObject = null;
IInfo result;
try
{
bool transactionControl = dbInstance.TransactionControl;
SqlDataReader sqlDataReader;
if (transactionControl)
{
sqlDataReader = SqlHelper.ExecuteReader(dbInstance.Transaction, CommandType.StoredProcedure, sQL_GET, array);
}
else
{
sqlDataReader = SqlHelper.ExecuteReader(SqlHelper.MyConnectionString, CommandType.StoredProcedure, sQL_GET, array);
}
bool hasRows = sqlDataReader.HasRows;
if (hasRows)
{
sqlDataReader.Read();
this.SetInfo(out bizObject, sqlDataReader);
result = new ReturnInfo
{
BizObject = bizObject,
Code = ErrorEnum.NoError
};
}
else
{
result = new ReturnInfo(ErrorEnum.NoRecord, string.Format("No record found for ID: {0}", Id));
}
}
catch (Exception ex)
{
result = new ReturnInfo(ErrorEnum.DataException, ex.Message);
}
return(result);
}
private void ShowInfo(int Id)
{
Maticsoft.BLL.Users bll = new Maticsoft.BLL.Users();
Maticsoft.Model.Users model = bll.GetModel(Id);
this.lblId.Text = model.Id.ToString();
this.lblName.Text = model.Name;
this.lblTrueName.Text = model.TrueName;
this.lblSex.Text = model.Sex;
this.lblPhone.Text = model.Phone;
this.iPhoto.ImageUrl = "~/" + model.Photo;
this.lblEmail.Text = model.Email;
this.lblBirthday.Text = model.Birthday.ToString();
BLL.Roles BLLRoles = new BLL.Roles();
Model.Roles ModelRoles = BLLRoles.GetModel((int)model.Fk_Roles_Id);
this.lblFk_Roles_Id.Text = ModelRoles.Name;
}
public ReturnInfo IsValid(Model.Roles info)
{
bool flag = string.IsNullOrEmpty(info.Id);
ReturnInfo result;
if (flag)
{
result = new ReturnInfo
{
Code = ErrorEnum.InvalidInput,
Message = "Name cannot be blank.",
BizObject = "Name"
};
}
else
{
result = new ReturnInfo(ErrorEnum.NoError, "");
}
return(result);
}
public static bool Update(Model.Roles model)
{
return(DAL.Roles.Update(model));
}
public static bool Insert(Model.Roles model)
{
return(DAL.Roles.Insert(model));
}
public int UptRoles(Model.Roles a)
{
string sql = $"update Roles set RoleName='{a.RoleName}' where RoleId={a.RoleId})";
return(DapperHelper.Execute(sql));
}
public int AddRoles(Model.Roles a)
{
string sql = $"insert into Roles values (null,'{a.RoleName}')";
return(DapperHelper.Execute(sql));
}
