/// <summary>
/// 添加文本事件
/// </summary>
protected void AddText()
{
DelEvent();//先删除原来的事件 再添加新事件
//
string EventId = Request.Form["EventId"];
if (!string.IsNullOrEmpty(EventId))
{
menuMol = menuBll.GetModel(Convert.ToInt32(EventId));
menuMol.flat1 = 1; //代表发送文本
menuBll.Update(menuMol); //更新数据
textMol.EventId = Convert.ToInt32(EventId);
textMol.msgContent = CommonMethod.CheckParamThrow(Request.Form["msgContent"]);
textMol.EventCate = "menu";//事件类型 菜单
if (textBll.Add(textMol) != 0)
{
CommonMethod.Alert("恭喜编辑菜单成功！", "wei_MenusConfig.aspx?menuFid=" + Request.Form["fid"]);
}
else
{
CommonMethod.Alert("系统正忙，请稍后重试！");
}
}
else
{
CommonMethod.Alert("系统正忙，请稍后重试！");
}
}
/// <summary>
/// 添加图文事件
/// </summary>
protected void AddNews()
{
DelEvent();//先删除原来的事件 再添加新事件
//
string EventId = Request.Form["EventId"];
if (!string.IsNullOrEmpty(EventId))
{
menuMol = menuBll.GetModel(Convert.ToInt32(EventId));
menuMol.flat1 = 2; //代表发送图文
menuBll.Update(menuMol); //更新数据
newsMol.EventId = Convert.ToInt32(EventId);
newsMol.newsTitle = CommonMethod.CheckParamThrow(Request.Form["newsTitle"]);
newsMol.newsDescription = CommonMethod.CheckParamThrow(Request.Form["newsDescription"]);
newsMol.newsPicUrl = CommonMethod.CheckParamThrow(Request.Form["newsPicUrl"]);
newsMol.newsUrl = CommonMethod.CheckParamThrow(Request.Form["newsUrl"]); newsMol.EventCate = "menu";//事件类型 菜单
if (newsBll.Add(newsMol) != 0)
{
CommonMethod.Alert("恭喜编辑菜单成功！", "wei_MenusConfig.aspx?menuFid=" + Request.Form["fid"]);
}
else
{
CommonMethod.Alert("系统正忙，请稍后重试！");
}
}
else
{
CommonMethod.Alert("系统正忙，请稍后重试！");
}
}
/// <summary>
/// 检测菜单是否可以加事件
/// </summary>
/// <param name="Id">菜单Id</param>
protected void checkMenu(string Id)
{
if (!string.IsNullOrEmpty(Id))
{
mol = bll.GetModel(Convert.ToInt32(Id));
if (mol.WX_Fid == 0)//如果是一级菜单 则不可以
{
Response.Write("NOO");
}
else
{
if (mol.WX_MenuType != "1")//菜单事件不是click
{
Response.Write("NO");
}
else
{
Response.Write("OK");
}
}
}
else
{
Response.Write("error");
}
Response.End();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BrnMall.Core.Model.YX_weiXinMenus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_weiXinMenus(");
strSql.Append("WX_menuName,WX_MenuType,WX_MenusKey_URL,WX_Fid,WX_AddTime,remark1,remark2,remark3,flat1,flat2,remark4,remark5,remark6,flat7,flat8,RegTim1,RegTim2)");
strSql.Append(" values (");
strSql.Append("@WX_menuName,@WX_MenuType,@WX_MenusKey_URL,@WX_Fid,@WX_AddTime,@remark1,@remark2,@remark3,@flat1,@flat2,@remark4,@remark5,@remark6,@flat7,@flat8,@RegTim1,@RegTim2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@WX_menuName", SqlDbType.NVarChar, 20),
new SqlParameter("@WX_MenuType", SqlDbType.VarChar, 20),
new SqlParameter("@WX_MenusKey_URL", SqlDbType.VarChar, 1000),
new SqlParameter("@WX_Fid", SqlDbType.Int, 4),
new SqlParameter("@WX_AddTime", SqlDbType.DateTime),
new SqlParameter("@remark1", SqlDbType.NVarChar, 500),
new SqlParameter("@remark2", SqlDbType.NVarChar, 500),
new SqlParameter("@remark3", SqlDbType.NText),
new SqlParameter("@flat1", SqlDbType.Int, 4),
new SqlParameter("@flat2", SqlDbType.Int, 4),
new SqlParameter("@remark4", SqlDbType.NVarChar, 50),
new SqlParameter("@remark5", SqlDbType.NVarChar, 50),
new SqlParameter("@remark6", SqlDbType.NText),
new SqlParameter("@flat7", SqlDbType.Int, 4),
new SqlParameter("@flat8", SqlDbType.Int, 4),
new SqlParameter("@RegTim1", SqlDbType.DateTime),
new SqlParameter("@RegTim2", SqlDbType.DateTime)
};
parameters[0].Value = model.WX_menuName;
parameters[1].Value = model.WX_MenuType;
parameters[2].Value = model.WX_MenusKey_URL;
parameters[3].Value = model.WX_Fid;
parameters[4].Value = model.WX_AddTime;
parameters[5].Value = model.remark1;
parameters[6].Value = model.remark2;
parameters[7].Value = model.remark3;
parameters[8].Value = model.flat1;
parameters[9].Value = model.flat2;
parameters[10].Value = model.remark4;
parameters[11].Value = model.remark5;
parameters[12].Value = model.remark6;
parameters[13].Value = model.flat7;
parameters[14].Value = model.flat8;
parameters[15].Value = model.RegTim1;
parameters[16].Value = model.RegTim2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
///检测是否拥有事件，已拥有，则可编辑事件！
/// </summary>
/// <param name="id">菜单Id</param>
protected void cekevent2(string id)
{
mol = bll.GetModel(Convert.ToInt32(id));
int flat = Convert.ToInt32(mol.flat1);
if (flat != 0)//已添加事件
{
Response.Write("OK");
}
else
{
Response.Write("NO");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
(Master.FindControl("childmenu") as Label).Text = "微事件编辑";
string id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(id))
{
mol = bll.GetModel(Convert.ToInt32(id));
eventType = mol.flat1.ToString();
switch (eventType)
{
case "1": dt_text = textBll.GetList(" EventId=" + id + " and EventCate='menu'").Tables[0]; break; //文本
case "2": dt_News = newsBll.GetList(" EventId=" + id + " and EventCate='menu'").Tables[0]; break; //图文
}
if (dt_text.Rows.Count != 0)
{
textMol = textBll.GetModel(Convert.ToInt32(dt_text.Rows[0]["Id"]));
}
if (dt_News.Rows.Count != 0)
{
newsMol = newsBll.GetModel(Convert.ToInt32(dt_News.Rows[0]["Id"]));
}
}
}
if (Request.Form["action"] == "text")
{
AddText();
}
if (Request.Form["action"] == "news")
{
AddNews();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BrnMall.Core.Model.YX_weiXinMenus GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,WX_menuName,WX_MenuType,WX_MenusKey_URL,WX_Fid,WX_AddTime,remark1,remark2,remark3,flat1,flat2,remark4,remark5,remark6,flat7,flat8,RegTim1,RegTim2 from YX_weiXinMenus ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
BrnMall.Core.Model.YX_weiXinMenus model = new BrnMall.Core.Model.YX_weiXinMenus();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["WX_menuName"] != null && ds.Tables[0].Rows[0]["WX_menuName"].ToString() != "")
{
model.WX_menuName = ds.Tables[0].Rows[0]["WX_menuName"].ToString();
}
if (ds.Tables[0].Rows[0]["WX_MenuType"] != null && ds.Tables[0].Rows[0]["WX_MenuType"].ToString() != "")
{
model.WX_MenuType = ds.Tables[0].Rows[0]["WX_MenuType"].ToString();
}
if (ds.Tables[0].Rows[0]["WX_MenusKey_URL"] != null && ds.Tables[0].Rows[0]["WX_MenusKey_URL"].ToString() != "")
{
model.WX_MenusKey_URL = ds.Tables[0].Rows[0]["WX_MenusKey_URL"].ToString();
}
if (ds.Tables[0].Rows[0]["WX_Fid"] != null && ds.Tables[0].Rows[0]["WX_Fid"].ToString() != "")
{
model.WX_Fid = int.Parse(ds.Tables[0].Rows[0]["WX_Fid"].ToString());
}
if (ds.Tables[0].Rows[0]["WX_AddTime"] != null && ds.Tables[0].Rows[0]["WX_AddTime"].ToString() != "")
{
model.WX_AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["WX_AddTime"].ToString());
}
if (ds.Tables[0].Rows[0]["remark1"] != null && ds.Tables[0].Rows[0]["remark1"].ToString() != "")
{
model.remark1 = ds.Tables[0].Rows[0]["remark1"].ToString();
}
if (ds.Tables[0].Rows[0]["remark2"] != null && ds.Tables[0].Rows[0]["remark2"].ToString() != "")
{
model.remark2 = ds.Tables[0].Rows[0]["remark2"].ToString();
}
if (ds.Tables[0].Rows[0]["remark3"] != null && ds.Tables[0].Rows[0]["remark3"].ToString() != "")
{
model.remark3 = ds.Tables[0].Rows[0]["remark3"].ToString();
}
if (ds.Tables[0].Rows[0]["flat1"] != null && ds.Tables[0].Rows[0]["flat1"].ToString() != "")
{
model.flat1 = int.Parse(ds.Tables[0].Rows[0]["flat1"].ToString());
}
if (ds.Tables[0].Rows[0]["flat2"] != null && ds.Tables[0].Rows[0]["flat2"].ToString() != "")
{
model.flat2 = int.Parse(ds.Tables[0].Rows[0]["flat2"].ToString());
}
if (ds.Tables[0].Rows[0]["remark4"] != null && ds.Tables[0].Rows[0]["remark4"].ToString() != "")
{
model.remark4 = ds.Tables[0].Rows[0]["remark4"].ToString();
}
if (ds.Tables[0].Rows[0]["remark5"] != null && ds.Tables[0].Rows[0]["remark5"].ToString() != "")
{
model.remark5 = ds.Tables[0].Rows[0]["remark5"].ToString();
}
if (ds.Tables[0].Rows[0]["remark6"] != null && ds.Tables[0].Rows[0]["remark6"].ToString() != "")
{
model.remark6 = ds.Tables[0].Rows[0]["remark6"].ToString();
}
if (ds.Tables[0].Rows[0]["flat7"] != null && ds.Tables[0].Rows[0]["flat7"].ToString() != "")
{
model.flat7 = int.Parse(ds.Tables[0].Rows[0]["flat7"].ToString());
}
if (ds.Tables[0].Rows[0]["flat8"] != null && ds.Tables[0].Rows[0]["flat8"].ToString() != "")
{
model.flat8 = int.Parse(ds.Tables[0].Rows[0]["flat8"].ToString());
}
if (ds.Tables[0].Rows[0]["RegTim1"] != null && ds.Tables[0].Rows[0]["RegTim1"].ToString() != "")
{
model.RegTim1 = DateTime.Parse(ds.Tables[0].Rows[0]["RegTim1"].ToString());
}
if (ds.Tables[0].Rows[0]["RegTim2"] != null && ds.Tables[0].Rows[0]["RegTim2"].ToString() != "")
{
model.RegTim2 = DateTime.Parse(ds.Tables[0].Rows[0]["RegTim2"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BrnMall.Core.Model.YX_weiXinMenus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_weiXinMenus set ");
strSql.Append("WX_menuName=@WX_menuName,");
strSql.Append("WX_MenuType=@WX_MenuType,");
strSql.Append("WX_MenusKey_URL=@WX_MenusKey_URL,");
strSql.Append("WX_Fid=@WX_Fid,");
strSql.Append("WX_AddTime=@WX_AddTime,");
strSql.Append("remark1=@remark1,");
strSql.Append("remark2=@remark2,");
strSql.Append("remark3=@remark3,");
strSql.Append("flat1=@flat1,");
strSql.Append("flat2=@flat2,");
strSql.Append("remark4=@remark4,");
strSql.Append("remark5=@remark5,");
strSql.Append("remark6=@remark6,");
strSql.Append("flat7=@flat7,");
strSql.Append("flat8=@flat8,");
strSql.Append("RegTim1=@RegTim1,");
strSql.Append("RegTim2=@RegTim2");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@WX_menuName", SqlDbType.NVarChar, 20),
new SqlParameter("@WX_MenuType", SqlDbType.VarChar, 20),
new SqlParameter("@WX_MenusKey_URL", SqlDbType.VarChar, 1000),
new SqlParameter("@WX_Fid", SqlDbType.Int, 4),
new SqlParameter("@WX_AddTime", SqlDbType.DateTime),
new SqlParameter("@remark1", SqlDbType.NVarChar, 500),
new SqlParameter("@remark2", SqlDbType.NVarChar, 500),
new SqlParameter("@remark3", SqlDbType.NText),
new SqlParameter("@flat1", SqlDbType.Int, 4),
new SqlParameter("@flat2", SqlDbType.Int, 4),
new SqlParameter("@remark4", SqlDbType.NVarChar, 50),
new SqlParameter("@remark5", SqlDbType.NVarChar, 50),
new SqlParameter("@remark6", SqlDbType.NText),
new SqlParameter("@flat7", SqlDbType.Int, 4),
new SqlParameter("@flat8", SqlDbType.Int, 4),
new SqlParameter("@RegTim1", SqlDbType.DateTime),
new SqlParameter("@RegTim2", SqlDbType.DateTime),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.WX_menuName;
parameters[1].Value = model.WX_MenuType;
parameters[2].Value = model.WX_MenusKey_URL;
parameters[3].Value = model.WX_Fid;
parameters[4].Value = model.WX_AddTime;
parameters[5].Value = model.remark1;
parameters[6].Value = model.remark2;
parameters[7].Value = model.remark3;
parameters[8].Value = model.flat1;
parameters[9].Value = model.flat2;
parameters[10].Value = model.remark4;
parameters[11].Value = model.remark5;
parameters[12].Value = model.remark6;
parameters[13].Value = model.flat7;
parameters[14].Value = model.flat8;
parameters[15].Value = model.RegTim1;
parameters[16].Value = model.RegTim2;
parameters[17].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}