//按时间查询
public void FindByTime()
{
try
{
ViewState["page"] = 3;
List <Common.Entities.Award> list = award.FindByAchievementTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"]));
Grid_Award.RecordCount = list.Count();
if (list != null)
{
Grid_Award.DataSource = list.Skip(Grid_Award.PageIndex * Grid_Award.PageSize).Take(Grid_Award.PageSize);
Grid_Award.DataBind();
}
}
catch (Exception ex)
{
pm.SaveError(ex, this.Request);
}
}
//按成员查询
private void FindByMember()
{
try
{
ViewState["page"] = 10;
List <Common.Entities.Award> list = award.FindByMember(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
Grid_Award.RecordCount = list.Count();
if (list != null)
{
Grid_Award.DataSource = list.Skip(Grid_Award.PageIndex * Grid_Award.PageSize).Take(Grid_Award.PageSize);
Grid_Award.DataBind();
}
}
catch (Exception ex)
{
pm.SaveError(ex, this.Request);
}
}
//全选按钮
protected void btnSelect_All_Click(object sender, EventArgs e)
{
Grid_Award.SelectAllRows();
int[] select = Grid_Award.SelectedRowIndexArray;
int m;
//取整数（不是四舍五入，全舍）
int Pages = (int)Math.Floor(Convert.ToDouble(Grid_Award.RecordCount / this.Grid_Award.PageSize));
if (Grid_Award.PageIndex == Pages)
{
m = (Grid_Award.RecordCount - this.Grid_Award.PageSize * Grid_Award.PageIndex);
}
else
{
m = this.Grid_Award.PageSize;
}
bool isCheck = false;
for (int i = 0; i < m; i++)
{
if (CBoxSelect.GetCheckedState(i) == false)
{
isCheck = true;
}
}
if (isCheck)
{
foreach (int item in select)
{
CBoxSelect.SetCheckedState(item, true);
}
btnDelete.Enabled = true;
btnSelect_All.Text = "取消全选";
}
else
{
foreach (int item in select)
{
CBoxSelect.SetCheckedState(item, false);
}
btnDelete.Enabled = false;
btnSelect_All.Text = "全选";
}
}
//初始化
public void InitData()
{
try
{
ViewState["page"] = 0;
List <Common.Entities.Award> list = award.FindPaged(Convert.ToInt32(Session["SecrecyLevel"]));
Grid_Award.RecordCount = list.Count();
if (list != null)
{
Grid_Award.DataSource = list.Skip(Grid_Award.PageIndex * Grid_Award.PageSize).Take(Grid_Award.PageSize);
Grid_Award.DataBind();
}
else
{
return;
}
}
catch (Exception ex)
{
pm.SaveError(ex, this.Request);
}
}
//导出
protected void btn_Get_Click(object sender, EventArgs e)
{
try
{
if (page == 0)
{
List <Common.Entities.Award> list = award.FindPaged(Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 1)
{
List <Common.Entities.Award> list = award.FindByAchievementName(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 2)
{
List <Common.Entities.Award> list = award.FindByAchievementRank(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 3)
{
List <Common.Entities.Award> list = award.FindByAchievementTime(Convert.ToInt32(dCondition.SelectedText.Trim()), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 4)
{
List <Common.Entities.Award> list = award.FindByUnit(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 5)
{
List <Common.Entities.Award> list = award.FindByAwardName(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 6)
{
List <Common.Entities.Award> list = award.AwardUnit(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 7)
{
List <Common.Entities.Award> list = award.FindByAwardPeople(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 9)
{
List <Common.Entities.Award> list = award.FindBySecrecyLevel(Secrecyreturnint(dCondition.SelectedText), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
if (page == 10)
{
List <Common.Entities.Award> list = award.FindByMember(tCondition.Text.Trim(), Convert.ToInt32(Session["SecrecyLevel"]));
if (list != null)
{
Grid_Award.DataSource = list;
Grid_Award.DataBind();
}
}
pm.ExportExcel(3, Grid_Award, 0);
}
catch (Exception ex)
{
pm.SaveError(ex, this.Request);
}
}
