/// <summary> /// 功能描述 : 根据所选城市代码和河流代码取得[tblEQIB_Section]表的地表水断面代码 /// 创建者 : Auto Generator /// 创建日期 : 2009-08-27 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="stcode">城市代码</param> /// <param name="rcode">河流代码</param> /// <returns>tblEQIB_Section</returns> public IList <tblEQIB_Section> GetRSCodeByRCode(string stcode, string rcode, int year) { try { DataTable tblData = new DataTable(); usp_tblEQIB_Section_GetRSCodeByRCode uspGetRSCode = new usp_tblEQIB_Section_GetRSCodeByRCode(); uspGetRSCode.fldSTCode = stcode; uspGetRSCode.fldRCode = rcode; uspGetRSCode.fldYear = year; tblData = uspGetRSCode.ExecDataTable(); if (tblData != null) { IList <tblEQIB_Section> listAll = new List <tblEQIB_Section>(); for (int i = 0; i < tblData.Rows.Count; i++) { DataTable tblTmp = tblData.Clone(); tblTmp.Rows.Add(tblData.Rows[i].ItemArray); tblEQIB_Section objData = new tblEQIB_Section(); objData.MetaDataTable = tblTmp; listAll.Add(objData); } tblData.Dispose(); return(listAll); } else { throw new Exception("取得记录失败,未找到对应的记录"); } } catch (DBOpenException e) { throw new GetByPKException("打开数据库连接失败", "RuletblEQIB_Section", "GetRSCodeByRCode", "stcode:" + stcode + ";rcode:" + rcode); } catch (DBQueryException e) { throw new GetByPKException("执行Sql语句失败", "RuletblEQIB_Section", "GetRSCodeByRCode", "stcode:" + stcode + ";rcode:" + rcode); } catch (Exception e) { throw new GetByPKException(e.Message, "RuletblEQIB_Section", "GetRSCodeByRCode", "stcode:" + stcode + ";rcode:" + rcode); } }
/// <summary> /// 功能描述 : 根据城市代码查询测点代码和名称,如果为空查找所有城市代码和名称 /// 创建者 : 马立军 /// 创建日期 : 2009-09-03 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="STCode">城市代码</param> /// <param name="strUserName">用户名</param> /// <param name="strPLevel">测点级别(-1为全部)</param> /// <returns>IList</returns> public IList <tblEQIB_Section> GetSTCodeOrPCode(string STCode, string strUserName, string strPLevel, int iInclude) { try { DataTable tblData = new DataTable(); usp_tblEQIB_Section_GetNameAndCode uspGetNameAndCode = new usp_tblEQIB_Section_GetNameAndCode(); uspGetNameAndCode.STCode = STCode; uspGetNameAndCode.UserName = strUserName; uspGetNameAndCode.PLevel = strPLevel; uspGetNameAndCode.Include = (iInclude == 1 ? true : false); tblData = uspGetNameAndCode.ExecDataTable(); if (tblData != null) { IList <tblEQIB_Section> listAll = new List <tblEQIB_Section>(); for (int i = 0; i < tblData.Rows.Count; i++) { DataTable tblTmp = tblData.Clone(); tblTmp.Rows.Add(tblData.Rows[i].ItemArray); tblEQIB_Section objData = new tblEQIB_Section(); objData.MetaDataTable = tblTmp; listAll.Add(objData); } tblData.Dispose(); return(listAll); } else { throw new Exception("取得记录失败,未找到对应的记录"); } } catch (DBOpenException e) { throw new GetListException("打开数据库连接失败", "RuletblEQIB_Section", "GetSTCodeOrPCode", "STCode:" + STCode + " UserName:"******"执行Sql语句失败", "RuletblEQIB_Section", "GetSTCodeOrPCode", "STCode:" + STCode + " UserName:"******"RuletblEQIB_Section", "GetSTCodeOrPCode", "STCode:" + STCode + " UserName:" + strUserName); } }