protected void bt_Refresh_Click(object sender, EventArgs e)
{
ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());
if (ReportViewer1.ServerReport.GetParameters().Count == 3)
{
int staff = 0;
int position = new Org_StaffBLL((int)Session["UserID"]).Model.Position;
string remark = new Org_PositionBLL(position).Model.Remark;
if (remark != null && remark.Contains("OnlyViewSelfReport"))
{
staff = (int)Session["UserID"];
}
ReportParameter[] _parms = {
new ReportParameter("BeginDate",tbx_begin.Text),
new ReportParameter("EndDate", tbx_end.Text),
new ReportParameter("Staff",staff.ToString())
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
else
{
ReportParameter[] _parms = {
new ReportParameter("BeginDate",tbx_begin.Text),
new ReportParameter("EndDate", tbx_end.Text)
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
}
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();
}
#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()
{
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();
}
protected void bt_Approve_Click(object sender, EventArgs e)
{
if ((int)ViewState["ForcastID"] != 0)
{
string wftitle = "经销商销量预估流程申请ID：";
Save();
if ((int)ViewState["ClientType"] == 3)
{
wftitle = "零售商销量预估流程申请ID：";
}
Org_StaffBLL bll = new Org_StaffBLL((int)Session["UserID"]);
NameValueCollection dataobjects = new NameValueCollection();
dataobjects.Add("ID", ViewState["ForcastID"].ToString());
dataobjects.Add("OrganizeCity", bll.Model.OrganizeCity.ToString());
dataobjects.Add("ApplyFee", SVM_ClassifyForcastBLL.GetForcastSumPrice((int)ViewState["ForcastID"]).ToString());
int TaskID = EWF_TaskBLL.NewTask("SVM_ClassifyForcast_Approve", (int)Session["UserID"], wftitle + ViewState["ForcastID"].ToString(), "~/SubModule/SVM/ClassifyForcastDetail.aspx?ClientID=" + ViewState["ClientID"].ToString() + "&ForcastID=" + ViewState["ForcastID"].ToString(), dataobjects);
if (TaskID > 0)
{
SVM_ClassifyForcastBLL.Submit((int)ViewState["ForcastID"], TaskID);
new EWF_TaskBLL(TaskID).Start(); //直接启动流程
}
bt_Approve.Enabled = false;
Response.Redirect("~/SubModule/SVM/ClassifyForcast.aspx");
}
}
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
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()
{
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();
}
#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()
{
#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()
{
#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()
{
#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";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["Type"] = Request.QueryString["Type"] == null ? 0 : int.Parse(Request.QueryString["Type"]); //客户类型，1:公司仓库 2：经销商 3：终端门店
#region 设置页面Title
if ((int)ViewState["Type"] == 1)
lb_PageTitle.Text = "办事处出货查询";
else if ((int)ViewState["Type"] == 2)
lb_PageTitle.Text = "经销商出货查询";
else if ((int)ViewState["Type"] == 3)
lb_PageTitle.Text = "零售商销量查询";
else if ((int)ViewState["Type"] == 4)
lb_PageTitle.Text = "办事处进货查询";
#endregion
AdvancedSearch1.ExtCondition = "SVM_SalesVolume.Type=" + ViewState["Type"].ToString();
#region 判断当前可查询的范围
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);
if (staff.Model.OrganizeCity > 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += staff.Model.OrganizeCity.ToString();
AdvancedSearch1.ExtCondition += " AND SVM_SalesVolume.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
}
}
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 Bind()
{
int StaffID = int.Parse(ViewState["StaffID"].ToString());
if (StaffID <= 0)
StaffID = int.Parse(Session["UserID"].ToString());
Org_StaffBLL _staff = new Org_StaffBLL(StaffID);
switch (ViewState["Type"].ToString())
{
case "4":
p_headr.InnerText = "已录进货的零售店数(成品)-未完成";
gv_Detail.DataSource = _staff.GetFillProcessDetail(4);
break;
case "5":
p_headr.InnerText = "已录销量的零售店数(成品)-未完成";
gv_Detail.DataSource = _staff.GetFillProcessDetail(5);
break;
case "2":
p_headr.InnerText = "返利费用申请门店数-未完成";
gv_Detail.DataSource = _staff.GetFillProcessDetail(2);
break;
case "3":
p_headr.InnerText = "导购工资申请导购数-未完成";
gv_Detail.DataSource = _staff.GetFillProcessDetail(3);
break;
case "1":
default:
p_headr.InnerText = "陈列费用申请门店数-未完成";
gv_Detail.DataSource = _staff.GetFillProcessDetail(1);
break;
}
gv_Detail.DataBind();
gv_Detail.BindGrid();
}
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_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"]);
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
#region 如果非总部职位，其只能选择自己职位及以下职位
Org_Position p = new Org_PositionBLL(staff.Model.Position).Model;
if (p != null && p.IsHeadOffice != "Y" && p.Remark != "OfficeHR")
{
//tr_Position.RootValue = staff.Model.Position.ToString();// p.SuperID.ToString();
tr_Position.RootValue = p.SuperID.ToString();
tr_Position.SelectValue = staff.Model.Position.ToString();
}
else
{
tr_Position.RootValue = "1";
//tr_Position.SelectValue = "1";
}
tr_Position.SelectValue = tr_Position.RootValue;
#endregion
ddl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag");
ddl_ApproveFlag.DataBind();
ddl_ApproveFlag.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"));
#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"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region 获取页面参数
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
int _relateclient = 0;
if (staff.Model["RelateClient"] != "" && int.TryParse(staff.Model["RelateClient"], out _relateclient))
{
ViewState["ClientID"] = _relateclient;
select_Client.Enabled = false;
}
else
{
if (Request.QueryString["ClientID"] != null)
{
ViewState["ClientID"] = Int32.Parse(Request.QueryString["ClientID"]);
Session["ClientID"] = ViewState["ClientID"];
}
else if (Session["ClientID"] != null && Request.QueryString["State"] == null && Request.QueryString["ApproveFlag"] == null)
{
ViewState["ClientID"] = Int32.Parse(Session["ClientID"].ToString());
}
}
#endregion
if (ViewState["ClientID"] != null)
{
CM_ClientBLL client = new CM_ClientBLL((int)ViewState["ClientID"]);
select_Client.SelectValue = ViewState["ClientID"].ToString();
select_Client.SelectText = client.Model.FullName;
}
}
}
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()
{
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()
{
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";
}
}
protected void tr_Position_Selected(object sender, MCSControls.MCSWebControls.SelectedEventArgs e)
{
if (tr_Position.SelectValue != "0")
{
string positions = "";
if (cb_IncludeChild.Checked)
{
Org_PositionBLL pos = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
positions = pos.GetAllChildPosition();
if (positions != "")
{
positions += ",";
}
positions += tr_Position.SelectValue;
}
else
{
positions = tr_Position.SelectValue;
}
DataTable dt = Org_StaffBLL.GetRealNameAndUserNameByPosition(positions);
listAccount.Items.Clear();
foreach (DataRow row in dt.Rows)
{
listAccount.Items.Add(new ListItem((string)row["UserName"] + "[" + (string)row["RealName"] + "]", (string)row["UserName"]));
}
}
}
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()
{
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"));
}
protected void bt_AddApply_Click(object sender, EventArgs e)
{
if ((int)ViewState["ID"] == 0)
{
MessageBox.Show(this, "对不起，请您先保存后在发起申请");
return;
}
Org_StaffBLL bll = new Org_StaffBLL((int)ViewState["ID"]);
if (Org_StaffNumberLimitBLL.CheckAllowAdd(bll.Model.OrganizeCity, bll.Model.Position) < 0)
{
MessageBox.Show(this, "对不起当前城市该职位员工人数满额，要想继续新增请与人事经理联系");
return;
}
int budget = Org_StaffNumberLimitBLL.CheckOverBudget(bll.Model.OrganizeCity, bll.Model.Position);
NameValueCollection dataobjects = new NameValueCollection();
dataobjects.Add("ID", ViewState["ID"].ToString());
dataobjects.Add("OrganizeCity", bll.Model.OrganizeCity.ToString());
dataobjects.Add("Position", bll.Model.Position.ToString());
dataobjects.Add("SalaryFlag", bll.Model["SalaryFlag"].ToString());
dataobjects.Add("StaffName", bll.Model.RealName.ToString());
dataobjects.Add("IsOverBudget", budget < 0 ? "1" : "2");
int TaskID = EWF_TaskBLL.NewTask("Add_Staff", (int)Session["UserID"], "人员入职流程,姓名:" + bll.Model.RealName, "~/SubModule/StaffManage/StaffDetail.aspx?ID=" + ViewState["ID"].ToString(), dataobjects);
if (TaskID > 0)
{
bll.Model["TaskID"] = TaskID.ToString();
bll.Model["State"] = "2";
bll.Update();
}
Response.Redirect("~/SubModule/EWF/Apply.aspx?TaskID=" + TaskID.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
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
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()
{
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
#region 如果非总部职位，其只能选择自己职位及以下职位
Org_Position p = new Org_PositionBLL(staff.Model.Position).Model;
if (p != null && p.IsHeadOffice != "Y" && p.Remark != "OfficeHR")
{
//tr_Position.RootValue = staff.Model.Position.ToString();// p.SuperID.ToString();
tr_Position.RootValue = p.SuperID.ToString();
tr_Position.SelectValue = staff.Model.Position.ToString();
}
else
{
tr_Position.RootValue = "1";
//tr_Position.SelectValue = "1";
}
tr_Position.SelectValue = tr_Position.RootValue;
#endregion
ddl_ApproveFlag.DataSource = DictionaryBLL.GetDicCollections("PUB_ApproveFlag");
ddl_ApproveFlag.DataBind();
ddl_ApproveFlag.Items.Insert(0, new ListItem("请选择", "0"));
}
private void BindDropDown()
{
ddl_Salesman.DataSource = Org_StaffBLL.GetStaffList("Org_Staff.ID IN (SELECT SalesMan FROM MCS_PBM.dbo.PBM_Order WHERE Supplier=" + Session["OwnerClient"].ToString() +
" AND InsertTime>DATEADD(MONTH,-6,GETDATE()) ) AND Org_Staff.Dimission = 1");
ddl_Salesman.DataBind();
ddl_Salesman.Items.Insert(0, new ListItem("请选择...", "0"));
}
protected void bt_AddApply_Click(object sender, EventArgs e)
{
if ((int)ViewState["ID"] == 0)
{
MessageBox.Show(this, "对不起，请您先保存后在发起申请");
return;
}
Org_StaffBLL bll = new Org_StaffBLL((int)ViewState["ID"]);
NameValueCollection dataobjects = new NameValueCollection();
dataobjects.Add("ID", ViewState["ID"].ToString());
dataobjects.Add("OrganizeCity", bll.Model.OrganizeCity.ToString());
dataobjects.Add("Position", bll.Model.Position.ToString());
dataobjects.Add("SalaryFlag", bll.Model["SalaryFlag"].ToString());
dataobjects.Add("StaffName", bll.Model.RealName.ToString());
int TaskID = EWF_TaskBLL.NewTask("Add_Staff", (int)Session["UserID"], "人员入职流程,姓名:" + bll.Model.RealName, "~/SubModule/StaffManage/StaffDetail.aspx?ID=" + ViewState["ID"].ToString(), dataobjects);
if (TaskID > 0)
{
bll.Model["TaskID"] = TaskID.ToString();
bll.Model["State"] = "2";
bll.Update();
}
Response.Redirect("~/SubModule/EWF/Apply.aspx?TaskID=" + TaskID.ToString());
}
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()
{
#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"));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region 获取参数
ViewState["OrganizeCity"] = Request.QueryString["OrganizeCity"] == null ? 0 : int.Parse(Request.QueryString["OrganizeCity"]);
ViewState["AccountMonth"] = Request.QueryString["AccountMonth"] == null ? 0 : int.Parse(Request.QueryString["AccountMonth"]);
ViewState["Staff"] = Request.QueryString["Staff"] == null ? 0 : int.Parse(Request.QueryString["Staff"]);
#endregion
BindDropDown();
if ((int)ViewState["OrganizeCity"] > 0) tr_OrganizeCity.SelectValue = ViewState["OrganizeCity"].ToString();
if ((int)ViewState["AccountMonth"] > 0) ddl_AccountMonth.SelectedValue = ViewState["AccountMonth"].ToString();
if ((int)ViewState["Staff"] > 0)
{
Org_StaffBLL staff = new Org_StaffBLL((int)ViewState["Staff"]);
if (staff.Model != null)
{
select_Staff.SelectValue = staff.Model.ID.ToString();
select_Staff.SelectText = staff.Model.RealName;
tr_OrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString();
}
}
if (select_Staff.SelectValue != "") BindGrid();
}
}
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_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);
}
public void ReplySet(int MailID)
{
ML_MailBLL mailbll = new ML_MailBLL(MailID);
string tmpStr = "<br/>" + mailbll.Model.Content.ToString();
tmpStr = tmpStr.Replace("<br/>", "\r\n");
this.txtSubject.Text = "回复:" + mailbll.Model.Subject.ToString();
SendToRealName = mailbll.Model.Sender.ToString();
Org_StaffBLL staffbll = new Org_StaffBLL();
SendTo = mailbll.Model.Sender.ToString();
if (SendTo != "")
{
if (UserBLL.GetStaffByUsername(SendTo) != null)
{
SendToRealName = SendTo + "[" + UserBLL.GetStaffByUsername(SendTo).RealName + "]" + ",";
}
else
{
MessageBox.Show(this, "用户名不存在");
}
}
//SendTo = mailbll.Model.CcToAddr.ToString() + ",";
this.ckedit_content.Text = SendToRealName + "你好!<br/><br/><br/><br/><hr/>";
this.ckedit_content.Text += "-----------------" + mailbll.Model.SendTime.ToString("yyyy年MM月dd日 HH:mm") + ", " + SendToRealName + "在来信中写道:" + "-----------------<br/>";
this.ckedit_content.Text += tmpStr;
}
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 Bind()
{
int StaffID = int.Parse(ViewState["StaffID"].ToString());
if (StaffID <= 0)
StaffID = int.Parse(Session["UserID"].ToString());
Org_StaffBLL _staff = new Org_StaffBLL(StaffID);
int type = 0;
int.TryParse(ViewState["Type"].ToString(),out type);
int city=0;
int.TryParse(ViewState["City"].ToString(),out city);
switch (type)
{
case 1:
p_headr.InnerText = "陈列费用下游待审批";break;
case 2:
p_headr.InnerText = "返利费用下游待审批";break;
case 3:
p_headr.InnerText = "导购工资下游待审批";break;
case 4:
p_headr.InnerText = "费用核销下游待审批";break;
case 5:
p_headr.InnerText = "促销品请购下游待审批";break;
default:
p_headr.InnerText = "其他费用下游待审批";break;
}
gv_Detail.DataSource = _staff.GetLowerPositionTask(type, city, (int)ViewState["Month"]);
gv_Detail.DataBind();
gv_Detail.BindGrid();
}
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
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";
}
protected void bt_Refresh_Click(object sender, EventArgs e)
{
if (tr_OrganizeCity.SelectValue == "0")
{
MessageBox.Show(this, "请选择要查询的管理片区!");
return;
}
ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());
if (ReportViewer1.ServerReport.GetParameters().Count == 2)
{
int staff = 0;
int position = new Org_StaffBLL((int)Session["UserID"]).Model.Position;
string remark = new Org_PositionBLL(position).Model.Remark;
if (remark != null && remark.Contains("OnlyViewSelfReport"))
{
staff = (int)Session["UserID"];
}
ReportParameter[] _parms = {
new ReportParameter("OrganizeCity", tr_OrganizeCity.SelectValue),
new ReportParameter("Staff",staff.ToString())
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
else
{
ReportParameter[] _parms = {
new ReportParameter("OrganizeCity", tr_OrganizeCity.SelectValue)
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
}
private void BindRelateActivity()
{
DateTime JournalDate = DateTime.Parse(tbx_begindate.Text);
int OrganizeCity = new Org_StaffBLL((int)Session["UserID"], true).Model.OrganizeCity;
string ConditionStr = "PlanBeginDate BETWEEN '" + JournalDate.AddDays(-15).ToString("yyyy-MM-dd") + "' AND '"
+ JournalDate.AddDays(15).ToString("yyyy-MM-dd") + "' ";
if (OrganizeCity != 1)
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(OrganizeCity, true);
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += OrganizeCity.ToString();
if (orgcitys != "")
{
ConditionStr += " AND OrganizeCity IN (" + orgcitys + ") ";
}
}
//if(ddl_RelateActivity!=null)
//{
//ddl_RelateActivity.DataSource = CAT_ActivityBLL.GetModelList(ConditionStr);
//ddl_RelateActivity.DataBind();
//ddl_RelateActivity.Items.Insert(0, new ListItem("请选择您参与举办的活动...", "0"));
//ddl_RelateActivity_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
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"));
}
protected void bt_Refresh_Click(object sender, EventArgs e)
{
ReportViewer1.ServerReport.ReportServerCredentials = new MCSReportServerCredentials();
ReportViewer1.ServerReport.ReportPath = ViewState["ReportPath"].ToString();
ReportViewer1.ServerReport.ReportServerUrl = new Uri(ViewState["ReportServerUrl"].ToString());
if (ReportViewer1.ServerReport.GetParameters().Count == 3)
{
int staff = 0;
int position = new Org_StaffBLL((int)Session["UserID"]).Model.Position;
string remark = new Org_PositionBLL(position).Model.Remark;
if (remark != null && remark.Contains("OnlyViewSelfReport"))
{
staff = (int)Session["UserID"];
}
ReportParameter[] _parms = {
new ReportParameter("BeginDate",tbx_begin.Text),
new ReportParameter("EndDate", tbx_end.Text),
new ReportParameter("Staff",staff.ToString())
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
else
{
ReportParameter[] _parms = {
new ReportParameter("BeginDate",tbx_begin.Text),
new ReportParameter("EndDate", tbx_end.Text)
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
}
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()
{
#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()
{
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_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()
{
#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"]);
ddl_Month.DataSource = AC_AccountMonthBLL.GetModelList("BeginDate Between dateadd(month,-4,getdate()) AND getdate()");
ddl_Month.DataBind();
ddl_Month.SelectedValue = AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddMonths(-1)).ToString();
#endregion
}
protected void bt_Add_StaffInOrganizeCity_Click(object sender, EventArgs e)
{
if (ddl_StaffInOrganizeCity.SelectedValue != "0" && (int)ViewState["ID"] != 0)
{
Org_StaffBLL _staffbll = new Org_StaffBLL((int)ViewState["ID"]);
_staffbll.StaffInOrganizeCity_Add(int.Parse(ddl_StaffInOrganizeCity.SelectedValue));
gv_StaffInOrganizeCity.BindGrid<Addr_OrganizeCity>(_staffbll.StaffInOrganizeCity_GetOrganizeCitys());
}
}
protected void select_OrgClientManager_SelectChange(object sender, MCSControls.MCSWebControls.SelectChangeEventArgs e)
{
if (select_OrgClientManager.SelectValue != "")
{
Org_Staff staff = new Org_StaffBLL(int.Parse(select_OrgClientManager.SelectValue)).Model;
if (staff != null)
{
lb_Prompt.Text = "注意：该操作将会替换所有原客户经理为【" + staff.RealName + "】的" + ((int)ViewState["ClientType"] == 2 ? "经销商" : "零售商") + "，请小心操作!";
}
}
}
protected void bt_DeleteUser_Click(object sender, EventArgs e)
{
Org_StaffBLL staff = new Org_StaffBLL((int)ViewState["ID"]);
if (staff.Model == null) return;
Membership.DeleteUser(lb_Username.Text, true);
staff.Model.aspnetUserId = Guid.Empty;
staff.Update();
Response.Redirect("StaffList.aspx");
}
private void BindData()
{
Org_Staff staff = new Org_StaffBLL((int)ViewState["ClientManager"]).Model;
if (staff != null)
{
select_OrgClientManager.SelectText = staff.RealName;
select_OrgClientManager.SelectValue = staff.ID.ToString();
lb_Prompt.Text = "注意：该操作将会替换所有原客户经理为【" + staff.RealName + "】的" + ((int)ViewState["ClientType"] == 2 ? "经销商" : "零售商") + "，请小心操作!";
}
}
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;
}
}
/// <summary>
/// 审核
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void bt_Approve_Click(object sender, EventArgs e)
{
if ((int)ViewState["ID"] != 0)
{
Org_StaffBLL _staff = new Org_StaffBLL((int)ViewState["ID"]);
if (_staff.Model != null && _staff.Model.ApproveFlag == 2)
{
if (_staff.Approve() == 0)
{
MessageBox.Show(this, "审核成功！");
BindData();
}
}
}
}
protected DateTime _pageInitTime; //= DateTime.Now; //用于计算页面生成时间
#endregion Fields
#region Methods
protected void bt_On_Click(object sender, EventArgs e)
{
WT_WorkTimeBLL _bll = new WT_WorkTimeBLL();
Org_Staff _s = new Org_StaffBLL(int.Parse(Session["UserID"].ToString())).Model;
if (_bll.IsBeginWork(int.Parse(Session["UserID"].ToString())))
{
MessageBox.Show(this.Page, "你今天已经上班了！");
}
else
{
_bll.BeginWork(int.Parse(Session["UserID"].ToString()), _s.OrganizeCity);
bt_On.Visible = false;
bt_Out.Visible = true;
}
}
private void BindData()
{
Org_StaffBLL bll = new Org_StaffBLL((int)ViewState["ID"]);
panel1.BindData(bll.Model);
if (bll.Model.OrganizeCity > 1)
{
gv_StaffInOrganizeCity.BindGrid<Addr_OrganizeCity>(bll.StaffInOrganizeCity_GetOrganizeCitys());
}
else
{
tr_StaffInOrganizeCity.Visible = false;
}
gv_List.DataSource = bll.GetUserList();
gv_List.DataBind();
}