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(); }