/// <summary> /// 得到一个对象实体 /// </summary> public hm.Model.ed_node GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,parentId,title,pic,url,types,orders,isShow,models from ed_node "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; hm.Model.ed_node model = new hm.Model.ed_node(); DataSet ds = DbHelperOleDb.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]["parentId"] != null && ds.Tables[0].Rows[0]["parentId"].ToString() != "") { model.parentId = int.Parse(ds.Tables[0].Rows[0]["parentId"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["pic"] != null && ds.Tables[0].Rows[0]["pic"].ToString() != "") { model.pic = ds.Tables[0].Rows[0]["pic"].ToString(); } if (ds.Tables[0].Rows[0]["url"] != null && ds.Tables[0].Rows[0]["url"].ToString() != "") { model.url = ds.Tables[0].Rows[0]["url"].ToString(); } if (ds.Tables[0].Rows[0]["types"] != null && ds.Tables[0].Rows[0]["types"].ToString() != "") { model.types = int.Parse(ds.Tables[0].Rows[0]["types"].ToString()); } if (ds.Tables[0].Rows[0]["orders"] != null && ds.Tables[0].Rows[0]["orders"].ToString() != "") { model.orders = int.Parse(ds.Tables[0].Rows[0]["orders"].ToString()); } if (ds.Tables[0].Rows[0]["isShow"] != null && ds.Tables[0].Rows[0]["isShow"].ToString() != "") { model.isShow = int.Parse(ds.Tables[0].Rows[0]["isShow"].ToString()); } if (ds.Tables[0].Rows[0]["models"] != null && ds.Tables[0].Rows[0]["models"].ToString() != "") { model.models = int.Parse(ds.Tables[0].Rows[0]["models"].ToString()); } return(model); } else { return(null); } }
protected void btnMod_Click(object sender, EventArgs e) { string id = lblId.Text; if (string.IsNullOrEmpty(id)) { MessageBox.Show(this, "请选择修改的栏目!"); return; } string strErr = ""; if (this.txtTitle.Text.Trim().Length == 0) { strErr += "名称不能为空!\\n"; } if (!PageValidate.IsNumber(txtOrderAdd.Text)) { strErr += "排序格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string title = this.txtTitle.Text; int parentId = int.Parse(this.ddrParent.SelectedValue); int orders = int.Parse(txtOrder.Text); string url = txtUrl.Text; int types = int.Parse(this.ddrTypes.SelectedValue); int models = 0; if (types == 4) { models = int.Parse(ddrModel.SelectedValue); } hm.Model.ed_node model = bll.GetModel(int.Parse(lblId.Text)); model.title = title; model.parentId = parentId; model.pic = ""; model.types = types; model.orders = orders; model.url = url; model.isShow = 1; if (!cbShow.Checked) { model.isShow = 0; } model.models = models; bll.Update(model); bindParentMenuAdd(); BindData(); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtTitleAdd.Text.Trim().Length == 0) { strErr += "名称不能为空!\\n"; } if (!PageValidate.IsNumber(txtOrderAdd.Text)) { strErr += "排序格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string title = this.txtTitleAdd.Text; int parentId = int.Parse(this.ddrNodeAdd.SelectedValue); int orders = int.Parse(txtOrderAdd.Text); string url = txtUrlAdd.Text; int types = int.Parse(this.ddrTypesAdd.SelectedValue); int models = 0; if (types == 4) { models = int.Parse(ddrModel.SelectedValue); } hm.Model.ed_node model = new hm.Model.ed_node(); model.title = title; model.parentId = parentId; model.pic = ""; model.types = types; model.orders = orders; model.url = url; model.isShow = 1; model.models = models; if (!cbShowAdd.Checked) { model.isShow = 0; } bll.Add(model); bindParentMenuAdd(); BindData(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(hm.Model.ed_node model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ed_node set "); strSql.Append("parentId=@parentId,"); strSql.Append("title=@title,"); strSql.Append("pic=@pic,"); strSql.Append("url=@url,"); strSql.Append("types=@types,"); strSql.Append("orders=@orders,"); strSql.Append("isShow=@isShow,"); strSql.Append("models=@models"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@parentId", OleDbType.Integer, 4), new OleDbParameter("@title", OleDbType.VarChar, 255), new OleDbParameter("@pic", OleDbType.VarChar, 255), new OleDbParameter("@url", OleDbType.VarChar, 255), new OleDbParameter("@types", OleDbType.Integer, 4), new OleDbParameter("@orders", OleDbType.Integer, 4), new OleDbParameter("@isShow", OleDbType.Integer, 4), new OleDbParameter("@models", OleDbType.Integer, 4), new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = model.parentId; parameters[1].Value = model.title; parameters[2].Value = model.pic; parameters[3].Value = model.url; parameters[4].Value = model.types; parameters[5].Value = model.orders; parameters[6].Value = model.isShow; parameters[7].Value = model.models; parameters[8].Value = model.ID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(hm.Model.ed_node model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ed_node("); strSql.Append("parentId,title,pic,url,types,orders,isShow,models)"); strSql.Append(" values ("); strSql.Append("@parentId,@title,@pic,@url,@types,@orders,@isShow,@models)"); OleDbParameter[] parameters = { new OleDbParameter("@parentId", OleDbType.Integer, 4), new OleDbParameter("@title", OleDbType.VarChar, 255), new OleDbParameter("@pic", OleDbType.VarChar, 255), new OleDbParameter("@url", OleDbType.VarChar, 255), new OleDbParameter("@types", OleDbType.Integer, 4), new OleDbParameter("@orders", OleDbType.Integer, 4), new OleDbParameter("@isShow", OleDbType.Integer, 4), new OleDbParameter("@models", OleDbType.Integer, 4) }; parameters[0].Value = model.parentId; parameters[1].Value = model.title; parameters[2].Value = model.pic; parameters[3].Value = model.url; parameters[4].Value = model.types; parameters[5].Value = model.orders; parameters[6].Value = model.isShow; parameters[7].Value = model.models; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }