private void BindDropDownList()
{
Js.BLL.BaseDal dal = new Js.BLL.BaseDal("BU_Enterprise");
string filter = "1=1";
if (Session["UserType"].ToString() == "EP")
filter = string.Format("EnterpriseID='{0}'", Session["EnterpriseID"].ToString());
this.ddlEnterpriseID.DataSource = dal.GetIDNameList(filter);
this.ddlEnterpriseID.DataTextField = "IDName";
this.ddlEnterpriseID.DataValueField = "ID";
this.ddlEnterpriseID.DataBind();
if (Session["EnterpriseID"] != null)
this.ddlEnterpriseID.SelectedValue = Session["EnterpriseID"].ToString();
}
/// <summary>
/// 綁定查詢
/// </summary>
private void dataSearch()
{
Js.BLL.Sys.SysComDal dal = new Js.BLL.Sys.SysComDal();
this.ddlFieldName.DataSource = dal.SearchTable(FormID, false).Tables[0];
this.ddlFieldName.DataTextField = "FieldCName";
this.ddlFieldName.DataValueField = "FieldName";
this.ddlFieldName.DataBind();
this.ddlPageSize.Items.Add(new ListItem("15", "15"));
this.ddlPageSize.Items.Add(new ListItem("20", "20"));
this.ddlPageSize.Items.Add(new ListItem("25", "25"));
this.ddlPageSize.Items.Add(new ListItem("30", "30"));
this.ddlPageSize.Items.Add(new ListItem("40", "40"));
this.ddlPageSize.Items.Add(new ListItem("50", "50"));
Js.BLL.BaseDal bdal = new Js.BLL.BaseDal("BU_Enterprise");
string filter = "1=1";
if (Session["UserType"].ToString() == "EP")
filter = string.Format("EnterpriseID='{0}'", Session["EnterpriseID"].ToString());
this.ddlEnterpriseID.DataSource = bdal.GetIDNameList(filter);
this.ddlEnterpriseID.DataTextField = "IDName";
this.ddlEnterpriseID.DataValueField = "ID";
this.ddlEnterpriseID.DataBind();
if (Session["UserType"].ToString() == "BU")
this.ddlEnterpriseID.Items.Insert(0, new ListItem("", ""));
if (Session["EnterpriseID"] != null)
this.ddlEnterpriseID.SelectedValue = Session["EnterpriseID"].ToString();
}
private void BindDropDownList()
{
Js.BLL.BaseDal dal = new Js.BLL.BaseDal("BU_EnterpriseCategory");
DataTable dt = dal.GetIDNameList("");
this.ddlCategoryID.DataSource = dt;
this.ddlCategoryID.DataTextField = "IDName";
this.ddlCategoryID.DataValueField = "ID";
this.ddlCategoryID.DataBind();
}
private void BindDropDownList()
{
Js.BLL.BaseDal dal = new Js.BLL.BaseDal("BU_Department");
DataTable dt = dal.GetIDNameList("");
this.ddlDepartmentID.DataSource = dt;
this.ddlDepartmentID.DataTextField = "IDName";
this.ddlDepartmentID.DataValueField = "ID";
this.ddlDepartmentID.DataBind();
}
private void BindDepartment()
{
Js.BLL.BaseDal dal = new Js.BLL.BaseDal("EP_Department", cnKey);
string filter = string.Format("EnterpriseID='{0}'", this.ddlEnterpriseID.SelectedValue);
DataTable dt = dal.GetIDNameList(filter);
this.ddlDepartmentID.DataSource = dt;
this.ddlDepartmentID.DataTextField = "IDName";
this.ddlDepartmentID.DataValueField = "ID";
this.ddlDepartmentID.DataBind();
}
private void BindEdll()
{
Js.BLL.BaseDal dal = new Js.BLL.BaseDal("LB_ProductionUnit",cnKey);
DataTable dt = dal.GetIDNameList("");
this.ddlProductionUnitID.DataSource = dt;
this.ddlProductionUnitID.DataTextField = "IDName";
this.ddlProductionUnitID.DataValueField = "ID";
this.ddlProductionUnitID.DataBind();
}