原来自己写的现在备份一下省的到时候有问题
[csharp]
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Data.SqlClient;
public partial class Station_Name_Data : System.Web.UI.Page
{
protected string strStation_Name = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
string Factory_Name = Request.Form["FactoryName"].Trim();
SqlConnection conn_StationName = new SqlConnection();
conn_StationName.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XNYQFGS"].ConnectionString;
try
{
conn_StationName.Open();
SqlCommand cmd_Station = new SqlCommand();
cmd_Station.Connection = conn_StationName;
cmd_Station.CommandText = "select station_id,Station_Name from station_info inner join factory_info on station_info.factory_id=factory_info.factory_id where factory_info.factory_name='" + Factory_Name + "'";
SqlDataAdapter sda = new SqlDataAdapter(cmd_Station);
DataSet ds = new DataSet();
sda.Fill(ds);
//strCompany_Name += "[";
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// //最后一条单独处理
// //格式如下：
// /*
// * [{"serviceHall_Name":"名字1","serviceHall_ID":"1"},{"serviceHall_Name":"名字2","serviceHall_ID":"2"}]
// */
// string ID = ds.Tables[0].Rows[i][0].ToString().Trim();
// string Company_Name = ds.Tables[0].Rows[i][1].ToString().Trim();
// strCompany_Name += "'{Company_ID':'" + ID + "',";
// strCompany_Name += "'Company_Name':'" + Company_Name + "'},";
//}
//strCompany_Name = strCompany_Name.Remove(strCompany_Name.Length - 1);
//strCompany_Name += "]";
DataTable dt = ds.Tables[0];
strStation_Name = DataTableToJson(dt, "rootStationName", 0, dt.Rows.Count);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
conn_StationName.Close();
}
HttpContext.Current.Response.Write(strStation_Name);
HttpContext.Current.Response.End();
}
public static string DataTableToJson(DataTable dt, string strTableName, int start, int limit)
{
StringBuilder jsonBuilder = new StringBuilder();
string head = "{ success:true,\"totalRecordCount\":\"" + dt.Rows.Count.ToString() + "\",\"";
//jsonBuilder.Append("{\"");
string tmpStr = "";
jsonBuilder.Append(strTableName);
jsonBuilder.Append("\":[");
if (dt.Rows.Count > 0)
{
int endCount = start + limit;
if (endCount > dt.Rows.Count)
endCount = dt.Rows.Count;
for (int i = start; i < endCount; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
tmpStr = dt.Rows[i][j].ToString().Trim();
jsonBuilder.Append(tmpStr.Replace("\"", "\\\""));
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
