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