public void BindData()
{
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
public void DropDownListBindData()
{
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
if (txtKeyword.Text.Trim() != "")
{
strWhere.AppendFormat("notice_topic like '%{0}%' or notice_content like '%{0}%' ", txtKeyword.Text.Trim());
}
ds = bllno.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
public void DropDownListBindData()
{
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
if (txtKeyword.Text.Trim() != "")
{
strWhere.AppendFormat("monthlyFeedback_fulfilmentDescription like '%{0}%'", txtKeyword.Text.Trim());
}
ds = bllmf.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
public void DropDownListBindData()
{
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
if (txtKeyword.Text.Trim() != "")
{
strWhere.AppendFormat("user_name like '%{0}%' or user_dept like '%{0}%' or user_liablePerson like '%{0}%'", txtKeyword.Text.Trim());
}
ds = blluser.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
public void DropDownListBindData()
{
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
if (txtKeyword.Text.Trim() != "")
{
strWhere.AppendFormat("specialFundRecord_methods like '%{0}%' or specialFundRecord_channel like '%{0}%' or specialFundRecord_description like '%{0}%'", txtKeyword.Text.Trim());
}
ds = bllsf.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
public void BindData()
{
this.GridView_Project.Visible = true;
if (DDL_Year.SelectedValue == "2010")
{
Maticsoft.BLL.NewPort.projecttable bll = new Maticsoft.BLL.NewPort.projecttable();
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat("project_type like '%{0}%' ", "集疏运项目");
ds = bll.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
}
public void mDropDownListBindData()
{
string value = DropDownList_mType.SelectedValue.ToString().Trim();
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat("project_id like '%{0}%'", value);
if (txtKeyword.Text.Trim() != "")
{
strWhere.AppendFormat("and(monthlyFeedback_fulfilmentDescription like '%{0}%' or monthlyFeedback_writer like '%{0}%' or project_id like '%{0}%')", txtKeyword.Text.Trim());
}
ds = bllmf.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
public void BindData()
{
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
string value = DropDownList_isCheck.SelectedValue.ToString().Trim();
string value1 = DropDownList_State.SelectedValue.ToString().Trim();
string value2 = DropDownList_Type.SelectedValue.ToString().Trim();
strWhere.AppendFormat("project_check like '%{0}%'", value);
strWhere.AppendFormat("and project_state like '%{0}%'", value1);
strWhere.AppendFormat("and project_type like '%{0}%'", value2);
// if (txtKeyword.Text.Trim() != "")
{
// strWhere.AppendFormat("and(project_name like '%{0}%' or project_owner like '%{0}%' or project_positon like '%{0}%')", txtKeyword.Text.Trim());
}
ds = bll.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
public void BindData()
{
this.GridView_Project.Visible = true;
// Maticsoft.BLL.NewPort.projecttable bll = new Maticsoft.BLL.NewPort.projecttable();
Maticsoft.BLL.NewPort.Table_project bll = new Maticsoft.BLL.NewPort.Table_project();
this.GridView_Project.DataSourceID = null;
DataSet ds = new DataSet();
StringBuilder strWhere = new StringBuilder();
strWhere.AppendFormat("(");
strWhere.AppendFormat("project_year like '%{0}%' and ", DDL_Year1.SelectedValue.Trim());
if (cb_alltype.Checked == false)
{
if (cb_Ganhang.Checked)
{
strWhere.AppendFormat("project_type like '%{0}%' or ", "港航项目");
}
if (cb_Jishuyun.Checked)
{
strWhere.AppendFormat("project_type like '%{0}%' or ", "集疏运项目");
}
if (cb_Lingang.Checked)
{
strWhere.AppendFormat("project_type like '%{0}%' or ", "临港产业项目");
}
strWhere.AppendFormat("project_type like '%{0}%' )and (", "visual2010");
}
if (cb_allstate.Checked == false)
{
if (cb_New.Checked)
{
strWhere.AppendFormat("project_state like '%{0}%' or ", "新开工");
}
if (cb_Goon.Checked)
{
strWhere.AppendFormat("project_state like '%{0}%' or ", "续建");
}
strWhere.AppendFormat("project_state like '%{0}%' )and (", "visual2010");
}
if (cb_allarea.Checked == false)
{
if (cb_Wuhan.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "武汉");
}
if (cb_Ezhou.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "鄂州");
}
if (cb_Huanggan.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "黄冈");
}
if (cb_Xianning.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "咸宁");
}
if (cb_Xinzhou.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "新洲");
}
if (cb_Hannan.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "汉南");
}
if (cb_HGQ.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "化工区");
}
if (cb_XGT.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "新港投");
}
if (cb_Wugan.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "武港");
}
if (cb_Jiangxia.Checked)
{
strWhere.AppendFormat("project_area like '%{0}%' or ", "江夏");
}
strWhere.AppendFormat("project_area like '%{0}%')", "visual2010");
}
else
{
strWhere.AppendFormat("'visual2010' like '%{0}%')", "visual2010");
}
ds = bll.GetList(strWhere.ToString());
GridView_Project.DataSource = ds;
GridView_Project.DataBind();
}
