Exemplo n.º 1
0
        /// <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);
        }
Exemplo n.º 4
0
        /// <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);
            }
        }
Exemplo n.º 5
0
        /// <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);
            }
        }
Exemplo n.º 6
0
        /// <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;
            }
        }