protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (Request["id"] != null) { CurrentLead = Lead.Get(Request["id"].Trim()); CurrentLeadInfo = CurrentLead.GetInfo(); } }
protected override void OnInit(EventArgs e) { base.OnInit(e); if (Request.PathInfo.Split('/').Length != 2) { Response.Redirect("/MarketingService/allCategories.aspx"); Response.End(); } guid = Request.PathInfo.Split('/')[1].Trim(); if (guid.Length != 32) { Response.Redirect("/MarketingService/allCategories.aspx"); Response.End(); } CurrentLead = Lead.Get(guid); if (CurrentLead == null) { Response.Redirect("/MarketingService/allCategories.aspx"); Response.End(); } CurrentLeadInfo = CurrentLead.GetInfo(); if (CurrentLeadInfo == null) { Response.Redirect("/MarketingService/allCategories.aspx"); Response.End(); } CurrentBuyer = Buyer.Get(CurrentLead.BuyerId); if (CurrentBuyer == null) { Response.Redirect("/MarketingService/allCategories.aspx"); Response.End(); } }
/// <summary> /// ��ȡLead�б� /// </summary> /// <param name="bid">BuyerId</param> /// <param name="cate">�������</param> /// <param name="area">����</param> /// <param name="indusRequire">�Ƿ�Ҫ����ҵ����</param> /// <param name="natureRequire">��ҵ����Ҫ��</param> /// <param name="chked">���״̬</param> /// <param name="matchSta">ƥ��״̬</param> /// <param name="start">��ʼ����</param> /// <param name="end">��ֹ����</param> /// <param name="pager">��ҳ</param> /// <returns></returns> public static ArrayList List(int bid,string cate, string area, int indusRequire,short natureRequire, short chk, short matchSta,DateTime start,DateTime end, Pager pager) { /* LeadList @buyerId int=0, @category varchar(30)='', @area varchar(100)='', @indusReq smallint=-1, @natureReq smallint=-2, @chk smallint=-1, @mSta smallint=-1, @start varchar(20)='', @end varchar(20)='', @pageIndex int=1, @pageSize int=20, @sort int=0 */ //[Id],Guid, BuyerId,BuyerName,Category, Area, IndustryRequired, Nature, [Datetime], CheckStatus,MatchStatus ArrayList list = new ArrayList(); SqlParameter[] prams ={ Database.MakeInParam("@buyerId",SqlDbType.Int,bid), Database.MakeInParam("@category",SqlDbType.VarChar,30,cate), Database.MakeInParam("@area",SqlDbType.VarChar,100,area), Database.MakeInParam("@indusReq",SqlDbType.SmallInt,indusRequire), Database.MakeInParam("@natureReq",SqlDbType.SmallInt,natureRequire), Database.MakeInParam("@chk",SqlDbType.SmallInt,chk), Database.MakeInParam("@mSta",SqlDbType.SmallInt,matchSta), Database.MakeInParam("@start",SqlDbType.VarChar,20,start==DateTime.MinValue?"":start.ToShortDateString()), Database.MakeInParam("@end",SqlDbType.VarChar,20,end==DateTime.MinValue?"":end.ToShortDateString()), Database.MakeInParam("@pageIndex",SqlDbType.Int,pager.PageIndex), Database.MakeInParam("@pageSize",SqlDbType.Int,pager.PageSize), Database.MakeInParam("@sort",SqlDbType.Int,pager.SortNum), }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "LeadList", prams); if (reader.Read()) { pager.RecordCount = reader.GetInt32(0); if (reader.NextResult()) { while (reader.Read()) { Lead lead = new Lead(); lead.id = reader.GetInt32(0); lead.guid = reader.GetString(1); lead.buyerId = reader.GetInt32(2); lead.buyerName = reader.GetString(3); lead.category = reader.GetString(4); lead.area = reader.GetString(5); lead.industryRequire = reader.GetBoolean(6); lead.natureRequire = reader.GetInt16(7); lead.datetime = reader.GetDateTime(8); lead.checkStatus = (LeadCheckStatus)reader.GetInt16(9); lead.matchStatus = (LeadMatchStatus)reader.GetInt16(10); lead.publicStatus = reader.GetInt16(11); list.Add(lead); } } } reader.Close(); } catch { } finally { if (reader != null) { reader.Close(); } } return list; }
public static Lead Get(string guid) { /* LeadGet @id varchar(32) */ //[Id],Guid, BuyerId,BuyerName,Category, Area, IndustryRequired, Nature, [Datetime], CheckStatus,MatchStatus Lead lead = null; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "LeadGet", new SqlParameter[] {Database.MakeInParam("@id",SqlDbType.VarChar,32,guid) }); if (reader.Read()) { lead = new Lead(); lead.id = reader.GetInt32(0); lead.guid = reader.GetString(1); lead.buyerId = reader.GetInt32(2); lead.buyerName = reader.GetString(3); lead.category = reader.GetString(4); lead.area = reader.GetString(5); lead.industryRequire = reader.GetBoolean(6); lead.natureRequire = reader.GetInt16(7); lead.datetime = reader.GetDateTime(8); lead.checkStatus = (LeadCheckStatus)reader.GetInt16(9); lead.matchStatus = (LeadMatchStatus)reader.GetInt16(10); lead.publicStatus = reader.GetInt16(11); } reader.Close(); } catch { // } finally { if (reader != null) { reader.Close(); } } return lead; }
private void SaveRequire() { //����Buyer if (Request.Form["email"] != null && Request.Form["uname"] != null && Request.Form["ugender"] != null && Request.Form["utitle"] != null && Request.Form["comName"] != null && Request.Form["comIndustry"] != null && Request.Form["comNature"] != null && Request.Form["comEmployee"] != null && Request.Form["comLocation"] != null && Request.Form["comAddress"] != null && Request.Form["comPhone"] != null) { string buyerGuid = Request.Form["buyerId"]==null?"":Request.Form["buyerId"].Trim(); bool isPublic = Request.Form["isPublic"] == null ? false : (Request.Form["isPublic"].Trim() == "1" ? true : false); if (String.IsNullOrEmpty(buyerGuid) && Company.IsExistsEmail(Request.Form["email"].Trim())) { Response.Write("existEmail"); return; } if (String.IsNullOrEmpty(buyerGuid)) { buyerGuid = Util.NewGuid; } Buyer buyer = new Buyer(); buyer.InviteUserId = GetInviteUserId; buyer.Email = Request.Form["email"].Trim(); buyer.Name = Request.Form["uname"].Trim(); buyer.Gender = Convert.ToChar(Request.Form["ugender"].Trim()); buyer.Title = Request.Form["utitle"].Trim(); buyer.CompanyName = Request.Form["comName"].Trim(); buyer.Industry = Request.Form["comIndustry"].Trim(); buyer.Nature = Request.Form["comNature"].Trim(); try { buyer.Employees[0] = Convert.ToInt32(Request.Form["comEmployee"].Split(',')[0]); buyer.Employees[1] = Convert.ToInt32(Request.Form["comEmployee"].Split(',')[1]); } catch { // } buyer.ZIP = Request.Form["comLocation"].Trim(); buyer.Address = Request.Form["comAddress"].Trim(); buyer.PhoneNumber = Request.Form["comPhone"].Trim(); buyer.Website = Request.Form["comWebsite"] != null ? Request.Form["comWebsite"].Trim() : ""; int buyerId = buyer.Save(buyerGuid); if (buyerId > 0) { //���¿ͻ�Email��Cookie Util.WriteCookie("KEBIBI_BUYER_EMAIL", buyer.Email, 360); //����Buyer Cookie buyer.WriteCookie(360); //����Lead Lead lead = new Lead(LeadGuid, CurrentLeadInfo.Category, buyerId); lead.Area = CurrentLeadInfo.Area; lead.IndustryRequire = CurrentLeadInfo.IndustryRequired; lead.NatrueRequire = CurrentLeadInfo.Nature; lead.PublicStatus = isPublic ? (short)1 : (short)0; if (lead.Save()) { //�ƶ���ʱ�����ļ� CurrentLeadInfo.Move(GeneralConfig.AppDataPath + "\\leads\\" + lead.Category + "\\" + DateTime.Now.ToString("yyyyMM")+"\\"); //�����ʼ�֪ͨ MailTempItem mailTemp = MailTemplates.GetTemplate("buyer_require_over_email"); string[] args = new string[] { buyer.CompanyName, lead.Id.ToString(), lead.Datetime.ToShortDateString(), lead.Category, lead.CategoryName, CurrentLeadInfo.ToHtmlListForBuyer2("<p>{0}��{1}</p>") }; SmtpMail sm = SmtpMail.Instance; sm.AddRecipient(new string[] { buyer.Email }); sm.Html = mailTemp.Html; sm.Subject = String.Format(mailTemp.Subject, args); sm.Body = String.Format(mailTemp.Body, args); bool snd = sm.Send(); //ɾ����ʱLead Guid��Cookie Util.RemoveCookie(QuestionaryHandler._COOKIE_NAME); //���浱ǰLead��ID��Cookie Util.WriteCookie("KEBIBI_REQUIRE_INFO", CrypticString.Encrypt("id="+lead.Id.ToString()+"&guid="+lead.Guid+"&date="+lead.Datetime.ToShortDateString()+"&email="+buyer.Email+"&zip="+buyer.ZIP+"&zipName="+buyer.ZIPName+"&category="+lead.Category+"&categoryName="+lead.CategoryName,true)); Response.Write("true"); return; } } } Response.Write("false"); }