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;
}
}
}
