/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BrnMall.Core.Model.YX_news model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_news(");
strSql.Append("EventId,newsTitle,newsDescription,newsPicUrl,newsUrl,EventCate,remark1,remark2,remark3,flat1,flat2,remark4,remark5,remark6,flat7,flat8,RegTim1,RegTim2)");
strSql.Append(" values (");
strSql.Append("@EventId,@newsTitle,@newsDescription,@newsPicUrl,@newsUrl,@EventCate,@remark1,@remark2,@remark3,@flat1,@flat2,@remark4,@remark5,@remark6,@flat7,@flat8,@RegTim1,@RegTim2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@EventId", SqlDbType.Int, 4),
new SqlParameter("@newsTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@newsDescription", SqlDbType.NVarChar, 1000),
new SqlParameter("@newsPicUrl", SqlDbType.VarChar, 1000),
new SqlParameter("@newsUrl", SqlDbType.VarChar, 1000),
new SqlParameter("@EventCate", SqlDbType.VarChar, 50),
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.EventId;
parameters[1].Value = model.newsTitle;
parameters[2].Value = model.newsDescription;
parameters[3].Value = model.newsPicUrl;
parameters[4].Value = model.newsUrl;
parameters[5].Value = model.EventCate;
parameters[6].Value = model.remark1;
parameters[7].Value = model.remark2;
parameters[8].Value = model.remark3;
parameters[9].Value = model.flat1;
parameters[10].Value = model.flat2;
parameters[11].Value = model.remark4;
parameters[12].Value = model.remark5;
parameters[13].Value = model.remark6;
parameters[14].Value = model.flat7;
parameters[15].Value = model.flat8;
parameters[16].Value = model.RegTim1;
parameters[17].Value = model.RegTim2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
(Master.FindControl("childmenu") as Label).Text = "配置微事件";
if (Request.Form["action"] == "text")
{
AddText(); return;
}
if (Request.Form["action"] == "news")
{
AddNews(); return;
}
if (!Page.IsPostBack)
{
loadMenus(Request.QueryString["msgtype"]);
string Id = Request.QueryString["id"];
if (!string.IsNullOrEmpty(Id))
{
eventMol = eventBll.GetModel(Convert.ToInt32(Id));
string eventType = eventMol.msgType.ToString();
switch (eventType)
{
case "1": dt_text = textBll.GetList(" EventId=" + Id + " and EventCate='" + eventMol.EventName + "'").Tables[0]; break; //文本
case "2": dt_News = newsBll.GetList(" EventId=" + Id + " and EventCate='" + eventMol.EventName + "'").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"]));
}
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BrnMall.Core.Model.YX_news GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,EventId,newsTitle,newsDescription,newsPicUrl,newsUrl,EventCate,remark1,remark2,remark3,flat1,flat2,remark4,remark5,remark6,flat7,flat8,RegTim1,RegTim2 from YX_news ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
BrnMall.Core.Model.YX_news model = new BrnMall.Core.Model.YX_news();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BrnMall.Core.Model.YX_news DataRowToModel(DataRow row)
{
BrnMall.Core.Model.YX_news model = new BrnMall.Core.Model.YX_news();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["EventId"] != null && row["EventId"].ToString() != "")
{
model.EventId = int.Parse(row["EventId"].ToString());
}
if (row["newsTitle"] != null)
{
model.newsTitle = row["newsTitle"].ToString();
}
if (row["newsDescription"] != null)
{
model.newsDescription = row["newsDescription"].ToString();
}
if (row["newsPicUrl"] != null)
{
model.newsPicUrl = row["newsPicUrl"].ToString();
}
if (row["newsUrl"] != null)
{
model.newsUrl = row["newsUrl"].ToString();
}
if (row["EventCate"] != null)
{
model.EventCate = row["EventCate"].ToString();
}
if (row["remark1"] != null)
{
model.remark1 = row["remark1"].ToString();
}
if (row["remark2"] != null)
{
model.remark2 = row["remark2"].ToString();
}
if (row["remark3"] != null)
{
model.remark3 = row["remark3"].ToString();
}
if (row["flat1"] != null && row["flat1"].ToString() != "")
{
model.flat1 = int.Parse(row["flat1"].ToString());
}
if (row["flat2"] != null && row["flat2"].ToString() != "")
{
model.flat2 = int.Parse(row["flat2"].ToString());
}
if (row["remark4"] != null)
{
model.remark4 = row["remark4"].ToString();
}
if (row["remark5"] != null)
{
model.remark5 = row["remark5"].ToString();
}
if (row["remark6"] != null)
{
model.remark6 = row["remark6"].ToString();
}
if (row["flat7"] != null && row["flat7"].ToString() != "")
{
model.flat7 = int.Parse(row["flat7"].ToString());
}
if (row["flat8"] != null && row["flat8"].ToString() != "")
{
model.flat8 = int.Parse(row["flat8"].ToString());
}
if (row["RegTim1"] != null && row["RegTim1"].ToString() != "")
{
model.RegTim1 = DateTime.Parse(row["RegTim1"].ToString());
}
if (row["RegTim2"] != null && row["RegTim2"].ToString() != "")
{
model.RegTim2 = DateTime.Parse(row["RegTim2"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BrnMall.Core.Model.YX_news model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update YX_news set ");
strSql.Append("EventId=@EventId,");
strSql.Append("newsTitle=@newsTitle,");
strSql.Append("newsDescription=@newsDescription,");
strSql.Append("newsPicUrl=@newsPicUrl,");
strSql.Append("newsUrl=@newsUrl,");
strSql.Append("EventCate=@EventCate,");
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("@EventId", SqlDbType.Int, 4),
new SqlParameter("@newsTitle", SqlDbType.NVarChar, 50),
new SqlParameter("@newsDescription", SqlDbType.NVarChar, 1000),
new SqlParameter("@newsPicUrl", SqlDbType.VarChar, 1000),
new SqlParameter("@newsUrl", SqlDbType.VarChar, 1000),
new SqlParameter("@EventCate", SqlDbType.VarChar, 50),
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.EventId;
parameters[1].Value = model.newsTitle;
parameters[2].Value = model.newsDescription;
parameters[3].Value = model.newsPicUrl;
parameters[4].Value = model.newsUrl;
parameters[5].Value = model.EventCate;
parameters[6].Value = model.remark1;
parameters[7].Value = model.remark2;
parameters[8].Value = model.remark3;
parameters[9].Value = model.flat1;
parameters[10].Value = model.flat2;
parameters[11].Value = model.remark4;
parameters[12].Value = model.remark5;
parameters[13].Value = model.remark6;
parameters[14].Value = model.flat7;
parameters[15].Value = model.flat8;
parameters[16].Value = model.RegTim1;
parameters[17].Value = model.RegTim2;
parameters[18].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
