private bool DoAdd() { try { Model.department model = new Model.department(); BLL.department bll = new BLL.department(); model.department_name = txtTitle.Text.Trim(); model.sort_id = int.Parse(txtSortId.Text.Trim()); model.is_lock = 0; if (cbIsLock.Checked == true) { model.is_lock = 1; } model.remark = txtRemark.Text.Trim(); model.parent_id = int.Parse(ddlParentId.SelectedValue); if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加部门信息:" + model.department_name); //记录日志 return(true); } } catch { return(false); } return(false); }
protected void ddlParentId_SelectedIndexChanged(object sender, EventArgs e) { DropDownList ddl = (DropDownList)sender; if (ddl.SelectedValue != "0") { Model.department de = new BLL.department().GetModel(int.Parse(ddl.SelectedValue)); if (de.de_isGroup.Value) { dlgroup.Visible = false; dlsubtitle.Visible = true; dlarea.Visible = true; initData(); } else { string _treeText = string.Empty, _treeid = string.Empty; new BLL.department().getDepartText(int.Parse(ddl.SelectedValue), out _treeText, out _treeid, out string area); labDepartText.Text = _treeText; dlsubtitle.Visible = false; dlarea.Visible = false; dlgroup.Visible = false; initData(2); } } else { dlgroup.Visible = true; dlsubtitle.Visible = true; dlarea.Visible = true; initData(1); } }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { PrintLoad(); ChkAdminLevel("sys_department", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.department bll = new BLL.department(); string result = ""; int success = 0, error = 0; StringBuilder sb = new StringBuilder(); manager = GetAdminInfo(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { result = bll.Delete(id, manager); if (result == "") { success++; } else { error++; sb.Append(result + "<br/>"); } } } JscriptMsg("共选择" + (success + error) + "条记录,成功" + success + "条,失败" + error + "条<br/>" + sb.ToString(), "department_list.aspx"); }
//删除导航 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("department_list", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.department bll = new BLL.department(); Agp2pDataContext context = new Agp2pDataContext(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { bll.Delete(id); var groupDepartments = context.li_user_group_departments.Where(w => w.department_id == id).ToList(); foreach (var tr in groupDepartments) { context.li_user_group_departments.DeleteOnSubmit(tr); } var managers = context.dt_manager.Where(w => w.department_id == id).ToList(); foreach (var m in managers) { m.department_id = 0; m.is_default = 0; } } } context.SubmitChanges(); AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除部门信息"); //记录日志 JscriptMsg("删除数据成功!", "department_list.aspx", "Success", "parent.loadMenuTree"); }
private void get_DepartText(HttpContext context) { int id = DTRequest.GetQueryInt("departid"); int oldid = DTRequest.GetQueryInt("olddepartid", 0); string textTree = "", idTree = "", username = ""; new BLL.department().getDepartText(id, out textTree, out idTree, out string area); if (oldid == 0) { //新增时要生成新的工号 username = new BLL.department().getNewUserName(area); } else { //编辑时当原来的区域和新的区域不一致时,要生成新的工号 new BLL.department().getDepartText(oldid, out string oldtextTree, out string oldidTree, out string oldarea); if (area != oldarea) { username = new BLL.department().getNewUserName(area); } } context.Response.Write("{ \"textTree\":\"" + textTree + "\", \"idTree\":\"" + idTree + "\", \"username\":\"" + username + "\" }"); context.Response.End(); return; }
private void ShowInfo(int _id) { BLL.department bll = new BLL.department(); Model.department model = bll.GetModel(_id); ddlParentId.SelectedValue = model.parent_id.ToString(); txtSortId.Text = model.sort_id.ToString(); if (model.is_lock == 1) { cbIsLock.Checked = true; } txtTitle.Text = model.department_name; txtTitle.Attributes.Add("ajaxurl", "../../tools/admin_ajax.ashx?action=department_validate&old_name=" + Utils.UrlEncode(model.department_name)); txtTitle.Focus(); //设置焦点,防止JS无法提交 if (model.is_sys == 1) { ddlParentId.Enabled = false; txtTitle.ReadOnly = true; } txtRemark.Text = model.remark; this.page = DTRequest.GetQueryInt("page", 1); //txtKeywords.Text = this.keywords; BLL.manager bllManager = new BLL.manager(); this.rptList.DataSource = bllManager.GetList(this.pageSize, this.page, "department_id=" + _id + "", "add_time asc,id desc", out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("department_edit.aspx", "page={0}&action={1}&id={2}", "__id__", "pagedepartment", _id.ToString()); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void NewShowInfo() { btnDstatus.Visible = false; btnFlag.Visible = false; btnLockstatus.Visible = false; btnUpdateCost.Visible = false; btnUnBusinessPay.Visible = false; btnReceiptPay.Visible = false; //btnPay.Visible = false; btnInvoince.Visible = false; //btnExcelIn.Visible = false; //默认生成下单人的活动归属地 Dictionary <string, string> areaDic = new BLL.department().getAreaDict(); Dictionary <string, string> orderAreaDic = new Dictionary <string, string>(); orderAreaDic.Add(manager.area, areaDic[manager.area]); rptAreaList.DataSource = orderAreaDic; rptAreaList.DataBind(); //默认下单人 DataTable pdt = new DataTable(); pdt.Columns.Add("op_number"); pdt.Columns.Add("op_name"); pdt.Columns.Add("op_area"); DataRow pdr = pdt.NewRow(); pdr["op_number"] = manager.user_name; pdr["op_name"] = manager.real_name; pdr["op_area"] = manager.area; pdt.Rows.Add(pdr); rptEmployee0.DataSource = pdt; rptEmployee0.DataBind(); }
private string DoEdit(int _id) { try { BLL.department bll = new BLL.department(); Model.department model = bll.GetModel(_id); manager = GetAdminInfo(); string content = string.Empty; model.de_type = string.IsNullOrEmpty(ddltype.SelectedValue) ? (byte)0 : Utils.ObjToByte(ddltype.SelectedValue); model.de_parentid = int.Parse(ddlParentId.SelectedValue); if (model.de_name != txtTitle.Text.Trim()) { content += "机构名称:" + model.de_name + "→<font color='red'>" + txtTitle.Text.Trim() + "</font><br/>"; } model.de_name = txtTitle.Text.Trim(); if (model.de_isUse != cbIsUse.Checked) { content += "状态:" + Common.BusinessDict.isUseStatus(1)[model.de_isUse] + "→<font color='red'>" + Common.BusinessDict.isUseStatus(1)[cbIsUse.Checked] + "</font>"; } model.de_isUse = cbIsUse.Checked; model.de_sort = Convert.ToInt32(txtSortId.Text.Trim()); return(bll.Update(model, content, manager.user_name, manager.real_name)); } catch (Exception e) { return(e.Message); } }
private void TreeBind() { BLL.department bll = new BLL.department(); DataTable dt = bll.GetList(0); this.ddlDepartment.Items.Clear(); this.ddlDepartment.Items.Add(new ListItem("无父级部门", "0")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["department_name"].ToString().Trim(); if (ClassLayer == 1) { this.ddlDepartment.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlDepartment.Items.Add(new ListItem(Title, Id)); } } }
//数据绑定 private void RptBind() { BLL.department bll = new BLL.department(); DataTable dt = bll.GetLists(0); this.rptList.DataSource = dt; this.rptList.DataBind(); }
/// <summary> /// 更新一条数据 /// </summary> public string Update(Model.manager model, string content, Model.manager manager, bool flag = true, bool updateName = false, bool updateContact = false) { if (model.role_id == 0) { return("请选择用户角色"); } if (string.IsNullOrEmpty(model.user_name)) { return("用户名不能为空"); } if (Exists(model.user_name, model.id)) { return("用户名已经存在"); } if (string.IsNullOrEmpty(model.password)) { return("密码不能为空"); } if (string.IsNullOrEmpty(model.real_name)) { return("姓名不能为空"); } if (string.IsNullOrEmpty(model.telephone)) { return("电话不能为空"); } if (flag) { if (model.departID == 0) { return("岗位不能为空"); } Model.department de = new BLL.department().GetModel(model.departID); if (de == null) { return("岗位不存在"); } if (de.de_type != 3) { return("请选择到岗位级别"); } } model.user_name = model.user_name.ToUpper(); model.area = model.area.ToUpper(); string result = dal.Update(model, updateName, updateContact); if (string.IsNullOrEmpty(result)) { Model.business_log logmodel = new Model.business_log(); logmodel.ol_relateID = model.id; logmodel.ol_title = "编辑用户"; logmodel.ol_content = content; logmodel.ol_operateDate = DateTime.Now; new business_log().Add(DTEnums.ActionEnum.Edit.ToString(), logmodel, manager.user_name, manager.real_name); return(""); } return(result); }
private void TreeBind() { var manager = context.dt_manager.FirstOrDefault(w => w.id == GetAdminInfo().id); var department = context.li_departments.FirstOrDefault(w => w.id == manager.department_id); BLL.department bll = new BLL.department(); var dt = new DataTable(); if (department == null) { dt = bll.GetList(0); } else if (department.parent_id == 0) { dt = bll.GetListByOkParentId(department.id, 0); } else { dt = bll.GetListByOkId(department.id, 0); } this.ddlDepartments.Items.Clear(); this.ddlDepartments.Items.Add(new ListItem("不限", "")); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); int ClassLayer = int.Parse(dr["class_layer"].ToString()); string Title = dr["department_name"].ToString().Trim(); if (ClassLayer == 1) { this.ddlDepartments.Items.Add(new ListItem(Title, Id)); } else { Title = "├ " + Title; Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title; this.ddlDepartments.Items.Add(new ListItem(Title, Id)); } var g = context.li_user_group_departments.Where(w => w.department_id == Convert.ToInt32(Id)) .Select(s => s.user_group_id) .ToList(); if (groupIdList.Count == 0) { groupIdList = g; } else { groupIdList = groupIdList.Concat(g).ToList(); } departmentIdList.Add(int.Parse(Id)); } }
protected void Page_Load(object sender, EventArgs e) { action = DTRequest.GetQueryString("action"); this.id = DTRequest.GetQueryInt("id"); ChkAdminLevel("sys_department", action); //检查权限 if (!string.IsNullOrEmpty(action) && action == DTEnums.ActionEnum.Edit.ToString()) { this.action = DTEnums.ActionEnum.Edit.ToString();//修改类型 if (this.id == 0) { JscriptMsg("传输参数不正确!", "back"); return; } if (!new BLL.department().Exists(this.id)) { JscriptMsg("导航不存在或已被删除!", "back"); return; } } if (!Page.IsPostBack) { initData(1); ChkAdminLevel("sys_department", DTEnums.ActionEnum.View.ToString()); //检查权限 if (action == DTEnums.ActionEnum.Edit.ToString()) //修改 { ShowInfo(this.id); } else { TreeBind(); if (this.id > 0) { this.ddlParentId.SelectedValue = this.id.ToString(); Model.department de = new BLL.department().GetModel(this.id); if (de != null) { if (de.de_isGroup.Value) { initData(1); dlgroup.Visible = false; } else { initData(2); } string _treeText = string.Empty, _treeid = string.Empty; new BLL.department().getDepartText(this.id, out _treeText, out _treeid, out string area); labDepartText.Text = _treeText; } } } } }
protected void btnSearch_Click(object sender, EventArgs e) { BLL.department bll = new BLL.department(); if (IsshowNum) { this.rptList.DataSource = bll.getAllEmployee(area, txtPerson.Text.ToUpper(), IsshowNum, hasOrder); this.rptList.DataBind(); } else { this.rptList1.DataSource = bll.getAllEmployee(area, txtPerson.Text.ToUpper()); this.rptList1.DataBind(); } }
private void RptBind() { BLL.department bll = new BLL.department(); if (IsshowNum) { this.rptList.DataSource = bll.getAllEmployee(area, "", IsshowNum, hasOrder); this.rptList.DataBind(); } else { this.rptList1.DataSource = bll.getAllEmployee(area, ""); this.rptList1.DataBind(); } }
//保存排序 protected void btnSave_Click(object sender, EventArgs e) { ChkAdminLevel("sys_department", DTEnums.ActionEnum.Edit.ToString()); //检查权限 BLL.department bll = new BLL.department(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); int sortId; if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId)) { sortId = 99; } bll.UpdateSort(id, sortId); } JscriptMsg("保存排序成功!", Utils.CombUrlTxt("department_list.aspx", "", ""), ""); }
private void ShowInfo(int _id) { BLL.department bll = new BLL.department(); Model.department model = bll.GetModel(_id); TreeBind(); ddlParentId.SelectedValue = model.de_parentid.ToString(); string _treeText = string.Empty, _treeid = string.Empty; bll.getDepartText(_id, out _treeText, out _treeid, out string area); labDepartText.Text = _treeText; initData(); ddltype.SelectedValue = model.de_type.ToString(); txtSortId.Text = model.de_sort.ToString(); txtTitle.Text = model.de_name; txtSubTitle.Text = model.de_subname; txtArea.Text = model.de_area; isgroupDiv.Visible = false; if (model.de_isGroup.Value) { labIsGroup.Text = "是"; cbIsGroup.Checked = true; } else { labIsGroup.Text = "否"; cbIsGroup.Checked = false; } if (model.de_isUse.Value) { cbIsUse.Checked = true; } else { cbIsUse.Checked = false; } if (model.de_type == 2 || model.de_type == 3) { dlsubtitle.Visible = false; dlarea.Visible = false; dlgroup.Visible = false; } txtSubTitle.Enabled = false; txtArea.Enabled = false; ddlParentId.Enabled = false; ddltype.Enabled = false; }
protected void Page_Load(object sender, EventArgs e) { oID = DTRequest.GetString("oID"); Model.Order order = new BLL.Order().GetModel(oID); if (order == null) { JscriptMsg("订单不存在!", "back"); return; } if (order.o_lockStatus == 1) { PrintJscriptMsg("订单已锁定,不能再添加合作分成", ""); return; } sdate = order.o_sdate.Value.ToString("yyyy-MM-dd"); edate = order.o_edate.Value.ToString("yyyy-MM-dd"); OrderPerson op = order.personlist.Where(p => p.op_type == 1).ToArray()[0]; string place = ("," + order.o_place + ",").Replace("," + op.op_area + ",", ","); string area = ""; if (!string.IsNullOrEmpty(place)) { string[] plist = place.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (string item in plist) { area = new BLL.department().getAreaText(item); trHtml += "<tr style=\"text-align: center;\" class=\"computeTR\">"; trHtml += "<td>" + area + "</td>"; trHtml += "<td>业绩分成(" + area + ")</td>"; trHtml += "<td><input type=\"text\" name=\"txtExpression1\" data-area=\"" + item + "\" style=\"width: 200px; \" class=\"input\" onblur=\"computeResult(this,1)\" /><span></span></td>"; trHtml += "<td><span class=\"computeInput1\">0</span></td>"; trHtml += "<td><input type=\"text\" name=\"txtExpression0\" data-area=\"" + item + "\" style=\"width: 200px; \" class=\"input\" onblur=\"computeResult(this,0)\" /><span></span></td>"; trHtml += "<td><span class=\"computeInput0\">0</span></td>"; trHtml += "</tr>"; } } area = new BLL.department().getAreaText(op.op_area); trHtml += "<tr style=\"text-align: center;\">"; trHtml += "<td>" + area + "</td>"; trHtml += "<td>业绩分成(" + area + ")</td>"; trHtml += "<td><input type=\"text\" id=\"txtArea1\" name=\"txtExpression1\" data-area=\"" + op.op_area + "\" disabled=\"disabled\" style=\"width: 200px; \" class=\"input\" value=\"0\" /><span></span></td>"; trHtml += "<td>0</td>"; trHtml += "<td><input type=\"text\" id=\"txtArea0\" name=\"txtExpression0\" data-area=\"" + op.op_area + "\" disabled=\"disabled\" style=\"width: 200px; \" class=\"input\" value=\"0\" /><span></span></td>"; trHtml += "<td>0</td>"; trHtml += "</tr>"; }
//保存排序 protected void btnSave_Click(object sender, EventArgs e) { ChkAdminLevel("department_list", DTEnums.ActionEnum.Edit.ToString()); //检查权限 BLL.department bll = new BLL.department(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); int sortId; if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId)) { sortId = 99; } bll.UpdateField(id, "sort_id=" + sortId.ToString()); } AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存部门排序"); //记录日志 JscriptMsg("保存排序成功!", "department_list.aspx", "Success"); }
private string DoAdd() { try { Model.department model = new Model.department(); BLL.department bll = new BLL.department(); manager = GetAdminInfo(); model.de_type = string.IsNullOrEmpty(ddltype.SelectedValue) ? (byte)0 : Utils.ObjToByte(ddltype.SelectedValue); model.de_parentid = int.Parse(ddlParentId.SelectedValue); model.de_isGroup = cbIsGroup.Checked; model.de_name = txtTitle.Text.Trim(); model.de_subname = txtSubTitle.Text.Trim(); model.de_area = txtArea.Text.Trim().ToUpper(); model.de_sort = Utils.ObjToInt(txtSortId.Text.Trim(), 0); model.de_isUse = cbIsUse.Checked; return(bll.Add(model, manager.user_name, manager.real_name)); } catch (Exception e) { return(e.Message); } }
private bool DoEdit(int _id) { try { BLL.department bll = new BLL.department(); Model.department model = bll.GetModel(_id); model.department_name = txtTitle.Text.Trim(); model.sort_id = int.Parse(txtSortId.Text.Trim()); model.is_lock = 0; if (cbIsLock.Checked == true) { model.is_lock = 1; } model.remark = txtRemark.Text.Trim(); if (model.is_sys == 0) { int parentId = int.Parse(ddlParentId.SelectedValue); //如果选择的父ID不是自己,则更改 if (parentId != model.id) { model.parent_id = parentId; } } if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "修改部门信息:" + model.department_name); //记录日志 return(true); } } catch { return(false); } return(false); }
private void ShowInfo(string _oid) { rptEmployee0.Visible = false; liemployee0.Visible = false; BLL.Order bll = new BLL.Order(); DataSet ds = bll.GetList(0, "o_id='" + _oid + "'", "o_addDate desc"); if (ds == null || ds.Tables[0].Rows.Count == 0) { JscriptMsg("订单不存在!", ""); return; } DataRow dr = ds.Tables[0].Rows[0]; labOwner.Text = new MettingSys.BLL.department().getAreaText(dr["op_area"].ToString()) + "," + dr["op_number"] + "," + dr["op_name"]; txtCusName.Text = dr["c_name"].ToString(); hCusId.Value = dr["c_id"].ToString(); List <Model.Contacts> contactlist = new BLL.Contacts().getList("co_cid=" + hCusId.Value + "", " co_flag desc,co_id asc"); if (contactlist != null) { ddlcontact.DataSource = contactlist; ddlcontact.DataTextField = "co_name"; ddlcontact.DataValueField = "co_id"; ddlcontact.DataBind(); } ddlcontact.SelectedValue = dr["o_coid"].ToString(); txtPhone.Text = dr["co_number"].ToString(); ddlcontractPrice.SelectedValue = dr["o_contractPrice"].ToString(); txtsDate.Text = ConvertHelper.toDate(dr["o_sdate"]).Value.ToString("yyyy-MM-dd"); txteDate.Text = ConvertHelper.toDate(dr["o_edate"]).Value.ToString("yyyy-MM-dd"); txtAddress.Text = dr["o_address"].ToString(); txtContent.Text = dr["o_content"].ToString(); txtContract.Text = dr["o_contractContent"].ToString(); txtRemark.Text = dr["o_remarks"].ToString(); ddlfStatus.SelectedValue = dr["o_status"].ToString(); //ddldstatus.SelectedValue = dr["o_dstatus"].ToString(); ddlpushStatus.SelectedValue = dr["o_isPush"].ToString(); labFlag.Text = Common.BusinessDict.checkStatus()[Utils.ObjToByte(dr["o_flag"])]; ddlflag.SelectedValue = dr["o_flag"].ToString(); labLockStatus.Text = Common.BusinessDict.lockStatus()[Utils.ObjToByte(dr["o_lockStatus"])]; labfinanceCost.Text = dr["o_financeCust"].ToString(); txtCost.Text = dr["o_financeCust"].ToString(); finCost = Utils.StrToDecimal(dr["o_financeCust"].ToString(), 0); ddllockstatus.SelectedValue = dr["o_lockStatus"].ToString(); labFinRemarks.Text = dr["o_finRemarks"].ToString(); txtFinRemark.Text = dr["o_finRemarks"].ToString(); labStatusTime.Text = Utils.ObjectToStr(dr["o_statusTime"]) == "" ? "" : Utils.StrToDateTime(Utils.ObjectToStr(dr["o_statusTime"])).ToString("yyyy-MM-dd HH:mm:ss"); #region 归属地 string placeStr = dr["o_place"].ToString(); if (!string.IsNullOrEmpty(placeStr)) { Dictionary <string, string> areaDic = new BLL.department().getAreaDict(); Dictionary <string, string> orderAreaDic = new Dictionary <string, string>(); string[] list = placeStr.Split(','); foreach (string item in list) { if (areaDic.ContainsKey(item)) { orderAreaDic.Add(item, areaDic[item]); } } rptAreaList.DataSource = orderAreaDic; rptAreaList.DataBind(); } #endregion #region 人员 DataTable pdt = bll.GetPersonList(0, "op_oid='" + _oid + "'", "op_id asc").Tables[0]; if (pdt != null && pdt.Rows.Count > 0) { rptEmployee1.DataSource = pdt.Select("op_type=2"); rptEmployee1.DataBind(); rptEmployee2.DataSource = pdt.Select("op_type=3"); rptEmployee2.DataBind(); rptEmployee3.DataSource = pdt.Select("op_type=4"); rptEmployee3.DataBind(); rptEmployee4.DataSource = pdt.Select("op_type=5"); rptEmployee4.DataBind(); liplace.Visible = false; liemployee1.Visible = false; liemployee2.Visible = false; liemployee3.Visible = false; liemployee4.Visible = false; uploadDiv.Visible = false; uploadDiv2.Visible = false; btnSave.Visible = false; btnDstatus.Visible = false; btnFlag.Visible = false; btnLockstatus.Visible = false; btnUpdateCost.Visible = false; btnUnBusinessPay.Visible = false; btnReceiptPay.Visible = false; btnFinRemark.Visible = false; //btnPay.Visible = false; btnInvoince.Visible = false; //btnExcelIn.Visible = false; btnSharing.Visible = false; trFile.Visible = false; #region 根据当前登录账户显示不同按钮 DataRow[] drs1 = pdt.Select("op_type=1 and op_number='" + manager.user_name + "'"); //业务员 DataRow[] drs2 = pdt.Select("op_type=2 and op_number='" + manager.user_name + "'"); //业务报账人员 DataRow[] drs3 = pdt.Select("op_type=3 and op_number='" + manager.user_name + "'"); //业务策划人员 DataRow[] drs4 = pdt.Select("op_type=4 and op_number='" + manager.user_name + "'"); //业务执行人员 DataRow[] drs6 = pdt.Select("op_type=5 and op_number='" + manager.user_name + "'"); //业务设计人员 bool showDetail = false; if (drs4.Length > 0) { isExecutiver = true; showDetail = true; uploadDiv.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; } if (drs3.Length > 0 || drs6.Length > 0) { showDetail = true; uploadDiv.Visible = true; uploadDiv2.Visible = true; btnDstatus.Visible = true; trFile.Visible = true; if (drs3.Length > 0) { ddldstatus.SelectedValue = drs3[0]["op_dstatus"].ToString(); } else if (drs6.Length > 0) { ddldstatus.SelectedValue = drs6[0]["op_dstatus"].ToString(); } } if (drs2.Length > 0) { isExecutiver = false; showDetail = true; liplace.Visible = true; liemployee2.Visible = true; liemployee3.Visible = true; liemployee4.Visible = true; uploadDiv.Visible = true; uploadDiv2.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; btnSave.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; trFile.Visible = true; } if (drs1.Length > 0) { isExecutiver = false; showDetail = true; liplace.Visible = true; liemployee1.Visible = true; liemployee2.Visible = true; liemployee3.Visible = true; liemployee4.Visible = true; uploadDiv.Visible = true; uploadDiv2.Visible = true; btnSave.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; trFile.Visible = true; } DataRow[] drs5 = pdt.Select("op_type=1"); //判断是否含有查看本区域数据的权限 if (new BLL.permission().checkHasPermission(manager, "0602") && (drs5[0]["op_area"].ToString() == manager.area || Utils.ObjectToStr(dr["o_place"]).IndexOf(manager.area) > -1)) { showDetail = true; trFile.Visible = true; } string groupArea = new BLL.department().getGroupArea();//总部 //判断是否是本区域,且含有财务基本权限 if ((drs5[0]["op_area"].ToString() == manager.area || groupArea == manager.area) && new BLL.permission().checkHasPermission(manager, "0401")) { showDetail = true; trFile.Visible = true; btnUnBusinessPay.Visible = true; btnReceiptPay.Visible = true; uploadDiv2.Visible = true; //btnPay.Visible = true; btnInvoince.Visible = true; //btnExcelIn.Visible = true; } //判断是否含有查看本区域审批权限 if (drs5[0]["op_area"].ToString() == manager.area && new BLL.permission().checkHasPermission(manager, "0603")) { trFile.Visible = true; showDetail = true; btnFlag.Visible = true; } // if (groupArea == manager.area) { if (new BLL.permission().checkHasPermission(manager, "0401")) { showDetail = true; trFile.Visible = true; } if (new BLL.permission().checkHasPermission(manager, "0405")) { showDetail = true; btnLockstatus.Visible = true; btnUpdateCost.Visible = true; trFile.Visible = true; } } if (new BLL.permission().checkHasPermission(manager, "0401")) { btnFinRemark.Visible = true; if (!Utils.StrToBool(dr["o_lockStatus"].ToString(), false)) { btnSharing.Visible = true; } } //以上都没有权限的,不能查看订单详细 if (!showDetail) { string msgbox = "parent.jsdialog(\"错误提示\", \"您没有管理该页面的权限,请勿非法进入!\", \"back\")"; Response.Write("<script type=\"text/javascript\">" + msgbox + "</script>"); Response.End(); } #endregion } #endregion if (dr["o_lockStatus"].ToString() == "1") { liplace.Visible = false; liemployee1.Visible = false; liemployee2.Visible = false; liemployee3.Visible = false; liemployee4.Visible = false; uploadDiv.Visible = false; uploadDiv2.Visible = false; btnSave.Visible = false; btnDstatus.Visible = false; btnFlag.Visible = false; btnUpdateCost.Visible = false; btnUnBusinessPay.Visible = false; btnReceiptPay.Visible = false; //btnPay.Visible = false; btnInvoince.Visible = true; //btnExcelIn.Visible = false; } #region 活动文件 DataTable fdt = bll.GetFileList(0, "f_oid='" + _oid + "'", "f_addDate asc,f_id asc").Tables[0]; if (fdt != null && fdt.Rows.Count > 0) { rptAlbumList.DataSource = fdt.Select("f_type=1"); rptAlbumList.DataBind(); rptAlbumList2.DataSource = fdt.Select("f_type=2"); rptAlbumList2.DataBind(); } #endregion string sqlwhere = ""; #region 执行备用金借款明细 if (isExecutiver) { sqlwhere = " and uba_PersonNum='" + manager.user_name + "'"; } DataSet unBusinessData = new BLL.unBusinessApply().GetList(0, "uba_oid='" + _oid + "' " + sqlwhere + "", "uba_addDate desc,uba_id desc"); if (unBusinessData != null && unBusinessData.Tables[0].Rows.Count > 0) { rptunBusinessList.DataSource = unBusinessData; rptunBusinessList.DataBind(); } #endregion #region 应收付 DataTable natureData = new BLL.finance().getNature(_oid, isExecutiver ? manager.user_name : ""); if (natureData != null && natureData.Rows.Count > 0) { rptNature.DataSource = natureData; rptNature.DataBind(); } #endregion #region 发票 if (isExecutiver) { sqlwhere = " and inv_personNum='" + manager.user_name + "'"; } DataTable invoiceData = new BLL.invoices().GetList(0, "inv_oid='" + _oid + "' " + sqlwhere + "", "inv_addDate desc,inv_id desc").Tables[0]; if (invoiceData != null && invoiceData.Rows.Count > 0) { foreach (DataRow inv in invoiceData.Rows) { if (inv["inv_flag1"].ToString() != "1" && inv["inv_flag2"].ToString() != "1" && inv["inv_flag3"].ToString() != "1") { requestMoney += Utils.StrToDecimal(inv["inv_money"].ToString(), 0); } if (Utils.StrToBool(inv["inv_isConfirm"].ToString(), false)) { confirmMoney += Utils.StrToDecimal(inv["inv_money"].ToString(), 0); } } rptInvoiceList.DataSource = invoiceData; rptInvoiceList.DataBind(); } #endregion #region 已收付款 if (isExecutiver) { sqlwhere = " and rpd_personNum='" + manager.user_name + "'"; } DataTable rpData = new BLL.ReceiptPayDetail().GetList(0, "rpd_oid='" + _oid + "'", "rpd_type desc,rpd_adddate desc,rpd_id desc").Tables[0]; if (rpData != null && rpData.Rows.Count > 0) { rptList.DataSource = rpData; rptList.DataBind(); } #endregion #region 结算汇总 if (!isExecutiver)//执行人员不可查看 { DataTable collectData = bll.getOrderCollect(_oid); if (collectData != null && collectData.Rows.Count > 0) { foreach (DataRow inv in collectData.Rows) { finProfit += Utils.StrToDecimal(inv["profit"].ToString(), 0); if (inv["fin_type"].ToString() == "True") { fin1 += Utils.StrToDecimal(inv["finMoney"].ToString(), 0); } else { fin0 += Utils.StrToDecimal(inv["finMoney"].ToString(), 0); } } rptCollect.DataSource = collectData; rptCollect.DataBind(); } } #endregion }
protected void Page_Load(object sender, EventArgs e) { this.pageSize = GetPageSize(10); //每页数量 _page = DTRequest.GetString("page"); _sMonth = DTRequest.GetString("txtsDate"); _eMonth = DTRequest.GetString("txteDate"); _status = DTRequest.GetString("ddlstatus"); _lockstatus = DTRequest.GetString("ddllock"); _area = DTRequest.GetString("hide_place"); _isRemove = DTRequest.GetString("cbIsRemove"); _isCust = DTRequest.GetString("cbIsCust"); action = DTRequest.GetString("action"); _excel = DTRequest.GetString("Excel"); ChkAdminLevel("sys_AreaAchievementStatistics", DTEnums.ActionEnum.View.ToString()); //检查权限 if (!IsPostBack && _excel != "on" && string.IsNullOrEmpty(_page)) { _sMonth = DateTime.Now.ToString("yyyy-MM"); _eMonth = DateTime.Now.ToString("yyyy-MM"); _status = "3"; _lockstatus = "1"; _isCust = "on"; RptBind("1=1 " + CombSqlTxt(), "de_area"); } InitData(); if (action == "Search") { RptBind("1=1 " + CombSqlTxt(), "de_area"); } if (_excel == "on") { Excel(); } #region 绑定控件值 txtsDate.Text = _sMonth; txteDate.Text = _eMonth; ddlstatus.SelectedValue = _status; ddllock.SelectedValue = _lockstatus; cbIsCust.Checked = _isCust == "on" ? true : false; cbIsRemove.Checked = _isRemove == "on" ? true : false; string placeStr = _area; if (!string.IsNullOrEmpty(placeStr)) { Dictionary <string, string> areaDic = new BLL.department().getAreaDict(); Dictionary <string, string> orderAreaDic = new Dictionary <string, string>(); string[] list = placeStr.Split(','); foreach (string item in list) { if (areaDic.ContainsKey(item)) { orderAreaDic.Add(item, areaDic[item]); } } rptAreaList.DataSource = orderAreaDic; rptAreaList.DataBind(); } else { rptAreaList.DataSource = null; rptAreaList.DataBind(); } #endregion }
private void RptBind(string _strWhere, string _orderby) { BLL.department bll = new BLL.department(); this.rptList.DataSource = bll.getAreaDict(); //bll.GetList(0, _strWhere, _orderby); this.rptList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { ChkAdminLevel("sys_RevenueAnalysis", DTEnums.ActionEnum.View.ToString()); //检查权限 this.pageSize = GetPageSize(10); //每页数量 _page = DTRequest.GetString("page"); _sMonth = DTRequest.GetString("txtsDate"); _eMonth = DTRequest.GetString("txteDate"); _cusName = DTRequest.GetString("txtCusName"); _cid = DTRequest.GetString("hCusId"); _area = DTRequest.GetString("hide_place"); _nature = DTRequest.GetString("hide_nature"); _person1 = DTRequest.GetString("hide_employee1"); _person3 = DTRequest.GetString("hide_employee3"); _group = DTRequest.GetString("ddlGroup"); _excel = DTRequest.GetString("Excel"); action = DTRequest.GetString("action"); _lockstatus = DTRequest.GetString("ddllock"); InitData(); if (!IsPostBack && _excel != "on" && string.IsNullOrEmpty(_page)) { InitData(); _lockstatus = "1"; _sMonth = DateTime.Now.ToString("yyyy-MM"); _eMonth = DateTime.Now.ToString("yyyy-MM"); RptBind(); } if (action == "Search") { RptBind(); } if (_excel == "on") { Excel(); } #region 绑定控件值 txtsDate.Text = _sMonth; txteDate.Text = _eMonth; txtCusName.Text = _cusName; hCusId.Value = _cid; ddlGroup.SelectedValue = _group; ddllock.SelectedValue = _lockstatus; string placeStr = _area; if (!string.IsNullOrEmpty(placeStr)) { Dictionary <string, string> areaDic = new BLL.department().getAreaDict(); Dictionary <string, string> orderAreaDic = new Dictionary <string, string>(); string[] list = placeStr.Split(','); foreach (string item in list) { if (areaDic.ContainsKey(item)) { orderAreaDic.Add(item, areaDic[item]); } } rptAreaList.DataSource = orderAreaDic; rptAreaList.DataBind(); } else { rptAreaList.DataSource = null; rptAreaList.DataBind(); } if (!string.IsNullOrEmpty(_nature)) { DataTable dt = new DataTable(); dt.Columns.Add("na_id"); dt.Columns.Add("na_name"); string[] list = _nature.Split(','); foreach (string item in list) { DataRow dr = dt.NewRow(); string[] lis = item.Split('|'); dr["na_id"] = lis[0]; dr["na_name"] = lis[1]; dt.Rows.Add(dr); } rptNatureList.DataSource = dt; rptNatureList.DataBind(); } else { rptNatureList.DataSource = null; rptNatureList.DataBind(); } if (!string.IsNullOrEmpty(_person1)) { DataTable dt = new DataTable(); dt.Columns.Add("op_name"); dt.Columns.Add("op_number"); dt.Columns.Add("op_area"); string[] list = _person1.Split(','); foreach (string item in list) { DataRow dr = dt.NewRow(); string[] lis = item.Split('|'); dr["op_name"] = lis[0]; dr["op_number"] = lis[1]; dr["op_area"] = lis[2]; dt.Rows.Add(dr); } rptEmployee1.DataSource = dt; rptEmployee1.DataBind(); } else { rptEmployee1.DataSource = null; rptEmployee1.DataBind(); } if (!string.IsNullOrEmpty(_person3)) { DataTable dt = new DataTable(); dt.Columns.Add("op_name"); dt.Columns.Add("op_number"); dt.Columns.Add("op_area"); string[] list = _person3.Split(','); foreach (string item in list) { DataRow dr = dt.NewRow(); string[] lis = item.Split('|'); dr["op_name"] = lis[0]; dr["op_number"] = lis[1]; dr["op_area"] = lis[2]; dt.Rows.Add(dr); } rptEmployee3.DataSource = dt; rptEmployee3.DataBind(); } else { rptEmployee3.DataSource = null; rptEmployee3.DataBind(); } #endregion }
private void RptBind() { //BLL.manager bll = new BLL.manager(); //this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //this.rptList.DataBind(); IQueryable <dt_manager> query = context.dt_manager; BLL.department departmentbll = new BLL.department(); if (string.IsNullOrWhiteSpace(ddlDepartments.SelectedValue)) // 不限:查自己的组权限 + 下属的组权限,都无选权限的话能看全部 { var manager = context.dt_manager.Single(m => m.id == GetAdminInfo().id); if (manager.department_id > 0) { query = query.Where(w => idstrList.Contains(w.id)); } } else // 选了下属,看下属的组权限,无选的话不能看全部 { var department = context.li_departments.FirstOrDefault(w => w.id == Convert.ToInt32(ddlDepartments.SelectedValue)); if (department.class_layer == 1) { DataTable dt = departmentbll.GetListByOkParentId(department.id, 0); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); var g = context.dt_manager.Where(w => w.department_id == Convert.ToInt32(Id)) .Select(s => s.id) .ToList(); if (manageridstrList.Count == 0) { manageridstrList = g; } else { manageridstrList = manageridstrList.Concat(g).ToList(); } } query = query.Where(w => manageridstrList.Contains(w.id)); // 不限:查自己的组权限 + 下属的组权限,都无选权限的话能看全部 } else // 选了下属,看下属的组权限,无选的话不能看全部 { var canAccessGroups = context.dt_manager.Where(w => w.department_id == Convert.ToInt32(ddlDepartments.SelectedValue)).Select(s => s.id).ToArray(); query = query.Where(w => canAccessGroups.Contains(w.id)); } } if (!string.IsNullOrWhiteSpace(txtKeywords.Text)) { query = query.Where(w => (w.user_name.Contains(txtKeywords.Text) || w.real_name.Contains(txtKeywords.Text) || w.email.Contains(txtKeywords.Text))); } totalCount = query.Count(); rptList.DataSource = query .OrderBy(u => u.add_time) .ThenByDescending(u => u.id) .Skip(pageSize * (page - 1)) .Take(pageSize) .ToList(); rptList.DataBind(); //绑定页码 txtPageNum.Text = pageSize.ToString(); var pageUrl = Utils.CombUrlTxt("manager_list.aspx", "keywords={0}&page={1}&department_id={2}", txtKeywords.Text, "__id__", ddlDepartments.SelectedValue); PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8); }
/// <summary> /// 增加一条数据 /// </summary> public string Add(Model.manager model, Model.manager manager) { if (model.role_id == 0) { return("请选择用户角色"); } if (string.IsNullOrEmpty(model.user_name)) { return("用户名不能为空"); } if (Exists(model.user_name)) { return("用户名已经存在"); } if (string.IsNullOrEmpty(model.password)) { return("密码不能为空"); } if (string.IsNullOrEmpty(model.real_name)) { return("姓名不能为空"); } if (string.IsNullOrEmpty(model.telephone)) { return("电话不能为空"); } if (model.departID == 0) { return("岗位不能为空"); } Model.department de = new BLL.department().GetModel(model.departID); if (de == null) { return("岗位不存在"); } if (de.de_type != 3) { return("请选择到岗位级别"); } model.area = de.de_area; model.user_name = model.user_name.ToUpper(); model.area = model.area.ToUpper(); int id = 0; string result = dal.Add(model, out id); if (string.IsNullOrEmpty(result)) { StringBuilder sb = new StringBuilder(); sb.Append("用户名:" + model.user_name + "<br/>"); sb.Append("管理角色:" + model.role_id + "<br/>"); sb.Append("姓名:" + model.real_name + "<br/>"); sb.Append("邮箱:" + model.email + "<br/>"); sb.Append("电话:" + model.telephone + "<br/>"); sb.Append("岗位:" + model.departTree + "<br/>"); sb.Append("区域:" + model.area + "<br/>"); Model.business_log logmodel = new Model.business_log(); logmodel.ol_relateID = id; logmodel.ol_title = "添加用户"; logmodel.ol_content = sb.ToString(); logmodel.ol_operateDate = DateTime.Now; new business_log().Add(DTEnums.ActionEnum.Add.ToString(), logmodel, manager.user_name, manager.real_name); return(""); } return(result); }
private void RptBind() { Agp2pDataContext context = new Agp2pDataContext(); BLL.department bll = new BLL.department(); var options = new DataLoadOptions(); options.LoadWith <dt_user_groups>(g => g.dt_users); options.LoadWith <dt_users>(u => u.li_wallets); context.LoadOptions = options; IQueryable <dt_user_groups> query = context.dt_user_groups; //if (string.IsNullOrWhiteSpace(ddlSubordinates.SelectedValue)) // 不限:查自己的组权限 + 下属的组权限,都无选权限的话能看全部 //{ // var subordinatesId = context.dt_manager.Single(m => m.id == GetAdminInfo().id).dt_manager2.Select(s => s.id).ToArray(); // var canAccessGroups = // context.li_user_group_access_keys.Where( // k => k.owner_manager == GetAdminInfo().id || subordinatesId.Contains(k.owner_manager)) // .Select(k => k.user_group).Distinct() // .ToArray(); // query = query.Where(w => !canAccessGroups.Any() || canAccessGroups.Contains(w.id)); //} //else // 选了下属,看下属的组权限,无选的话不能看全部 //{ // var canAccessGroups = context.li_user_group_access_keys.Where(k => k.owner_manager == Convert.ToInt32(ddlSubordinates.SelectedValue)).Select(k => k.user_group).ToArray(); // query = query.Where(w => canAccessGroups.Contains(w.id)); //} if (string.IsNullOrWhiteSpace(ddlDepartments.SelectedValue)) // 不限:查自己的组权限 + 下属的组权限,都无选权限的话能看全部 { var manager = context.dt_manager.Single(m => m.id == GetAdminInfo().id); if (manager.department_id > 0) { query = query.Where(w => idstrList.Contains(w.id)); } } else // 选了下属,看下属的组权限,无选的话不能看全部 { var department = context.li_departments.FirstOrDefault(w => w.id == Convert.ToInt32(ddlDepartments.SelectedValue)); if (department.class_layer == 1) { DataTable dt = bll.GetListByOkParentId(department.id, 0); foreach (DataRow dr in dt.Rows) { string Id = dr["id"].ToString(); var g = context.li_user_group_departments.Where(w => w.department_id == Convert.ToInt32(Id)) .Select(s => s.user_group_id) .ToList(); if (departmentIdList.Count == 0) { departmentIdList = g; } else { departmentIdList = departmentIdList.Concat(g).ToList(); } } query = query.Where(w => departmentIdList.Contains(w.id)); // 不限:查自己的组权限 + 下属的组权限,都无选权限的话能看全部 } else // 选了下属,看下属的组权限,无选的话不能看全部 { var canAccessGroups = context.li_user_group_departments.Where(w => w.department_id == Convert.ToInt32(ddlDepartments.SelectedValue)).Select(s => s.user_group_id).ToArray(); query = query.Where(w => canAccessGroups.Contains(w.id)); } } query = query.Where(w => w.title.Contains(txtKeywords.Text)); var groups = query.OrderBy(g => g.grade).AsEnumerable().Select(g => new GroupDetails { id = g.id, is_default = g.is_default, GroupName = g.title, Servers = QueryServers(g), UserCount = QueryGroupUserCount(g), DepartmentName = QueryDepartmentName(g), IdleMoney = QueryGroupUserWalletSum(g, w => w.idle_money), LockedMoney = QueryGroupUserWalletSum(g, w => w.locked_money), InvestingMoney = QueryGroupUserWalletSum(g, w => w.investing_money), UnpaidPrincipal = QueryGroupUserWalletSum(g, w => w.total_investment - w.investing_money), TotalInvestment = QueryGroupUserWalletSum(g, w => w.total_investment), ProfitingMoney = QueryGroupUserWalletSum(g, w => w.profiting_money), PaidMoney = QueryGroupUserWalletSum(g, w => w.total_profit), TotalProfit = QueryGroupUserWalletSum(g, w => w.total_profit + w.profiting_money), TotalCharge = QueryGroupUserWalletSum(g, w => w.total_charge), TotalWithdraw = QueryGroupUserWalletSum(g, w => w.total_withdraw) }).ToLazyList(); rptList.DataSource = groups.Concat(Enumerable.Range(0, 1).Select(i => new GroupDetails { GroupName = "总计", is_default = 1, // hide operation UserCount = groups.Sum(g => g.UserCount), //DepartmentName = groups.Select(g => g.DepartmentName).ToString(), IdleMoney = groups.Sum(w => w.IdleMoney), LockedMoney = groups.Sum(w => w.LockedMoney), InvestingMoney = groups.Sum(w => w.InvestingMoney), UnpaidPrincipal = groups.Sum(w => w.TotalInvestment - w.InvestingMoney), TotalInvestment = groups.Sum(w => w.TotalInvestment), ProfitingMoney = groups.Sum(w => w.ProfitingMoney), PaidMoney = groups.Sum(w => w.TotalProfit), TotalProfit = groups.Sum(w => w.TotalProfit + w.ProfitingMoney), TotalCharge = groups.Sum(w => w.TotalCharge), TotalWithdraw = groups.Sum(w => w.TotalWithdraw) })); rptList.DataBind(); }
private void RptBind() { BLL.department bll = new BLL.department(); this.rptList.DataSource = bll.GetList(0, ""); this.rptList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { this.pageSize = GetPageSize(10); //每页数量 _page = DTRequest.GetString("page"); _sMonth = DTRequest.GetString("txtsDate"); _eMonth = DTRequest.GetString("txteDate"); _status = DTRequest.GetString("ddlstatus"); _lockstatus = DTRequest.GetString("ddllock"); _area = DTRequest.GetString("hide_place"); _person = DTRequest.GetString("hide_employee3"); _isRemove = DTRequest.GetString("cbIsRemove"); _isCust = DTRequest.GetString("cbIsCust"); action = DTRequest.GetString("action"); _type = DTRequest.GetString("ddltype"); _excel = DTRequest.GetString("Excel"); if (_type == "") { _type = "0"; } _self = DTRequest.GetString("self"); if (_self == "1")//个人业绩 { manager = GetAdminInfo(); _person = manager.real_name + "|" + manager.user_name + "|" + manager.area; liemployee3.Visible = false; } else { ChkAdminLevel("sys_AchievementStatistics", DTEnums.ActionEnum.View.ToString()); //检查权限 } if (!IsPostBack && _excel != "on" && string.IsNullOrEmpty(_page)) { _sMonth = DateTime.Now.ToString("yyyy-MM"); _eMonth = DateTime.Now.ToString("yyyy-MM"); _status = "3"; _lockstatus = "1"; _isCust = "on"; RptBind("1=1 " + CombSqlTxt(), _type == "0"?"p1.op_number asc": "p3.op_number asc"); } InitData(); if (action == "Search") { RptBind("1=1 " + CombSqlTxt(), _type == "0" ? "p1.op_number asc" : "p3.op_number asc"); } if (_excel == "on") { Excel(); } #region 绑定控件值 txtsDate.Text = _sMonth; txteDate.Text = _eMonth; ddlstatus.SelectedValue = _status; ddllock.SelectedValue = _lockstatus; ddltype.SelectedValue = _type; cbIsCust.Checked = _isCust == "on" ? true : false; cbIsRemove.Checked = _isRemove == "on" ? true : false; string placeStr = _area; if (!string.IsNullOrEmpty(placeStr)) { Dictionary <string, string> areaDic = new BLL.department().getAreaDict(); Dictionary <string, string> orderAreaDic = new Dictionary <string, string>(); string[] list = placeStr.Split(','); foreach (string item in list) { if (areaDic.ContainsKey(item)) { orderAreaDic.Add(item, areaDic[item]); } } rptAreaList.DataSource = orderAreaDic; rptAreaList.DataBind(); } else { rptAreaList.DataSource = null; rptAreaList.DataBind(); } if (!string.IsNullOrEmpty(_person)) { DataTable dt = new DataTable(); dt.Columns.Add("op_name"); dt.Columns.Add("op_number"); dt.Columns.Add("op_area"); string[] list = _person.Split(','); foreach (string item in list) { DataRow dr = dt.NewRow(); string[] lis = item.Split('|'); dr["op_name"] = lis[0]; dr["op_number"] = lis[1]; dr["op_area"] = lis[2]; dt.Rows.Add(dr); } rptEmployee2.DataSource = dt; rptEmployee2.DataBind(); } else { rptEmployee2.DataSource = null; rptEmployee2.DataBind(); } #endregion }