private bool DoEdit(int _id) { try { BLL.pro_category bll = new BLL.pro_category(); Model.pro_category model = bll.GetModel(_id); model.title = txtTitle.Text; model.img = txtImgUrl.Text; model.img2 = txtImgUrl2.Text; if (model.is_sys != 1) { model.parent_id = Convert.ToInt32(ddlParentId.SelectedValue); } model.sort = Convert.ToInt32(txtSortId.Text); if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改产品栏目分类:" + model.title); //记录日志 return(true); } } catch { return(false); } return(false); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.pro_category</param> /// <returns>ID</returns> public int Add(Model.pro_category model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "pro_category]("); strSql.Append("title,img,img2,parent_id,sort,is_sys"); strSql.Append(") values("); strSql.Append("@title,@img,@img2,@parent_id,@sort,@is_sys)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@img", SqlDbType.NText), new SqlParameter("@img2", SqlDbType.NText), new SqlParameter("@parent_id", SqlDbType.Int, 4), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.title; parameters[1].Value = model.img; parameters[2].Value = model.img2; parameters[3].Value = model.parent_id; parameters[4].Value = model.sort; parameters[5].Value = model.is_sys; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.pro_category</param> /// <returns>True or False</returns> public bool Update(Model.pro_category model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "pro_category] set "); strSql.Append("title=@title,"); strSql.Append("img=@img,"); strSql.Append("img2=@img2,"); strSql.Append("parent_id=@parent_id,"); strSql.Append("sort=@sort,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@img", SqlDbType.NText), new SqlParameter("@img2", SqlDbType.NText), new SqlParameter("@parent_id", SqlDbType.Int, 4), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.title; parameters[1].Value = model.img; parameters[2].Value = model.img2; parameters[3].Value = model.parent_id; parameters[4].Value = model.sort; parameters[5].Value = model.is_sys; parameters[6].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
private bool DoAdd() { try { Model.pro_category model = new Model.pro_category(); BLL.pro_category bll = new BLL.pro_category(); model.title = txtTitle.Text; model.img = txtImgUrl.Text; model.parent_id = Convert.ToInt32(ddlParentId.SelectedValue); model.sort = Convert.ToInt32(txtSortId.Text); model.is_sys = 0; if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加产品栏目分类:" + model.title); //记录日志 return(true); } } catch { return(false); } return(false); }
/// <summary> /// 组合成对象实体 /// </summary> /// <param name="row">一行数据</param> /// <returns>Model.pro_category</returns> private Model.pro_category DataRowToModel(DataRow row) { Model.pro_category model = new Model.pro_category(); if (row != null) { if (null != row["id"] && "" != row["id"].ToString()) { model.id = int.Parse(row["id"].ToString()); } if (null != row["title"]) { model.title = row["title"].ToString(); } if (null != row["img"]) { model.img = row["img"].ToString(); } if (null != row["img2"]) { model.img2 = row["img2"].ToString(); } if (null != row["parent_id"] && "" != row["parent_id"].ToString()) { model.parent_id = int.Parse(row["parent_id"].ToString()); } if (null != row["sort"] && "" != row["sort"].ToString()) { model.sort = int.Parse(row["sort"].ToString()); } if (null != row["is_sys"] && "" != row["is_sys"].ToString()) { model.is_sys = int.Parse(row["is_sys"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.pro_category</param> /// <returns>True Or False</returns> public bool Update(Model.pro_category model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.pro_category</param> /// <returns>ID</returns> public int Add(Model.pro_category model) { return(dal.Add(model)); }