C# (CSharp) Model rp_t_accout_payrec_flow Examples

Example #1

        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);
        }

Example #2

File: CusSettle.cs Project: zanderphh/IvyBack_GuiZhou

        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);
        }