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;
}
