/// <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") }); }