public ActionResult Edit(string zaiLiuKaNo, string userName, string birthday, string sex, string qualification, string adress, string motivation, string permitDay)
{
ZailiukaDto dto = new ZailiukaDto();
//string data = WebUtil.GetQueryStringValue<string>("json");
dto.ZaiLiuKaNo = zaiLiuKaNo;
dto.UserName = userName;
dto.Birthday = birthday;
dto.Sex = sex;
dto.Qualification = qualification;
dto.Adress = adress;
dto.Motivation = motivation;
dto.PermitDay = permitDay;
//dto.ZaiLiuKaNo = WebUtil.GetQueryStringValue<string>("zaiLiuKaNo");
//dto.UserName = WebUtil.GetQueryStringValue<string>("userName");
//dto.Birthday = WebUtil.GetQueryStringValue<string>("birthday");
//dto.Sex = WebUtil.GetQueryStringValue<string>("sex");
//dto.Qualification = WebUtil.GetQueryStringValue<string>("qualification");
//dto.Adress = WebUtil.GetQueryStringValue<string>("adress");
//dto.Motivation = WebUtil.GetQueryStringValue<string>("motivation");
//dto.PermitDay = WebUtil.GetQueryStringValue<string>("permitDay");
ViewBag.Dto = dto;
return(View());
}
public ActionResult Register()
{
string zaiLiuKaNo = WebUtil.GetFormValue <string>("zaiLiuKaNo", string.Empty);
string userName = WebUtil.GetFormValue <string>("userName", string.Empty);
string sex = WebUtil.GetFormValue <string>("sex", string.Empty);
string birthday = WebUtil.GetFormValue <string>("birthday", string.Empty);
string permitStart = WebUtil.GetFormValue <string>("permitStart", string.Empty);
string permitEnd = WebUtil.GetFormValue <string>("permitEnd", string.Empty);
string adress = WebUtil.GetFormValue <string>("adress", string.Empty);
string qualification = WebUtil.GetFormValue <string>("qualification", string.Empty);
string motivation = WebUtil.GetFormValue <string>("motivation", string.Empty);
ZailiukaDto dto = new ZailiukaDto();
dto.ZaiLiuKaNo = zaiLiuKaNo;
dto.UserName = userName;
dto.Sex = sex;//Enum.GetName(typeof(Sex), Convert.ToInt32(sex));
dto.Birthday = birthday;
dto.PermitDay = permitStart + "~" + permitEnd;
dto.Adress = adress;
dto.Qualification = qualification;
dto.Motivation = motivation;
int line = zaiLiuKaProvider.Add(dto);
//ViewBag.ZaiLiuKa = dto;
if (line > 0)
{
this.ReturnJson.AddProperty("add", "success");
}
return(Content(this.ReturnJson.ToString()));
}
public ActionResult Change(string zaiLiuKaNo)
{
//string zaiLiuKaNo = WebUtil.GetQueryStringValue<string>("zaiLiuKaNo");
ZailiukaDto dto = zaiLiuKaProvider.SelectByNo(zaiLiuKaNo);
//ViewBag.Dto = dto;
return(this.Json(dto));
}
public int Update(ZailiukaDto dto)
{
ZailiukaInfoEntity zaiLiuKaInfoEntity = new ZailiukaInfoEntity();
QualificationEntity qualificationEntity = new QualificationEntity();
MotivationEntity motivationEntity = new MotivationEntity();
zaiLiuKaInfoEntity.IncludeAll();
qualificationEntity.IncludeAll();
motivationEntity.IncludeAll();
zaiLiuKaInfoEntity.ZaiLiuKaNo = dto.ZaiLiuKaNo;
qualificationEntity.ZaiLiuKaNo = dto.ZaiLiuKaNo;
motivationEntity.ZaiLiuKaNo = dto.ZaiLiuKaNo;
zaiLiuKaInfoEntity.UserName = dto.UserName;
zaiLiuKaInfoEntity.Sex = dto.Sex;
zaiLiuKaInfoEntity.Birthday = Convert.ToDateTime(dto.Birthday);
zaiLiuKaInfoEntity.PermitDay = dto.PermitDay;
zaiLiuKaInfoEntity.Adress = dto.Adress;
zaiLiuKaInfoEntity.UpdateTime = DateTime.Now;
zaiLiuKaInfoEntity.Flg = "1";
qualificationEntity.Type = dto.Qualification;
qualificationEntity.UpdateTime = DateTime.Now;
qualificationEntity.Memo = "無し";
qualificationEntity.Flg = "1";
motivationEntity.Type = dto.Motivation;
motivationEntity.UpdateTime = DateTime.Now;
motivationEntity.Memo = "無し";
motivationEntity.Flg = "1";
zaiLiuKaInfoEntity.Include(a => new { a.ZaiLiuKaNo, a.UserName, a.Sex, a.Birthday, a.PermitDay, a.Adress, a.UpdateTime, a.Memo, a.Flg });
zaiLiuKaInfoEntity.Where(a => a.ZaiLiuKaNo == dto.ZaiLiuKaNo);
this.ZailiukaInfo.Update(zaiLiuKaInfoEntity);
qualificationEntity.Include(a => new { a.ZaiLiuKaNo, a.Type, a.Memo, a.Flg });
qualificationEntity.Where(a => a.ZaiLiuKaNo == dto.ZaiLiuKaNo);
this.Qualification.Update(qualificationEntity);
motivationEntity.Include(a => new { a.ZaiLiuKaNo, a.Type, a.Memo, a.Flg });
motivationEntity.Where(a => a.ZaiLiuKaNo == dto.ZaiLiuKaNo);
int line = this.Motivation.Update(motivationEntity);
return(line);
}
public int Add(ZailiukaDto dto)
{
ZailiukaInfoEntity zaiLiuKaInfoEntity = new ZailiukaInfoEntity();
QualificationEntity qualificationEntity = new QualificationEntity();
MotivationEntity motivationEntity = new MotivationEntity();
zaiLiuKaInfoEntity.IncludeAll();
qualificationEntity.IncludeAll();
motivationEntity.IncludeAll();
zaiLiuKaInfoEntity.ZaiLiuKaNo = dto.ZaiLiuKaNo;
qualificationEntity.ZaiLiuKaNo = dto.ZaiLiuKaNo;
motivationEntity.ZaiLiuKaNo = dto.ZaiLiuKaNo;
zaiLiuKaInfoEntity.UserName = dto.UserName;
zaiLiuKaInfoEntity.Sex = dto.Sex;
zaiLiuKaInfoEntity.Birthday = Convert.ToDateTime(dto.Birthday);
zaiLiuKaInfoEntity.PermitDay = dto.PermitDay;
zaiLiuKaInfoEntity.Adress = dto.Adress;
zaiLiuKaInfoEntity.UpdateTime = DateTime.Now;
zaiLiuKaInfoEntity.Flg = "1";
qualificationEntity.Type = dto.Qualification;
qualificationEntity.UpdateTime = DateTime.Now;
qualificationEntity.Memo = "無し";
qualificationEntity.Flg = "1";
motivationEntity.Type = dto.Motivation;
motivationEntity.UpdateTime = DateTime.Now;
motivationEntity.Memo = "無し";
motivationEntity.Flg = "1";
//DTO to entity
this.ZailiukaInfo.Add(zaiLiuKaInfoEntity);
this.Qualification.Add(qualificationEntity);
int line = this.Motivation.Add(motivationEntity);
return(line);
}
public ZailiukaDto SelectByNo(string zaiLiuKaNo)
{
ZailiukaInfoEntity zaiLiuKaInfoEntity = new ZailiukaInfoEntity();
QualificationEntity qualificationEntity = new QualificationEntity();
MotivationEntity motivationEntity = new MotivationEntity();
zaiLiuKaInfoEntity.IncludeAll();
qualificationEntity.IncludeAll();
motivationEntity.IncludeAll();
zaiLiuKaInfoEntity.Where(a => a.ZaiLiuKaNo == zaiLiuKaNo);
zaiLiuKaInfoEntity = this.ZailiukaInfo.GetSingle(zaiLiuKaInfoEntity);
if (zaiLiuKaInfoEntity.Flg == "1")
{
qualificationEntity.Where(a => a.ZaiLiuKaNo == zaiLiuKaNo);
qualificationEntity = this.Qualification.GetSingle(qualificationEntity);
motivationEntity.Where(a => a.ZaiLiuKaNo == zaiLiuKaNo);
motivationEntity = this.Motivation.GetSingle(motivationEntity);
ZailiukaDto dto = new ZailiukaDto();
dto.ZaiLiuKaNo = zaiLiuKaInfoEntity.ZaiLiuKaNo;
dto.UserName = zaiLiuKaInfoEntity.UserName;
dto.Birthday = zaiLiuKaInfoEntity.Birthday.ToString();
dto.Sex = zaiLiuKaInfoEntity.Sex;
dto.Qualification = qualificationEntity.Type;
dto.Adress = zaiLiuKaInfoEntity.Adress;
dto.Motivation = motivationEntity.Type;
dto.PermitDay = zaiLiuKaInfoEntity.PermitDay;
return(dto);
}
else
{
return(null);
}
}
public List <ZailiukaDto> GetListByColumns(Dictionary <string, string> columnDic)
{
ZailiukaInfoEntity zaiLiuKaInfoEntity = new ZailiukaInfoEntity();
QualificationEntity qualificationEntity = new QualificationEntity();
MotivationEntity motivationEntity = new MotivationEntity();
zaiLiuKaInfoEntity.IncludeAll();
qualificationEntity.IncludeAll();
motivationEntity.IncludeAll();
List <ZailiukaDto> dtoList = new List <ZailiukaDto>();
//zaiLiuKaInfoEntity.Include(a => new { a.ZaiLiuKaNo, a.UserName, a.Sex, a.Birthday, a.PermitDay, a.Adress, a.UpdateTime, a.Memo, a.Flg });
//qualificationEntity.Include(a => new { a.ZaiLiuKaNo, a.Type, a.UpdateTime, a.Memo, a.Flg });
//motivationEntity.Include(a => new { a.ZaiLiuKaNo, a.Type, a.UpdateTime, a.Memo, a.Flg });
List <ZailiukaInfoEntity> zaiLiuKaList = this.ZailiukaInfo.GetList();
List <QualificationEntity> qualificationList = this.Qualification.GetList();
List <MotivationEntity> motivationList = this.Motivation.GetList();
//zaiLiuKaInfoEntity.Inner<QualificationEntity>(qualificationEntity, new Params<string, string>() { Item1 = "ZaiLiuKaNo", Item2 = "Type" });
//zaiLiuKaInfoEntity.Inner<MotivationEntity>(motivationEntity, new Params<string, string>() { Item1 = "ZaiLiuKaNo", Item2 = "Type" });
if (columnDic.ContainsKey("sex"))
{
List <ZailiukaInfoEntity> sexList = new List <ZailiukaInfoEntity>();
foreach (ZailiukaInfoEntity zEntity in zaiLiuKaList)
{
if (zEntity.Sex == columnDic["sex"])
{
sexList.Add(zEntity);
}
}
foreach (ZailiukaInfoEntity infoEntity in sexList)
{
ZailiukaDto dto = new ZailiukaDto();
if (infoEntity.Flg == "1")
{
dto.ZaiLiuKaNo = infoEntity.ZaiLiuKaNo;
dto.UserName = infoEntity.UserName;
dto.Sex = Enum.GetName(typeof(Sex), Convert.ToInt32(infoEntity.Sex));
dto.Birthday = infoEntity.Birthday.ToString();
dto.PermitDay = infoEntity.PermitDay;
dto.Adress = infoEntity.Adress;
foreach (QualificationEntity qEntity in qualificationList)
{
if (qEntity.ZaiLiuKaNo == dto.ZaiLiuKaNo)
{
dto.Qualification = Enum.GetName(typeof(Qualification), Convert.ToInt32(qEntity.Type));
}
}
foreach (MotivationEntity mEntity in motivationList)
{
if (mEntity.ZaiLiuKaNo == dto.ZaiLiuKaNo)
{
if (mEntity.Type.Contains(','))
{
string[] moti = mEntity.Type.Split(',');
foreach (string m in moti)
{
dto.Motivation = "";
dto.Motivation += Enum.GetName(typeof(Motivation), Convert.ToInt32(m)) + ",";
}
dto.Motivation = dto.Motivation.Substring(0, dto.Motivation.Length - 1);
}
else
{
dto.Motivation = Enum.GetName(typeof(Motivation), Convert.ToInt32(mEntity.Type));
}
}
}
dtoList.Add(dto);
}
}
if (!dtoList.ToString().IsEmpty())
{
return(dtoList);
}
else
{
return(null);
}
}
if (columnDic.ContainsKey("userName"))
{
List <ZailiukaInfoEntity> nameList = new List <ZailiukaInfoEntity>();
foreach (ZailiukaInfoEntity zEntity in zaiLiuKaList)
{
if (zEntity.UserName == columnDic["userName"])
{
nameList.Add(zEntity);
}
}
foreach (ZailiukaInfoEntity infoEntity in nameList)
{
ZailiukaDto dto = new ZailiukaDto();
if (infoEntity.Flg == "1")
{
dto.ZaiLiuKaNo = infoEntity.ZaiLiuKaNo;
dto.UserName = infoEntity.UserName;
dto.Sex = Enum.GetName(typeof(Sex), Convert.ToInt32(infoEntity.Sex));
dto.Birthday = infoEntity.Birthday.ToString();
dto.PermitDay = infoEntity.PermitDay;
dto.Adress = infoEntity.Adress;
foreach (QualificationEntity qEntity in qualificationList)
{
if (qEntity.ZaiLiuKaNo == dto.ZaiLiuKaNo)
{
dto.Qualification = Enum.GetName(typeof(Qualification), Convert.ToInt32(qEntity.Type));
}
}
foreach (MotivationEntity mEntity in motivationList)
{
if (mEntity.ZaiLiuKaNo == dto.ZaiLiuKaNo)
{
if (mEntity.Type.Contains(','))
{
string[] moti = mEntity.Type.Split(',');
foreach (string m in moti)
{
dto.Motivation = "";
dto.Motivation += Enum.GetName(typeof(Motivation), Convert.ToInt32(m)) + ",";
}
dto.Motivation = dto.Motivation.Substring(0, dto.Motivation.Length - 1);
}
else
{
dto.Motivation = Enum.GetName(typeof(Motivation), Convert.ToInt32(mEntity.Type));
}
}
}
dtoList.Add(dto);
}
}
}
if (!dtoList.ToString().IsEmpty())
{
return(dtoList);
}
else
{
return(null);
}
}
public List <ZailiukaDto> SearchAll()
{
ZailiukaInfoEntity zaiLiuKaInfoEntity = new ZailiukaInfoEntity();
QualificationEntity qualificationEntity = new QualificationEntity();
MotivationEntity motivationEntity = new MotivationEntity();
zaiLiuKaInfoEntity.IncludeAll();
qualificationEntity.IncludeAll();
motivationEntity.IncludeAll();
List <ZailiukaDto> dtoList = new List <ZailiukaDto>();
List <ZailiukaInfoEntity> zaiLiuKaList = this.ZailiukaInfo.GetList();
List <QualificationEntity> qualificationList = this.Qualification.GetList();
List <MotivationEntity> motivationList = this.Motivation.GetList();
// List<ZailiukaInfoEntity> allList = new List<ZailiukaInfoEntity>();
foreach (ZailiukaInfoEntity zEntity in zaiLiuKaList)
{
ZailiukaDto dto = new ZailiukaDto();
if (zEntity.Flg == "1")
{
dto.ZaiLiuKaNo = zEntity.ZaiLiuKaNo;
dto.UserName = zEntity.UserName;
dto.Sex = Enum.GetName(typeof(Sex), Convert.ToInt32(zEntity.Sex));
dto.Birthday = zEntity.Birthday.ToString();
dto.PermitDay = zEntity.PermitDay;
dto.Adress = zEntity.Adress;
foreach (QualificationEntity qEntity in qualificationList)
{
if (qEntity.ZaiLiuKaNo == dto.ZaiLiuKaNo)
{
dto.Qualification = Enum.GetName(typeof(Qualification), Convert.ToInt32(qEntity.Type));
}
}
foreach (MotivationEntity mEntity in motivationList)
{
if (mEntity.ZaiLiuKaNo == dto.ZaiLiuKaNo)
{
if (mEntity.Type.Contains(','))
{
string[] moti = mEntity.Type.Split(',');
foreach (string m in moti)
{
dto.Motivation = "";
dto.Motivation += Enum.GetName(typeof(Motivation), Convert.ToInt32(m)) + ",";
}
dto.Motivation = dto.Motivation.Substring(0, dto.Motivation.Length - 1);
}
else
{
dto.Motivation = Enum.GetName(typeof(Motivation), Convert.ToInt32(mEntity.Type));
}
}
}
dtoList.Add(dto);
}
}
if (!dtoList.ToString().IsEmpty())
{
return(dtoList);
}
else
{
return(null);
}
}
