public List <Volunteer_Model> Search_Volunteer(string Name, string Group, string Expertise, List <int> years)
{
VolunteerEntities dbcontext = new VolunteerEntities();
var q = from p1 in dbcontext.Volunteer
join p2 in dbcontext.Expertise2 on p1.Volunteer_no equals p2.Volunteer_no
join p2_5 in dbcontext.Expertise1 on p2.Expertise_no equals p2_5.Expertise_no
join p3 in dbcontext.Service_Group1 on p1.Volunteer_no equals p3.Volunteer_no
join p3_5 in dbcontext.Service_group on p3.Group_no equals p3_5.Group_no
join p4 in dbcontext.Identity_type on p1.Identity_type equals p4.Identity_type1
where
(!(Expertise == "(無)") ? p2.Expertise1.Expertise == Expertise : true) &&
(!(Group == "(無)") ? p3_5.Group_name == Group : true) &&
(!(Name == "") ? p1.Chinese_name.Contains(Name) : true) &&
(!(years.Count == 0)?years.Contains(p1.Seniority):true)
select new
{
Volunteer_no = p1.Volunteer_no.ToString(),
Chinese_name = p1.Chinese_name.ToString(),
English_name = p1.English_name.ToString(),
Sex = p1.sex.ToString(),
Birthday = p1.birthday.ToString(),
IDcrad_no = p1.IDcrad_no.ToString(),
Medical_record_no = p1.Medical_record_no.ToString(),
Identity_type = p4.Identity_type_name.ToString(),
Seniority = p1.Seniority.ToString(),
Join_date = p1.Join_date.ToString(),
Leave_date = p1.Leave_date.ToString(),
Leave_reason = p1.Leave_reason.ToString(),
Phone_no = p1.Phone_no.ToString(),
Mobile_no = p1.Mobile_no.ToString(),
Vest_no = p1.Vest_no.ToString(),
Postal_code = p1.Postal_code.ToString(),
Address = p1.Address.ToString(),
Education = p1.Education.ToString(),
Lssuing_unit_no = p1.Lssuing_unit_no.ToString(),
Service_manual_no = p1.Service_manual_no.ToString(),
Personality_scale = p1.Personality_scale.ToString(),
//合併項
Expertise = p2_5.Expertise.ToString(),
Group = p3_5.Group_name.ToString(),
//Photo = p1.Photo.ToString()
};
List <Volunteer_Model> volunteer_Models = new List <Volunteer_Model>();
List <Volunteer_Model> volunteer_Models2 = new List <Volunteer_Model>();
foreach (var row in q)
{
Volunteer_Model model = new Volunteer_Model();
model.Volunteer_no = row.Volunteer_no;
model.Chinese_name = row.Chinese_name;
model.English_name = row.English_name;
model.Sex = row.Sex;
model.Birthday = row.Birthday;
model.IDcrad_no = row.IDcrad_no;
model.Medical_record_no = row.Medical_record_no;
model.Identity_type = row.Identity_type;
model.Seniority = row.Seniority;
model.Join_date = row.Join_date;
model.Leave_date = row.Leave_date;
model.Leave_reason = row.Leave_reason;
model.Phone_no = row.Phone_no;
model.Mobile_no = row.Mobile_no;
model.Vest_no = row.Vest_no;
model.Postal_code = row.Postal_code;
model.Address = row.Address;
model.Education = row.Education;
model.Lssuing_unit_no = row.Lssuing_unit_no;
model.Service_manual_no = row.Service_manual_no;
model.Personality_scale = row.Personality_scale;
model.Group = row.Group;
model.Experise = row.Expertise;
model.VLT_group = new List <string>();
model.VLT_experise = new List <string>();
var q2 = from p2 in q
where p2.Volunteer_no == row.Volunteer_no
select p2;
foreach (var group in q2)
{
//將各種組別、專長合併成一個欄位
if (!model.VLT_group.Contains(group.Group))
{
model.VLT_group.Add(group.Group);
}
if (!model.VLT_experise.Contains(group.Expertise))
{
model.VLT_experise.Add(group.Expertise);
}
}
volunteer_Models.Add(model);
}
List <string> 存在的volunteer_no = new List <string>();
foreach (Volunteer_Model q3 in volunteer_Models)
{
if (!存在的volunteer_no.Contains(q3.Volunteer_no))
{
存在的volunteer_no.Add(q3.Volunteer_no);
volunteer_Models2.Add(q3);
}
}
return(volunteer_Models2);
}
public void UpdateManpower_apply(int apply_ID, int reply_number, string repply_description, int supervision_ID)
{
int processing = 0;
int end_processing = 0;
Apply_assessment_Model apply_Assessment_Model = new Apply_assessment_Model();
List <string> Assessments = apply_Assessment_Model.SelectApply_assessment_byApply_ID(apply_ID);
Apply_result_Model apply_Result_Model = new Apply_result_Model();
List <string> Assessment_results = apply_Result_Model.SelectApply_result_byApply_ID(apply_ID);
VolunteerEntities dbContext = new VolunteerEntities();
var a = from n in dbContext.Stages
where n.Stage_type == "人力申請"
select new
{
Stage_ID = n.Stage_ID,
Stage = n.Stage1
};
foreach (var row in a)
{
switch (row.Stage.ToString())
{
case "處理中":
processing = row.Stage_ID;
break;
case "申請完成":
end_processing = row.Stage_ID;
break;
}
}
var q = from n in dbContext.Manpower_apply
where n.Apply_ID == apply_ID
select n;
foreach (var row in q)
{
row.Reply_number = reply_number;
row.Repply_description = repply_description;
row.Supervision_ID = supervision_ID;
row.Supervision_heads = "熊主任";
row.Reply_date = DateTime.Now;
if (reply_number > 0 &&
!string.IsNullOrEmpty(repply_description) &&
Assessments.Count() > 0 &&
Assessment_results.Count() > 0)
{
row.Apply_state = end_processing;
}
else
{
row.Apply_state = processing;
}
}
dbContext.SaveChanges();
}