protected void Page_Load(object sender, EventArgs e) { Literal1.Text = "<strong><img style=\"margin:0 6px -6px 0;\" src=\"/images/mail/6464_034.png\" width=\"32\" height=\"32\" />您的申请已提交,感谢您的支持!</strong>"; GetRequest GetRequest1 = new GetRequest(); SymmetricMethod ss = new SymmetricMethod(); check ck = new check(); string uid = "0"; try { uid = ck.CheckNumber(ss.Decrypto(GetRequest1.GetRequestQueryString("uid", ""))); data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = ""; sql = "SELECT userid FROM TB_TOPIC_REG WHERE userid = " + uid + ""; ds = cn.mdb_ds(sql, "user"); if (ds.Tables["user"].Rows.Count > 0) { Literal1.Text = "<strong><img style=\"margin:0 6px -6px 0;\" src=\"/images/mail/wr.gif\" width=\"32\" height=\"32\" />您已经提交过申请!</strong>"; } else { sql = "INSERT INTO TB_TOPIC_REG (userid) VALUES (" + uid + ")"; cn.mdb_exe(sql); Literal1.Text = "<strong><img style=\"margin:0 6px -6px 0;\" src=\"/images/mail/6464_034.png\" width=\"32\" height=\"32\" />您的申请已提交,感谢您的支持!</strong>"; } } catch { Literal1.Text = "<strong><img style=\"margin:0 6px -6px 0;\" src=\"/images/mail/wr.gif\" width=\"32\" height=\"32\" />抱歉,您需在注册邮件或普通会员注册页面中点击申请链接!</strong>"; } }
protected void Page_Load(object sender, EventArgs e) { GetRequest GetRequest1 = new GetRequest(); string port = GetRequest1.GetRequestQueryString("port","1"); if (port.ToString().ToLower() == "shanghai") { PlaceHolder1.Visible = true; } if (port.ToString().ToLower() == "ningbo") { PlaceHolder2.Visible = true; } if (port.ToString().ToLower() == "tianjin") { PlaceHolder3.Visible = true; } if (port.ToString().ToLower() == "dalian") { PlaceHolder4.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetRequest g=new GetRequest (); string name = g.GetRequestQueryString("name", ""); data_conn cn = new data_conn(); DataSet ds = cn.mdb_ds("select * from TB_Ship where name_en_s='" + name + "'", "ship"); if (ds.Tables["ship"].Rows.Count > 0) { Literal1.Text = ds.Tables["ship"].Rows[0]["name_cn_s"].ToString() + "/" + ds.Tables["ship"].Rows[0]["name_cn"].ToString() + "/" + ds.Tables["ship"].Rows[0]["name_en_s"].ToString() + "/" + ds.Tables["ship"].Rows[0]["name_en"].ToString(); Literal2.Text = ds.Tables["ship"].Rows[0]["name_cn"].ToString(); Literal3.Text = ds.Tables["ship"].Rows[0]["Website"].ToString(); Literal4.Text = ds.Tables["ship"].Rows[0]["cargotail"].ToString(); Literal5.Text = ds.Tables["ship"].Rows[0]["contact"].ToString(); Literal6.Text = ds.Tables["ship"].Rows[0]["introduction"].ToString(); //Literal7.Text = ds.Tables["ship"].Rows[0]["name_cn_s"].ToString() + "/" + ds.Tables["ship"].Rows[0]["name_cn"].ToString() + "/" + ds.Tables["ship"].Rows[0]["name_en_s"].ToString() + "/" + ds.Tables["ship"].Rows[0]["name_en"].ToString(); Littitle.Text = "<title>" + ds.Tables["ship"].Rows[0]["name_cn_s"].ToString() + "-" + ds.Tables["ship"].Rows[0]["name_cn"].ToString() + "-" + ds.Tables["ship"].Rows[0]["name_en_s"].ToString() + "-" + ds.Tables["ship"].Rows[0]["name_en"].ToString() + "-联系方式-公司介绍-环球运费网</title>"; Litkey.Text = "<meta name=\"keywords\" content=\"" + ds.Tables["ship"].Rows[0]["name_cn_s"].ToString() + "," + ds.Tables["ship"].Rows[0]["name_cn"].ToString() + "," + ds.Tables["ship"].Rows[0]["name_en_s"].ToString() + "," + ds.Tables["ship"].Rows[0]["name_en"].ToString() + ",船公司信息,船公司联系方式,船公司网站,船公司介绍-环球运费网\" />"; Litdes.Text = "<meta name=\"description\" content=\"" + ds.Tables["ship"].Rows[0]["name_cn_s"].ToString() + ds.Tables["ship"].Rows[0]["name_en_s"].ToString() + "船公司的联系方式和介绍,环球运费网提供最新最全面的" + ds.Tables["ship"].Rows[0]["name_en_s"].ToString() + "船公司信息\" />"; LoadLeft(ds.Tables["ship"].Rows[0]["name_en_s"].ToString()); } else { } } }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { GetRequest GetRequest1 = new GetRequest(); check check1 = new check(); string pro1 = check1.CheckInput(CheckBox1.Checked == true ? "1" : "0"); //Response.Write(pro1 + ":" + pro2 + ":" + pro3 + ":" +pro4); string userid = check1.CheckInput(GetRequest1.GetRequestQueryString("user_id", "0")); string companyname = check1.CheckInput(TextBox1.Text); string realname = check1.CheckInput(TextBox2.Text); string gender = RadioButtonList1.SelectedValue; string rank = check1.CheckInput(TextBox3.Text); string phone = check1.CheckInput(TextBox4.Text + "-" + TextBox7.Text + "-" + TextBox8.Text); string movephone = check1.CheckInput(TextBox5.Text); string useremail = check1.CheckInput(TextBox6.Text); if (pro1 == "0") { MessageBox("", "您好!请至少选择一件产品"); } else { if (companyname == "" | realname == "" | gender == "" | rank == "" | TextBox7.Text == "" | TextBox8.Text == "" | movephone == "" | useremail == "") { MessageBox("", "您好!请将表格填写完整"); } else { data_conn cn = new data_conn(); string sql = ""; sql += "INSERT INTO TB_PRODUCTS_APPLY "; sql += "("; sql += "pro7,"; sql += "userid,"; sql += "companyname,"; sql += "realname,"; sql += "gender,"; sql += "rank,"; sql += "phone,"; sql += "movephone,"; sql += "useremail "; sql += ") VALUES ("; sql += "" + pro1 + ","; sql += "" + userid + ","; sql += "'" + companyname + "',"; sql += "'" + realname + "',"; sql += "'" + gender + "',"; sql += "'" + rank + "',"; sql += "'" + phone + "',"; sql += "'" + movephone + "',"; sql += "'" + useremail + "' "; sql += ")"; cn.mdb_exe(sql); Response.Redirect("success.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { GetRequest GetRequest1 = new GetRequest(); SymmetricMethod ss = new SymmetricMethod(); check ck = new check(); string uid = "0"; uid = ck.CheckNumber(GetRequest1.GetRequestQueryString("uid", "")); Response.Redirect("index.aspx?uid=" + ss.Encrypto(uid)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetRequest g = new GetRequest(); string name = g.GetRequestQueryString("name", ""); data_conn cn = new data_conn(); DataSet ds = cn.mdb_ds("select * from TB_Y_Port where portname_en='" + name + "'", "ship"); //Response.Write("select * from TB_Y_Port where portname_en='" + name + "'"); if (ds.Tables["ship"].Rows.Count > 0) { Literal1.Text = ds.Tables["ship"].Rows[0]["country_en"].ToString() + "/" + ds.Tables["ship"].Rows[0]["country"].ToString() + "-" + ds.Tables["ship"].Rows[0]["portname_en"].ToString() + "/" + ds.Tables["ship"].Rows[0]["portname"].ToString(); Literal4.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal2.Text = ds.Tables["ship"].Rows[0]["portname"].ToString(); Literal10.Text = ds.Tables["ship"].Rows[0]["portNum"].ToString(); Literal5.Text = ds.Tables["ship"].Rows[0]["Line"].ToString(); Literal3.Text = ds.Tables["ship"].Rows[0]["country_en"].ToString(); Literal11.Text = ds.Tables["ship"].Rows[0]["country"].ToString(); //Literal7.Text = "<a href='http://localhost/ports/list---" + ds.Tables["ship"].Rows[0]["int_country"].ToString() + "-----1.html'>" + ds.Tables["ship"].Rows[0]["country_en"].ToString() + "/" + ds.Tables["ship"].Rows[0]["country"].ToString() + "</a> > " + ds.Tables["ship"].Rows[0]["portname_en"].ToString() + "/" + ds.Tables["ship"].Rows[0]["portname"].ToString(); Literal6.Text = ds.Tables["ship"].Rows[0]["intro"].ToString(); Literal8.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal13.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal15.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal17.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal19.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal21.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal23.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal25.Text = ds.Tables["ship"].Rows[0]["portname"].ToString() + ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal9.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal12.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal14.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal16.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal18.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal20.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal22.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Literal24.Text = ds.Tables["ship"].Rows[0]["portname_en"].ToString(); Littitle.Text = "<title>" + ds.Tables["ship"].Rows[0]["country"].ToString() + "-" + ds.Tables["ship"].Rows[0]["country_en"].ToString() + "-" + ds.Tables["ship"].Rows[0]["portname"].ToString() + "-" + ds.Tables["ship"].Rows[0]["portname_en"].ToString() + "-港口介绍,港口介绍-环球运费网</title>"; Litkey.Text = "<meta name=\"keywords\" content=\"" + ds.Tables["ship"].Rows[0]["country"].ToString() + "港口," + ds.Tables["ship"].Rows[0]["country_en"].ToString() + " port," + ds.Tables["ship"].Rows[0]["portname"].ToString() + "," + ds.Tables["ship"].Rows[0]["portname_en"].ToString() + "," + ds.Tables["ship"].Rows[0]["portname"].ToString() + "港," + ds.Tables["ship"].Rows[0]["portname_en"].ToString() + "port,港口介绍,港口代码-环球运费网\" />"; Litdes.Text = "<meta name=\"description\" content=\"" + ds.Tables["ship"].Rows[0]["country"].ToString() + "港口," + ds.Tables["ship"].Rows[0]["country_en"].ToString() + " port," + ds.Tables["ship"].Rows[0]["portname"].ToString() + "," + ds.Tables["ship"].Rows[0]["portname_en"].ToString() + "," + ds.Tables["ship"].Rows[0]["portname"].ToString() + "港," + ds.Tables["ship"].Rows[0]["portname_en"].ToString() + "ports介绍,港口代码,环球运费网提供最全面的" + ds.Tables["ship"].Rows[0]["portname"].ToString() + "港口信息\" />"; //LoadHotShip(); } else { } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetRequest GetRequest1 = new GetRequest(); destport = GetRequest1.GetRequestQueryString("destport", ""); line = GetRequest1.GetRequestQueryString("line", ""); type = GetRequest1.GetRequestQueryString("type", ""); p = GetRequest1.GetRequestQueryString("p", "1"); if (type == "") { loadRecord(); PlaceHolder1.Visible = true; } if (type == "fs") { loadRecord1(); PlaceHolder2.Visible = true; } if (type == "ls") { loadRecord(); PlaceHolder1.Visible = true; } if (type == "ll") { loadRecord2(); PlaceHolder1.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetRequest GetRequest1 = new GetRequest(); cr = GetRequest1.GetRequestQueryString("cr", ""); l = GetRequest1.GetRequestQueryString("l", ""); p = GetRequest1.GetRequestQueryString("p", "1"); loadRecord(); } }
public void LoadSavedOrder() { check ck = new check(); data_conn cn = new data_conn(); DataSet ds = new DataSet(); GetRequest GetRequest1 = new GetRequest(); string u = ck.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); string orderid = ck.CheckInput(GetRequest1.GetRequestQueryString("orderid", "0")); string role = GetRequest1.GetRequestQueryString("role", ""); AllinOrder AllinOrder1 = new AllinOrder(); string[] odetail; odetail = AllinOrder1.GetOrderDetail(orderid); ltrOrderViewCode.Text = odetail[0]; ltrOrderViewShipper.Text = odetail[8]; ltrOrderViewConsignee.Text = odetail[9]; ltrOrderViewNotifyParty.Text = odetail[10]; ltrOrderViewCompanyName.Text = odetail[11]; ltrOrderViewEmail.Text = odetail[12]; ltrOrderViewContactor.Text = odetail[13]; ltrOrderViewMobile.Text = odetail[14]; ltrOrderViewTel.Text = odetail[15]; ltrOrderViewFax.Text = odetail[16]; ltrOrderViewStartport.Text = odetail[17]; ltrOrderViewMidport.Text = odetail[18]; ltrOrderViewDestport.Text = odetail[19]; ltrOrderViewMarksNumbers.Text = odetail[20]; ltrOrderViewNumbersofPackages.Text = odetail[21]; ltrOrderViewDescription.Text = odetail[22]; ltrOrderViewGrossWeight.Text = odetail[23]; ltrOrderViewMeasurement.Text = odetail[24]; ltrOrderViewCarrier.Text = odetail[26]; ltrOrderViewKaihangri.Text = odetail[27]; ltrOrderViewZhuangxiangri.Text = odetail[28]; ltrOrderViewJieguanri.Text = odetail[29]; ltrOrderViewGP.Text = odetail[34]; ltrFreightGP.Text = odetail[49]; ltrFreightGPV.Text = odetail[50]; ltrFreightAppend.Text = odetail[44]; ltrFreightCarrier.Text = odetail[26]; ltrOrderViewHyf.Text = odetail[59]; ltrOrderViewBeizhu.Text = odetail[36]; if (odetail[44] != "") { ltrOrderFujiafei.Text = "(附加费:" + odetail[44] + ")"; } string order_type_string = odetail[58]; ltrSMS.Text = "<a href=\"/member/pm_detail.aspx?cid=" + odetail[4] + "\" id=\"linkSMS\" target=\"_blank\"></a>"; AllinFreight AllinFreight1 = new AllinFreight(); string[] fdetail; if (odetail[7] == "0") { fdetail = AllinFreight1.GetFreightDetail("9", ck.CheckNumber(odetail[6]), "0"); } else { fdetail = AllinFreight1.GetFreightDetail("9", "0", ck.CheckNumber(odetail[7])); } ltrFreightTitle.Text = "<span style=\"font-weight:bold;font-size:14px\">" + odetail[75] + "</span>"; ltrFreightPostdate.Text = Convert.ToDateTime(odetail[65]).ToString("MM") + "/" + Convert.ToDateTime(odetail[65]).ToString("dd"); ltrFreightEnddate.Text = Convert.ToDateTime(odetail[66]).ToString("MM") + "/" + Convert.ToDateTime(odetail[66]).ToString("dd"); ltrFreightCompany.Text = fdetail[18]; ltrFreightAllinStar.Text = fdetail[19]; ltrFreightUserStar.Text = fdetail[20]; ltrFreightLine.Text = odetail[69]; ltrFreightStartport.Text = odetail[70]; ltrFreightDestport.Text = odetail[71]; ltrFreightAssuranceSpace.Text = odetail[100]; ltrFreightAssurancePrice.Text = odetail[101]; ltrOrderFirstStep.Text = odetail[2] + ":订舱方 " + odetail[107] + " 创建订单"; string sql = ""; sql += "SELECT * FROM TB_ORDER_DETAIL WHERE order_code = '" + orderid + "'"; ds = cn.mdb_ds(sql, "order"); rptOrder.DataSource = ds.Tables["order"].DefaultView; rptOrder.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["l"] != null) { GetRequest g = new GetRequest(); l = g.GetRequestQueryString("l", ""); n = g.GetRequestQueryString("n", ""); p = g.GetRequestQueryString("p", "1"); //seo部分 string nkey = ""; string lkey = ""; string nkey2 = ""; if (l != "") { lkey = l; } else if (n != "") { nkey = n + "字母开头"; } if (n != "") { nkey2 = n + "字母开头"; } Littitle.Text = "<title>" + lkey + nkey + "船公司," + lkey + nkey + "船公司信息," + lkey + nkey + "船公司联系方式," + lkey + nkey + "船公司查询" + "-环球运费网</title>"; Litkey.Text = "<meta name=\"keywords\" content=\"" + nkey2 + " " + lkey + " " + "船公司-环球运费网\" />"; Litdes.Text = "<meta name=\"description\" content=\"" + "环球运费网提供" + lkey + nkey + "船公司的介绍," + lkey + nkey + "船公司电话," + lkey + nkey + "船公司网址," + lkey + nkey + "船公司介绍等详细信息查询" + "\" />"; //seo结束 txtkey.Value = l; string strLetter = ""; n = n.ToUpper(); for (int i = 0; i < arrayLetter.Length; i++) { if (arrayLetter[i] == n) { strLetter += "<a href=\"/carrier/list-" + Server.UrlEncode(l) + "-" + arrayLetter[i] + "------1.html\"><span style='color:Red'>" + arrayLetter[i] + "</span></a> "; } else { strLetter += "<a href=\"/carrier/list-" + Server.UrlEncode(l) + "-" + arrayLetter[i] + "------1.html\">" + arrayLetter[i] + "</a> "; } } lclletter.Text = strLetter; LoadRecord(p); } else { string strLetter = ""; for (int i = 0; i < arrayLetter.Length; i++) { strLetter += "<a href=\"/carrier/list--" + arrayLetter[i] + "------1.html\">" + arrayLetter[i] + "</a> "; } lclletter.Text = strLetter; LoadRecord("1"); } } }
protected void Page_Load(object sender, EventArgs e) { GetRequest g = new GetRequest(); l = g.GetRequestQueryString("l", ""); n = g.GetRequestQueryString("n", ""); p = g.GetRequestQueryString("p", ""); c = g.GetRequestQueryString("c", ""); string lkey = ""; string nkey = ""; string ckey = ""; if (n != "") { data_conn cn = new data_conn(); DataSet ds = cn.mdb_ds("select TB_Y_Line.Line,TB_Y_Line.id,count(TB_Y_Port.id) as count from TB_Y_Port,TB_Y_Line where TB_Y_Port.int_Line=TB_Y_Line.id group by TB_Y_Line.Line,TB_Y_Line.id order by count desc", "line"); Repeater4.DataSource = ds.Tables["line"].DefaultView; Repeater4.DataBind(); divLine.Visible = true; if (n != "0") { DataSet ds2 = cn.mdb_ds("select * from TB_Y_Line where id=" + n, "Line"); Literal3.Text = "<div style=\"font-size:small; margin:0px 20px 10px 20px; line-height:20px;\"><strong>" + ds2.Tables["Line"].Rows[0]["Line"].ToString() + "简介</strong><br /><br />" + ds2.Tables["Line"].Rows[0]["intro"].ToString() + "</div>"; nkey = ds2.Tables["Line"].Rows[0]["Line"].ToString(); } } else { divLine.Visible = false; } if (c != "") { data_conn cn = new data_conn(); DataSet ds = cn.mdb_ds("select top 35 TB_Y_Country.country,TB_Y_Country.id,count(TB_Y_Port.id) as count from TB_Y_Port,TB_Y_Country where TB_Y_Port.int_country=TB_Y_Country.id group by TB_Y_Country.country,TB_Y_Country.id order by count desc", "Country"); Repeater5.DataSource = ds.Tables["Country"].DefaultView; Repeater5.DataBind(); divCountry.Visible = true; DataSet ds1 = cn.mdb_ds("select TB_Y_Country.country,TB_Y_Country.id,count(TB_Y_Port.id) as count from TB_Y_Port,TB_Y_Country where TB_Y_Port.int_country=TB_Y_Country.id group by TB_Y_Country.country,TB_Y_Country.id order by count desc", "Country"); Repeater6.DataSource = ds1.Tables["Country"].DefaultView; Repeater6.DataBind(); if (ds.Tables["Country"].Select("id=" + c).Length == 0 && c != "0") { Literal2.Text = "(" + trimString(ds1.Tables["Country"].Select("id=" + c)[0]["country"].ToString(), 4) + ")"; } if (c != "0") { DataSet ds2 = cn.mdb_ds("select * from TB_Y_Country where id=" + c, "country"); Literal3.Text = "<div style=\"font-size:small; margin:0px 20px 10px 20px; line-height:20px;\"><strong>" + ds2.Tables["country"].Rows[0]["country"].ToString() + "简介</strong><br />" + ds2.Tables["country"].Rows[0]["intro"].ToString() + "</div>"; ckey = ds2.Tables["country"].Rows[0]["country"].ToString() + "," + ds2.Tables["country"].Rows[0]["country_en"].ToString(); } } else { divCountry.Visible = false; divCountry1.Visible = false; } if (!IsPostBack) { if (Request.QueryString["l"] != null) { LoadRecord(p); } else { LoadRecord("1"); } //seo部分 Littitle.Text = "<title>" + lkey + nkey + ckey + "港口介绍,港口代码," + lkey + nkey + ckey + "港口查询" + "-环球运费网</title>"; Litkey.Text = "<meta name=\"keywords\" content=\"" + lkey + nkey + ckey + "港口介绍,港口代码-环球运费网\" />"; Litdes.Text = "<meta name=\"description\" content=\"" + "环球运费网提供最全的" + lkey + nkey + ckey + "港口介绍,港口代码," + lkey + nkey + ckey + "港口详细信息查询" + "\" />"; //seo结束 } }
protected void Page_Load(object sender, EventArgs e) { data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = ""; check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); p = check1.CheckNumber(GetRequest1.GetRequestQueryString("p", "1")); sp = check1.CheckInput(GetRequest1.GetRequestQueryString("sp", "")); dp = check1.CheckInput(GetRequest1.GetRequestQueryString("dp", "")); l = check1.CheckInput(GetRequest1.GetRequestQueryString("l", "")); cr = check1.CheckInput(GetRequest1.GetRequestQueryString("cr", "")); LoadRecord(p); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { GetRequest GetRequest1 = new GetRequest(); string type = "0"; type = GetRequest1.GetRequestQueryString("type", "0"); if (type == "1") { CheckBox1.Checked = true; } if (type == "2") { CheckBox2.Checked = true; } if (type == "3") { CheckBox3.Checked = true; } if (type == "4") { CheckBox4.Checked = true; } if (type == "5") { CheckBox5.Checked = true; } if (type == "6") { CheckBox6.Checked = true; } //Response.Write("11"); } }
protected void SetStep(string status, string yiping_shipper, string yiping_forward) { GetRequest GetRequest1 = new GetRequest(); string role = GetRequest1.GetRequestQueryString("role", ""); string ss1 = "<img src=\"/images/fcl/shipper_booking_m_r1_c1.gif\" /> "; string ss4 = "<img src=\"/images/fcl/shipper_booking_m2_r1_c9.gif\" /> "; string ss4_p = "<img src=\"/images/fcl/shipper_booking_m_r1_c9.gif\" /> "; if (role == "shipper") { ss1 = "<img src=\"/images/fcl/shipper_booking_m_r1_c1.gif\" /> "; ss4 = "<img src=\"/images/fcl/shipper_booking_m2_r1_c9.gif\" /> "; ss4_p = "<img src=\"/images/fcl/shipper_booking_m_r1_c9.gif\" /> "; }//订舱方显示的文本 if (role == "forward") { ss1 = "<img src=\"/images/fcl/booking_m_r1_c1.gif\" /> "; ss4 = "<img src=\"/images/fcl/booking_m2_r1_c9.gif\" /> "; ss4_p = "<img src=\"/images/fcl/booking_m_r1_c9.gif\" /> "; }//承运方显示的文本 string s1 = ss1; string a1 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; string s2 = "<img src=\"/images/fcl/booking_m2_r1_c3.gif\" /> "; string a2 = "<img src=\"/images/fcl/booking_bb2.gif\" /> "; string s3 = "<img src=\"/images/fcl/booking_m2_r1_c5.gif\" /> "; string a3 = "<img src=\"/images/fcl/booking_bb2.gif\" /> "; string s4 = ss4; string a4 = "<img src=\"/images/fcl/booking_bb2.gif\" /> "; string s5 = "<img src=\"/images/fcl/booking_m2_r1_c7.gif\" />"; string s = ""; if (status == "3") { s2 = "<img src=\"/images/fcl/booking_m_r1_c3.gif\" /> "; a2 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; } if (status == "4") { s2 = "<img src=\"/images/fcl/booking_m_r1_c3.gif\" /> "; a2 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; s3 = "<img src=\"/images/fcl/booking_m_r1_c5.gif\" /> "; a3 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; } if (status == "5") { s2 = "<img src=\"/images/fcl/booking_m_r1_c3.gif\" /> "; a2 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; s3 = "<img src=\"/images/fcl/booking_m_r1_c5.gif\" /> "; a3 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; s4 = ss4_p; a4 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; } if (yiping_shipper == "1" & yiping_forward == "1") { s2 = "<img src=\"/images/fcl/booking_m_r1_c3.gif\" /> "; a2 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; s3 = "<img src=\"/images/fcl/booking_m_r1_c5.gif\" /> "; a3 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; s4 = ss4_p; a4 = "<img src=\"/images/fcl/booking_m_r1_c12.gif\" /> "; s5 = "<img src=\"/images/fcl/booking_m_r1_c7.gif\" />"; } s = s1 + a1 + s2 + a2 + s3 + a3 + s4 + a4 + s5; ltrStep.Text = s; }
protected void Page_Load(object sender, EventArgs e) { GetRequest GetRequest1 = new GetRequest(); string p = ""; p = GetRequest1.GetRequestQueryString("p", "1"); string u = ""; u = GetRequest1.GetRequestCookies("user_id", "0"); int item = 0; item = (Convert.ToInt32(p) - 1) * 10; data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = ""; sql += "SELECT TOP 10 * "; sql += "FROM (SELECT * FROM V_REPASTE_INDEX) AS T WHERE rid NOT IN "; sql += "(SELECT TOP " + item.ToString() + " rid FROM V_REPASTE_INDEX ORDER BY rid DESC) ORDER BY rid DESC"; ds = cn.mdb_ds(sql, "repaste"); Repeater1.DataSource = ds.Tables["repaste"].DefaultView; Repeater1.DataBind(); sql = "SELECT rid as c FROM V_REPASTE_INDEX "; ds = cn.mdb_ds(sql, "repaste"); string base_url = "random.aspx?p="; string end_url = ""; int cp = Convert.ToInt32(p); int tp = 1; int count = 0; count = ds.Tables["repaste"].Rows.Count; if (count % 10 > 0 || count == 0) { tp = count / 10 + 1; } else { tp = count / 10; } string s = ""; if (cp == 1) { //s = s + " <span class=\"selected2\">首页</span> "; //s = s + " <span class=\"selected2\">上一页</span> "; s = s + " <span class=\"selected2\">1</span> "; for (int i = 2; i <= (tp < 10 ? tp : 10); i++) { s = s + " <a href=\"" + base_url + "" + i + end_url + "\"><span>" + i + "</span></a> "; } } else { s = s + " <a href=\"" + base_url + "1" + end_url + "\"><span>首页</span></a> "; s = s + " <a href=\"" + base_url + (cp - 1) + end_url + "\"><span>上一页</span></a> "; for (int i = (cp <= 5 ? 1 : (tp - cp < 5 ? (tp - 9 < 1 ? 1 : tp - 9) : cp - 4)); i <= cp - 1; i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } s = s + " <span class=\"selected2\">" + cp + "</span> "; for (int i = cp + 1; i <= (cp + 5 >= tp ? tp : (cp <= 5 ? (tp >= 10 ? 10 : tp) : cp + 5)); i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } } if (cp == tp) { //s = s + " <span class=\"selected2\">下一页</span> "; //s = s + " <span class=\"selected2\">尾页</span> "; } else { s = s + " <a href=\"" + base_url + (cp + 1) + end_url + "\">下一页</a> "; s = s + " <a href=\"" + base_url + tp + end_url + "\">尾页</a> "; } pagecontrol_string = s; }
protected void Page_Load(object sender, EventArgs e) { //LoadUser(); if (Page.IsPostBack == false) { check ck = new check(); GetRequest GetRequest1 = new GetRequest(); sp = ck.CheckInput(GetRequest1.GetRequestQueryString("sp", "")); dp = ck.CheckInput(GetRequest1.GetRequestQueryString("dp", "")); cr = ck.CheckInput(GetRequest1.GetRequestQueryString("cr", "")); l = ck.CheckInput(GetRequest1.GetRequestQueryString("l", "")); p = ck.CheckInput(GetRequest1.GetRequestQueryString("p", "1")); order = ck.CheckInput(GetRequest1.GetRequestQueryString("order", "0")); top = ck.CheckInput(GetRequest1.GetRequestQueryString("top", "0")); u = ck.CheckInput(GetRequest1.GetRequestQueryString("u", "0")); ftype = ck.CheckInput(GetRequest1.GetRequestQueryString("ftype", "8")); LoadRecord(lblCurrentPage.Text); } }
protected void Page_Load(object sender, EventArgs e) { GetRequest GetRequest1 = new GetRequest(); check check1 = new check(); data_conn cn = new data_conn(); DataSet ds = new DataSet(); string u = "0"; u = check1.CheckNumber(GetRequest1.GetRequestQueryString("u", "0")); string sql = ""; sql = ""; sql += "SELECT * "; sql += "FROM TB_User "; sql += "WHERE (UserID = " + u + ") "; ds = cn.mdb_ds(sql, "user"); ltrRealname.Text = ds.Tables["user"].Rows[0]["realname"].ToString() + "(" + ds.Tables["user"].Rows[0]["companyname"].ToString() + ")"; sql = ""; sql += "SELECT COUNT(ID) AS c,MIN(postdatex) as mindate,MAX(postdatex) as maxdate "; sql += "FROM TB_YunJiaInfo "; sql += "WHERE (UserIDx = " + u + ") AND (yunjialeixingx = 8) "; ds = cn.mdb_ds(sql, "user0"); if (ds.Tables["user0"].Rows[0][0].ToString() != "0") { ltrFclTotal.Text = "整箱运价共 " + ds.Tables["user0"].Rows[0][0].ToString() + " 条(" + Convert.ToDateTime(ds.Tables["user0"].Rows[0][1].ToString()).ToShortDateString() + " 第一次发布," + Convert.ToDateTime(ds.Tables["user0"].Rows[0][2].ToString()).ToShortDateString() + " 最后一次发布),其中:"; } else { ltrFclTotal.Text = "整箱运价共 0 条"; phFclTotal.Visible = false; } sql = ""; sql += "SELECT TOP 10 hangxianmiaoshux, COUNT(hangxianmiaoshux) AS c "; sql += "FROM TB_YunJiaInfo "; sql += "WHERE (UserIDx = " + u + ") AND (yunjialeixingx = 8) "; sql += "GROUP BY hangxianmiaoshux "; sql += "ORDER BY c DESC "; ds = cn.mdb_ds(sql, "user1"); Repeater1.DataSource = ds.Tables["user1"].DefaultView; Repeater1.DataBind(); sql = ""; sql += "SELECT TOP 10 hangxianmiaoshux, shipcompany, COUNT(hangxianmiaoshux) AS c "; sql += "FROM TB_YunJiaInfo "; sql += "WHERE (UserIDx = " + u + ") AND (yunjialeixingx = 8) "; sql += "AND (shipcompany IS NOT NULL) AND (shipcompany <> '') "; sql += "GROUP BY hangxianmiaoshux, shipcompany "; sql += "ORDER BY c DESC "; ds = cn.mdb_ds(sql, "user1"); Repeater2.DataSource = ds.Tables["user1"].DefaultView; Repeater2.DataBind(); sql = ""; sql += "SELECT COUNT(ID) AS c,MIN(postdatex) as mindate,MAX(postdatex) as maxdate "; sql += "FROM TB_YunJiaInfo "; sql += "WHERE (UserIDx = " + u + ") AND (yunjialeixingx = 9) "; ds = cn.mdb_ds(sql, "user0"); if (ds.Tables["user0"].Rows[0][0].ToString() != "0") { ltrLclTotal.Text = "拼箱运价共 " + ds.Tables["user0"].Rows[0][0].ToString() + " 条(" + Convert.ToDateTime(ds.Tables["user0"].Rows[0][1].ToString()).ToShortDateString() + " 第一次发布," + Convert.ToDateTime(ds.Tables["user0"].Rows[0][2].ToString()).ToShortDateString() + " 最后一次发布),其中:"; } else { ltrLclTotal.Text = "拼箱运价共 0 条"; phLclTotal.Visible = false; } sql = ""; sql += "SELECT TOP 10 hangxianmiaoshux, COUNT(hangxianmiaoshux) AS c "; sql += "FROM TB_YunJiaInfo "; sql += "WHERE (UserIDx = " + u + ") AND (yunjialeixingx = 9) "; sql += "GROUP BY hangxianmiaoshux "; sql += "ORDER BY c DESC "; ds = cn.mdb_ds(sql, "user1"); Repeater3.DataSource = ds.Tables["user1"].DefaultView; Repeater3.DataBind(); sql = ""; sql += "SELECT TOP 10 hangxianmiaoshux, shipcompany, COUNT(hangxianmiaoshux) AS c "; sql += "FROM TB_YunJiaInfo "; sql += "WHERE (UserIDx = " + u + ") AND (yunjialeixingx = 9) "; sql += "AND (shipcompany IS NOT NULL) AND (shipcompany <> '') "; sql += "GROUP BY hangxianmiaoshux, shipcompany "; sql += "ORDER BY c DESC "; ds = cn.mdb_ds(sql, "user1"); Repeater4.DataSource = ds.Tables["user1"].DefaultView; Repeater4.DataBind(); sql = ""; sql += "SELECT COUNT(ID) AS c,MIN(postdatex) as mindate,MAX(postdatex) as maxdate "; sql += "FROM T_AIRPRICE "; sql += "WHERE (UserIDx = " + u + ") "; ds = cn.mdb_ds(sql, "user0"); if (ds.Tables["user0"].Rows[0][0].ToString() != "0") { ltrAirTotal.Text = "空运运价共 " + ds.Tables["user0"].Rows[0][0].ToString() + " 条(" + Convert.ToDateTime(ds.Tables["user0"].Rows[0][1].ToString()).ToShortDateString() + " 第一次发布," + Convert.ToDateTime(ds.Tables["user0"].Rows[0][2].ToString()).ToShortDateString() + " 最后一次发布),其中:"; } else { ltrAirTotal.Text = "空运运价共 0 条"; phAirTotal.Visible = false; } sql = ""; sql += "SELECT TOP 10 linex, COUNT(linex) AS c "; sql += "FROM T_AIRPRICE "; sql += "WHERE (UserIDx = " + u + ") "; sql += "GROUP BY linex "; sql += "ORDER BY c DESC "; ds = cn.mdb_ds(sql, "user1"); Repeater5.DataSource = ds.Tables["user1"].DefaultView; Repeater5.DataBind(); sql = ""; sql = "SELECT * FROM TB_USER WHERE userid = " + u + ""; ds = cn.mdb_ds(sql, "user1"); Literal2.Text = "<a href=\"/admin/freightlist.aspx\" target=\"_blank\">" + ds.Tables["user1"].Rows[0]["Login2_Adventage_Line_Adv"].ToString() + "</a>"; Literal10.Text = ds.Tables["user1"].Rows[0]["Login2_Adventage_Line2_Adv"].ToString(); }
protected void Page_Load(object sender, EventArgs e) { login login1 = new login(); login1.login(); check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); string p = ""; p = check1.CheckNumber(GetRequest1.GetRequestQueryString("p", "1")); string u = ""; u = check1.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = ""; sql = "SELECT UCenterHomeUid FROM TB_User WHERE userid = " + u; //Response.Write(sql); ds = cn.mdb_ds(sql, "tb_user"); string uid = "0"; uid = ds.Tables["tb_user"].Rows[0][0].ToString(); mysqldata_conn mysqlcn = new mysqldata_conn(); //以下为获得“我的好友” sql = "SELECT friendid FROM uc_friends WHERE uid = " + uid; ds = mysqlcn.mdb_ds(sql, "uc_friends"); //ltrMyFriendCount.Text = ds.Tables["uc_friends"].Rows.Count.ToString(); string uidlist = ""; for (int i = 0; i < ds.Tables["uc_friends"].Rows.Count; i++) { if (uid != "") { uidlist += ds.Tables["uc_friends"].Rows[i][0].ToString() + ","; } } uidlist += "0"; sql = "SELECT * FROM TB_User WHERE UCenterHomeUid in (" + uidlist + ") ORDER BY USERID"; ds = cn.mdb_ds(sql, "myfriends"); int item = 0; item = (Convert.ToInt32(p) - 1) * 10; sql = "SELECT TOP 10 * "; sql += "FROM (SELECT * FROM V_REPASTE_INDEX) AS T WHERE uhomeid2 in (" + uidlist + ") AND rid NOT IN "; sql += "(SELECT TOP " + item.ToString() + " rid FROM V_REPASTE_INDEX WHERE uhomeid2 in (" + uidlist + ") ORDER BY rid DESC) ORDER BY rid DESC"; //Response.Write(sql); ds = cn.mdb_ds(sql, "repaste"); Repeater1.DataSource = ds.Tables["repaste"].DefaultView; Repeater1.DataBind(); sql = "SELECT rid as c FROM V_REPASTE_INDEX WHERE uhomeid2 in (" + uidlist + ")"; ds = cn.mdb_ds(sql, "repaste"); string base_url = "friend.aspx?p="; string end_url = ""; int cp = Convert.ToInt32(p); int tp = 1; int count = 0; count = ds.Tables["repaste"].Rows.Count; if (count % 10 > 0 || count == 0) { tp = count / 10 + 1; } else { tp = count / 10; } string s = ""; if (cp == 1) { //s = s + " <span class=\"selected2\">首页</span> "; //s = s + " <span class=\"selected2\">上一页</span> "; s = s + " <span class=\"selected2\">1</span> "; for (int i = 2; i <= (tp < 10 ? tp : 10); i++) { s = s + " <a href=\"" + base_url + "" + i + end_url + "\"><span>" + i + "</span></a> "; } } else { s = s + " <a href=\"" + base_url + "1" + end_url + "\"><span>首页</span></a> "; s = s + " <a href=\"" + base_url + (cp - 1) + end_url + "\"><span>上一页</span></a> "; for (int i = (cp <= 5 ? 1 : (tp - cp < 5 ? (tp - 9 < 1 ? 1 : tp - 9) : cp - 4)); i <= cp - 1; i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } s = s + " <span class=\"selected2\">" + cp + "</span> "; for (int i = cp + 1; i <= (cp + 5 >= tp ? tp : (cp <= 5 ? (tp >= 10 ? 10 : tp) : cp + 5)); i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } } if (cp == tp) { //s = s + " <span class=\"selected2\">下一页</span> "; //s = s + " <span class=\"selected2\">尾页</span> "; } else { s = s + " <a href=\"" + base_url + (cp + 1) + end_url + "\">下一页</a> "; s = s + " <a href=\"" + base_url + tp + end_url + "\">尾页</a> "; } pagecontrol_string = s; }
protected void Page_Load(object sender, EventArgs e) { login login1 = new login(); login1.login(); check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); string p = ""; p = check1.CheckNumber(GetRequest1.GetRequestQueryString("p", "1")); string u = ""; u = check1.CheckNumber(GetRequest1.GetRequestQueryString("uid", "0")); int item = 0; item = (Convert.ToInt32(p) - 1) * 10; data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = ""; sql += "SELECT TOP 10 * "; sql += "FROM (SELECT * FROM V_REPASTE_INDEX WHERE userid2 = " + u + ") AS T WHERE rid NOT IN "; sql += "(SELECT TOP " + item.ToString() + " rid FROM V_REPASTE_INDEX WHERE userid2 = " + u + " ORDER BY rid DESC) ORDER BY rid DESC"; ds = cn.mdb_ds(sql, "repaste"); Repeater1.DataSource = ds.Tables["repaste"].DefaultView; Repeater1.DataBind(); sql = "SELECT rid as c FROM V_REPASTE_INDEX WHERE userid2 = " + u; ds = cn.mdb_ds(sql, "repaste"); string base_url = "other.aspx?uid=" + u + "&p="; string end_url = ""; int cp = Convert.ToInt32(p); int tp = 1; int count = 0; count = ds.Tables["repaste"].Rows.Count; if (count % 10 > 0 || count == 0) { tp = count / 10 + 1; } else { tp = count / 10; } string s = ""; if (cp == 1) { //s = s + " <span class=\"selected2\">首页</span> "; //s = s + " <span class=\"selected2\">上一页</span> "; s = s + " <span class=\"selected2\">1</span> "; for (int i = 2; i <= (tp < 10 ? tp : 10); i++) { s = s + " <a href=\"" + base_url + "" + i + end_url + "\"><span>" + i + "</span></a> "; } } else { s = s + " <a href=\"" + base_url + "1" + end_url + "\"><span>首页</span></a> "; s = s + " <a href=\"" + base_url + (cp - 1) + end_url + "\"><span>上一页</span></a> "; for (int i = (cp <= 5 ? 1 : (tp - cp < 5 ? (tp - 9 < 1 ? 1 : tp - 9) : cp - 4)); i <= cp - 1; i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } s = s + " <span class=\"selected2\">" + cp + "</span> "; for (int i = cp + 1; i <= (cp + 5 >= tp ? tp : (cp <= 5 ? (tp >= 10 ? 10 : tp) : cp + 5)); i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } } if (cp == tp) { //s = s + " <span class=\"selected2\">下一页</span> "; //s = s + " <span class=\"selected2\">尾页</span> "; } else { s = s + " <a href=\"" + base_url + (cp + 1) + end_url + "\">下一页</a> "; s = s + " <a href=\"" + base_url + tp + end_url + "\">尾页</a> "; } pagecontrol_string = s; string[] udetail; AllinUser AllinUser1 = new AllinUser(); udetail = AllinUser1.GetUserDetail(u); Literal1.Text = udetail[3]; }
public void LoadSavedOrder() { check ck = new check(); data_conn cn = new data_conn(); DataSet ds = new DataSet(); GetRequest GetRequest1 = new GetRequest(); string u = ck.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); string orderid = ck.CheckInput(GetRequest1.GetRequestQueryString("orderid", "0")); string role = GetRequest1.GetRequestQueryString("role", ""); AllinOrder AllinOrder1 = new AllinOrder(); string[] odetail; odetail = AllinOrder1.GetOrderDetail(orderid); ltrOrderViewCode.Text = odetail[0]; ltrOrderViewShipper.Text = odetail[8]; ltrOrderViewConsignee.Text = odetail[9]; ltrOrderViewNotifyParty.Text = odetail[10]; ltrOrderViewCompanyName.Text = odetail[11]; ltrOrderViewEmail.Text = odetail[12]; ltrOrderViewContactor.Text = odetail[13]; ltrOrderViewMobile.Text = odetail[14]; ltrOrderViewTel.Text = odetail[15]; ltrOrderViewFax.Text = odetail[16]; ltrOrderViewStartport.Text = odetail[17]; ltrOrderViewMidport.Text = odetail[18]; ltrOrderViewDestport.Text = odetail[19]; ltrOrderViewMarksNumbers.Text = odetail[20]; ltrOrderViewNumbersofPackages.Text = odetail[21]; ltrOrderViewDescription.Text = odetail[22]; ltrOrderViewGrossWeight.Text = odetail[23]; ltrOrderViewMeasurement.Text = odetail[24]; ltrOrderViewCarrier.Text = odetail[26]; ltrOrderViewKaihangri.Text = odetail[27]; ltrOrderViewZhuangxiangri.Text = odetail[28]; ltrOrderViewJieguanri.Text = odetail[29]; ltrOrderViewGP.Text = odetail[34]; ltrFreightGP.Text = odetail[49]; ltrFreightGPV.Text = odetail[50]; ltrFreightAppend.Text = odetail[44]; ltrFreightCarrier.Text = odetail[68]; ltrOrderViewHyf.Text = odetail[59]; ltrOrderViewBeizhu.Text = odetail[36]; ltrOverageThis.Text = odetail[62]; txt_edit_pricegp.Text = odetail[49]; txt_edit_pricegpv.Text = odetail[50]; txt_edit_price_shipcompany.Text = odetail[68]; if (odetail[44] != "") { ltrOrderFujiafei.Text = "(附加费:" + odetail[44] + ")"; } SetStep(odetail[1], odetail[37], odetail[38]); if (u != odetail[3] & u != odetail[4]) { Response.Redirect("/search/err.aspx"); }//不是买卖双方的用户无法查看该订单! string order_type_string = odetail[58]; if (role == "shipper") { PlaceHolder3.Visible = true; ltrOrderStatus.Text = "<div style=\"padding:20px; margin-bottom:10px; font-size:14px; line-height:30px; text-align:left; background:#FFFCF3;border:1px solid #F7E4A5;\">" + odetail[89].Replace("{1}", orderid).Replace("{9}", order_type_string) + "</div>"; if (u != odetail[3]) { Response.Redirect("/search/err.aspx"); }//不是买卖双方的用户无法查看该订单! }//订舱方显示的文本 if (role == "forward") { PlaceHolder4.Visible = true; ltrOrderStatus.Text = "<div style=\"padding:20px; margin-bottom:10px; font-size:14px; line-height:30px; text-align:left; background:#FFFCF3;border:1px solid #F7E4A5;\">" + odetail[90].Replace("{1}", orderid).Replace("{9}", order_type_string) + "</div>"; if (u != odetail[4]) { Response.Redirect("/search/err.aspx"); }//不是买卖双方的用户无法查看该订单! if (odetail[1] != "2") { phEditDisabled.Visible = true; phEditEnabled.Visible = false; } else { phEditDisabled.Visible = false; phEditEnabled.Visible = true; } }//承运方显示的文本 if (odetail[1] != "2") { PlaceHolder2.Visible = false; PlaceHolder1.Visible = false; } ltrSMS.Text = "<a href=\"/member/pm_detail.aspx?cid=" + odetail[4] + "\" id=\"linkSMS\" target=\"_blank\"></a>"; AllinFreight AllinFreight1 = new AllinFreight(); string[] fdetail; if (odetail[7] == "0") { fdetail = AllinFreight1.GetFreightDetail("9", ck.CheckNumber(odetail[6]), "0"); } else { fdetail = AllinFreight1.GetFreightDetail("9", "0", ck.CheckNumber(odetail[7])); } ltrEndDate.Text = Convert.ToDateTime(fdetail[6]).ToString("yyyy-MM-dd"); ltrFreightTitle.Text = "<span style=\"font-weight:bold;font-size:14px\">" + odetail[75] + "</span>"; ltrFreightPostdate.Text = Convert.ToDateTime(odetail[65]).ToString("MM") + "/" + Convert.ToDateTime(odetail[65]).ToString("dd"); ltrFreightEnddate.Text = Convert.ToDateTime(odetail[66]).ToString("MM") + "/" + Convert.ToDateTime(odetail[66]).ToString("dd"); ltrFreightCompany.Text = fdetail[18]; ltrFreightAllinStar.Text = fdetail[19]; ltrFreightUserStar.Text = fdetail[20]; ltrFreightLine.Text = odetail[69]; ltrFreightStartport.Text = odetail[70]; ltrFreightDestport.Text = odetail[71]; ltrFreightAssuranceSpace.Text = odetail[100]; ltrFreightAssurancePrice.Text = odetail[101]; lblTousu.Text = fdetail[18]; AllinUser AllinUser1 = new AllinUser(); string[] udetail; udetail = AllinUser1.GetUserDetail(u); txtbank.Value = udetail[50]; txtbankname.Value = udetail[51]; txtbankaccount.Value = udetail[52]; txtotheraccount.Value = udetail[53]; ltrOverageTotal.Text = udetail[55]; ltrOverageAvailable.Text = (Convert.ToInt32(ltrOverageTotal.Text) - Convert.ToInt32(ltrOverageThis.Text)).ToString(); ltrPayJump.Text = "<a href=\"/member/order/pay_sel_single.aspx?orderid=" + orderid + "\">立即充值</a>"; //if (Convert.ToInt32(ltrOverageTotal.Text) - Convert.ToInt32(ltrOverageThis.Text) >= 0) //{ // PlaceHolder8.Visible = true; // PlaceHolder9.Visible = false; // PlaceHolder10.Visible = true; // PlaceHolder11.Visible = false; //} //else //{ // PlaceHolder8.Visible = false; // PlaceHolder9.Visible = true; // PlaceHolder10.Visible = false; // PlaceHolder11.Visible = true; //} PlaceHolder8.Visible = true; PlaceHolder9.Visible = false; PlaceHolder10.Visible = true; PlaceHolder11.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { txt_lstartport.Attributes.Add("onkeyup", "autowords(this.id,event);"); txt_lstartport.Attributes.Add("onkeydown", "if(event.keyCode==13){return false;}"); for (int i = 0; i < rbl_lftype.Items.Count; i++) { rbl_lftype.Items[i].Attributes.Add("onclick", "selectftype();"); } rbl_line2.Attributes.Add("style", "display:none;"); check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); p = check1.CheckNumber(GetRequest1.GetRequestQueryString("p", "1")); ltype = check1.CheckInput(GetRequest1.GetRequestQueryString("ltype", "")); ltime1 = check1.CheckInput(GetRequest1.GetRequestQueryString("ltime1", "")); ltime2 = check1.CheckInput(GetRequest1.GetRequestQueryString("ltime2", "")); lftype = check1.CheckInput(GetRequest1.GetRequestQueryString("lftype", "")); startport = check1.CheckInput(GetRequest1.GetRequestQueryString("startport", "")); line = check1.CheckInput(GetRequest1.GetRequestQueryString("line", "")); lhidden = check1.CheckInput(GetRequest1.GetRequestQueryString("lhidden", "")); rbl_ltype.SelectedValue = Server.UrlDecode(ltype); txtDate1.Text = Server.UrlDecode(ltime1); txtDate2.Text = Server.UrlDecode(ltime2); rbl_lftype.SelectedValue = Server.UrlDecode(lftype); txt_lstartport.Text = Server.UrlDecode(startport); if (lftype == "10") { rbl_line2.SelectedValue = line; rbl_line2.Attributes.Remove("style"); rbl_line1.Attributes.Add("style", "display:none;"); } else { rbl_line1.SelectedValue = line; } rbl_hidden.SelectedValue = Server.UrlDecode(lhidden); LoadRecord(p); } }
public void LoadEditOrder() { check ck = new check(); data_conn cn = new data_conn(); DataSet ds = new DataSet(); GetRequest GetRequest1 = new GetRequest(); string u = ck.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); string orderid = ck.CheckInput(GetRequest1.GetRequestQueryString("orderid", "0")); string role = GetRequest1.GetRequestQueryString("role", ""); AllinOrder AllinOrder1 = new AllinOrder(); string[] odetail; odetail = AllinOrder1.GetOrderDetail(orderid); ltrHyf.Text = odetail[59]; txtPubf.Text = odetail[4]; txtCode.Value = odetail[0]; txtShipper.Value = odetail[8]; txtConsignee.Value = odetail[9]; txtNotifyParty.Value = odetail[10]; txtCompanyName.Value = odetail[11]; txtEmail.Value = odetail[12]; txtContactor.Value = odetail[13]; txtMobile.Value = odetail[14]; txtTel.Value = odetail[15]; txtFax.Value = odetail[16]; txtstartport.Value = odetail[17]; txtmidport.Value = odetail[18]; txtdestport.Value = odetail[19]; txtMarksNumbers.Value = odetail[20]; txtNumbersofPackages.Value = odetail[21]; txtDescription.Value = odetail[22]; txtGrossWeight.Value = odetail[23]; txtMeasurement.Value = odetail[24]; txtkaihangri.Value = odetail[27]; txtzhuangxiangri.Value = odetail[28]; txtjieguanri.Value = odetail[29]; ltrEndDate.Text = odetail[105]; txtcarrier_name.Value = odetail[26]; ltrFreightTitle.Text = "<span style=\"font-weight:bold;font-size:14px\">" + odetail[75] + "</span>"; txtgp.Value = odetail[34]; if (odetail[44] != "") { ltrOrderFujiafei1.Text = "(附加费:" + odetail[44] + ")"; } ltrFreightGP.Text = odetail[49]; ltrFreightGPV.Text = odetail[50]; ltrFreightAppend.Text = odetail[44]; ltrFreightCarrier.Text = odetail[68]; txtbeizhu.Value = odetail[36]; SetStep(odetail[1], odetail[37], odetail[38]); ltrSMS.Text = "<a href=\"/member/pm_detail.aspx?cid=" + odetail[4] + "\" id=\"linkSMS\" target=\"_blank\"></a>"; if (u != odetail[3]) { Response.Redirect("/search/err.aspx"); }//不是买方的用户无修改订单! if (odetail[1] != "2" & odetail[1] != "3" & odetail[1] != "7") { Response.Redirect("/search/err.aspx"); }//排除不能修改的订单状态! ltrOrderStatus.Text = "<div style=\"padding:20px; margin-bottom:10px; font-size:14px; line-height:30px; text-align:center; background:#FFFCF3;border:1px solid #F7E4A5;\">修改订舱单</div>"; AllinFreight AllinFreight1 = new AllinFreight(); string[] fdetail; if (odetail[7] == "0") { fdetail = AllinFreight1.GetFreightDetail("9", ck.CheckNumber(odetail[6]), "0"); } else { fdetail = AllinFreight1.GetFreightDetail("9", "0", ck.CheckNumber(odetail[7])); } ltrEndDate.Text = Convert.ToDateTime(fdetail[6]).ToString("yyyy-MM-dd"); ltrFreightTitle.Text = "<span style=\"font-weight:bold;font-size:14px\">" + odetail[75] + "</span>"; ltrFreightPostdate.Text = Convert.ToDateTime(odetail[65]).ToString("MM") + "/" + Convert.ToDateTime(odetail[65]).ToString("dd"); ltrFreightEnddate.Text = Convert.ToDateTime(odetail[66]).ToString("MM") + "/" + Convert.ToDateTime(odetail[66]).ToString("dd"); ltrFreightCompany.Text = fdetail[18]; ltrFreightAllinStar.Text = fdetail[19]; ltrFreightUserStar.Text = fdetail[20]; ltrFreightLine.Text = odetail[69]; ltrFreightStartport.Text = odetail[70]; ltrFreightDestport.Text = odetail[71]; ltrFreightAssuranceSpace.Text = odetail[100]; ltrFreightAssurancePrice.Text = odetail[101]; lblTousu.Text = fdetail[18]; AllinUser AllinUser1 = new AllinUser(); string[] udetail; udetail = AllinUser1.GetUserDetail(u); txtbank.Value = udetail[50]; txtbankname.Value = udetail[51]; txtbankaccount.Value = udetail[52]; txtotheraccount.Value = udetail[53]; txtaliaccount.Value = udetail[9]; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //txt_realname.Attributes.Add("onkeyup", "autowords(this.id,event);"); //txt_realname.Attributes.Add("onkeydown", "if(event.keyCode==13){return false;}"); check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); p = check1.CheckNumber(GetRequest1.GetRequestQueryString("p", "1")); ltime1 = check1.CheckInput(GetRequest1.GetRequestQueryString("ltime1", "")); ltime2 = check1.CheckInput(GetRequest1.GetRequestQueryString("ltime2", "")); realname = check1.CheckInput(GetRequest1.GetRequestQueryString("realname", "")); companyname = check1.CheckInput(GetRequest1.GetRequestQueryString("companyname", "")); txtDate1.Text = Server.UrlDecode(ltime1); txtDate2.Text = Server.UrlDecode(ltime2); txt_realname.Text = Server.UrlDecode(realname); txt_companyname.Text = Server.UrlDecode(companyname); LoadRecord(p); } }
protected void Page_Load(object sender, EventArgs e) { login login1 = new login(); login1.login(); check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); string p = ""; p = check1.CheckNumber(GetRequest1.GetRequestQueryString("p", "1")); string u = ""; u = check1.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); string tip = ""; tip = GetRequest1.GetRequestQueryString("tip", "0"); if (tip == "delete") { Literal1.Text = "<div class=\"main2box_notice\" id=\"main2box_notice\"><img src=\"images/LedIcon_001.GIF\"> 转帖删除成功</div>"; Literal1.Text = Literal1.Text + "<script>function hidetip(){document.getElementById(\"main2box_notice\").style.display = \"none\"};setTimeout(\"hidetip()\",\"2000\");</script>"; } int item = 0; item = (Convert.ToInt32(p) - 1) * 10; data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = ""; sql += "SELECT TOP 10 * "; sql += "FROM (SELECT * FROM V_REPASTE_INDEX WHERE userid2 = " + u + ") AS T WHERE rid NOT IN "; sql += "(SELECT TOP " + item.ToString() + " rid FROM V_REPASTE_INDEX WHERE userid2 = " + u + " ORDER BY rid DESC) ORDER BY rid DESC"; ds = cn.mdb_ds(sql, "repaste"); Repeater1.DataSource = ds.Tables["repaste"].DefaultView; Repeater1.DataBind(); sql = "SELECT rid as c FROM V_REPASTE_INDEX WHERE userid2 = " + u; ds = cn.mdb_ds(sql, "repaste"); string base_url = "index.aspx?p="; string end_url = ""; int cp = Convert.ToInt32(p); int tp = 1; int count = 0; count = ds.Tables["repaste"].Rows.Count; if (count % 10 > 0 || count == 0) { tp = count / 10 + 1; } else { tp = count / 10; } string s = ""; if (cp == 1) { //s = s + " <span class=\"selected2\">首页</span> "; //s = s + " <span class=\"selected2\">上一页</span> "; s = s + " <span class=\"selected2\">1</span> "; for (int i = 2; i <= (tp < 10 ? tp : 10); i++) { s = s + " <a href=\"" + base_url + "" + i + end_url + "\"><span>" + i + "</span></a> "; } } else { s = s + " <a href=\"" + base_url + "1" + end_url + "\"><span>首页</span></a> "; s = s + " <a href=\"" + base_url + (cp - 1) + end_url + "\"><span>上一页</span></a> "; for (int i = (cp <= 5 ? 1 : (tp - cp < 5 ? (tp - 9 < 1 ? 1 : tp - 9) : cp - 4)); i <= cp - 1; i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } s = s + " <span class=\"selected2\">" + cp + "</span> "; for (int i = cp + 1; i <= (cp + 5 >= tp ? tp : (cp <= 5 ? (tp >= 10 ? 10 : tp) : cp + 5)); i++) { s = s + " <a href=\"" + base_url + i + end_url + "\"><span>" + i + "</span></a> "; } } if (cp == tp) { //s = s + " <span class=\"selected2\">下一页</span> "; //s = s + " <span class=\"selected2\">尾页</span> "; } else { s = s + " <a href=\"" + base_url + (cp + 1) + end_url + "\">下一页</a> "; s = s + " <a href=\"" + base_url + tp + end_url + "\">尾页</a> "; } pagecontrol_string = s; }
protected void Button1_Click(object sender, EventArgs e) { if (txtkey.Value != "") { data_conn cn = new data_conn(); cn.mdb_exe("search_ports '" + txtkey.Value + "'"); GetRequest g = new GetRequest(); Response.Redirect("/ports/list-" + txtkey.Value + "-" + g.GetRequestQueryString("", "") + "------1.html"); } else { Response.Redirect("/ports/"); } }