/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ssn_art_menu DataRowToModel(DataRow row) { XHD.Model.ssn_art_menu model = new XHD.Model.ssn_art_menu(); if (row != null) { if (row["Menu_id"] != null && row["Menu_id"].ToString() != "") { model.Id = int.Parse(row["Menu_id"].ToString()); } if (row["factory_Id"] != null) { model.factory_Id = row["factory_Id"].ToString(); } if (row["Menu_name"] != null) { model.Art_Menu = row["Menu_name"].ToString(); } if (row["Art_Menu_en"] != null) { model.Art_Menu_en = row["Art_Menu_en"].ToString(); } if (row["parentid"] != null && row["parentid"].ToString() != "") { model.parentid = int.Parse(row["parentid"].ToString()); } if (row["parentname"] != null) { model.parentname = row["parentname"].ToString(); } if (row["level"] != null && row["level"].ToString() != "") { model.level = int.Parse(row["level"].ToString()); } if (row["App_id"] != null && row["App_id"].ToString() != "") { model.App_id = int.Parse(row["App_id"].ToString()); } if (row["Menu_url"] != null) { model.Menu_url = row["Menu_url"].ToString(); } if (row["Menu_icon"] != null) { model.Menu_icon = row["Menu_icon"].ToString(); } if (row["Menu_handler"] != null) { model.Menu_handler = row["Menu_handler"].ToString(); } if (row["Menu_order"] != null && row["Menu_order"].ToString() != "") { model.Menu_order = int.Parse(row["Menu_order"].ToString()); } if (row["Menu_type"] != null) { model.Menu_type = row["Menu_type"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.ssn_art_menu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ssn_art_menu set "); strSql.Append("factory_Id=@factory_Id,"); strSql.Append("Art_Menu=@Art_Menu,"); strSql.Append("Art_Menu_en=@Art_Menu_en,"); strSql.Append("parentid=@parentid,"); strSql.Append("parentname=@parentname,"); strSql.Append("level=@level,"); strSql.Append("App_id=@App_id,"); //strSql.Append("Menu_url=@Menu_url,"); strSql.Append("Menu_icon=@Menu_icon,"); strSql.Append("Menu_handler=@Menu_handler,"); strSql.Append("Menu_order=@Menu_order,"); strSql.Append("Menu_type=@Menu_type"); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@Art_Menu", MySqlDbType.VarChar, 60), new MySqlParameter("@Art_Menu_en", MySqlDbType.VarChar, 60), new MySqlParameter("@parentid", MySqlDbType.Int32, 11), new MySqlParameter("@parentname", MySqlDbType.VarChar, 200), new MySqlParameter("@level", MySqlDbType.Int32, 4), new MySqlParameter("@App_id", MySqlDbType.Int32, 11), new MySqlParameter("@Menu_url", MySqlDbType.VarChar, 255), new MySqlParameter("@Menu_icon", MySqlDbType.VarChar, 50), new MySqlParameter("@Menu_handler", MySqlDbType.VarChar, 50), new MySqlParameter("@Menu_order", MySqlDbType.Int32, 11), new MySqlParameter("@Menu_type", MySqlDbType.VarChar, 50), new MySqlParameter("@Id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.factory_Id; parameters[1].Value = model.Art_Menu; parameters[2].Value = model.Art_Menu_en; parameters[3].Value = model.parentid; parameters[4].Value = model.parentname; parameters[5].Value = model.level; parameters[6].Value = model.App_id; parameters[7].Value = model.Menu_url; parameters[8].Value = model.Menu_icon; parameters[9].Value = model.Menu_handler; parameters[10].Value = model.Menu_order; parameters[11].Value = model.Menu_type; parameters[12].Value = model.Id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(XHD.Model.ssn_art_menu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ssn_art_menu("); strSql.Append("factory_Id,Art_Menu,Art_Menu_en,parentid,parentname,level,App_id,Menu_url,Menu_icon,Menu_handler,Menu_order,Menu_type)"); strSql.Append(" values ("); strSql.Append("@factory_Id,@Art_Menu,@Art_Menu_en,@parentid,@parentname,@level,@App_id,@Menu_url,@Menu_icon,@Menu_handler,@Menu_order,@Menu_type)"); strSql.Append(";select @@IDENTITY"); MySqlParameter[] parameters = { new MySqlParameter("@factory_Id", MySqlDbType.VarChar, 60), new MySqlParameter("@Art_Menu", MySqlDbType.VarChar, 60), new MySqlParameter("@Art_Menu_en", MySqlDbType.VarChar, 60), new MySqlParameter("@parentid", MySqlDbType.Int32, 11), new MySqlParameter("@parentname", MySqlDbType.VarChar, 200), new MySqlParameter("@level", MySqlDbType.Int32, 4), new MySqlParameter("@App_id", MySqlDbType.Int32, 11), new MySqlParameter("@Menu_url", MySqlDbType.VarChar, 255), new MySqlParameter("@Menu_icon", MySqlDbType.VarChar, 50), new MySqlParameter("@Menu_handler", MySqlDbType.VarChar, 50), new MySqlParameter("@Menu_order", MySqlDbType.Int32, 11), new MySqlParameter("@Menu_type", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.factory_Id; parameters[1].Value = model.Art_Menu; parameters[2].Value = model.Art_Menu_en; parameters[3].Value = model.parentid; parameters[4].Value = model.parentname; parameters[5].Value = model.level; parameters[6].Value = model.App_id; parameters[7].Value = model.Menu_url; parameters[8].Value = model.Menu_icon; parameters[9].Value = model.Menu_handler; parameters[10].Value = model.Menu_order; parameters[11].Value = model.Menu_type; object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(false); } else { int rows = DbHelperMySQL.ExecuteSql("update ssn_art_menu set Menu_url='SSN/article/ssn_article.aspx?Id=" + Convert.ToInt32(obj) + "' where id=" + Convert.ToInt32(obj)); if (rows > 0) { return(true); } else { return(false); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ssn_art_menu GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,factory_Id,Art_Menu,Art_Menu_en,parentid,parentname,level,App_id,Menu_url,Menu_icon,Menu_handler,Menu_order,Menu_type from ssn_art_menu "); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySqlDbType.Int32) }; parameters[0].Value = Id; XHD.Model.ssn_art_menu model = new XHD.Model.ssn_art_menu(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; HttpRequest request = context.Request; XHD.BLL.ssn_art_menu menu = new XHD.BLL.ssn_art_menu(); XHD.Model.ssn_art_menu model = new XHD.Model.ssn_art_menu(); var cookie = context.Request.Cookies[FormsAuthentication.FormsCookieName]; var ticket = FormsAuthentication.Decrypt(cookie.Value); string CoockiesID = ticket.UserData; XHD.BLL.hr_employee emp = new XHD.BLL.hr_employee(); int emp_id = int.Parse(CoockiesID); DataSet dsemp = emp.GetList("id=" + emp_id); string empname = string.Empty; string uid = string.Empty; string factory_Id = string.Empty; if (dsemp != null && dsemp.Tables[0].Rows.Count > 0) { empname = dsemp.Tables[0].Rows[0]["name"].ToString(); uid = dsemp.Tables[0].Rows[0]["uid"].ToString(); factory_Id = dsemp.Tables[0].Rows[0]["Factory_Id"].ToString(); } if (request["Action"] == "GetMenu") { int appid = XHD.Common.PageValidate.IsNumber(request["appid"]) ? int.Parse(request["appid"]) : 0; string serch = "App_id=" + appid; DataSet ds = menu.GetList(0, serch, "Menu_order"); //string dt = Common.GetGridJSON.DataTableToJSON(ds.Tables[0]); string dt = "{Rows:[" + GetTasksString(0, ds.Tables[0]) + "]}"; context.Response.Write(dt); } //Form JSON else if (request["Action"] == "form") { DataSet ds = menu.GetList("id=" + int.Parse(request["menuid"])); string dt = XHD.Common.DataToJson.DataToJSON(ds); context.Response.Write(dt); } else if (request["Action"] == "SysTree") { int appid = int.Parse(request["appid"]); DataSet ds = menu.GetList(0, "parentid=0 and App_id=" + appid, "Menu_order"); StringBuilder str = new StringBuilder(); str.Append("[{id:0,pid:0,text:'无',Menu_icon:''},"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { str.Append("{id:" + ds.Tables[0].Rows[i]["menu_id"].ToString() + ",pid:" + ds.Tables[0].Rows[i]["parentid"].ToString() + ",text:'" + ds.Tables[0].Rows[i]["menu_name"] + "',Menu_icon:'" + ds.Tables[0].Rows[i]["Menu_icon"] + "'},"); } str.Replace(",", "", str.Length - 1, 1); str.Append("]"); context.Response.Write(str); } //save else if (request["Action"] == "save") { model.Art_Menu = XHD.Common.PageValidate.InputText(request["T_menu_name"], 255); model.Menu_url = XHD.Common.PageValidate.InputText(request["T_menu_url"], 255); model.Menu_icon = XHD.Common.PageValidate.InputText(request["T_menu_icon"], 255); model.Menu_order = int.Parse(request["T_menu_order"]); model.Menu_type = XHD.Common.PageValidate.InputText(request["T_menu_type_val"], 255); model.parentid = int.Parse(request["T_menu_parent_val"]); model.parentname = XHD.Common.PageValidate.InputText(request["T_menu_parent"], 255); model.App_id = int.Parse(request["appid"]); model.factory_Id = factory_Id; string id = request["menuid"]; if (!string.IsNullOrEmpty(id) && id != "null") { model.Id = int.Parse(id); //DataSet ds = menu.GetList("Menu_id=" + model.Menu_id); //DataRow dr = ds.Tables[0].Rows[0]; //if (ds.Tables[0].Rows.Count > 0) //{ // model.Menu_type = ds.Tables[0].Rows[0]["Menu_type"].ToString(); //} menu.Update(model); } else { bool mid = menu.Add(model); } } else if (request["Action"] == "del") { string id = request["menuid"]; if (!string.IsNullOrEmpty(id) && id != "null") { //校验此菜单id下以及子菜单id下是否存在文章、 if (menu.ExistsArt(int.Parse(id))) { context.Response.Write('1'); //存在文章,不允许删除 } else { menu.DeleteAndChildren(int.Parse(id)); context.Response.Write('2'); //不存在文章删除,删除 } } } }