public bool AddOrg(b01 org, b01Expansion orge)
{
CQGJPassportEntities CQGJ = new CQGJPassportEntities();
orge.b01 = org;
if (org.b0111 == orge.b01.b0111)
{
try
{
CQGJ.AddTob01(org);
CQGJ.AddTob01Expansion(orge);
CQGJ.SaveChanges();
return true;
}
catch
{
}
}
return false;
}
public string ValidateOrg(string orgname, string password)
{
CQGJPassportEntities CQGJ = new CQGJPassportEntities();
b01 Querry = new b01();
string strResult = "";
try
{
Querry = (from b in CQGJ.b01 where (b.b0101 == orgname || b.b0104 == orgname) select b).First();
strResult = Querry.b0111;
}
catch
{
strResult = "";
}
if (strResult.Equals(""))
{
return strResult;
}
else
{
b01Expansion OrgOtherInfo = new b01Expansion();
try
{
OrgOtherInfo = (from i in CQGJ.b01Expansion where i.b01.b0111 == strResult && i.Password == password select i).First();
}
catch
{
strResult = "";
}
}
return strResult;
}
public bool SaveOrgChange(b01 Org, b01Expansion OrgEx)
{
OrgEx.b01 = Org;
CQGJPassportEntities CQGJ = new CQGJPassportEntities();
b01 newOrg = (from c in CQGJ.b01
where c.b0111 == Org.b0111
select c).First();
b01Expansion newOrgEx = (from d in CQGJ.b01Expansion
where d.ID == OrgEx.ID
select d).First();
newOrg.b0101 = Org.b0101;
newOrgEx.Mail = OrgEx.Mail;
newOrgEx.Mobile = OrgEx.Mobile;
newOrgEx.Tel = OrgEx.Tel;
if (newOrgEx.b01==newOrg)
{
int i= CQGJ.SaveChanges();
return true;
}
return false;
}
public string GetOrgType(string orgcode)
{
CQGJPassportEntities CQGJ = new CQGJPassportEntities();
b01Expansion OrgOtherInfo = new b01Expansion();
string strResult = "";
try
{
OrgOtherInfo = (from i in CQGJ.b01Expansion where i.b01.b0111 == orgcode select i).First();
strResult = OrgOtherInfo.OrgType.ToString();
}
catch
{
strResult = "";
}
return strResult;
}
public void CreateOrg()
{
CQGJUserViewData viewData = new CQGJUserViewData();
b01 Org = new b01();
b01Expansion OrgE = new b01Expansion();
int orgType = int.Parse(GetString("OrgType"));
Org.b0101 = GetString("b0101");
Org.b0104 = GetString("b0104");
Org.b0107 = GetString("b0107");
//Org.b0111 = GetString("b0111");
Org.b0111_1 = GetString("b0111_1");
Org.b0111_3 = GetString("b0111_3");
Org.b0114 = GetString("b0114");
Org.b0117 = GetString("b0117");
Org.b01224 = GetString("b01224");
Org.b0127 = GetString("b0127");
Org.b0131 = GetString("b0131");
Org.b0134 = GetString("b0134");
Org.b0137 = GetString("b0137");
Org.b0144_1 = GetString("b0144_1");
Org.b0144_2 = GetString("b0144_2");
Org.b0151_1 = GetString("b0151_1");
Org.b0151_2 = GetString("b0151_2");
Org.b0154_1 = GetString("b0154_1");
Org.b0154_2 = GetString("b0154_2");
Org.b0157_1 = GetString("b0157_1");
Org.b0157_2 = GetString("b0157_2");
Org.b0161 = GetString("b0161");
Org.b0164 = GetDate("b0164");
Org.b0167 = GetString("b0167");
Org.b0171_1 = GetString("b0171_1");
Org.b0171_2 = GetString("b0171_2");
Org.b0174 = GetString("b0174");
Org.b0177 = GetString("b0177");
Org.b0181 = GetDate("b0181");
Org.b0184 = GetString("b0184");
Org.b0187_1 = GetString("b0187_1");
Org.b0187_2 = GetString("b0187_2");
Org.b0191 = GetString("b0191");
Org.b0194 = GetString("b0194");
Org.b0197 = GetString("b0197");
Org.b0199 = GetString("b0199");
if (orgType != 0)
{
Org.b0111 = GetString("b0111");
}
else
{
//Org.b0111 = GetString("b0111");
}
CQGJ.AddTob01(Org);
CQGJ.SaveChanges(true);
OrgE.b01 = Org;
OrgE.Password = Security.MD5Encrypt("123456");
OrgE.OrgType = orgType;
CQGJ.AddTob01Expansion(OrgE);
CQGJ.SaveChanges(true);
viewData.ActionSuccess = true;
viewData.HtmlPage = "单位:" + Org.b0104 + "添加成功。";
viewData.JavaScriptPage = "/admin/OrgInfo/" + Org.b0111;
//调用webservers
CQGJAP.CQGJWebServices ap = new CQGJ.Passport.CQGJAP.CQGJWebServices();
ap.AddOrg(Org.b0111);
RenderView("MessagePage", viewData);
}