/// <summary>
/// 功能描述 ： 根据项目代码取得[tblEQIA_R_Item]表的部分记录
/// 创建者 ： 张浩
/// 创建日期 ： 2009-05-27
/// 修改者 ：
/// 修改日期 ：
/// 修改原因 ：
/// </summary>
/// <param name="iCode">项目代码</param>
/// <returns>tblEQIA_R_Item</returns>
public tblEQIA_R_Item ByItemCode(string iCode)
{
try
{
usp_tblEQIA_R_Item_ByItemCode uspByItemCode = new usp_tblEQIA_R_Item_ByItemCode();
uspByItemCode.fldItemCode = iCode;
DataTable tblData = uspByItemCode.ExecDataTable();
if (tblData != null)
{
tblEQIA_R_Item objData = new tblEQIA_R_Item();
objData.MetaDataTable = tblData;
return(objData);
}
else
{
throw new Exception("取得单条记录失败，未找到对应的记录");
}
}
catch (DBOpenException e)
{
throw new GetByPKException("打开数据库连接失败", "RuletblEQIA_R_Item", "ByItemCode", iCode);
}
catch (DBQueryException e)
{
throw new GetByPKException("执行Sql语句失败", "RuletblEQIA_R_Item", "ByItemCode", iCode);
}
catch (Exception e)
{
throw new GetByPKException(e.Message, "RuletblEQIA_R_Item", "ByItemCode", iCode);
}
}
public HttpResponseMessage GetOneHour_data(string vname, string btype, string strwhere)
{
string json = "[{data: ";
try
{
RuletblEQIW_R_HourData_Auto rules = new RuletblEQIW_R_HourData_Auto();
if (strwhere == null || strwhere == "undefind")
{
strwhere = ""
;
}
DataTable dt = rules.getOneHour_Data(vname, strwhere);
string sql1 = "select * from tblEQIW_R_Item_Auto";
DataTable tableitem = rule.getdt(sql1);
DataRow dr = dt.NewRow();
dr["fldSTName"] = "城市名称";
dr["fldRName"] = "河流名称";
dr["fldRSName"] = "断面名称";
dr["fldDate"] = "监测日期";
dr["fldTime"] = "监测时间";
for (int i = 6; i < dt.Columns.Count; i++)
{
DataRow[] dataRows = tableitem.Select("fldItemCode='" + dt.Columns[i].ToString().Substring(3) + "'");
if (dataRows.Length > 0)
{
dr[dt.Columns[i].ToString()] = dataRows[0]["fldUnit"].ToString();
}
}
dt.Rows.InsertAt(dr, 0);
string jsondt = JsonHelper.SerializeObject(dt);
json += jsondt;
#region 拼数据对应列名
json += ",head: [";
RuletblEQIA_R_Item itemnames = new RuletblEQIA_R_Item();
//拼标题并汉化
for (int i = 0; i < dt.Columns.Count; i++)
{
string engname = "'" + dt.Columns[i].ColumnName + "'";
DataTable dtDesc = rule.ChinesizeTitleNamebyViewName(vname, engname);//根据视图名称在字典表中查出对应字段的中文名称
if (dtDesc.Rows.Count > 0)
{
if (i == dt.Columns.Count - 1)
{
json += "'" + dtDesc.Rows[0]["fldFieldDesc"].ToString() + "']}]";
}
else
{
json += "'" + dtDesc.Rows[0]["fldFieldDesc"].ToString() + "',";
}
}
else
{
string itemcode = dt.Columns[i].ColumnName.Substring(3);
tblEQIA_R_Item name = itemnames.ByItemCodes(itemcode, btype, "");
if (i == dt.Columns.Count - 1)
{
//最后一列的时候添加“]”↓
json += "'" + name.fldItemName + "']}]";
}
else
{
json += "'" + name.fldItemName + "',";
}
}
}
#endregion
if (dt.Rows.Count > 0)
{
json = rule.JsonStr("ok", "", json.ToString());//有数据
}
else
{
json = rule.JsonStr("nodata", "没有数据", json.ToString());//没数据
}
}
catch (Exception e)
{
json = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json")
});
}
