public ActionResult WorkListInfo() { int pid = CommonMethod.GetInt(Request["pid"]); var projectName = ""; if (pid != 0) { var model = ProjectManageDBOperate.GetModelById(pid); if (model != null) { projectName = "->[" + model.Name + "/" + model.FullName + "]"; } } ViewBag.ProjectName = projectName; ViewBag.ProjectId = pid; var user = CookieOperate.AccountCookie; ViewBag.Project = ProjectManageDBOperate.GetList(0, user.AccountId).Select(a => new SelectListItem() { Value = a.Id.ToString(), Text = a.Name + "-" + a.FullName }); //ViewBag.Member = CustomerMemberDBOperate.GetList(user.CompanyId).Select(a => new SelectListItem() { Value = a.Id.ToString(), Text = a.Name }); //ViewBag.WorkListStatus = CommonMethod.GetEnumItems<WorkListStatusEnum>().Select(a => new SelectListItem() { Value = a.Key.ToString(), Text = a.Value }); return(View()); }
public JsonResult WorkListInfoEdit(string str, int projectId, string name, int id) { ResultInfo result = new ResultInfo(); var account = CookieOperate.AccountCookie; var list = JsonConvert.DeserializeObject <List <WorkListEdit> >(str); var project = ProjectManageDBOperate.GetModelById(projectId); var cusMember = CustomerMemberDBOperate.GetModelById(account.AccountId); var workList = new WorkList() { ProjectId = projectId, ProjectName = project.Name, CompanyId = CommonMethod.GetInt(ConfigSetting.eeeYoooId), CompanyName = ConfigSetting.eeeYoooName, CusMemberId = account.AccountId, CusCompanyId = cusMember.CusCompanyId, Name = name, Id = id, Status = WorkListStatusEnum.NotStart.ToString(), Guid = Guid.NewGuid().ToString(), CreateBy = account.AccountName }; var flag = WorkListBLL.AddWorkList(workList, list); if (flag) { result.Message = "操作成功"; result.IsSuccess = true; } else { result.Message = "操作成功"; } return(Json(result)); }
public JsonResult ProjectManageList(QueryBase query) { string payway = CommonMethod.GetString(Request["PayWay"]); string status = CommonMethod.GetString(Request["Status"]); query.CusMemberId = CookieOperate.AccountCookie.AccountId; var totalcount = 0; var list = ProjectManageDBOperate.GetPagerList(query, payway, status, out totalcount); var payways = CommonMethod.GetEnumItems <ProjectPayWayEnum>(); var statuss = CommonMethod.GetEnumItems <ProjectStatusEnum>(); var operate = CommonMethod.GetIntEnumItems <OpereateTypeEnum>(); var dev = CommonMethod.GetIntEnumItems <DevTypeEnum>(); list.ForEach(a => { a.StatusTxt = statuss.FirstOrDefault(b => b.Key == a.Status).Value; a.PayWayTxt = payways.FirstOrDefault(b => b.Key == a.PayWay).Value; var o = operate.FirstOrDefault(b => b.Key == a.OpereateType); if (!string.IsNullOrEmpty(o.Value)) { a.OpereateTypeTxt = o.Value; } var d = operate.FirstOrDefault(b => b.Key == a.DevType); if (!string.IsNullOrEmpty(d.Value)) { a.DevTypeTxt = d.Value; } }); PagerList <ProjectManage> pagerList = new PagerList <ProjectManage>(); pagerList.rows = list; pagerList.total = totalcount; return(Json(pagerList)); }
public JsonResult ProjectManageGetModel(int id) { ResultInfo <ProjectManage> info = new ResultInfo <ProjectManage>(); var data = ProjectManageDBOperate.GetModelById(id); info.Data = data; return(Json(info)); }
public JsonResult ProjectManageDelete(int id, int IsDeleted) { ResultInfo info = new ResultInfo(); var flag = false; flag = ProjectManageDBOperate.DeleteProjectManage(new ProjectManage() { ModifyBy = CookieOperate.AccountCookie.Mobile, Id = id, IsDeleted = IsDeleted }); if (flag) { info.Message = "删除成功"; info.IsSuccess = true; } return(Json(info)); }
public static bool CreateBill(PayVoucherCreateModel model) { var project = ProjectManageDBOperate.GetModelById(model.ProjectId); var res = CreateBillDetail(model); #region 账单信息填充 var bill = res.Item1; bill.ProjectName = project.Name; bill.ProjectId = project.Id; bill.CusCompanyId = project.CusCompanyId; bill.CusMemberId = project.CusMemberId; #endregion #region 账单详情 var billDetail = res.Item2; billDetail.ForEach(a => { a.ProjectName = bill.ProjectName; a.CusCompanyId = bill.CusCompanyId; a.CusMemberId = bill.CusMemberId; }); #endregion return(BillDBOperate.AddBill(bill, billDetail)); }
public JsonResult ProjectManageAddModel(ProjectManage model) { ResultInfo info = new ResultInfo(); var flag = false; var user = CookieOperate.AccountCookie; var cusMember = CustomerMemberDBOperate.GetModelById(user.AccountId); model.CusCompanyId = cusMember.CusCompanyId; model.FullName = model.Name; model.EndTime = DateTime.MaxValue; model.CusMemberId = user.AccountId; model.PayWay = ProjectPayWayEnum.UnKnown.ToString(); model.Status = ProjectStatusEnum.NotStart.ToString(); model.CreateBy = user.Mobile; model.CreateDate = DateTime.Now; model.RelStartTime = model.StartTime; model.RelEndTime = model.EndTime; model.LastPayDate = model.EndTime; model.CompanyId = CommonMethod.GetInt(ConfigSetting.eeeYoooId); model.Source = SourceEnum.PC.ToString(); if (model.Id <= 0) { flag = ProjectManageDBOperate.AddProjectManage(model); info.IsSuccess = flag; if (flag) { info.Message = "保存成功"; } } else { flag = ProjectManageDBOperate.ModifyProjectManage(model); info.IsSuccess = flag; if (flag) { info.Message = "保存成功"; } } return(Json(info)); }
public static bool ImportExcel(DataTable dt, CompanyUser user, int projectId, string status, out string message) { message = string.Empty; try { //工单名称 var workName = dt.Columns[1].ColumnName.Trim(); var project = ProjectManageDBOperate.GetModelById(projectId); if (project == null) { message = "项目编号有误,请核实"; return(false); } var guid = Guid.NewGuid().ToString(); if (WorkListDBOperate.GetCountByName(workName) > 0) { message = "工单名称已存在,请重新编辑"; return(false); } WorkList work = new WorkList() { Name = workName, CreateBy = user.UserName, CreateDate = DateTime.Now, Length = 0, Status = status, CompanyId = user.CompanyId, CompanyName = user.CompanyName, ProjectId = projectId, ProjectName = project.Name, CusCompanyId = project.CusCompanyId, CusMemberId = project.CusMemberId, Guid = guid, }; var list = new List <WorkListDetail>(); for (int i = 1; i < dt.Rows.Count; i++) { var dr = dt.Rows[i]; var detail = new WorkListDetail() { Infos = dr[1].ToString().Trim(), RoleCode = dr[0].ToString(), //== "消费者" ? DetailRole.Customer.ToString() : DetailRole.Admin.ToString(), CreateBy = user.UserName, WorkId = guid, Index = i, Guid = Guid.NewGuid().ToString() }; if (string.IsNullOrEmpty(detail.Infos)) { continue; } else if (detail.Infos.Length > 100) { message += (i + 2).ToString() + ","; } list.Add(detail); } if (!string.IsNullOrEmpty(message)) { message = "数据第[" + message.Substring(0, message.Length - 1) + "]条内容字数超过100字"; return(false); } return(WorkListDBOperate.Import(work, list, out message)); } catch (Exception ex) { message = ex.Message; } return(false); }