62,272
社区成员
发帖
与我相关
我的任务
分享

$(function () {
$("#btnSubmit").click(function () {
var sdata = $("#tb_sdate_1").val();
var edate = $("#tb_edate_1").val();
var vall = $("#Hidden1").val();
$.ajax({
type: "POST",
url: "index.aspx/sendValue",
data: "{'va':'" + vall + "','sdate':'" + sdata + "','edate':'" + edate + "'}",
beforeSend: function () { $("#hidiv").show();},
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
var vstr = data.d
var strarr = new Array();
if (vstr != "") {
if (vstr.indexOf(",") > 0) {
strarr = vstr.split(",");
}
else {
strarr = new Array(vstr);
}
}
for (var t = 0; t < strarr.length; t++) {
var yu = strarr[t].split(":");
$('#' + yu[0]).html(yu[1]);
}
$("#hidiv").hide();
$("#head").width($(".td_Item:gt(0)").width());
},
error: function (XMLHttpRequest) {
alert(XMLHttpRequest.responseText);
}
});
return false;
});
}
);[WebMethod]
public static string sendValue(string va, string sdate, string edate)
{
string disp = va;
string display = disp.LastIndexOf(",") != -1 ? disp.Substring(0, disp.LastIndexOf(",")) : "";
string[] strarr = new string[] { };
string vlues = "";
if (display != "")
{
if (display.IndexOf(",") != -1)
{
strarr = display.Split(',');
}
else
{
strarr = new string[] { display };
}
}
for (int i = 0; i < strarr.Length; i++)
{
vlues += strarr[i] + ":" + getDataByItem(strarr[i], sdate, edate, getDept()) + ",";
}
string values = vlues.IndexOf(",") != -1 ? vlues.Substring(0, vlues.LastIndexOf(",")) : vlues;
return values;
} public static string getDataByItem(string item_code, string sdate, string edate, string dept)
{
string sql = "select querysql from kssrfx where item_code='" + item_code + "'";
DataTable dt = DataOper.getPlatData(sql).Tables[0];
string datasql = dt.Rows[0][0].ToString();
OracleConnection dconn = new OracleConnection(conn);
OracleCommand cmd = new OracleCommand();
try
{
dconn.Open();
cmd.Connection = dconn;
cmd.CommandText = datasql;
OracleParameter op1 = new OracleParameter();
op1.ParameterName = ":sdate";
op1.Value = sdate;
OracleParameter op2 = new OracleParameter();
op2.ParameterName = ":edate";
op2.Value = edate;
OracleParameter op3 = new OracleParameter();
op3.ParameterName = ":dept";
op3.Value = dept;
cmd.Parameters.Add(op1);
cmd.Parameters.Add(op2);
cmd.Parameters.Add(op3);
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = cmd;
DataSet ds = new DataSet();
oda.Fill(ds);
dconn.Close();
DataTable dt1 = ds.Tables[0];
if (dt1.Rows.Count > 0)
{
string backhtml = "<table class='autot' cellspacing='0' cellpadding='0'><tr>";
for (int k = 0; k < dt1.Columns.Count; k++)
{
backhtml += "<td>" + dt1.Columns[k].ColumnName + "</td>";
}
backhtml += "</tr>";
for (int i = 0; i < dt1.Rows.Count; i++)
{
backhtml += "<tr>";
for (int j = 0; j < dt1.Columns.Count; j++)
{
backhtml += "<td>" + dt1.Rows[i][j].ToString() + "</td>";
}
backhtml += "</tr>";
}
backhtml += "</table>";
return backhtml;
}
else
return "没有数据!";
}
catch (Exception r)
{
return "没有数据!";
}
}