public List<NearbyInfoOR> selectNearbyInfoData(string orgbhWhere) { if (string.IsNullOrEmpty(orgbhWhere)) return null; string sql = @"select bu.* from t_NearbyInfo bu inner join t_Bank b on b.orgbh= bu.orgbh where " + orgbhWhere; DataTable dt = null; try { dt = dbMsSql.ExecuteQuery(sql); } catch (Exception ex) { throw ex; } if (dt == null) return null; List<NearbyInfoOR> listNear = new List<NearbyInfoOR>(); foreach (DataRow dr in dt.Rows) { NearbyInfoOR obj = new NearbyInfoOR(dr); listNear.Add(obj); } return listNear; }
/// <summary> /// 获取插入数据 /// </summary> public string GetInsertSql(NearbyInfoOR nearbyInfo) { string sql = @"insert into t_NearbyInfo (Id,OrgBH,NearbyIndex,OrgNo,BankName, BankAddr,BusInfo,Flag,Description) values ('@Id','@OrgBH',NearbyIndex,OrgNo,'@BankName', '@BankAddr','@BusInfo',Flag,'@Description')"; sql = sql.Replace("@Id", nearbyInfo.Id); // sql = sql.Replace("@OrgBH", nearbyInfo.Orgbh); //所属机构 sql = sql.Replace("@NearbyIndex", nearbyInfo.Nearbyindex.ToString()); //网点编号(1-5) sql = sql.Replace("@OrgNo", nearbyInfo.Orgno.ToString()); //网点编号 sql = sql.Replace("@BankName", nearbyInfo.Bankname); //邻近网点名称 sql = sql.Replace("@BankAddr", nearbyInfo.Bankaddr); //邻近网点地址 sql = sql.Replace("@BusInfo", nearbyInfo.Businfo); //公交线路 sql = sql.Replace("@Flag", nearbyInfo.Flag.ToString()); //启用标记,1为启用,0为禁用 sql = sql.Replace("@Description", nearbyInfo.Description); //描述 return sql; }