示例#1
0
        private void LoadData()
        {
            string strWhere = string.Format("ParameterNO in ('{0}','{1}')", "JH_StartDate", "JH_EndDate");

            BLL.tb_SYS_Parameter bllParameter = new BLL.tb_SYS_Parameter();
            DataTable            dt           = bllParameter.GetList(strWhere).Tables[0];

            foreach (DataRow dr in dt.Rows)
            {
                if (dr["ParameterNO"].ToString() == "JH_StartDate")
                {
                    dapStartDate.Text = (dr["Value"].ToString() == "") ? DateTime.Today.AddDays(-90).ToString() : dr["Value"].ToString();
                }
                else
                {
                    dapEndDate.Text = (dr["Value"].ToString() == "") ? DateTime.Today.AddDays(90).ToString() : dr["Value"].ToString();
                }
            }
        }
示例#2
0
        protected void btnResearch_Click(object sender, EventArgs e)
        {
            BindGrid();
            BLL.tb_SYS_Parameter bllParameter = new BLL.tb_SYS_Parameter();
            string startDateID = bllParameter.GetList("ParameterNO='JH_StartDate'").Tables[0].Rows[0]["ID"].ToString();
            string endDateID   = bllParameter.GetList("ParameterNO='JH_EndDate'").Tables[0].Rows[0]["ID"].ToString();

            Model.tb_SYS_Parameter modelParameter = new Model.tb_SYS_Parameter();
            //更新起始时间
            modelParameter.ID          = startDateID;
            modelParameter.ParameterNO = "JH_StartDate";
            modelParameter.Value       = dapStartDate.Text;
            modelParameter.Status      = "Y";
            bllParameter.Update(modelParameter);
            //更新截至时间
            modelParameter.ID          = endDateID;
            modelParameter.ParameterNO = "JH_EndDate";
            modelParameter.Value       = dapEndDate.Text;
            bllParameter.Update(modelParameter);
        }