public List<PageWinOR> selectPageWinData(string orgbhWhere)
{
if (string.IsNullOrEmpty(orgbhWhere))
return null;
string sql = @"select bu.* from t_PageWin 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<PageWinOR> listPage = new List<PageWinOR>();
foreach (DataRow dr in dt.Rows)
{
PageWinOR obj = new PageWinOR(dr);
listPage.Add(obj);
}
return listPage;
}
/// <summary>
/// 获取插入数据
/// </summary>
public string GetInsertSql(PageWinOR pageWin)
{
string sql = @"insert into t_PageWin (Id,Name,Width,Height,orgBH)
values ('@Id','@Name',@Width,@Height,'@orgBH')";
sql = sql.Replace("@Id", pageWin.Id); //
sql = sql.Replace("@Name", pageWin.Name); //名称
sql = sql.Replace("@Width", pageWin.Width.ToString()); //宽
sql = sql.Replace("@Height", pageWin.Height.ToString()); //高
sql = sql.Replace("@orgBH", pageWin.Orgbh); //
return sql;
}
