public static string ebillingForm(string OrderID, string ChargeArm, string LoginName)
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("EbilingICPcodeTab", "Amount,CPCODE", "ID", 1, 1, 0, 1, "Amount=" + Convert.ToDouble(ChargeArm));
string PCode = "";
if (dt.Rows.Count > 0)
{
PCode = dt.Rows[0]["CPCODE"].ToString().Trim();
}
else
{
return("");
}
string targetURL = DomainName.PayDomain() + "/ebiling/response.aspx?order_no=" + OrderID; //付费完成地址 使用者
string Charge = (Convert.ToDouble(ChargeArm) * 100).ToString(); //付费金额 ----除以100即为真实额度
string UId = LoginName; //会员ID 使用ICP服务的使用者ID 注册会员 20个字以内
string DateTime_ = DateTime.Now.ToString(); //传送时间
string UIResize = "0"; //窗口大小模式 0不能放大窗口 1可以放大
string FormMethod = "POST"; //提交方式
string Target = "_self"; //窗口位置
string Corporation = "1"; //固定变量
string billingURL = DomainName.VipDomain() + "/PayManage/return_ebilling.aspx"; //付费结束URL 服务器
string billingKind = "1"; //固定变量
string Quote = "0"; //固定变量
string CpDemand = OrderID; //订单号
string txt = "";
txt = txt + "targetURL=" + targetURL + ",";
txt = txt + "PCode=" + PCode + ",";
txt = txt + "Charge=" + Charge + ",";
txt = txt + "UId=" + UId + ",";
txt = txt + "DateTime=" + DateTime_ + ",";
txt = txt + "UIResize=" + UIResize + ",";
txt = txt + "FormMethod=" + FormMethod + ",";
txt = txt + "Target=" + Target + ",";
txt = txt + "Corporation=" + Corporation + ",";
txt = txt + "billingURL=" + billingURL + ",";
txt = txt + "billingKind=" + billingKind + ",";
txt = txt + "Quote=" + Quote + ",";
txt = txt + "CpDemand=" + CpDemand;
string url = "http://billing.ebilling.net.cn/ebilling.asp"; //正式地址
string EncTxt = new SOFTFAMILYLib.PayClass().Encode(txt); // 对输出数据加密
string htmlCode = @"
<form name=frmPay action=""" + url + @"""' method=post>
<input type=""hidden"" name=""request"" value=""" + EncTxt + @""">
<input type=""submit"" style=""display:none"" id=""submit""/>
</form>
<script language=""javascript"">
document.all.submit.click();
</script>" ;
return(htmlCode);
}
public string GetContactDetail_New(string InfoID, string LoginName)
{
//是否收费信息
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
bool b = false;
int FixPriceID = 0;
decimal MainPointCount = 0;
DataTable dt = dal.GetList("MainInfoTab", "InfoID,FixPriceID,MainPointCount", "InfoID", 1, 1, 0, 1, "InfoID=" + Convert.ToInt64(InfoID));
if (dt.Rows.Count > 0)
{
FixPriceID = Convert.ToInt32(dt.Rows[0]["FixPriceID"].ToString().Trim());
MainPointCount = Convert.ToDecimal(dt.Rows[0]["MainPointCount"].ToString().Trim());
}
if (MainPointCount > 0 && FixPriceID > 1)
{
Tz888.BLL.Info.CapitalInfoBLL ciBll = new Tz888.BLL.Info.CapitalInfoBLL();
b = ciBll.bIsBuyInfoOfUser(LoginName, InfoID);
if (b)
{
return(GetContactDetail(InfoID));
}
else
{
return("您需要购买此信息才能查看联系方式");
}
}
else
{
return(GetContactDetail(InfoID));//免费
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.User.Identity.Name == null || Page.User.Identity.Name.Trim() == "")
{
Response.Redirect("../Login.aspx");
}
string strWhere = "";
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
if (Request.QueryString["commentId"] != null && Request.QueryString["commentId"].ToString().Trim() != "")
{
long i = 1;
long j = 1;
strWhere = "id= ' " + Request.QueryString["commentId"].ToString().Trim() + " '";
DataTable dt = dal.GetList("InfoCommentManagerVIW", "InfoID", "LoginName,InfoID,Title,CommentContent",
strWhere, "CommentTime desc", ref i, 1, ref j);
if (dt != null)
{
this.commentName.Text = dt.Rows[0][0].ToString();
infoId = Convert.ToInt32(dt.Rows[0][1]);
this.commentTile.Text = dt.Rows[0][2].ToString();
this.commentText.Text = dt.Rows[0][3].ToString();
}
this.commentRes.Focus();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (string.IsNullOrEmpty(Page.User.Identity.Name))
//{
// Response.Redirect("/Login.aspx?ReturnUrl=" + Server.UrlEncode(Request.RawUrl));
// return;
//}
try
{
string strLoginName = Page.User.Identity.Name;
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
long CurrPage = 0;
long TotalCount = 0;
string strWhere = "loginName='" + strLoginName + "'";
DataTable dt = dal.GetList("LoginInfoTab", "loginName",
"nickName", strWhere, "loginName", ref CurrPage, 0, ref TotalCount);
string nickName = "";
if (dt != null && dt.Rows.Count > 0)
{
nickName = dt.Rows[0][0].ToString().Trim();
}
lblWelcome.Text = " " + "您的用户登录名：" + strLoginName + " " + "您的姓名:" + nickName + " ";
}
catch
{
}
}
public string view(object view)
{
string name = view.ToString().Trim().ToLower();
if (name == "拓富网" || name == "tz888admin")
{
return("拓富网");
}
string result = "";
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
string strWhere = "";
strWhere = "loginName='" + name.Trim() + "'";
long i = 1;
long j = 1;
long k = 1;
DataTable dt = dal.GetList("loginInfoTab", "loginName", "nickName", strWhere, "loginName", ref i, k, ref j);
if (dt != null)
{
result = dt.Rows[0]["nickName"].ToString();
}
return(result);
}
public void bind()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
string strWhere = ViewState["strWhere"].ToString();
long CurrPage = Convert.ToInt64(ViewState["CurrPage"]);
long TotalCount = 0;
long PageSize = Convert.ToInt64(ViewState["pagesize"]);
DataTable dt = dal.GetList("StrikeOrderTab", "OID", "*", strWhere, "OID desc", ref CurrPage, PageSize, ref TotalCount);
DataTable dtPoint = dal.GetList("StrikeOrderTab", "sum(TransMoney) as p", "p", 1, 1, 0, 1, strWhere);
lblPoint.Text = dtPoint.Rows[0].ItemArray[0].ToString();
lblCount.Text = TotalCount.ToString();
lblPageCount.Text = System.Math.Ceiling(Convert.ToDouble(TotalCount) / Convert.ToDouble(PageSize)).ToString();
lblCurrPage.Text = CurrPage.ToString();
txtPage.Value = CurrPage.ToString();
lblCount.Text = TotalCount.ToString();
Pager();
myList.DataSource = dt;
myList.DataBind();
}
public void getList()
{
string strWhere = "";
string username = Page.User.Identity.Name;//"tz888admin";
if (this.infoSendTime.SelectedValue == "0")
{
strWhere = "LoginName='" + username + "'";
}
if (this.infoSendTime.SelectedValue == "91")
{
strWhere = "LoginName='" + username + "' and DateDiff(d,SendTime,getdate())>90";
}
else
{
strWhere = "LoginName='" + username + "' and DateDiff(d,SendTime,getdate())<" + Convert.ToInt32(infoSendTime.SelectedValue);
}
long CurrPage = Convert.ToInt64(ViewState["CurrPage"]);
long TotalCount = 0;
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("InnerInfoSendTab", "SendID", "*", strWhere, "ReceivedID desc", ref CurrPage, Convert.ToInt64(ViewState["pagesize"]), ref TotalCount);
outDataTable = dt;
lblCount.Text = TotalCount.ToString();
lblCurrPage.Text = CurrPage.ToString();
lblPageCount.Text = System.Math.Ceiling(Convert.ToDouble(TotalCount) / Convert.ToDouble(ViewState["pagesize"])).ToString();
infoSendGridView.DataSource = dt;
infoSendGridView.DataBind();
}
public void bind()
{
string LoginName = Page.User.Identity.Name;
lblLoginName.Text = LoginName;
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("VipMsgTrialLog", "ID", "ID", 1, 1, 1, 1, "LoginName='" + LoginName + "'");
if (Convert.ToInt32(dt.Rows[0].ItemArray[0]) == 0)
{
lblMsg.Text = "发送短信，<span class='hong font14'>拓富通会员服务 </span>就能轻松试用！每次可试用一天，最多可以试用三次！";
return;
}
if (Convert.ToInt32(dt.Rows[0].ItemArray[0]) < 3)
{
lblMsg.Text = "您已经试用过" + dt.Rows[0].ItemArray[0].ToString() + "次，您可以再次通过短信申请试用！";
//您已经试用过X次，请您填写我们的调查问卷，填写后您可以再次通过短信申请试用！
return;
}
if (Convert.ToInt32(dt.Rows[0].ItemArray[0]) >= 3)
{
lblMsg.Text = "您已经试用过三次拓富通会员，可见你非常认同我们的拓富通会员服务，请立即申请使用吧！如果还有疑问，请与我们的<a href=\"javascript:jiayingOpenMyWin()\"><font color='red'>客服专员</font></a>联系!";
return;
}
}
public void bindWait()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("StrikeOrderViw", "*", "OrderNo", 1, 1, 0, 1, "Status<>10 and OrderNo='" + orderNo + "' and LoginName='" + Page.User.Identity.Name + "'");
if (dt.Rows.Count > 0)
{
lblORDER.Text = orderNo;
lblOrderNo.Text = orderNo;
lblAmount.Text = dt.Rows[0]["TransMoney"].ToString();
lblOrderDate.Text = dt.Rows[0]["PayTime"].ToString();
lblLoginName.Text = dt.Rows[0]["StrikeLoginName"].ToString();
if (dt.Rows[0]["Status"].ToString() == "1")
{
lblStatus.Text = "已付款";
}
if (dt.Rows[0]["Status"].ToString() == "0")
{
lblStatus.Text = "未付款";
}
if (dt.Rows[0]["Status"].ToString() == "2")
{
lblStatus.Text = "等待确认";
}
if (dt.Rows[0]["paytypename"].ToString() != "")
{
lblPayType.Text = dt.Rows[0]["paytypename"].ToString() + "支付";
}
else
{
lblPayType.Text = "暂无";
}
}
}
protected void ServiesBind(string Servies)
{
string len = "";
string[] str = Servies.Split(',');
for (int i = 0; i < str.Length; i++)
{
if (i == 0)
{
len = "(ServiesBID like '%" + str[i].Trim() + "%'";
}
else if (!string.IsNullOrEmpty(str[i]))
{
if (len != "")
{
len += "or ServiesBID like '%" + str[i].Trim() + "%'";
}
else
{
len = "(ServiesBID like '%" + str[i].Trim() + "%'";
}
}
}
len += ")";
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("ReleaseTabViw", "InfoID,ServiesBID,ServiesMID,Title,CreateDate,Price,AuditStatus,AuditStatus", "CreateDate ", 5, 1, 0, 1, "DelStatus=0 and AuditStatus=1 and UserName!= '" + Page.User.Identity.Name.ToString() + "' and " + len + " ");
ServiesList.DataSource = dt;
ServiesList.DataBind();
string s = Request.QueryString["company"].ToString();
Literal1.Text = "与(" + s + ")匹配的";
}
//获取区域
protected string GetQu(object obj)
{
string str = "";
long CurrPage = Convert.ToInt64(ViewState["CurrPage"]);
long TotalCount = 0;
long infoId = Convert.ToInt64(obj);
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("MerchantInfoTab", "infoId", "industryClassList,countrycode,Provinceid,cityid,countyid", "InfoId='" + infoId + "'", "InfoId desc", ref CurrPage, 1, ref TotalCount);
if (dt.Rows.Count > 0)
{
DataTable dtPro = dal.GetList("setProvincetab", "provinceid", "provinceid,provincename", "provinceid='" + dt.Rows[0]["provinceid"].ToString().Trim() + "'", "provinceid desc", ref CurrPage, 1, ref TotalCount);
DataTable dtcity = dal.GetList("setcitytab", "cityid", "cityid,cityname", "cityid='" + dt.Rows[0]["cityid"].ToString().Trim() + "'", "cityid desc", ref CurrPage, 1, ref TotalCount);
if (dtPro.Rows[0]["provincename"].ToString() != "")
{
str += dtPro.Rows[0]["ProvinceName"].ToString() + "省 ";
if (dtcity.Rows[0]["CityName"].ToString() != "")
{
str += dtcity.Rows[0]["CityName"].ToString() + "市";
}
}
else
{
str += "<font color='red'>暂无投资区域</font>";
}
}
else
{
str += "<font color='red'>暂无投资区域</font>";
}
return(str);
}
//兑换参数信息
public void changeinfo()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("DictionaryInfoTab", "DictionaryInfoParam", "DictionaryInfoID", 3, 1, 0, 0, "DictionaryCode='VRate' or DictionaryCode='ExLimit' or DictionaryCode='VTerms'");
if (dt.Rows.Count > 0)
{
lbVRate.Text = dt.Rows[0][0].ToString().Trim(); //兑换比率
hidB.Value = dt.Rows[0][0].ToString().Trim(); //兑换比率
lbExLimit.Text = dt.Rows[1][0].ToString().Trim(); //每天兑换限额
lbVTerms.Text = dt.Rows[2][0].ToString().Trim(); //有效期
lbVTerms2.Text = dt.Rows[2][0].ToString().Trim(); //有效期
}
DataTable jifen = dal.GetList("CreateCardTab", "IntegralCount", "id", 1, 1, 0, 1, "LoginName='" + loginname + "'");
if (jifen.Rows.Count > 0)
{
string ower = jifen.Rows[0]["IntegralCount"].ToString().Trim();
string rate = lbVRate.Text == "" ? "0" : lbVRate.Text;
lblOwnerCount.Text = ower == "" ? "0" : ower;
lblExCount.Text = (Convert.ToDouble(ower) / Convert.ToDouble(rate)).ToString();
}
DataTable ticket = dal.GetList("MemberVoucherInfoTab", "LeftBalanceSum", "LeftBalanceSum", 1, 1, 0, 1, "LoginName='" + loginname + "'");
if (ticket.Rows.Count > 0)
{
lblLeft.Text = ticket.Rows[0]["LeftBalanceSum"].ToString().Trim();//剩余购物券
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (string.IsNullOrEmpty(Page.User.Identity.Name))
{
Response.Redirect("~/Login.aspx?ReturnUrl=" + Server.UrlEncode(Request.RawUrl));
}
if (Page.User.Identity.Name != null && Page.User.Identity.Name.Trim() != "")
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("LoginInfoTab", "ManageTypeID", "LoginID", 1, 1, 0, 1, "LoginName='" + Page.User.Identity.Name.ToString() + "' ");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string managetype = dt.Rows[0]["ManageTypeID"].ToString();
manage(managetype);
}
}
//toBind(Page.User.Identity.Name.Trim());
if (!string.IsNullOrEmpty(Request.QueryString["Servies"]))
{
ServiesBind(Request.QueryString["Servies"]);
}
else
{
ServiesBind();
}
}
}
}
public void getList()
{
string strWhere = "";
long CurrPage = Convert.ToInt64(ViewState["CurrPage"]);
long TotalCount = 0;
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
strWhere = "infoId= " + infoID + " and IsAudit=1 and fatherId=0 and isdelete=0 ";
//strWhere = "infoId= " + infoID + " and IsAudit=0 and isdelete=0 ";
DataTable dt = dal.GetList("InfoCommentManagerVIW", "InfoID", "LoginName,InfoID,Title,CommentContent,CommentTime,ID,IsAudit,IsResponse,infoowner",
strWhere, "CommentTime desc", ref CurrPage, Convert.ToInt64(ViewState["pagesize"]), ref TotalCount);
if (dt != null && dt.Rows.Count > 0)
{
this.lbCount.Text = TotalCount.ToString();
lblCount.Text = TotalCount.ToString();
lblCurrPage.Text = CurrPage.ToString();
lblPageCount.Text = System.Math.Ceiling(Convert.ToDouble(TotalCount) / Convert.ToDouble(ViewState["pagesize"])).ToString();
rptCommentForeList.DataSource = dt;
rptCommentForeList.DataBind();
}
else
{
lbCount.Text = "0";
divcontentMain.Style.Add("display", "none");
divmessageMain.Style.Add("display", "none");
}
}
/// <summary>
///
/// </summary>
private void Bind(int ID)
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("InfoRecommend", "*", "ResourceID", 100, 1, 0, 1, "ResourceID=" + ID);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
/// <summary>
///
/// </summary>
private void Bind()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("RecommendedResources", "*", "ResourceID", 100, 1, 0, 1, "");
this.ResDongList.DataSource = dt;
this.ResDongList.DataBind();
}
/// <summary>
/// 项目有效期
/// </summary>
private void SetValid()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='xmyxqxx' ");
this.rblXmyxqxx.DataTextField = "cdictname";
this.rblXmyxqxx.DataValueField = "idictvalue";
this.rblXmyxqxx.DataSource = dt;
this.rblXmyxqxx.DataBind();
}
public void CheckConflict()
{
this.Visible = false;
Tz888.BLL.Conn SqlConn = new Tz888.BLL.Conn();
string tableName = "";
string selectColumns = "*";
string keyColumn = "InfoID";
int pageSize = 20;
string sort = "InfoID DESC";
long CurrentPage = 1;
long PageCount = 10;
if (!string.IsNullOrEmpty(_strCriteria))
{
this._strCriteria += " And InfoTypeID = '" + theInfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And ( AuditingStatus = 0 OR AuditingStatus = 1)";
}
else
{
this._strCriteria = "InfoTypeID = '" + theInfoType + "' And DelStatus <> 1 And DATEADD(Month, ValidateTerm, ValidateStartTime) <= GETDATE() And ( AuditingStatus = 0 OR AuditingStatus = 1)";
}
switch (this.theInfoType.ToLower())
{
case "capital":
tableName = "CapitalInfo_VIW";
break;
case "merchant":
tableName = "MerchantInfo_VIW";
break;
case "project":
tableName = "ProjectInfo_VIW";
break;
default:
break;
}
DataTable dt = SqlConn.GetList(tableName, keyColumn, selectColumns, _strCriteria, sort, ref CurrentPage, pageSize, ref PageCount);
if (dt != null && dt.Rows.Count > 0)
{
this.lbMessage.Text = "可能存在以下重复信息";
this.rpCheck.DataSource = dt.DefaultView;
this.rpCheck.DataBind();
this.plDisplay.Visible = true;
}
else
{
this.lbMessage.Text = "<font color='red'>不存在可能重复的信息！</font>";
this.plDisplay.Visible = false;
}
this.Visible = true;
}
private void BindShow()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='xmyxqxx' ");
this.rdlValiditeTerm.DataTextField = "cdictname";
this.rdlValiditeTerm.DataValueField = "idictvalue";
this.rdlValiditeTerm.DataSource = dt;
this.rdlValiditeTerm.SelectedIndex = 0;
this.rdlValiditeTerm.DataBind();
this.rdlValiditeSystem.DataTextField = "cdictname";
this.rdlValiditeSystem.DataValueField = "idictvalue";
this.rdlValiditeSystem.DataSource = dt;
this.rdlValiditeSystem.SelectedIndex = 0;
this.rdlValiditeSystem.DataBind();
Tz888.Model.LoansInfoTab loansInfotab = (Tz888.Model.LoansInfoTab)loansInfoTabbll.GetLoansInfoTabByLoansInfoId(loansInfoID);
Tz888.Model.LoansInfo loansinfo = (Tz888.Model.LoansInfo)loansinfobll.GetLoansInfoByLoansInfoId(loansInfoID);
Tz888.Model.LoanscontactsTab loanscontactstab = (Tz888.Model.LoanscontactsTab)loanscontacttabbll.GetLoanscontactsTabByLoansInfoId(loansInfoID);
txtCapitalTitle.Text = loansInfotab.LoansTitle.ToString();
txtCapitalMoney.Text = loansinfo.Amount.ToString();
radiohaiMoney.Items.FindByValue(loansinfo.Reimbursement.ToString().Trim()).Selected = true;
radiodanbao.Items.FindByValue(loansinfo.Guarantee.ToString().Trim()).Selected = true;
txtCapitalIntent.Value = loansinfo.BorrowingUse.ToString();
txtcontactsName.Text = loanscontactstab.ContactsName.ToString();
txtcontactsphone.Text = loanscontactstab.Moblie.ToString();
string[] num = loanscontactstab.Telephone.ToString().Trim().Split('-');
if (num.Length == 1)
{
txttel1.Text = num[0];
}
else if (num.Length == 2)
{
txttel1.Text = num[0];
}
else if (num.Length == 3)
{
txtcontactsTel.Text = num[0];
txttel1.Text = num[1];
txttel2.Text = num[2];
}
txtcontactsemail.Text = loanscontactstab.Mail.ToString();
txtcontactsaddress.Text = loanscontactstab.Address.ToString();
this.ZoneSelectControl1.CountryID = loansinfo.CountryID.ToString().Trim();
this.ZoneSelectControl1.ProvinceID = loansinfo.ProvinceID.ToString().Trim();
this.ZoneSelectControl1.CityID = loansinfo.CityID.ToString().Trim();
this.ZoneSelectControl1.CountyID = loansinfo.CountyID.ToString().Trim();
this.rdlValiditeTerm.Items.FindByValue(loansinfo.Deadline.ToString().Trim()).Selected = true;
this.rdlValiditeSystem.Items.FindByValue(loansinfo.ValidityID.ToString().Trim()).Selected = true;
}
protected void btnOk_Click(object sender, EventArgs e)
{
Tz888.BLL.GoodFriend friendBll = new Tz888.BLL.GoodFriend();
Tz888.Model.GoodFriend model = new Tz888.Model.GoodFriend();
if (this.tboxName.Text.IndexOf(",") > -1)
{
string[] names = this.tboxName.Text.Trim().Split(',');
for (int i = 0; i < names.Length; i++)
{
if (names[i].Trim() != "")
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
string strWhere = "";
strWhere = "nickName='" + names[i].Trim() + "'";
long m = 1;
long j = 1;
long k = 1;
DataTable dt = dal.GetList("loginInfoTab", "loginName", "loginName", strWhere, "loginName", ref m, k, ref j);
if (dt != null && dt.Rows.Count > 0)
{
model.LoginName = Page.User.Identity.Name;
//model.LoginName = "kiki";
model.ContactName = dt.Rows[0][0].ToString();
model.GroupId = 3;
friendBll.AddFriend(model);
}
else
{
Response.Write("<script>alert('用户不存在')</script>");
}
}
}
}
else
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
string strWhere = "";
strWhere = "nickName='" + this.tboxName.Text.Trim() + "'";
long i = 1;
long j = 1;
long k = 1;
DataTable dt = dal.GetList("loginInfoTab", "loginName", "loginName", strWhere, "loginName", ref i, k, ref j);
if (dt != null && dt.Rows.Count > 0)
{
model.LoginName = Page.User.Identity.Name;
//model.LoginName = "kiki";
model.ContactName = dt.Rows[0][0].ToString();
model.GroupId = 3;
friendBll.AddFriend(model);
}
else
{
Response.Write("<script>alert('用户不存在')</script>");
}
}
getList();
}
private void Bind(int ResID)
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("RecommendedResources", "*", "ResourceID", 100, 1, 0, 1, "ResourceID=" + ResID);
this.txtName.Text = dt.Rows[0]["ResourceName"].ToString();
this.TextList.Text = dt.Rows[0]["TuijianID"].ToString();
this.TextBei.Value = dt.Rows[0]["FromSource"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
HtmlInputCheckBox check = new HtmlInputCheckBox();
DataTable dt = dal.GetList("UserParametersTab", "*", "parID", 1, 1, 0, 1, "LoginName='topfo001'");
this.ViewState["MemberLoginName"] = "topfo001";
//try
//{
txtTitle.Text = Session["title"].ToString(); //默认标题
if (Convert.ToString(Request["tag"]) == null)
{
tag = "Add";
}
else
{
tag = Request["tag"].ToString();
}
// tag =Convert.ToString(Request.QueryString["tag"].ToString()) == "" ? "Add" : Request.QueryString["tag"].ToString();
ID = Convert.ToInt32(Request.QueryString["id"]);
//}
//catch
//{
// tag = "Add";
//}
setNotice();
try
{
DataSet ds = new DataSet();
ds = (DataSet)Session["CustomInfo"];
dt = ds.Tables[0];
if (!Page.IsPostBack)
{
ControlBind(dt);
}
}
catch
{
}
#region 查看用户己订阅的条数
if (Page.User.IsInRole("GT1001"))
{
Tz888.Common.MessageBox.ShowAndRedirect(this.Page, "对不起，普通会员不能进行此项服务！", "http://member.topfo.com/helper/MatchingInfo.aspx");
return;
}
else
{
//divMessage.InnerHtml = "如果您无暇上网，又担心错过了好机会，请立即进行订阅设置。<br/>第一时间抢占先机，万千财富滚滚来！<br/>您是拓富通会员，享有无限数量的免费订阅权限!";
//labMessage.Visible = false;
}
#endregion
}
//退出方式
public void bindReturn()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("SetReturnModeTAB", "*", "ReturnModeID", 10, 1, 0, 0, "");
//chkReturn.DataTextField = "ReturnModeName";
//chkReturn.DataValueField = "ReturnModeID";
//chkReturn.DataSource = dt;
//chkReturn.DataBind();
}
protected void ServiesBind()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("ReleaseTabViw", "InfoID,ServiesBID,ServiesMID,Title,CreateDate,Price,AuditStatus,AuditStatus", "CreateDate ", 5, 1, 0, 1, "DelStatus=0 and AuditStatus=1 and UserName!='" + Page.User.Identity.Name.ToString() + "'");
ServiesList.DataSource = dt;
ServiesList.DataBind();
Literal1.Text = "最新五条";
}
//项目有效期限
public void Xmyxqxx()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='Xmyxqxx' ");
rblXmyxqxx.DataTextField = "cdictname";
rblXmyxqxx.DataValueField = "idictvalue";
rblXmyxqxx.DataSource = dt;
rblXmyxqxx.DataBind();
}
//融资对象
public void bindObj()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("SETfinancingTargetTab", "*", "financingID", 10, 1, 0, 0, "");
rbtnObj.DataTextField = "financingName";
rbtnObj.DataValueField = "financingID";
rbtnObj.DataSource = dt;
rbtnObj.DataBind();
}
//邦定学历
private void BindDegree()
{
Tz888.BLL.Conn bll = new Tz888.BLL.Conn();
DataTable dt = bll.GetList("SetDegreeInfoTab", " * ", "degreeid", 50, 1, 0, 0, "");
ddlDegree.DataTextField = "degreename";
ddlDegree.DataValueField = "degreeid";
ddlDegree.DataSource = dt;
ddlDegree.DataBind();
}
/// <summary>
/// 机构注册资金
/// </summary>
private void BindRegDollar()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='jgzczj' ");
this.rblRegisterdollar.DataTextField = "cdictname";
this.rblRegisterdollar.DataValueField = "idictvalue";
this.rblRegisterdollar.DataSource = dt;
this.rblRegisterdollar.DataBind();
}
/// <summary>
/// 机构团队规模
/// </summary>
private void BindTeam()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='jgtdgm' ");
this.rblTeam.DataTextField = "cdictname";
this.rblTeam.DataValueField = "idictvalue";
this.rblTeam.DataSource = dt;
this.rblTeam.DataBind();
}
/// <summary>
/// 机构成功投资事件总数
/// </summary>
private void BindCheng()
{
Tz888.BLL.Conn dal = new Tz888.BLL.Conn();
DataTable dt = dal.GetList("dicttab", "*", "idictvalue", 10, 1, 0, 0, " cdicttype='jgcgtzsjs' ");
this.rblSucess.DataTextField = "cdictname";
this.rblSucess.DataValueField = "idictvalue";
this.rblSucess.DataSource = dt;
this.rblSucess.DataBind();
}
