/// <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");
}
}
