//和下面重名 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()); }