public ActionResult Selectres(string code)
{
TempData["code"] = code;
resourceModel res = ires.resourceSelectWhere(code)[0];
return(View(res));
}
public ActionResult AddImage(HttpPostedFileBase file)
{
resourceModel res = ires.resourceSelectWhere((string)TempData["code"])[0];
try
{
byte[] bts = MD5.Create().ComputeHash(file.InputStream);
StringBuilder sb = new StringBuilder();
foreach (byte b in bts)
{
sb.Append(b.ToString("X2"));
}
string name = sb.ToString();
string ext = Path.GetExtension(file.FileName);
string path = Server.MapPath("~/Image/" + DateTime.Now.ToString("yyyy/MM/dd")) + "/" + name + ext;
new FileInfo(path).Directory.Create();
file.SaveAs(path);
res.RPhoto = path;
}
catch (Exception)
{
return(Content("0"));
}
if (ires.resourceUpd(res) > 0)
{
return(Content("1"));
}
else
{
return(Content("0"));
}
}
//Get all resources (Employees) from DB.
public JsonResult GetResources()
{
Employee_Schedule_DatabaseEntities db = new Employee_Schedule_DatabaseEntities();
db.Configuration.ProxyCreationEnabled = false;
var resources = db.Employees.ToList();
//Tempory holder for resrouces
List <resourceModel> resList = new List <resourceModel>();
foreach (var emp in resources)
{
resourceModel res = new resourceModel();
res.title = emp.FirstName + " " + emp.LastName;
res.id = emp.EmployeeID;
res.groupId = emp.Occupation;
resList.Add(res);
}
return(new JsonResult {
Data = resList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult Insertresource(string RCode)
{
//string bian = DateTime.Now.ToString("yyMMddmmss") + new Random().Next(100, 999);
//ViewData["s"] = bian;
resourceModel res = ires.resourceSelectWhere(RCode)[0];
return(View("Insertresource", res));
}
public ActionResult Selectresour(string code)
{
TempData["code1"] = code;
resourceModel res = ires.resourceSelectWhere(code)[0];
res.RAlterationDate = DateTime.Now.ToString();
return(View(res));
}
//I级机构删除
public int resourceDel(resourceModel r)
{
resource e = new resource()
{
RCode = r.RCode
};
return(Delete(e));
}
public ActionResult UpdateSelectWhere(resourceModel res)
{
if (ires.resourceUpd(res) > 0)
{
Response.Write("<script>alert('修改成功')</script>");
return(View("UpdatePhoto"));
}
else
{
Response.Write("<script>alert('修改失败')</script>");
return(View());
}
}
public ActionResult Updateresourse(resourceModel res)
{
if (ires.resourceUpd(res) > 0)
{
Response.Write("<script>alert('变更成功')</script>");
TempData["resCode"] = res.RCode;
return(UpdateSelectPhoto());
}
else
{
Response.Write("<script>alert('变更失败')</script>");
return(View());
}
}
public ActionResult SelectDelWhereTwosFenYe(int currentPage, int PageSize)
{
int rows = 0;
resourceModel res = new resourceModel();
res.RRState = 1;
res.RState = "已复核";
List <resourceModel> list = ires.resourceWhereFenYe(res, currentPage, PageSize, out rows);
Dictionary <string, object> dic = new Dictionary <string, object>()
{
{ "list", list }, { "rows", rows }
};
return(Content(JsonConvert.SerializeObject(dic)));
}
public ActionResult InsertWhereresource(resourceModel res)
{
if (ires.resourceUpd(res) > 0)
{
string code = res.RCode;
Response.Write("<script>alert('登记成功')</script>");
TempData["code"] = code;
return(Updateesource());
}
else
{
Response.Write("<script>alert('添加失败')</script>");
return(View());
}
}
//Methods for grabbing data to render Schedule
//Get all Events from DB
public JsonResult GetEvents()
{
ResourceEventContext db = new ResourceEventContext();
db.Configuration.ProxyCreationEnabled = false;
var events = db.Events.ToList();
//Tempory holder for resrouces
List <resourceModel> resList = new List <resourceModel>();
foreach (var evnt in events)
{
//Finds Employee Linked to Event
Employee tempEmp = new Employee();
tempEmp = db.Employees.Where(c => c.EmployeeID == evnt.EmployeeID).FirstOrDefault();
//Saves All information about event to temporary result model
resourceModel res = new resourceModel();
res.EventID = evnt.EventID;
res.EmployeeID = tempEmp.EmployeeID;
res.EventTitle = evnt.Title;
res.Start = evnt.Start;
res.IsFullDay = evnt.IsFullDay;
res.ThemeColor = evnt.ThemeColor;
//Adding text to event description depending on how long employee works that day
if (res.IsFullDay)
{
res.Description = tempEmp.FirstName + " " + tempEmp.LastName + " works full time today";
}
else
{
res.End = evnt.End;
TimeSpan?timeDif = res.End - res.Start;
res.Description = tempEmp.FirstName + " " + tempEmp.LastName + ", works " + timeDif.Value.TotalHours + " hours today.";
}
resList.Add(res);
}
return(new JsonResult {
Data = resList, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult SelectDelWhereTwosRes(string code)
{
resourceModel res = new resourceModel();
res.RCode = code;
if (ires.resourceDel(res) > 0)
{
Response.Write("<script>alert('永久删除成功')</script>");
return(SelectDelWhereTwos());
}
else
{
Response.Write("<script>alert('永久删除失败')</script>");
return(View());
}
}
public ActionResult LuYongShengPiUpdate(LuYongModel lym) //录用申请主页
{
string bian = DateTime.Now.ToString("yyMMddmmss") + new Random().Next(100, 999);
if (ilyb.UpdateLuYong(lym) > 0)
{
resourceModel res = new resourceModel();
res.RCode = bian;
res.MKName = lym.MKName;
res.CName = lym.MCName;
res.RName = lym.JlName;
res.RSex = lym.JlSex;
res.REmail = lym.JlEmail;
res.RPhone = lym.JlDianHua;
res.RCellphone = lym.JlShouJi;
res.RAddress = lym.JlAdds;
res.RPostcode = lym.JlYouBian;
res.RNationality = lym.JlGuoJi;
res.RBirthplace = lym.JlBreathAdds;
res.RBirthday = lym.JlBreathDay;
res.RNation = lym.JlMingZu;
res.RFaith = lym.JlZongJioaXingYang;
res.RPolitics = lym.JlZhengZhiMianMao;
res.RIDKA = lym.JlEntityCond;
res.RAge = lym.JlAge;
res.RBackground = lym.JlXueli;
res.RYears = Convert.ToInt32(lym.JlJiaoYvYean);
res.REducation = lym.JlXueLiZhuanYe;
res.RInputting = DateTime.Now;
res.Rstrong = lym.JlTeChang;
res.RHobby = lym.JlAiHoa;
res.Rcurriculum = lym.JlGeRenLvLi;
res.RRemark = lym.JlBeiZhu;
res.RChangeDate = DateTime.Now;
res.RState = "未复核";
res.RRState = 0;
ires.resourceAdd(res);
return(RedirectToAction("LuYongShengPiIndex"));
}
else
{
return(View(lym));
}
}
public ActionResult SelectDelWhereOneUpd(resourceModel res)
{
string Rcode = res.RCode;
resourceModel ress = ires.resourceSelectWhere(Rcode)[0];
ress.RRState = 0;//0恢复
if (ires.resourceUpd(ress) > 0)
{
Response.Write("<script>alert('恢复成功')</script>");
return(SelectDelWhereone());
}
else
{
Response.Write("<script>alert('恢复失败')</script>");
return(View());
}
}
public ActionResult SelectDeltwos(resourceModel res)
{
string Rcode = res.RCode;
resourceModel ress = ires.resourceSelectWhere(Rcode)[0];
ress.RRState = 1;//1假删除
if (ires.resourceUpd(ress) > 0)
{
Response.Write("<script>alert('删除成功')</script>");
return(SelectresDel());
}
else
{
Response.Write("<script>alert('删除失败')</script>");
return(View());
}
}
public List <resourceModel> resourceWhereFenYe(resourceModel res, int pageindex, int pagecount, out int count)
{
return(ires.resourceWhereFenYe(res, pageindex, pagecount, out count));
}
//I级机构条件查询
public List <resourceModel> resourceSelectWhere(string code)
{
MyDbContext db = CreateContext();
List <resource> list = db.resource.AsNoTracking()
.Where(e => e.RCode == code)
.Select(e => e)
.ToList();
List <resourceModel> list2 = new List <resourceModel>();
foreach (resource item in list)
{
resourceModel e = new resourceModel()
{
RCode = item.RCode,
oneCodeName = item.oneCodeName,
twoCodeName = item.twoCodeName,
threeCodeName = item.threeCodeName,
MKName = item.MKName,
CName = item.CName,
MWei = item.MWei,
RName = item.RName,
RSex = item.RSex,
REmail = item.REmail,
RPhone = item.RPhone,
RQQ = item.RQQ,
RCellphone = item.RCellphone,
RAddress = item.RAddress,
RPostcode = item.RPostcode,
RNationality = item.RNationality,
RBirthplace = item.RBirthplace,
RBirthday = item.RBirthday,
RNation = item.RNation,
RFaith = item.RFaith,
RPolitics = item.RPolitics,
RIDKA = item.RIDKA,
RSecurity = item.RSecurity,
RAge = item.RAge,
RBackground = item.RBackground,
RYears = item.RYears,
REducation = item.REducation,
RSalary = item.RSalary,
RBank = item.RBank,
RAccounts = item.RAccounts,
RRegistrant = item.RRegistrant,
RInputting = item.RInputting,
Rstrong = item.Rstrong,
RHobby = item.RHobby,
Rcurriculum = item.Rcurriculum,
RFamily = item.RFamily,
RRemark = item.RRemark,
RRCode = item.RRCode,
RRBasicCount = item.RRBasicCount,
RRShouldCount = item.RRShouldCount,
RRActualCount = item.RRActualCount,
RRTransfer = item.RRTransfer,
RRMotivateCount = item.RRMotivateCount,
RRTrainCount = item.RRTrainCount,
RRAlterationCount = item.RRAlterationCount,
RPhoto = item.RPhoto,
RAccessory = item.RAccessory,
RState = item.RState,
RRecombination = item.RRecombination,
RRecombinationDate = item.RRecombinationDate,
RAlteration = item.RAlteration,
RAlterationDate = item.RAlterationDate,
RChangeDate = item.RChangeDate,
RDelDate = item.RDelDate,
RReplyDate = item.RReplyDate,
RRState = item.RRState
};
list2.Add(e);
}
return(list2);
}
//I级机构修改
public int resourceUpd(resourceModel r)
{
resource first = new resource()
{
RCode = r.RCode,
oneCodeName = r.oneCodeName,
twoCodeName = r.twoCodeName,
threeCodeName = r.threeCodeName,
MKName = r.MKName,
CName = r.CName,
MWei = r.MWei,
RName = r.RName,
RSex = r.RSex,
REmail = r.REmail,
RPhone = r.RPhone,
RQQ = r.RQQ,
RCellphone = r.RCellphone,
RAddress = r.RAddress,
RPostcode = r.RPostcode,
RNationality = r.RNationality,
RBirthplace = r.RBirthplace,
RBirthday = r.RBirthday,
RNation = r.RNation,
RFaith = r.RFaith,
RPolitics = r.RPolitics,
RIDKA = r.RIDKA,
RSecurity = r.RSecurity,
RAge = r.RAge,
RBackground = r.RBackground,
RYears = r.RYears,
REducation = r.REducation,
RSalary = r.RSalary,
RBank = r.RBank,
RAccounts = r.RAccounts,
RRegistrant = r.RRegistrant,
RInputting = r.RInputting,
Rstrong = r.Rstrong,
RHobby = r.RHobby,
Rcurriculum = r.Rcurriculum,
RFamily = r.RFamily,
RRemark = r.RRemark,
RRCode = r.RRCode,
RRBasicCount = r.RRBasicCount,
RRShouldCount = r.RRShouldCount,
RRActualCount = r.RRActualCount,
RRTransfer = r.RRTransfer,
RRMotivateCount = r.RRMotivateCount,
RRTrainCount = r.RRTrainCount,
RRAlterationCount = r.RRAlterationCount,
RPhoto = r.RPhoto,
RAccessory = r.RAccessory,
RState = r.RState,
RRecombination = r.RRecombination,
RRecombinationDate = r.RRecombinationDate,
RAlteration = r.RAlteration,
RAlterationDate = r.RAlterationDate,
RChangeDate = r.RChangeDate,
RDelDate = r.RDelDate,
RReplyDate = r.RReplyDate,
RRState = r.RRState
};
return(Update(first));
}
public List <resourceModel> resourceFenYe(int RRState, string RState, int currentPage, int PageSize, out int rows)
{
var list = CreateContext().resource.AsNoTracking().Where(e => e.RState == RState).Where(e => e.RRState == RRState).OrderBy(e => e.RCode);
rows = list.Count();
var data = list
.Skip((currentPage - 1) * PageSize)
.Take(PageSize)
.ToList();
List <resourceModel> list2 = new List <resourceModel>();
foreach (var item in data)
{
resourceModel e = new resourceModel()
{
RCode = item.RCode,
oneCodeName = item.oneCodeName,
twoCodeName = item.twoCodeName,
threeCodeName = item.threeCodeName,
MKName = item.MKName,
CName = item.CName,
MWei = item.MWei,
RName = item.RName,
RSex = item.RSex,
REmail = item.REmail,
RPhone = item.RPhone,
RQQ = item.RQQ,
RCellphone = item.RCellphone,
RAddress = item.RAddress,
RPostcode = item.RPostcode,
RNationality = item.RNationality,
RBirthplace = item.RBirthplace,
RBirthday = item.RBirthday,
RNation = item.RNation,
RFaith = item.RFaith,
RPolitics = item.RPolitics,
RIDKA = item.RIDKA,
RSecurity = item.RSecurity,
RAge = item.RAge,
RBackground = item.RBackground,
RYears = item.RYears,
REducation = item.REducation,
RSalary = item.RSalary,
RBank = item.RBank,
RAccounts = item.RAccounts,
RRegistrant = item.RRegistrant,
RInputting = item.RInputting,
Rstrong = item.Rstrong,
RHobby = item.RHobby,
Rcurriculum = item.Rcurriculum,
RFamily = item.RFamily,
RRemark = item.RRemark,
RRCode = item.RRCode,
RRBasicCount = item.RRBasicCount,
RRShouldCount = item.RRShouldCount,
RRActualCount = item.RRActualCount,
RRTransfer = item.RRTransfer,
RRMotivateCount = item.RRMotivateCount,
RRTrainCount = item.RRTrainCount,
RRAlterationCount = item.RRAlterationCount,
RPhoto = item.RPhoto,
RAccessory = item.RAccessory,
RState = item.RState,
RRecombination = item.RRecombination,
RRecombinationDate = item.RRecombinationDate,
RAlteration = item.RAlteration,
RAlterationDate = item.RAlterationDate,
RChangeDate = item.RChangeDate,
RDelDate = item.RDelDate,
RReplyDate = item.RReplyDate,
RRState = item.RRState
};
list2.Add(e);
}
return(list2);
}
public ActionResult SelectDelWhereOnesRes(string code)
{
resourceModel res = ires.resourceSelectWhere(code)[0];
return(View("SelectDelWhereOnesRes", res));
}
public ActionResult SelectDelWhereOnes(resourceModel res)
{
Session["resDelone"] = res;
return(View("SelectDelWhereOnes"));
}
public ActionResult SelectDelFen(resourceModel res)
{
Session["restwo"] = res;
return(View("SelectDelFen"));
}
public ActionResult UpdateresourceState(string RCode)
{
TempData["photo"] = RCode;
List <resourceModel> list = ires.resourceSelectWhere(RCode);
resourceModel res = null;
foreach (resourceModel item in list)
{
res = new resourceModel()
{
RCode = item.RCode,
oneCodeName = item.oneCodeName,
twoCodeName = item.twoCodeName,
threeCodeName = item.threeCodeName,
MKName = item.MKName,
CName = item.CName,
MWei = item.MWei,
RName = item.RName,
RSex = item.RSex,
REmail = item.REmail,
RPhone = item.RPhone,
RQQ = item.RQQ,
RCellphone = item.RCellphone,
RAddress = item.RAddress,
RPostcode = item.RPostcode,
RNationality = item.RNationality,
RBirthplace = item.RBirthplace,
RBirthday = item.RBirthday,
RNation = item.RNation,
RFaith = item.RFaith,
RPolitics = item.RPolitics,
RIDKA = item.RIDKA,
RSecurity = item.RSecurity,
RAge = item.RAge,
RBackground = item.RBackground,
RYears = item.RYears,
REducation = item.REducation,
RSalary = item.RSalary,
RBank = item.RBank,
RAccounts = item.RAccounts,
RRegistrant = item.RRegistrant,
RInputting = item.RInputting,
Rstrong = item.Rstrong,
RHobby = item.RHobby,
Rcurriculum = item.Rcurriculum,
RFamily = item.RFamily,
RRemark = item.RRemark,
RRCode = item.RRCode,
RRBasicCount = item.RRBasicCount,
RRShouldCount = item.RRShouldCount,
RRActualCount = item.RRActualCount,
RRTransfer = item.RRTransfer,
RRMotivateCount = item.RRMotivateCount,
RRTrainCount = item.RRTrainCount,
RRAlterationCount = item.RRAlterationCount,
RPhoto = item.RPhoto,
RAccessory = item.RAccessory,
RState = item.RState,
RRecombination = item.RRecombination,
RRecombinationDate = item.RRecombinationDate,
RAlteration = item.RAlteration,
RAlterationDate = item.RAlterationDate,
RChangeDate = item.RChangeDate,
RDelDate = item.RDelDate,
RReplyDate = item.RReplyDate,
RRState = item.RRState
};
}
return(View("UpdateresourceState", res));
}
public ActionResult SelectWhereDateTwo(resourceModel res)
{
Session["res"] = res;
return(SelectWhereDate());
}
public List <resourceModel> resourceWhereFenYe(resourceModel res, int pageindex, int pagecount, out int count)
{
string sql = "select * from resource where 1=1 ";
sql += " and RRState=" + res.RRState + " and RState='" + res.RState + "'";
if (res.oneCodeName != "0" && res.oneCodeName != "" && res.oneCodeName != null)
{
sql += " and oneCodeName='" + res.oneCodeName + "'";
}
if (res.twoCodeName != "0" && res.twoCodeName != "" && res.twoCodeName != null)
{
sql += " and twoCodeName='" + res.twoCodeName + "'";
}
if (res.threeCodeName != "0" && res.threeCodeName != "" && res.threeCodeName != null)
{
sql += " and threeCodeName='" + res.threeCodeName + "'";
}
if (res.MKName != "0" && res.MKName != "" && res.MKName != null)
{
sql += " and MKName='" + res.MKName + "'";
}
if (res.CName != "0" && res.CName != "" && res.CName != null)
{
sql += " and CName='" + res.CName + "'";
}
if (res.RInputting.ToString() != "0001/1/1 0:00:00" && res.RInputting != null)
{
sql += " and RInputting>'" + res.RInputting + "'";
}
if (res.RChangeDate.ToString() != "0001/1/1 0:00:00" && res.RChangeDate != null)
{
sql += " and RInputting<'" + res.RChangeDate + "'";
}
var Result = CreateContext().resource.SqlQuery(sql).Select(e => e).ToList();
var Result2 = Result.Select(e => e).ToList().Skip((pageindex - 1) * pagecount).Take(pagecount);
count = Result.Count();
List <resourceModel> list = new List <resourceModel>();
foreach (resource item in Result2)
{
resourceModel hh = new resourceModel()
{
RCode = item.RCode,
oneCodeName = item.oneCodeName,
twoCodeName = item.twoCodeName,
threeCodeName = item.threeCodeName,
MKName = item.MKName,
CName = item.CName,
MWei = item.MWei,
RName = item.RName,
RSex = item.RSex,
REmail = item.REmail,
RPhone = item.RPhone,
RQQ = item.RQQ,
RCellphone = item.RCellphone,
RAddress = item.RAddress,
RPostcode = item.RPostcode,
RNationality = item.RNationality,
RBirthplace = item.RBirthplace,
RBirthday = item.RBirthday,
RNation = item.RNation,
RFaith = item.RFaith,
RPolitics = item.RPolitics,
RIDKA = item.RIDKA,
RSecurity = item.RSecurity,
RAge = item.RAge,
RBackground = item.RBackground,
RYears = item.RYears,
REducation = item.REducation,
RSalary = item.RSalary,
RBank = item.RBank,
RAccounts = item.RAccounts,
RRegistrant = item.RRegistrant,
RInputting = item.RInputting,
Rstrong = item.Rstrong,
RHobby = item.RHobby,
Rcurriculum = item.Rcurriculum,
RFamily = item.RFamily,
RRemark = item.RRemark,
RRCode = item.RRCode,
RRBasicCount = item.RRBasicCount,
RRShouldCount = item.RRShouldCount,
RRActualCount = item.RRActualCount,
RRTransfer = item.RRTransfer,
RRMotivateCount = item.RRMotivateCount,
RRTrainCount = item.RRTrainCount,
RRAlterationCount = item.RRAlterationCount,
RPhoto = item.RPhoto,
RAccessory = item.RAccessory,
RState = item.RState,
RRecombination = item.RRecombination,
RRecombinationDate = item.RRecombinationDate,
RAlteration = item.RAlteration,
RAlterationDate = item.RAlterationDate,
RChangeDate = item.RChangeDate,
RDelDate = item.RDelDate,
RReplyDate = item.RReplyDate,
RRState = item.RRState
};
list.Add(hh);
}
return(list);
}
public ActionResult SelectWhereBianGenFen(resourceModel res)
{
Session["resour"] = res;
return(SelectWhereBianGenFenYe());
}
public int resourceUpd(resourceModel r)
{
return(ires.resourceUpd(r));
}
