protected override void OnInit(EventArgs e)
{
oDetailPage = new Epoint.MisBizLogic2.Web.DetailPage(TableID);
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//���û�е���Excel��Grid��������Ϊnull
oListPage.CustomMode = true;
base.OnInit(e);
}
override protected void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, GridExcel);//如果没有导出Excel的Grid，就设置为null
//此处添加全局通用条件
string sqlstr = "and ParentGuid='" + Request.QueryString["ParentGuid"] + "'";
if (!string.IsNullOrEmpty(Request["IsBelongtoApp"]))
{
sqlstr += "and IsBelongtoApp='" + Request["IsBelongtoApp"] + "'";
}
if (!string.IsNullOrEmpty(Request["AppGuid"]))
{
if (Request["AppGuid"] == "all")
{
sqlstr += "and AppGuid!=''";
}
else
{
sqlstr += "and AppGuid='" + Request["AppGuid"] + "'";
}
}
oListPage.OtherCondition = sqlstr;
oListPage.SortExpression = " Order by OrderNum Desc ";
oListPage.CustomMode = true;
//此方法解决删除错位问题。可以使查询条件的值自动从ViewState中恢复。
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
override protected void OnInit(EventArgs e)
{
oEditPage = new Epoint.MisBizLogic2.Web.EditPage(TableID);
oListPage2 = new Epoint.MisBizLogic2.Web.ListPage(GGTableID, Datagrid2, null, Pager2, null);//如果没有导出Excel的Grid，就设置为null
oListPage2.CustomMode = true;
base.OnInit(e);
}
override protected void OnInit(EventArgs e)
{
oDetailPage = new Epoint.MisBizLogic2.Web.DetailPage(TableID);
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//如果没有导出Excel的Grid，就设置为null
oListPage.CustomMode = true;
base.OnInit(e);
}
override protected void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, GridExcel);//如果没有导出Excel的Grid，就设置为null
oListPage.CustomMode = true;
//此方法解决删除错位问题。可以使查询条件的值自动从ViewState中恢复。
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//���û�е���Excel��Grid��������Ϊnull
oListPage.CustomMode = true;
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//���û�е���Excel��Grid��������Ϊnull
//�˴����ȫ��ͨ������
//oListPage.OtherCondition = " and (UserStatus is null or Userstatus=001) or IsValid=0";
oListPage.CustomMode = true;
oListPage.SortExpression = " order by Row_ID desc";
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
override protected void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//���û�е���Excel��Grid��������Ϊnull
//�˴����ȫ��ͨ������
//oListPage.OtherCondition = " and (UserStatus is null or Userstatus=001) or IsValid=0";
oListPage.CustomMode = true;
oListPage.SortExpression = " order by Row_ID desc";
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
override protected void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//如果没有导出Excel的Grid，就设置为null
//此处添加全局通用条件
tdrecover.Style["display"] = "none";
oListPage.CustomMode = true;
oListPage.SortExpression = " order by Row_ID desc";
//此方法解决删除错位问题。可以使查询条件的值自动从ViewState中恢复。
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
override protected void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//如果没有导出Excel的Grid，就设置为null
//此处添加全局通用条件
oListPage.OtherCondition = " and ParentGuid='" + ParentGuid + "'";
oListPage.SortExpression = " OrderNum desc";
oListPage.CustomMode = true;
//此方法解决删除错位问题。可以使查询条件的值自动从ViewState中恢复。
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//如果没有导出Excel的Grid，就设置为null
//此处添加全局通用条件
oListPage.OtherCondition = " and AppGuid='" + AppGuid + "'";
oListPage.SortExpression = " OrderNum desc";
oListPage.CustomMode = true;
//此方法解决删除错位问题。可以使查询条件的值自动从ViewState中恢复。
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
override protected void OnInit(EventArgs e)
{
oEditPage = new Epoint.MisBizLogic2.Web.EditPage(TableID);
oZZListPage = new Epoint.MisBizLogic2.Web.ListPage(TableZZID, DGZZ, null, PagerZZ, null);//如果没有导出Excel的Grid，就设置为null
oZZListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oZZListPage.SortExpression = " ORDER BY ROW_ID DESC ";
oZZListPage.CustomMode = true;
oRYListPage = new Epoint.MisBizLogic2.Web.ListPage(TableRYID, DGRY, null, PagerRY, null);//如果没有导出Excel的Grid，就设置为null
oRYListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oZZListPage.SortExpression = " ORDER BY ROW_ID DESC ";
oRYListPage.CustomMode = true;
base.OnInit(e);
}
protected override void OnInit(EventArgs e)
{
oDetailPage = new Epoint.MisBizLogic2.Web.DetailPage(TableID);
oZZListPage = new Epoint.MisBizLogic2.Web.ListPage(TableZZID, DGZZ, null, PagerZZ, null);//���û�е���Excel��Grid��������Ϊnull
oZZListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oZZListPage.CustomMode = true;
oRYListPage = new Epoint.MisBizLogic2.Web.ListPage(TableRYID, DGRY, null, PagerRY, null);//���û�е���Excel��Grid��������Ϊnull
oRYListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oRYListPage.CustomMode = true;
oXMListPage = new Epoint.MisBizLogic2.Web.ListPage(TableXMID, DGXM, null, PagerXM, null);//���û�е���Excel��Grid��������Ϊnull
oXMListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oXMListPage.CustomMode = true;
base.OnInit(e);
}
override protected void OnInit(EventArgs e)
{
oDetailPage = new Epoint.MisBizLogic2.Web.DetailPage(TableID);
oZZListPage = new Epoint.MisBizLogic2.Web.ListPage(TableZZID, DGZZ, null, PagerZZ, null);//如果没有导出Excel的Grid，就设置为null
oZZListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oZZListPage.CustomMode = true;
oRYListPage = new Epoint.MisBizLogic2.Web.ListPage(TableRYID, DGRY, null, PagerRY, null);//如果没有导出Excel的Grid，就设置为null
oRYListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oRYListPage.CustomMode = true;
oXMListPage = new Epoint.MisBizLogic2.Web.ListPage(TableXMID, DGXM, null, PagerXM, null);//如果没有导出Excel的Grid，就设置为null
oXMListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oXMListPage.CustomMode = true;
base.OnInit(e);
}
override protected void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, GridExcel);//如果没有导出Excel的Grid，就设置为null
oListPage.OtherCondition = " and DelStatus='0' ";
if (!String.IsNullOrEmpty(Request["DWGuid"]))
{
oListPage.OtherCondition += " and DWGuid='" + Request["DWGuid"] + "' ";
}
oListPage.SortExpression = " order by Row_ID desc";
oListPage.CustomMode = true;
//此方法解决删除错位问题。可以使查询条件的值自动从ViewState中恢复。
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
override protected void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, GridExcel);//如果没有导出Excel的Grid，就设置为null
//此处添加全局通用条件
oListPage.OtherCondition = " and DelStatus='0' and Status='90' and DWGuid='" + Request["DWGuid"] + "' ";
//将个人的劳动合同时间筛选
oListPage.OtherCondition += " and HeTongEndDate>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' ";
//将个人的身份证到期时间筛选
oListPage.OtherCondition += " and sfzyxqz>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' ";
//将个人的社保证明时间筛选
//暂时不看社保证明，数据库社保证明时间有误!
//oListPage.OtherCondition += " and Exists(SELECT 1 FROM RG_OUINFO WHERE ROWGUID=RG_QYUser.DWGUID AND SMJZSJ>'" + DateTime.Now.ToString("yyyy-MM-dd") + "' AND STATUS='90' ) ";
//注册章有效期
oListPage.OtherCondition += " and ((YinZhangNo='') or (YinZhangNo!='' and ZCZ_YXQ>'" + DateTime.Now.ToString("yyyy-MM-dd") + "') or (YinZhangNo1='') or (YinZhangNo1!='' and ZCZ_YXQ1>'" + DateTime.Now.ToString("yyyy-MM-dd") + "') or (YinZhangNo2='') or (YinZhangNo2!='' and ZCZ_YXQ2>'" + DateTime.Now.ToString("yyyy-MM-dd") + "') ) ";
oListPage.CustomMode = true;
//此方法解决删除错位问题。可以使查询条件的值自动从ViewState中恢复。
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, GridExcel);//���û�е���Excel��Grid��������Ϊnull
//�˴����ȫ��ͨ������
string sqlstr = "and ParentGuid='" + Request.QueryString["ParentGuid"] + "'";
if (!string.IsNullOrEmpty(Request["IsBelongtoApp"]))
sqlstr += "and IsBelongtoApp='" + Request["IsBelongtoApp"] + "'";
if (!string.IsNullOrEmpty(Request["AppGuid"]))
{
if (Request["AppGuid"] == "all")
sqlstr += "and AppGuid!=''";
else
sqlstr += "and AppGuid='" + Request["AppGuid"] + "'";
}
oListPage.OtherCondition = sqlstr;
oListPage.SortExpression = " Order by OrderNum Desc ";
oListPage.CustomMode = true;
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, GridExcel);//���û�е���Excel��Grid��������Ϊnull
oListPage.OtherCondition = " and DelStatus='0' ";
if (!String.IsNullOrEmpty(Request["DWGuid"]))
{
oListPage.OtherCondition += " and DWGuid='" + Request["DWGuid"] + "' ";
}
oListPage.SortExpression = " order by Row_ID desc";
oListPage.CustomMode = true;
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//���û�е���Excel��Grid��������Ϊnull
//�˴����ȫ��ͨ������
tdrecover.Style["display"] = "none";
oListPage.CustomMode = true;
oListPage.SortExpression = " order by Row_ID desc";
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager,GridExcel );//���û�е���Excel��Grid��������Ϊnull
//�˴����ȫ��ͨ������
oListPage.OtherCondition = " and DelStatus='0' and Status='90' and DWGuid='" + Request["DWGuid"] + "' ";
//�����˵��Ͷ���ͬʱ��ɸѡ
oListPage.OtherCondition += " and HeTongEndDate>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' ";
//�����˵����֤����ʱ��ɸѡ
oListPage.OtherCondition += " and sfzyxqz>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' ";
//�����˵��籣֤��ʱ��ɸѡ
//��ʱ�����籣֤�������ݿ��籣֤��ʱ������!
//oListPage.OtherCondition += " and Exists(SELECT 1 FROM RG_OUINFO WHERE ROWGUID=RG_QYUser.DWGUID AND SMJZSJ>'" + DateTime.Now.ToString("yyyy-MM-dd") + "' AND STATUS='90' ) ";
//ע������Ч��
oListPage.OtherCondition += " and ((YinZhangNo='') or (YinZhangNo!='' and ZCZ_YXQ>'" + DateTime.Now.ToString("yyyy-MM-dd") + "') or (YinZhangNo1='') or (YinZhangNo1!='' and ZCZ_YXQ1>'" + DateTime.Now.ToString("yyyy-MM-dd") + "') or (YinZhangNo2='') or (YinZhangNo2!='' and ZCZ_YXQ2>'" + DateTime.Now.ToString("yyyy-MM-dd") + "') ) ";
oListPage.CustomMode = true;
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(System.EventArgs e)
{
oListPage = new Epoint.MisBizLogic2.Web.ListPage(TableID, Datagrid1, controlHolder, Pager, null);//���û�е���Excel��Grid��������Ϊnull
//�˴����ȫ��ͨ������
oListPage.OtherCondition = " and ParentGuid='" + ParentGuid + "'";
oListPage.SortExpression = " OrderNum desc";
oListPage.CustomMode = true;
//�˷������ɾ����λ���⡣����ʹ��ѯ������ֵ�Զ���ViewState�лָ���
controlHolder.Controls.Add(oListPage.RenderSearchCondition());
base.OnInit(e);
}
protected override void OnInit(EventArgs e)
{
oEditPage = new Epoint.MisBizLogic2.Web.EditPage(TableID);
oListPage2 = new Epoint.MisBizLogic2.Web.ListPage(GGTableID, Datagrid2, null, Pager2, null);//���û�е���Excel��Grid��������Ϊnull
oListPage2.CustomMode = true;
base.OnInit(e);
}
protected override void OnInit(EventArgs e)
{
oEditPage = new Epoint.MisBizLogic2.Web.EditPage(TableID);
oZZListPage = new Epoint.MisBizLogic2.Web.ListPage(TableZZID, DGZZ, null, PagerZZ, null);//���û�е���Excel��Grid��������Ϊnull
oZZListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oZZListPage.SortExpression = " ORDER BY ROW_ID DESC ";
oZZListPage.CustomMode = true;
oRYListPage = new Epoint.MisBizLogic2.Web.ListPage(TableRYID, DGRY, null, PagerRY, null);//���û�е���Excel��Grid��������Ϊnull
oRYListPage.OtherCondition = " and DelStatus='0' and DWGuid='" + Request["RowGuid"] + "' ";
oZZListPage.SortExpression = " ORDER BY ROW_ID DESC ";
oRYListPage.CustomMode = true;
base.OnInit(e);
}
