public DataSet trun(string id) { DataSet ds; string strSQL; strSQL = "select * from TB_YunJia where id=" + id; data_conn3 tt=new data_conn3 (); ds = tt.mdb_ds(strSQL, "asdf"); return ds; }
protected void Button1_Click1(object sender, EventArgs e) { check ck = new check(); if (TextBox1.Text == "") { MessageBox("", "标题不能为空"); } else if( txtenddate.Value == "") { MessageBox("", "有效日期不能为空"); } else if(ddlhangxianmiaoshu.Text == "请选择") { MessageBox("", "请选择航线"); } else if (txtStartPost.Text == "") { MessageBox("", "启运港不能为空"); } else if (ck.CheckNumber1(this.txthit.Text) == "-1") { MessageBox("", "点击量不是数字"); } else { string strSql; string meno = ck.CheckInput(txtmemo.Text); meno = meno.Replace("\r", "<br>"); meno = meno.Replace(" ", " "); data_conn3 data_conn = new data_conn3(); System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(); conn = data_conn.mdb_conn(); conn.Open(); string time = txtpostdate.Value + " " + TextBox13.Text; strSql = "update TB_YunJia set title='" + ck.CheckInput(TextBox1.Text.Replace("'", "''")) + "',enddate='" + ck.CheckInput(txtenddate.Value.Replace("'", "''")) + "',StartPort='" + ck.CheckInput(txtStartPost.Text.Replace("'", "''")) + "',hangxianmiaoshu='" + ck.CheckInput(ddlhangxianmiaoshu.Text.Replace("'", "''")) + "',memo='" + meno.Replace("'", "''") + "',PostDate='" + time.Replace("'", "''") + "',hits=" + this.txthit.Text + ",UserID2=" + this.Hidden1.Value + " where id=" + ck.CheckNumber(Request["id"]); System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand(strSql, conn); myCommand.ExecuteNonQuery(); //lblPostDate.Text = DateTime.Now.ToString(); conn.Close(); this.Response.Redirect("lcllist.aspx"); } }
public void updatePostDate() { string strSql; check ck = new check(); data_conn3 data_conn = new data_conn3 (); string time = txtpostdate.Value + " " + TextBox16.Text; System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(); conn = data_conn.mdb_conn(); conn.Open(); strSql = "update T_AIRINFO set PostDate='" + time + "' where id=" + ck.CheckNumber(Request["id"]); System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand(strSql, conn); myCommand.ExecuteNonQuery(); conn.Close(); //lblPostDate.Text = DateTime.Now.ToString(); }
public static long CheckMudiGang(string word) { data_conn3 cn = new data_conn3(); SqlConnection conn = cn.mdb_conn(); conn.Open(); SqlCommand cmd = new SqlCommand("select gangkou_id from V_GangkouSearch where mingcheng = @mingcheng", conn); cmd.Parameters.AddWithValue("mingcheng", word); object gangkouId = cmd.ExecuteScalar(); conn.Close(); if (gangkouId == null) { return -1; } return (long)gangkouId; }
protected string ExecoutID(string cmdtext,SqlParameter[] paras) { SqlCommand cmd=new SqlCommand (); data_conn3 data_conn = new data_conn3(); SqlConnection conn = new SqlConnection(); conn = data_conn.mdb_conn(); conn.Open(); cmd.Connection = conn; cmd.CommandText = cmdtext; cmd.CommandType = System.Data.CommandType.StoredProcedure; string newid = String.Empty; if (paras.Length > 0) { for (int i = 0; i < paras.Length; i++) { cmd.Parameters.Add(paras[i]); } } cmd.ExecuteNonQuery(); if (paras.Length > 0) { for (int i = 0; i < paras.Length; i++) { if (paras[i].Direction == ParameterDirection.Output) { newid = Convert.ToString(paras[i].Value); } } } conn.Close(); return newid; }
protected void Button1_Click(object sender, EventArgs e) { if (WordsIScn(hidsubmit.Value) || WordsIScn(txtTitle.Text) || WordsIScn(txtStart.Text) || WordsIScn(txtRemark.Value)) { MessageBox("", "发布英文运价时,除了标题备注,不能出现中文"); return; } if (hidsubmit.Value == "") { MessageBox("", "目的港不能为0个"); return; } if (hidsubmit.Value.Replace("qwerhjkl", "").Replace("sdfgyuio", "").Replace("0", "").Replace("1", "") == "") { MessageBox("", "目的港不能为0个"); return; } string[] strsubmitrow = Regex.Split(hidsubmit.Value, "sdfgyuio", new RegexOptions()); for (int k = 0; k < strsubmitrow.Length - 1; k++) { if (strsubmitrow[k].Substring(0, 8) == "qwerhjkl" && (strsubmitrow[k] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl" && strsubmitrow[k] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl")) { MessageBox("", "第" + Convert.ToString(k + 1) + "行的目的港不能为空"); return; } string[] strrow = Regex.Split(strsubmitrow[k], "qwerhjkl", new RegexOptions()); if (strrow[8] == "" && (strsubmitrow[k] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl" && strsubmitrow[k] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl")) { MessageBox("", "第" + Convert.ToString(k + 1) + "行的船公司不能为空"); return; } } if (txtTitle.Text == "") { MessageBox("", "标题不能为空"); } else if (BasicDatePicker1_TextBox.Value == "") { MessageBox("", "有效日期不能为空"); } else if (txtStart.Text == "") { MessageBox("", "启运港不能为空"); } else if (DropDownList1.SelectedValue == "") { MessageBox("", "请选择航线"); } else { //try //{ string text = txtRemark.Value; text = text.Replace("\n", "<br>"); text = text.Replace(" ", " "); SqlParameter[] paras = new SqlParameter[29]; paras[0] = new SqlParameter("@UserID", SqlDbType.Int); paras[0].Value = check.CheckNumber(Request.Cookies["user_id"].Value.ToString()); paras[1] = new SqlParameter("@title", SqlDbType.NVarChar, 50); paras[1].Value = check.CheckInput(txtTitle.Text); paras[2] = new SqlParameter("@PostDate", SqlDbType.SmallDateTime); paras[2].Value = DateTime.Now.ToString(); paras[3] = new SqlParameter("@enddate", SqlDbType.SmallDateTime); paras[3].Value = check.CheckInput(BasicDatePicker1_TextBox.Value); paras[4] = new SqlParameter("@yunjialeixing", SqlDbType.Int); paras[4].Value = 8; paras[5] = new SqlParameter("@hangxianmiaoshu", SqlDbType.NVarChar, 255); paras[5].Value = check.CheckInput(DropDownList1.SelectedValue); paras[6] = new SqlParameter("@StartPort", SqlDbType.NVarChar, 50); paras[6].Value = check.CheckInput(txtStart.Text.Replace("'", "''")); paras[7] = new SqlParameter("@DestPort", SqlDbType.NVarChar); paras[7].Value = ""; paras[8] = new SqlParameter("@zhuangxiangchangdi", SqlDbType.NVarChar); paras[8].Value = ""; paras[9] = new SqlParameter("@baozhuangyaoqiu", SqlDbType.NVarChar); paras[9].Value = ""; paras[10] = new SqlParameter("@PriceDesc", SqlDbType.NText); paras[10].Value = ""; paras[11] = new SqlParameter("@memo", SqlDbType.NText); paras[11].Value = text.Replace("'", "''"); paras[12] = new SqlParameter("@fujiandizhi", SqlDbType.NVarChar); paras[12].Value = ""; paras[13] = new SqlParameter("@ifpass", SqlDbType.Int); paras[13].Value = 0; paras[14] = new SqlParameter("@hits", SqlDbType.Int); paras[14].Value = 0; paras[15] = new SqlParameter("@OnTop", SqlDbType.Int); paras[15].Value = 0; paras[16] = new SqlParameter("@supportspecial", SqlDbType.Bit); paras[16].Value = false; paras[17] = new SqlParameter("@specialdesc", SqlDbType.NVarChar); paras[17].Value = ""; paras[18] = new SqlParameter("@CompanyName", SqlDbType.NVarChar); paras[18].Value = ""; paras[19] = new SqlParameter("@CompanyAddr", SqlDbType.NVarChar); paras[19].Value = ""; paras[20] = new SqlParameter("@CompanyPhone", SqlDbType.NVarChar); paras[20].Value = ""; paras[21] = new SqlParameter("@CompanyFax", SqlDbType.NVarChar); paras[21].Value = ""; paras[22] = new SqlParameter("@CommuPerson", SqlDbType.NVarChar); paras[22].Value = ""; paras[23] = new SqlParameter("@email", SqlDbType.NVarChar); paras[23].Value = ""; paras[24] = new SqlParameter("@mobile", SqlDbType.NVarChar); paras[24].Value = ""; paras[25] = new SqlParameter("@entitle", SqlDbType.NVarChar, 200); paras[25].Value = check.CheckInput(txtTitle.Text); paras[26] = new SqlParameter("@enmemo", SqlDbType.NText); paras[26].Value = check.CheckInput(txtRemark.Value); paras[27] = new SqlParameter("@ifen", SqlDbType.Int); paras[27].Value = 1; paras[28] = new SqlParameter("@id", SqlDbType.Int); paras[28].Direction = ParameterDirection.Output; int id = Convert.ToInt32(ExecoutID("UP_brand_add", paras)); string strsubmit = hidsubmit.Value; string[] strarray = Regex.Split(strsubmit, "sdfgyuio", new RegexOptions()); int i; data_conn3 data_conn = new data_conn3(); SqlConnection conn = new SqlConnection(); conn = data_conn.mdb_conn(); conn.Open(); string value; string strSQL = ""; string[] strrow = new string[strarray.Length]; for (i = 0; i < strarray.Length - 1; i++) { if (strarray[i] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl" && strarray[i] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl") { strrow = Regex.Split(strarray[i], "qwerhjkl", RegexOptions.IgnoreCase); value = check.CheckNumber(id.ToString()) + ",'" + check.CheckInput(strrow[0]) + "','" + check.CheckInput(strrow[1]) + "','" + check.CheckInput(strrow[2]) + "','" + check.CheckInput(strrow[3]) + "','" + check.CheckInput(strrow[4]) + "','" + check.CheckInput(strrow[5]) + "','" + check.CheckInput(strrow[6]) + "','" + check.CheckInput(strrow[7]) + "','" + check.CheckInput(strrow[8]) + "','" + check.CheckInput(strrow[9]) + "','" + check.CheckInput(txtTitle.Text) + "','" + check.CheckInput(txtStart.Text) + "','" + DateTime.Now + "','" + check.CheckInput(BasicDatePicker1_TextBox.Value) + "',8,'" + check.CheckInput(DropDownList1.SelectedValue) + "'," + check.CheckNumber(Request.Cookies["user_id"].Value.ToString()) + ",'" + check.CheckInput(txtTitle.Text) + "',1"; strSQL += "insert into TB_YunJiaInfo (YunJiaID,DestPort,price20gp,price40gp,price40hq,price45hq,price20gpAppend,Distance,DepartureWkd,shipcompany,memo,Titlex,StartPortx,PostDatex,enddatex,yunjialeixingx,hangxianmiaoshux,UserIDx,entitlex,ifEnx) values (" + value + ");"; } } strSQL += "update TB_YunJia set DestPort1='" + check.CheckInput(strrow[0]) + "',price20gp1='" + check.CheckInput(strrow[1]) + "',price40gp1='" + check.CheckInput(strrow[2]) + "',price40hq1='" + check.CheckInput(strrow[3]) + "',price45hq1='" + check.CheckInput(strrow[4]) + "',shipcompany1='" + check.CheckInput(strrow[8]) + "' where id=" + id.ToString() + ";"; strSQL += "UPDATE TB_PRICECOUNT SET TB_PRICECOUNT.fclcount = (SELECT COUNT(tb_yunjia.id) AS yunjiacount FROM tb_yunjia,tb_yunjiainfo WHERE (tb_yunjia.yunjialeixing = 8) AND tb_yunjia.id = tb_yunjiainfo.yunjiaid),TB_PRICECOUNT.countdate = getdate() where TB_PRICECOUNT.cid = 1;"; SqlCommand myCommand1 = new SqlCommand(strSQL, conn); myCommand1.ExecuteNonQuery(); conn.Close(); topnew tp = new topnew(); tp.SetTopNew(id.ToString(), check.CheckInput(txtTitle.Text), DateTime.Now.ToString(), "8", check.CheckInput(DropDownList1.SelectedValue), check.CheckInput(txtStart.Text.Replace("'", "''")), check.CheckNumber(Request.Cookies["user_id"].Value.ToString())); Response.Redirect("office_fcl_list.aspx"); } }
protected void Button1_Click(object sender, EventArgs e) { if (hidsubmit.Value == "") { MessageBox("", "目的港不能为0个"); return; } if (hidsubmit.Value.Replace("qwerhjkl", "").Replace("sdfgyuio", "").Replace("0", "").Replace("1", "") == "") { MessageBox("", "目的港不能为0个"); return; } string[] strsubmitrow = Regex.Split(hidsubmit.Value, "sdfgyuio", new RegexOptions()); for (int k = 0; k < strsubmitrow.Length - 1; k++) { if (strsubmitrow[k].Substring(0, 8) == "qwerhjkl" && strsubmitrow[k] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl") { MessageBox("", "第" + Convert.ToString(k + 1) + "行的目的港不能为空"); return; } } if (txtTitle.Text == "") { MessageBox("", "标题不能为空"); } else if (BasicDatePicker1_TextBox.Value == "") { MessageBox("", "有效日期不能为空"); } else if (txtStart.Text == "") { MessageBox("", "启运港不能为空"); } else if (DropDownList1.Text == "请选择") { MessageBox("", "请选择航线"); } else { //try //{ string text = txtRemark.Value; text = text.Replace("\n", "<br>"); text = text.Replace(" ", " "); SqlParameter[] paras = new SqlParameter[21]; paras[0] = new SqlParameter("@PostDate", SqlDbType.SmallDateTime); paras[0].Value = DateTime.Now.ToString(); paras[1] = new SqlParameter("@DestPort", SqlDbType.NVarChar); paras[1].Value = ""; paras[2] = new SqlParameter("@StartPort", SqlDbType.NVarChar); paras[2].Value = check.CheckInput(txtStart.Text); paras[3] = new SqlParameter("@enddate", SqlDbType.NVarChar); paras[3].Value = check.CheckInput(BasicDatePicker1_TextBox.Value); paras[4] = new SqlParameter("@memo", SqlDbType.NText); paras[4].Value = text.Replace("'", "''"); paras[5] = new SqlParameter("@COMPANY", SqlDbType.NVarChar); paras[5].Value = ""; paras[6] = new SqlParameter("@AIRCOMPANY", SqlDbType.NVarChar); paras[6].Value = ""; paras[7] = new SqlParameter("@UserID", SqlDbType.Int); paras[7].Value = check.CheckNumber(Request.Cookies["user_id"].Value.ToString()); paras[8] = new SqlParameter("@title", SqlDbType.NVarChar, 50); paras[8].Value = check.CheckInput(txtTitle.Text); paras[9] = new SqlParameter("@attach", SqlDbType.NVarChar, 50); paras[9].Value = ""; paras[10] = new SqlParameter("@hits", SqlDbType.Int); paras[10].Value = 0; paras[11] = new SqlParameter("@LINE", SqlDbType.NVarChar, 50); paras[11].Value = check.CheckInput(DropDownList1.Text); paras[12] = new SqlParameter("@CompanyName", SqlDbType.NVarChar); paras[12].Value = ""; paras[13] = new SqlParameter("@CompanyAddr", SqlDbType.NVarChar); paras[13].Value = ""; paras[14] = new SqlParameter("@CompanyPhone", SqlDbType.NVarChar); paras[14].Value = ""; paras[15] = new SqlParameter("@CompanyFax", SqlDbType.NVarChar); paras[15].Value = ""; paras[16] = new SqlParameter("@CommuPerson", SqlDbType.NVarChar); paras[16].Value = ""; paras[17] = new SqlParameter("@email", SqlDbType.NVarChar); paras[17].Value = ""; paras[18] = new SqlParameter("@mobile", SqlDbType.NVarChar); paras[18].Value = ""; paras[19] = new SqlParameter("@UserID2", SqlDbType.Int); paras[19].Value = "0"; paras[20] = new SqlParameter("@id", SqlDbType.Int); paras[20].Direction = ParameterDirection.Output; int id = Convert.ToInt32(ExecoutID("Air_UP_brand_add", paras)); string strsubmit = hidsubmit.Value; string[] strarray = Regex.Split(strsubmit, "sdfgyuio", new RegexOptions()); int i; data_conn3 data_conn = new data_conn3(); SqlConnection conn = new SqlConnection(); conn = data_conn.mdb_conn(); conn.Open(); string value; string strSQL = ""; string[] strrow = new string[strarray.Length]; for (i = 0; i < strarray.Length - 1; i++) { if (strarray[i] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl") { strrow = Regex.Split(strarray[i], "qwerhjkl", RegexOptions.IgnoreCase); if (strrow[3] == "" && strrow[4] == "" && strrow[5] == "" && strrow[6] == "" && strrow[7] == "") { strrow[5] = "cable"; } value = check.CheckNumber(id.ToString()) + ",'" + check.CheckInput(strrow[0]) + "','" + check.CheckInput(strrow[1]) + "','" + check.CheckInput(strrow[2]) + "','" + check.CheckInput(strrow[3]) + "','" + check.CheckInput(strrow[4]) + "','" + check.CheckInput(strrow[5]) + "','" + check.CheckInput(strrow[6]) + "','" + check.CheckInput(strrow[7]) + "','" + check.CheckInput(strrow[8]) + "','" + check.CheckInput(strrow[9]) + "','" + check.CheckInput(strrow[10]) + "','" + check.CheckInput(strrow[11]) + "','" + check.CheckInput(txtTitle.Text) + "','" + check.CheckInput(txtStart.Text) + "','" + DateTime.Now + "','" + check.CheckInput(BasicDatePicker1_TextBox.Value) + "','" + check.CheckInput(DropDownList1.Text) + "'," + check.CheckNumber(Request.Cookies["user_id"].Value.ToString()); strSQL += "insert into T_AIRPRICE (AIRID,DestPort,PRICE_M,PRICE_N,PRICE_P45,PRICE_P100,PRICE_P300,PRICE_P500,PRICE_P1000,price20gpAppend,Distance,DepartureWkd,memo,Titlex,StartPortx,PostDatex,enddatex,linex,UserIDx) values (" + value + ");"; } } strSQL += "update T_AIRINFO set DestPort1='" + check.CheckInput(strrow[0]) + "',PRICE_M1='" + check.CheckInput(strrow[1]) + "',PRICE_N1='" + check.CheckInput(strrow[2]) + "',PRICE_P451='" + check.CheckInput(strrow[3]) + "',PRICE_P1001='" + check.CheckInput(strrow[4]) + "',PRICE_P3001='" + check.CheckInput(strrow[5]) + "',PRICE_P5001='" + check.CheckInput(strrow[6]) + "',PRICE_P10001='" + check.CheckInput(strrow[7]) + "' where id=" + id.ToString() + ";"; strSQL += "UPDATE TB_PRICECOUNT SET TB_PRICECOUNT.aircount = (SELECT COUNT(t_airinfo.id) AS yunjiacount FROM t_airinfo,t_airprice WHERE t_airinfo.id = t_airprice.airid),TB_PRICECOUNT.countdate = getdate() where TB_PRICECOUNT.cid = 1"; SqlCommand myCommand1 = new SqlCommand(strSQL, conn); myCommand1.ExecuteNonQuery(); conn.Close(); topnew tp = new topnew(); tp.SetTopNew(id.ToString(), check.CheckInput(txtTitle.Text), DateTime.Now.ToString(), "10", check.CheckInput(DropDownList1.Text), check.CheckInput(txtStart.Text.Replace("'", "''")), check.CheckNumber(Request.Cookies["user_id"].Value.ToString())); //Server.Transfer("ReleaseSucceed.aspx?id=" + id.ToString() + "&type=1"); Server.Transfer("office_air_list.aspx"); } }
protected void Button1_Click(object sender, EventArgs e) { if (WordsIScn(hidsubmit.Value) || WordsIScn(txtTitle.Text) || WordsIScn(txtStart.Text) || WordsIScn(txtRemark.Value)) { MessageBox("", "发布英文运价时,除了标题备注,不能出现中文"); return; } if (hidsubmit.Value == "") { MessageBox("", "目的港不能为0个"); return; } if (hidsubmit.Value.Replace("qwerhjkl", "").Replace("sdfgyuio", "").Replace("0", "").Replace("1", "") == "") { MessageBox("", "目的港不能为0个"); return; } string[] strsubmitrow = Regex.Split(hidsubmit.Value, "sdfgyuio", new RegexOptions()); for (int k = 0; k < strsubmitrow.Length - 1; k++) { if (strsubmitrow[k].Substring(0, 8) == "qwerhjkl" && strsubmitrow[k] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl" ) { MessageBox("", "第" + Convert.ToString(k + 1) + "行的目的港不能为空"); return; } } if (txtTitle.Text == "") { MessageBox("", "标题不能为空"); } else if (BasicDatePicker1_TextBox.Value == "") { MessageBox("", "有效日期不能为空"); } else if (txtStart.Text == "") { MessageBox("", "启运港不能为空"); } else if (DropDownList1.Text == "请选择") { MessageBox("", "请选择航线"); } else { string strSql; string meno = check.CheckInput(txtRemark.Value); meno = meno.Replace("\n", "<br>"); meno = meno.Replace(" ", " "); data_conn3 data_conn = new data_conn3(); SqlConnection conn = new SqlConnection(); conn = data_conn.mdb_conn(); conn.Open(); strSql = "update T_AIRINFO set entitle='" + check.CheckInput(txtTitle.Text.Replace("'", "''")) + "',title='" + check.CheckInput(txtTitle.Text.Replace("'", "''")) + "',enddate='" + check.CheckInput(BasicDatePicker1_TextBox.Value.Replace("'", "''")) + "',StartPort='" + check.CheckInput(txtStart.Text.Replace("'", "''")) + "',line='" + check.CheckInput(DropDownList1.SelectedValue.Replace("'", "''")) + "',enmemo='" + meno.Replace("'", "''") + "',memo='" + meno.Replace("'", "''") + "',PostDate='" + DateTime.Now.ToString().Replace("'", "''") + "',updateTimes=updateTimes+1 where id=" + check.CheckNumber(Request["id"]); SqlCommand myCommand = new SqlCommand(strSql, conn); myCommand.ExecuteNonQuery(); myCommand.CommandText = "delete from T_AIRPRICE where AIRID=" + check.CheckNumber(Request["id"]); myCommand.ExecuteNonQuery(); string strsubmit = hidsubmit.Value; string[] strarray = Regex.Split(strsubmit, "sdfgyuio", new RegexOptions()); strSql = ""; string value; string[] strrow = new string[strarray.Length]; for (int i = 0; i < strarray.Length - 1; i++) { if (strarray[i] != "qwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjklqwerhjkl") { strrow = Regex.Split(strarray[i], "qwerhjkl", new RegexOptions()); value = check.CheckNumber(Request["id"]) + ",'" + check.CheckInput(strrow[0]) + "','" + check.CheckInput(strrow[1]) + "','" + check.CheckInput(strrow[2]) + "','" + check.CheckInput(strrow[3]) + "','" + check.CheckInput(strrow[4]) + "','" + check.CheckInput(strrow[5]) + "','" + check.CheckInput(strrow[6]) + "','" + check.CheckInput(strrow[7]) + "','" + check.CheckInput(strrow[8]) + "','" + check.CheckInput(strrow[9]) + "','" + check.CheckInput(strrow[10]) + "','" + check.CheckInput(strrow[11]) + "','" + check.CheckInput(txtTitle.Text.Replace("'", "''")) + "','" + check.CheckInput(txtStart.Text) + "','" + DateTime.Now.ToString().Replace("'", "''") + "','" + check.CheckInput(BasicDatePicker1_TextBox.Value.Replace("'", "''")) + "','" + check.CheckInput(DropDownList1.Text.Replace("'", "''")) + "'," + check.CheckNumber(Request.Cookies["user_id"].Value.ToString()) + ",'" + check.CheckInput(txtTitle.Text) + "',1"; strSql += "insert into T_AIRPRICE (AIRID,DestPort,PRICE_M,PRICE_N,PRICE_P45,PRICE_P100,PRICE_P300,PRICE_P500,PRICE_P1000,price20gpAppend,Distance,DepartureWkd,memo,Titlex,StartPortx,PostDatex,enddatex,linex,UserIDx,entitlex,ifEnx) values (" + value + ");"; } } strSql += "update T_AIRINFO set DestPort1='" + check.CheckInput(strrow[0]) + "',PRICE_M1='" + check.CheckInput(strrow[1]) + "',PRICE_N1='" + check.CheckInput(strrow[2]) + "',PRICE_P451='" + check.CheckInput(strrow[3]) + "',PRICE_P1001='" + check.CheckInput(strrow[4]) + "',PRICE_P3001='" + check.CheckInput(strrow[5]) + "',PRICE_P5001='" + check.CheckInput(strrow[6]) + "',PRICE_P10001='" + check.CheckInput(strrow[7]) + "' where id=" + Request["id"].ToString() + ";"; strSql += "UPDATE TB_PRICECOUNT SET TB_PRICECOUNT.aircount = (SELECT COUNT(t_airinfo.id) AS yunjiacount FROM t_airinfo,t_airprice WHERE t_airinfo.id = t_airprice.airid),TB_PRICECOUNT.countdate = getdate() where TB_PRICECOUNT.cid = 1"; SqlCommand myCommand1 = new SqlCommand(strSql, conn); myCommand1.ExecuteNonQuery(); conn.Close(); topnew tp = new topnew(); tp.SetTopNew(check.CheckNumber(Request["id"]), check.CheckInput(txtTitle.Text.Replace("'", "''")), DateTime.Now.ToString(), "10", check.CheckInput(DropDownList1.Text.Replace("'", "''")), check.CheckInput(txtStart.Text.Replace("'", "''")), check.CheckNumber(Request.Cookies["user_id"].Value.ToString())); Response.Redirect("office_air_list.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { Page.Title = "傲赢网 - 我的办公室 - 整箱运价"; check ck = new check(); string a = ck.CheckNumber(this.Request["id"]); if (! Page.IsPostBack) { DataSet ds=trun(a); if (ds.Tables[0].Rows.Count == 0) { Response.Redirect("../search/err.aspx"); } //try //{ // if((ds.Tables[0].Rows[0]["UserID2"].ToString() != Request.Cookies["user_id"].Value.ToString()) && (ds.Tables[0].Rows[0]["UserID"].ToString() != Request.Cookies["user_id"].Value.ToString())) // { // Response.Redirect("../search/err.aspx"); // } //} //catch(Exception t) //{ // Response.Redirect("../search/err.aspx"); //} txtpostdate.Value = ds.Tables[0].Rows[0]["PostDate"].ToString().Split(' ')[0]; TextBox13.Text = ds.Tables[0].Rows[0]["PostDate"].ToString().Split(' ')[1]; TextBox1.Text = ds.Tables[0].Rows[0]["title"].ToString(); txtenddate.Value = ds.Tables[0].Rows[0]["enddate"].ToString().Split(' ')[0]; if (Convert.ToInt32(ds.Tables[0].Rows[0]["yunjialeixing"]) == 8) { lblyunjialeixing.Text = "整箱运价"; } else if(Convert.ToInt32(ds.Tables[0].Rows[0]["yunjialeixing"]) == 9) { lblyunjialeixing.Text = "拼箱运价"; } txtStartPost.Text = ds.Tables[0].Rows[0]["StartPort"].ToString(); ddlhangxianmiaoshu.SelectedItem.Text = ds.Tables[0].Rows[0]["hangxianmiaoshu"].ToString(); txthit.Text = ds.Tables[0].Rows[0]["hits"].ToString(); string memo = ds.Tables[0].Rows[0]["memo"].ToString(); memo = memo.Replace("<br>", "\r"); memo = memo.Replace(" ", " "); txtmemo.Text = memo; if (ds.Tables[0].Rows[0]["UserID2"].ToString() == "") { this.Hidden1.Value = "0"; } else { this.Hidden1.Value = ds.Tables[0].Rows[0]["UserID2"].ToString(); } AddStyleSheet(this.Page, "/css/list.css"); GridView1.Attributes.Add("bordercolor ", "#D9D9D9"); DataSet ds2; data_conn3 conn = new data_conn3(); string sql; if (ds.Tables[0].Rows[0]["UserID2"].ToString() == "0" || ds.Tables[0].Rows[0]["UserID2"].ToString() == "") { sql = "select * from TB_User where UserID=" + ck.CheckNumber(ds.Tables[0].Rows[0]["UserID"].ToString()); } else { sql = "select * from TB_User where UserID=" + ck.CheckNumber(ds.Tables[0].Rows[0]["UserID2"].ToString()); } ds2 = conn.mdb_ds(sql, "table"); txtname.Text = ds2.Tables["table"].Rows[0]["RealName"].ToString(); txtCompanyName.Text = ds2.Tables["table"].Rows[0]["CompanyName"].ToString(); txtAddress.Text = ds2.Tables["table"].Rows[0]["Address"].ToString(); txtFax.Text = ds2.Tables["table"].Rows[0]["Fax"].ToString(); txtMovePhone.Text = ds2.Tables["table"].Rows[0]["MovePhone"].ToString(); txtPhone.Text = ds2.Tables["table"].Rows[0]["Phone"].ToString(); txtPostNumber.Text = ds2.Tables["table"].Rows[0]["PostNumber"].ToString(); txtUserEmail.Text = ds2.Tables["table"].Rows[0]["UserEmail"].ToString(); ////判断是否为manager用户,是的话,显示选择用户按钮 // DataSet ds3; // sql = "select * from TB_User where UserID=" + ck.CheckNumber(this.Request.Cookies["user_id"].Value.ToString()); // ds3 = conn.mdb_ds(sql, "table"); tt.InnerHtml = "<input type=\"button\" name=\"Submit\" value=\"选择用户\" onClick=\"javascript:window.open('../member/user_search1.asp','_blank','scrollbars=yes,width=420,height=600')\" id=\"Button2\" / >"; this.Hidden1.Visible = true; } }
protected void Button2_Click(object sender, EventArgs e) { if( TextBox4.Text == "") { MessageBox("", "目的港不能为空"); } else { check ck = new check(); string strSql, value; data_conn3 data_conn = new data_conn3 (); System.Data.SqlClient.SqlConnection conn=new System.Data.SqlClient.SqlConnection (); conn = data_conn.mdb_conn(); conn.Open(); value = ck.CheckNumber(Request["id"]) + ",'" + ck.CheckInput(this.TextBox4.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox5.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox6.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox7.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox8.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox11.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox9.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox10.Text.Replace("'", "''")) + "','" + ck.CheckInput(this.TextBox12.Text.Replace("'", "''")) + "'"; strSql = "insert into TB_YunJiaInfo (YunJiaID,DestPort,price20gp,price40gp,price40hq,price20gpAppend,memo,Distance,DepartureWkd,shipcompany) values (" + value + ")"; System.Data.SqlClient.SqlCommand myCommand=new System.Data.SqlClient.SqlCommand (strSql, conn); myCommand.ExecuteNonQuery(); conn.Close(); GridView1.DataBind(); if (this.GridView1.Rows.Count != 0) { this.head.Visible = false; this.GridView1.ShowHeader = true; } this.TextBox4.Text = ""; this.TextBox5.Text = ""; this.TextBox6.Text = ""; this.TextBox7.Text = ""; this.TextBox8.Text = ""; this.TextBox9.Text = ""; this.TextBox10.Text = ""; this.TextBox11.Text = ""; TextBox12.Text = ""; updatePostDate(); } }
//载入列表信息 public void LoadRecord(string page) { check ck = new check(); //取搜索条件,搜索条件保存在隐藏的label内 string yunjiaid = ck.CheckInput(hidTxtYunjiaid.Text); string line = ck.CheckInput(hidTxtLine.Text); string startport = ck.CheckInput(hidTxtStartport.Text); string destport = ck.CheckInput(hidTxtDestport.Text); //取保存在Cookies中的用户编号id string id = ""; if (Request.Cookies["user_id"] != null) { id = Request.Cookies["user_id"].Value.ToString(); } else { //如果用户未登录,则跳转到网站首页 Response.Redirect("/en/"); } data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = ""; //跳转 check check = new check(); DataSet ds2; data_conn3 conn = new data_conn3(); sql = "select * from TB_User where UserID=" + check.CheckNumber(Request.Cookies["user_id"].Value.ToString()); ds2 = conn.mdb_ds(sql, "table"); if (Convert.ToInt32(ds2.Tables["table"].Rows[0]["User_Level"].ToString()) == 0) { Response.Redirect("../accounts/regnormal.aspx"); } //item是(页码-1)x10,用来计算分页用 int item; item = (Convert.ToInt32(page) - 1) * 10; if (destport == "") { //无目的港搜索的select语句 sql = "select top 10 "; sql = sql + "id,startport,title,hangxianmiaoshu,"; sql = sql + "postdate,"; sql = sql + "enddate "; sql = sql + "FROM (SELECT "; sql = sql + "id,startport,title,hangxianmiaoshu,"; sql = sql + "postdate,"; sql = sql + "CONVERT(varchar(10), enddate, 120) as enddate "; sql = sql + "FROM "; sql = sql + "tb_yunjia "; sql = sql + "WHERE "; sql = sql + "1=1 "; sql = sql + "AND (userid = " + id + " or userid2 = " + id + ") "; sql = sql + "AND yunjialeixing = 9 "; //加入筛选条件,编号,航线,启运港 if (yunjiaid != "") { sql = sql + "AND tb_yunjia.id = " + yunjiaid + " "; } if (line != "") { sql = sql + "AND hangxianmiaoshu = '" + line + "' "; } if (startport != "") { sql = sql + "AND startport like '%" + startport + "%' "; } sql = sql + ") AS T "; sql = sql + "WHERE id NOT IN "; sql = sql + "(SELECT TOP " + item.ToString() + " id "; sql = sql + "FROM "; sql = sql + "tb_yunjia "; sql = sql + "WHERE "; sql = sql + "1=1 "; sql = sql + "AND (userid = " + id + " or userid2 = " + id + ") "; sql = sql + "AND yunjialeixing = 9 "; //加入筛选条件,编号,航线,启运港 if (yunjiaid != "") { sql = sql + "AND tb_yunjia.id = " + yunjiaid + " "; } if (line != "") { sql = sql + "AND hangxianmiaoshu = '" + line + "' "; } if (startport != "") { sql = sql + "AND startport like '%" + startport + "%' "; } sql = sql + "ORDER BY tb_yunjia.postdate DESC "; sql = sql + ") "; sql = sql + "ORDER BY postdate DESC "; } else { //有目的港搜索的select语句 sql = "select top 10 "; sql = sql + "id,startport,title,hangxianmiaoshu,"; sql = sql + "postdate,"; sql = sql + "enddate "; sql = sql + "FROM (SELECT "; sql = sql + "DISTINCT tb_yunjia.id as id,tb_yunjia.startport as startport,title,hangxianmiaoshu,"; sql = sql + "postdate,"; sql = sql + "CONVERT(varchar(10), enddate, 120) as enddate "; sql = sql + "FROM "; sql = sql + "tb_yunjia,tb_yunjiainfo "; sql = sql + "WHERE "; sql = sql + "1=1 AND tb_yunjia.id = tb_yunjiainfo.yunjiaid "; sql = sql + "AND (userid = " + id + " or userid2 = " + id + ") "; sql = sql + "AND yunjialeixing = 9 "; //加入筛选条件,编号,航线,启运港 if (yunjiaid != "") { sql = sql + "AND tb_yunjia.id = " + yunjiaid + " "; } if (line != "") { sql = sql + "AND hangxianmiaoshu = '" + line + "' "; } if (startport != "") { sql = sql + "AND tb_yunjia.startport like '%" + startport + "%' "; } if (destport != "") { sql = sql + "AND tb_yunjiainfo.destport like '%" + destport + "%' "; } sql = sql + ") AS T "; sql = sql + "WHERE id NOT IN "; sql = sql + "(SELECT id FROM"; sql = sql + "(SELECT DISTINCT TOP " + item.ToString() + " tb_yunjia.id AS id,postdate "; sql = sql + "FROM "; sql = sql + "tb_yunjia,tb_yunjiainfo "; sql = sql + "WHERE "; sql = sql + "1=1 AND tb_yunjia.id = tb_yunjiainfo.yunjiaid "; sql = sql + "AND (userid = " + id + " or userid2 = " + id + ") "; sql = sql + "AND yunjialeixing = 9 "; //加入筛选条件,编号,航线,启运港 if (yunjiaid != "") { sql = sql + "AND tb_yunjia.id = " + yunjiaid + " "; } if (line != "") { sql = sql + "AND hangxianmiaoshu = '" + line + "' "; } if (startport != "") { sql = sql + "AND tb_yunjia.startport like '%" + startport + "%' "; } if (destport != "") { sql = sql + "AND tb_yunjiainfo.destport like '%" + destport + "%' "; } sql = sql + "ORDER BY tb_yunjia.postdate DESC "; sql = sql + ") AS T "; sql = sql + ") "; sql = sql + "ORDER BY postdate DESC "; } ds = cn.mdb_ds(sql, "yunjia"); Repeater1.DataSource = ds.Tables["yunjia"].DefaultView; Repeater1.DataBind(); //计算页数 LoadTotalCount(); }