public void databind2()
{
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'", "LoginName");
model2 = obj2.GetModel("LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'");
this.ViewState["ManageTypeID"] = dt1.Rows[0]["ManageTypeID"].ToString();
if (dt1.Rows.Count > 0)
{
txtEmail.Text = dt1.Rows[0]["Email"].ToString();
lbLoginName.Text = dt1.Rows[0]["LoginName"].ToString();
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();
}
}
lbNickName.Text = dt1.Rows[0]["NickName"].ToString();
txtCompany.Text = dt1.Rows[0]["CompanyName"].ToString();
txtContactTitle.Text = dt1.Rows[0]["ContactTitle"].ToString();
txtContactName.Text = dt1.Rows[0]["ContactName"].ToString();
this.ViewState["tag"] = "add";
if (model2 != null)
{
txtMobile.Text = model2.Mobile;
txtAddress.Text = model2.Address;
txtPostCode.Text = model2.PostCode;
this.ViewState["tag"] = "update";
}
}
}
//初始化联络人信息
private void InitInfoContact()
{
string loginName = Page.User.Identity.Name;
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + loginName + "'", "LoginName");
Tz888.BLL.Register.common bll = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model = new Tz888.Model.Register.OrgContactModel();
model = bll.getContactModel(loginName);
if (model == null)
{
return;
}
txtCompanyName.Value = model.OrganizationName.Trim();
txtLinkMan.Value = model.Name.Trim();
txtMobile.Value = model.Mobile.Trim();
//telArea1.Value = model.TelCountryCode.Trim(); //国际号
//txtTelStateCode.Value = model.TelStateCode.Trim(); //区号
//txtTel.Value = model.TelNum.Trim(); //电话号
txtWebSite.Value = model.Website.Trim();
txtEmail.Value = model.Email.Trim();
txtAddress.Value = model.address.Trim();
// txtCareer.Value = model.Career.Trim();
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
telArea1.Value = tel[0].ToString();
txtTelStateCode.Value = tel[1].ToString();
txtTel.Value = tel[2].ToString();
}
catch
{
telArea1.Value = "+86";
txtTelStateCode.Value = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTel.Value = dt1.Rows[0]["Tel"].ToString();
}
}
}
Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel();
Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL();
string name = Page.User.Identity.Name;
model3 = obj3.GetModel(" LoginName='" + name + "'");
this.ZoneSelectControl1.CountryID = model3.CountryCode.ToString().Trim(); //国别
ZoneSelectControl1.CityID = model3.CityID.ToString().Trim(); //市
ZoneSelectControl1.ProvinceID = model3.ProvinceID.ToString().Trim(); //省
ZoneSelectControl1.CountyID = model3.CountyID.ToString().Trim(); //县
}
/// <summary>
/// 添加数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
#region
// protected void btnSubmit_ServerClick(object sender, EventArgs e)
//{
//Response.Write("<script>alert('ok1')</script>");
////20090811 判断权限
//Tz888.BLL.Login.LoginInfoBLL loginbll = new Tz888.BLL.Login.LoginInfoBLL();
//bool yanzheng = loginbll.yanzheng(Page.User.Identity.Name);
//if (!yanzheng)
//{
// Tz888.Common.MessageBox.Show(this.Page, "发布失败,你没有发布信息的权限！\\n可能是你发布违规信息帐户被锁定了。\\n详情请联系客服。");
// return;
//}
////-----end--
////获取投资资源的信息
//Tz888.Model.Info.MainInfoModel mainInfoModel = new Tz888.Model.Info.MainInfoModel(); //创建主体信息实体
//Tz888.Model.Info.V124.CapitalInfoModel capitalInfoModel = new Tz888.Model.Info.V124.CapitalInfoModel(); //创建投资信息实体
//List<Tz888.Model.Info.CapitalInfoAreaModel> capitalInfoAreaModels = new List<Tz888.Model.Info.CapitalInfoAreaModel>();//投资区域信息实体列表
//Tz888.Model.Info.ShortInfoModel shortInfoModel = new Tz888.Model.Info.ShortInfoModel(); //创建短信息实体
////以下是文件上传的实体声明
//List<Tz888.Model.Info.InfoResourceModel> infoResourceModels = new List<Tz888.Model.Info.InfoResourceModel>();
//DateTime time_now = DateTime.Now;
////拟投向区域
//capitalInfoAreaModels = this.ZoneSelect1.CapitalInfoAreaModels;
////主体信息实体付值
//#region 投资信息实体赋值
////投资意向详细说明
//capitalInfoModel.ComAbout = Tz888.Common.Utility.PageValidate.TxtToHtml(this.txtCapitalIntent.Value.Trim());
////资本类型
////capitalInfoModel.CapitalTypeID = this.rblfinancingTarget.SelectedValue;
//for (int i = 0; rblfinancingTarget.Items.Count > i; i++)
//{
// if (rblfinancingTarget.Items[i].Selected)
// {
// capitalInfoModel.CapitalTypeID += rblfinancingTarget.Items[i].Value + ",";
// }
//}
////单项目可投资金额
//capitalInfoModel.CapitalID = this.rblCurreny.SelectedValue;
////项目介绍提炼
//capitalInfoModel.ComBreif = "";
//capitalInfoModel.CooperationDemandType = "";
////拟投资行业
//capitalInfoModel.IndustryBID = this.SelectIndustryControl1.IndustryString;
////投资项目阶段
//capitalInfoModel.stageID = Convert.ToInt32(this.rblStage.SelectedValue);
//// 是否参与项目方管理
//capitalInfoModel.joinManageID = Convert.ToInt32(this.rdlJoinManage.SelectedValue);
//投资方式
//for (int i = 0; chkLstCooperationDemand.Items.Count > i; i++)
//{
// if (chkLstCooperationDemand.Items[i].Selected)
// {
// capitalInfoModel.CooperationDemandType += chkLstCooperationDemand.Items[i].Value + ",";
// }
//}
////以下是需要添加的参数
////注册资金
//capitalInfoModel.RegisteredCapital = this.rblRegisterdollar.SelectedValue;
////团队规模
//capitalInfoModel.TeamScale = this.rblTeam.SelectedValue;
////机构年平均投资事件数
//capitalInfoModel.AverageInvestment = this.rblPinJ.SelectedValue;
////机构成功投资事件总数
//capitalInfoModel.SuccessfulInvestment = this.rblSucess.SelectedValue;
////投资需求摘要
//capitalInfoModel.InvestmentDemand = this.txtDemand.Value;
////添加所属区域
//capitalInfoModel.SCountryID = this.ZoneSelectControl1.CountryID;
//capitalInfoModel.SProvinceID = this.ZoneSelectControl1.ProvinceID;
//capitalInfoModel.SCityID = this.ZoneSelectControl1.CityID;
//capitalInfoModel.SCountyID = this.ZoneSelectControl1.CountyID;
////项目承办单位
//capitalInfoModel.Prorganizers = "no";
////文件上传的
//infoResourceModels = FilesUploadControl1.InfoList;
//#endregion
////这里是其他的实体值
//if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim()))
// mainInfoModel.Title = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtCapitalName.Text.Trim());
//string CountryCode;
//try
//{
// CountryCode = capitalInfoAreaModels[0].CountryCode;
//}
//catch
//{
// CountryCode = "ALL";
//}
//mainInfoModel.InfoCode = Tz888.BLL.Info.Common.CreateInfoCode("Capital", capitalInfoModel.IndustryBID.Split(',')[0], CountryCode, time_now);
//mainInfoModel.publishT = time_now;
//mainInfoModel.Hit = 0;
//mainInfoModel.IsCore = true;
//mainInfoModel.LoginName = "cxj";
////mainInfoModel.LoginName = Page.User.Identity.Name; //用户名称
//mainInfoModel.InfoOriginRoleName = "0"; //用户角色
//mainInfoModel.GradeID = "0";
//mainInfoModel.FixPriceID = "1";
//mainInfoModel.FeeStatus = 0;
//string keyword = "";
//if (!string.IsNullOrEmpty(this.txtKeyword1.Text.Trim()))
// keyword += Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtKeyword1.Text.Trim()) + ",";
//if (!string.IsNullOrEmpty(this.txtKeyword2.Text.Trim()))
// keyword += Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtKeyword2.Text.Trim()) + ",";
//if (!string.IsNullOrEmpty(this.txtKeyword3.Text.Trim()))
// keyword += Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtKeyword3.Text.Trim()) + ",";
//mainInfoModel.KeyWord = keyword;
//mainInfoModel.Descript = "";
//if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim()))
// mainInfoModel.DisplayTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtCapitalName.Text.Trim());
//mainInfoModel.FrontDisplayTime = time_now;
//mainInfoModel.ValidateStartTime = time_now;
////意向有效期限
//mainInfoModel.ValidateTerm = Convert.ToInt32(this.rdlValiditeTerm.SelectedValue.Trim());
//mainInfoModel.TemplateID = "001";
//mainInfoModel.HtmlFile = "";
//shortInfoModel.ShortInfoControlID = "CapitalIndex1";
//if (!string.IsNullOrEmpty(this.txtCapitalName.Text.Trim()))
// shortInfoModel.ShortTitle = Tz888.Common.Utility.PageValidate.FiltrateHTMLTag(this.txtCapitalName.Text.Trim());
//shortInfoModel.ShortContent = "";
//shortInfoModel.Remark = "";
//Tz888.BLL.Info.V124.CapitalInfoBLL bll = new Tz888.BLL.Info.V124.CapitalInfoBLL();
////这里是插入资源投资信息
////long infoID = bll.Insert(mainInfoModel, capitalInfoModel, this.GetInfoContact(), shortInfoModel, capitalInfoAreaModels, null, infoResourceModels);
//long infoID = bll.Insert(mainInfoModel, capitalInfoModel, this.GetInfoContact(), shortInfoModel, capitalInfoAreaModels, infoResourceModels);
////以下进行图片的插入
//if (infoID > 0)
//{
// bool isTof = Page.User.IsInRole("GT1002");
// if (isTof)
// {
// string HtmlFile = Tz888.BLL.Info.Common.createStaticPageFileName("Capital", mainInfoModel.InfoCode, infoID);
// Tz888.BLL.Info.MainInfoBLL mainBll = new Tz888.BLL.Info.MainInfoBLL();
// Page.Response.Write(infoID.ToString() + HtmlFile.ToString());
// mainBll.HasHtmlFile(infoID, HtmlFile);
// string actionMsg = "";
// Tz888.BLL.PageStatic.CapitalPageStatic staticobj = new Tz888.BLL.PageStatic.CapitalPageStatic();
// staticobj.CreateStaticPageCapital(infoID.ToString(), ref actionMsg);
// }
// // Response.Redirect("publishCapital_step2.aspx?code=" + Tz888.Common.DEncrypt.DESEncrypt.Encrypt(infoID.ToString() + "|Capital|" + this.txtCapitalName.Text.Trim() + "|" + txtGovName.Text.Trim()));
// Response.Redirect("publishCapital_step2.aspx?code=" + Tz888.Common.DEncrypt.DESEncrypt.Encrypt(infoID.ToString() + "|Capital|" + this.txtCapitalName.Text.Trim() + "|" + "no"));
//}
//else
//{
// Tz888.Common.MessageBox.Show(this.Page, "发布失败！");
//}
//}
#endregion
#region 信息初始化绑定
private void LoadInfoContact()
{
string loginName = Page.User.Identity.Name;
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + loginName + "'", "LoginName");
Tz888.BLL.Register.common bll = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model = new Tz888.Model.Register.OrgContactModel();
model = bll.getContactModel(loginName);
if (model == null)
{
return;
}
this.txtLinkMan.Text = model.Name;
this.txtMobile.Text = model.Mobile;
//this.txtTelCountry.Text = model.TelCountryCode;
//this.txtTelZoneCode.Text = model.TelStateCode;
//this.txtTelNumber.Text = model.TelNum;
//this.txtFaxCountry.Text = model.FaxCountryCode;
//this.txtFaxZoneCode.Text = model.FaxStateCode;
//this.txtFaxNumber.Text = model.FaxNum;
this.txtEmail.Text = model.Email;
this.txtAddress.Text = model.address;
//this.txtPostCode.Text = model.PostCode;
this.txtWebSite.Text = model.Website;
//以下是职位
//this.txtPosition.Text = model.Position;
//ViewState["OrganizationName"] = model.OrganizationName;
//这里是换为投资机构名称
this.txtGovName.Text = model.OrganizationName;
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();
}
}
}
}
/// <summary>
/// 加载用户联系信息
/// </summary>
public void InitInfoContact()
{
string Lname = Page.User.Identity.Name;
this.ViewState["LoginMemberName"] = Page.User.Identity.Name;
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + Lname + "'", "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='" + this.ViewState["LoginMemberName"].ToString() + "'");
this.ZoneSelectControl1.CountryID = model3.CountryCode.ToString().Trim(); //国别
ZoneSelectControl1.CityID = model3.CityID.ToString().Trim(); //市
ZoneSelectControl1.ProvinceID = model3.ProvinceID.ToString().Trim(); //省
ZoneSelectControl1.CountyID = model3.CountyID.ToString().Trim(); //县
Tz888.Model.Register.OrgContactModel org = new Tz888.Model.Register.OrgContactModel();
Tz888.BLL.Info.MarchantInfoBLL mar = new Tz888.BLL.Info.MarchantInfoBLL();
org = mar.SelLoginName(Page.User.Identity.Name);
// org = mar.SelLoginName("dishi");
this.txtCompanyName.Text = org.OrganizationName;
this.txtName.Text = org.Name;
//this.txtPosition.Text = org.Position;
//this.txtTelCountry.Text = org.TelCountryCode;
//this.txtTelZoneCode.Text = org.TelStateCode;
//this.txtTelNumber.Text = org.TelNum;
this.txtMobile.Text = org.Mobile;
this.txtEmail.Text = org.Email;
this.txtAddress.Text = org.address;
if (dt1.Rows.Count > 0)
{
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoginName = Page.User.Identity.Name.Trim();
if (LoginName != "")
{
// LoginName = "liulixing";
// LoginName = "topfo001";
ShowPublishInfo();
MemberNews(LoginName);
DataTable dt1 = obj1.GetLoginInfoList("VipInvalidDate", "LoginName='" + LoginName + "'", "LoginName");
string Validate1 = dt1.Rows[0]["VipInvalidDate"].ToString();
if (Validate1 != "")
{
this.sVadate.InnerText = Convert.ToDateTime(Validate1).ToShortDateString();
}
}
else
{
Response.Redirect("Login.aspx");
}
}
}
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 = 1001 LoginName
if (Request.QueryString["LoginName"] != null)
{
// ManageTypeID=Request.QueryString["ManageTypeID"] ;
LoginName = Request.QueryString["LoginName"].ToString().Trim();
//注册信息
Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL();
//登记联系人
Tz888.BLL.Register.common obj2 = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model2 = new Tz888.Model.Register.OrgContactModel();
//会员信息表
Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel();
Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL();
//会员登陆信息
Tz888.SQLServerDAL.Conn obj4 = new Tz888.SQLServerDAL.Conn();
// DataTable dt4 = obj4.GetList("LoginLogTab", "LoginTime", "LoginTime", 1, 1, 1, 1, "LoginName='"+LoginName+"'");
//会员发布信息
// DataTable dt5 = obj4.GetList("MainInfoViw", "Title,PublishT,HtmlFile", "PublishT", 1000, 1, 0, 1, "LoginName='" + LoginName + "' ");
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + LoginName + "'", "LoginName");
model2 = obj2.getContactModel(LoginName);
model3 = obj3.GetModel("LoginName='" + LoginName + "'");
if (dt1.Rows.Count > 0)
{
#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:
break;
}
string req = dt1.Rows[0]["RequirInfo"].ToString().Trim();
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 (model2 != null)
{
lbCareer.Text = model2.Career;
lbOrganizationName.Text = model2.OrganizationName != "" ? model2.OrganizationName : "暂无";
lbtAddress.Text = model2.address != "" ? model2.address : "暂无";
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 (model3 != null)
{
lbSex.Text = model3.Sex ? "(女)" : "(男)";
try
{
imgHead.ImageUrl = model3.HeadPortrait.ToString() != "" ? ConfigurationManager.AppSettings["ImageDomain"].ToString() + "/" + model3.HeadPortrait.ToString() : @"../images/publish/noneimg.gif";
}
catch { imgHead.ImageUrl = @"../images/publish/noneimg.gif"; }
lbTel.Text = model3.Tel;
lbMoble.Text = model3.Mobile;
lbFax.Text = model3.FAX;
}
else
{
imgHead.ImageUrl = @"../images/publish/noneimg.gif";
}
}
else
{
Tz888.Common.MessageBox.Show(this.Page, "请求出错");
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
//btnOk.Attributes.Add("onclick", "return chkPost();");
this.ViewState["LoginMemberName"] = "262734254ee"; //Page.User.Identity.Name;
this.ViewState["HeadPortrait"] = "";
//注册信息
Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL();
//登记联系人
Tz888.BLL.Register.common obj2 = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model2 = new Tz888.Model.Register.OrgContactModel();
//会员信息表
Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel();
Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL();
model3 = obj3.GetModel("LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'");
if (!IsPostBack)
{
#region 加载获取信息
this.ZoneSelectControl1.CountryID = model3.CountryCode.ToString().Trim(); //国别
ZoneSelectControl1.CityID = model3.CityID.ToString().Trim(); //市
ZoneSelectControl1.ProvinceID = model3.ProvinceID.ToString().Trim(); //省
ZoneSelectControl1.CountyID = model3.CountyID.ToString().Trim(); //县
txtAddress.Text = model3.Address.ToString(); //联系地址
txtEmail.Text = model3.Email.ToString(); //邮箱
txtContactName.Text = model3.MemberName.ToString(); //联系人姓名
txtMobile.Text = model3.Mobile.ToString(); //手机号码
txtPostCode.Text = model3.PostCode.ToString().Trim(); //邮编
txtNickName.Text = model3.NickName.ToString(); //昵称
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'", "LoginName");
this.ViewState["ManageTypeID"] = dt1.Rows[0]["ManageTypeID"].ToString();
model2 = obj2.getContactModel(this.ViewState["LoginMemberName"].ToString());
if (dt1.Rows.Count > 0)
{
//txtEmail.Text = dt1.Rows[0]["Email"].ToString();
lbLoginName.Text = dt1.Rows[0]["LoginName"].ToString().Trim();
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();
}
}
lbManageType.Text = ShenFen(dt1.Rows[0]["ManageTypeID"].ToString().Trim());
txtCompany.Text = dt1.Rows[0]["CompanyName"].ToString();
txtContactTitle.Text = dt1.Rows[0]["ContactTitle"].ToString();
if (model2 != null)
{
txtCompany.Text = model2.OrganizationName;
}
this.ViewState["tag"] = "update";
}
else
{
this.ViewState["tag"] = "add";
}
#endregion
}
}
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)
{
//btnOk.Attributes.Add("onclick", "return chkPost();");
//this.ViewState["LoginMemberName"] = Page.User.Identity.Name;
this.ViewState["LoginMemberName"] = "xiongmaozi";
this.ViewState["HeadPortrait"] = "";
//注册信息
Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL();
//登记联系人
Tz888.BLL.Register.common obj2 = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model2 = new Tz888.Model.Register.OrgContactModel();
//会员信息表
Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel();
Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL();
model3 = obj3.GetModel("LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'");
if (!IsPostBack)
{
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'", "LoginName");
this.ViewState["ManageTypeID"] = dt1.Rows[0]["ManageTypeID"].ToString();
model2 = obj2.getContactModel(this.ViewState["LoginMemberName"].ToString());
if (dt1.Rows.Count > 0)
{
txtEmail.Text = dt1.Rows[0]["Email"].ToString();
lbLoginName.Text = dt1.Rows[0]["LoginName"].ToString();
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();
}
}
txtNickName.Text = dt1.Rows[0]["NickName"].ToString();
txtCompany.Text = dt1.Rows[0]["CompanyName"].ToString();
txtContactTitle.Text = dt1.Rows[0]["ContactTitle"].ToString();
txtContactName.Text = dt1.Rows[0]["ContactName"].ToString();
if (model2 != null)
{
txtMobile.Text = model2.Mobile;
txtAddress.Text = model2.address;
txtPostCode.Text = model2.PostCode;
}
this.ViewState["tag"] = "update";
}
else
{
this.ViewState["tag"] = "add";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//btnOk.Attributes.Add("onclick", "return chkPost();");
this.ViewState["LoginMemberName"] = Page.User.Identity.Name;
this.ViewState["HeadPortrait"] = "";
//注册信息
Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL();
//登记联系人
Tz888.BLL.Register.common obj2 = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model2 = new Tz888.Model.Register.OrgContactModel();
//会员信息表
Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel();
Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL();
model3 = obj3.GetModel("LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'");
//判断是个人会员还是企业会员
Tz888.BLL.Register.LoginInfoBLL dal1 = new Tz888.BLL.Register.LoginInfoBLL();
string propertyid = dal1.GetPropertyID(Page.User.Identity.Name.Trim());
if (propertyid == "1")
{
lbManageType.Text = "项目方 (个人)";
}
if (!IsPostBack)
{
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'", "LoginName");
this.ViewState["ManageTypeID"] = dt1.Rows[0]["ManageTypeID"].ToString();
model2 = obj2.getContactModel(this.ViewState["LoginMemberName"].ToString());
if (dt1.Rows.Count > 0)
{
txtEmail.Text = dt1.Rows[0]["Email"].ToString();
lbLoginName.Text = dt1.Rows[0]["LoginName"].ToString();
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();
}
}
lbNickName.Text = dt1.Rows[0]["NickName"].ToString();
txtCompany.Text = dt1.Rows[0]["CompanyName"].ToString();
txtContactTitle.Text = dt1.Rows[0]["ContactTitle"].ToString();
txtContactName.Text = dt1.Rows[0]["ContactName"].ToString();
if (model2 != null)
{
txtMobile.Text = model2.Mobile;
txtAddress.Text = model2.address;
txtPostCode.Text = model2.PostCode;
}
///---------------------------------
///design by ww (20090526)
///---------------------------------
if (model3 != null)
{
//modelInfo3.Address = txtAddress.Text;
//modelInfo3.Birthday = DateTime.Now;
//modelInfo3.Email = txtEmail.Text;
//modelInfo3.Mobile = txtMobile.Text;
//modelInfo3.NickName = lbNickName.Text;
//modelInfo3.PostCode = txtPostCode.Text;
txtAddress.Text = model3.Address.ToString();
txtEmail.Text = model3.Email.ToString();
txtMobile.Text = model3.Mobile.ToString();
lbNickName.Text = model3.NickName.ToString();
txtPostCode.Text = model3.PostCode.ToString();
txtContactName.Text = model3.MemberName;
}
this.ViewState["tag"] = "update";
}
else
{
this.ViewState["tag"] = "add";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
btnOk.Attributes.Add("onclick", "return chkPost();");
this.ViewState["LoginMemberName"] = Page.User.Identity.Name;
this.ViewState["HeadPortrait"] = "";
//注册信息
Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL();
//登记联系人
Tz888.BLL.Register.common obj2 = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model2 = new Tz888.Model.Register.OrgContactModel();
//会员信息表
Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel();
Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL();
model3 = obj3.GetModel("LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'");
////头像
//if (model3 != null)
//{
// rblSex.SelectedValue = model3.Sex.ToString();
// if (model3.HeadPortrait != "" && model3.HeadPortrait != null)
// {
// FileUploader1.Img = ConfigurationManager.AppSettings["ImageDomain"].ToString() + "/" + model3.HeadPortrait;
// FileUploader1.ButtonName = "修改";
// FileUploader1.MaxPics = 0;
// FileUploader1.IsUp = "0";//是否通过控件上传
// // this.ViewState["HeadPortrait"] = model3.HeadPortrait;
// this.ViewState["HeadPortrait"] = model3.HeadPortrait;
// }
// else
// {
// FileUploader1.Img = "../images/MemberData/nopic.gif";
// FileUploader1.ButtonName = "修改";
// FileUploader1.MaxPics = 1;
// FileUploader1.IsUp = "0";//是否通过控件上传
// }
//}
if (!IsPostBack)
{
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'", "LoginName");
model2 = obj2.getContactModel(this.ViewState["LoginMemberName"].ToString());
if (dt1.Rows.Count > 0)
{
#region 信息绑定
txtEmail.Text = dt1.Rows[0]["Email"].ToString();
lbLoginName.Text = dt1.Rows[0]["LoginName"].ToString();
switch (dt1.Rows[0]["ManageTypeID"].ToString().Trim())
{
case "1001":
lbManageType.Text = "个人会员";
ChkLstRequirInfo.Items[0].Enabled = false;
Label1.Text = "公司网址";
hlView.NavigateUrl = "MemberMessage_P.aspx?LoginName=" + this.ViewState["LoginMemberName"].ToString();
HyperLink1.NavigateUrl = "MemberMessage_P.aspx?LoginName=" + this.ViewState["LoginMemberName"].ToString();
break;
case "1003":
lbManageType.Text = "企业会员";
ChkLstRequirInfo.Items[0].Enabled = false;
Label1.Text = "公司网址";
hlView.NavigateUrl = "MemberMessage_E.aspx?LoginName=" + this.ViewState["LoginMemberName"].ToString();
HyperLink1.NavigateUrl = "MemberMessage_E.aspx?LoginName=" + this.ViewState["LoginMemberName"].ToString();
break;
case "1004":
lbManageType.Text = "政府会员";
ChkLstRequirInfo.Items[1].Enabled = false;
ChkLstRequirInfo.Items[2].Enabled = false;
ChkLstRequirInfo.Items[3].Enabled = false;
ChkLstRequirInfo.Items[4].Enabled = false;
ChkLstRequirInfo.Items[5].Enabled = false;
Label1.Text = "机构网址";
hlView.NavigateUrl = "MemberMessage_G.aspx?LoginName=" + this.ViewState["LoginMemberName"].ToString();
HyperLink1.NavigateUrl = "MemberMessage_G.aspx?LoginName=" + this.ViewState["LoginMemberName"].ToString();
break;
default:
break;
}
this.ViewState["ManageTypeID"] = dt1.Rows[0]["ManageTypeID"].ToString();
string[] code = dt1.Rows[0]["RequirInfo"].ToString().Split(new char[] { ',' }, 6);
foreach (ListItem li in ChkLstRequirInfo.Items)
{
for (int i = 0; i < code.Length; i++)
{
if (li.Value == code[i].Trim())
{
li.Selected = true;
}
}
}
if (dt1.Rows[0]["Tel"] != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();//因以前数据格式不同原因，没有用‘-’分格
}
}
lbNickName.Text = dt1.Rows[0]["NickName"].ToString();
txtMemberName.Text = dt1.Rows[0]["RealName"].ToString();
//公司，机构登记 公司网址
if (Page.User.IsInRole("MT1004"))//机构
{
Tz888.BLL.Register.GovernmentRegisterBLL obj = new Tz888.BLL.Register.GovernmentRegisterBLL();
DataTable dtGov = obj.getGovernmentModel(this.ViewState["LoginMemberName"].ToString());
if (dtGov == null)
{
Label2.Text = "<span class='hui'> 您还没有登记您的机构信息<a href='/Register/GovernmentRegister.aspx'>立即登记</a></span>";
Label3.Text = "<span class='hui'>如果您的机构还没有网站</span><a href='http://co.topfo.com/manager/intro.aspx' target='blank'>请点此建立您的网上展厅</a>";
}
else
{
Label3.Text = "<span class='hui'>您的展厅地址为：www." + dtGov.Rows[0]["ExhibitionHall"].ToString().Trim() + ".co.tz888.cn <span class='hui'>，如果您的公司还没有网站，可用此网址。</span> ";
}
}
else if (Page.User.IsInRole("MT1003")) //企业
{
Tz888.BLL.Register.EnterpriseRegisterBLL obj = new Tz888.BLL.Register.EnterpriseRegisterBLL();
DataTable dtEnt = obj.getEnterpriseModel(this.ViewState["LoginMemberName"].ToString());
if (dtEnt == null)
{
Label2.Text = "<span class='hui'> 您还没有登记您的公司信息<a href='/Register/EnterpriseRegister.aspx'>立即登记</a></span>";
Label3.Text = "<span class='hui'>如果您的公司还没有网站</span><a href='http://co.topfo.com/Manager/intro.aspx' target='blank'>请点此建立您的网上展厅</a>";
}
else
{
Label3.Text = "<span class='hui'>您的展厅地址为：www." + dtEnt.Rows[0]["ExhibitionHall"].ToString().Trim() + ".co.tz888.cn <span class='hui'>，如果您的公司还没有网站，可用此网址。</span> ";
}
}
else if (Page.User.IsInRole("MT1001")) //个人
{
Label2.Text = "";
}
if (model2 != null)
{
txtOrganizationName.Text = model2.OrganizationName;
txtMobile.Text = model2.Mobile;
txtFaxCountry.Text = model2.FaxCountryCode;
txtFaxZoneCode.Text = model2.FaxStateCode;
txtFaxNumber.Text = model2.FaxNum;
txtAddress.Text = model2.address;
txtPostCode.Text = model2.PostCode;
}
else
{
}
#endregion
this.ViewState["tag"] = "update";
}
else
{
this.ViewState["tag"] = "add";
}
}
//会员是否存在
AjaxPro.Utility.RegisterTypeForAjax(typeof(Tz888.Common.Ajax.AjaxMethod));
}
private void BindShow()
{
this.ViewState["LoginMemberName"] = "wa";
this.ViewState["HeadPortrait"] = "";
//注册信息
Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL();
//登记联系人
Tz888.BLL.Register.common obj2 = new Tz888.BLL.Register.common();
Tz888.Model.Register.OrgContactModel model2 = new Tz888.Model.Register.OrgContactModel();
//会员信息表
Tz888.Model.Register.MemberInfoModel model3 = new Tz888.Model.Register.MemberInfoModel();
Tz888.BLL.Register.MemberInfoBLL obj3 = new Tz888.BLL.Register.MemberInfoBLL();
model3 = obj3.GetModel("LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'");
//判断是个人会员还是企业会员
Tz888.BLL.Register.LoginInfoBLL dal1 = new Tz888.BLL.Register.LoginInfoBLL();
string propertyid = dal1.GetPropertyID("wa");
this.radiotype.Items.FindByValue(propertyid.Trim()).Selected = true;
if (propertyid == "1")
{
lbManageType.Text = "项目方 (个人)";
}
else
{
lbManageType.Text = "项目方 (企业)";
}
DataTable dt1 = obj1.GetLoginInfoList("*", "LoginName='" + this.ViewState["LoginMemberName"].ToString() + "'", "LoginName");
this.ViewState["ManageTypeID"] = dt1.Rows[0]["ManageTypeID"].ToString();
model2 = obj2.getContactModel(this.ViewState["LoginMemberName"].ToString());
if (dt1.Rows.Count > 0)
{
txtEmail.Text = dt1.Rows[0]["Email"].ToString();
lbLoginName.Text = dt1.Rows[0]["LoginName"].ToString();
if (dt1.Rows[0]["Tel"] != DBNull.Value && dt1.Rows[0]["Tel"].ToString() != "")
{
try
{
string[] tel = dt1.Rows[0]["Tel"].ToString().Split('-');
txtTelCountry.Text = tel[0].ToString();
txtTelZoneCode.Text = tel[1].ToString();
txtTelNumber.Text = tel[2].ToString();
}
catch
{
txtTelCountry.Text = "+86";
txtTelZoneCode.Text = "";
//因以前数据格式不同原因，没有用‘-’分格
txtTelNumber.Text = dt1.Rows[0]["Tel"].ToString();
}
}
txtNickName.Text = dt1.Rows[0]["NickName"].ToString();
txtCompany.Text = dt1.Rows[0]["CompanyName"].ToString();
txtContactTitle.Text = dt1.Rows[0]["ContactTitle"].ToString();
txtContactName.Text = dt1.Rows[0]["ContactName"].ToString();
if (model2 != null)
{
txtMobile.Text = model2.Mobile;
txtAddress.Text = model2.address;
txtPostCode.Text = model2.PostCode;
}
///---------------------------------
///design by ww (20090526)
///---------------------------------
if (model3 != null)
{
//modelInfo3.Address = txtAddress.Text;
//modelInfo3.Birthday = DateTime.Now;
//modelInfo3.Email = txtEmail.Text;
//modelInfo3.Mobile = txtMobile.Text;
//modelInfo3.NickName = txtNickName.Text;
//modelInfo3.PostCode = txtPostCode.Text;
txtAddress.Text = model3.Address.ToString();
txtEmail.Text = model3.Email.ToString();
txtMobile.Text = model3.Mobile.ToString();
txtNickName.Text = model3.NickName.ToString();
txtPostCode.Text = model3.PostCode.ToString();
txtContactName.Text = model3.MemberName;
}
this.ViewState["tag"] = "update";
}
else
{
this.ViewState["tag"] = "add";
}
}
protected void btnDC_Click(object sender, EventArgs e)
{
//单位名称 联系人 手机 电话 邮箱 会员类型
//contacname membername mobile tel Email managetypeid
RetureWhere();
Tz888.BLL.Visit.VisitInfoBLL visit = new Tz888.BLL.Visit.VisitInfoBLL();
DataTable dt = visit.SelDataTable(ViewState["Criteria"].ToString());
Tz888.BLL.Login.LoginInfoBLL obj1 = new Tz888.BLL.Login.LoginInfoBLL();
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
dsi.Company = "深圳拓富投资有限公司";
SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
si.Subject = "会员管理";
si.Author = "颜品庄";
si.CreateDateTime = DateTime.Now;
hssfworkbook.DocumentSummaryInformation = dsi;
hssfworkbook.SummaryInformation = si;
HSSFSheet sheet1 = hssfworkbook.CreateSheet("Sheet1");
//sheet1.DefaultColumnWidth=10;设置列宽
HSSFRow row = sheet1.CreateRow(0);
row.CreateCell(0).SetCellValue("单位名称");
row.CreateCell(1).SetCellValue("联系人");
row.CreateCell(2).SetCellValue("手机");
row.CreateCell(3).SetCellValue("电话");
row.CreateCell(4).SetCellValue("邮件");
row.CreateCell(5).SetCellValue("会员类型");
for (int i = 0; i < dt.Rows.Count; i++)
{
HSSFRow row0 = sheet1.CreateRow(i + 1);
DataTable dt1 = obj1.GetLoginInfoList("*", " LoginID=" + dt.Rows[i]["LoginID"].ToString() + " ", "LoginName");
row0.CreateCell(0).SetCellValue(dt1.Rows[0]["contactname"].ToString());
row0.CreateCell(1).SetCellValue(dt.Rows[i]["membername"].ToString());
row0.CreateCell(2).SetCellValue(dt.Rows[i]["mobile"].ToString());
row0.CreateCell(3).SetCellValue(dt.Rows[i]["tel"].ToString());
row0.CreateCell(4).SetCellValue(dt.Rows[i]["Email"].ToString());
row0.CreateCell(5).SetCellValue(visit.SelManageType(dt.Rows[i]["managetypeid"].ToString()));
}
string t1 = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString();
string filename = "attachment;filename=" + System.Web.HttpUtility.UrlEncode("会员表" + t1, System.Text.Encoding.UTF8) + ".xls";
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", filename);
Response.Clear();
MemoryStream filestream = new MemoryStream();
hssfworkbook.Write(filestream);
Response.BinaryWrite(filestream.GetBuffer());
Response.End();
#region
//RetureWhere();
//DataTable d = new DataTable();
//DataTable dt = new DataTable();
//dt.Columns.Add("编号", typeof(String));
//dt.Columns.Add("用户名", typeof(String));
//dt.Columns.Add("邮箱", typeof(String));
//dt.Columns.Add("座机", typeof(String));
//dt.Columns.Add("手机", typeof(String));
//dt.Columns.Add("会员类型", typeof(String));
//string sql = "select * from MemberLoginInfoView" + (string.IsNullOrEmpty(ViewState["Criteria"].ToString()) ? "" : " where " + ViewState["Criteria"].ToString());
//this.Page.RegisterStartupScript("K", "<script>alert('" + sql + "')</script>");
//string connStr = ConfigurationManager.ConnectionStrings["SQLConnString1"].ToString();
//using (SqlConnection con = new SqlConnection(connStr))
//{
// SqlCommand com = new SqlCommand();
// com.CommandText = sql;
// com.Connection = con;
// con.Open();
// SqlDataAdapter dp = new SqlDataAdapter();
// dp.SelectCommand = com;
// dp.Fill(d);
//};
//foreach (DataRow r in d.Rows)
//{
// DataRow dr = dt.NewRow();
// dr["编号"] = r["MemberID"].ToString();
// dr["用户名"] = r["LoginName"].ToString();
// dr["邮箱"] = r["Email"].ToString();
// dr["座机"] = r["Tel"].ToString();
// dr["手机"] = r["Mobile"].ToString();
// dr["会员类型"] = GetType(r["ManageTypeID"].ToString());
// dt.Rows.Add(dr);
//}
//HSSFWorkbook hssfworkbook = new HSSFWorkbook();
//DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();
//dsi.Company = "深圳拓富投资有限公司";
//SummaryInformation si = PropertySetFactory.CreateSummaryInformation();
//si.Subject = "会员管理";
//si.Author = "颜品庄";
//si.CreateDateTime = DateTime.Now;
//hssfworkbook.DocumentSummaryInformation = dsi;
//hssfworkbook.SummaryInformation = si;
//HSSFSheet sheet1 = hssfworkbook.CreateSheet("Sheet1");
//HSSFRow row = sheet1.CreateRow(0);
//row.CreateCell(0).SetCellValue("编号");
//row.CreateCell(1).SetCellValue("用户名");
//row.CreateCell(2).SetCellValue("邮箱");
//row.CreateCell(3).SetCellValue("座机");
//row.CreateCell(4).SetCellValue("手机");
//row.CreateCell(5).SetCellValue("会员类型");
////单位名称 联系人 手机 电话 邮箱 会员类型
////contacname membername mobile tel Email managetypeid
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// HSSFRow row0 = sheet1.CreateRow(i + 1);
// row0.CreateCell(0).SetCellValue(dt.Rows[i]["编号"].ToString());
// row0.CreateCell(1).SetCellValue(dt.Rows[i]["用户名"].ToString());
// row0.CreateCell(2).SetCellValue(dt.Rows[i]["邮箱"].ToString());
// row0.CreateCell(3).SetCellValue(dt.Rows[i]["座机"].ToString());
// row0.CreateCell(4).SetCellValue(dt.Rows[i]["手机"].ToString());
// row0.CreateCell(5).SetCellValue(dt.Rows[i]["会员类型"].ToString());
//}
//string t1 = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString();
//string filename = "attachment;filename=" + System.Web.HttpUtility.UrlEncode("会员表" + t1, System.Text.Encoding.UTF8) + ".xls";
//Response.ContentType = "application/vnd.ms-excel";
//Response.AppendHeader("Content-Disposition", filename);
//Response.Clear();
//MemoryStream filestream = new MemoryStream();
//hssfworkbook.Write(filestream);
//Response.BinaryWrite(filestream.GetBuffer());
//Response.End();
#endregion
}