/// <summary>
/// 更新一条数据
/// </summary>
public static int Update(OALevel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OALevel set ");
strSql.Append("levelName=@levelName,");
strSql.Append("levelNO=@levelNO,");
strSql.Append("isParent=@isParent,");
strSql.Append("parentLevelNo=@parentLevelNo,");
strSql.Append("url=@url,");
strSql.Append("status=@status,");
strSql.Append("remark=@remark");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@levelName", SqlDbType.VarChar, 150),
new SqlParameter("@levelNO", SqlDbType.Int, 4),
new SqlParameter("@isParent", SqlDbType.Int, 4),
new SqlParameter("@parentLevelNo", SqlDbType.Int, 4),
new SqlParameter("@url", SqlDbType.VarChar, 150),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 250)
};
parameters[0].Value = model.id;
parameters[1].Value = model.levelName;
parameters[2].Value = model.levelNO;
parameters[3].Value = model.isParent;
parameters[4].Value = model.parentLevelNo;
parameters[5].Value = model.url;
parameters[6].Value = model.status;
parameters[7].Value = model.remark;
return(DBHelperSQL.ExecuteSql(strSql.ToString(), parameters));
}
/// <summary>
/// 添加一级信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAddOne_Click(object sender, EventArgs e)
{
string pName = this.txtOne.Text.Trim();
if (pName.Length == 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('名称不能为空!');", true);
return;
}
OALevel item = new OALevel();
item.levelName = pName;
item.levelNO = OALevelService.GetMaxLevelNo(0);
item.isParent = 0;
item.url = "";
item.parentLevelNo = 0;
item.status = 0;
item.remark = "";
int num = OALevelService.Add(item);
if (num > 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('添加成功!');", true);
}
LoadOneInfo();
}
/// <summary>
/// 添加二级信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAddTwo_Click(object sender, EventArgs e)
{
string pid = this.ddlOne.SelectedValue;
if (pid == "0")
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('请选择一级分类!');", true);
return;
}
string twoName = this.txtTwo.Text.Trim();
if (twoName.Length == 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('二级分类名称不能为空!');", true);
return;
}
OALevel item = new OALevel();
item.levelName = twoName;
item.isParent = 0;
item.url = txtURL.Text.Trim();
OALevel parentItem = OALevelService.GetModel(Convert.ToInt32(pid));
if (parentItem != null)
{
item.parentLevelNo = parentItem.levelNO;
}
else
{
item.parentLevelNo = 0;
}
item.levelNO = OALevelService.GetMaxLevelNo(item.parentLevelNo);
item.status = 0;
item.remark = "";
int num = OALevelService.Add(item);
if (num > 0)
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('添加成功!');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('添加失败!');", true);
}
GetTwo(pid);
}
/// <summary>
/// 根据条件获取对象列表
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public static List <OALevel> GetListModel(string strWhere)
{
List <OALevel> list = null;
OALevel model = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,levelName,levelNO,isParent,parentLevelNo,url,status,remark ");
strSql.Append(" FROM OALevel ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by id desc");
DataSet ds = DBHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
list = new List <OALevel>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
model = new OALevel();
if (dr["id"].ToString() != "")
{
model.id = int.Parse(dr["id"].ToString());
}
model.levelName = dr["levelName"].ToString();
model.levelNO = int.Parse(dr["levelNO"].ToString());
if (dr["isParent"].ToString() != "")
{
model.isParent = int.Parse(dr["isParent"].ToString());
}
model.parentLevelNo = int.Parse(dr["parentLevelNo"].ToString());
model.url = dr["url"].ToString();
if (dr["status"].ToString() != "")
{
model.status = int.Parse(dr["status"].ToString());
}
model.remark = dr["remark"].ToString();
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static OALevel GetModelByLevelNo(int levelNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,levelName,levelNO,isParent,parentLevelNo,url,status,remark from OALevel ");
strSql.Append(" where levelNO=@levelNO ");
SqlParameter[] parameters =
{
new SqlParameter("@levelNO", SqlDbType.Int, 4)
};
parameters[0].Value = levelNo;
OALevel model = new OALevel();
DataSet ds = DBHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.levelName = ds.Tables[0].Rows[0]["levelName"].ToString();
model.levelNO = int.Parse(ds.Tables[0].Rows[0]["levelNO"].ToString());
if (ds.Tables[0].Rows[0]["isParent"].ToString() != "")
{
model.isParent = int.Parse(ds.Tables[0].Rows[0]["isParent"].ToString());
}
model.parentLevelNo = int.Parse(ds.Tables[0].Rows[0]["parentLevelNo"].ToString());
model.url = ds.Tables[0].Rows[0]["url"].ToString();
if (ds.Tables[0].Rows[0]["status"].ToString() != "")
{
model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString());
}
model.remark = ds.Tables[0].Rows[0]["remark"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 一级权限菜单信息加载
/// </summary>
/// <returns></returns>
private void GetTwo(string pid)
{
StringBuilder sb = new StringBuilder();
if (pid != "0")
{
OALevel item = OALevelService.GetModel(Convert.ToInt32(pid));
if (item != null)
{
DataSet ds = OALevelService.GetList("parentLevelNo = " + item.levelNO);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
sb.Append("<label class=\"preview\"><input type=\"radio\" id='city" + dr["id"] + "' name='city' onclick=\"getTwoInfo(" + dr["id"] + ",'" + dr["levelName"] + "',this,'" + dr["url"] + "');\" />" + dr["levelName"] + "</label>");
}
}
}
}
ViewState["twoInfo"] = sb.ToString();
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(OALevel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OALevel(");
strSql.Append("levelName,levelNO,isParent,parentLevelNo,url,status,remark)");
strSql.Append(" values (");
strSql.Append("@levelName,@levelNO,@isParent,@parentLevelNo,@url,@status,@remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@levelName", SqlDbType.VarChar, 150),
new SqlParameter("@levelNO", SqlDbType.Int, 4),
new SqlParameter("@isParent", SqlDbType.Int, 4),
new SqlParameter("@parentLevelNo", SqlDbType.Int, 4),
new SqlParameter("@url", SqlDbType.VarChar, 150),
new SqlParameter("@status", SqlDbType.Int, 4),
new SqlParameter("@remark", SqlDbType.VarChar, 250)
};
parameters[0].Value = model.levelName;
parameters[1].Value = model.levelNO;
parameters[2].Value = model.isParent;
parameters[3].Value = model.parentLevelNo;
parameters[4].Value = model.url;
parameters[5].Value = model.status;
parameters[6].Value = model.remark;
object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 返回菜单信息
/// </summary>
/// <returns></returns>
protected string GetMenu()
{
StringBuilder sb = new StringBuilder();
AdminUser item = Session["loginUser"] as AdminUser;
DataSet ds = SysPrivilegesService.GetLevelInfo(item.roleId, 3);
int menuCount = SysPrivilegesService.GetSonCount(item.roleId, 3); //总数
int nowNode = 1;
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
OALevel levelItem = OALevelService.GetModelByLevelNo(Convert.ToInt32(ds.Tables[0].Rows[i]["levelNo"]));
if (levelItem != null)
{
sb.Append("<div class=\"left_tab\" style=\"padding-left:30px;\">" + levelItem.levelName + "</div>");
sb.Append("<ul>");
DataSet ds2 = SysPrivilegesService.GetSonInfo(Convert.ToInt32(ViewState["role"]), 3, Convert.ToInt32(ds.Tables[0].Rows[i]["levelNo"]));
if (ds2.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
levelItem = OALevelService.GetModelByLevelNo(Convert.ToInt32(ds2.Tables[0].Rows[j]["levelNo"]));
if (levelItem != null)
{
sb.Append("<li id=\"m_" + nowNode + "\" onClick=\"dis_cont('" + levelItem.url + "'," + nowNode + "," + ViewState["role"] + "," + menuCount + ")\">" + levelItem.levelName + "</li>");
nowNode++;
}
}
}
sb.Append("</ul>");
}
}
}
return(sb.ToString());
}
