// 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());
}
