页面用Grid++打印报表,列名不正确! 报表.netxmlSQL 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@ Page Language="C#" %><script runat = "server"> protected void Page_load(object sender, EventArgs e){ String INVOICE_CODE = Request.QueryString["INVOICE_CODE"]; int CLEARING_TYPE = 1; String QuerySQL = @"SELECT EIID.INVOICE_CODE, EIID.INVOICE_DETAIL_ID, EIID.MATERIAL_MODEL_ID, EIID.PRICE_TOTAL_NOTAX, EIID.NUMBER, EIID.PRICE_NOTAX, dbo.V_P1_MSTORE_PUTIN_MANAGE.PRICE_NOTAX as estimatedPRICE_NOTAX, ISNULL(CONVERT(DECIMAL(12,2),EIID.NUMBER*dbo.V_P1_MSTORE_PUTIN_MANAGE.PRICE_NOTAX),0) AS TOTALNOTAXPRICE, --dbo.V_P1_MSTORE_PUTIN_MANAGE.TOTALNOTAXPRICE, EIID.PRICE_TOTAL, EIID.STORE_PUTIN_CODE, dbo.V_P1_MSTORE_PUTIN_MANAGE.PRICE_TAX, EIID.CONTRACT_ID, EIID.TAX, EIID.TAX_RATE, MM.UNIT_MAIN_NAME, MM.UNIT_CONVERSION_NAME, MM.MEASURE_MODEL_CODE, MM.MEASURE_MODEL_NAME, EIID.CLEARING_TYPEFROM dbo.ERP_INVOICE_IN_DETAIL AS EIID INNER JOIN dbo.V_TL_MATERIAL_MODEL AS MM ON EIID.MATERIAL_MODEL_ID = MM.MATERIAL_MODEL_ID INNER JOIN dbo.V_P1_MSTORE_PUTIN_MANAGE ON dbo.V_P1_MSTORE_PUTIN_MANAGE.MATERIAL_MODEL_ID = EIID.MATERIAL_MODEL_ID AND dbo.V_P1_MSTORE_PUTIN_MANAGE.STORE_PUTIN_CODE = EIID.STORE_PUTIN_CODE WHERE EIID.INVOICE_CODE LIKE '%" + INVOICE_CODE + "%' AND NAME LIKE '%" + CLEARING_TYPE + "%' "; SqlReportData.GenNodeXmlData(this,QuerySQL,true); } </script> 我在ASP.NET程序中使用AJAX,点击按钮后出现问题 求助一个模态对话框的问题 ASP.net 的页面 怎设置居中显示 怎样让页面返回XML内容? 还是静态页的问题。(关于网站主页的静态页的生成) 急求为什么点击RadioButton后checked属性没反应 一个类似ftp上传的功能 ,能不能获取到上传的文件的大小的呢 统计表中记录数应该怎么做 GridView在谷歌浏览器和IE浏览器之间的问题 在ASP.NET中怎样用OCX控件?? DataSet绑定分页控件,只分页动,列表不动,求修改 大家有没有c#对应这个java.des的代码
<script runat = "server">
protected void Page_load(object sender, EventArgs e){
String INVOICE_CODE = Request.QueryString["INVOICE_CODE"];
int CLEARING_TYPE = 1;
String QuerySQL = @"SELECT EIID.INVOICE_CODE, EIID.INVOICE_DETAIL_ID, EIID.MATERIAL_MODEL_ID, EIID.PRICE_TOTAL_NOTAX,
EIID.NUMBER, EIID.PRICE_NOTAX,
dbo.V_P1_MSTORE_PUTIN_MANAGE.PRICE_NOTAX as estimatedPRICE_NOTAX,
ISNULL(CONVERT(DECIMAL(12,2),EIID.NUMBER*dbo.V_P1_MSTORE_PUTIN_MANAGE.PRICE_NOTAX),0) AS TOTALNOTAXPRICE,
--dbo.V_P1_MSTORE_PUTIN_MANAGE.TOTALNOTAXPRICE,
EIID.PRICE_TOTAL, EIID.STORE_PUTIN_CODE,
dbo.V_P1_MSTORE_PUTIN_MANAGE.PRICE_TAX, EIID.CONTRACT_ID,
EIID.TAX, EIID.TAX_RATE,
MM.UNIT_MAIN_NAME, MM.UNIT_CONVERSION_NAME,
MM.MEASURE_MODEL_CODE, MM.MEASURE_MODEL_NAME,
EIID.CLEARING_TYPE
FROM dbo.ERP_INVOICE_IN_DETAIL AS EIID INNER JOIN
dbo.V_TL_MATERIAL_MODEL AS MM ON EIID.MATERIAL_MODEL_ID = MM.MATERIAL_MODEL_ID INNER JOIN
dbo.V_P1_MSTORE_PUTIN_MANAGE ON dbo.V_P1_MSTORE_PUTIN_MANAGE.MATERIAL_MODEL_ID = EIID.MATERIAL_MODEL_ID AND
dbo.V_P1_MSTORE_PUTIN_MANAGE.STORE_PUTIN_CODE = EIID.STORE_PUTIN_CODE
WHERE EIID.INVOICE_CODE LIKE '%" + INVOICE_CODE + "%' AND NAME LIKE '%" + CLEARING_TYPE + "%' ";
SqlReportData.GenNodeXmlData(this,QuerySQL,true);
}
</script>