/*会将外校的修改为本校的*/
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);
}
