public void BindData() { #region //if (!Context.User.Identity.IsAuthenticated) //{ // return; //} //AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name); //if (user.HasPermissionID(PermId_Modify)) //{ // gridView.Columns[6].Visible = true; //} //if (user.HasPermissionID(PermId_Delete)) //{ // gridView.Columns[7].Visible = true; //} #endregion DataSet ds = new DataSet(); StringBuilder strWhere = new StringBuilder(); if (txtKeyword.Text.Trim() != "") { #warning 代码生成警告:请修改 keywordField 为需要匹配查询的真实字段名称 //strWhere.AppendFormat("keywordField like '%{0}%'", txtKeyword.Text.Trim()); } ds = bll.GetList(strWhere.ToString()); gridView.DataSource = ds; gridView.DataBind(); }
/// <summary> /// /// </summary> /// <param name="sal_ID"></param> private void ShowInfo(int sta_ID) { DataSet ds = bll.GetList("sal_sta_id=" + sta_ID + " and sal_date=(SELECT MAX(t_staffsalary.sal_date) from t_staffsalary where sal_sta_id=" + sta_ID + ")"); WalleProject.Model.t_staffsalary model = new Model.t_staffsalary(); if (ds.Tables[0].Rows.Count != 0) { foreach (DataTable table in ds.Tables) { model = bll.GetModel(int.Parse(table.Rows[0]["sal_ID"].ToString())); } } this.lblsal_staff.Text = sta_ID.ToString(); if (model != null && model.sal_year == DateTime.Now.Year && model.sal_month == DateTime.Now.Month) { this.lblsal_ID.Text = model.sal_ID.ToString(); this.txtsal_bonusM.Text = model.sal_bonusM.ToString(); this.txtsal_describe.Value = model.sal_describe; this.txtsal_deductM.Text = model.sal_deductM.ToString(); this.txtsal_totalM.Text = model.sal_totalM.ToString(); this.txtsal_incrementM.Text = model.sal_incrementM.ToString(); this.txtSal_leaveDay.Text = model.Sal_leaveDay.ToString(); this.txtSal_absenteeismDay.Text = model.Sal_absenteeismDay.ToString(); } else { this.lblsal_ID.Text = new BLL.t_staffsalary().GetMaxId().ToString(); this.txtsal_bonusM.Text = "0.0"; this.txtsal_describe.Value = " "; this.txtsal_deductM.Text = "0.0"; this.txtsal_totalM.Text = new BLL.t_staff().GetModel(sta_ID).sta_salary.ToString(); this.txtsal_incrementM.Text = "0.0"; this.txtSal_leaveDay.Text = "0"; this.txtSal_absenteeismDay.Text = "0"; } }