public static Supplier Get(string guidOrEmail) { /*SupplierGet @id varchar(50) --Id,Guid or Email */ /*[Id], GroupId, Guid, Email, [Name], Gender, * CompanyName, Industry,Nature, Address, PhoneNumber, * ZIP, Website, FirstLogin, LastLogin, * LastIP, LoginTimes, Points, Status, * * FaxNumber, FoundedYear, ServiceAreas, Categories, Industries,CategoryLeadsNum, * AllowMatch,MatchMode,Balance */ Supplier sp = null; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "SupplierGet", new SqlParameter[] { Database.MakeInParam("@id", SqlDbType.VarChar, 50, guidOrEmail) }); if (reader.Read()) { sp = new Supplier(); sp.id = reader.GetInt32(0); sp.groupId = reader.GetInt32(1); sp.guid = reader.GetString(2); sp.email = reader.GetString(3); sp.name = reader.GetString(4); sp.gender = Convert.ToChar(reader.GetString(5)); sp.companyName = reader.GetString(6); sp.industry = reader.GetString(7); sp.nature = reader.GetString(8); sp.address = reader.GetString(9); sp.phoneNumber = reader.GetString(10); sp.zip = reader.GetString(11); sp.website = reader.GetString(12); sp.regDate = reader.GetDateTime(13); sp.firstLogin = reader.GetDateTime(14); sp.lastLogin = reader.GetDateTime(15); sp.lastIP = reader.GetString(16); sp.loginTimes = reader.GetInt32(17); sp.points = reader.GetInt32(18); sp.status = (CompanyStatus)(reader.GetInt16(19)); sp.faxNumber = reader.GetString(20); sp.foundedYear = reader.GetInt16(21); sp.serviceAreas=reader.IsDBNull(22)?"":reader.GetString(22); sp.categories = reader.IsDBNull(23) ? "" : reader.GetString(23); sp.industries = reader.IsDBNull(24) ? "" : reader.GetString(24); sp.categoryLeadsNums = reader.IsDBNull(25) ? "" : reader.GetString(25); sp.allowMatch = reader.GetString(26) == "1"; sp.matchMode = reader.GetString(27) == "A" ? SupplierMatchMode.Auto : SupplierMatchMode.Manual; sp.balance = Convert.ToSingle(reader.GetValue(28)); } reader.Close(); } catch { throw; } finally { if (reader != null) { reader.Close(); } } if (sp != null) { Group gp = Group.Get(sp.groupId); if (gp != null) { sp.rights = SupplierRights.ConvertFromString(gp.Rights) as SupplierRights; } } return sp; }
/// <summary> /// ��Ӧ��ע�� /// </summary> private void DoRegister() { if (Request.Form["email"] != null && Request.Form["pwd"] != null && Request.Form["confirmPwd"] != null && Request.Form["uname"] != null && Request.Form["ugender"] != null && Request.Form["comName"] != null && //Request.Form["comIndustry"]!=null && Request.Form["comNature"] != null && Request.Form["comFounded"] != null && Request.Form["comLocation"] != null && Request.Form["comAddress"] != null && Request.Form["comPhone"] != null && Request.Form["comFax"] != null && Request.Form["comWebsite"] != null && Request.Form["category"] != null) { string email = Request.Form["email"].Trim(); if (!Util.IsValidEmail(email)) { Response.Write("showErrInputMsg(\"Email\",\"�ʼ���ַ��ʽ����\");"); return; } if (Company.IsExistsEmail(email)) { Response.Write("showErrInputMsg(\"Email\",\"�ʼ���ַ�Ѿ���ʹ�ã�\");"); return; } string pwd = Request.Form["pwd"].Trim(); string uname = Request.Form["uname"].Trim(); string gender = Request.Form["ugender"].Trim(); string comName = Request.Form["comName"].Trim(); string comIndus = "000000";//Request.Form["comIndustry"].Trim(); string comNature = Request.Form["comNature"].Trim(); string comFounded = Request.Form["comFounded"].Trim(); string location = Request.Form["comLocation"].Trim(); string addr = Request.Form["comAddress"].Trim(); string phone = Request.Form["comPhone"].Trim(); string fax = Request.Form["comFax"]; string web = Request.Form["comWebsite"]; if (String.IsNullOrEmpty(uname)) { Response.Write("showErrInputMsg(\"Uname\",\"������������\");"); return; } if (String.IsNullOrEmpty(comName)) { Response.Write("showErrInputMsg(\"ComName\",\"��ҵ���Ʋ���Ϊ�գ�\");"); return; } try { int fy = Convert.ToInt16(comFounded); if (fy < 1800 || fy > DateTime.Now.Year) { Response.Write("showErrInputMsg(\"ComFounded\",\"��ҵ������ݱ������1800-" + DateTime.Now.Year.ToString() + "֮�䣡\");"); return; } } catch { Response.Write("showErrInputMsg(\"ComName\",\"��ҵ������ݱ���ʹ��4λ�������룡\");"); return; } if (String.IsNullOrEmpty(addr)) { Response.Write("showErrInputMsg(\"ComName\",\"��ҵ��ϸ��ַ����Ϊ�գ�\");"); return; } if (String.IsNullOrEmpty(phone)) { Response.Write("showErrInputMsg(\"ComName\",\"��ҵ�绰���벻��Ϊ�գ�\");"); return; } Supplier sp = new Supplier(); sp.InviteUserId = base.InviteUserId; sp.Email = email; sp.Name = uname; sp.Gender = gender.ToCharArray(0, 1)[0]; sp.Password = pwd; sp.CompanyName = comName; sp.Nature = comNature; sp.Industry = comIndus; sp.FoundedYear = Convert.ToInt16(comFounded); sp.ZIP = location; sp.Address = addr; sp.PhoneNumber = phone; sp.FaxNumber = fax; sp.Website = web.StartsWith("http://", StringComparison.OrdinalIgnoreCase) ? web : "http://" + web; sp.RegDate = DateTime.Now; if (sp.Register()) { Cookies.WriteCookie("SP_REG_TEMP","",360,"id="+sp.Id.ToString()+"&guid=" + sp.Guid + "&categories=" + Request.Form["category"].Trim() + "&email=" + email + "&pwd=" + pwd + "&comname=" + comName + "&name=" + uname + "&gender=" + gender); Response.Write("true"); } else { Response.Write("setMessage(\"ע������г��ִ������������Ƿ����Ҫ��\",false);"); } } }