public void UserDateBind()
{
CommonDao<HealthUserOrder> HealthUserOrdermgr = new CommonDao<HealthUserOrder>();
CommonDao<HealthAdmin> healadminmgr = new CommonDao<HealthAdmin>();
string username = UI.GetList("CN_ID = " + userid).Tables[0].Rows[0]["CN_LOGIN"].ToString();
if (int.Parse(healadminmgr.GetTotalCount(" username='******' and works=2 ")) > 0)
{
string condition = " userid in('other','" + userid + "') ";
if (this.DropDownList1.Text.Trim() != "")
{
condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'";
}
AspNetPager1.RecordCount = int.Parse(HealthUserOrdermgr.GetTotalCount(condition));
Repeater1.DataSource = HealthUserOrdermgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition);
Repeater1.DataBind();
}
else
{
string condition = " username='******'";
if (this.DropDownList1.Text.Trim() != "")
{
condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'";
}
AspNetPager1.RecordCount = int.Parse(HealthUserOrdermgr.GetTotalCount(condition));
Repeater1.DataSource = HealthUserOrdermgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition);
Repeater1.DataBind();
}
}
public void UserDateBind()
{
CommonDao<HealthUserOrder> HealthUserOrdermgr = new CommonDao<HealthUserOrder>();
CommonDao<HealthAdmin> healadminmgr = new CommonDao<HealthAdmin>();
string condition = " 1=1 ";
if (this.TextBox1.Text.Trim() != "") {
condition = condition + " and USERNAME like '%" + this.TextBox1.Text.ToString() + "%'";
}
if (this.TextBox2.Text.Trim() != "")
{
condition = condition + " and STARTTIME >'" + this.TextBox2.Text.ToString() + "'";
}
if (this.TextBox3.Text.Trim() != "")
{
condition = condition + " and STARTTIME <'" + this.TextBox3.Text.ToString() + "'";
}
if (this.DropDownList2.Text.Trim() != "")
{
condition = condition + " and USERDOCTOR ='" + this.DropDownList2.Text.ToString() + "'";
}
if (this.DropDownList1.Text.Trim() != "")
{
condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'";
}
AspNetPager1.RecordCount = int.Parse(HealthUserOrdermgr.GetTotalCount(condition));
Repeater1.DataSource = HealthUserOrdermgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition);
Repeater1.DataBind();
}
private void GetZhuanTiList()
{
string fid = "";
string condition = "";
if (Request["ZhuanName"] != null)
{
fid = Request["ZhuanName"].ToString();
CommonDao<Safezhuan> sugmgr = new CommonDao<Safezhuan>();
Safezhuan safezhuan = sugmgr.FindByConditions(" fid='"+fid+"' ");
this.lableType.InnerHtml = " <span style='color: #0087ce;'>" +safezhuan.ZhuanName.ToString() + "</span>";
condition = condition + " NewsZhuan ='" + fid + "' ";
}
CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>();
SafeNews s = new SafeNews();
if (TextBoxSearch.Text.Trim().Length > 0)
{
condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
RepeaterPubGG.DataBind();
}
private void InfoBind()
{
string Infotype = Request.QueryString["Infotype"];
string type = Request.QueryString["type"];
if (Infotype == null && type == null)
{
Infotype = "安全新闻";
}
string condition = "";
CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>();
if (Infotype == "安全新闻")
{
condition = " NewsInfoType = '" + Infotype + "' ";
}
else
{
condition = " NewsInfoType = '" + Infotype + "' and NewsType='" + type + "' ";
}
if (TextBoxSearch.Text.Trim().Length > 0)
{
condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
RepeaterPubGG.DataBind();
}
private void InfoBind()
{
CommonDao<SafePitFalls> newmgr = new CommonDao<SafePitFalls>();
string condition = " 1=1 ";
if (TextBoxyh.Text.Trim().Length > 0)
{
condition = condition + " and PitContents like '%" + this.TextBoxyh.Text.Trim().ToString() + "%'";
}
if (TextBoxdept.Text.Trim().Length > 0)
{
condition = condition + " and dept like '%" + this.TextBoxdept.Text.Trim().ToString() + "%'";
}
if (TextBoxperson.Text.Trim().Length > 0)
{
condition = condition + " and person like '%" + this.TextBoxperson.Text.Trim().ToString() + "%'";
}
if (TextBoxqy.Text.Trim().Length > 0)
{
condition = condition + " and Area like '%" + this.TextBoxqy.Text.Trim().ToString() + "%'";
}
if (TextBoxtime.Text.Trim().Length > 0)
{
condition = condition + " and time = '" + this.TextBoxtime.Text.Trim().ToString()+"'";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
RepeaterPubGG.DataBind();
}
private void InfoBind()
{
CommonDao<SafeRewards> newmgr = new CommonDao<SafeRewards>();
string condition = " ";
if (TextBoxSearch.Text.Trim().Length > 0)
{
condition = condition + " Area like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
RepeaterPubGG.DataBind();
}
private void InfoBind()
{
CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>();
string condition = " NewsInfoType = '安全新闻' ";
if (TextBoxSearch.Text.Trim().Length > 0)
{
condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
RpNewReplay.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
RpNewReplay.DataBind();
}
private void InfoBind(string dept)
{
CommonDao<SafePitFalls> newmgr = new CommonDao<SafePitFalls>();
string condition = " datediff (month,time,getdate())=0 ";
if (dept.Length > 0)
{
condition = condition + " and dept like '%" + dept + "%'";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
Repeateryhxx.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
Repeateryhxx.DataBind();
}
private void InfoBind()
{
string type = "安全公文";
if (Request["type"] != null)
{
type = Request["type"].ToString();
this.lableType.InnerHtml = " <span style='color: #0087ce;'>" + type + "</span>";
}
CommonDao<SafeNews> newmgr = new CommonDao<SafeNews>();
string condition = " NewsInfoType = '安全信息' and newstype ='" + type + "' ";
if (TextBoxSearch.Text.Trim().Length > 0)
{
condition = condition + " and newstitle like '%" + this.TextBoxSearch.Text.Trim().ToString() + "%'";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
RepeaterPubGG.DataBind();
}
public void UserDateBind()
{
CommonDao<V_HealthScoreHistory> HealthUserScoremgr = new CommonDao<V_HealthScoreHistory>();
string condition = " 1=1 ";
if (this.TextBox1.Text.Trim() != "")
{
condition = condition + " and USERNAME like '%" + this.TextBox1.Text.ToString() + "%'";
}
if (this.TextBox2.Text.Trim() != "")
{
condition = condition + " and STARTTIME >'" + this.TextBox2.Text.ToString() + "'";
}
if (this.TextBox3.Text.Trim() != "")
{
condition = condition + " and STARTTIME <'" + this.TextBox3.Text.ToString() + "'";
}
if (this.DropDownList2.Text.Trim() != "")
{
condition = condition + " and USERDOCTOR ='" + this.DropDownList2.Text.ToString() + "'";
}
if (this.TextBox4.Text.Trim() != "")
{
string value = this.TextBox4.Text.ToString();
condition = condition + " and ( LIDAO <" + value + " or SHUSHIDU <" + value + " or LIAOXIAO <" + value + " or JIFA <" + value + " or FUWUTAIDU <" + value + ")";
}
if (this.TextBox5.Text.Trim() != "")
{
string value = this.TextBox5.Text.ToString();
condition = condition + " and ( TOTALSUM < " + value + ")";
}
//if (this.DropDownList1.Text.Trim() != "")
//{
// condition = condition + " and userstate='" + this.DropDownList1.Text.ToString() + "'";
//}
AspNetPager1.RecordCount = int.Parse(HealthUserScoremgr.GetTotalCount(condition));
Repeater1.DataSource = HealthUserScoremgr.FindAllByPageDesc(((AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize).ToString(), AspNetPager1.PageSize.ToString(), condition);
Repeater1.DataBind();
}
private void InfoBind()
{
CommonDao<SafePitFalls> newmgr = new CommonDao<SafePitFalls>();
string condition = " ";
if (ViewState["con"] == null)
{
condition = condition = "1!=1";
}
else
{
string allornot = "";
if (ViewState["fulldept"].ToString().Substring(0, 3) == "999")
{
allornot = "已处理";
}
else
{
allornot = "全部";
}
condition = condition + ViewState["con"];
lbusername.Text = "您正在查看的是 " + ViewState["dept"].ToString() + " " + allornot + "的安全隐患 ";
}
Pager.RecordCount = int.Parse(newmgr.GetTotalCount(condition));
RepeaterPubGG.DataSource = newmgr.FindAllByPageDesc(((Pager.CurrentPageIndex - 1) * Pager.PageSize).ToString(), Pager.PageSize.ToString(), condition);
RepeaterPubGG.DataBind();
}
