public DataTable GetAccountFlows(Model.rp_t_accout_payrec_flow flow) { JsonRequest r = new JsonRequest(); r.Write <rp_t_accout_payrec_flow>("flow", flow); r.request("/cus_settle?t=GetAccountFlows"); if (!r.ReadSuccess()) { throw new Exception(r.ReadMessage()); } DataTable tb = r.GetDataTable(); return(tb); }
public DataTable GetAccountFlows(Model.rp_t_accout_payrec_flow flow) { DB.IDB db = new DB.DBByAutoClose(Appsetting.conn); string sql = @"select *,isnull(p.paid_amount,0.00) 已付金额,isnull(p.free_money,0.00) 已免付金额 from rp_t_accout_payrec_flow p where (p.paid_amount+p.free_money)<p.sheet_amount and p.supcust_no='@supcust_no' and p.supcust_flag='@supcust_flag' " .Replace("@supcust_flag", flow.supcust_flag) .Replace("@supcust_no", flow.supcust_no); sql += " order by p.oper_date "; var tb = db.ExecuteToTable(sql, null); return(tb); }