protected void Page_Load(object sender, EventArgs e) { check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); string u = ""; u = check1.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); if (u == "0") { PlaceHolder1.Visible = false; PlaceHolder2.Visible = true; } else { PlaceHolder1.Visible = true; PlaceHolder2.Visible = false; string[] udetail; AllinUser AllinUser1 = new AllinUser(); udetail = AllinUser1.GetUserDetail(u); string uhomeid = udetail[10]; string name = udetail[3]; Literal1.Text = "<A class=login_thumb href=\"/home/space.php?uid=" + udetail[10] + "\"><IMG height=20 alt=" + udetail[3] + " src=\"/uc/avatar.php?uid=" + udetail[10] + "&size=small&type=virtual\" width=20></A> <A class=loginName href=\"/home/space.php?uid=" + udetail[10] + "\">" + udetail[3] + "</A>"; } }
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]; }
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; }
public string SetOrderDetail(string a, string c1, string c2, string o,string r) { //a是行为的角色,1为货主,2为货代,0为系统 //o是订单号 //c1是操作之前的状态号 //c2是操作之后的状态号码 //数组中参数{x}将被具体角色替换,{1}将被货主公司名替换, //{2}将被货代公司名替换,{3}将被订单号替换,{4}将被操作时间替换, //{5}将被拒绝理由替换,{6}将被个人信息替换,{7}将被重新选择替换, //{8}货主信息费,{9}货代信息费 //r是拒绝订舱的理由 string returnValue = "null"; check ck = new check(); string reject = ck.CheckInput(r); string order_code = ck.CheckInput(o); string op_code = ""; string[] op_array = new string[30]; op_array[0] = "1|0|1|订舱方 {1} 保存订单"; op_array[1] = "1|0|2|订舱方 {1} 提交订舱单,等待承运方答复"; op_array[2] = "1|1|2|订舱方 {1} 提交订舱单,等待承运方答复"; op_array[3] = "2|2|3|承运方 {2} 接受订舱"; op_array[4] = "2|2|7|承运方 {2} 不接受订舱,理由是 {5} ,申请系统审核"; op_array[5] = "2|7|2|承运方 {2} 取消不接受订舱"; op_array[6] = "0|7|12|系统通过了承运方 {2} 的不接受订舱申请,该订单作废"; op_array[7] = "0|7|2|系统未通过承运方 {2} 的不接受订舱申请,该订单恢复原状态"; op_array[8] = "1|13|2|订舱方 {1} 恢复了该订舱单,重新等待承运方答复"; op_array[9] = "1|2|8|订舱方 {1} 撤消了该订舱单"; op_array[10] = "1|8|2|订舱方 {1} 取消撤消该订舱单,重新等待承运方答复"; op_array[11] = "0|8|13|系统通过了订舱方 {1} 的撤消订舱申请,该订单作废"; op_array[12] = "0|8|2|系统未通过订舱方 {1} 的撤消订舱申请,该订单恢复原状态"; op_array[13] = "1|13|2|订舱方 {1} 恢复了该订舱单,重新等待承运方答复"; op_array[14] = "1|3|4|订舱方 {1} 确认出运"; op_array[15] = "1|3|9|订舱方 {1} 撤消了该订舱单"; op_array[16] = "1|9|3|订舱方 {1} 取消撤消该订舱单,重新等待承运方答复"; op_array[17] = "0|9|14|系统通过了订舱方 {1} 的撤消订舱申请,该订单作废"; op_array[18] = "0|9|3|系统未通过订舱方 {1} 的撤消订舱申请,该订单恢复原状态"; op_array[19] = "1|15|9|订舱方 {1} 恢复了该订舱单,重新等待承运方答复"; op_array[20] = "2|3|5|承运方 {2} 确认出运"; op_array[21] = "1|5|6|订舱方 {1} 同意完成,交易结束"; op_array[22] = "2|4|6|承运方 {2} 同意完成,交易结束"; op_array[23] = "1|4|10|订舱方 {1} 撤消了该订舱单"; op_array[24] = "1|10|4|订舱方 {1} 取消撤消该订舱单,重新等待承运方答复"; op_array[25] = "0|10|14|系统通过了订舱方 {1} 的撤消订舱申请,该订单作废"; op_array[26] = "0|10|4|系统未通过订舱方 {1} 的撤消订舱申请,该订单恢复原状态"; op_array[27] = "1|15|10|订舱方 {1} 恢复了该订舱单,重新等待承运方答复"; op_array[28] = "1|1|11|订舱方 {1} 删除该订舱单"; op_array[29] = "1|11|1|订舱方 {1} 恢复该订舱单"; string detail_txt = ""; for (int i = 0; i < op_array.Length; i++) { if (a == op_array[i].Split('|')[0].ToString() & c1 == op_array[i].Split('|')[1].ToString() & c2 == op_array[i].Split('|')[2].ToString()) { detail_txt = op_array[i].Split('|')[3].ToString(); op_code = i.ToString(); } }//确认当前的状态数组 string sql = ""; string[] odetail; odetail = GetOrderDetail(order_code); //a是货主,b是货代 //Response.Write(sql); data_conn cn = new data_conn(); DataSet ds = new DataSet(); detail_txt = detail_txt.Replace("{1}", odetail[107]); detail_txt = detail_txt.Replace("{2}", odetail[102]); detail_txt = detail_txt.Replace("{5}", "<span style=\"color:red\">" + ck.CheckInput(reject) + "</span>"); sql = "UPDATE TB_ORDER SET order_status = " + c2 + " WHERE order_code = '" + order_code + "'"; cn.mdb_exe(sql);//改变订单状态 //生成交易记录 sql = "INSERT INTO TB_ORDER_DETAIL (order_code,detail_txt,detail_date) VALUES ('" + order_code + "','" + detail_txt + "',GetDate())"; cn.mdb_exe(sql); double base_fee = 0; if (c2 == "3") { OrderAddCredit(odetail[4], (0 - Convert.ToDouble(odetail[62])).ToString(), "4", order_code, odetail[3], "0");//扣除货代的信息费 } if (c2 == "6") { OrderAddCredit(odetail[3], Convert.ToDouble(odetail[61]).ToString(), "6", order_code, odetail[4], "0");//给货主加上信息费 OrderAddCredit(odetail[4], Convert.ToDouble(odetail[63]).ToString(), "5", order_code, odetail[3], "0");//归还货代的信息费 base_fee = Convert.ToDouble(odetail[60]); if (odetail[120] == "1") { AllinUser AllinUser1 = new AllinUser(); string[] udetail; udetail = AllinUser1.GetUserDetail(odetail[4]); string ali_account = udetail[9]; double baozhengjin = Convert.ToDouble(odetail[60]) * 4 / 10000; //测试用,把保证金缩小10000倍 baozhengjin = Math.Round(baozhengjin, 2); //保留两位小数,精确到分,否则支付宝会出错 string baozhengjin_total = baozhengjin.ToString(); string baozhengjin_back = Math.Round(Convert.ToDouble(baozhengjin.ToString()) * 3 / 4, 2).ToString(); System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; string out_order_no = ""; out_order_no = order_code + "_AA"; //out_trade_no 外部商家订单号 string out_trade_no = ""; out_trade_no = order_code + "_BB"; string gateway = "https://www.alipay.com/cooperate/gateway.do?"; //'支付接口 string service = "unfreeze2fastpay"; string partner = "2088201885472720"; //partner 合作伙伴ID 保留字段 string sign_type = "MD5"; string key = "o272s6dqq0s60tm44sy314jvnsfeihd0"; //partner账户的支付宝安全校验码 string out_order_dt = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ; //外部系统订单生成时间 string buyer_nick = ali_account; //买家昵称 string seller_nick = "*****@*****.**"; //卖家昵称 string order_from = "100002"; //(6) 订单的来源地(电子客票使用,淘宝=100001) Y string old_out_order_no = order_code; //(64) 外部系统的冻结资金时的订单号 string goods_detail = "test"; //(400) 购买商品详情(不同于商品名称) Y string totle_fee = baozhengjin_total; // 交易总金额 (0.01-100000000.00元) N string price = baozhengjin_total; // 商品价格(0.01-100000000.00元) N string other_fee = "0"; // 其他费用(0.00-100000000.00元) N string op_type = "0006"; //(50) 见业务类型表 N string royalty_type = "10"; //(50) 见业务类型表 N string royalty_parameters = "" + ali_account + "^" + baozhengjin_back + "^返还订舱保证金"; //(50) 见业务类型表 N string _input_charset = "utf-8"; //HttpContext.Current.Response.Redirect(baozhengjin_total + baozhengjin_back); string aliay_url = CreatUrl( gateway, service, partner, sign_type, out_order_no, out_trade_no, seller_nick, buyer_nick, _input_charset, out_order_dt, op_type, totle_fee, price, other_fee, old_out_order_no, order_from, goods_detail, royalty_type, royalty_parameters, key ); aliay_url = aliay_url.Replace("订舱保证金", "%e8%ae%a2%e8%88%b1%e4%bf%9d%e8%af%81%e9%87%91").Replace("返还订舱保证金", "%e8%bf%94%e8%bf%98%e8%ae%a2%e8%88%b1%e4%bf%9d%e8%af%81%e9%87%91"); //HttpContext.Current.Response.Redirect(aliay_url); XmlTextReader textReader = null; try { textReader = new XmlTextReader(aliay_url); textReader.Read(); textReader.WhitespaceHandling = WhitespaceHandling.None; returnValue = "AliBackSuccess"; } catch { returnValue = "AliBackFail"; } finally { if (textReader != null) { textReader.Close(); } } } }//订单成功后的处理 if (c2 == "7") { sql = "UPDATE TB_ORDER SET reject_reason = '" + ck.CheckInput(reject) + "' WHERE order_code = '" + order_code + "'"; cn.mdb_exe(sql); } string txt_jujueliyou = ""; //拒绝理由 string txt_gerenxinxi = ""; //个人信息 string txt_chongxinxuanze = ""; //重新选择 txt_jujueliyou = "<span style=\"color:red\">" + ck.CheckInput(reject) + "</span>"; //获得货代个人信息 string sql_gerenxinxi = "SELECT * FROM TB_USER WHERE userid = " + odetail[4]; DataSet ds_gerenxinxi = new DataSet(); ds_gerenxinxi = cn.mdb_ds(sql_gerenxinxi, "bid"); txt_gerenxinxi += "姓名:" + ds_gerenxinxi.Tables["bid"].Rows[0]["Realname"].ToString() + "<br/>"; txt_gerenxinxi += "电话:" + ds_gerenxinxi.Tables["bid"].Rows[0]["phone"].ToString() + "<br/>"; txt_gerenxinxi += "Email:" + ds_gerenxinxi.Tables["bid"].Rows[0]["useremail"].ToString() + "<br/>"; //获得货代个人信息 //获得重新选择 //txt_chongxinxuanze += "<a href=\"/fcl/list-" + txtstartport.Value + "-" + txtdestport.Value + "-" + txtcarrier_name.Value + "-0-0-0-------1.html\" target=\"_blank\">重新选择</a>"; //获得重新选择 string order_type_string = odetail[58]; string sql_pm = ""; sql_pm = "SELECT * FROM TB_ORDER_OPERATION WHERE op_code = " + op_code; DataSet ds_pm = new DataSet(); ds_pm = cn.mdb_ds(sql_pm, "pm"); pm p1 = new pm(); string op_sms_shipper = ds_pm.Tables["pm"].Rows[0]["op_sms_shipper"].ToString(); op_sms_shipper = op_sms_shipper.Replace("{1}", odetail[107]); op_sms_shipper = op_sms_shipper.Replace("{2}", odetail[102]); op_sms_shipper = op_sms_shipper.Replace("{3}", "<a href= \"/search/" + order_type_string + "_order.aspx?filter=view&role=shipper&orderid=" + order_code + "\">" + order_code + "</a>"); op_sms_shipper = op_sms_shipper.Replace("{4}", DateTime.Now.ToString()); op_sms_shipper = op_sms_shipper.Replace("{5}", txt_jujueliyou); op_sms_shipper = op_sms_shipper.Replace("{6}", txt_gerenxinxi); op_sms_shipper = op_sms_shipper.Replace("{7}", txt_chongxinxuanze); op_sms_shipper = op_sms_shipper.Replace("{8}", (base_fee / 2).ToString()); op_sms_shipper = op_sms_shipper.Replace("{9}", base_fee.ToString()); string op_sms_forward = ds_pm.Tables["pm"].Rows[0]["op_sms_forward"].ToString(); op_sms_forward = op_sms_forward.Replace("{1}", odetail[107]); op_sms_forward = op_sms_forward.Replace("{2}", odetail[102]); op_sms_forward = op_sms_forward.Replace("{3}", "<a href= \"/search/" + order_type_string + "_order.aspx?filter=view&role=forward&orderid=" + order_code + "\" target=\"_blank\">" + order_code + "</a>"); op_sms_forward = op_sms_forward.Replace("{4}", DateTime.Now.ToString()); op_sms_forward = op_sms_forward.Replace("{5}", txt_jujueliyou); op_sms_forward = op_sms_forward.Replace("{6}", txt_gerenxinxi); op_sms_forward = op_sms_forward.Replace("{7}", txt_chongxinxuanze); op_sms_forward = op_sms_forward.Replace("{8}", (base_fee / 2).ToString()); op_sms_forward = op_sms_forward.Replace("{9}", base_fee.ToString()); if (op_sms_shipper != "") { p1.sendpm("41", odetail[3], op_sms_shipper, "1"); } if (op_sms_forward != "") { p1.sendpm("41", odetail[4], op_sms_forward, "1"); } return returnValue; }
protected void Page_Load(object sender, EventArgs e) { login lg = new login(); lg.login(); order order1 = new order(); check ck = new check(); string u = ck.CheckNumber(order1.GetRequestQueryString("u", "0")); string myu = ck.CheckNumber(order1.GetRequestCookies("user_id", "")); data_conn cn = new data_conn(); DataSet ds = new DataSet(); string sql = "SELECT * FROM TB_USER WHERE userid = " + u; ds = cn.mdb_ds(sql, "user"); Label1.Text = ds.Tables["user"].Rows[0]["companyname"].ToString(); Label9.Text = ds.Tables["user"].Rows[0]["postnumber"].ToString(); Label11.Text = ds.Tables["user"].Rows[0]["address"].ToString(); Label4.Text = "<span><a href=\"/company/" + setkey(u) + "\" style='font-size:14px; font-weight:bold; color:#FF6600;' target=\"_blank\">" + ds.Tables["user"].Rows[0]["realname"].ToString() + "</a></span>"; Literal25.Text = "<a href=\"/member/pm_detail.aspx?pid=1&cid=" + u + "\" target=\"_blank\"><img src=\"/images/fcl/bot_1.jpg\" border=\"0\" style= 'margin-top: 12px;'/></a>"; if ((bool)ds.Tables["user"].Rows[0]["HeadURL"] == true) { imghead.Src = "/member/Head/" + ds.Tables["user"].Rows[0]["UserID"].ToString() + ".jpg"; } else { imghead.Src = "/member/Head/default.jpg"; } LtrStars1.Text = Star1(ds.Tables["user"].Rows[0]["star_allin"].ToString()); LtrStars2.Text = Star2(ds.Tables["user"].Rows[0]["star_user"].ToString()); try { ImageButton1.ImageUrl = "/images/get/company_tel.aspx?u=" + setkey(u); ImageButton3.ImageUrl = "/images/get/company_email.aspx?u=" + setkey(u); ImageButton4.ImageUrl = "/images/get/company_mobile.aspx?u=" + setkey(u); } catch { } AllinUser AllinUser1 = new AllinUser(); mysqldata_conn mycn = new mysqldata_conn(); sql = "SELECT uid FROM uc_friends WHERE uid = " + AllinUser1.GetUserDetail(myu)[10] + " AND friendid = " + ds.Tables["user"].Rows[0]["UCenterHomeUid"].ToString(); //Response.Write(sql); DataSet dsu = new DataSet(); dsu = mycn.mdb_ds(sql, "ufriend"); if (dsu.Tables["ufriend"].Rows.Count > 0) { ImageButton2.Visible = false; Label2.Visible = true; } }
protected void submitbtn_ServerClick(object sender, EventArgs e) { check check1 = new check(); GetRequest GetRequest1 = new GetRequest(); string u = ""; u = check1.CheckNumber(GetRequest1.GetRequestCookies("user_id", "0")); data_conn cn = new data_conn(); DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); DataSet ds2 = new DataSet(); string sql = ""; string surl = url2.Value.Trim(); string vurl = ""; if (surl.IndexOf("http://") == -1) { surl = "http://" + surl; } sql = "SELECT * FROM TB_REPASTE_VIDEO WHERE '" + check1.CheckRecord(surl) + "' LIKE '%' + vtag + '%'"; ds = cn.mdb_ds(sql, "video"); if (ds.Tables["video"].Rows.Count > 0) { string regexp1 = ds.Tables["video"].Rows[0]["surl"].ToString(); string regexp2 = ds.Tables["video"].Rows[0]["durl"].ToString(); Match TitleMatch = Regex.Match(surl, regexp1, RegexOptions.IgnoreCase | RegexOptions.Multiline); string urlkey = TitleMatch.Groups[1].Value.ToString(); if (urlkey != "") { vurl = Regex.Replace(regexp2, "urlkey", urlkey); } } sql = "INSERT INTO TB_REPASTE_TOPIC (topic,txt,userid,url) VALUES ('" + check1.CheckInput(title.Value) + "','" + vurl + "<br/>" + check1.CheckRecord(HiddenField1.Value) + "'," + u + ",'" + check1.CheckInput(url2.Value) + "'); SELECT @@identity "; ds1 = cn.mdb_ds(sql, "topic"); string redirect_tid = ds1.Tables["topic"].Rows[0][0].ToString();//获得转贴主记录的id号 sql = "INSERT INTO TB_REPASTE_REPASTE (tid,userid) VALUES ('" + ds1.Tables["topic"].Rows[0][0].ToString() + "'," + u + "); SELECT @@identity "; ds2 = cn.mdb_ds(sql, "paste"); string redirect_rid = ds2.Tables["paste"].Rows[0][0].ToString();//获得转贴的id号 sql = "SELECT TOP 4 * FROM V_REPASTE_INDEX WHERE userid2 = " + u + " ORDER BY rid DESC"; ds2 = cn.mdb_ds(sql, "index"); string body_template = ""; for (int i = 0; i < ds2.Tables["index"].Rows.Count; i++) { body_template = body_template + "<a href=\"/club/repaste/detail.aspx?rid=" + ds2.Tables["index"].Rows[i]["rid"].ToString() + "\">" + check1.CheckRecord(ds2.Tables["index"].Rows[i]["topic"].ToString()) + "</a><br/>"; if (i == ds2.Tables["index"].Rows.Count - 1) { body_template += "<div style=\"width:98%;text-align:right;\"><a href=\"/club/repaste/other.aspx?uid=" + u + "\">查看TA的全部转贴>></a></div>"; } } string[] udetail; AllinUser AllinUser1 = new AllinUser(); udetail = AllinUser1.GetUserDetail(u); string uhomeid = udetail[10]; mysqldata_conn mysqlcn = new mysqldata_conn(); sql = "select uc_members.uid,uc_members.username,uchome_space.name from uc_members left join uchome_space on uc_members.uid = uchome_space.uid where uc_members.uid = " + uhomeid; ds2 = mysqlcn.mdb_ds(sql, "uc"); string uhomename = ""; if (ds2.Tables["uc"].Rows[0]["name"].ToString() == "") { uhomename = ds2.Tables["uc"].Rows[0]["username"].ToString(); } else { uhomename = ds2.Tables["uc"].Rows[0]["name"].ToString(); } sql = "DELETE FROM uchome_feed WHERE appid = 1 AND icon = 'repaste' AND uid = " + uhomeid + ";INSERT INTO uchome_feed (appid,icon,uid,username,dateline,friend,hash_data,title_template,body_template) VALUES (1,'repaste'," + uhomeid + ",'" + uhomename + "'," + UnixTimestamp() + ",0,'" + UnixTimestamp() + "','<b>{actor}</b> 转贴给大家','" + body_template + "')"; //Response.Write(sql); mysqlcn.mdb_exe(sql); if (Radio2.Checked == true) { sql = ""; if (answer1.Value != "") { DataSet ds_v = new DataSet(); sql = "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer1.Value) + "',1," + redirect_tid + ");SELECT @@identity "; ds_v = cn.mdb_ds(sql,"vote"); sql = "INSERT INTO TB_REPASTE_VIEW (userid,tid,voteid) VALUES (" + u + "," + redirect_tid + "," + ds_v.Tables["vote"].Rows[0][0].ToString() + ");"; } if (answer2.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer2.Value) + "',0," + redirect_tid + ");"; } if (answer3.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer3.Value) + "',0," + redirect_tid + ");"; } if (answer4.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer4.Value) + "',0," + redirect_tid + ");"; } if (answer5.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer5.Value) + "',0," + redirect_tid + ");"; } if (answer6.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer6.Value) + "',0," + redirect_tid + ");"; } if (answer7.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer7.Value) + "',0," + redirect_tid + ");"; } if (answer8.Value != "") { sql += "INSERT INTO TB_REPASTE_VOTE (txt,vcount,tid) VALUES ('" + check1.CheckInput(answer8.Value) + "',0," + redirect_tid + ");"; } cn.mdb_exe(sql); } Response.Redirect("detail.aspx?rid=" + redirect_rid); }
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]; }