private void BindDropdown()
{
IList <AC_AccountMonth> _monthlist = AC_AccountMonthBLL.GetModelList("");
ddl_AccountMonth.DataSource = _monthlist;
ddl_AccountMonth.DataBind();
ddl_AccountMonth2.DataSource = AC_AccountMonthBLL.GetModelList("Year>=" + (DateTime.Now.Year - 1).ToString());
ddl_AccountMonth2.DataBind();
int JXCDelayDays = ConfigHelper.GetConfigInt("JXCDelayDays");
ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetCurrentMonth() - 1).ToString();
ddl_AccountMonth2.SelectedValue = "0";
select_Staff.SelectValue = Session["UserID"].ToString();
select_Staff.SelectText = Session["UserRealName"].ToString();
if ((int)(ViewState["IsOpponent"]) != 2 && (int)(ViewState["IsOpponent"]) != 3)
{
ddl_Opponent.SelectedValue = ViewState["IsOpponent"].ToString();
}
string condition = " 1=1 ";
if (!string.IsNullOrEmpty(ConfigHelper.GetConfigString("OrganizePartCity-CityLevel")))
{
condition = " Level=" + ConfigHelper.GetConfigString("OrganizePartCity-CityLevel");
}
ddl_OrganizeCity.DataSource = Addr_OrganizeCityBLL.GetModelList(condition);
ddl_OrganizeCity.DataTextField = "Name";
ddl_OrganizeCity.DataValueField = "ID";
ddl_OrganizeCity.DataBind();
ddl_OrganizeCity.Items.Insert(0, new ListItem("请选择", "0"));
ddl_ExcelState.DataSource = DictionaryBLL.GetDicCollections((int)(ViewState["State"]) == 2 ? "SVM_UploadState" : "SVM_DownloadState");
ddl_ExcelState.DataBind();
ddl_ExcelState.Items.Insert(0, new ListItem("所有", "0"));
ddl_ExcelState2.DataSource = ddl_ExcelState.DataSource;
ddl_ExcelState2.DataBind();
ddl_ExcelState2.Items.Insert(0, new ListItem("所有", "0"));
if ((int)(ViewState["State"]) == 1)
{
ddl_ExcelState.SelectedValue = "2";
ddl_ExcelState2.SelectedValue = "2";
}
MCSTabControl1.SelectedIndex = (int)ViewState["State"] - 1;
ddl_ClientType.SelectedValue = ViewState["ClientType"].ToString();
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker worker = sender as BackgroundWorker;
HSSFWorkbook book = new HSSFWorkbook();
ISheet sheet = book.CreateSheet("季度费率");
sheet.SetColumnWidth(0, 12 * 256);
sheet.SetColumnWidth(2, 20 * 256);
sheet.SetColumnWidth(3, 12 * 256);
sheet.SetColumnWidth(4, 20 * 256);
sheet.SetColumnWidth(5, 16 * 256);
sheet.SetColumnWidth(6, 12 * 256);
int rowcount = 0;
IRow row = sheet.CreateRow(rowcount);
row.CreateCell(0).SetCellValue("营业部");
row.CreateCell(1).SetCellValue("办事处ID");
row.CreateCell(2).SetCellValue("办事处");
row.CreateCell(3).SetCellValue("归属季度ID");
row.CreateCell(4).SetCellValue("归属季度");
row.CreateCell(5).SetCellValue("季度预算费率");
row.CreateCell(6).SetCellValue("季度实际费率");
row.CreateCell(7).SetCellValue("导入标志");
IList <Addr_OrganizeCity> _cityList = Addr_OrganizeCityBLL.GetModelList("Level=4 Order By Level3_SuperID");
foreach (Addr_OrganizeCity city in _cityList)
{
row = sheet.CreateRow(++rowcount);
row.CreateCell(0).SetCellValue(new Addr_OrganizeCityBLL(city.SuperID).Model.Name);
row.CreateCell(1).SetCellValue(city.ID);
row.CreateCell(2).SetCellValue(city.Name);
row.CreateCell(3).SetCellValue(cmb_Quarter.SelectedValue.ToString());
row.CreateCell(4).SetCellValue(cmb_Quarter.SelectedText);
row.CreateCell(5).SetCellValue("");
row.CreateCell(6).SetCellValue("");
row.CreateCell(7).SetCellValue("");
worker.ReportProgress(rowcount * 100 / _cityList.Count, rowcount);
}
//保存
using (FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write))
{
book.Write(fs);
}
book = null;
sheet = null;
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker worker = sender as BackgroundWorker;
HSSFWorkbook book = new HSSFWorkbook();
ISheet sheet = book.CreateSheet("办事处目标");
sheet.SetColumnWidth(0, 12 * 256);
sheet.SetColumnWidth(2, 20 * 256);
sheet.SetColumnWidth(3, 12 * 256);
sheet.SetColumnWidth(4, 20 * 256);
sheet.SetColumnWidth(5, 16 * 256);
sheet.SetColumnWidth(6, 12 * 256);
int rowcount = 0;
IRow row = sheet.CreateRow(rowcount);
row.CreateCell(0).SetCellValue("营业部");
row.CreateCell(1).SetCellValue("办事处ID");
row.CreateCell(2).SetCellValue("办事处");
row.CreateCell(3).SetCellValue("归属月份");
row.CreateCell(4).SetCellValue("办事处业绩目标额");
row.CreateCell(5).SetCellValue("导入标志");
IList <Addr_OrganizeCity> _cityList = Addr_OrganizeCityBLL.GetModelList("Level=4 Order By Level3_SuperID");
AC_AccountMonthBLL monthbll = new AC_AccountMonthBLL(AC_AccountMonthBLL.GetMonthByDate(DateTime.Now.AddMonths(-1)));
foreach (Addr_OrganizeCity city in _cityList)
{
row = sheet.CreateRow(++rowcount);
row.CreateCell(0).SetCellValue(new Addr_OrganizeCityBLL(city.SuperID).Model.Name);
row.CreateCell(1).SetCellValue(city.ID);
row.CreateCell(2).SetCellValue(city.Name);
row.CreateCell(3).SetCellValue(monthbll.Model.Name);
row.CreateCell(4).SetCellValue("");
row.CreateCell(5).SetCellValue("");
worker.ReportProgress(rowcount * 100 / _cityList.Count, rowcount);
}
//保存
using (FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write))
{
book.Write(fs);
}
book = null;
sheet = null;
}
private void BindGrid()
{
if (ViewState["ClientID"] != null)
{
CM_ClientBLL bll = new CM_ClientBLL((int)ViewState["ClientID"]);
#region 绑定住宿人员
gv_Staff.ConditionString = "MCS_CM.dbo.CM_StaffInProperty.Client = " + ViewState["ClientID"].ToString() + " AND Org_Staff.Dimission=1";
gv_Staff.BindGrid();
#endregion
#region 绑定兼管片区
if (bll.Model.OrganizeCity > 1)
{
ddl_PropertyInOrganizeCity.Items.Clear();
int superid = new Addr_OrganizeCityBLL(bll.Model.OrganizeCity).Model.SuperID;
IList <Addr_OrganizeCity> lists = Addr_OrganizeCityBLL.GetModelList("SuperID = " + superid.ToString() +
" AND ID <> " + bll.Model.OrganizeCity.ToString() +
" AND ID NOT IN (SELECT OrganizeCity FROM MCS_CM.dbo.CM_PropertyInOrganizeCity WHERE Client=" + bll.Model.ID.ToString() + ")");
if (lists.Count > 0)
{
foreach (Addr_OrganizeCity city in lists)
{
ddl_PropertyInOrganizeCity.Items.Add(new ListItem("(" + city.Code + ")" + city.Name, city.ID.ToString()));
}
}
ddl_PropertyInOrganizeCity.Items.Insert(0, new ListItem("请选择...", "0"));
gv_PropertyInOrganizeCity.BindGrid <Addr_OrganizeCity>(bll.ClientInOrganizeCity_GetOrganizeCitys());
}
else
{
tr_PropertyInOrganizeCity.Visible = false;
}
#endregion
#region 绑定电话列表
gv_Telephone.ConditionString = "Client=" + bll.Model.ID.ToString();
gv_Telephone.BindGrid();
#endregion
#region 绑定合同列表
gv_List_Contract.BindGrid(CM_ContractBLL.GetModelList("Client=" + bll.Model.ID.ToString()));
#endregion
}
}
private void Init()
{
IList <Addr_OrganizeCity> citys = Addr_OrganizeCityBLL.GetModelList
("Level=2 AND ID NOT IN (SELECT OrganizeCity FROM MCS_FNA.dbo.FNA_BudgetSource WHERE AccountMonth=" +
ddl_AccountMonth.SelectedValue + ") ORDER BY SuperID,Code");
foreach (Addr_OrganizeCity city in citys)
{
FNA_BudgetSourceBLL bll = new FNA_BudgetSourceBLL();
bll.Model.AccountMonth = int.Parse(ddl_AccountMonth.SelectedValue);
bll.Model.OrganizeCity = city.ID;
bll.Model.ApproveFlag = 2;
bll.Model.InsertStaff = (int)Session["UserID"];
bll.Model["DepartmentBudget"] = "0";
bll.Add();
}
}
private void BindDropDown()
{
chk_Citylist.DataSource = Addr_OrganizeCityBLL.GetModelList("Level=" + ConfigHelper.GetConfigString("OrganizePartCity-CityLevel"));
chk_Citylist.DataBind();
if ((int)ViewState["Type"] == 2)
{
MCSTabControl1.SelectedIndex = 2;
tb_step1.Visible = MCSTabControl1.SelectedIndex == 0;
}
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"));
//CheckOrganizeCity();
ddl_AccountMonth.DataSource = AC_AccountMonthBLL.GetModelList("");
ddl_AccountMonth.DataBind();
ddl_AccountMonth.SelectedValue = (AC_AccountMonthBLL.GetCurrentMonth() - 1).ToString();
}
private void BindData(int ID)
{
ViewState["ID"] = ID;
Addr_OrganizeCityBLL _bll = new Addr_OrganizeCityBLL(ID);
lbl_ID.Text = _bll.Model.ID.ToString();
tbx_Name.Text = _bll.Model.Name;
if (_bll.Model.SuperID != 0)
{
tree_SuperID.SelectValue = _bll.Model.SuperID.ToString();
}
tbx_Code.Text = _bll.Model.Code;
if (_bll.Model.Manager != 0)
{
select_Manager.SelectValue = _bll.Model.Manager.ToString();
select_Manager.SelectText = new Org_StaffBLL(_bll.Model.Manager).Model.RealName;
}
else
{
select_Manager.SelectValue = "";
select_Manager.SelectText = "";
}
if (_bll.Model.Level != 0)
{
lbl_LevelName.Text = DictionaryBLL.GetDicCollections("Addr_OrganizeCityLevel")[_bll.Model.Level.ToString()].Name;
}
tbx_ManageRegion.Text = _bll.Model["ManageRegion"];
if (ID == 1)
{
btn_Save.Visible = false;
btn_Delete.Visible = false;
}
else
{
btn_Save.Visible = true;
btn_Delete.Visible = true;
}
bt_AddSub.Visible = true;
MessageBox.ShowConfirm(btn_Delete, "数据删除将不可恢复，确定删除么?");
btn_Delete.Visible = Addr_OrganizeCityBLL.GetModelList("SuperID=" + ViewState["ID"].ToString()).Count == 0;
lbl_AlertInfo.Text = "";
#region 绑定已关联的行政区县列表
if (_bll.Model.Level.ToString() == ConfigHelper.GetConfigString("OrganizeCity-CityLevel"))
{
tb_OfficialCityInOrganizeCity.Visible = true;
cb_CheckAll.Checked = false;
cbl_OfficialList.Items.Clear();
IList <Addr_OfficialCityInOrganizeCity> lists = Addr_OfficialCityInOrganizeCityBLL.GetModelList("OrganizeCity = " + ID.ToString());
foreach (Addr_OfficialCityInOrganizeCity e in lists)
{
Addr_OfficialCityBLL city = new Addr_OfficialCityBLL(e.OfficialCity);
string fullname = TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OfficialCity", city.Model.ID);
ListItem item = new ListItem(fullname, e.ID.ToString());
cbl_OfficialList.Items.Add(item);
}
bt_AddOfficialCity.OnClientClick = "PopAddOfficialCity(" + ID.ToString() + ")";
}
else
{
tb_OfficialCityInOrganizeCity.Visible = false;
}
#endregion
}
private void BindData()
{
Org_StaffBLL bll = new Org_StaffBLL((int)ViewState["ID"]);
panel1.BindData(bll.Model);
Header.Attributes["WebPageSubCode"] = "Modify";
gv_List.DataSource = bll.GetUserList();
gv_List.DataBind();
UploadFile1.RelateID = (int)ViewState["ID"];
UploadFile1.BindGrid();
Org_Staff m = bll.Model;
if (m.ApproveFlag == 1)
{
if (m.Dimission == 1)
{
bt_AddApply.Visible = false;
}
bt_Approve.Visible = false;
TextBox tbx_BeginWorkTime = (TextBox)panel1.FindControl("Org_Staff_BeginWorkTime");
// if (tbx_BeginWorkTime != null) tbx_BeginWorkTime.Enabled = false;//03-17暂停使用,便于维护资料
if (m.Dimission == 2)
{
TextBox tbx_EndWorkTime = (TextBox)panel1.FindControl("Org_Staff_EndWorkTime");
if (tbx_EndWorkTime != null)
{
tbx_EndWorkTime.Enabled = false;
}
}
}
if (m["State"] == "2")
{
//审批中
bt_AddApply.Visible = false;
bt_OK.Visible = false;
bt_CreateUser.Visible = false;
bt_TaskDetail.Visible = true;
bt_RevocationApply.Visible = false;
}
if (bll.Model.OrganizeCity > 1)
{
#region 绑定兼管片区
IList <Addr_OrganizeCity> staffincity = bll.StaffInOrganizeCity_GetOrganizeCitys();
Addr_OrganizeCity currentcity = new Addr_OrganizeCityBLL(bll.Model.OrganizeCity).Model;
if (currentcity != null)
{
Addr_OrganizeCity parent = new Addr_OrganizeCityBLL(currentcity.SuperID).Model;
if (parent != null)
{
IList <Addr_OrganizeCity> lists = Addr_OrganizeCityBLL.GetModelList("SuperID = " + parent.ID.ToString() + " AND ID <> " + bll.Model.OrganizeCity.ToString());
if (lists.Count > 0)
{
foreach (Addr_OrganizeCity city in lists)
{
if (staffincity.FirstOrDefault(p => p.ID == city.ID) == null)
{
ddl_StaffInOrganizeCity.Items.Add(new ListItem(parent.Name + "->" + city.Name + "(" + city.Code + ")", city.ID.ToString()));
}
}
}
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
Org_Position position = new Org_PositionBLL(staff.Model.Position).Model;
if (currentcity.Level > 1 && position != null && (position.IsHeadOffice == "Y" || position.Remark == "OfficeHR"))
{
int grandpacityid = new Addr_OrganizeCityBLL(currentcity.SuperID).Model.SuperID;
string condition = "SuperID = " + grandpacityid.ToString() + " AND ID <> " + currentcity.SuperID.ToString();
if (currentcity.Level < ConfigHelper.GetConfigInt("OrganizeCity-CityLevel"))
{
condition = "SuperID != " + parent.ID.ToString() + " AND Level=" + (currentcity.Level - 1).ToString() + " AND ID <> " + currentcity.SuperID.ToString();
}
IList <Addr_OrganizeCity> bobos = Addr_OrganizeCityBLL.GetModelList(condition);
foreach (Addr_OrganizeCity bobo in bobos)
{
IList <Addr_OrganizeCity> tangxongs = Addr_OrganizeCityBLL.GetModelList("SuperID = " + bobo.ID.ToString());
foreach (Addr_OrganizeCity city in tangxongs)
{
if (staffincity.FirstOrDefault(p => p.ID == city.ID) == null)
{
ddl_StaffInOrganizeCity.Items.Add(new ListItem(bobo.Name + "->" + city.Name + "(" + city.Code + ")", city.ID.ToString()));
}
}
}
}
}
ddl_StaffInOrganizeCity.Items.Insert(0, new ListItem("请选择...", "0"));
}
if (ddl_StaffInOrganizeCity.Items.Count == 0)
{
bt_Add_StaffInOrganizeCity.Enabled = false;
}
#endregion
gv_StaffInOrganizeCity.BindGrid <Addr_OrganizeCity>(bll.StaffInOrganizeCity_GetOrganizeCitys());
}
else
{
tr_StaffInOrganizeCity.Visible = false;
}
bt_OK.Text = "保 存";
bt_OK.ForeColor = System.Drawing.Color.Red;
//if (new Org_StaffBLL((int)Session["UserID"]).Model.ID != 1)
//{
// ((MCSTreeControl)panel1.FindControl("Org_Staff_Position")).Enabled = false;
//}
int budget = Org_StaffNumberLimitBLL.CheckOverBudget(m.OrganizeCity, m.Position);
if (budget == 0)
{
lb_OverBudgetInfo.Text = "当前城市该职位人员数量已等于预定的预算人数，请注意！";
}
else if (budget < 0)
{
lb_OverBudgetInfo.Text = "当前城市该职位人员数量已超过预定的预算人数 " + (0 - budget).ToString() + "人，请注意！";
}
}
private void BindData()
{
Org_StaffBLL bll = new Org_StaffBLL((int)ViewState["ID"]);
if (bll.Model == null)
{
return;
}
panel1.BindData(bll.Model);
gv_List.DataSource = bll.GetUserList();
gv_List.DataBind();
UploadFile1.RelateID = (int)ViewState["ID"];
UploadFile1.BindGrid();
Org_Staff m = bll.Model;
if (m.ApproveFlag == 1)
{
if (m.Dimission == 1)
{
bt_AddApply.Visible = false;
}
bt_Approve.Visible = false;
Header.Attributes["WebPageSubCode"] = "Modify";
TextBox tbx_BeginWorkTime = (TextBox)panel1.FindControl("Org_Staff_BeginWorkTime");
// if (tbx_BeginWorkTime != null) tbx_BeginWorkTime.Enabled = false;//03-17暂停使用,便于维护资料
if (m.Dimission == 2)
{
TextBox tbx_EndWorkTime = (TextBox)panel1.FindControl("Org_Staff_EndWorkTime");
if (tbx_EndWorkTime != null)
{
tbx_EndWorkTime.Enabled = false;
}
}
}
if (m["State"] == "2")
{
//审批中
bt_AddApply.Visible = false;
bt_OK.Visible = false;
bt_CreateUser.Visible = false;
bt_TaskDetail.Visible = true;
}
if (bll.Model.OrganizeCity > 1)
{
#region 绑定兼管片区
IList <Addr_OrganizeCity> staffincity = bll.StaffInOrganizeCity_GetOrganizeCitys();
Addr_OrganizeCity currentcity = new Addr_OrganizeCityBLL(bll.Model.OrganizeCity).Model;
if (currentcity != null)
{
Addr_OrganizeCity parent = new Addr_OrganizeCityBLL(currentcity.SuperID).Model;
if (parent != null)
{
IList <Addr_OrganizeCity> lists = Addr_OrganizeCityBLL.GetModelList("SuperID = " + parent.ID.ToString() + " AND ID <> " + bll.Model.OrganizeCity.ToString());
if (lists.Count > 0)
{
foreach (Addr_OrganizeCity city in lists)
{
if (staffincity.FirstOrDefault(p => p.ID == city.ID) == null)
{
ddl_StaffInOrganizeCity.Items.Add(new ListItem(parent.Name + "->" + city.Name + "(" + city.Code + ")", city.ID.ToString()));
}
}
}
if (currentcity.Level > 1)
{
int grandpacityid = new Addr_OrganizeCityBLL(currentcity.SuperID).Model.SuperID;
IList <Addr_OrganizeCity> bobos = Addr_OrganizeCityBLL.GetModelList("SuperID = " + grandpacityid.ToString() + " AND ID <> " + currentcity.SuperID.ToString());
foreach (Addr_OrganizeCity bobo in bobos)
{
IList <Addr_OrganizeCity> tangxongs = Addr_OrganizeCityBLL.GetModelList("SuperID = " + bobo.ID.ToString());
foreach (Addr_OrganizeCity city in tangxongs)
{
if (staffincity.FirstOrDefault(p => p.ID == city.ID) == null)
{
ddl_StaffInOrganizeCity.Items.Add(new ListItem(bobo.Name + "->" + city.Name + "(" + city.Code + ")", city.ID.ToString()));
}
}
}
}
}
ddl_StaffInOrganizeCity.Items.Insert(0, new ListItem("请选择...", "0"));
}
if (ddl_StaffInOrganizeCity.Items.Count == 0)
{
bt_Add_StaffInOrganizeCity.Enabled = false;
}
#endregion
gv_StaffInOrganizeCity.BindGrid <Addr_OrganizeCity>(bll.StaffInOrganizeCity_GetOrganizeCitys());
}
else
{
tr_StaffInOrganizeCity.Visible = false;
}
bt_OK.Text = "保 存";
bt_OK.ForeColor = System.Drawing.Color.Red;
//if (new Org_StaffBLL((int)Session["UserID"]).Model.ID != 1)
//{
// ((MCSTreeControl)panel1.FindControl("Org_Staff_Position")).Enabled = false;
//}
}