using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using BLL;

namespace FineUIPro.Web.ZHGL.InformationProject
{
    public partial class BoardData : PageBase
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                loadData();
            }
        }

        private void loadData()
        {
            var data = Funs.DB.Sys_Const.Where(x => x.GroupId == "BoardData").ToList();
            if (data.Count > 0)
            {
                #region 加载数据
                NumberBox1.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox1").ConstValue;
                NumberBox2.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox2").ConstValue;
                NumberBox3.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox3").ConstValue;
                NumberBox4.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox4").ConstValue;
                NumberBox5.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox5").ConstValue;
                NumberBox6.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox6").ConstValue;
                NumberBox7.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox7").ConstValue;
                NumberBox8.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox8").ConstValue;
                NumberBox9.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox9").ConstValue;
                NumberBox10.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox10").ConstValue;
                NumberBox11.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox11").ConstValue;
                NumberBox12.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox12").ConstValue;
                NumberBox13.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox13").ConstValue;
                NumberBox14.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox14").ConstValue;
                NumberBox15.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox15").ConstValue;
                NumberBox16.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox16").ConstValue;
                NumberBox17.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox17").ConstValue;
                NumberBox18.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox18").ConstValue;
                NumberBox19.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox19").ConstValue;
                NumberBox20.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox20").ConstValue;

                NumberBox21.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox21").ConstValue;
                NumberBox22.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox22").ConstValue;
                NumberBox23.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox23").ConstValue;
                NumberBox24.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox24").ConstValue;
                NumberBox25.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox25").ConstValue;
                NumberBox26.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox26").ConstValue;
                NumberBox27.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox27").ConstValue;
                NumberBox28.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox28").ConstValue;
                NumberBox29.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox29").ConstValue;
                NumberBox30.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox30").ConstValue;
                NumberBox31.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox31").ConstValue;
                NumberBox32.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox32").ConstValue;
                NumberBox33.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox33").ConstValue;
                NumberBox34.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox34").ConstValue;
                NumberBox35.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox35").ConstValue;
                NumberBox36.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox36").ConstValue;
                NumberBox37.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox37").ConstValue;
                NumberBox38.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox38").ConstValue;
                NumberBox39.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox39").ConstValue;
                NumberBox40.Text = data.FirstOrDefault(x => x.ConstText == "NumberBox40").ConstValue;
                #endregion


            }
        }
        public List<Model.Sys_Const> listConst = new List<Model.Sys_Const>();

        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnSave_OnClick(object sender, EventArgs e)
        {
            listConst.Clear();
            //先删除所有const表中BoardData的数据
            var data = Funs.DB.Sys_Const.Where(x => x.GroupId == "BoardData").ToList();
            if (data.Count > 0)
            {
                Funs.DB.Sys_Const.DeleteAllOnSubmit(data);
            }

            InsertSysConst(NumberBox1.Text, "NumberBox1");
            InsertSysConst(NumberBox2.Text, "NumberBox2");
            InsertSysConst(NumberBox3.Text, "NumberBox3");
            InsertSysConst(NumberBox4.Text, "NumberBox4");
            InsertSysConst(NumberBox5.Text, "NumberBox5");
            InsertSysConst(NumberBox6.Text, "NumberBox6");
            InsertSysConst(NumberBox7.Text, "NumberBox7");
            InsertSysConst(NumberBox8.Text, "NumberBox8");
            InsertSysConst(NumberBox9.Text, "NumberBox9");
            InsertSysConst(NumberBox10.Text, "NumberBox10");

            InsertSysConst(NumberBox11.Text, "NumberBox11");
            InsertSysConst(NumberBox12.Text, "NumberBox12");
            InsertSysConst(NumberBox13.Text, "NumberBox13");
            InsertSysConst(NumberBox14.Text, "NumberBox14");
            InsertSysConst(NumberBox15.Text, "NumberBox15");
            InsertSysConst(NumberBox16.Text, "NumberBox16");
            InsertSysConst(NumberBox17.Text, "NumberBox17");
            InsertSysConst(NumberBox18.Text, "NumberBox18");
            InsertSysConst(NumberBox19.Text, "NumberBox19");
            InsertSysConst(NumberBox20.Text, "NumberBox20");

            InsertSysConst(NumberBox21.Text, "NumberBox21");
            InsertSysConst(NumberBox22.Text, "NumberBox22");
            InsertSysConst(NumberBox23.Text, "NumberBox23");
            InsertSysConst(NumberBox24.Text, "NumberBox24");
            InsertSysConst(NumberBox25.Text, "NumberBox25");
            InsertSysConst(NumberBox26.Text, "NumberBox26");
            InsertSysConst(NumberBox27.Text, "NumberBox27");
            InsertSysConst(NumberBox28.Text, "NumberBox28");
            InsertSysConst(NumberBox29.Text, "NumberBox29");
            InsertSysConst(NumberBox30.Text, "NumberBox30");

            InsertSysConst(NumberBox31.Text, "NumberBox31");
            InsertSysConst(NumberBox32.Text, "NumberBox32");
            InsertSysConst(NumberBox33.Text, "NumberBox33");
            InsertSysConst(NumberBox34.Text, "NumberBox34");
            InsertSysConst(NumberBox35.Text, "NumberBox35");
            InsertSysConst(NumberBox36.Text, "NumberBox36");
            InsertSysConst(NumberBox37.Text, "NumberBox37");
            InsertSysConst(NumberBox38.Text, "NumberBox38");
            InsertSysConst(NumberBox39.Text, "NumberBox39");
            InsertSysConst(NumberBox40.Text, "NumberBox40");


            if (listConst.Count > 1)
            {
                Funs.DB.Sys_Const.InsertAllOnSubmit(listConst);
                Funs.DB.SubmitChanges();
                ShowNotify("保存成功", MessageBoxIcon.Success);
                loadData();
            }
        }

        private void InsertSysConst(string constValue, string constText)
        {
            //逐个添加
            var model = new Model.Sys_Const();
            model.ID = Guid.NewGuid().ToString();
            model.GroupId = "BoardData";
            if (string.IsNullOrEmpty(constValue))
            {
                constValue = "0";
            }
            model.ConstValue = constValue;
            model.ConstText = constText;

            listConst.Add(model);
        }

        #region 附件上传
        /// <summary>
        /// 上传附件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnAttachUrl_Click(object sender, EventArgs e)
        {
            PageContext.RegisterStartupScript(WindowAtt.GetShowReference(String.Format("~/AttachFile/webuploader.aspx?toKeyId={0}&path=FileUpload/BoardData&menuId={1}",
                "BoardDataImg", BLL.Const.BoardDataMenuId)));
        }
        #endregion
    }
}