//和下面重名
public object GetBill_Bak(BILLEntity Data)
{
string sql = " SELECT A.BILLID,A.BRANCHID,A.MERCHANTID,A.CONTRACTID,A.TERMID,A.NIANYUE,A.YEARMONTH,A.MUST_MONEY "
+ " ,A.RECEIVE_MONEY,A.RRETURN_MONEY,A.START_DATE, A.END_DATE,A.TYPE,A.STATUS,A.DESCRIPTION,B.NAME FEENAME"
+ " FROM BILL A,FeeSubject B " +
" WHERE A.TRIMID= B.TRIMID";
if (!Data.BILLID.IsEmpty())
{
sql += " AND A.BILLID='" + Data.BILLID + "'";
}
if (!Data.BRANCHID.IsEmpty())
{
sql += " AND A.BRANCHID=" + Data.BRANCHID + "";
}
DataTable dt = DbHelper.ExecuteTable(sql);
return(new
{
dt = dt.ToOneLine()
});
}
public UIResult GetBill(BILLEntity Data)
{
//return new UIResult(service.DataService.GetBill(Data));
return(new UIResult());
}
