// GET: BillPropertyModels/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BillPropertyModels billPropertyModels = db.BillProperties.Find(id); if (billPropertyModels == null) { return(HttpNotFound()); } List <CodeMethod> list = CodeMethod.GetCodeMethod(); List <SelectListItem> item = list.Select(c => new SelectListItem { Value = c.Id, Text = c.Description }).ToList(); foreach (var tmp in item) { if (billPropertyModels.CodeMethod == tmp.Text) { tmp.Selected = true; break; } } ViewBag.List = item; return(View(billPropertyModels)); }
/// <summary> /// 根据单据类型编号,生成单号 /// </summary> /// <param name="BillTypeNumber">单据类型编号,连接字符串</param> /// <returns>单号</returns> public static string GenerateBillNumber(string BillTypeNumber, string connString) { BonsaiiDbContext db = new BonsaiiDbContext(connString); BillPropertyModels tmp = db.BillProperties.Where(p => p.Type == BillTypeNumber).Single(); string date = DateTime.Now.ToString("yyyyMMdd"); //为流水号补充零 string SerialNumber = AddZero(tmp.Count, tmp.SerialNumber); //更新单号的计数值 tmp.Count++; db.Entry(tmp).State = EntityState.Modified; db.SaveChanges(); switch (tmp.CodeMethod) { case CodeMethod.One: return(DateTime.Now.ToString("yyyyMMdd").ToString() + SerialNumber); case CodeMethod.Two: return(DateTime.Now.ToString("yyyyMM").ToString() + SerialNumber); case CodeMethod.Three: return(tmp.Code.Substring(0, 10 - tmp.SerialNumber) + SerialNumber); default: return(""); } }
/// <summary> /// 根据单据类型编号,生成单号 /// </summary> /// <param name="BillTypeNumber">单据类型编号</param> /// <returns>单号</returns> public string GenerateBillNumber(string BillTypeNumber) { BillPropertyModels tmp = db.BillProperties.Where(p => p.Type == BillTypeNumber).Single(); string date = DateTime.Now.ToString("yyMMdd"); //为流水号补充零 string SerialNumber = AddZero(tmp.Count, tmp.SerialNumber); //更新单号的计数值 tmp.Count++; db.Entry(tmp).State = EntityState.Modified; try { db.SaveChanges(); } catch (System.Data.SqlClient.SqlException e) { throw e; } switch (tmp.CodeMethod) { case CodeMethod.Day: return(DateTime.Now.ToString("yyMMdd").ToString() + SerialNumber); case CodeMethod.Month: return(DateTime.Now.ToString("yyMM").ToString() + SerialNumber); case CodeMethod.Serial: return(tmp.Code.Substring(0, 10 - tmp.SerialNumber) + SerialNumber); default: return(""); } }
// GET: Recruitments/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Recruitments recruitments = db.Recruitments.Find(id); if (recruitments == null) { return(HttpNotFound()); } BillPropertyModels bill = db.BillProperties.Where(b => b.Type.Equals(recruitments.BillType)).SingleOrDefault(); recruitments.BillType = recruitments.BillType + " " + bill.TypeName; /*查找预留字段(value)*/ var fieldValueList = (from rr in db.RecruitmentReserves join rf in db.ReserveFields on rr.FieldId equals rf.Id where rr.Number == recruitments.Id select new RecruitmentViewModel { Id = rr.Number, Description = rf.Description, Value = rr.Value }).ToList(); ViewBag.fieldValueList = fieldValueList; return(View(recruitments)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TrainStart trainStart = db.TrainStarts.Find(id); if (trainStart == null) { return(HttpNotFound()); } BillPropertyModels bill = db.BillProperties.Where(b => b.Type.Equals(trainStart.BillTypeNumber)).SingleOrDefault(); trainStart.BillTypeNumber = trainStart.BillTypeNumber + " " + bill.TypeName; trainStart.JoinPerson = trainStart.JoinPerson.Replace("multiselect-all,", ""); trainStart.ChoosePerson = trainStart.ChoosePerson.Replace("multiselect-all,", ""); /*查找预留字段(value)*/ var fieldValueList = (from tsr in db.TrainStartReserves join rf in db.ReserveFields on tsr.FieldId equals rf.Id where tsr.Number == trainStart.Id select new TrainStartViewModel { Id = tsr.Number, Description = rf.Description, Value = tsr.Value }).ToList(); ViewBag.fieldValueList = fieldValueList; return(View(trainStart)); }
public ActionResult DeleteConfirmed(int id) { BillPropertyModels billPropertyModels = db.BillProperties.Find(id); db.BillProperties.Remove(billPropertyModels); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(BillPropertyModels billPropertyModels) { if (ModelState.IsValid) { switch (billPropertyModels.CodeMethod) { case CodeMethod.Month: billPropertyModels.Year = 2; billPropertyModels.Month = 2; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 6; break; case CodeMethod.Serial: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = this.GetSerialNumbers(billPropertyModels.Code); break; case CodeMethod.Manual: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 0; break; default: billPropertyModels.Year = 2; billPropertyModels.Month = 2; billPropertyModels.Day = 2; billPropertyModels.SerialNumber = 4; break; } db.Entry(billPropertyModels).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } List <CodeMethod> list = CodeMethod.GetBillType(); List <SelectListItem> item = list.Select(c => new SelectListItem { Value = c.Id, Text = c.Description }).ToList(); foreach (var tmp in item) { if (billPropertyModels.CodeMethod == tmp.Text) { tmp.Selected = true; break; } } ViewBag.List = item; return(View(billPropertyModels)); }
// GET: BillPropertyModels/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BillPropertyModels billPropertyModels = db.BillProperties.Find(id); if (billPropertyModels == null) { return(HttpNotFound()); } return(View(billPropertyModels)); }
public ActionResult Create(BillPropertyModels billPropertyModels) { if (ModelState.IsValid) { switch (billPropertyModels.CodeMethod) { case CodeMethod.Two: billPropertyModels.Year = 4; billPropertyModels.Month = 2; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 4; break; case CodeMethod.Three: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 10; break; case CodeMethod.Four: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 0; break; default: billPropertyModels.Year = 4; billPropertyModels.Month = 2; billPropertyModels.Day = 2; billPropertyModels.SerialNumber = 2; break; } db.BillProperties.Add(billPropertyModels); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(billPropertyModels)); }
// GET: Recruitments/Edit/5 public ActionResult Edit(int id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Recruitments recruitments = db.Recruitments.Find(id); if (recruitments == null) { return(HttpNotFound()); } BillPropertyModels bill = db.BillProperties.Where(b => b.Type.Equals(recruitments.BillType)).SingleOrDefault(); ViewBag.BillType = recruitments.BillType + " " + bill.TypeName; ViewBag.BillCode = recruitments.BillCode; ViewBag.DepartmentsList = new SelectList(db.Departments.ToList(), "Name", "Name", recruitments.DepartmentName); ViewBag.PositionsList = new SelectList(this.GetParamsListByName("员工岗位"), recruitments.Position);//this.GetParamsByName("员工岗位"); ViewBag.RequiredNumber = recruitments.RequiredNumber.ToString(); ViewBag.GendersList = new MultiSelectList(this.GetParamsListByName("性别"), this.SelectedListByName(recruitments.Gender)); ViewBag.Age = recruitments.Age.ToString(); ViewBag.MaritalStatusList = new MultiSelectList(this.GetParamsListByName("婚姻状况"), this.SelectedListByName(recruitments.MaritalStatus)); ViewBag.EduBackgroundsList = new MultiSelectList(this.GetParamsListByName("学历"), this.SelectedListByName(recruitments.EducationBackground)); ViewBag.MajorsList = new MultiSelectList(this.GetParamsListByName("专业"), this.SelectedListByName(recruitments.Major)); ViewBag.WorkExperience = recruitments.WorkExperience; ViewBag.Skill = recruitments.Skill; ViewBag.Others = recruitments.Others; ViewBag.Status = recruitments.Status; /*查找预留字段(value)*/ var fieldValueList = (from rr in db.RecruitmentReserves join rf in db.ReserveFields on rr.FieldId equals rf.Id where rr.Number == id select new RecruitmentViewModel { Description = rf.Description, Value = rr.Value }).ToList(); ViewBag.fieldValueList = fieldValueList; return(View()); }
public ActionResult Edit([Bind(Include = "Id,Type,TypeName,TypeFullName,CodeMethod,Year,Month,Day,SerialNumber,Code,IsAutoAudit,IsApprove,IsLimitInput,IsAscOrDesc")] BillPropertyModels billPropertyModels) { if (ModelState.IsValid) { switch (billPropertyModels.CodeMethod) { case CodeMethod.Two: billPropertyModels.Year = 4; billPropertyModels.Month = 2; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 4; break; case CodeMethod.Three: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 10; break; case CodeMethod.Four: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 0; break; default: billPropertyModels.Year = 4; billPropertyModels.Month = 2; billPropertyModels.Day = 2; billPropertyModels.SerialNumber = 2; break; } db.Entry(billPropertyModels).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(billPropertyModels)); }
public ActionResult Create(BillPropertyModels billPropertyModels) { if (ModelState.IsValid) { switch (billPropertyModels.CodeMethod) { case CodeMethod.Month: billPropertyModels.Year = 2; billPropertyModels.Month = 2; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 6; break; case CodeMethod.Serial: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = this.GetSerialNumbers(billPropertyModels.Code); break; case CodeMethod.Manual: billPropertyModels.Year = 0; billPropertyModels.Month = 0; billPropertyModels.Day = 0; billPropertyModels.SerialNumber = 0; break; default: billPropertyModels.Year = 2; billPropertyModels.Month = 2; billPropertyModels.Day = 2; billPropertyModels.SerialNumber = 4; break; } //获取单据的编号值 BillSort tmpBillSort = db.BillSorts.Find(billPropertyModels.BillSort); string num = tmpBillSort.SerialNumber.ToString(); if (num.Length == 1) { num = num.Insert(0, "0"); } //更新BillSort表中某一类型单据可用的最大编号值 tmpBillSort.SerialNumber += 2; db.Entry(tmpBillSort).State = EntityState.Modified; //拼凑出真实的单据性质编号(单据的类型编号+单据的可用最大编号值) billPropertyModels.Type = billPropertyModels.BillSort + num; db.BillProperties.Add(billPropertyModels); db.SaveChanges(); return(RedirectToAction("Index")); } List <CodeMethod> list = CodeMethod.GetBillType(); List <SelectListItem> item = list.Select(c => new SelectListItem { Value = c.Id, Text = c.Description }).ToList(); ViewBag.List = item; ViewBag.BillSortList = BillSortMethod.GetBillSortMethod(base.ConnectionString); return(View(billPropertyModels)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TrainStart trainStart = db.TrainStarts.Find(id); if (trainStart == null) { return(HttpNotFound()); } var temp = (from p in db.StaffParamTypes where p.Name == "培训类型" select p.Id).FirstOrDefault(); List <SelectListItem> item = (from p in db.StaffParams where p.StaffParamTypeId == temp select p).ToList().Select(c => new SelectListItem { Value = c.Value, //保存的值 Text = c.Value //显示的值 }).ToList(); SelectListItem i = new SelectListItem(); i.Value = ""; i.Text = "-请选择-"; i.Selected = true; item.Add(i); ViewBag.List = item; List <SelectListItem> staff = (from s in db.Staffs join d in db.Departments on s.Department equals d.DepartmentId select new { StaffNumber = s.StaffNumber, StaffName = s.Name, StaffDepartment = d.Name, StaffPosition = s.Position }).ToList().Select(s => new SelectListItem { Text = s.StaffNumber + "-" + s.StaffName + "-" + s.StaffDepartment + "-" + s.StaffPosition, Value = s.StaffNumber + "-" + s.StaffName + "-" + s.StaffDepartment + "-" + s.StaffPosition }).ToList(); ViewBag.staff = staff; List <string> staff1 = (from s in db.Staffs join d in db.Departments on s.Department equals d.DepartmentId select s.StaffNumber + "-" + s.Name + "-" + d.Name + "-" + s.Position).ToList(); ViewBag.join = new MultiSelectList(staff1, this.SelectedListByName(trainStart.JoinPerson)); ViewBag.choose = new MultiSelectList(staff1, this.SelectedListByName(trainStart.ChoosePerson)); ViewBag.BillTypeNumber = trainStart.BillTypeNumber + " " + trainStart.BillTypeName; ViewBag.BillNumber = trainStart.BillNumber; ViewBag.TrainType = trainStart.TrainType; ViewBag.StartDate = trainStart.StartDate.ToString(); ViewBag.EndDate = trainStart.EndDate.ToString(); ViewBag.TrainCost = trainStart.TrainCost; ViewBag.TellNumber = trainStart.TellNumber; ViewBag.Remark = trainStart.Remark; ViewBag.TrainTheme = trainStart.TrainTheme; ViewBag.TrainPlace = trainStart.TrainPlace; ViewBag.TrainPerson = trainStart.TrainPerson; ViewBag.TrainManage = trainStart.TrainManage; ViewBag.TrainContent = trainStart.TrainContent; BillPropertyModels bill = db.BillProperties.Where(b => b.Type.Equals(trainStart.BillTypeNumber)).SingleOrDefault(); trainStart.BillTypeNumber = trainStart.BillTypeNumber + " " + bill.TypeName; /*查找预留字段(value)*/ var fieldValueList = (from tsr in db.TrainStartReserves join rf in db.ReserveFields on tsr.FieldId equals rf.Id where tsr.Number == id select new TrainStartViewModel { Description = rf.Description, Value = tsr.Value }).ToList(); ViewBag.fieldValueList = fieldValueList; return(View()); }