/*会将外校的修改为本校的*/ public bool updateMem(Person person, XiaoYan xiaoyan) {//update member who is only xiaoyan bool res = true; try { if (person.Pgrade == "XiaoYan" && person.PID == xiaoyan.PID) { _persondal.Update(person); _memdal.Update(xiaoyan); } else { return(false); } } catch (Exception e) { res = false; using (StreamWriter writer = new StreamWriter(@"C:\Users\JJH\Desktop\log.txt", true)) { writer.WriteLine(DateTime.Now.ToString()); writer.WriteLine(e.Message); writer.WriteLine(e.StackTrace); } } return(res); }
public void deleteMem(Guid pid) { var mems = _ecdal.GetEntities(m => m.PID == pid); XiaoYan xy = null; foreach (var mem in mems) { xy = mem; } var pers = _persondal.GetEntities(m => m.PID == pid); Person ps = null; foreach (var per in pers) { ps = per; } var accs = _account.GetEntities(m => m.Username == ps.Username); Account at = null; foreach (var acc in accs) { at = acc; } if (xy != null) { _memdal.Delete(xy); _persondal.Delete(ps); _account.Delete(at); } }
protected void Button1_Click(object sender, EventArgs e) { Helper helper = new Helper(); ECService ec = new ECService(Label1.Text); Guid Pid = Guid.NewGuid(); Guid XiaoYanid = Guid.NewGuid(); XiaoYan x = new XiaoYan(); Person p = new Person(); Account a = new Account(); a.Password = TextBox17.Text; a.Username = TextBox17.Text; a.UserID = Guid.NewGuid(); x.isActive = true; x.isEC = false; x.Sid = ec._ec.Sid; x.PID = Pid; x.XYID = XiaoYanid; p.PID = Pid; p.Username = TextBox17.Text; p.Pname = TextBox13.Text; p.Pgrade = "XiaoYan"; p.Ppro = TextBox15.Text; p.Psex = DropDownList1.Text; p.Ptel = TextBox4.Text; p.PwechatID = TextBox5.Text; p.Pemail = TextBox6.Text; p.Pcontact = TextBox7.Text; p.Pjob4u = TextBox8.Text; p.Ptime = helper.string2long(datel.Value); p.Pwork_years = Convert.ToInt16(TextBox16.Text); p.Padvs = TextBox9.Text; p.Pact4water = TextBox10.Text; p.Pact4fire = TextBox11.Text; p.Pfield_of_firm = TextBox12.Text; //XiaoYanDal xd= new XiaoYanDal(); //PersonDal pd= new PersonDal(); //AccountDal ad = new AccountDal(); //ad.Insert(a); //pd.Insert(p); //xd.Insert(x); try { ec.insertMem(a, p, x); Response.Write("<script>alert('插入成功!')</script>"); } catch (Exception ex) { Response.Write("<script>alert('插入失败!')</script>"); } }
public void sdxvv() { XiaoYanDal xyd = new XiaoYanDal(); XiaoYan x = new XiaoYan(); x.isActive = true; x.isEC = false; x.PID = Guid.NewGuid(); x.Sid = 1; xyd.Insert(x); }
public ECService(string username) { _persondal = new PersonDal(); _ecdal = new XiaoYanDal(); _memdal = new XiaoYanDal(); _account = new AccountDal(); var resultp = _persondal.GetEntities(i => i.Username == username); foreach (var p in resultp) { _person = p; } var resulte = _ecdal.GetEntities(i => i.PID == _person.PID); foreach (var e in resulte) { _ec = e; } }
public XiaoYanService(string username) { _persondal = new PersonDal(); _xiaoyandal = new XiaoYanDal(); var resultp = _persondal.GetEntities(i => i.Username == username); foreach (var p in resultp) { _person = p; } if (_person != null) { var resultx = _xiaoyandal.GetEntities(i => i.PID == _person.PID); foreach (var x in resultx) { _xiaoyan = x; } } }
public bool insertMem(Account account, Person person, XiaoYan xiaoyan) { bool res = true; try { _account.Insert(account); _persondal.Insert(person); _memdal.Insert(xiaoyan); } catch (Exception e) { res = false; using (StreamWriter writer = new StreamWriter(@"C:\Users\lenovo\Desktop\log.txt", true)) { writer.WriteLine(DateTime.Now.ToString()); writer.WriteLine(e.Message); writer.WriteLine(e.StackTrace); } } return(res); }
//修改自己的信息 public void updateInfo(Person person, XiaoYan ec) { _persondal.Update(person); _ecdal.Update(ec); }
public void updateInfo(Person person, XiaoYan xiaoyan) { _persondal.Update(person); _xiaoyandal.Update(xiaoyan); }
//update member grade public bool updateMemGrade(Person person, string toGrade) { bool res = true; Person tPerson = null; var persondal = new PersonDal(); //get the person's old profile var pres = persondal.GetEntities(m => m.PID == person.PID); try { foreach (var p in pres) { tPerson = p; } if (person.Pgrade != toGrade) //若前后grade不一致 //update person first { updatePersonGrade(person, toGrade); //update Member later switch (person.Pgrade) { case "XiaoYan": case "EC": { //get the old profile of the member var oldmem = new XiaoYan(); var xymemdal = new XiaoYanDal(); var mems = xymemdal.GetEntities(m => m.PID == person.PID); foreach (var p in mems) { oldmem = p; } //update the member profile if (toGrade == "EC") { //XiaoYan=>EC,set EC flag xymemdal.Update(new XiaoYan { XYID = oldmem.XYID, PID = oldmem.PID, Sid = oldmem.Sid, isEC = true, isActive = oldmem.isActive }); } else if (toGrade == "XiaoYan") { //EC=>XiaoYan,unset EC flag xymemdal.Update(new XiaoYan { XYID = oldmem.XYID, PID = oldmem.PID, Sid = oldmem.Sid, isEC = false, isActive = oldmem.isActive }); } else if (toGrade == "DaYan") { var dymemdal = new DaYanDal(); //inactivate the xiaoyan xymemdal.Update(new XiaoYan { XYID = oldmem.XYID, PID = oldmem.PID, Sid = oldmem.Sid, isEC = oldmem.isEC, isActive = false }); //insert a dayan dymemdal.Insert(new DaYan { DYID = Guid.NewGuid(), PID = oldmem.PID, Sid = oldmem.Sid, isECleader = false, isActive = true }); } break; } case "DaYan": case "ECleader": { var oldmem = new DaYan(); var dymemdal = new DaYanDal(); var mems = dymemdal.GetEntities(m => m.PID == person.PID); foreach (var p in mems) { oldmem = p; } if (toGrade == "ECleader") { //DaYan=>ECleader,set ECleader flag dymemdal.Update(new DaYan { DYID = oldmem.DYID, PID = oldmem.PID, Sid = oldmem.Sid, isECleader = true, isActive = oldmem.isActive }); } else if (toGrade == "DaYan") { //ECleader=>DaYan,unset ECleader flag dymemdal.Update(new DaYan { DYID = oldmem.DYID, PID = oldmem.PID, Sid = oldmem.Sid, isECleader = false, isActive = oldmem.isActive }); } break; } } } } catch (Exception e) { res = false; using (StreamWriter writer = new StreamWriter(@"C:\Users\JJH\Desktop\log.txt", true)) { writer.WriteLine(DateTime.Now.ToString()); writer.WriteLine(e.Message); writer.WriteLine(e.StackTrace); } } return(res); }