/// <summary> /// 增加一条数据,及其子表数据 /// </summary> public int Add(DTcms.Model.sys_model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_sys_model("); strSql.Append("title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys)"); strSql.Append(" values ("); strSql.Append("@title,@sort_id,@inherit_index,@inherit_list,@inherit_detail,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@inherit_index", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_list", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_detail", SqlDbType.NVarChar, 255), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = model.title; parameters[1].Value = model.sort_id; parameters[2].Value = model.inherit_index; parameters[3].Value = model.inherit_list; parameters[4].Value = model.inherit_detail; parameters[5].Value = model.is_sys; parameters[6].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); StringBuilder strSql2; foreach (DTcms.Model.sys_model_nav models in model.sys_model_navs) { strSql2 = new StringBuilder(); strSql2.Append("insert into dt_sys_model_nav("); strSql2.Append("model_id,title,nav_url,sort_id)"); strSql2.Append(" values ("); strSql2.Append("@model_id,@title,@nav_url,@sort_id)"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@nav_url", SqlDbType.NVarChar, 255), new SqlParameter("@sort_id", SqlDbType.Int, 4) }; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[6].Value); }
private void ShowInfo(int _id) { DTcms.BLL.sys_model bll = new BLL.sys_model(); DTcms.Model.sys_model model = bll.GetModel(_id); txtTitle.Text = model.title; txtSortId.Text = model.sort_id.ToString(); txtInheritIndex.Text = model.inherit_index; txtInheritList.Text = model.inherit_list; txtInheritDetail.Text = model.inherit_detail; rptNavList.DataSource = model.sys_model_navs; rptNavList.DataBind(); }
private bool DoEdit(int _id) { bool result = true; DTcms.BLL.sys_model bll = new BLL.sys_model(); DTcms.Model.sys_model model = bll.GetModel(_id); string nav_id = Request.Form["nav_id"]; string nav_title = Request.Form["nav_title"]; string nav_url = Request.Form["nav_url"]; string nav_sort = Request.Form["nav_sort"]; if (!string.IsNullOrEmpty(nav_id) && !string.IsNullOrEmpty(nav_title) && !string.IsNullOrEmpty(nav_url) && !string.IsNullOrEmpty(nav_sort)) { try { string[] idArr = nav_id.Split(','); string[] titleArr = nav_title.Split(','); string[] urlArr = nav_url.Split(','); string[] sortArr = nav_sort.Split(','); List <DTcms.Model.sys_model_nav> ls = new List <Model.sys_model_nav>(); for (int i = 0; i < titleArr.Length; i++) { ls.Add(new DTcms.Model.sys_model_nav { id = int.Parse(idArr[i]), model_id = model.id, title = titleArr[i], nav_url = urlArr[i], sort_id = int.Parse(sortArr[i].Trim()) }); } model.sys_model_navs = ls; } catch { result = false; } } model.title = txtTitle.Text.Trim(); model.sort_id = int.Parse(txtSortId.Text.Trim()); model.inherit_index = txtInheritIndex.Text.Trim(); model.inherit_list = txtInheritList.Text.Trim(); model.inherit_detail = txtInheritDetail.Text.Trim(); if (!bll.Update(model)) { result = false; } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public DTcms.Model.sys_model GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys from dt_sys_model "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; DTcms.Model.sys_model model = new DTcms.Model.sys_model(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region 父表信息 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]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["inherit_index"] != null && ds.Tables[0].Rows[0]["inherit_index"].ToString() != "") { model.inherit_index = ds.Tables[0].Rows[0]["inherit_index"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_list"] != null && ds.Tables[0].Rows[0]["inherit_list"].ToString() != "") { model.inherit_list = ds.Tables[0].Rows[0]["inherit_list"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_detail"] != null && ds.Tables[0].Rows[0]["inherit_detail"].ToString() != "") { model.inherit_detail = ds.Tables[0].Rows[0]["inherit_detail"].ToString(); } if (ds.Tables[0].Rows[0]["is_sys"] != null && ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } #endregion 父表信息end #region 子表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,model_id,title,nav_url,sort_id from dt_sys_model_nav "); strSql2.Append(" where model_id=@model_id "); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4) }; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { #region 子表字段信息 int i = ds2.Tables[0].Rows.Count; List <DTcms.Model.sys_model_nav> models = new List <DTcms.Model.sys_model_nav>(); DTcms.Model.sys_model_nav modelt; for (int n = 0; n < i; n++) { modelt = new DTcms.Model.sys_model_nav(); if (ds2.Tables[0].Rows[n]["id"] != null && ds2.Tables[0].Rows[n]["id"].ToString() != "") { modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString()); } if (ds2.Tables[0].Rows[n]["model_id"] != null && ds2.Tables[0].Rows[n]["model_id"].ToString() != "") { modelt.model_id = int.Parse(ds2.Tables[0].Rows[n]["model_id"].ToString()); } if (ds2.Tables[0].Rows[n]["title"] != null && ds2.Tables[0].Rows[n]["title"].ToString() != "") { modelt.title = ds2.Tables[0].Rows[n]["title"].ToString(); } if (ds2.Tables[0].Rows[n]["nav_url"] != null && ds2.Tables[0].Rows[n]["nav_url"].ToString() != "") { modelt.nav_url = ds2.Tables[0].Rows[n]["nav_url"].ToString(); } if (ds2.Tables[0].Rows[n]["sort_id"] != null && ds2.Tables[0].Rows[n]["sort_id"].ToString() != "") { modelt.sort_id = int.Parse(ds2.Tables[0].Rows[n]["sort_id"].ToString()); } models.Add(modelt); } model.sys_model_navs = models; #endregion 子表字段信息end } #endregion 子表信息end return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DTcms.Model.sys_model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_sys_model set "); strSql.Append("title=@title,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("inherit_index=@inherit_index,"); strSql.Append("inherit_list=@inherit_list,"); strSql.Append("inherit_detail=@inherit_detail,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@inherit_index", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_list", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_detail", SqlDbType.NVarChar, 255), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.title; parameters[1].Value = model.sort_id; parameters[2].Value = model.inherit_index; parameters[3].Value = model.inherit_list; parameters[4].Value = model.inherit_detail; parameters[5].Value = model.is_sys; parameters[6].Value = model.id; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); if (model.sys_model_navs != null) { StringBuilder strSql2; foreach (DTcms.Model.sys_model_nav models in model.sys_model_navs) { strSql2 = new StringBuilder(); if (models.id > 0) { strSql2.Append("update dt_sys_model_nav set "); strSql2.Append("model_id=@model_id,"); strSql2.Append("title=@title,"); strSql2.Append("nav_url=@nav_url,"); strSql2.Append("sort_id=@sort_id"); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@nav_url", SqlDbType.NVarChar, 255), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters2[0].Value = models.model_id; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; parameters2[4].Value = models.id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } else { strSql2.Append("insert into dt_sys_model_nav("); strSql2.Append("model_id,title,nav_url,sort_id)"); strSql2.Append(" values ("); strSql2.Append("@model_id,@title,@nav_url,@sort_id)"); strSql2.Append(";select @@IDENTITY"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@nav_url", SqlDbType.NVarChar, 255), new SqlParameter("@sort_id", SqlDbType.Int, 4) }; parameters2[0].Value = models.model_id; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } } int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public DTcms.Model.sys_model GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys from dt_sys_model "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; DTcms.Model.sys_model model = new DTcms.Model.sys_model(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region ������Ϣ 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]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["inherit_index"] != null && ds.Tables[0].Rows[0]["inherit_index"].ToString() != "") { model.inherit_index = ds.Tables[0].Rows[0]["inherit_index"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_list"] != null && ds.Tables[0].Rows[0]["inherit_list"].ToString() != "") { model.inherit_list = ds.Tables[0].Rows[0]["inherit_list"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_detail"] != null && ds.Tables[0].Rows[0]["inherit_detail"].ToString() != "") { model.inherit_detail = ds.Tables[0].Rows[0]["inherit_detail"].ToString(); } if (ds.Tables[0].Rows[0]["is_sys"] != null && ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } #endregion ������Ϣend #region �ӱ���Ϣ StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,model_id,title,nav_url,sort_id from dt_sys_model_nav "); strSql2.Append(" where model_id=@model_id "); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int,4)}; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { #region �ӱ��ֶ���Ϣ int i = ds2.Tables[0].Rows.Count; List<DTcms.Model.sys_model_nav> models = new List<DTcms.Model.sys_model_nav>(); DTcms.Model.sys_model_nav modelt; for (int n = 0; n < i; n++) { modelt = new DTcms.Model.sys_model_nav(); if (ds2.Tables[0].Rows[n]["id"] != null && ds2.Tables[0].Rows[n]["id"].ToString() != "") { modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString()); } if (ds2.Tables[0].Rows[n]["model_id"] != null && ds2.Tables[0].Rows[n]["model_id"].ToString() != "") { modelt.model_id = int.Parse(ds2.Tables[0].Rows[n]["model_id"].ToString()); } if (ds2.Tables[0].Rows[n]["title"] != null && ds2.Tables[0].Rows[n]["title"].ToString() != "") { modelt.title = ds2.Tables[0].Rows[n]["title"].ToString(); } if (ds2.Tables[0].Rows[n]["nav_url"] != null && ds2.Tables[0].Rows[n]["nav_url"].ToString() != "") { modelt.nav_url = ds2.Tables[0].Rows[n]["nav_url"].ToString(); } if (ds2.Tables[0].Rows[n]["sort_id"] != null && ds2.Tables[0].Rows[n]["sort_id"].ToString() != "") { modelt.sort_id = int.Parse(ds2.Tables[0].Rows[n]["sort_id"].ToString()); } models.Add(modelt); } model.sys_model_navs = models; #endregion �ӱ��ֶ���Ϣend } #endregion �ӱ���Ϣend return model; } else { return null; } }