/// <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'); //不存在文章删除，删除
}
}
}
}
