protected void tr_Position_Selected(object sender, MCSControls.MCSWebControls.SelectedEventArgs e)
{
if (tr_Position.SelectedValue != "0")
{
string positions = "";
if (cb_IncludeChild.Checked)
{
Org_PositionBLL pos = new Org_PositionBLL(int.Parse(tr_Position.SelectedValue));
positions = pos.GetAllChildPosition();
if (positions != "") positions += ",";
positions += tr_Position.SelectedValue;
}
else
positions = tr_Position.SelectedValue;
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"]));
}
}
}
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();
}
}
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);
}
}
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()
{
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"));
}
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 BindStaffList()
{
listAccount.Items.Clear();
if (ddl_Position.SelectedValue != "0" || (ddl_Position.SelectedValue == "0" && tbx_Name.Text.Trim() != ""))
{
string positions = "";
if (ddl_Position.SelectedValue == "0")
{
Org_PositionBLL pos = new Org_PositionBLL(1);
positions = pos.GetAllChildPosition() + ",1";
}
else
{
if (cb_IncludeChild.Checked)
{
Org_PositionBLL pos = new Org_PositionBLL(int.Parse(ddl_Position.SelectedValue));
positions = pos.GetAllChildPosition();
if (positions != "") positions += ",";
positions += ddl_Position.SelectedValue;
}
else
positions = ddl_Position.SelectedValue;
}
DataTable dt = Org_StaffBLL.GetRealNameAndUserNameByPosition(positions);
dt.DefaultView.RowFilter = " RealName like '%" + tbx_Name.Text + "%' ";
for (int i = 0; i < dt.DefaultView.Count; i++)
{
listAccount.Items.Add(new ListItem((string)dt.DefaultView[i]["RealName"], (string)dt.DefaultView[i]["UserName"]));
}
}
}
//protected void tbx_Name_TextChanged(object sender, EventArgs e)
//{
//}
protected void bt_serch_Click(object sender, EventArgs e)
{
if (tr_Position.SelectedValue != "0")
{
string positions = "";
if (cb_IncludeChild.Checked)
{
Org_PositionBLL pos = new Org_PositionBLL(int.Parse(tr_Position.SelectedValue));
positions = pos.GetAllChildPosition();
if (positions != "")
{
positions += ",";
}
positions += tr_Position.SelectedValue;
}
else
{
positions = tr_Position.SelectedValue;
}
DataTable dt = Org_StaffBLL.GetRealNameAndUserNameByPosition(positions);
dt.DefaultView.RowFilter = " RealName like '%" + tbx_Name.Text + "%' ";
listAccount.Items.Clear();
for (int i = 0; i < dt.DefaultView.Count; i++)
{
listAccount.Items.Add(new ListItem((string)dt.DefaultView[i]["UserName"] + "[" + (string)dt.DefaultView[i]["RealName"] + "]", (string)dt.DefaultView[i]["UserName"]));
}
}
}
private void BindGrid()
{
string condition = "1=1";
#region 根据职位的范围查询
if (tr_Position.SelectValue != tr_Position.RootValue && tr_Position.SelectValue != "0")
{
if (chb_ToPositionChild.Checked)
{
#region 绑定子职位
Org_PositionBLL _bll = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
string ids = "";
ids = _bll.GetAllChildPosition();
#endregion
if (ids != "")
condition += " and RelatePosition in(" + tr_Position.SelectValue + "," + ids + ")";
else
condition += " and RelatePosition =" + tr_Position.SelectValue;
}
else
{
condition += " and RelatePosition =" + tr_Position.SelectValue;
}
}
#endregion
if (ddl_ApproveFlag.SelectedValue != "0")
{
condition += " AND ApproveFlag="+ddl_ApproveFlag.SelectedValue;
}
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindPosition()
{
listAccount.Items.Clear();
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
tr_Position.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()
{
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();
}
public void BindGrid()
{
string condition = " 1 = 1 ";
#region 判断当前可查询的范围
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") condition += " AND OrganizeCity IN (" + orgcitys + ")";
}
if (tr_Position.SelectValue != "1")
{
Org_PositionBLL org_position = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
string positions = org_position.GetAllChildPosition();
if (positions != "") positions += ",";
positions += tr_Position.SelectValue;
if (positions != "") condition += " AND Position IN (" + positions + ")";
}
#endregion
gv_List.BindGrid(Org_StaffNumberLimitBLL.GetModelList(condition));
}
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);
}
}
//protected void tbx_Name_TextChanged(object sender, EventArgs e)
//{
//}
protected void bt_serch_Click(object sender, EventArgs e)
{
if (tr_Position.SelectedValue != "0")
{
string positions = "";
if (cb_IncludeChild.Checked)
{
Org_PositionBLL pos = new Org_PositionBLL(int.Parse(tr_Position.SelectedValue));
positions = pos.GetAllChildPosition();
if (positions != "") positions += ",";
positions += tr_Position.SelectedValue;
}
else
positions = tr_Position.SelectedValue;
DataTable dt = Org_StaffBLL.GetRealNameAndUserNameByPosition(positions);
dt.DefaultView.RowFilter = " RealName like '%" + tbx_Name.Text + "%' ";
listAccount.Items.Clear();
for (int i = 0; i < dt.DefaultView.Count; i++)
{
listAccount.Items.Add(new ListItem((string)dt.DefaultView[i]["UserName"] + "[" + (string)dt.DefaultView[i]["RealName"] + "]", (string)dt.DefaultView[i]["UserName"]));
}
}
}
private void BindData()
{
QNA_Project m = new QNA_ProjectBLL((int)ViewState["ID"]).Model;
if (m != null)
{
pl_detail.BindData(m);
if (m.Enabled == "Y")
{
bt_Enabled.Visible = false;
}
else
{
bt_Disabled.Visible = false;
}
tab_QNAToPosition.Visible = m.ToAllStaff == "N";
tab_QNAToOrganizeCity.Visible = m.ToAllOrganizeCity == "N";
ddl_FaceTo_SelectedIndexChanged(null, null);
gv_List.ConditionString = "QNA_Question.Project=" + m.ID.ToString() + " ORDER BY QNA_Question.SortCode";
gv_List.BindGrid();
#region 显示所属职位，片区
if (tab_QNAToPosition.Visible)
{
List <int> List = new List <int>();
List = new QNA_ToPositionBLL().GetPositionByProjectID((int)ViewState["ID"]);
lb_PositionChild.Items.Clear();
if (List != null)
{
foreach (int id in List)
{
Org_PositionBLL positionbll = new Org_PositionBLL(id);
lb_PositionChild.Items.Add(new ListItem(positionbll.Model.Name, id.ToString()));
}
}
}
if (tab_QNAToOrganizeCity.Visible)
{
List <int> List = new List <int>();
List = new QNA_ToOrganizeCityBLL().GetOrganizeCityByProjectID((int)ViewState["ID"]);
lb_CityChild.Items.Clear();
if (List != null)
{
foreach (int id in List)
{
Addr_OrganizeCityBLL organizeCitybll = new Addr_OrganizeCityBLL(id);
lb_CityChild.Items.Add(new ListItem(organizeCitybll.Model.Name, id.ToString()));
}
}
}
#endregion
}
}
private void BindDropDown()
{
ddl_Type.DataSource = DictionaryBLL.GetDicCollections("EWF_Role_Type");
ddl_Type.DataBind();
ddl_Type.Items.Insert(0, new ListItem("请选择...", "0"));
tr_SuperPosition.DataSource = Org_PositionBLL.GetAllPostion();
tr_SuperPosition.DataBind();
tr_SuperPosition.SelectValue = "0";
}
private void BindDropDown()
{
//SuperPosition
tr_SuperPosition.DataSource = Org_PositionBLL.GetAllPostion();
//Depart
ddl_Department.DataSource = DictionaryBLL.GetDicCollections("PUB_Department");
ddl_Department.DataBind();
ddl_Department.Items.Insert(0, new ListItem("请选择...", "0"));
}
private void BindPosition()
{
//ddl_Position.DataSource = Org_PositionBLL.GetAllPostion();
//ddl_Position.DataBind();
//ddl_Position.Items.Insert(0, new ListItem("请选择员工职位", "0"));
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
tr_Position.SelectedValue = "1";
//tr_Position.SelectValue = "1";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
tr_Position.SelectValue = "0";
BindTree(tr_Role.Nodes);
}
}
protected void btn_Delete_Click(object sender, EventArgs e)
{
Org_PositionBLL _bll = new Org_PositionBLL(int.Parse(lbl_ID.Text));
if (_bll.Delete() < 0)
{
lbl_AlertInfo.Text = "该职务包含下级职务，请勿删除";
return;
}
lbl_AlertInfo.Text = "";
Response.Redirect("PositionManage.aspx");
}
protected void btn_Delete_Click(object sender, EventArgs e)
{
Org_PositionBLL _bll = new Org_PositionBLL(int.Parse(lbl_ID.Text));
if (_bll.Delete() < 0)
{
lbl_AlertInfo.Text = "该职务包含下级职务，请勿删除";
return;
}
lbl_AlertInfo.Text = "";
Response.Redirect("PositionManage.aspx");
}
private void BindTree(TreeNodeCollection TNC, int SuperID)
{
IList <Org_Position> _positionlist = Org_PositionBLL.GetModelList("SuperID=" + SuperID.ToString());
foreach (Org_Position _position in _positionlist)
{
TreeNode tn = new TreeNode();
tn.Text = _position.Name + "(" + _position.ID.ToString() + ")";
tn.Value = _position.ID.ToString();
TNC.Add(tn);
BindTree(tn.ChildNodes, _position.ID);
}
}
protected string DisplayFullInfo(string loginname)
{
string ret = "";
Org_Staff staff = UserBLL.GetStaffByUsername(loginname);
ret = "登录名称：<a href=\"javascript:SendMsg('" + loginname + "','" + Server.UrlPathEncode(staff.RealName) + "');\" title='发送短内短信' style='color:red' target='_self'>" + loginname + "</a>";
ret += "<br/>真实姓名：" + staff.RealName + "<br/>所属区域：" + TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OrganizeCity", "ID", "Name", "SuperID", 0, staff.OrganizeCity);
Org_Position p = new Org_PositionBLL(staff.Position).Model;
if (p != null)
ret += "<br/>职位：" + p.Name;
return ret;
}
protected void bt_Refresh_Click(object sender, EventArgs e)
{
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
}
else
{
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 == 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("OrganizeCitys", orgcitys),
new ReportParameter("Month", ddl_Month.SelectedValue),
new ReportParameter("Staff", staff.ToString())
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
else
{
ReportParameter[] _parms =
{
new ReportParameter("OrganizeCitys", orgcitys),
new ReportParameter("Month", ddl_Month.SelectedValue)
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
Org_PositionBLL _bll;
if (lbl_ID.Text == "")
{
_bll = new Org_PositionBLL();
}
else
{
_bll = new Org_PositionBLL(int.Parse(lbl_ID.Text));
}
_bll.Model.Name = tbx_Name.Text;
_bll.Model.SuperID = int.Parse(tr_SuperPosition.SelectValue);
_bll.Model.IsHeadOffice = cbx_IsHeadOffice.Checked ? "Y" : "N";
_bll.Model.Department = int.Parse(ddl_Department.SelectedValue);
_bll.Model.Enabled = cbx_Enable.Checked ? "Y" : "N";
_bll.Model.Remark = tbx_Remark.Text;
if (lbl_ID.Text == "")
{
if (_bll.Add() < 0)
{
lbl_AlertInfo.Text = "添加职务失败，职务名称已存在";
return;
}
}
else
{
int ret = _bll.Update();
switch (ret)
{
case -1:
lbl_AlertInfo.Text = "更新职务失败，职务名称已存在";
return;
case -2:
lbl_AlertInfo.Text = "更新职务失败，不能将当前职务设置为上级职务";
return;
case -3:
lbl_AlertInfo.Text = "更新职务失败，不能将当前职务的子职务设置为上级职务";
return;
}
}
Response.Redirect("PositionManage.aspx");
}
protected string DisplayFullInfo(string loginname)
{
string ret = "";
Org_Staff staff = UserBLL.GetStaffByUsername(loginname);
ret = "登录名称：<a href=\"javascript:SendMsg('" + loginname + "','" + Server.UrlPathEncode(staff.RealName) + "');\" title='发送短内短信' style='color:red' target='_self'>" + loginname + "</a>";
ret += "<br/>真实姓名：" + staff.RealName + "<br/>所属区域：" + TreeTableBLL.GetFullPathName("MCS_SYS.dbo.Addr_OrganizeCity", "ID", "Name", "SuperID", 0, staff.OrganizeCity);
Org_Position p = new Org_PositionBLL(staff.Position).Model;
if (p != null)
{
ret += "<br/>职位：" + p.Name;
}
return(ret);
}
/// <summary>
/// 取消已生成的导购人员导购工资
/// 是（值为1）：取消工资；否（值为2）：未取消工资
/// </summary>
/// <param name="SalaryDetailID">工资明细ID</param>
/// <param name="DeleteStaff">取消人ID</param>
/// <returns></returns>
public static int CancelSalaryDetail(int SalaryDetailID, int DeleteStaff)
{
PM_SalaryDAL dal = (PM_SalaryDAL)DataAccess.CreateObject(DALClassName);
PM_SalaryDetail detail = dal.GetDetailModel(SalaryDetailID);
detail["FlagCancel"] = "1";
Org_Staff staff = new Org_StaffBLL(DeleteStaff).Model;
detail["DeleteStaff"] = staff.RealName;
detail["DeleteTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
detail["DeletePosition"] = new Org_PositionBLL(staff.Position).Model.Name;
dal.HeadID = detail.SalaryID;
string a = detail.SalaryID + "|" + detail["FlagCancel"] + "|" + detail["DeleteTime"] + "|" + detail["DeleteStaff"] + "|" + detail["DeletePosition"];
return(dal.UpdateDetail(detail));
}
protected void btn_Save_Click(object sender, EventArgs e)
{
Org_PositionBLL _bll;
if (lbl_ID.Text == "")
{
_bll = new Org_PositionBLL();
}
else
{
_bll = new Org_PositionBLL(int.Parse(lbl_ID.Text));
}
_bll.Model.Name = tbx_Name.Text;
_bll.Model.SuperID = int.Parse(tr_SuperPosition.SelectValue);
_bll.Model.IsHeadOffice = cbx_IsHeadOffice.Checked ? "Y" : "N";
_bll.Model.Department = int.Parse(ddl_Department.SelectedValue);
_bll.Model.Enabled = cbx_Enable.Checked ? "Y" : "N";
_bll.Model.Remark = tbx_Remark.Text;
if (lbl_ID.Text == "")
{
if (_bll.Add() < 0)
{
lbl_AlertInfo.Text = "添加职务失败，职务名称已存在";
return;
}
}
else
{
int ret = _bll.Update();
switch (ret)
{
case -1:
lbl_AlertInfo.Text = "更新职务失败，职务名称已存在";
return;
case -2:
lbl_AlertInfo.Text = "更新职务失败，不能将当前职务设置为上级职务";
return;
case -3:
lbl_AlertInfo.Text = "更新职务失败，不能将当前职务的子职务设置为上级职务";
return;
}
}
Response.Redirect("PositionManage.aspx");
}
private void BindPublic()
{
lbRemainStaff.Items.Clear();
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
tr_Position.SelectValue = "1";
BBS_BoardUserMemberBLL userMemberbll = new BBS_BoardUserMemberBLL((int)ViewState["BoardID"]);
if (userMemberbll != null && userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"]).Count > 0)
{
lbBoardMasterList.Items.Clear();
foreach (BBS_BoardUserMember user in userMemberbll._GetModelList(" Board=" + (int)ViewState["BoardID"] + " and Role = 1"))
{
lbBoardMasterList.Items.Add(new ListItem(user.UserName + "[" + UserBLL.GetStaffByUsername(user.UserName).RealName + "]", user.UserName));
}
}
}
protected void bt_Refresh_Click(object sender, EventArgs e)
{
string orgcitys = "";
if (tr_OrganizeCity.SelectValue != "0")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
}
else
{
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 == 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("OrganizeCitys", orgcitys),
new ReportParameter("Month", ddl_Month.SelectedValue),
new ReportParameter("Staff",staff.ToString())
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
else
{
ReportParameter[] _parms = {
new ReportParameter("OrganizeCitys", orgcitys),
new ReportParameter("Month", ddl_Month.SelectedValue)
};
ReportViewer1.ServerReport.SetParameters(_parms);
}
}
protected void bt_CreateUser_Click(object sender, EventArgs e)
{
string UserName = "", Password = "", PositionName = "";
Org_StaffBLL staff = new Org_StaffBLL((int)ViewState["ID"]);
if (staff.Model == null) return;
if (staff.Model.aspnetUserId != null && staff.Model.aspnetUserId != Guid.Empty) return;
PositionName = new Org_PositionBLL(staff.Model.Position).Model.Name;
CM_ClientBLL tdp = new CM_ClientBLL((int)Session["OwnerClient"]);
CM_ClientManufactInfo manufactinfo = tdp.GetManufactInfo(tdp.Model.OwnerClient);
if (tdp.Model == null) return;
//用户名默认为当前:TDP代码-员工姓名
if (manufactinfo != null && !string.IsNullOrEmpty(manufactinfo.Code))
UserName = manufactinfo.Code;
else if (!string.IsNullOrEmpty(tdp.Model.Code))
UserName = tdp.Model.Code;
else
UserName = tdp.Model.ID.ToString();
UserName += "-" + staff.Model.RealName;
if (Membership.GetUser(UserName) != null) UserName += staff.Model.ID.ToString();
//密码默认为员工手机号码，为空时则为123456
Password = staff.Model.Mobile.Trim();
if (Password == "") Password = "******";
//创建用户，并加入角色
MembershipUser u = Membership.CreateUser(UserName, Password);
foreach (string rolename in Roles.GetAllRoles().Where(p => p.StartsWith("TDP")))
{
if (rolename == PositionName)
{
Roles.AddUserToRole(u.UserName, rolename);
}
}
UserBLL.Membership_SetStaffID(u.UserName, staff.Model.ID);
staff.Model.aspnetUserId = (Guid)u.ProviderUserKey;
staff.Update();
MessageBox.ShowAndRedirect(this, "用户创建成功！【用户名：" + UserName + ",初始密码:" + Password + "】", "StaffList.aspx");
}
protected void select_Staff_SelectChange(object sender, SelectChangeEventArgs e)
{
if (select_Staff.SelectValue != "")
{
Org_StaffBLL staff = new Org_StaffBLL(int.Parse(select_Staff.SelectValue), true);
select_Staff.SelectText = staff.Model.RealName;
select_Staff.SelectValue = staff.Model.ID.ToString();
Org_PositionBLL position = new Org_PositionBLL(staff.Model.Position);
lbl_Position.Text = position.Model.Name;
MCSTreeControl tr_OfficialCity = (MCSTreeControl)pl_detail.FindControl("JN_Journal_OfficialCity");
tr_OfficialCity.SelectValue = staff.Model.OfficialCity.ToString();
}
else
{
MessageBox.Show(this, "请正确选择日志填报人!");
return;
}
}
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 = p.SuperID.ToString();
tr_Position.SelectValue = staff.Model.Position.ToString();
}
else
{
tr_Position.RootValue = "1";
}
tr_Position.SelectValue = tr_Position.RootValue;
#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_JournalType.DataSource = DictionaryBLL.GetDicCollections("OA_JournalType");
ddl_JournalType.DataBind();
ddl_JournalType.Items.Insert(0, new ListItem("请选择...", "0"));
#region 绑定职位
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
#region 如果非总部职位，其只能选择自己职位及以下职位
if (Right_Assign_BLL.GetAccessRight(Session["UserName"].ToString(), 22, "ViewAllStaffJN"))
{
//有【查看所有员工工作日志】权限
tr_Position.RootValue = "0";
tr_Position.SelectValue = "0";
}
else
{
tr_Position.RootValue = staff.Model.Position.ToString();
tr_Position.SelectValue = staff.Model.Position.ToString();
}
#endregion
#endregion
}
private void BindStaffList()
{
listAccount.Items.Clear();
if (ddl_Position.SelectedValue != "0" || (ddl_Position.SelectedValue == "0" && tbx_Name.Text.Trim() != ""))
{
string positions = "";
if (ddl_Position.SelectedValue == "0")
{
Org_PositionBLL pos = new Org_PositionBLL(1);
positions = pos.GetAllChildPosition() + ",1";
}
else
{
if (cb_IncludeChild.Checked)
{
Org_PositionBLL pos = new Org_PositionBLL(int.Parse(ddl_Position.SelectedValue));
positions = pos.GetAllChildPosition();
if (positions != "")
{
positions += ",";
}
positions += ddl_Position.SelectedValue;
}
else
{
positions = ddl_Position.SelectedValue;
}
}
DataTable dt = Org_StaffBLL.GetRealNameAndUserNameByPosition(positions);
dt.DefaultView.RowFilter = " RealName like '%" + tbx_Name.Text + "%' ";
for (int i = 0; i < dt.DefaultView.Count; i++)
{
listAccount.Items.Add(new ListItem((string)dt.DefaultView[i]["RealName"], (string)dt.DefaultView[i]["UserName"]));
}
}
}
public void BindGrid()
{
string condition = " 1 = 1 ";
#region 判断当前可查询的范围
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "")
{
orgcitys += ",";
}
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "")
{
condition += " AND OrganizeCity IN (" + orgcitys + ")";
}
}
if (tr_Position.SelectValue != "1")
{
Org_PositionBLL org_position = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
string positions = org_position.GetAllChildPosition();
if (positions != "")
{
positions += ",";
}
positions += tr_Position.SelectValue;
if (positions != "")
{
condition += " AND Position IN (" + positions + ")";
}
}
#endregion
gv_List.BindGrid(Org_StaffNumberLimitBLL.GetModelList(condition));
}
private void BindDropDown()
{
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
#region 绑定职位
tr_ToPosition.DataSource = Org_PositionBLL.GetAllPostion();
#region 如果非总部职位，其只能选择自己职位及以下职位
Org_Position p = new Org_PositionBLL(staff.Model.Position).Model;
if (p != null && p.IsHeadOffice != "Y")
{
tr_ToPosition.RootValue = p.SuperID.ToString();
tr_ToPosition.SelectValue = staff.Model.Position.ToString();
}
else
{
tr_ToPosition.RootValue = "0";
tr_ToPosition.SelectValue = "1";
}
#endregion
tr_ToOrganizeCity.DataBind();
#endregion
#region 绑定管理片区
tr_ToOrganizeCity.DataSource = staff.GetStaffOrganizeCity();
if (tr_ToOrganizeCity.DataSource.Select("ID = 1").Length > 0)
{
tr_ToOrganizeCity.RootValue = "0";
tr_ToOrganizeCity.SelectValue = "1";
}
else
{
tr_ToOrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString();
tr_ToOrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString();
}
#endregion
}
private void BindData(int ID)
{
Org_PositionBLL _bll = new Org_PositionBLL(ID);
lbl_ID.Text = _bll.Model.ID.ToString();
tbx_Name.Text = _bll.Model.Name;
tr_SuperPosition.SelectValue = _bll.Model.SuperID.ToString();
cbx_IsHeadOffice.Checked = _bll.Model.IsHeadOffice == "Y";
if (_bll.Model.Department != null)
{
ddl_Department.SelectedValue = _bll.Model.Department.ToString();
}
cbx_Enable.Checked = _bll.Model.Enabled == "Y";
tbx_Remark.Text = _bll.Model.Remark;
btn_AddSubPosition.Visible = true;
btn_Delete.Visible = true;
MessageBox.ShowConfirm(btn_Delete, "数据删除将不可恢复，确定删除么?");
btn_Cancel.Visible = true;
lbl_AlertInfo.Text = "";
}
protected void bt_Insert1_Click(object sender, EventArgs e)
{
string positionID = tr_ToPosition.SelectValue;
if (positionID != null && positionID != "" && positionID != "1")
{
Org_PositionBLL _positionbll = new Org_PositionBLL(int.Parse(positionID));
lb_PositionChild.Items.Add(new ListItem(_positionbll.Model.Name, positionID.ToString()));
if (this.chb_ToPositionChild.Checked)
{
string[] childList = StringSplit(_positionbll.GetAllChildPosition());
foreach (string child in childList)
{
if (lb_PositionChild.Items.FindByValue(child) == null)
{
_positionbll = new Org_PositionBLL(int.Parse(child));
lb_PositionChild.Items.Add(new ListItem(_positionbll.Model.Name, child));
}
}
}
}
}
private void BindDropDown()
{
ddl_Position.DataSource = Org_PositionBLL.GetAllPostion();
ddl_Position.DataBind();
if (Request.QueryString["StaffID"] != null)
{
int staffid = int.Parse(Request.QueryString["StaffID"]);
Org_Staff staff = new Org_StaffBLL(staffid).Model;
if (staff != null)
{
ddl_Position.SelectValue = staff.Position.ToString();
ddl_Staff.DataSource = Org_StaffBLL.GetStaffList("Position=" + staff.Position.ToString());
ddl_Staff.DataBind();
ddl_Staff.SelectedValue = staff.ID.ToString();
}
}
else
{
ddl_Staff.DataSource = Org_StaffBLL.GetStaffList("Position=" + ddl_Position.SelectValue);
ddl_Staff.DataBind();
}
}
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();
}
#region 绑定职位
tr_Position.DataSource = Org_PositionBLL.GetAllPostion();
tr_Position.DataBind();
#region 如果非总部职位，其只能选择自己职位及以下职位
if (Right_Assign_BLL.GetAccessRight(Session["UserName"].ToString(), 22, "ViewAllStaffPlan"))
{
//有【查看所有员工工作计划】权限
tr_Position.RootValue = "0";
tr_Position.SelectValue = "0";
}
else
{
tr_Position.RootValue = staff.Model.Position.ToString();
tr_Position.SelectValue = staff.Model.Position.ToString();
}
#endregion
#endregion
}
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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ViewState["ID"] = Request.QueryString["ID"] == null ? 0 : int.Parse(Request.QueryString["ID"]);
#region 如果非总部职位，其只能选择自己职位及以下职位
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
Org_Position p = new Org_PositionBLL(staff.Model.Position).Model;
MCSTreeControl tr_Position = (MCSTreeControl)panel1.FindControl("Org_Staff_Position");
if (p != null && p.IsHeadOffice != "Y" && p.Remark != "OfficeHR") //备注为"OfficeHR":人事经理,可以选择全部职位
{
tr_Position.RootValue = p.SuperID.ToString();
tr_Position.SelectValue = staff.Model.Position.ToString();
}
else if (tr_Position!=null)
{
tr_Position.RootValue = "1";
tr_Position.SelectValue = "1";
}
#endregion
DropDownList ddl_Dimission = (DropDownList)panel1.FindControl("Org_Staff_Dimission");
if (ddl_Dimission != null) ddl_Dimission.Enabled = false;
TextBox tbx_EndWorkTime = (TextBox)panel1.FindControl("Org_Staff_EndWorkTime");
if (tbx_EndWorkTime != null) tbx_EndWorkTime.Enabled = false;
if ((int)ViewState["ID"] > 0)
{
BindData();
}
else
{
tr_LoginUser.Visible = false;
tr_StaffInOrganizeCity.Visible = false;
UploadFile1.Visible = false;
bt_AddApply.Visible = false;
bt_RevocationApply.Visible = false;
bt_Approve.Visible = false;
bt_Print.Visible = false;
if (ddl_Dimission != null) ddl_Dimission.SelectedValue = "1";
RadioButtonList rbl_ApproveFlag = (RadioButtonList)panel1.FindControl("Org_Staff_ApproveFlag");
if (rbl_ApproveFlag != null) rbl_ApproveFlag.SelectedValue = "2";
DropDownList ddl_SalaryFlag = (DropDownList)panel1.FindControl("Org_Staff_SalaryFlag");
if (ddl_SalaryFlag != null) ddl_SalaryFlag.SelectedValue = "1";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region 界面自定底控件事件
rab_ToAllStaff = (RadioButtonList)UC_Notice.FindControl("PN_Notice_ToAllStaff");
if (rab_ToAllStaff != null)
{
rab_ToAllStaff.AutoPostBack = true;
rab_ToAllStaff.SelectedIndexChanged += new EventHandler(rab_ToAllStaff_SelectedIndexChanged);
}
rab_ToAllOrganizeCity = (RadioButtonList)UC_Notice.FindControl("PN_Notice_ToAllOrganizeCity");
if (rab_ToAllOrganizeCity != null)
{
rab_ToAllOrganizeCity.AutoPostBack = true;
rab_ToAllOrganizeCity.SelectedIndexChanged += new EventHandler(rab_ToAllOrganizeCity_SelectedIndexChanged);
}
#endregion
if (!Page.IsPostBack)
{
ViewState["ID"] = Request.QueryString["ID"] == null ? 0 : int.Parse(Request.QueryString["ID"]);
ViewState["Catalog"] = Request.QueryString["Catalog"] == null ? 1 : int.Parse(Request.QueryString["Catalog"]);
BindDropDown();
if ((int)ViewState["ID"] > 0)
{
#region 页面设置
bt_OK.Text = "修改保存";
bt_OK.ForeColor = System.Drawing.Color.Red;
#endregion
BindData();
}
else
{
#region 页面设置
bt_PreView.Visible = false;
UploadFile1.Visible = false;
tab_PNToPosition.Visible = false;
tab_PNToOrganizeCity.Visible = false;
bt_Approve.Visible = false;
ckedit_content.Text = "";
DropDownList ddl_IsSpecial = (DropDownList)UC_Notice.FindControl("PN_Notice_IsSpecial");
if (ddl_IsSpecial != null) ddl_IsSpecial.SelectedValue = "2";
DropDownList ddl_IsTop = (DropDownList)UC_Notice.FindControl("PN_Notice_IsTop");
if (ddl_IsTop != null) ddl_IsTop.SelectedValue = "N";
DropDownList ddl_Catalog = (DropDownList)UC_Notice.FindControl("PN_Notice_Catalog");
if (ddl_Catalog != null && (int)ViewState["Catalog"]>0)
{
ddl_Catalog.SelectedValue = ViewState["Catalog"].ToString();
ddl_Catalog.Enabled = false;
}
#endregion
}
#region 判断是否非总部职位，非总部职位不能面向全体发公告
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
Org_Position p = new Org_PositionBLL(staff.Model.Position).Model;
if (p != null && p.IsHeadOffice != "Y")
{
rab_ToAllStaff.SelectedValue = "N";
rab_ToAllStaff.Enabled = false;
rab_ToAllStaff_SelectedIndexChanged(null, null);
rab_ToAllOrganizeCity.SelectedValue = "N";
rab_ToAllOrganizeCity.Enabled = false;
rab_ToAllOrganizeCity_SelectedIndexChanged(null, null);
}
#endregion
}
}
private void BindGrid()
{
string ConditionStr = "JN_WorkingPlan.BeginDate Between '" + tbx_begindate.Text + "' AND '" + tbx_enddate.Text + " 23:59' ";
switch (MCSTabControl1.SelectedTabItem.Value)
{
case "0":
ConditionStr += " AND JN_WorkingPlan.Staff=" + Session["UserID"].ToString();
gv_List.OrderFields = "JN_WorkingPlan_ID";
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
break;
case "1":
if (tbx_StaffName.Text != "") ConditionStr += "AND Org_Staff.RealName LIKE '%" + tbx_StaffName.Text + "%'";
#region 只显示当前员工的所有下级职位的员工计划
if (tr_Position.SelectValue != "0")
{
if (cb_IncludeChild.Checked || tr_Position.SelectValue == tr_Position.RootValue)
{
Org_PositionBLL p = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
string positions = p.GetAllChildPosition();
if (tr_Position.SelectValue != tr_Position.RootValue)
{
if (positions != "") positions += ",";
positions += tr_Position.SelectValue;
}
ConditionStr += " AND Org_Staff.Position IN (" + positions + ")";
}
else
ConditionStr += " AND Org_Staff.Position = " + tr_Position.SelectValue;
}
#endregion
#region 判断当前可查询的管理片区范围
if (tr_OrganizeCity.SelectValue != "1")
{
string orgcitys = "";
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") ConditionStr += " AND JN_WorkingPlan.OrganizeCity IN (" + orgcitys + ") ";
}
#endregion
gv_List.OrderFields = "JN_WorkingPlan_ID";
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
break;
case "2":
DateTime dt_begin = DateTime.Parse(tbx_begindate.Text);
DateTime dt_end = DateTime.Parse(tbx_enddate.Text);
DataTable dtSummary = JN_WorkingPlanBLL.GetSummary(dt_begin, dt_end, int.Parse(tr_OrganizeCity.SelectValue), int.Parse(tr_Position.SelectValue), tbx_StaffName.Text.Trim(), cb_IncludeChild.Checked ? 1 : 0);
if (dtSummary.Rows.Count == 0)
{
gv_planList.DataBind();
return;
}
dtSummary = MatrixTable.Matrix(dtSummary, new string[] { "营业部", "办事处", "Staff", "员工姓名", "工号", "职位", "出差天数", "负责客户数", "拜访客户数→计划", "拜访客户数→实际", "差旅费→计划", "差旅费→实际差旅费", "差旅费→实际用车费" },
new string[] { "WorkingClassify" }, "WorkCounts", true, false);
dtSummary.Rows[dtSummary.Rows.Count - 1]["出差天数"] = dtSummary.Compute("SUM(出差天数)", "true");
dtSummary.Rows[dtSummary.Rows.Count - 1]["负责客户数"] = dtSummary.Compute("SUM(负责客户数)", "true");
dtSummary.Rows[dtSummary.Rows.Count - 1]["拜访客户数→计划"] = dtSummary.Compute("SUM(拜访客户数→计划)", "true");
dtSummary.Rows[dtSummary.Rows.Count - 1]["拜访客户数→实际"] = dtSummary.Compute("SUM(拜访客户数→实际)", "true");
dtSummary.Rows[dtSummary.Rows.Count - 1]["差旅费→计划"] = dtSummary.Compute("SUM(差旅费→计划)", "true");
dtSummary.Rows[dtSummary.Rows.Count - 1]["差旅费→实际差旅费"] = dtSummary.Compute("SUM(差旅费→实际差旅费)", "true");
dtSummary.Rows[dtSummary.Rows.Count - 1]["差旅费→实际用车费"] = dtSummary.Compute("SUM(差旅费→实际用车费)", "true");
gv_planList.DataSource = dtSummary;
gv_planList.DataBind();
MatrixTable.GridViewMatric(gv_planList);
gv_planList.Rows[gv_planList.Rows.Count - 1].Cells[0].Text = "";
break;
}
}
private void BindData()
{
PN_NoticeBLL bll = new PN_NoticeBLL((int)ViewState["ID"]);
UC_Notice.BindData(bll.Model);
if (bll.Model["Catalog"] != "") ViewState["Catalog"] = int.Parse(bll.Model["Catalog"]);
if (bll.Model.ApproveFlag == 1)
{
bt_Approve.Visible = false;
bt_OK.Visible = false;
bt_Clear1.Visible = false;
bt_Detele1.Visible = false;
bt_Insert1.Visible = false;
bt_Clear2.Visible = false;
bt_Detele2.Visible = false;
bt_Insert2.Visible = false;
bt_PreView.Visible = false;
UploadFile1.CanDelete = false;
UploadFile1.CanUpload = false;
}
tab_PNToPosition.Visible = bll.Model.ToAllStaff == "N";
tab_PNToOrganizeCity.Visible = bll.Model.ToAllOrganizeCity == "N";
UploadFile1.RelateID = (int)ViewState["ID"];
UploadFile1.BindGrid();
#region 显示所属职位，片区
if (tab_PNToPosition.Visible)
{
List<int> List = new List<int>();
List = PN_ToPositionBLL.GetPositionByNoticeID((int)ViewState["ID"]);
lb_PositionChild.Items.Clear();
if (List != null)
{
foreach (int id in List)
{
Org_PositionBLL positionbll = new Org_PositionBLL(id);
lb_PositionChild.Items.Add(new ListItem(positionbll.Model.Name, id.ToString()));
}
}
}
if (tab_PNToOrganizeCity.Visible)
{
List<int> List = new List<int>();
List = PN_ToOrganizeCityBLL.GetOrganizeCityByNoticeID((int)ViewState["ID"]);
lb_CityChild.Items.Clear();
if (List != null)
{
foreach (int id in List)
{
Addr_OrganizeCityBLL organizeCitybll = new Addr_OrganizeCityBLL(id);
lb_CityChild.Items.Add(new ListItem(organizeCitybll.Model.Name, id.ToString()));
}
}
}
#endregion
ckedit_content.Text = bll.Model.Content;
}
protected void bt_Insert1_Click(object sender, EventArgs e)
{
string positionID = tr_ToPosition.SelectValue;
if (positionID != null && positionID != "" && positionID != "1")
{
Org_PositionBLL _positionbll = new Org_PositionBLL(int.Parse(positionID));
lb_PositionChild.Items.Add(new ListItem(_positionbll.Model.Name, positionID.ToString()));
if (this.chb_ToPositionChild.Checked)
{
string[] childList = StringSplit(_positionbll.GetAllChildPosition());
foreach (string child in childList)
{
if (lb_PositionChild.Items.FindByValue(child) == null)
{
_positionbll = new Org_PositionBLL(int.Parse(child));
lb_PositionChild.Items.Add(new ListItem(_positionbll.Model.Name, child));
}
}
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
#region 界面自定底控件事件
rab_ToAllStaff = (RadioButtonList)pl_detail.FindControl("QNA_Project_ToAllStaff");
if (rab_ToAllStaff != null)
{
rab_ToAllStaff.AutoPostBack = true;
rab_ToAllStaff.SelectedIndexChanged += new EventHandler(rab_ToAllStaff_SelectedIndexChanged);
}
rab_ToAllOrganizeCity = (RadioButtonList)pl_detail.FindControl("QNA_Project_ToAllOrganizeCity");
if (rab_ToAllOrganizeCity != null)
{
rab_ToAllOrganizeCity.AutoPostBack = true;
rab_ToAllOrganizeCity.SelectedIndexChanged += new EventHandler(rab_ToAllOrganizeCity_SelectedIndexChanged);
}
ddl_FaceTo = (DropDownList)pl_detail.FindControl("QNA_Project_FaceTo");
if (ddl_FaceTo != null)
{
ddl_FaceTo.AutoPostBack = true;
ddl_FaceTo.SelectedIndexChanged +=new EventHandler(ddl_FaceTo_SelectedIndexChanged);
}
#endregion
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
#region 获取页面参数
ViewState["ID"] = Request.QueryString["ID"] != null ? int.Parse(Request.QueryString["ID"]) : 0;
#endregion
BindDropDown();
if ((int)ViewState["ID"] != 0)
{
//修改
BindData();
}
else
{
//新增
tr_QuestionList.Visible = false;
bt_Enabled.Visible = false;
bt_Disabled.Visible = false;
bt_ViewStatistics.Visible = false;
tab_QNAToPosition.Visible = false;
tab_QNAToOrganizeCity.Visible = false;
}
#region 判断是否非总部职位，不是总部职位没有权限进行设置
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
Org_Position p = new Org_PositionBLL(staff.Model.Position).Model;
if (p != null && p.IsHeadOffice != "Y")
{
rab_ToAllStaff.SelectedValue = "N";
rab_ToAllStaff.Enabled = false;
rab_ToAllStaff_SelectedIndexChanged(null, null);
rab_ToAllOrganizeCity.SelectedValue = "N";
rab_ToAllOrganizeCity.Enabled = false;
rab_ToAllOrganizeCity_SelectedIndexChanged(null, null);
}
#endregion
}
}
private void BindGrid()
{
DateTime dt_begin = DateTime.Parse(tbx_begindate.Text);
DateTime dt_end = DateTime.Parse(tbx_enddate.Text);
string ConditionStr = "JN_Journal.BeginTime <= '" + dt_end.ToString("yyyy-MM-dd") + "' And JN_Journal.EndTime >='" + dt_begin.ToString("yyyy-MM-dd") + "'";
if (ddl_JournalType.SelectedValue != "0")
{
ConditionStr += " AND JN_Journal.JournalType=" + ddl_JournalType.SelectedValue;
}
if (MCSTabControl1.SelectedTabItem.Value == "0")
{
ConditionStr += " AND JN_Journal.Staff=" + Session["UserID"].ToString();
}
else
{
if (tbx_StaffName.Text != "") ConditionStr += "AND Org_Staff.RealName LIKE '%" + tbx_StaffName.Text + "%'";
#region 只显示当前员工的所有下级职位的员工计划
if (tr_Position.SelectValue != "0")
{
if (cb_IncludeChild.Checked || tr_Position.SelectValue == tr_Position.RootValue)
{
Org_PositionBLL p = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
string positions = p.GetAllChildPosition();
if (tr_Position.SelectValue != tr_Position.RootValue)
{
if (positions != "") positions += ",";
positions += tr_Position.SelectValue;
}
ConditionStr += " AND Org_Staff.Position IN (" + positions + ")";
}
else
ConditionStr += " AND Org_Staff.Position = " + tr_Position.SelectValue;
}
#endregion
#region 判断当前可查询的管理片区范围
if (tr_OrganizeCity.SelectValue != "1")
{
string orgcitys = "";
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue), true);
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") ConditionStr += " AND JN_Journal.OrganizeCity IN (" + orgcitys + ") ";
}
#endregion
}
gv_List.OrderFields = "JN_Journal_BeginTime";
gv_List.ConditionString = ConditionStr;
gv_List.BindGrid();
}
protected void select_Staff_SelectChange(object sender, SelectChangeEventArgs e)
{
if (select_Staff.SelectValue != "")
{
Org_StaffBLL staff = new Org_StaffBLL(int.Parse(select_Staff.SelectValue), true);
select_Staff.SelectText = staff.Model.RealName;
select_Staff.SelectValue = staff.Model.ID.ToString();
Org_PositionBLL position = new Org_PositionBLL(staff.Model.Position);
lbl_Position.Text = position.Model.Name;
MCSTreeControl tr_OfficialCity = (MCSTreeControl)pl_detail.FindControl("JN_Journal_OfficialCity");
tr_OfficialCity.SelectValue = staff.Model.OfficialCity.ToString();
}
else
{
MessageBox.Show(this, "请正确选择日志填报人!");
return;
}
}
private void BindData()
{
JN_Journal m = new JN_JournalBLL((int)ViewState["ID"]).Model;
Org_StaffBLL staff = new Org_StaffBLL(m.Staff, true);
select_Staff.SelectValue = m.Staff.ToString();
select_Staff.SelectText = staff.Model.RealName;
select_Staff.Enabled = false;
Org_PositionBLL position = new Org_PositionBLL(staff.Model.Position);
lbl_Position.Text = position.Model.Name;
ddl_JournalType.SelectedValue = m.JournalType.ToString();
ddl_JournalType_SelectedIndexChanged(null, null);
ddl_JournalType.Enabled = false;
tbx_begindate.Text = m.BeginTime.ToString("yyyy-MM-dd");
tbx_enddate.Text = m.EndTime.ToString("yyyy-MM-dd");
try
{
ddl_BeginHour.SelectedValue = m.BeginTime.Hour.ToString("d2");
ddl_BeginMinute.SelectedValue = m.BeginTime.Minute.ToString("d2");
ddl_EndHour.SelectedValue = m.EndTime.Hour.ToString("d2");
ddl_EndMinute.SelectedValue = m.EndTime.Minute.ToString("d2");
}
catch { }
ddl_WorkingClassify.SelectedValue = m.WorkingClassify.ToString();
ddl_WorkingClassify_SelectedIndexChanged(null, null);
ddl_WorkingClassify.Enabled = false;
pl_detail.BindData(m);
rbl_HasSynergeticStaff_SelectedIndexChanged(null, null);
select_RelateClient_SelectChange(null, null);
if (ddl_RelateLinkMan.Items.FindByValue(m.RelateLinkMan.ToString()) != null)
ddl_RelateLinkMan.SelectedValue = m.RelateLinkMan.ToString();
if (m.WorkingClassify == 1 && m.RelateLinkMan > 0)
{
//客户拜访
bt_AddNewClient.OnClientClick = "javascript:OpenClientInput(" + m.ID.ToString() + "," + m.RelateLinkMan + ",0)";
bt_AddNewClient.Enabled = true;
}
else if (m.WorkingClassify == 3 && !string.IsNullOrEmpty(m["RelateActivity"]))
{
//活动举办
bt_AddNewClient.OnClientClick = "javascript:OpenClientInput(" + m.ID.ToString() + ",0," + m["RelateActivity"] + ")";
bt_AddNewClient.Enabled = true;
}
else
{
bt_AddNewClient.Enabled = false;
}
#region 显示日志填报时的IP地址
TextBox tbx_IPAddress = (TextBox)pl_detail.FindControl("JN_Journal_IPAddress");
if (m["IPAddress"] != "" && m["IPLocation"] == "")
{
TextBox tbx_IPLocation = (TextBox)pl_detail.FindControl("JN_Journal_IPLocation");
userAddress = Const_IPLocationBLL.FindByIP(Request.UserHostAddress);
if (tbx_IPLocation != null) tbx_IPLocation.Text = userAddress != null ? userAddress.Location : "";
}
#endregion
Label lbl_InsertStaff = (Label)pl_detail.FindControl("JN_Journal_InsertStaff");
if (lbl_InsertStaff != null)
{
Org_StaffBLL _staff = new Org_StaffBLL(m.InsertStaff, true);
Org_PositionBLL _position = new Org_PositionBLL(_staff.Model.Position);
lbl_InsertStaff.Text = lbl_InsertStaff.Text + "(职位:" + _position.Model.Name + ")";
}
if (m.InsertStaff != (int)Session["UserID"] || m.ApproveFlag == 1 || (DateTime.Today - m.InsertTime.Date).Days > 7)
{
ddl_JournalType.Enabled = false;
tbx_begindate.Enabled = false;
ddl_WorkingClassify.Enabled = false;
ddl_BeginHour.Enabled = false;
ddl_BeginMinute.Enabled = false;
ddl_EndHour.Enabled = false;
ddl_EndMinute.Enabled = false;
pl_detail.SetControlsEnable(false);
TextBox tbx_remark = pl_detail.FindControl("JN_Journal_Remark") != null ?
(TextBox)pl_detail.FindControl("JN_Journal_Remark") : null;
if (tbx_remark != null)
{
tbx_remark.Enabled = true;
tbx_remark.ReadOnly = true;
}
UploadFile1.CanDelete = false;
UploadFile1.CanUpload = false;
bt_OK.Visible = false;
bt_Delete.Visible = false;
}
if ((DateTime.Today - m.InsertTime.Date).Days > 0) bt_Delete.Visible = false; //只能删除当日填写的日志
#region 展示附件
UploadFile1.RelateID = (int)ViewState["ID"];
UploadFile1.RelateType = 90;
UploadFile1.BindGrid();
#endregion
int commentcounts = JN_JournalCommentBLL.GetModelList("JournalID=" + ViewState["ID"].ToString()).Count;
lb_CommentCounts.Text = commentcounts.ToString();
if (commentcounts > 0)
{
table_comment.Visible = true;
BindGridList();
btn_LookComment.Visible = false;
}
}
private void BindGrid()
{
string condition = " Dimission=1 AND ApproveFlag=1 "; //仅仅查询在职的
if (tbx_Condition.Text != string.Empty)
{
condition += " AND " + ddl_SearchType.SelectedValue + " Like '%" + this.tbx_Condition.Text.Trim() + "%'";
}
if (tr_Position.SelectValue != "0")
{
if (cb_IncludeChild.Checked || tr_Position.SelectValue == tr_Position.RootValue)
{
string positions = "";
Org_PositionBLL pos = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
positions = pos.GetAllChildPosition();
if (tr_Position.SelectValue != tr_Position.RootValue)
{
if (positions != "") positions += ",";
positions += tr_Position.SelectValue;
}
condition += " AND Org_Staff.Position IN (" + positions + ")";
}
else
condition += " AND Org_Staff.Position = " + tr_Position.SelectValue;
}
#region 判断当前可查询的范围
if (tr_OrganizeCity.SelectValue != "0" && tr_OrganizeCity.SelectValue != "1")
{
string orgcitys = "";
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
condition += " AND (Org_Staff.OrganizeCity IN (" + orgcitys +
") OR Org_Staff.ID IN (SELECT Staff FROM MCS_SYS.dbo.Org_Staff_StaffInOrganizeCity WHERE OrganizeCity IN (" + orgcitys + ")) )";
}
#endregion
if (Request.QueryString["ExtCondition"] != null)
{
condition += " AND (" + Request.QueryString["ExtCondition"] + ")";
}
#region 将指定区域的上级经理加入人员选择窗口中
if (Request.QueryString["IncludeSuperManager"] != null && Request.QueryString["OrganizeCity"] != null)
{
int supercitymanager = 0;
Addr_OrganizeCity city1 = new Addr_OrganizeCityBLL(int.Parse(Request.QueryString["OrganizeCity"])).Model;
if (city1 != null)
{
Addr_OrganizeCity city2 = new Addr_OrganizeCityBLL(city1.SuperID).Model;
if (city2 != null) supercitymanager = city2.Manager;
}
if (supercitymanager != 0)
{
condition += " OR Org_Staff.ID=" + supercitymanager.ToString();
}
}
#endregion
gv_List.ConditionString = condition;
gv_List.BindGrid();
}
private void BindGrid()
{
string condition = " Org_Staff.Dimission=" + ViewState["Dimission"].ToString();
#region 根据职位的范围查询
if (tr_Position.SelectValue != tr_Position.RootValue && tr_Position.SelectValue != "0")
{
if (chb_ToPositionChild.Checked)
{
#region 绑定子职位
Org_PositionBLL _bll = new Org_PositionBLL(int.Parse(tr_Position.SelectValue));
string ids = "";
ids = _bll.GetAllChildPosition();
#endregion
if (ids != "")
condition += " and Org_Staff.Position in(" + tr_Position.SelectValue + "," + ids + ")";
else
condition += " and Org_Staff.Position =" + tr_Position.SelectValue;
}
else
{
condition += " and Org_Staff.Position =" + tr_Position.SelectValue;
}
}
#endregion
#region 判断当前可查询的范围
if (tr_OrganizeCity.SelectValue != "1")
{
Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue));
string orgcitys = orgcity.GetAllChildNodeIDs();
if (orgcitys != "") orgcitys += ",";
orgcitys += tr_OrganizeCity.SelectValue;
if (orgcitys != "") condition += " AND Org_Staff.OrganizeCity IN (" + orgcitys + ")";
}
#endregion
if (ddl_ApproveFlag.SelectedValue != "0")
{
condition += " And Org_Staff.ApproveFlag =" + ddl_ApproveFlag.SelectedValue;
}
if ((int)Session["OwnerType"] != 1)
{
condition += " AND Org_Staff.OwnerType=" + Session["OwnerType"].ToString();
}
if (!Right_Assign_BLL.GetAccessRight(Session["UserName"].ToString(), 1302, "SearchDI"))
{
//查询经销商用户
condition += " AND Org_Staff.OwnerType!=3";
}
ud_grid.ConditionString = condition;
if (ViewState["ConditionString"] != null)
ud_grid.ConditionString += " AND " + ViewState["ConditionString"].ToString();
ud_grid.BindGrid();
}
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 = p.SuperID.ToString();
tr_Position.SelectValue = staff.Model.Position.ToString();
}
else
{
tr_Position.RootValue = "1";
}
tr_Position.SelectValue = tr_Position.RootValue;
#endregion
}
private void BindData()
{
QNA_Project m = new QNA_ProjectBLL((int)ViewState["ID"]).Model;
if (m != null)
{
pl_detail.BindData(m);
if (m.Enabled == "Y")
bt_Enabled.Visible = false;
else
bt_Disabled.Visible = false;
tab_QNAToPosition.Visible =m.ToAllStaff == "N";
tab_QNAToOrganizeCity.Visible = m.ToAllOrganizeCity == "N";
ddl_FaceTo_SelectedIndexChanged(null, null);
gv_List.ConditionString = "QNA_Question.Project=" + m.ID.ToString() + " ORDER BY QNA_Question.SortCode";
gv_List.BindGrid();
#region 显示所属职位，片区
if (tab_QNAToPosition.Visible)
{
List<int> List = new List<int>();
List = new QNA_ToPositionBLL().GetPositionByProjectID((int)ViewState["ID"]);
lb_PositionChild.Items.Clear();
if (List != null)
{
foreach (int id in List)
{
Org_PositionBLL positionbll = new Org_PositionBLL(id);
lb_PositionChild.Items.Add(new ListItem(positionbll.Model.Name, id.ToString()));
}
}
}
if (tab_QNAToOrganizeCity.Visible)
{
List<int> List = new List<int>();
List = new QNA_ToOrganizeCityBLL().GetOrganizeCityByProjectID((int)ViewState["ID"]);
lb_CityChild.Items.Clear();
if (List != null)
{
foreach (int id in List)
{
Addr_OrganizeCityBLL organizeCitybll = new Addr_OrganizeCityBLL(id);
lb_CityChild.Items.Add(new ListItem(organizeCitybll.Model.Name, id.ToString()));
}
}
}
#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() + "人，请注意！";
}
protected void Page_Load(object sender, System.EventArgs e)
{
#region 初始化页面控件
Page.ClientScript.RegisterClientScriptInclude("meizzDate", Page.ResolveClientUrl("~/App_Themes/basic/meizzDate.js"));
select_RelateClient = (MCSSelectControl)pl_detail.FindControl("JN_Journal_RelateClient");
if (select_RelateClient != null)
select_RelateClient.SelectChange += new SelectChangeEventHandler(select_RelateClient_SelectChange);
ddl_RelateLinkMan = (DropDownList)pl_detail.FindControl("JN_Journal_RelateLinkMan");
if (ddl_RelateLinkMan != null)
{
ddl_RelateLinkMan.DataTextField = "Name";
ddl_RelateLinkMan.DataValueField = "ID";
}
rbl_HasSynergeticStaff = (RadioButtonList)pl_detail.FindControl("JN_Journal_HasSynergeticStaff");
if (rbl_HasSynergeticStaff != null)
{
rbl_HasSynergeticStaff.AutoPostBack = true;
rbl_HasSynergeticStaff.SelectedIndexChanged += new EventHandler(rbl_HasSynergeticStaff_SelectedIndexChanged);
}
ddl_RelateActivity = (DropDownList)pl_detail.FindControl("JN_Journal_RelateActivity");
if (ddl_RelateActivity != null)
{
ddl_RelateActivity.DataTextField = "Topic";
ddl_RelateActivity.DataValueField = "ID";
ddl_RelateActivity.AutoPostBack = true;
ddl_RelateActivity.SelectedIndexChanged += new EventHandler(ddl_RelateActivity_SelectedIndexChanged);
}
#endregion
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
#region 获取页面参数
ViewState["ID"] = Request.QueryString["ID"] != null ? Int32.Parse(Request.QueryString["ID"]) : 0;
#endregion
BindDropDown();
if ((int)ViewState["ID"] != 0)
{
if (rbl_HasSynergeticStaff != null) rbl_HasSynergeticStaff.SelectedValue = "2"; //默认非协同拜访
BindData();
}
else
{
if (Request.QueryString["Day"] != null && Request.QueryString["Day"] != "0")
tbx_begindate.Text = DateTime.Today.AddDays(int.Parse(Request.QueryString["Day"]) - DateTime.Today.DayOfYear).ToString("yyyy-MM-dd");
else
tbx_begindate.Text = DateTime.Today.ToString("yyyy-MM-dd");
#region 获取日志填报人信息
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"], true);
select_Staff.SelectText = staff.Model.RealName;
select_Staff.SelectValue = Session["UserID"].ToString();
Org_PositionBLL position = new Org_PositionBLL(staff.Model.Position);
lbl_Position.Text = position.Model.Name;
MCSTreeControl tr_OfficialCity = pl_detail.FindControl("JN_Journal_OfficialCity") != null ? (MCSTreeControl)pl_detail.FindControl("JN_Journal_OfficialCity") : null;
if (tr_OfficialCity != null) tr_OfficialCity.SelectValue = staff.Model.OfficialCity.ToString();
#endregion
#region 获取本机IP
TextBox tbx_IPAddress = pl_detail.FindControl("JN_Journal_IPAddress") != null ? (TextBox)pl_detail.FindControl("JN_Journal_IPAddress") : null;
if (tbx_IPAddress != null)
{
tbx_IPAddress.Text = Request.UserHostAddress;
TextBox tbx_IPLocation = pl_detail.FindControl("JN_Journal_IPLocation") != null ? (TextBox)pl_detail.FindControl("JN_Journal_IPLocation") : null;
userAddress = Const_IPLocationBLL.FindByIP(Request.UserHostAddress);
if (tbx_IPLocation != null) tbx_IPLocation.Text = userAddress != null ? userAddress.Location : "";
}
#endregion
#region 新增日志时，联系人字段不可编辑
if (ddl_RelateLinkMan != null)
{
ddl_RelateLinkMan.Items.Clear();
ddl_RelateLinkMan.Enabled = false;
}
#endregion
pl_detail.SetPanelVisible("Panel_OA_JournalDetail_02", false);
pl_detail.SetPanelVisible("Panel_OA_JournalDetail_03", false);
pl_detail.SetPanelVisible("Panel_OA_JournalDetail_04", false);
#region 默认无领导协同拜访
if (rbl_HasSynergeticStaff != null)
{
rbl_HasSynergeticStaff.SelectedValue = "2"; //默认非协同拜访
rbl_HasSynergeticStaff_SelectedIndexChanged(null, null);
}
#endregion
bt_AddNewClient.Visible = false;
bt_Delete.Visible = false;
tbl_comment.Visible = false;
UploadFile1.Visible = false;
bt_ToEvectionRoute.Visible = false;
}
}
#region 注册脚本
string script = "function OpenClientInput(Journalid,OfferMan,Activityid){\r\n";
script += "window.open('../../CSO/CSO_SampleOfferDetail.aspx?JournalID='+Journalid+'&OfferMan='+OfferMan+'&ActivityID='+Activityid);}";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "OpenClientInput", script, true);
#endregion
}
private void BindData(int ID)
{
Org_PositionBLL _bll = new Org_PositionBLL(ID);
lbl_ID.Text = _bll.Model.ID.ToString();
tbx_Name.Text = _bll.Model.Name;
tr_SuperPosition.SelectValue = _bll.Model.SuperID.ToString();
cbx_IsHeadOffice.Checked = _bll.Model.IsHeadOffice == "Y";
if (_bll.Model.Department != null)
ddl_Department.SelectedValue = _bll.Model.Department.ToString();
cbx_Enable.Checked = _bll.Model.Enabled == "Y";
tbx_Remark.Text = _bll.Model.Remark;
btn_AddSubPosition.Visible = true;
btn_Delete.Visible = true;
MessageBox.ShowConfirm(btn_Delete, "数据删除将不可恢复，确定删除么?");
btn_Cancel.Visible = true;
lbl_AlertInfo.Text = "";
}
private void BindDropDown()
{
Org_StaffBLL staff = new Org_StaffBLL((int)Session["UserID"]);
#region 绑定职位
tr_ToPosition.DataSource = Org_PositionBLL.GetAllPostion();
#region 如果非总部职位，其只能选择自己职位及以下职位
Org_Position p = new Org_PositionBLL(staff.Model.Position).Model;
if (p != null && p.IsHeadOffice != "Y")
{
tr_ToPosition.RootValue = p.SuperID.ToString();
tr_ToPosition.SelectValue = staff.Model.Position.ToString();
}
else
{
tr_ToPosition.RootValue = "0";
tr_ToPosition.SelectValue = "1";
}
#endregion
tr_ToOrganizeCity.DataBind();
#endregion
#region 绑定管理片区
tr_ToOrganizeCity.DataSource = staff.GetStaffOrganizeCity();
if (tr_ToOrganizeCity.DataSource.Select("ID = 1").Length > 0)
{
tr_ToOrganizeCity.RootValue = "0";
tr_ToOrganizeCity.SelectValue = "1";
}
else
{
tr_ToOrganizeCity.RootValue = new Addr_OrganizeCityBLL(staff.Model.OrganizeCity).Model.SuperID.ToString();
tr_ToOrganizeCity.SelectValue = staff.Model.OrganizeCity.ToString();
}
#endregion
}
