/// <summary> /// 价值评分查询 /// </summary> private void SetGradeTabList() { Tz888.BLL.Common.IndustryBLL bllIn = new Tz888.BLL.Common.IndustryBLL(); this.ddlSetGrade.DataSource = bllIn.SetGradeTab(); this.ddlSetGrade.DataTextField = "GradeName"; this.ddlSetGrade.DataValueField = "GradeID"; this.ddlSetGrade.DataBind(); }
public string GetIndustry(object obj) { string str = obj.ToString().Trim(); string strIndustry = "无"; if (str != "") { string[] strList = str.Split(','); Tz888.BLL.Common.IndustryBLL objI = new Tz888.BLL.Common.IndustryBLL(); strIndustry = ""; for (int i = 0; i < strList.Length; i++) { if (strList[i] != "") { strIndustry = strIndustry + objI.GetNameByID(strList[i]) + ";"; } } strIndustry = strIndustry.Substring(0, strIndustry.Length - 1); } return(strIndustry); }
public string GetIndustryList() { Tz888.BLL.Common.IndustryBLL bll = new Tz888.BLL.Common.IndustryBLL(); DataView dv = bll.dvGetAllIndustry(); string str = ""; if (dv == null) { return(str); } for (int m = 0; m < dv.Table.Rows.Count; m++) { if (m == 0) { str = dv[m]["IndustryBID"].ToString().Trim() + "|" + dv[m]["IndustryBName"].ToString().Trim(); } else { str += "," + dv[m]["IndustryBID"].ToString().Trim() + "|" + dv[m]["IndustryBName"].ToString().Trim(); } } return(str); }
protected void Page_Load(object sender, EventArgs e) { ///------------------------------ ///--design by AdSystem_20090620 ///------------------------------ bool isBuy = false; string viewid = "0"; string loginName = ""; if (Request.QueryString["v"] != null && Request.QueryString["v"].ToString() != "") { viewid = Request.QueryString["v"].ToString().Trim(); } if (Request.QueryString["LoginName"] != null && Request.QueryString["LoginName"].ToString() != "") { loginName = Request.QueryString["LoginName"].ToString().Trim(); } AdSystem.Logic loc = new AdSystem.Logic(); isBuy = loc.ViewInfo_IsBuy(Convert.ToInt64(viewid), loginName); if (!isBuy) { Response.Write("<script language=javascript>alert('您没有查看的权限,查询此信息需要花费1元,请先购买!');window.close();</script>"); return; } //要传的值 ManageTypeID = 1003 LoginName if (Request.QueryString["LoginName"] != null) { LoginName = Request.QueryString["LoginName"].ToString(); //注册信息 Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL(); DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + LoginName + "'", "LoginName"); //登记联系人 Tz888.BLL.Register.common obj2 = new Tz888.BLL.Register.common(); Tz888.Model.Register.OrgContactModel model2 = new Tz888.Model.Register.OrgContactModel(); model2 = obj2.getContactModel(LoginName); //会员信息表 Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel(); Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL(); model3 = obj3.GetModel("LoginName='" + LoginName + "'"); //会员登陆信息 Tz888.SQLServerDAL.Conn obj4 = new Tz888.SQLServerDAL.Conn(); // DataTable dt4 = obj4.GetList("LoginLogTab", "LoginTime", "LoginTime", 10000, 1, 0, 1, "LoginName='" + LoginName + "'"); //会员发布信息 // DataTable dt5 = obj4.GetList("MainInfoViw", "Title,PublishT,HtmlFile", "PublishT", 1000, 1, 0, 1, "LoginName='" + LoginName + "'"); //公司登记信息 Tz888.BLL.Register.EnterpriseRegisterBLL obj6 = new Tz888.BLL.Register.EnterpriseRegisterBLL(); DataTable dt6 = obj6.getEnterpriseModel(LoginName); //公司附加信息 // DataTable dt7 = obj4.GetList("MemberResourceTab", "*", "LoginName", 1, 1, 0, 1, "LoginName='kittycat'"); if (dt1 != null) { #region 信息绑定 lbRealName.Text = dt1.Rows[0]["RealName"].ToString() == "" ? dt1.Rows[0]["NickName"].ToString() : dt1.Rows[0]["RealName"].ToString(); lbLoginName.Text = dt1.Rows[0]["LoginName"].ToString(); lbNickName.Text = dt1.Rows[0]["NickName"].ToString(); lblNickName2.Text = dt1.Rows[0]["NickName"].ToString(); HyperLink1.NavigateUrl = "http://member.topfo.com/helper/FriendManager/FriendFore.aspx?name=" + lbLoginName.Text; HyperLink2.NavigateUrl = "http://member.topfo.com/InnerInfo/SendView.aspx?name=" + lbNickName.Text; switch (dt1.Rows[0]["ManageTypeID"].ToString().Trim()) { case "1001": lbManageType.Text = "个人会员"; break; case "1003": lbManageType.Text = "企业会员"; break; case "1004": lbManageType.Text = "政府会员"; break; default: break; } switch (dt1.Rows[0]["MemberGradeID"].ToString().Trim()) { case "1001": GradeDiv.Visible = false; break; case "1002": GradeDiv.Visible = true; break; default: GradeDiv.Visible = false; break; } string req = dt1.Rows[0]["RequirInfo"].ToString(); string[] strReq = req.Split(','); string strRequar = ""; for (int i = 0; i < strReq.Length; i++) { switch (strReq[i].Trim()) { case "1001": strRequar += "政府招商 "; break; case "1002": strRequar += "企业招商 "; break; case "1003": strRequar += "项目融资 "; break; case "1004": strRequar += "项目投资 "; break; case "1005": strRequar += "创业合作 "; break; case "1006": strRequar += "产品供求 "; break; default: break; } } lbRequar.Text = strRequar;//会员意向 lbRegTime.Text = dt1.Rows[0]["RegisterTime"].ToString(); if (model3 != null) { lbSex.Text = model3.Sex ? "(女)" : "(男)"; imgHead.ImageUrl = model3.HeadPortrait.ToString() != "" ? ConfigurationManager.AppSettings["ImageDomain"].ToString() + "/" + model3.HeadPortrait.ToString() : "../images/MemberData/nopic.gif"; } if (model2 != null) { lbCareer.Text = model2.Career; lbOrganizationName.Text = model2.OrganizationName != "" ? model2.OrganizationName : "暂无"; lbtAddress.Text = model2.address != "" ? model2.address : "暂无"; string tel = model2.TelCountryCode + model2.TelStateCode + model2.TelNum; lbTel.Text = tel != "" ? tel : "暂无"; lbMoble.Text = model2.Mobile != "" ? model2.Mobile : "暂无"; string fax = model2.FaxCountryCode + model2.FaxStateCode + model2.FaxNum; lbFax.Text = fax != "" ? fax : "暂无"; lbSite.Text = model2.Website != "" ? model2.Website : "暂无"; } int rowCount = Convert.ToInt32(obj4.GetList("LoginLogTab", "LoginTime", "LoginTime", 1, 1, 1, 1, "LoginName='" + LoginName + "'").Rows[0][0]); if (rowCount > 0) { DataTable dt4 = obj4.GetList("LoginLogTab", "LoginTime", "LoginTime", 1, 1, 0, 1, "LoginName='" + LoginName + "'"); lbLoginCount.Text = rowCount.ToString(); lbLoginB.Text = dt4.Rows[0]["LoginTime"].ToString(); } else { lbLoginCount.Text = "1"; lbLoginB.Text = DateTime.Now.ToShortDateString(); } lbPublishCount.Text = obj4.GetList("MainInfoViw", "Title,PublishT,HtmlFile", "PublishT", 1, 1, 1, 1, "LoginName='" + LoginName + "' ").Rows[0][0].ToString(); if (dt6 != null) { string strMP = dt6.Rows[0]["MainProduct"].ToString(); string MainProduct = ""; if (strMP.Trim() != "") { MainProduct = strMP.Remove(strMP.Length - 1); } lbMainProduct.Text = MainProduct != "" ? MainProduct : "暂无"; string str = dt6.Rows[0]["Industrylist"].ToString(); string[] strList = str.Split(','); Tz888.BLL.Common.IndustryBLL obj7 = new Tz888.BLL.Common.IndustryBLL(); string strIndustry = ""; for (int i = 0; i < strList.Length; i++) { if (strList[i] != "") { strIndustry += obj7.GetNameByID(strList[i]) + " "; } } lbIndustryModels.Text = strIndustry != "" ? strIndustry : "暂无"; // 2已审核(已审基本信息),0未审核、1审核通过、3审核不通过、4退款 if (dt6.Rows[0]["AuditingStatus"].ToString() == "1") { //查询认证信息 DataTable ddt6 = obj4.GetList("OrgAuditTab", "*", "AuditingDate", 1, 1, 0, 1, "LoginName='" + LoginName + "'"); lbAuditingStatus.Text = ddt6.Rows[0]["AuditingDate"].ToString() + "通过认证"; } else { lbAuditingStatus.Text = "暂未通过认证"; } lbExhibitionHall.Text = dt6.Rows[0]["ExhibitionHall"].ToString() != "" ? "http://www." + dt6.Rows[0]["ExhibitionHall"].ToString() + ".co.tz888.cn " : "暂无"; } /// 资源类型 /// 0 -其他文档 /// 1 -图片 /// 2 -视频 /// <summary> /// 资源性质 /// 0 --其他 /// 1--立项批文 ///2--商业计划书 ///3 --项目视频展播 /// 附:(公司登记附件 4-8) ///4营业执照 ///5税务登记证(国税) ///6税务登记证(地税) ///7荣誉和证书 ///8其它 if (Page.User.IsInRole("GT1001")) //普通会员 { spanRM.Visible = false; } else { DataTable dtmr4 = obj4.GetList("MemberResourceTab", "*", "LoginName", 1, 1, 0, 1, "LoginName='" + LoginName + "' AND ResourceType=4"); if (dtmr4 != null) { lbResourceType4.Text = dtmr4.Rows.Count == 0 ? "暂无" : dtmr4.Rows.Count + "张己上传"; } else { lbResourceType4.Text = "暂无"; } DataTable dtmr56 = obj4.GetList("MemberResourceTab", "*", "LoginName", 1, 1, 0, 1, "LoginName='" + LoginName + "' AND ResourceType=5 OR ResourceType=6"); if (dtmr56 != null) { lbResourceType56.Text = dtmr56.Rows.Count == 0 ? "暂无" : dtmr4.Rows.Count + "张己上传"; } else { lbResourceType56.Text = "暂无"; } DataTable dtmr7 = obj4.GetList("MemberResourceTab", "*", "LoginName", 1, 1, 0, 1, "LoginName='" + LoginName + "' AND ResourceType=7"); if (dtmr7 != null) { lbResourceType7.Text = dtmr7.Rows.Count == 0 ? "暂无" : dtmr4.Rows.Count + "张己上传"; } else { lbResourceType7.Text = "暂无"; } } } #endregion } else { Tz888.Common.MessageBox.Show(this.Page, "请求出错"); } }
protected void Page_Load(object sender, EventArgs e) { if (Page.User.Identity.Name == null || Page.User.Identity.Name.Trim() == "") { Response.Redirect("../Login.aspx?ReturnUrl=" + Server.UrlEncode(Request.RawUrl)); } //根据会员类型转向不同的登记页面 if (Page.User.IsInRole("MT1004")) { Response.Redirect("GovernmentRegisterResult.aspx"); //机构 } else if (Page.User.IsInRole("MT1001")) //个人 { Tz888.Common.MessageBox.Show(this.Page, "对不起,个人会员不能进行登记!"); if (Page.User.IsInRole("GT1001")) { Response.Write("index.aspx"); } else { Response.Write("indexTop.aspx"); } } Tz888.BLL.Register.EnterpriseRegisterBLL obj = new EnterpriseRegisterBLL(); this.ViewState["MemberLoginName"] = Page.User.Identity.Name; /*登记审核状态(待审核0 已发布上网1 未通过审核2 己删除3 ) * FeedbackStatus 反馈状态(0 可修改 1 将删除)*/ if (Page.User.IsInRole("GT1001")) { divReg.InnerHtml = " <strong>重要提示:</strong>请确保您发布的公司资料真实有效,由于发布虚假信息产生的任何责任," + "由发布者自行承担! 想让您的公司介绍排在普通会员的前面被更多用户关注吗?点此<a href='VIPMemberRegister_In.aspx'>申请拓富通</a>" + " 0755-82210116 82212980 在线客服"; } if (Page.User.IsInRole("GT1002")) { divReg.InnerHtml = ""; } DataTable dt = obj.getEnterpriseModel(this.ViewState["MemberLoginName"].ToString()); if (dt == null) { Response.Redirect("EnterpriseRegister.aspx"); return; } else if (dt.Rows.Count > 0) { //判断登记信息是的审核状态(AuditingStatus)1:审核状态: 2已审核(已审基本信息),0未审核、1审核通过、 //3审核不通过、4退款(注意:审核为拓富通会员后不出现在此列表),付费状态和审核状态无关。 switch (Convert.ToInt32(dt.Rows[0]["AuditingStatus"])) { case 0: lbMessage.Text = "您的公司资料还在审核过程中..."; break; case 1: //基本信息 lbMessage.Text = "您的公司资料己审核通过!"; break; case 2: //审核信息 lbMessage.Text = "您的公司资料审核没有通过!"; Tz888.SQLServerDAL.Conn objStatus = new Tz888.SQLServerDAL.Conn(); DataTable dtStatus = objStatus.GetList("OrgAuditTab", "*", "AuditingDate", 1, 1, 0, 1, "LoginName='" + this.ViewState["MemberLoginName"].ToString() + "'"); if (dtStatus.Rows.Count > 0) { switch (dtStatus.Rows[0]["FeedbackStatus"].ToString()) //0即将删除 1可修改 2己发布 { case "2": lbFeedbackStatus.Text = "状态:即将删除"; lbResult.Text = "原因:" + dtStatus.Rows[0]["AuditingRemark"].ToString(); break; case "1": lbFeedbackStatus.Text = "状态:可修改"; lbResult.Text = "原因:" + dtStatus.Rows[0]["AuditingRemark"] + "<a href='EnterpriseRegister.aspx'>马上去修改</a>"; break; default: break; } } break; default: break; } lbOrgName.Text = dt.Rows[0]["EnterpriseName"].ToString(); lbComAboutBrief.Text = dt.Rows[0]["ComAbout"].ToString(); string str = dt.Rows[0]["Industrylist"].ToString().Trim(); string[] strList = str.Split(','); Tz888.BLL.Common.IndustryBLL obj7 = new Tz888.BLL.Common.IndustryBLL(); string strIndustry = ""; // Response.Write(str); for (int i = 0; i < strList.Length; i++) { if (strList[i] != "") { strIndustry += obj7.GetNameByID(strList[i].Trim()); } } lbindustry.Text = strIndustry != "" ? strIndustry : "暂无"; lbMainProduct.Text = dt.Rows[0]["MainProduct"].ToString(); lbManageType.Text = dt.Rows[0]["SetComTypeName"].ToString(); lbRegisterDate.Text = Convert.ToDateTime(dt.Rows[0]["RegisterDate"]).ToShortDateString(); string CountryName = ""; string ProvinceName = ""; string CountyName = ""; string CityName = ""; try { Tz888.BLL.Common.ZoneSelectBLL objZone = new Tz888.BLL.Common.ZoneSelectBLL(); CountryName = objZone.GetCountyNameByCode(dt.Rows[0]["CountryCode"].ToString()); ProvinceName = objZone.GetProvinceNameByCode(dt.Rows[0]["ProvinceID"].ToString()); CountyName = objZone.GetCountyNameByCode(dt.Rows[0]["CountyID"].ToString()); CityName = objZone.GetCityNameByCode(dt.Rows[0]["CityID"].ToString()); } catch { } lbZone.Text = (CountryName != "" ? CountryName : "") + "" + (ProvinceName != "" ? ProvinceName : "") + "" + (CountyName != "" ? CountyName : "") + "" + (CityName != "" ? CityName : ""); lbRegCapital.Text = dt.Rows[0]["RegCapital"].ToString() + "(万)" + dt.Rows[0]["currency"].ToString(); //联系信息 lbLinkMan.Text = dt.Rows[0]["Name"].ToString() != "" ? dt.Rows[0]["Name"].ToString() : "没有提供"; lbMail.Text = dt.Rows[0]["Email"].ToString() != "" ? dt.Rows[0]["Email"].ToString() : "没有提供"; lbSite.Text = dt.Rows[0]["Website"].ToString() != "" ? dt.Rows[0]["Website"].ToString() : "没有提供"; lbTel.Text = dt.Rows[0]["TelCountryCode"].ToString() + "-" + dt.Rows[0]["TelStateCode"].ToString() + "-" + dt.Rows[0]["TelNum"].ToString(); lbFax.Text = dt.Rows[0]["FaxCountryCode"].ToString() + "-" + dt.Rows[0]["FaxStateCode"].ToString() + "-" + dt.Rows[0]["FaxNum"].ToString(); lbMobile.Text = dt.Rows[0]["Mobile"].ToString() != "" ? dt.Rows[0]["Mobile"].ToString() : "没有提供"; lbAddress.Text = dt.Rows[0]["address"].ToString() != "" ? dt.Rows[0]["address"].ToString() : "没有提供"; //图片信息 Tz888.SQLServerDAL.Conn objResource = new Tz888.SQLServerDAL.Conn(); DataTable dtResource = objResource.GetList("MemberResourceTab", "*", "ResourceID", 1, 1, 0, 1, "LoginName='" + this.ViewState["MemberLoginName"].ToString() + "' AND ResourceProperty=0"); if (dtResource != null && dtResource.Rows.Count > 0) { FileUploader1.Img = Tz888.Common.Common.GetImageDomain() + "/" + dtResource.Rows[0]["ResourceAddr"].ToString();//ConfigurationManager.AppSettings["ImageDomain"].ToString() FileUploader1.ButtonName = ""; } else { FileUploader1.Img = @"../images/publish/noneimg.gif"; FileUploader1.ButtonName = "添加"; FileUploader1.IsUp = "1";//是否通过控件上传 FileUploader1.InfoType = "EnterpriseRegister"; //Response.Write("<Script>document.all('ButAdd').onclick();</script>"); } } else //没有进行公司登记 { Response.Redirect("EnterpriseRegister.aspx"); } }