/// <summary>
/// 重新定义表头,获取数据。重新插入【该方法主要解决 查出来的表字段。和所需要的表字段不一样,做特殊处理】
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetStandCostInfo(HttpContext context)
{
string TypeID = context.Request["TypeID"];//业态ID
DataTable dtJson = new DataTable();
dtJson.Columns.Add(new DataColumn("ItemSelected", typeof(string)));
dtJson.Columns.Add(new DataColumn("RegionalID", typeof(int)));
dtJson.Columns.Add(new DataColumn("RegionalName", typeof(string)));
dtJson.Columns.Add(new DataColumn("LineID", typeof(int)));
dtJson.Columns.Add(new DataColumn("LineName", typeof(string)));
dtJson.Columns.Add(new DataColumn("PurchasingID", typeof(int)));
dtJson.Columns.Add(new DataColumn("PurchasingName", typeof(string)));
dtJson.Columns.Add(new DataColumn("ProductTypeID", typeof(int)));
dtJson.Columns.Add(new DataColumn("ProductTypeName", typeof(string)));
dtJson.Columns.Add(new DataColumn("ArchitecturalStyleID", typeof(int)));
dtJson.Columns.Add(new DataColumn("ArchitecturalStyleName", typeof(string)));
dtJson.Columns.Add(new DataColumn("StandLine", typeof(string)));
string strSql = string.Format(@"select *from CF_test where TypeID={0}", TypeID);
using (DataAccessAdapter adp = new DataAccessAdapter())
{
LinqMetaData linq = new LinqMetaData(adp);
DataTable _dtStand = adp.GetDataTable(strSql);
foreach (DataRow drStand in _dtStand.Rows)
{
DataRow dr = dtJson.NewRow();
dr["ItemSelected"] = "";
dr["RegionalID"] = drStand["RegionalID"].ToInt();
dr["RegionalName"] = drStand["RegionalName"].ToString();
dr["LineID"] = drStand["ProductLineID"].ToInt();
dr["LineName"] = drStand["LineName"].ToString();
dr["PurchasingID"] = drStand["PurchasingID"].ToInt();
dr["PurchasingName"] = drStand["PurchasingName"].ToString();
dr["ProductTypeID"] = drStand["ProductTypeID"].ToInt();
dr["ProductTypeName"] = drStand["TypeName"].ToString();
dr["ArchitecturalStyleID"] = drStand["ArchitecturalStyleID"].ToInt();
dr["ArchitecturalStyleName"] = drStand["StyleName"].ToString();
dr["StandLine"] = drStand["StandLine"].ToString();
dr.EndEdit();
dtJson.Rows.Add(dr);
}
}
string JsonString = JsonConvert.SerializeObject(dtJson);
return JsonString;
}