protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!String.IsNullOrEmpty(Request["FYDH"])) { string strFYDH = Request["FYDH"]; try { DataSet ds = FYDQuery.GetFYDItems(strFYDH); this.grdGridList.DataSource = ds; this.grdGridList.DataBind(); this.lblCount.Text = (ds == null)?"0":ds.Tables[0].Rows.Count.ToString(); decimal sZL = 0; if (ds != null) { foreach (DataRow row in ds.Tables[0].Rows) { sZL += string.IsNullOrEmpty(row["ZL"].ToString()) ? 0 : Convert.ToDecimal(row["ZL"]); } } this.lblSZL.Text = sZL.ToString("#0.0000"); } catch (Exception ex) { this.PrintfError("数据访问失败!"); return; } } } }
//查询 protected void imgBtnQuery_Click(object sender, ImageClickEventArgs e) { if (CheckUI()) { string sql = GetSqlWhere(); if (!string.IsNullOrEmpty(sql)) { SetPageCountView(); BindGridView(); try { DataSet dsCount = FYDQuery.GetFYDCollectionQR(sql); this.lblCount.Text = (string.IsNullOrEmpty(dsCount.Tables[0].Rows[0]["fCount"].ToString())) ? "0" : dsCount.Tables[0].Rows[0]["fCount"].ToString(); this.jhsl.Text = (string.IsNullOrEmpty(dsCount.Tables[0].Rows[0]["sjhsl"].ToString())) ? "0" : dsCount.Tables[0].Rows[0]["sjhsl"].ToString(); this.jhzl.Text = (string.IsNullOrEmpty(dsCount.Tables[0].Rows[0]["sjhzl"].ToString())) ? "0" : Convert.ToDecimal(dsCount.Tables[0].Rows[0]["sjhzl"]).ToString("#0.0000"); this.sjsl.Text = (string.IsNullOrEmpty(dsCount.Tables[0].Rows[0]["ssjsl"].ToString())) ? "0" : dsCount.Tables[0].Rows[0]["ssjsl"].ToString(); this.sjzl.Text = (string.IsNullOrEmpty(dsCount.Tables[0].Rows[0]["ssjzl"].ToString())) ? "0" : Convert.ToDecimal(dsCount.Tables[0].Rows[0]["ssjzl"]).ToString("#0.0000"); } catch { this.PrintfError("数据访问错误!"); } return; } this.PrintfError("请输入查询条件!"); return; } else { PrintfError("输入时间日期格式有误!"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strWLH = Request["wlh"]; string strSX = Request["sx"]; string strVfree1 = Request["vfree1"]; string strVfree2 = Request["vfree2"]; string strVfree3 = Request["vfree3"]; string FYDH = Request["FYDH"]; string ck = Request["ck"]; string sqlstr = ""; DataSet ds = new DataSet(); ds = FYDQuery.GetQueryFYDKYHW(FYDH, ck, strWLH, strSX, strVfree1, strVfree2, strVfree3); //this.grvFYD.DataSource = ds; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { this.Label1.Text = ds.Tables[0].Rows.Count.ToString(); } else { this.Label1.Text = "无"; } // this.grvFYD.DataBind(); } }
private void SetOperForm() { this.WGDCount = WGDQuery.GetExeWGDCount(); this.FYDCount = FYDQuery.GetExeFYDCount(); this.XTZHCount = XTZHQuery.GetExeXTZHCount(); this.PDDCount = PDParam.GetExePDDCount(); this.YKDCount = ZKDQuery.GetExeZKDCount(); }
protected void btnCancle_Click(object sender, ImageClickEventArgs e) { if (!this.CUSER.USERFUNCTION.FYD_CancelFinish) { this.PrintfError("您没有取消发运单完成的权限!"); return; } bool isCheck = false; foreach (GridViewRow row in this.grvFYD.Rows) { CheckBox chBox = (CheckBox)row.FindControl("chkCFYD"); HtmlInputHidden hidStatus = (HtmlInputHidden)row.FindControl("strStatus"); HtmlInputHidden hidYSLB = (HtmlInputHidden)row.FindControl("strYSLB"); HtmlInputHidden hidFYDH = (HtmlInputHidden)row.FindControl("strFYDH"); HtmlInputHidden hidCK = (HtmlInputHidden)row.FindControl("strCK"); HtmlInputHidden hidWLH = (HtmlInputHidden)row.FindControl("strWLH"); HtmlInputHidden hidSX = (HtmlInputHidden)row.FindControl("strSX"); if (chBox.Checked) { isCheck = true; if (hidStatus.Value != "2") { this.PrintfError("不能取消完成!"); return; } FYDQuery fydQ = new FYDQuery(); try { int result = fydQ.CancleWC(hidFYDH.Value, hidCK.Value, hidWLH.Value, hidSX.Value, this.CUSER.UserID); if (result == -1) { PrintfError("取消完成失败!"); return; } if (result == 10000) { PrintfError("已经完成签证确认,不能取消!"); return; } PrintfError("取消完成成功!"); BindGridView(); } catch { PrintfError("数据访问错误!"); return; } } } if (isCheck == false) { PrintfError("没有选中的发运单!"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strWLH = Request["FYDH"]; DataSet ds = new DataSet(); ds = FYDQuery.GetQueryFYDFHCK(strWLH); this.grvFYD.DataSource = ds; this.grvFYD.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { //if (!IsPostBack) //{ if (!String.IsNullOrEmpty(Request["FYDH"])) { string strFYDH = Request["FYDH"]; try { DataSet ds = FYDQuery.GetFYDQRItems(strFYDH); this.grvqr.DataSource = ds; this.grvqr.DataBind(); DataSet dspic = FYDQuery.getfydPicPath(strFYDH); this.imgdoorcph.ImageUrl = "../../images/Error.png"; this.imgdoorbody.ImageUrl = "../../images/Error.png"; this.imgqzscph.ImageUrl = "../../images/Error.png"; this.imgqzsbody.ImageUrl = "../../images/Error.png"; string picpathper = "../../CapPic/"; if (dspic != null && dspic.Tables.Count > 0 && dspic.Tables[0].Rows.Count > 0) { DataRow dr = dspic.Tables[0].Rows[0]; if (dr["doorcphissuccess"].ToString() == "Y" && dr["doorcphpicpath"].ToString() != "") { imgdoorcph.ImageUrl = picpathper + dr["doorcphpicpath"].ToString(); HyperLink3.NavigateUrl = "http://192.168.2.8/wmssite/CapPic/" + dr["doorcphpicpath"].ToString(); } if (dr["doorbodyissuccess"].ToString() == "Y" && dr["doorbodypicpath"].ToString() != "") { imgdoorbody.ImageUrl = picpathper + dr["doorbodypicpath"].ToString(); HyperLink4.NavigateUrl = "http://192.168.2.8/wmssite/CapPic/" + dr["doorbodypicpath"].ToString(); } if (dr["qzscphissuccess"].ToString() == "Y" && dr["qzscphpicpath"].ToString() != "") { imgqzscph.ImageUrl = picpathper + dr["qzscphpicpath"].ToString(); HyperLink1.NavigateUrl = "http://192.168.2.8/wmssite/CapPic/" + dr["qzscphpicpath"].ToString(); } if (dr["qzsbodyissuccess"].ToString() == "Y" && dr["qzsbodypicpath"].ToString() != "") { imgqzsbody.ImageUrl = picpathper + dr["qzsbodypicpath"].ToString(); HyperLink2.NavigateUrl = "http://192.168.2.8/wmssite/CapPic/" + dr["qzsbodypicpath"].ToString(); } } } catch (Exception ex) { this.PrintfError("数据访问失败!"); return; } } //} }
private void BindSX() { try { DataSet ds = FYDQuery.GetSX(); this.drpSX.DataSource = ds; this.drpSX.DataBind(); this.drpSX.Items.Insert(0, "请选择"); this.drpSX.SelectedIndex = 0; } catch { this.PrintfError("数据访问错误!"); } }
//设置分页控件显示 private void SetPageCountView() { try { string sqlWhere = GetSqlWhere(); int outCount; int pageCount = FYDQuery.GetPageCountQR(sqlWhere, PageControl1.GetPageSize(), out outCount); PageControl1.SetInitView(pageCount, outCount); } catch { this.PrintfError("数据访问错误,请重试!"); return; } }
protected void btnSCXH_Click(object sender, ImageClickEventArgs e) { if (!this.CUSER.USERFUNCTION.FYD_UpdateCXH) { this.PrintfError("您没有修改发运单车厢号的权限!"); return; } if (string.IsNullOrEmpty(txtCXH.Text.Trim())) { this.PrintfError("请输入车厢号!"); return; } bool isCheck = false; foreach (GridViewRow row in this.grvFYD.Rows) { CheckBox chBox = (CheckBox)row.FindControl("chkCFYD"); HtmlInputHidden hidFYDH = (HtmlInputHidden)row.FindControl("strFYDH"); if (chBox.Checked) { isCheck = true; try { int result = FYDQuery.UpdateFYDCPH(hidFYDH.Value.Trim(), this.txtCXH.Text.Trim()); if (result == 1) { PrintfError("车厢号修改失败!"); return; } PrintfError("车厢号修改成功!"); BindGridView(); this.hidItem.Value = ""; return; } catch { PrintfError("数据访问错误!"); return; } } } if (isCheck == false) { PrintfError("没有选中要修改车厢号的发运单"); return; } }
private void BindGridView() { try { string sql = GetSqlWhere(); string sortEx = this.grvFYD.Attributes["SortExpression"]; string sortDirect = this.grvFYD.Attributes["SortDirection"]; string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : ""; DataSet ds = FYDQuery.GetQueryFYDQR(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage()); this.grvFYD.DataSource = ds; this.grvFYD.DataBind(); //this.SetDisplayList1.InitSetListControl(this.grvFYD, SysBaseConfig.FYD_Q_PAGE); //this.SetDisplayList1.SetGridViewDisplay(grvFYD); } catch (Exception ex) { String strEx = ex.Message; this.PrintfError("数据访问错误,请重试!"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string type = ""; if (Request["TYPE"] == null) { return; } type = Request["TYPE"]; switch (type) { case "3": DataSet ds3 = null; try { ds3 = FYDQuery.GetFYDY(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds3 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds3.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "4": DataSet ds4 = null; try { ds4 = FYDQuery.GetBMY(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds4 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds4.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "5": DataSet ds5 = null; try { ds5 = FYDQuery.GetCPH(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds5 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds5.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "6": DataSet ds6 = null; try { ds6 = FYDQuery.GetWLH(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds6 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds6.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "7": DataSet ds7 = null; try { ds7 = FYDQuery.GetPH(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds7 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds7.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "8": DataSet ds8 = null; try { ds8 = FYDQuery.GetSX(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds8 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds8.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "10": DataSet ds10 = null; try { ds10 = FYDQuery.Getgg1(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds10 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds10.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "11": DataSet ds11 = null; try { ds11 = FYDQuery.GetTSXX(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds11 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds11.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "12": DataSet ds12 = null; try { ds12 = FYDQuery.GetKHH(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds12 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds12.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "13": DataSet ds13 = null; try { ds13 = FYDQuery.GetADD(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds13 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds13.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "14": break; } } }
protected void imgBtnFei_Click(object sender, ImageClickEventArgs e) { if (!this.CUSER.USERFUNCTION.CANCELBILL) { this.PrintfError("您没有作废单据的权限!"); return; } bool isCheck = false; foreach (GridViewRow row in this.grvFYD.Rows) { CheckBox chBox = (CheckBox)row.FindControl("chkCFYD"); HtmlInputHidden hidStatus = (HtmlInputHidden)row.FindControl("strStatus"); HtmlInputHidden hidYSLB = (HtmlInputHidden)row.FindControl("strYSLB"); HtmlInputHidden hidFYDH = (HtmlInputHidden)row.FindControl("strFYDH"); if (chBox.Checked) { isCheck = true; if (hidStatus.Value == "2") { this.PrintfError("该发运单已经装车完毕,不能作废"); return; } if (hidStatus.Value == "3") { this.PrintfError("该发运单车辆已经出厂,不能作废"); return; } if (hidStatus.Value == "4") { this.PrintfError("该发运单已经作废,不能重复作废"); return; } if (hidStatus.Value == "5") { this.PrintfError("该发运单正在装车,不能作废"); return; } if (hidYSLB.Value == "2" && hidStatus.Value == "2") { this.PrintfError("该火车发运单已经出厂,不能作废"); return; } FYDQuery fydQ = new FYDQuery(); try { fydQ.Update(hidFYDH.Value, this.CUSER.UserID); this.imgBtnQuery_Click(sender, e); } catch { PrintfError("数据访问错误!"); return; } } } if (isCheck == false) { PrintfError("没有选中的发运单!"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string type = ""; if (Request["TYPE"] == null) { return; } type = Request["TYPE"]; switch (type) { case "1": //获取完工单查询的批次号条件 DataSet ds = null; try { ds = WGDQuery.GetPCHTerm(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "2": //获取完工单查询的特殊信息条件 DataSet ds2 = null; try { string pchXX = ""; if (!string.IsNullOrEmpty(Request["PCH"])) { pchXX = Request["PCH"]; } ds2 = WGDQuery.GetPCInfo(pchXX); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds2 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds2.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "3": //批次属性的查询条件 DataSet ds3 = null; try { ds3 = WGDQuery.GetPCSX(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds3 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds3.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "4": //物料号的查询条件 DataSet ds4 = null; try { ds4 = WGDQuery.GetWLH(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds4 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds4.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "5": //生产线 DataSet ds5 = null; try { ds5 = WGDQuery.GetSCX(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds5 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds5.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "6": //生产线 DataSet ds6 = null; try { ds6 = WGDQuery.GetPH(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds6 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds6.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "7": //规格 DataSet ds7 = null; try { ds7 = WGDQuery.GetGG(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds7 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds7.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "8": //完工单号 DataSet ds8 = null; try { ds8 = WGDQuery.GetWGDH(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds8 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds8.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "9": //完工单号 DataSet ds9 = null; try { ds9 = WGDQuery.GetZJR(); } catch (Exception ex) { string a = ex.Message; Response.Write("ERROR"); } if (ds9 != null) { try { XmlTextWriter writer = new XmlTextWriter(Response.OutputStream, Response.ContentEncoding); writer.Formatting = Formatting.Indented; writer.Indentation = 4; writer.IndentChar = ' '; ds9.WriteXml(writer); writer.Flush(); writer.Close(); Response.End(); } catch { } } break; case "10": DataSet ds10 = null; string fFYDH = Request["fydh"].ToString(); string fck = Request["ck"].ToString(); string fstrWLH = Request["wlh"].ToString(); string fstrSX = Request["sx"].ToString(); string fstrVfree1 = Request["vfree1"].ToString(); string fstrVfree2 = Request["vfree2"].ToString(); string fstrVfree3 = Request["vfree3"].ToString(); string res10 = ""; try { ds10 = FYDQuery.GetQueryFYDKYHW(fFYDH, fck, fstrWLH, fstrSX, fstrVfree1, fstrVfree2, fstrVfree3); // <th>仓库</th> //<th>货位</th> //<th>物料号</th> //<th>物料名称</th> //<th>属性</th> //<th>牌号</th> //<th>规格</th> //<th>特殊信息</th> //<th>重量</th> //<th>数量</th> //<th>自由项1</th> //<th>自由项2</th> //<th>自由项3</th> res10 = "<table width=\"800px;\" id=\"grvstand\" border=\"1\" cellpadding=\"1\" cellspacing=\"0\" bordercolor =\"#dce8f4\">" + "<thead id=\"djlist\">" + "<tr>" + "<th bgcolor=\"#dce8f4\">仓库</th>" + "<th bgcolor=\"#dce8f4\">货位</th>" + "<th bgcolor=\"#dce8f4\">物料号</th>" + "<th bgcolor=\"#dce8f4\" width=\"120px\">称重日期</th>" + "<th bgcolor=\"#dce8f4\">物料名称</th>" + "<th bgcolor=\"#dce8f4\">批次号</th>" + "<th bgcolor=\"#dce8f4\">属性</th>" + "<th bgcolor=\"#dce8f4\">牌号</th>" + "<th bgcolor=\"#dce8f4\">规格</th>" + "<th bgcolor=\"#dce8f4\">特殊信息</th>" + "<th bgcolor=\"#dce8f4\">重量</th>" + "<th bgcolor=\"#dce8f4\">数量</th>" + "<th bgcolor=\"#dce8f4\">自由项1</th>" + "<th bgcolor=\"#dce8f4\">自由项2</th>" + "<th bgcolor=\"#dce8f4\">自由项3</th>" + "</tr>" + "</thead><tbody id=\"djlist\">"; if (ds10 != null && ds10.Tables.Count > 0 && ds10.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds10.Tables[0].Rows) { res10 += "<tr><td>" + dr["ck"].ToString() + "</td><td>" + dr["hw"].ToString() + "</td><td>" + dr["wlh"].ToString() + "</td><td>" + dr["rq"].ToString() + "</td><td>" + dr["wlmc"].ToString() + "</td><td>" + dr["pch"].ToString() + "</td><td>" + dr["sx"].ToString() + "</td><td>" + dr["ph"].ToString() + "</td><td>" + dr["gg"].ToString() + "</td><td>" + dr["pcinfo"].ToString() + "</td><td>" + dr["zls"].ToString() + "</td><td>" + dr["num"].ToString() + "</td><td>" + dr["vfree1"].ToString() + "</td><td>" + dr["vfree2"].ToString() + "</td><td>" + dr["vfree3"].ToString() + "</td></tr>"; } } res10 += "</tbody></table>"; } catch (System.Exception ex) { res10 = "ERROR" + ex.Message; } Response.Write(res10); Response.End(); break; } } }