//商户收费单位余额
public object GetBalance(MERCHANT_ACCOUNTEntity Data)
{
string sql = @" SELECT * FROM MERCHANT_ACCOUNT WHERE 1=1";
if (!Data.MERCHANTID.IsEmpty())
{
sql += " AND MERCHANTID='" + Data.MERCHANTID + "'";
}
if (!Data.FEE_ACCOUNT_ID.IsEmpty())
{
sql += " AND FEE_ACCOUNT_ID='" + Data.FEE_ACCOUNT_ID + "'";
}
DataTable dt = DbHelper.ExecuteTable(sql);
return(new
{
dt = dt.ToOneLine()
});
}
public UIResult SearchBalance(MERCHANT_ACCOUNTEntity Data)
{
return(new UIResult(service.DataService.GetBalance(Data)));
}
