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(); } } }
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); }