C#个人重构之基本数据设定

【山巅远眺】

学习思路：但是不想用无参数的查询方法，就在U层没有传数据，但是在D层用了有参数的查询方法。

设计理念：设一个用户看不到的参数。但是需要在数据库里添加一个标识字段。我这里是10001. 用户只需要看到后面的五项数据即可！

SQL语句中的 where SerialID = 10001，很巧妙！有偷梁换柱、狸猫换太子的功效！

【披荆斩棘】

当窗体加载时

        private void UIFormBasicInformationSetting_Load(object sender, EventArgs e)
        {
            #region 控件的可用性
            btnSave.Enabled = false;
            txtTmpCost.Enabled = false;
            txtUnitTime.Enabled = false;
            txtLeastTime.Enabled = false;
            txtReadyTime.Enabled = false;
            txtLeastCost.Enabled = false;
            #endregion

            #region 加载基本数据表中的信息

            Entity.BasicDataInfo BasicDataInfo = new Entity.BasicDataInfo();
            BasicDataInfo.SerialID = 10001;
            Facade.QueryFacade facadeShowBasicDataInfo = new Facade.QueryFacade();
            List<Entity.BasicDataInfo> List = new List<Entity.BasicDataInfo>();
            List = facadeShowBasicDataInfo.showBasicDataInfo(BasicDataInfo);

            txtTmpCost.Text = List[0].TmpCost.ToString();
            txtUnitTime.Text = List[0].UnitTime.ToString();
            txtLeastTime.Text = List[0].LeastTime.ToString();
            txtReadyTime.Text = List[0].ReadyTime.ToString();
            txtLeastCost.Text = List[0].LeastCost.ToString();

            #endregion
        }

D层代码

        #region 基本数据设定：更新数据
        public bool updateBasicDataInfo(Entity.BasicDataInfo BasicDataInfo)
        {
            bool result = false;
            SqlHelper.SqlHelperAll sqlHelperUpdateBasicDataInfo = new SqlHelper.SqlHelperAll();
            string sql = "update BasicData_Info set TmpCost=@TmpCost,UnitTime=@UnitTime,LeastTime=@LeastTime,ReadyTiime=@ReadyTiime,LeastCost=@LeastCost where SerialID = 10001";
            SqlParameter[] sqlParams = { new SqlParameter("@SerialID", BasicDataInfo.SerialID), new SqlParameter("@TmpCost", BasicDataInfo.TmpCost), new SqlParameter("@UnitTime", BasicDataInfo.UnitTime), new SqlParameter("@LeastTime", BasicDataInfo.LeastTime), new SqlParameter("@ReadyTiime", BasicDataInfo.ReadyTime), new SqlParameter("@LeastCost", BasicDataInfo.LeastCost) };
            int res = sqlHelperUpdateBasicDataInfo.ExecuteNonQuery(sql,CommandType.Text,sqlParams);
            if (res>0)
            {
                result = true;
            }
            return result;
        }
        #endregion    

【筋斗云】