public ActionResult NewPriceApproveStep() { string strErrText; //读取价格审批步骤数据 FlowSystem flow = new FlowSystem(); List<ApproveFlowStep> listStep = flow.LoadApproveFlowStepsByFlowType(InnoSoft.LS.Resources.Options.PriceApproveFlow, LoginAccountId, LoginStaffName, out strErrText); if (listStep == null) { throw new Exception(strErrText); } //生成新步骤序号 int nStepNum = 1; if (listStep.Count > 0) { nStepNum = listStep[listStep.Count - 1].StepNum + 1; } //创建空的Model PriceApproveFlowStepViewModel model = new PriceApproveFlowStepViewModel(); model.StepNum = nStepNum; model.Conditions = new List<PriceApproveFlowStepConditionViewModel>(); model.Conditions.Add(new PriceApproveFlowStepConditionViewModel()); //生成处理人下拉列表项 StaffSystem staff = new StaffSystem(); List<Staff> listStaff = staff.LoadStaffs(LoginAccountId, LoginStaffName, out strErrText); if (listStaff == null) { throw new Exception(strErrText); } List<SelectListItem> selectListStaff = new List<SelectListItem>(); selectListStaff.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListStaff.AddRange(from s in listStaff select new SelectListItem { Text = s.FullName, Value = s.Id.ToString() }); ViewData["Disposers"] = new SelectList(selectListStaff, "Value", "Text"); return View(model); }
public ActionResult ModifyPriceApproveStep(string id) { string strErrText; //读取价格审批步骤数据 FlowSystem flow = new FlowSystem(); ApproveFlowStep data = flow.LoadApproveFlowStep(long.Parse(id), LoginAccountId, LoginStaffName, out strErrText); if (data == null) { throw new Exception(strErrText); } //创建Model PriceApproveFlowStepViewModel model = new PriceApproveFlowStepViewModel(); model.StepNum = data.StepNum; model.StepName = data.StepName; model.DisposerId = data.DisposerId; model.ConditionExpression = data.ConditionExpression; model.Conditions = new List<PriceApproveFlowStepConditionViewModel>(); model.Conditions.Add(new PriceApproveFlowStepConditionViewModel()); //生成处理人下拉列表项 StaffSystem staff = new StaffSystem(); List<Staff> listStaff = staff.LoadStaffs(LoginAccountId, LoginStaffName, out strErrText); if (listStaff == null) { throw new Exception(strErrText); } List<SelectListItem> selectListStaff = new List<SelectListItem>(); selectListStaff.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListStaff.AddRange(from s in listStaff select new SelectListItem { Text = s.FullName, Value = s.Id.ToString() }); ViewData["Disposers"] = new SelectList(selectListStaff, "Value", "Text", model.DisposerId); return View(model); }
public JsonResult LoadStaffs() { string strErrText; StaffSystem staff = new StaffSystem(); List<Staff> listStaff = staff.LoadStaffs(LoginAccountId, LoginStaffName, out strErrText); if (listStaff == null) { throw new Exception(strErrText); } var ret = from s in listStaff orderby s.FullName select new { s.Id, s.FullName }; return Json(ret, JsonRequestBehavior.AllowGet); }
public ActionResult ExportStaffs() { string strErrText; //读取全部数据 StaffSystem staff = new StaffSystem(); List<Staff> listStaff = staff.LoadStaffs(LoginAccountId, LoginStaffName, out strErrText); if (listStaff == null) { throw new Exception(strErrText); } //生成GridView BoundField colStaffId = new BoundField(); colStaffId.HeaderText = InnoSoft.LS.Resources.Labels.StaffId; colStaffId.DataField = "StaffId"; BoundField colStaffName = new BoundField(); colStaffName.HeaderText = InnoSoft.LS.Resources.Labels.StaffName; colStaffName.DataField = "StaffName"; BoundField colSex = new BoundField(); colSex.HeaderText = InnoSoft.LS.Resources.Labels.Sex; colSex.DataField = "Sex"; BoundField colOrganFullName = new BoundField(); colOrganFullName.HeaderText = InnoSoft.LS.Resources.Labels.OrganName; colOrganFullName.DataField = "OrganFullName"; BoundField colPositionName = new BoundField(); colPositionName.HeaderText = InnoSoft.LS.Resources.Labels.PositionName; colPositionName.DataField = "PositionName"; BoundField colOfficeTel = new BoundField(); colOfficeTel.HeaderText = InnoSoft.LS.Resources.Labels.Tel; colOfficeTel.DataField = "OfficeTel"; BoundField colTelExt = new BoundField(); colTelExt.HeaderText = InnoSoft.LS.Resources.Labels.TelExt; colTelExt.DataField = "TelExt"; BoundField colFax = new BoundField(); colFax.HeaderText = InnoSoft.LS.Resources.Labels.Fax; colFax.DataField = "Fax"; BoundField colMobileTel1 = new BoundField(); colMobileTel1.HeaderText = InnoSoft.LS.Resources.Labels.MobileTel + "1"; colMobileTel1.DataField = "MobileTel1"; BoundField colMobileTel2 = new BoundField(); colMobileTel2.HeaderText = InnoSoft.LS.Resources.Labels.MobileTel + "2"; colMobileTel2.DataField = "MobileTel2"; BoundField colMobileTel3 = new BoundField(); colMobileTel3.HeaderText = InnoSoft.LS.Resources.Labels.MobileTel + "3"; colMobileTel3.DataField = "MobileTel3"; BoundField colEMail = new BoundField(); colEMail.HeaderText = InnoSoft.LS.Resources.Labels.EMail; colEMail.DataField = "EMail"; BoundField colQQ = new BoundField(); colQQ.HeaderText = InnoSoft.LS.Resources.Labels.QQ; colQQ.DataField = "QQ"; BoundField colBossName = new BoundField(); colBossName.HeaderText = InnoSoft.LS.Resources.Labels.BossName; colBossName.DataField = "BossName"; BoundField colIsOrganLeader = new BoundField(); colIsOrganLeader.HeaderText = InnoSoft.LS.Resources.Labels.IsOrganLeader; colIsOrganLeader.DataField = "IsOrganLeader"; BoundField colIsOrganManager = new BoundField(); colIsOrganManager.HeaderText = InnoSoft.LS.Resources.Labels.IsOrganManager; colIsOrganManager.DataField = "IsOrganManager"; var grid = new GridView(); grid.Columns.Add(colStaffId); grid.Columns.Add(colStaffName); grid.Columns.Add(colSex); grid.Columns.Add(colOrganFullName); grid.Columns.Add(colPositionName); grid.Columns.Add(colOfficeTel); grid.Columns.Add(colTelExt); grid.Columns.Add(colFax); grid.Columns.Add(colMobileTel1); grid.Columns.Add(colMobileTel2); grid.Columns.Add(colMobileTel3); grid.Columns.Add(colEMail); grid.Columns.Add(colQQ); grid.Columns.Add(colBossName); grid.Columns.Add(colIsOrganLeader); grid.Columns.Add(colIsOrganManager); grid.AutoGenerateColumns = false; grid.DataSource = from s in listStaff select new { StaffId = s.Id, StaffName = s.FullName, Sex = s.Sex, OrganFullName = s.OrganFullName, PositionName = s.PositionName, OfficeTel = s.OfficeTel, TelExt = s.TelExt, Fax = s.Fax, MobileTel1 = s.MobileTel1, MobileTel2 = s.MobileTel2, MobileTel3 = s.MobileTel3, EMail = s.EMail, QQ = s.QQ, BossName = s.BossStaffName, IsOrganLeader = s.IsOrganLeader ? InnoSoft.LS.Resources.Options.Yes : InnoSoft.LS.Resources.Options.No, IsOrganManager = s.IsOrganManager ? InnoSoft.LS.Resources.Options.Yes : InnoSoft.LS.Resources.Options.No }; grid.DataBind(); //导出GridView Response.ClearContent(); Response.Charset = InnoSoft.LS.Resources.Encoding.ExcelCharset; Response.ContentEncoding = System.Text.Encoding.GetEncoding(InnoSoft.LS.Resources.Encoding.ExcelContent); Response.ContentType = "application/ms-excel"; Response.Write("<meta http-equiv=Content-Type content=text/html charset=" + InnoSoft.LS.Resources.Encoding.ExcelCharset + ">"); Response.AddHeader("content-disposition", "attachment; filename=Staff.xls"); StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); grid.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); return View("SetStaff"); }
public ActionResult NewStaff() { string strErrText; //生成组织部门下拉列表项 OrganizationSystem organ = new OrganizationSystem(); List<Organization> listOrganization = organ.LoadOrganizations(LoginAccountId, LoginStaffName, out strErrText); if (listOrganization == null) { throw new Exception(strErrText); } List<SelectListItem> selectListOrganization = new List<SelectListItem>(); selectListOrganization.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListOrganization.AddRange(from o in listOrganization orderby o.FullName select new SelectListItem { Text = o.FullName, Value = o.Id.ToString() }); ViewData["Organizations"] = new SelectList(selectListOrganization, "Value", "Text"); //生成岗位下拉列表项 PositionSystem position = new PositionSystem(); List<Position> listPosition = position.LoadPositions(LoginAccountId, LoginStaffName, out strErrText); if (listPosition == null) { throw new Exception(strErrText); } List<SelectListItem> selectListPosition = new List<SelectListItem>(); selectListPosition.Add(new SelectListItem { Text = string.Empty, Value = string.Empty }); selectListPosition.AddRange(from p in listPosition select new SelectListItem { Text = p.Name, Value = p.Id.ToString() }); ViewData["Positions"] = new SelectList(selectListPosition, "Value", "Text"); //生成上司下拉列表项 StaffSystem staff = new StaffSystem(); List<Staff> listStaff = staff.LoadStaffs(LoginAccountId, LoginStaffName, out strErrText); if (listStaff == null) { throw new Exception(strErrText); } List<SelectListItem> selectListStaff = new List<SelectListItem>(); selectListStaff.Add(new SelectListItem { Text = string.Empty, Value = "0" }); selectListStaff.AddRange(from s in listStaff select new SelectListItem { Text = s.FullName, Value = s.Id.ToString() }); ViewData["Bosses"] = new SelectList(selectListStaff, "Value", "Text"); //创建空的Model StaffViewModel model = new StaffViewModel(); return View(model); }
public JsonResult LoadStaffsGrid(string sidx, string sord, int page, int rows) { //读取全部数据 string strErrText; StaffSystem staff = new StaffSystem(); List<Staff> listStaff = staff.LoadStaffs(LoginAccountId, LoginStaffName, out strErrText); if (listStaff == null) { throw new Exception(strErrText); } //提取当前页面数据 int nTotalRows = listStaff.Count; int nPageIndex = page; int nPageSize = rows; int nTotalPages = nTotalRows / nPageSize; if (nTotalRows % nPageSize > 0) nTotalPages++; string sortExpression = (sidx ?? "StaffId") + " " + (sord ?? "ASC"); var data = listStaff.OrderBy(sortExpression).Skip((nPageIndex - 1) * nPageSize).Take(nPageSize).ToList(); //生成表格数据 var ret = new { total = nTotalPages, page = nPageIndex, records = nTotalRows, rows = ( from s in data select new { id = s.Id, cell = new string[] { s.Id.ToString(), s.FullName, s.Sex, s.OrganFullName, s.PositionName, s.BossStaffName, s.OfficeTel, s.TelExt, s.MobileTel1, s.QQ } }).ToArray() }; return Json(ret, JsonRequestBehavior.AllowGet); }