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));
}
/// <summary>
/// 发起培训并且审核通过之后，执行此函数
/// </summary>
/// <param name="?"></param>
public void TrainStartPassAudit(TrainStart trainStart)
{
//string joinperson = Request["JoinPerson"];
//string[] personInfo = joinperson.Split(',');
string[] personInfo = trainStart.JoinPerson.Split(',');
DateTime time = Convert.ToDateTime(trainStart.StartDate.ToShortDateString());
for (; time <= trainStart.EndDate; time = time.AddDays(1))
{
for (int temp2 = 0; temp2 < personInfo.Count(); temp2++)
{
// string[] person = personInfo[temp2].Split('-');
string[] person = personInfo[temp2].Split('-', '<', '>');
TrainRecord trainrecord = new TrainRecord();
trainrecord.BillNumber = trainStart.BillNumber;
trainrecord.StaffNumber = person[0];
trainrecord.StaffName = person[1];
trainrecord.Tag = false;
trainrecord.Time = time.ToShortDateString();
trainrecord.BillTypeNumber = trainStart.BillTypeNumber;
trainrecord.TrainId = trainStart.Id;
db.TrainRecords.Add(trainrecord);
db.SaveChanges();
}
}
}
public ActionResult DeleteConfirmed(int id)
{
TrainStart trainStart = db.TrainStarts.Find(id);
db.TrainStarts.Remove(trainStart);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,BillTypeNumber,BillTypeName,BillNumber,TrainType,StartDate,EndDate,TrainCost,TellNumber,AuditStatus,Remark")] TrainStart trainStart)
{
if (ModelState.IsValid)
{
db.Entry(trainStart).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(trainStart));
}
public ActionResult Create(TrainStart trainStart)
{
if (ModelState.IsValid)
{
db.TrainStarts.Add(trainStart);
db.SaveChanges();
/**/
return(RedirectToAction("Index"));
}
return(View(trainStart));
}
// GET: TrainStart/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TrainStart trainStart = db.TrainStarts.Find(id);
if (trainStart == null)
{
return(HttpNotFound());
}
return(View(trainStart));
}
public ActionResult Edit(TrainStart trainStart)
{
if (ModelState.IsValid)
{
TrainStart train = db.TrainStarts.Find(trainStart.Id);
train.BillTypeNumber = trainStart.BillTypeNumber.Substring(0, 4);
train.TrainType = trainStart.TrainType;
train.StartDate = trainStart.StartDate;
train.EndDate = trainStart.EndDate;
train.TrainCost = trainStart.TrainCost;
train.TellNumber = trainStart.TellNumber;
train.Remark = trainStart.Remark;
train.TrainTheme = trainStart.TrainTheme;
train.TrainPlace = trainStart.TrainPlace;
train.TrainPerson = trainStart.TrainPerson;
train.ChoosePerson = Request["ChoosePerson"];
train.TrainManage = trainStart.TrainManage;
train.JoinPerson = Request["JoinPerson"];
train.TrainContent = trainStart.TrainContent;
train.ChangePerson = this.Name;
train.ChangeTime = DateTime.Now;
db.SaveChanges();
/*查找预留字段(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.Id, Description = rf.Description, Value = tsr.Value
}).ToList();
/*给预留字段赋值*/
foreach (var temp in fieldValueList)
{
TrainStartReserve rr = db.TrainStartReserves.Find(temp.Id);
rr.Value = Request[temp.Description];
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(trainStart));
}
public ActionResult Submit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TrainStart staffSkill = db.TrainStarts.Find(id);
if (staffSkill == null)
{
return(HttpNotFound());
}
//提交审批
byte status = AuditApplicationStaffSkill(staffSkill);
//需要对原表做出的修改
staffSkill.AuditStatus = status;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
/*Step1：删除预留字段*/
var item = (from tsr in db.TrainStartReserves
where tsr.Number == id
select new TrainStartViewModel {
Id = tsr.Id
}).ToList();
foreach (var temp in item)
{
TrainStartReserve tsr = db.TrainStartReserves.Find(temp.Id);
db.TrainStartReserves.Remove(tsr);
}
db.SaveChanges();
/*Step2：删除固定字段*/
TrainStart trainStart = db.TrainStarts.Find(id);
db.TrainStarts.Remove(trainStart);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ManualAudit(int?id, int flag)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TrainStart trainStart = db.TrainStarts.Find(id);
if (trainStart == null)
{
return(HttpNotFound());
}
//手动审批；这部分是自己给自己审批
//需要对原表做出的修改
try
{
if (flag == 1)
{
//通过审批
trainStart.AuditStatus = 3;
TrainStartPassAudit(trainStart);
}
else
{
//不通过审批
trainStart.AuditStatus = 4;
}
trainStart.AuditPerson = this.UserName;
trainStart.AuditTime = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
}
public static void ReturnStatus(int auditProcessAId, byte status, string userName)
{
UserModels user = (from u in sdb.Users where u.UserName == userName select u).FirstOrDefault();
BonsaiiDbContext db = new BonsaiiDbContext(user.ConnectionString);
AuditApplication application = db.AuditApplications.Find(auditProcessAId);//修改Application的状态
application.State = status;
string btype = application.BType.Substring(0, 2);
switch (btype)
{
case "21":
{ //员工
Staff someone = (from p in db.Staffs where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status; //已审
SystemDbContext sysdb = new SystemDbContext();
/*BindCodes*/
var Ucount = (from p in sysdb.BindCodes where (p.CompanyId == user.CompanyId && p.StaffNumber == someone.StaffNumber) select p).ToList();
if (Ucount.Count == 0)
{ //木有该员工
BindCode user1 = new BindCode();
string CompanyDbName = "Bonsaii" + user1.CompanyId;
user1.ConnectionString = ConfigurationManager.AppSettings["UserDbConnectionString"] + CompanyDbName + ";"; //"Data Source = localhost,1433;Network Library = DBMSSOCN;Initial Catalog = " + CompanyDbName + ";User ID = test;Password = admin;";
user1.CompanyId = user1.CompanyId;
user1.StaffNumber = someone.StaffNumber;
user1.RealName = someone.Name;
user1.BindingCode = someone.BindingCode;
user1.Phone = someone.IndividualTelNumber;
user1.BindTag = false;
user1.LastTime = DateTime.Now;
user1.IsAvail = true;
sysdb.BindCodes.Add(user1);
sysdb.SaveChanges();
}
db.SaveChanges();
Push(someone.StaffNumber, user.CompanyId, status);
}
} break;
case "22":
{ //变更
StaffChange someone = (from p in db.StaffChanges where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.Name = someone.Name;
staff.Gender = someone.Gender;
staff.Department = someone.Department;
staff.WorkType = someone.WorkType;
staff.Position = someone.Position;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Nationality = someone.Nationality;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Entrydate = someone.Entrydate;
staff.ClassOrder = someone.ClassOrder;
staff.ApplyOvertimeSwitch = staff.ApplyOvertimeSwitch;
staff.JobState = someone.JobState;
staff.AbnormalChange = someone.AbnormalChange;
staff.FreeCard = someone.FreeCard;
staff.WorkProperty = someone.WorkProperty;
staff.WorkType = someone.WorkType;
staff.Source = someone.Source;
staff.QualifyingPeriodFull = someone.QualifyingPeriodFull;
staff.MaritalStatus = someone.MaritalStatus;
staff.BirthDate = someone.BirthDate;
staff.NativePlace = someone.NativePlace;
staff.HealthCondition = someone.HealthCondition;
staff.Nation = someone.Nation;
staff.Address = someone.Address;
staff.VisaOffice = someone.VisaOffice;
staff.HomeTelNumber = someone.HomeTelNumber;
staff.EducationBackground = someone.EducationBackground;
staff.GraduationSchool = someone.GraduationSchool;
staff.SchoolMajor = someone.SchoolMajor;
staff.Degree = someone.SchoolMajor;
staff.Introducer = someone.Introducer;
staff.IndividualTelNumber = someone.IndividualTelNumber;
staff.BankCardNumber = someone.BankCardNumber;
staff.UrgencyContactMan = someone.UrgencyContactMan;
staff.UrgencyContactAddress = someone.UrgencyContactAddress;
staff.UrgencyContactPhoneNumber = someone.UrgencyContactPhoneNumber;
staff.PhysicalCardNumber = someone.PhysicalCardNumber;
staff.LeaveDate = someone.LeaveDate;
staff.LeaveType = someone.LeaveType;
staff.LeaveReason = someone.LeaveReason;
staff.AuditStatus = someone.AuditStatus;
staff.HealthCondition = someone.HealthCondition;
staff.ChangeTime = someone.RecordTime;
staff.ChangePerson = someone.RecordPerson;
staff.AuditTime = DateTime.Now;
staff.AuditPerson = userName;
staff.Head = someone.Head;
staff.LogicCardNumber = someone.LogicCardNumber;
staff.HeadType = someone.HeadType;
staff.IDCardNumber = someone.IDCardNumber;
staff.DeadlineDate = someone.DeadlineDate;
}
db.SaveChanges();
Push(someone.StaffNumber, user.CompanyId, status);
}
}
break;
case "23":
{ //离职
StaffApplication someone = (from p in db.StaffApplications where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{ //审核通过就在Staff里面把标志置为1
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.ArchiveTag = true; //true 代表离职
staff.BindingCode = null;
//要把信息写到离职档案中
StaffArchive staffArchive = new StaffArchive();
staffArchive.BillTypeNumber = someone.BillTypeNumber;
staffArchive.BillTypeName = someone.BillTypeName;
staffArchive.BillNumber = someone.BillNumber;
staffArchive.StaffNumber = staff.StaffNumber;
staffArchive.StaffName = staff.Name;
staffArchive.LeaveDate = someone.HopeLeaveDate;
staffArchive.Department = (from p in db.Departments where p.DepartmentId == staff.Department select p.Name).ToList().FirstOrDefault();
staffArchive.IdenticationNumber = staff.IdentificationNumber;
staffArchive.RecordPerson = staff.RecordPerson;
staffArchive.RecordTime = staff.RecordTime;
staffArchive.BlackList = false;
staffArchive.WorkPlus = false;
staff.ArchiveTag = true; //true 代表离职
db.StaffArchives.Add(staffArchive); //Users表中离职；
//修改系统表
SystemDbContext sysdb = new SystemDbContext();
var Ucount = (from p in sysdb.BindCodes where (p.CompanyId == user.CompanyId && p.StaffNumber == someone.StaffNumber) select p).SingleOrDefault();
if (Ucount != null)
{
sysdb.BindCodes.Remove(Ucount);
sysdb.SaveChanges();
}
db.SaveChanges();
Push(someone.StaffNumber, user.CompanyId, status);
}
}
}
break;
case "24":
{ //技能
StaffSkill someone = (from p in db.StaffSkills where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "25":
{ //招聘
Recruitments someone = (from p in db.Recruitments where (p.BillCode == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
}
break;
case "26":
{ //培训
TrainStart someone = (from p in db.TrainStarts where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
}
break;
case "27":
{ //合同
Contract someone = (from p in db.Contracts where (p.BillNumber == application.BNumber) && (p.BillTypeNumber == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status; //已审
}
} break;
case "31":
{ //出差
EvectionApplies someone = (from p in db.EvectionApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "32":
{ //请假
VacateApplies someone = (from p in db.VacateApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "33":
{ //加班
OvertimeApplies someone = (from p in db.OvertimeApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
OvertimeApplies correct = db.OvertimeApplies.Find(someone.Id);
correct.AuditPerson = someone.AuditPerson;
correct.AuditStatus = status;
correct.AuditStatusName = someone.AuditStatusName;
correct.AuditTime = someone.AuditTime;
correct.BillNumber = someone.BillNumber;
correct.BillType = someone.BillType;
correct.Date = someone.Date;
correct.EndDateTime = someone.EndDateTime;
correct.Hours = someone.Hours;
correct.IsRead = someone.IsRead;
correct.Reason = someone.Reason;
correct.Remark = someone.Remark;
correct.StaffNumber = someone.StaffNumber;
correct.StartDateTime = someone.StartDateTime;
db.SaveChanges();
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "34":
{ //签卡
ChargeCardApplies someone = (from p in db.ChargeCardApplies where (p.BillNumber == application.BNumber) && (p.BillType == p.BillType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "35":
{ //调休
DaysOffApplies someone = (from p in db.DaysOffApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "36":
{ //异地
VacateApplies someone = (from p in db.VacateApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "37":
{ //值班
OnDutyApplies someone = (from p in db.OnDutyApplies where (p.BillNumber == application.BNumber) && (p.BillType == application.BType) select p).ToList().SingleOrDefault();
if (someone != null)
{
someone.AuditStatus = status;
}
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
default:
break;
}
switch (btype)
{
case "27":
{ //合同
Contract someone = (from p in db.Contracts where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status; //已审
} break;
case "21":
{ //员工
Staff someone = (from p in db.Staffs where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status; //已审
} break;
case "24":
{ //技能
StaffSkill someone = (from p in db.StaffSkills where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
}
break;
case "26":
{ //培训
TrainStart someone = (from p in db.TrainStarts where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
}
break;
case "23":
{ //离职
StaffApplication someone = (from p in db.StaffApplications where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{ //审核通过就在Staff里面把标志置为1
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.ArchiveTag = true; //true 代表离职
//要把信息写到离职档案中
StaffArchive staffArchive = new StaffArchive();
staffArchive.BillTypeNumber = someone.BillTypeNumber;
staffArchive.BillTypeName = someone.BillTypeName;
staffArchive.StaffNumber = staff.StaffNumber;
staffArchive.StaffName = staff.Name;
staffArchive.Department = staff.Department;
staffArchive.IdenticationNumber = staff.IdentificationNumber;
staffArchive.RecordPerson = staff.RecordPerson;
staffArchive.RecordTime = staff.RecordTime;
staffArchive.BillNumber = Generate.GenerateBillNumber(staffArchive.BillTypeNumber, user.ConnectionString);
db.StaffArchives.Add(staffArchive);
db.SaveChanges();
}
}
break;
case "22":
{ //变更
StaffChange someone = (from p in db.StaffChanges where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
if (someone.AuditStatus == 3)
{
var staffId = (from p in db.Staffs where p.StaffNumber == someone.StaffNumber && p.ArchiveTag != true select p.Number).ToList().FirstOrDefault();
Staff staff = db.Staffs.Find(staffId);
staff.Name = someone.Name;
staff.Gender = someone.Gender;
staff.Department = someone.Department;
staff.WorkType = someone.WorkType;
staff.Position = someone.Position;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Nationality = someone.Nationality;
staff.IdentificationNumber = someone.IdentificationNumber;
staff.Entrydate = someone.Entrydate;
staff.ClassOrder = someone.ClassOrder;
staff.ApplyOvertimeSwitch = staff.ApplyOvertimeSwitch;
staff.JobState = someone.JobState;
staff.AbnormalChange = someone.AbnormalChange;
staff.FreeCard = someone.FreeCard;
staff.WorkProperty = someone.WorkProperty;
staff.WorkType = someone.WorkType;
staff.Source = someone.Source;
staff.QualifyingPeriodFull = someone.QualifyingPeriodFull;
staff.MaritalStatus = someone.MaritalStatus;
staff.BirthDate = someone.BirthDate;
staff.NativePlace = someone.NativePlace;
staff.HealthCondition = someone.HealthCondition;
staff.Nation = someone.Nation;
staff.Address = someone.Address;
staff.VisaOffice = someone.VisaOffice;
staff.HomeTelNumber = someone.HomeTelNumber;
staff.EducationBackground = someone.EducationBackground;
staff.GraduationSchool = someone.GraduationSchool;
staff.SchoolMajor = someone.SchoolMajor;
staff.Degree = someone.SchoolMajor;
staff.Introducer = someone.Introducer;
staff.IndividualTelNumber = someone.IndividualTelNumber;
staff.BankCardNumber = someone.BankCardNumber;
staff.UrgencyContactMan = someone.UrgencyContactMan;
staff.UrgencyContactAddress = someone.UrgencyContactAddress;
staff.UrgencyContactPhoneNumber = someone.UrgencyContactPhoneNumber;
staff.PhysicalCardNumber = someone.PhysicalCardNumber;
staff.LeaveDate = someone.LeaveDate;
staff.LeaveType = someone.LeaveType;
staff.LeaveReason = someone.LeaveReason;
staff.AuditStatus = someone.AuditStatus;
staff.HealthCondition = someone.HealthCondition;
staff.ChangeTime = someone.RecordTime;
staff.ChangePerson = someone.RecordPerson;
staff.AuditTime = DateTime.Now;
staff.AuditPerson = user.Name;
staff.Head = someone.Head;
staff.LogicCardNumber = someone.LogicCardNumber;
staff.HeadType = someone.HeadType;
staff.IDCardNumber = someone.IDCardNumber;
staff.DeadlineDate = someone.DeadlineDate;
}
db.SaveChanges();
}
break;
case "33":
{ //加班
OvertimeApplies someone = (from p in db.OvertimeApplies where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "32":
{ //请假
VacateApplies someone = (from p in db.VacateApplies where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "34":
{ //请假
ChargeCardApplies someone = (from p in db.ChargeCardApplies where p.BillNumber == application.BNumber select p).ToList().SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "31":
{ //出差
EvectionApplies someone = (from p in db.EvectionApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "35":
{ //出差
DaysOffApplies someone = (from p in db.DaysOffApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "36":
{ //出差
OffSiteApplies someone = (from p in db.OffSiteApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
case "37":
{ //出差
OnDutyApplies someone = (from p in db.OnDutyApplies where p.BillNumber == application.BNumber select p).SingleOrDefault();
someone.AuditStatus = status;
Push(someone.StaffNumber, user.CompanyId, status);
}
break;
default:
break;
}
db.SaveChanges();
}
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());
}
public ActionResult Create(TrainStart trainStart)
{
var staff = (from s in db.Staffs
where s.AuditStatus == 3 && s.ArchiveTag == false
select new StaffModel
{
department = s.Department,
text = s.StaffNumber + "-" + s.Name,
value = s.StaffNumber + "-" + s.Name + "<" + s.IndividualTelNumber + "-" + s.Email + ">"
}).ToList();
var group = (from d in db.Departments
select new StaffModel {
department = d.DepartmentId, name = d.Name
}).ToList();
Dictionary <string, int> sum = new Dictionary <string, int>();
foreach (var g in group)
{
int count = 0;
foreach (var s in staff)
{
if (s.department == g.department)
{
count++;
}
}
sum.Add(g.department, count);
}
ViewBag.Count = sum;
ViewBag.Receiver = staff;
ViewBag.Group = group;
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;
/*查找预留字段(name)*/
var fieldList1 = (from p in db.ReserveFields
join q in db.TableNameContrasts
on p.TableNameId equals q.Id
where q.TableName == "TrainStarts" select p).ToList();
ViewBag.fieldList = fieldList1;
if (ModelState.IsValid)
{
trainStart.JoinPerson = Request["JoinPerson"];
trainStart.ChoosePerson = Request["ChoosePerson"];
trainStart.RecordPerson = this.Name;
trainStart.RecordTime = DateTime.Now;
db.TrainStarts.Add(trainStart);
//提交审批
byte status = AuditApplicationStaffSkill(trainStart);
//需要对原表做出的修改
trainStart.AuditStatus = status;
/*查找预留字段(name)*/
var fieldList = (from p in db.ReserveFields
join q in db.TableNameContrasts
on p.TableNameId equals q.Id
where q.TableName == "TrainStarts" select p).ToList();
ViewBag.fieldList = fieldList;
/*遍历，保存变化的字段*/
foreach (var temp1 in fieldList)
{
TrainStartReserve rr = new TrainStartReserve();
rr.Number = trainStart.Id;
rr.FieldId = temp1.Id;
rr.Value = Request[temp1.FieldName];
/*占位，为了在Index中显示整齐的格式*/
if (rr.Value == null)
{
rr.Value = " ";
}
db.TrainStartReserves.Add(rr);
db.SaveChanges();
}
db.SaveChanges();
if (status == 7)
{
ViewBag.alertMessage = true;
return(View(trainStart));
}
else
if (status == 3)
{
TrainStartPassAudit(trainStart);
}
return(RedirectToAction("Index"));
}
return(View(trainStart));
}
public byte AuditApplicationStaffSkill(TrainStart staffSkill)//(string BillTypeNumber,int id)
{
/*访问单据性质，看是否是自动审核*/
var item = (from p in db.BillProperties where p.Type == staffSkill.BillTypeNumber select p).ToList().FirstOrDefault();
if (item.IsAutoAudit == 1) //自动审核是1
{ //如果为0 代表不能自动审核 如果为1 代表可以自动审核
return(3); //代表自动审核
}
if (item.IsAutoAudit == 2)//手动审核是2
{
//手动审核,也写到db.AditApplications这个表中但是不走process？
return(6);//手动审核
}
if (item.IsAutoAudit == 3)
{ //如果不自动审核，就要走人工审核流程。即，把信息写入db.AditApplications这个表中
AuditApplication auditApplication = new AuditApplication();
auditApplication.BType = item.Type;
auditApplication.TypeName = item.TypeName;
auditApplication.CreateDate = DateTime.Now;
var template = (from p in db.AuditTemplates
where (
(staffSkill.BillTypeNumber == p.BType) && (DateTime.Now > p.StartTime) && (DateTime.Now < p.ExpireTime)
)
select p).ToList().FirstOrDefault();
if (template != null)//如果没有用于审批的模板 那么这里没法运行
{
auditApplication.BNumber = staffSkill.BillNumber;
auditApplication.TId = template.Id;
auditApplication.Creator = this.UserName;
auditApplication.CreatorName = this.Name;
auditApplication.State = 0;//代表等待审
auditApplication.Info =
"单据名称：" + staffSkill.BillTypeNumber + ";" +
"培训类型：" + staffSkill.TrainType + ";" +
"培训主题：" + staffSkill.TrainTheme + ";" +
"培训讲师：" + staffSkill.TrainPerson + ";" +
"培训地址：" + staffSkill.TrainPlace + ";" +
"开始时间：" + staffSkill.StartDate + ";" +
"结束时间：" + staffSkill.EndDate + ";" +
"培训费用：" + staffSkill.TrainCost + "元" + ";" +
"联系电话：" + staffSkill.TellNumber + ";" +
"参加人员：" + staffSkill.JoinPerson + ";" +
"列席人员：" + staffSkill.TrainManage + ";" +
"培训内容：" + staffSkill.TrainContent + ";" +
db.AuditApplications.Add(auditApplication);
db.SaveChanges();
AuditStep step = db.AuditSteps.Find(template.FirstStepSId);
if (step == null)
{
return(7);
}
else
{
AuditProcess auditProcess = new AuditProcess();
auditProcess.AId = auditApplication.Id;
auditProcess.SId = step.SId;
auditProcess.TId = step.TId;
auditProcess.BType = auditApplication.BType;
auditProcess.BNumber = auditApplication.BNumber;
auditProcess.TypeName = auditApplication.TypeName;
auditProcess.Info = auditApplication.Info;
//auditProcess.Info = auditApplication.Info + "提交人员：" + auditApplication.CreatorName + "-" + auditApplication.Creator + ";" +
// "提交日期：" + auditApplication.CreateDate + ";";
auditProcess.AuditDate = DateTime.Now;
auditProcess.CreateDate = auditApplication.CreateDate;
auditProcess.Result = 0; //待审
auditProcess.DeadlineDate = DateTime.Now.AddDays(step.Days); //记录一下该节点最晚的审核时间；
auditProcess.Approver = step.Approver;
db.AuditProcesses.Add(auditProcess);
db.SaveChanges();
}
db.SaveChanges();
return(0);//待审
}
else
{
return(7);//待审(未能进入审核流程)
}
}
return(0);//待审
}
