public static string QueryEmploeeTel(string ename) { string r = ""; Sys_EmployeeDpt sed = new Sys_EmployeeDpt(); Sys_EmployeeBll seb = new Sys_EmployeeBll(); Sys_EmployeeDptBll sedb = new Sys_EmployeeDptBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { sed = sedb.Query(" and eno=(select eno from Sys_Employee where ename='" + ename + "') "); if (sed != null) { r = sed.etelephone; } else { r = ""; } } else { r = iv.badstr; } return(r); }
public static string LoginSystem(string iuname, string iupwd) { string r = ""; SysExpireBll seb = new SysExpireBll(); //if (seb.SysExpire()) //{ string jmsz = DES.EncryptDES(iupwd); if (!string.IsNullOrEmpty(iuname) && !string.IsNullOrEmpty(iupwd)) { Sys_User model = new Sys_User(); Sys_Employee ee = new Sys_Employee(); Sys_EmployeeDpt eed = new Sys_EmployeeDpt(); Sys_UserBll sub = new Sys_UserBll(); Sys_EmployeeBll eb = new Sys_EmployeeBll(); model = sub.Query(" and uname='" + iuname + "' and upass='******' and ulogin='******'"); if (model == null) { r = "F"; } else { r = "S"; ee = eb.Query(" and eno='" + model.eno + "'"); if (ee.dcode != "") { Sys_Depment sd = sdb.Query(" and dcode='" + ee.dcode + "'"); ee.dname = sd != null ? sd.dname : ""; } eed = sedb.Query(" and eno='" + ee.eno + "'"); if (eed != null) { ee.etelephone = eed.etelephone; } ee.elname = iuname; HttpContext.Current.Session["LUser"] = ee; Guid uniqueID = Guid.NewGuid(); OnLineUser olu = new OnLineUser(); olu.Gid = uniqueID; olu.Zt = 0; olu.Username = model.uname; UserCacheImp uci = new UserCacheImp(); if (HttpContext.Current.Request.Cookies["Cuser"] != null) { HttpCookie c*k = HttpContext.Current.Request.Cookies["Cuser"]; c*k.Values["cuser"] = System.Web.HttpUtility.UrlEncode(model.uname); HttpContext.Current.Response.AppendCookie(c*k); } else { HttpCookie cookie = new HttpCookie("Cuser"); cookie.Values.Add("cuser", System.Web.HttpUtility.UrlEncode(model.uname)); HttpContext.Current.Response.AppendCookie(cookie); } uci.Add(olu, "U"); } } else { HttpContext.Current.Session["LUser"] = null; r = "F"; } // } //else //{ // r = "F"; //} return(r); }
public static string QueryEmploee(string eno) { string r = ""; VEmploee ve = new VEmploee(); Sys_Employee se = new Sys_Employee(); Sys_User su = new Sys_User(); Sys_EmployeeDpt sed = new Sys_EmployeeDpt(); Sys_EmployeeBll seb = new Sys_EmployeeBll(); Sys_UserBll sub = new Sys_UserBll(); Sys_EmployeeDptBll sedb = new Sys_EmployeeDptBll(); SessionUserValidate iv = SysValidateBll.ValidateSession(); if (iv.f) { if (eno == "") { ve.eno = "E" + seb.GetEno().ToString().PadLeft(8, '0'); ve.eaddress = ""; ve.eage = "0"; ve.eeducation = ""; ve.eemail = ""; ve.eheadimage = ""; ve.eidentity = ""; ve.enativeplace = ""; ve.esex = "0"; ve.etelephone = ""; ve.eworkdate = ""; ve.estate = "1"; ve.elogin = "******"; ve.id = 0; } else { se = seb.Query(" and eno='" + eno + "'"); sed = sedb.Query(" and eno='" + eno + "'"); su = sub.Query(" and eno='" + eno + "'"); ve.dname = se.dname; ve.dcode = se.dcode; ve.eno = se.eno; ve.ename = se.ename; ve.estate = se.estate == true ? "1" : "0"; ve.dtcode = ""; ve.elogin = se.elogin == true ? "1" : "0"; ve.rcode = se.rcode; if (sed != null) { ve.eaddress = sed.eaddress; ve.eage = sed.eage.ToString(); ve.eeducation = sed.eeducation; ve.eemail = sed.eemail; ve.eheadimage = sed.eheadimage; ve.eidentity = sed.eidentity; ve.enativeplace = sed.enativeplace; ve.esex = sed.esex == true ? "1" : "0"; ve.etelephone = sed.etelephone; ve.eworkdate = sed.eworkdate; } else { ve.eaddress = ""; ve.eage = ""; ve.eeducation = ""; ve.eemail = ""; ve.eheadimage = ""; ve.eidentity = ""; ve.enativeplace = ""; ve.esex = "0"; ve.etelephone = ""; ve.eworkdate = ""; } if (su != null) { ve.upass = DES.DecryptDES(su.upass); ve.uname = su.uname; } ve.id = se.id; } r = js.Serialize(ve); } else { r = iv.badstr; } return(r); }