protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { tbx_begin.Text = DateTime.Now.AddMonths(-3).ToShortDateString(); tbx_end.Text = DateTime.Now.ToShortDateString(); #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion tr_Position.DataSource = Org_PositionBLL.GetAllPostion(); BindData(); } }
private void BindDropdown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetCurrentMonth() - 1).ToString(); ddl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag"); ddl_ApproveFlag.DataBind(); ddl_ApproveFlag.Items.Insert(0, new ListItem("所有", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); select_Staff.SelectValue = staff.Model.ID.ToString(); select_Staff.SelectText = staff.Model.RealName; } #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<=DateAdd(day,0,GETDATE())"); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = AC_AccountMonthBLL.GetCurrentMonth().ToString(); ddl_ISWanYuan.DataSource = DictionaryBLL.GetDicCollections("PUB_YesOrNo"); ddl_ISWanYuan.DataBind(); ddl_ISWanYuan.Items.Insert(0, new ListItem("所有", "0")); ddl_ISWanYuan.SelectedValue = "0"; }
private void BindDropDown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE() AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_Brand.DataSource = PDT_BrandBLL.GetModelList("IsOpponent =" + rbl_IsOpponent.SelectedValue); ddl_Brand.DataBind(); ddl_Brand.Items.Insert(0, new ListItem("所有品牌", "0")); ddl_Brand.SelectedValue = "0"; rbl_Brand_SelectedIndexChanged(null, null); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<='" + DateTime.Today.ToString("yyyy-MM-dd") + "' AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(-10)).ToString(); ddl_ActiveFlag.DataSource = DictionaryBLL.GetDicCollections("CM_ActiveFlag"); ddl_ActiveFlag.DataBind(); ddl_ActiveFlag.Items.Insert(0, new ListItem("所有", "0")); ddl_ActiveFlag.SelectedValue = "1"; }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); IList <PDT_Brand> _brandList = PDT_BrandBLL.GetModelList("(IsOpponent IN (1) OR ID IN (4,5))"); ddl_Brand.DataTextField = "Name"; ddl_Brand.DataValueField = "ID"; ddl_Brand.DataSource = _brandList; ddl_Brand.DataBind(); ddl_Brand.Items.Insert(0, new ListItem("全部", "0")); ddl_GiftClassify.DataSource = DictionaryBLL.GetDicCollections("ORD_GiftClassify"); ddl_GiftClassify.DataBind(); ddl_GiftClassify.Items.Insert(0, new ListItem("全部", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion int forwarddays = ConfigHelper.GetConfigInt("FeeApplyForwardDays"); ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_Level.DataSource = DictionaryBLL.GetDicCollections("Addr_OrganizeCityLevel"); ddl_Level.DataBind(); ddl_Level.Items.Insert(0, new ListItem("所有", "0")); ddl_FeeType.DataSource = DictionaryBLL.GetDicCollections("FNA_FeeType").OrderBy(p => p.Value.Name); ddl_FeeType.DataBind(); ddl_FeeType.Items.Insert(0, new ListItem("全部", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE() AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_EndMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE() AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_EndMonth.DataBind(); ddl_EndMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_FeeType.DataSource = DictionaryBLL.GetDicCollections("FNA_FeeType"); ddl_FeeType.DataBind(); ddl_FeeType.Items.Insert(0, new ListItem("全部", "0")); //if (ddl_FeeType.Items.FindByValue("1") != null) ddl_FeeType.SelectedValue = "1"; ddl_State.DataSource = DictionaryBLL.GetDicCollections("FNA_FeeWriteOffState"); ddl_State.DataBind(); ddl_State.Items.Insert(0, new ListItem("全部", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } tr_OrganizeCity_Selected(null, null); #endregion ddl_BeginMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_BeginMonth.DataBind(); ddl_BeginMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddMonths(-3)).ToString(); ddl_EndMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_EndMonth.DataBind(); ddl_EndMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag"); ddl_ApproveFlag.DataBind(); ddl_ApproveFlag.Items.Insert(0, new ListItem("所有", "0")); ddl_ApproveFlag.SelectedValue = "1"; ddl_ActiveFlag.DataSource = DictionaryBLL.GetDicCollections("CM_ActiveFlag"); ddl_ActiveFlag.DataBind(); ddl_ActiveFlag.Items.Insert(0, new ListItem("所有", "0")); ddl_ActiveFlag.SelectedValue = "1"; }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag"); ddl_ApproveFlag.DataBind(); ddl_ApproveFlag.Items.Insert(0, new ListItem("所有", "0")); ddl_ApproveFlag.SelectedValue = "1"; ddl_State.DataSource = DictionaryBLL.GetDicCollections("CM_ActiveFlag"); ddl_State.DataBind(); ddl_State.Items.Insert(0, new ListItem("所有", "0")); ddl_State.SelectedValue = "1"; }
private void BindDropDown() { if ((int)Session["AccountType"] == 1) { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } } else if ((int)Session["AccountType"] == 2) { CM_Client client = new CM_ClientBLL((int)Session["UserID"]).Model; if (client != null) { Addr_OrganizeCityBLL citybll = new Addr_OrganizeCityBLL(client.OrganizeCity); tr_OrganizeCity.DataSource = citybll.GetAllChildNodeIncludeSelf(); tr_OrganizeCity.RootValue = citybll.Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = client.OrganizeCity.ToString(); } } ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate>DateAdd(year,-2,getdate()) AND EndDate<=Getdate()"); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(-10)) - 1).ToString(); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } if (Request.QueryString["OrganizeCity"] != null) { tr_OrganizeCity.SelectValue = Request.QueryString["OrganizeCity"].ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<='" + DateTime.Today.ToString("yyyy-MM-dd") + "' AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = (AC_AccountMonthBLL.GetMonthByDate(DateTime.Now) - 1).ToString(); if (Request.QueryString["AccountMonth"] != null) { ddl_Month.SelectedValue = Request.QueryString["AccountMonth"].ToString(); } }
private void BindDropDown() { IList<EWF_Flow_App> apps = EWF_Flow_AppBLL.GetModelList(" EnableFlag='Y' "); ddl_App.DataSource = apps; ddl_App.DataBind(); ddl_App.Items.Insert(0, new ListItem("请选择...", "0")); #region 绑定当前操作员所能查看的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_FinishStatus.DataSource = DictionaryBLL.GetDicCollections("EWF_Flow_FinishStatus"); ddl_FinishStatus.DataBind(); ddl_FinishStatus.Items.Insert(0, new ListItem("全部", "0")); }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_FLType.DataSource = DictionaryBLL.GetDicCollections("RT_FLType"); ddl_FLType.DataBind(); ddl_FLType.Items.Insert(0, new ListItem("全部", "0")); ddl_FLTypeDetail.DataSource = DictionaryBLL.GetDicCollections("RT_FLType"); ddl_FLTypeDetail.DataBind(); ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("Year>=" + (DateTime.Now.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = "0"; if (ViewState["AccountMonth"] != null) { ddl_Month.SelectedValue = ViewState["AccountMonth"].ToString(); } }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_State.DataSource = DictionaryBLL.GetDicCollections("ORD_OrderDeliveryState"); ddl_State.DataBind(); ddl_State.Items.Insert(0, new ListItem("全部", "0")); }
private void BindDropDown() { string condition = " EnableFlag='Y' "; string CantApproveAlone_EWF = ConfigHelper.GetConfigString("CantApproveAlone_EWF"); if (!string.IsNullOrEmpty(CantApproveAlone_EWF)) { condition += " AND Code NOT IN ( " + CantApproveAlone_EWF + ")"; } IList <EWF_Flow_App> apps = EWF_Flow_AppBLL.GetModelList(condition); ddl_App.DataSource = apps; ddl_App.DataBind(); ddl_App.Items.Insert(0, new ListItem("请选择...", "0")); Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = "0"; } }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } tr_OrganizeCity_Selected(null, null); #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<=GETDATE() AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_FeeType.DataSource = DictionaryBLL.GetDicCollections("FNA_FeeType").OrderBy(p => p.Value.Name); ddl_FeeType.DataBind(); ddl_FeeType.Items.Insert(0, new ListItem("全部", "0")); tr_AccountTitle.SelectValue = "1"; }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE() AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetCurrentMonth().ToString(); ddl_FeeType.DataSource = DictionaryBLL.GetDicCollections("FNA_FeeType").OrderBy(p => p.Value.Name); ddl_FeeType.DataBind(); ddl_FeeType.Items.Insert(0, new ListItem("全部", "0")); ddl_ExtraType.DataSource = DictionaryBLL.GetDicCollections("FNA_BudgetExtraType").OrderBy(p => p.Value.Name); ddl_ExtraType.DataBind(); ddl_ExtraType.Items.Insert(0, new ListItem("全部", "0")); }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_BeginMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE()"); ddl_BeginMonth.DataBind(); ddl_BeginMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_EndMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_EndMonth.DataBind(); ddl_EndMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion int forwarddays = ConfigHelper.GetConfigInt("GiftApplyForwardDays"); ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("EndDate>=GETDATE() AND BeginDate<='" + DateTime.Today.AddDays(forwarddays).ToString("yyyy-MM-dd") + "' AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(forwarddays)).ToString(); rbl_Type.DataSource = DictionaryBLL.GetDicCollections("ORD_OrderType"); rbl_Type.DataBind(); rbl_Type.SelectedValue = "2"; ddl_Publish.Items.Insert(0, new ListItem("请选择...", "0")); //ddl_Address.Items.Insert(0, new ListItem("请选择...", "0")); select_Client.PageUrl = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=2&ExtCondition=\"MCS_SYS.dbo.UF_Spilt(CM_Client.ExtPropertys,~|~,7)=1\""; }
private void BindDropDown() { ddl_BeginMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate <= GETDATE() AND YEAR >= 2013"); ddl_BeginMonth.DataBind(); ddl_BeginMonth.SelectedValue = (AC_AccountMonthBLL.GetMonthByDate(DateTime.Now) - 1).ToString(); ddl_EndMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate <= GETDATE() AND YEAR >= 2013"); ddl_EndMonth.DataBind(); ddl_EndMonth.SelectedValue = (AC_AccountMonthBLL.GetMonthByDate(DateTime.Now) - 1).ToString(); #region 绑定用户可管辖的管理片区 if (Session["UserID"] != null) { int staffid = (int)Session["UserID"]; Org_StaffBLL staff = new Org_StaffBLL(staffid); //select_Staff.SelectText = staff.Model.RealName; //select_Staff.SelectValue = staffid.ToString(); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } } #endregion }
private void BindDropdown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_CityLevel.DataSource = DictionaryBLL.GetDicCollections("Addr_OrganizeCityLevel"); ddl_CityLevel.DataBind(); ddl_CityLevel.Items.Insert(0, new ListItem("请选择", "0")); ddl_CityLevel.SelectedValue = "4"; ddl_Classify.DataSource = DictionaryBLL.GetDicCollections("PM_PromotorClassify"); ddl_Classify.DataBind(); ddl_Classify.Items.Insert(0, new ListItem("不限制类别", "0")); }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_CityLevel.DataSource = DictionaryBLL.GetDicCollections("Addr_OrganizeCityLevel"); ddl_CityLevel.DataBind(); ddl_CityLevel.Items.Insert(0, new ListItem("请选择", "0")); ddl_CityLevel.SelectedValue = "4"; tr_Position.DataSource = Org_PositionBLL.GetAllPostion(); tr_Position.SelectValue = staff.Model.Position.ToString(); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } tr_OrganizeCity_Selected(null, null); if (Request.QueryString["OrganizeCity"] != null) { tr_OrganizeCity.SelectValue = Request.QueryString["OrganizeCity"].ToString(); } #endregion ddl_RTChannel.DataSource = DictionaryBLL.GetDicCollections("CM_RT_Channel"); ddl_RTChannel.DataBind(); ddl_RTChannel.Items.Insert(0, new ListItem("所有", "0")); ddl_RTChannel.SelectedValue = "0"; }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } tr_OrganizeCity_Selected(null, null); ddl_BeginMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<DateAdd(month,1,GetDate()) AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_BeginMonth.DataBind(); ddl_BeginMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddMonths(-3)).ToString(); ddl_EndMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<DateAdd(month,1,GetDate()) AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_EndMonth.DataBind(); ddl_EndMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddMonths(1)).ToString(); rbl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag"); rbl_ApproveFlag.DataBind(); rbl_ApproveFlag.Items.Insert(0, new ListItem("所有", "0")); rbl_ApproveFlag.SelectedValue = "0"; }
private void BindDropDown() { IList <EWF_Flow_App> apps = EWF_Flow_AppBLL.GetModelList(" EnableFlag='Y' "); ddl_App.DataSource = apps; ddl_App.DataBind(); ddl_App.Items.Insert(0, new ListItem("请选择...", "0")); #region 绑定当前操作员所能查看的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_FinishStatus.DataSource = DictionaryBLL.GetDicCollections("EWF_Flow_FinishStatus"); ddl_FinishStatus.DataBind(); ddl_FinishStatus.Items.Insert(0, new ListItem("全部", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion int forwarddays = ConfigHelper.GetConfigInt("FeeApplyForwardDays"); ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("EndDate>=GETDATE() AND BeginDate<='" + DateTime.Today.AddDays(forwarddays).ToString("yyyy-MM-dd") + "' AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(forwarddays)).ToString(); rbl_IsNKA.SelectedValue = Request.QueryString["ISNKA"] != null ? Request.QueryString["ISNKA"].ToString() : "2"; }
private void BindDropDown() { int forwarddays = ConfigHelper.GetConfigInt("FeeApplyForwardDays"); ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<='" + DateTime.Today.AddDays(forwarddays).ToString("yyyy-MM-dd") + "' AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = (int)ViewState["AccountMonth"] == 0 ? AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(forwarddays)).ToString() : ViewState["AccountMonth"].ToString(); #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } if ((int)ViewState["OrganizeCity"] > 0) { tr_OrganizeCity.SelectValue = ViewState["OrganizeCity"].ToString(); } tr_OrganizeCity_Selected(null, null); #endregion }
private void BindDropdown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetCurrentMonth()).ToString(); IList <PDT_Brand> _brandList = PDT_BrandBLL.GetModelList("IsOpponent=1"); ddl_Brand.DataTextField = "Name"; ddl_Brand.DataValueField = "ID"; ddl_Brand.DataSource = _brandList; ddl_Brand.DataBind(); ddl_Brand.Items.Insert(0, new ListItem("全部", "0")); ddl_Classify.Items.Insert(0, new ListItem("所有", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion select_Staff.SelectText = staff.Model.RealName; select_Staff.SelectValue = staff.Model.ID.ToString(); ddl_Transport.DataSource = DictionaryBLL.GetDicCollections("FNA_EvectionTransport"); ddl_Transport.DataBind(); ddl_Transport.Items.Insert(0, new ListItem("请选择...", "0")); ddl_Car.DataSource = Car_CarListBLL.GetCarListByOrganizeCity(staff.Model.OrganizeCity); ddl_Car.DataBind(); ddl_Car.Items.Insert(0, new ListItem("请选择", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion rbl_Type.DataSource = DictionaryBLL.GetDicCollections("ORD_OrderType"); rbl_Type.DataBind(); rbl_Type.SelectedValue = "2"; double DelayDays = Convert.ToDouble(System.Configuration.ConfigurationManager.AppSettings["OrderDelayDays"]); ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(-DelayDays)).ToString(); ddl_Publish.Items.Insert(0, new ListItem("请选择...", "0")); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<='" + DateTime.Today.ToString("yyyy-MM-dd") + "' AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(-10)).ToString(); tr_OrganizeCity_Selected(null, null); }
private void BindDropDown() { #region 绑定管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } if ((int)ViewState["OrganizeCity"] > 0) { tr_OrganizeCity.SelectValue = ViewState["OrganizeCity"].ToString(); } tr_OrganizeCity_Selected(null, null); #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate>DateAdd(year,-2,getdate()) AND EndDate<=Getdate()"); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(-10)) - 1).ToString(); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_BeginMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE() AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_BeginMonth.DataBind(); ddl_BeginMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddMonths(-3)).ToString(); ddl_EndMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE() AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_EndMonth.DataBind(); ddl_EndMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_State.DataSource = DictionaryBLL.GetDicCollections("ORD_OrderDeliveryState"); ddl_State.DataBind(); ddl_State.Items.Insert(0, new ListItem("全部", "0")); rbl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag"); rbl_ApproveFlag.DataBind(); rbl_ApproveFlag.Items.Insert(0, new ListItem("所有", "0")); rbl_ApproveFlag.SelectedValue = "0"; }
private void BindDropdown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetCurrentMonth() - 1).ToString(); rbl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag"); rbl_ApproveFlag.DataBind(); rbl_ApproveFlag.Items.Insert(0, new ListItem("所有", "0")); rbl_ApproveFlag.SelectedValue = "0"; }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_Month.DataBind(); ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); ddl_Type.DataSource = DictionaryBLL.GetDicCollections("ORD_OrderType"); ddl_Type.DataBind(); ddl_Type.Items.Insert(0, new ListItem("全部", "0")); if ((int)ViewState["Type"] > 0) { ddl_Type.SelectedValue = ViewState["Type"].ToString(); ddl_Type.Enabled = false; } ddl_State.DataSource = DictionaryBLL.GetDicCollections("ORD_OrderApplyState"); ddl_State.DataBind(); ddl_State.Items.Insert(0, new ListItem("全部", "0")); IList<PDT_Brand> _brandList = PDT_BrandBLL.GetModelList("(IsOpponent IN (1) OR ID IN (4,5))"); ddl_Brand.DataTextField = "Name"; ddl_Brand.DataValueField = "ID"; ddl_Brand.DataSource = _brandList; ddl_Brand.DataBind(); ddl_Brand.Items.Insert(0, new ListItem("全部", "0")); ddl_ProductType.DataSource = DictionaryBLL.GetDicCollections("ORD_ProductOrderType"); ddl_ProductType.DataBind(); ddl_ProductType.Items.Insert(0, new ListItem("全部", "0")); if ((int)ViewState["Type"] == 2) { ddl_ProductType.Enabled = false; } }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion int forwarddays = ConfigHelper.GetConfigInt("FeeApplyForwardDays"); ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("EndDate>=GETDATE() AND BeginDate<='" + DateTime.Today.AddDays(forwarddays).ToString("yyyy-MM-dd") + "' AND Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(forwarddays)).ToString(); ddl_FeeType.DataSource = DictionaryBLL.GetDicCollections("FNA_FeeType").OrderBy(p => p.Value.Name).ToList(); ddl_FeeType.DataBind(); foreach (ListItem item in ddl_FeeType.Items) { if (AC_AccountTitleBLL.GetListByFeeType(int.Parse(item.Value)).Where(p => p.ID > 1).ToList().Count == 0) { item.Enabled = false; } } if (ConfigHelper.GetConfigBool("FeeApplyByAccountTitleLevel2")) { tr_AccountTitle2.Visible = true; ddl_FeeType.AutoPostBack = true; ddl_FeeType.Items.Insert(0, new ListItem("请选择...", "0")); ddl_FeeType_SelectedIndexChanged(null, null); } ddl_Brand.DataSource = PDT_BrandBLL.GetModelList("IsOpponent='1'"); ddl_Brand.DataBind(); ddl_Brand.Items.Insert(0, new ListItem("多品牌", "0")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region 判断当前可查询的范围 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); if (staff.Model.OrganizeCity > 1 && staff.GetStaffOrganizeCity().Select("ID = 1").Length==0) { Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true); string orgcitys = orgcity.GetAllChildNodeIDs(); if (orgcitys != "") orgcitys += ","; orgcitys += staff.Model.OrganizeCity.ToString(); AdvancedSearch1.ExtCondition = " MCS_CM.dbo.CM_Client.OrganizeCity IN (" + orgcitys + ") AND MCS_CM.dbo.CM_Client.ClientType=3"; } #endregion AdvancedSearch1.DataKeyNames = new string[] { "CM_Client_ID" }; } }
protected void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (!Page.IsPostBack) { if (Request.QueryString["Index"] != null) { MCSTabControl1.SelectedIndex = int.Parse(Request.QueryString["Index"]); } BindDropDown(); if (Request.QueryString["Date"] == null) { tbx_begindate.Text = DateTime.Now.ToString("yyyy-MM-01"); tbx_enddate.Text = DateTime.Now.ToString("yyyy-MM-dd"); } else { tbx_begindate.Text = Request.QueryString["Date"]; tbx_enddate.Text = Request.QueryString["Date"]; } if (Request.QueryString["Staff"] != null) { Org_Staff viewstaff = new Org_StaffBLL(int.Parse(Request.QueryString["Staff"])).Model; if (viewstaff != null) { //判断要查看的人所在的管理片区是否在当前人可管辖的范围之内 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); DataTable dt = staff.GetStaffOrganizeCity(); if (dt.Select("ID=" + viewstaff.OrganizeCity).Length > 0) { select_Staff.SelectValue = viewstaff.ID.ToString(); select_Staff.SelectText = viewstaff.RealName; MCSTabControl1.SelectedIndex = 1; } } } BindGrid(); } }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID=1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate>DateAdd(year,-2,getdate()) AND EndDate<=Getdate()"); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddDays(-10)) - 1).ToString(); }
private void BindDropDown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Quarter.DataSource = AC_AccountQuarterBLL.GetModelList(""); ddl_Quarter.DataBind(); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); DataTable dt = staff.GetStaffOrganizeCity(); tr_OrganizeCity.DataSource = dt; if (dt.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_BeginMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE()"); ddl_BeginMonth.DataBind(); ddl_BeginMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now).ToString(); }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } //ddl_JournalType.DataSource = DictionaryBLL.Dictionary_Data_GetAlllList("Type=908"); //ddl_JournalType.DataBind(); //ddl_JournalType.Items.Insert(0, new ListItem("请选择...", "0")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region 判断当前可查询的范围 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); if (staff.Model.OrganizeCity > 1 && staff.GetStaffOrganizeCity().Select("ID = 1").Length == 0) { Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true); string orgcitys = orgcity.GetAllChildNodeIDs(); if (orgcitys != "") orgcitys += ","; orgcitys += staff.Model.OrganizeCity.ToString(); as_uc_promotor.ExtCondition = " MCS_Promotor.dbo.PM_Promotor.OrganizeCity IN (" + orgcitys + ")"; } #endregion as_uc_promotor.DataKeyNames = new string[] { "PM_Promotor_ID" }; } }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion tbx_BeginDate.Text = DateTime.Now.AddDays(-10).ToString("yyyy-MM-dd"); tbx_EndDate.Text = DateTime.Now.ToString("yyyy-MM-dd"); }
private void BindDropDown() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_PositionType.DataSource = DictionaryBLL.GetDicCollections("PUB_PositionType"); ddl_PositionType.DataBind(); ddl_PositionType.Items.Insert(0, new ListItem("请选择", "0")); }
private void BindDropDown() { IList<EWF_Flow_App> apps = EWF_Flow_AppBLL.GetModelList(" EnableFlag='Y' "); ddl_App.DataSource = apps; ddl_App.DataBind(); ddl_App.Items.Insert(0, new ListItem("请选择...", "0")); Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = "0"; } }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("Year>=" + (DateTime.Today.Year - 1).ToString()); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = AC_AccountMonthBLL.GetCurrentMonth().ToString(); }
private void BindDropDown() { Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("Year>=" + (DateTime.Now.Year - 1).ToString()); ddl_Month.DataBind(); ddl_Month.SelectedValue = "0"; if (ViewState["AccountMonth"] != null) ddl_Month.SelectedValue = ViewState["AccountMonth"].ToString(); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate BETWEEN DateAdd(month,-3,GETDATE()) AND GETDATE()"); ddl_Month.DataBind(); ddl_Month.SelectedValue = (AC_AccountMonthBLL.GetCurrentMonth() - 1).ToString(); }
private void BindDropDown() { #region 绑定用户可管辖的管理片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList(""); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetCurrentMonth()-1).ToString(); ddl_State.DataSource = DictionaryBLL.GetDicCollections("PM_SalaryState"); ddl_State.DataBind(); ddl_State.Items.Insert(0, new ListItem("全部", "0")); #region 绑定导购员工资类别 ddl_PMClassify.DataSource = DictionaryBLL.GetDicCollections("PM_SalaryClassify"); ddl_PMClassify.DataBind(); ddl_PMClassify.Items.Insert(0, new ListItem("所有", "0")); ddl_PMClassify.SelectedValue = "0"; #endregion select_Client.PageUrl = "~/SubModule/CM/PopSearch/Search_SelectClient.aspx?ClientType=2&ExtCondition=\"MCS_SYS.dbo.UF_Spilt(CM_Client.ExtPropertys,~|~,7)=1\""; if (Request.QueryString["Client"] != null) { select_Client.SelectValue = Request.QueryString["Client"].ToString(); } }
private void BindDropDownList() { #region 绑定用户可管辖的片区 Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]); tr_OrganizeCity.DataSource = staff.GetStaffOrganizeCity(); if (tr_OrganizeCity.DataSource.Select("ID = 1").Length > 0) { tr_OrganizeCity.RootValue = "0"; tr_OrganizeCity.SelectValue = "1"; } else { tr_OrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString(); tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString(); } tr_OrganizeCity_Selected(null, null); #endregion ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate<GETDATE() AND Year>" + (DateTime.Today.Year - 1).ToString()); ddl_AccountMonth.DataBind(); ddl_AccountMonth.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Today).ToString(); }