Beispiel #1
0
        /// <summary>
        /// ����һ������
        /// </summary>
        public int Add(Hoto.Model.sys_channel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into dt_sys_channel(");
            strSql.Append("model_id,name,title,sort_id)");
            strSql.Append(" values (");
            strSql.Append("@model_id,@name,@title,@sort_id)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@model_id", SqlDbType.Int,4),
                    new SqlParameter("@name", SqlDbType.NVarChar,100),
                    new SqlParameter("@title", SqlDbType.NVarChar,100),
                    new SqlParameter("@sort_id", SqlDbType.Int,4)};
            parameters[0].Value = model.model_id;
            parameters[1].Value = model.name;
            parameters[2].Value = model.title;
            parameters[3].Value = model.sort_id;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Beispiel #2
0
        /// <summary>
        /// ����һ������
        /// </summary>
        public int Add(Hoto.Model.attributes model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into dt_attributes(");
            strSql.Append("channel_id,title,remark,type,default_value,sort_id,add_time)");
            strSql.Append(" values (");
            strSql.Append("@channel_id,@title,@remark,@type,@default_value,@sort_id,@add_time)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@channel_id", SqlDbType.Int,4),
                    new SqlParameter("@title", SqlDbType.NVarChar,100),
                    new SqlParameter("@remark", SqlDbType.NVarChar,500),
                    new SqlParameter("@type", SqlDbType.Int,4),
                    new SqlParameter("@default_value", SqlDbType.NVarChar,500),
                    new SqlParameter("@sort_id", SqlDbType.Int,4),
                    new SqlParameter("@add_time", SqlDbType.DateTime)};
            parameters[0].Value = model.channel_id;
            parameters[1].Value = model.title;
            parameters[2].Value = model.remark;
            parameters[3].Value = model.type;
            parameters[4].Value = model.default_value;
            parameters[5].Value = model.sort_id;
            parameters[6].Value = model.add_time;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
Beispiel #3
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public int Add(Hoto.Model.users model)
 {
     return dal.Add(model);
 }
Beispiel #4
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public bool Update(Hoto.Model.users model)
 {
     return dal.Update(model);
 }
Beispiel #5
0
        /// <summary>
        /// ����һ������
        /// </summary>
        public bool Update(Hoto.Model.attributes model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("update dt_attributes set ");
            strSql.Append("[email protected]_id,");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected]_value,");
            strSql.Append("[email protected]_id,");
            strSql.Append("[email protected]_time");
            strSql.Append(" where [email protected]");
            SqlParameter[] parameters = {
                    new SqlParameter("@channel_id", SqlDbType.Int,4),
                    new SqlParameter("@title", SqlDbType.NVarChar,100),
                    new SqlParameter("@remark", SqlDbType.NVarChar,500),
                    new SqlParameter("@type", SqlDbType.Int,4),
                    new SqlParameter("@default_value", SqlDbType.NVarChar,500),
                    new SqlParameter("@sort_id", SqlDbType.Int,4),
                    new SqlParameter("@add_time", SqlDbType.DateTime),
                    new SqlParameter("@id", SqlDbType.Int,4)};
            parameters[0].Value = model.channel_id;
            parameters[1].Value = model.title;
            parameters[2].Value = model.remark;
            parameters[3].Value = model.type;
            parameters[4].Value = model.default_value;
            parameters[5].Value = model.sort_id;
            parameters[6].Value = model.add_time;
            parameters[7].Value = model.id;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Beispiel #6
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public int Add(Hoto.Model.manager_role model)
 {
     return dal.Add(model);
 }
Beispiel #7
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public bool Update(Hoto.Model.manager_role model)
 {
     return dal.Update(model);
 }
Beispiel #8
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public int Add(Hoto.Model.user_message model)
 {
     return dal.Add(model);
 }
Beispiel #9
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public bool Update(Hoto.Model.mail_template model)
 {
     return dal.Update(model);
 }
Beispiel #10
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public int Add(Hoto.Model.mail_template model)
 {
     return dal.Add(model);
 }
Beispiel #11
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(Hoto.Model.category model)
 {
     return dal.Add(model);
 }
Beispiel #12
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Hoto.Model.category model)
 {
     return dal.Update(model);
 }
Beispiel #13
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public bool Update(Hoto.Model.sys_model model)
 {
     return dal.Update(model);
 }
Beispiel #14
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public int Add(Hoto.Model.sys_model model)
 {
     return dal.Add(model);
 }
Beispiel #15
0
        /// <summary>
        /// ����һ������
        /// </summary>
        public bool Update(Hoto.Model.sys_channel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update dt_sys_channel set ");
            strSql.Append("[email protected]_id,");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected]_id");
            strSql.Append(" where [email protected]");
            SqlParameter[] parameters = {
                    new SqlParameter("@model_id", SqlDbType.Int,4),
                    new SqlParameter("@name", SqlDbType.NVarChar,100),
                    new SqlParameter("@title", SqlDbType.NVarChar,100),
                    new SqlParameter("@sort_id", SqlDbType.Int,4),
                    new SqlParameter("@id", SqlDbType.Int,4)};
            parameters[0].Value = model.model_id;
            parameters[1].Value = model.name;
            parameters[2].Value = model.title;
            parameters[3].Value = model.sort_id;
            parameters[4].Value = model.id;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
Beispiel #16
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Hoto.Model.category model)
 {
     using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
     {
         conn.Open();
         using (SqlTransaction trans = conn.BeginTransaction())
         {
             try
             {
                 //先判断选中的父节点是否被包含
                 if (IsContainNode(model.id, model.parent_id))
                 {
                     //查找旧数据
                     Model.category oldModel = GetModel(model.id);
                     //查找旧父节点数据
                     string class_list = "," + model.parent_id + ",";
                     int class_layer = 1;
                     if (oldModel.parent_id > 0)
                     {
                         Model.category oldParentModel = GetModel(conn, trans, oldModel.parent_id); //带事务
                         class_list = oldParentModel.class_list + model.parent_id + ",";
                         class_layer = oldParentModel.class_layer + 1;
                     }
                     //先提升选中的父节点
                     DbHelperSQL.ExecuteSql(conn, trans, "update dt_category set parent_id=" + oldModel.parent_id + ",class_list='" + class_list + "', class_layer=" + class_layer + " where id=" + model.parent_id); //带事务
                     UpdateChilds(conn, trans, model.parent_id); //带事务
                 }
                 //更新子节点
                 if (model.parent_id > 0)
                 {
                     Model.category model2 = GetModel(conn, trans, model.parent_id); //带事务
                     model.class_list = model2.class_list + model.id + ",";
                     model.class_layer = model2.class_layer + 1;
                 }
                 else
                 {
                     model.class_list = "," + model.id + ",";
                     model.class_layer = 1;
                 }
                 StringBuilder strSql = new StringBuilder();
                 strSql.Append("update dt_category set ");
                 strSql.Append("[email protected]_id,");
                 strSql.Append("[email protected],");
                 strSql.Append("[email protected]_index,");
                 strSql.Append("[email protected]_id,");
                 strSql.Append("[email protected]_list,");
                 strSql.Append("[email protected]_layer,");
                 strSql.Append("[email protected]_id,");
                 strSql.Append("[email protected]_url,");
                 strSql.Append("[email protected]_url,");
                 strSql.Append("[email protected],");
                 strSql.Append("[email protected]_title,");
                 strSql.Append("seo_keywo[email protected]_keywords,");
                 strSql.Append("[email protected]_description");
                 strSql.Append(" where [email protected]");
                 SqlParameter[] parameters = {
                         new SqlParameter("@channel_id", SqlDbType.Int,4),
                         new SqlParameter("@title", SqlDbType.NVarChar,100),
                         new SqlParameter("@call_index", SqlDbType.NVarChar,50),
                         new SqlParameter("@parent_id", SqlDbType.Int,4),
                         new SqlParameter("@class_list", SqlDbType.NVarChar,500),
                         new SqlParameter("@class_layer", SqlDbType.Int,4),
                         new SqlParameter("@sort_id", SqlDbType.Int,4),
                         new SqlParameter("@link_url", SqlDbType.NVarChar,255),
                         new SqlParameter("@img_url", SqlDbType.NVarChar,255),
                         new SqlParameter("@content", SqlDbType.NText),
                         new SqlParameter("@seo_title", SqlDbType.NVarChar,255),
                         new SqlParameter("@seo_keywords", SqlDbType.NVarChar,255),
                         new SqlParameter("@seo_description", SqlDbType.NVarChar,255),
                         new SqlParameter("@id", SqlDbType.Int,4)};
                 parameters[0].Value = model.channel_id;
                 parameters[1].Value = model.title;
                 parameters[2].Value = model.call_index;
                 parameters[3].Value = model.parent_id;
                 parameters[4].Value = model.class_list;
                 parameters[5].Value = model.class_layer;
                 parameters[6].Value = model.sort_id;
                 parameters[7].Value = model.link_url;
                 parameters[8].Value = model.img_url;
                 parameters[9].Value = model.content;
                 parameters[10].Value = model.seo_title;
                 parameters[11].Value = model.seo_keywords;
                 parameters[12].Value = model.seo_description;
                 parameters[13].Value = model.id;
                 DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
                 //更新子节点
                 UpdateChilds(conn, trans, model.id);
                 trans.Commit();
             }
             catch
             {
                 trans.Rollback();
                 return false;
             }
         }
     }
     return true;
 }
Beispiel #17
0
 /// <summary>
 /// ����һ������
 /// </summary>
 public bool Update(Hoto.Model.user_message model)
 {
     return dal.Update(model);
 }