protected void btnSave_Click(object sender, EventArgs e)
{
if (Request.QueryString["Id"] == null)
{
return;
}
string content = Request.Form["editor1"] == null ? "" : Request.Form["editor1"];
Maticsoft.BLL.tAbout bll = new Maticsoft.BLL.tAbout();
Maticsoft.Model.tAbout model = bll.GetModel(int.Parse(Request.QueryString["Id"]));
if (model == null)
{
return;
}
model.AboutContent = content;
model.Remark = txtRemark.Text;
if (bll.Update(model))
{
Alert.ShowInTop("保存成功！");
}
else
{
Alert.ShowInTop("保存失败！");
}
}
public Maticsoft.Model.tAbout About(int id)
{
Maticsoft.BLL.tAbout BLL = new Maticsoft.BLL.tAbout();
Maticsoft.Model.tAbout model = BLL.GetModel(id);
//model.Click = (model.Click + 1);
//BLL.Update(model);
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Maticsoft.BLL.tAbout BLL = new Maticsoft.BLL.tAbout();
Maticsoft.Model.tAbout menu = BLL.GetModel(8);
lit_content.Text = menu == null?"": menu.AboutContent;
}
}
/// <summary>
/// 根据ArtGuid 来给控件赋值
/// </summary>
/// <param name="ArtGuid"></param>
public void UpMenuModel(string ArtGuid)
{
Maticsoft.BLL.tAbout BLL = new Maticsoft.BLL.tAbout();
Maticsoft.Model.tAbout m = BLL.GetModel(int.Parse(ArtGuid));
txtName.Text = m.Title;
txtSort.Text = m.Sort.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.tAbout model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tAbout set ");
strSql.Append("Title=@Title,");
strSql.Append("AboutContent=@AboutContent,");
strSql.Append("Sort=@Sort,");
strSql.Append("Editor=@Editor,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("Click=@Click,");
strSql.Append("Remark=@Remark,");
strSql.Append("FengMian=@FengMian,");
strSql.Append("IsEnable=@IsEnable");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@AboutContent", SqlDbType.NVarChar, -1),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@Click", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, -1),
new SqlParameter("@FengMian", SqlDbType.NVarChar, 500),
new SqlParameter("@IsEnable", SqlDbType.Int, 4),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.AboutContent;
parameters[2].Value = model.Sort;
parameters[3].Value = model.Editor;
parameters[4].Value = model.UpdateTime;
parameters[5].Value = model.Click;
parameters[6].Value = model.Remark;
parameters[7].Value = model.FengMian;
parameters[8].Value = model.IsEnable;
parameters[9].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(Request.QueryString["pageId"]))
{
Maticsoft.BLL.tAbout BLL = new Maticsoft.BLL.tAbout();
int pageId = int.Parse(Request.QueryString["pageId"]);
Maticsoft.Model.tAbout menu = BLL.GetModel(pageId);
if (BLL.GetList(string.Format(" Title='{0}' and Id<>{1} ", txtName.Text, pageId)).Tables[0].Rows.Count >= 1)
{
Alert.ShowInTop("该名称已经存在！"); return;
}
menu.Id = pageId;
menu.Title = txtName.Text.ToString().Trim();
menu.Sort = Convert.ToInt32(txtSort.Text.ToString().Trim());
if (BLL.Update(menu) == true)
{
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.ShowInTop("操作失败！");
}
}
else
{
Maticsoft.BLL.tAbout BLL = new Maticsoft.BLL.tAbout();
Maticsoft.Model.tAbout menu = new Maticsoft.Model.tAbout();
if (BLL.GetList(string.Format(" Title='{0}' ", txtName.Text)).Tables[0].Rows.Count >= 1)
{
Alert.ShowInTop("该名称已经存在！"); return;
}
menu.Title = txtName.Text.ToString().Trim();
menu.Sort = Convert.ToInt32(txtSort.Text.ToString().Trim());
if (BLL.Add(menu) >= 1)
{
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
}
else
{
Alert.ShowInTop("操作失败！");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tAbout DataRowToModel(DataRow row)
{
Maticsoft.Model.tAbout model = new Maticsoft.Model.tAbout();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["AboutContent"] != null)
{
model.AboutContent = row["AboutContent"].ToString();
}
if (row["Sort"] != null && row["Sort"].ToString() != "")
{
model.Sort = int.Parse(row["Sort"].ToString());
}
if (row["Editor"] != null)
{
model.Editor = row["Editor"].ToString();
}
if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
if (row["Click"] != null && row["Click"].ToString() != "")
{
model.Click = int.Parse(row["Click"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["FengMian"] != null)
{
model.FengMian = row["FengMian"].ToString();
}
if (row["IsEnable"] != null && row["IsEnable"].ToString() != "")
{
model.IsEnable = int.Parse(row["IsEnable"].ToString());
}
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["Id"] != null)
{
Maticsoft.BLL.tAbout bll = new Maticsoft.BLL.tAbout();
Maticsoft.Model.tAbout model = bll.GetModel(int.Parse(Request.QueryString["Id"]));
if (model == null)
{
return;
}
hfEditorInitValue.Text = model.AboutContent;
txtRemark.Text = model.Remark;
btnSave.Text = model.Title + "-" + "保存";
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.tAbout model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tAbout(");
strSql.Append("Title,AboutContent,Sort,Editor,UpdateTime,Click,Remark,FengMian,IsEnable)");
strSql.Append(" values (");
strSql.Append("@Title,@AboutContent,@Sort,@Editor,@UpdateTime,@Click,@Remark,@FengMian,@IsEnable)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@AboutContent", SqlDbType.NVarChar, -1),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Editor", SqlDbType.NVarChar, 50),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@Click", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, -1),
new SqlParameter("@FengMian", SqlDbType.NVarChar, 500),
new SqlParameter("@IsEnable", SqlDbType.Int, 4)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.AboutContent;
parameters[2].Value = model.Sort;
parameters[3].Value = model.Editor;
parameters[4].Value = model.UpdateTime;
parameters[5].Value = model.Click;
parameters[6].Value = model.Remark;
parameters[7].Value = model.FengMian;
parameters[8].Value = model.IsEnable;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tAbout GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,Title,AboutContent,Sort,Editor,UpdateTime,Click,Remark,FengMian,IsEnable from tAbout ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Maticsoft.Model.tAbout model = new Maticsoft.Model.tAbout();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}