コード例 #1
0
        //保存修改
        protected void imgbtnsave_Click(object sender, ImageClickEventArgs e)
        {
            int id = int.Parse(this.hidval.Value);

            EtNet_Models.InitializeUserSet model = EtNet_BLL.InitializeUserSetManager.GetModel(id);
            if (this.chkdata.Checked)
            {
                model.pagecount = int.Parse(this.iptpagecount.Value);
                model.pageitem  = int.Parse(this.iptpageitem.Value);
                ModifyDataList(model.siftopen, model.pagecount, model.pageitem);
            }
            if (this.chkinformation.Checked)
            {
                model.newinforemind = int.Parse(this.ddlnewinforemind.SelectedValue);
                model.infocycle     = int.Parse(this.iptinfocycle.Value);
            }
            if (this.chkpanel.Checked)
            {
                model.panelcount = this.iptpanelcount.Value;
                //model.panelcols = int.Parse(this.ddlpanelcols.SelectedValue);
            }
            if (EtNet_BLL.InitializeUserSetManager.Update(model))
            {
                Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "modify", "<script>alert('保存成功!')</script>", false);
            }
        }
コード例 #2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public static int Add(EtNet_Models.InitializeUserSet model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into InitializeUserSet(");
            strSql.Append("cname,siftopen,pagecount,pageitem,inforemind,newinforemind,infocycle,createtime,panellistall,panellist,panelcount,panelcols,createrid)");
            strSql.Append(" values (");
            strSql.Append("@cname,@siftopen,@pagecount,@pageitem,@inforemind,@newinforemind,@infocycle,@createtime,@panellistall,@panellist,@panelcount,@panelcols,@createrid)");
            strSql.Append(";select SCOPE_IDENTITY() ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@cname",         SqlDbType.VarChar,    50),
                new SqlParameter("@siftopen",      SqlDbType.Int,         4),
                new SqlParameter("@pagecount",     SqlDbType.Int,         4),
                new SqlParameter("@pageitem",      SqlDbType.Int,         4),
                new SqlParameter("@inforemind",    SqlDbType.Int,         4),
                new SqlParameter("@newinforemind", SqlDbType.Int,         4),
                new SqlParameter("@infocycle",     SqlDbType.Int,         4),
                new SqlParameter("@createtime",    SqlDbType.DateTime),
                new SqlParameter("@panellistall",  SqlDbType.VarChar,   100),
                new SqlParameter("@panellist",     SqlDbType.VarChar,   100),
                new SqlParameter("@panelcount",    SqlDbType.VarChar,   100),
                new SqlParameter("@panelcols",     SqlDbType.Int,         4),
                new SqlParameter("@createrid",     SqlDbType.Int, 4)
            };
            parameters[0].Value  = model.cname;
            parameters[1].Value  = model.siftopen;
            parameters[2].Value  = model.pagecount;
            parameters[3].Value  = model.pageitem;
            parameters[4].Value  = model.inforemind;
            parameters[5].Value  = model.newinforemind;
            parameters[6].Value  = model.infocycle;
            parameters[7].Value  = model.createtime;
            parameters[8].Value  = model.panellistall;
            parameters[9].Value  = model.panellist;
            parameters[10].Value = model.panelcount;
            parameters[11].Value = model.panelcols;
            parameters[12].Value = model.createrid;

            int           result = 0;
            SqlDataReader rad    = EtNet_DAL.DBHelper.ExecuteReader(strSql.ToString(), parameters);

            if (rad.Read())
            {
                result = Convert.ToInt32(rad[0]);
                rad.Close();
            }

            return(result);
        }
コード例 #3
0
        /// <summary>
        /// 修改用户参数设置
        /// </summary>
        private void ResetUserSet()
        {
            SaveInitializeSet(); //保存参数设置

            int id = int.Parse(this.hidval.Value);

            EtNet_Models.InitializeSet model = EtNet_BLL.InitializeSetManager.GetModel(id);

            string[] list = null; //用户的id值列表
            if (this.hiduserlist.Value.IndexOf(',') != -1)
            {
                list = this.hiduserlist.Value.Split(',');
            }
            else
            {
                list = new string[1] {
                    this.hiduserlist.Value
                };
            }
            int founderid = 0; //用户的id值

            for (int i = 0; i < list.Length; i++)
            {
                founderid = int.Parse(list[i]);
                string strdel = " createrid=" + founderid;
                EtNet_BLL.InitializeUserSetManager.Del(strdel); //删除用户参数设置

                EtNet_Models.InitializeUserSet user = new EtNet_Models.InitializeUserSet();
                user.cname         = model.cname;
                user.createrid     = founderid;
                user.createtime    = DateTime.Now;
                user.infocycle     = model.infocycle;
                user.inforemind    = model.inforemind;
                user.newinforemind = model.newinforemind;
                user.pagecount     = model.pagecount;
                user.pageitem      = model.pageitem;
                user.panelcols     = model.panelcols;
                user.panelcount    = model.panelcount;
                user.panellist     = model.panellist;
                user.panellistall  = model.panellistall;
                user.siftopen      = model.siftopen;
                EtNet_BLL.InitializeUserSetManager.Add(user);

                ModifyDataList(founderid, model.siftopen, model.pagecount, model.pageitem);
                ModifyPanelMenuRecord(founderid, model.panelcols);
                ModifyPanelItem(founderid, model.panellist);
            }
        }
コード例 #4
0
        /// <summary>
        /// 创建用户的初始化参数
        /// </summary>
        /// <param name="ownersid">用户的id值</param>
        private void CreateInitializeData(int ownersid)
        {
            DataTable tbl = EtNet_BLL.InitializeSetManager.GetList(1, "", "id");

            if (tbl.Rows.Count == 1)
            {
                string strpagenum = "001,002,003,004,008,011,013,014,019,020,021,022,024,025,030,";
                strpagenum += "100,101,102,105,111,140,201";
                string[] list = strpagenum.Split(',');
                EtNet_Models.SearchPageSet model = null;
                for (int i = 0; i < list.Length; i++)
                {
                    model           = new EtNet_Models.SearchPageSet();
                    model.Ownersid  = ownersid;
                    model.Pagenum   = list[i];
                    model.Pagecount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
                    model.Pageitem  = int.Parse(tbl.Rows[0]["pageitem"].ToString());
                    EtNet_BLL.SearchPageSetManager.addSearchPageSet(model);
                }

                EtNet_Models.InitializeUserSet usermodel = new EtNet_Models.InitializeUserSet();
                usermodel.cname         = tbl.Rows[0]["cname"].ToString();
                usermodel.createtime    = DateTime.Now;
                usermodel.infocycle     = int.Parse(tbl.Rows[0]["infocycle"].ToString());
                usermodel.inforemind    = int.Parse(tbl.Rows[0]["inforemind"].ToString());
                usermodel.newinforemind = int.Parse(tbl.Rows[0]["newinforemind"].ToString());
                usermodel.pagecount     = int.Parse(tbl.Rows[0]["pagecount"].ToString());
                usermodel.pageitem      = int.Parse(tbl.Rows[0]["pageitem"].ToString());
                usermodel.panelcols     = int.Parse(tbl.Rows[0]["panelcols"].ToString());
                usermodel.panelcount    = tbl.Rows[0]["panelcount"].ToString();
                usermodel.panellist     = tbl.Rows[0]["panellist"].ToString();
                usermodel.panellistall  = tbl.Rows[0]["panellistall"].ToString();
                usermodel.createrid     = ownersid;
                EtNet_BLL.InitializeUserSetManager.Add(usermodel);
                PanelMenuRecord(ownersid, usermodel.panelcols);
                FirstPanelItem(ownersid, usermodel.panellist);
            }
        }
コード例 #5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public static EtNet_Models.InitializeUserSet GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 * from InitializeUserSet ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@id", SqlDbType.Int, 4)
            };
            parameters[0].Value = id;

            EtNet_Models.InitializeUserSet model = new EtNet_Models.InitializeUserSet();
            DataTable tbl = EtNet_DAL.DBHelper.GetDataSet(strSql.ToString(), parameters);

            if (tbl.Rows.Count > 0)
            {
                model.id            = int.Parse(tbl.Rows[0]["id"].ToString());
                model.cname         = tbl.Rows[0]["cname"].ToString();
                model.siftopen      = int.Parse(tbl.Rows[0]["siftopen"].ToString());
                model.pagecount     = int.Parse(tbl.Rows[0]["pagecount"].ToString());
                model.pageitem      = int.Parse(tbl.Rows[0]["pageitem"].ToString());
                model.inforemind    = int.Parse(tbl.Rows[0]["inforemind"].ToString());
                model.newinforemind = int.Parse(tbl.Rows[0]["newinforemind"].ToString());
                model.infocycle     = int.Parse(tbl.Rows[0]["infocycle"].ToString());
                model.createtime    = DateTime.Parse(tbl.Rows[0]["createtime"].ToString());
                model.panellistall  = tbl.Rows[0]["panellistall"].ToString();
                model.panellist     = tbl.Rows[0]["panellist"].ToString();
                model.panelcount    = tbl.Rows[0]["panelcount"].ToString();
                model.panelcols     = int.Parse(tbl.Rows[0]["panelcols"].ToString());
                model.createrid     = int.Parse(tbl.Rows[0]["createrid"].ToString());
                return(model);
            }
            else
            {
                return(null);
            }
        }
コード例 #6
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public static bool Update(EtNet_Models.InitializeUserSet model)
 {
     return(EtNet_DAL.InitializeUserSetService.Update(model));
 }
コード例 #7
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public static int  Add(EtNet_Models.InitializeUserSet model)
 {
     return(EtNet_DAL.InitializeUserSetService.Add(model));
 }
コード例 #8
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public static bool Update(EtNet_Models.InitializeUserSet model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update InitializeUserSet set ");
            strSql.Append("cname=@cname,");
            strSql.Append("siftopen=@siftopen,");
            strSql.Append("pagecount=@pagecount,");
            strSql.Append("pageitem=@pageitem,");
            strSql.Append("inforemind=@inforemind,");
            strSql.Append("newinforemind=@newinforemind,");
            strSql.Append("infocycle=@infocycle,");
            strSql.Append("createtime=@createtime,");
            strSql.Append("panellistall=@panellistall,");
            strSql.Append("panellist=@panellist,");
            strSql.Append("panelcount=@panelcount,");
            strSql.Append("panelcols=@panelcols,");
            strSql.Append("createrid=@createrid");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters =
            {
                new SqlParameter("@cname",         SqlDbType.VarChar,    50),
                new SqlParameter("@siftopen",      SqlDbType.Int,         4),
                new SqlParameter("@pagecount",     SqlDbType.Int,         4),
                new SqlParameter("@pageitem",      SqlDbType.Int,         4),
                new SqlParameter("@inforemind",    SqlDbType.Int,         4),
                new SqlParameter("@newinforemind", SqlDbType.Int,         4),
                new SqlParameter("@infocycle",     SqlDbType.Int,         4),
                new SqlParameter("@createtime",    SqlDbType.DateTime),
                new SqlParameter("@panellistall",  SqlDbType.VarChar,   100),
                new SqlParameter("@panellist",     SqlDbType.VarChar,   100),
                new SqlParameter("@panelcount",    SqlDbType.VarChar,   100),
                new SqlParameter("@panelcols",     SqlDbType.Int,         4),
                new SqlParameter("@createrid",     SqlDbType.Int,         4),
                new SqlParameter("@id",            SqlDbType.Int, 4)
            };

            parameters[0].Value  = model.cname;
            parameters[1].Value  = model.siftopen;
            parameters[2].Value  = model.pagecount;
            parameters[3].Value  = model.pageitem;
            parameters[4].Value  = model.inforemind;
            parameters[5].Value  = model.newinforemind;
            parameters[6].Value  = model.infocycle;
            parameters[7].Value  = model.createtime;
            parameters[8].Value  = model.panellistall;
            parameters[9].Value  = model.panellist;
            parameters[10].Value = model.panelcount;
            parameters[11].Value = model.panelcols;
            parameters[12].Value = model.createrid;
            parameters[13].Value = model.id;

            int result = EtNet_DAL.DBHelper.ExecuteCommand(strSql.ToString(), parameters);

            if (result >= 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }