农业系统技术备忘

来源：互联网发布：安卓数据库sqlite 编辑：程序博客网时间：2024/04/28 22:02

（1）凭证查询

SELECT nw_Credence.Unit_id,
         nw_Credence.Account_id,
         nw_Credence.Credence_sn,
         nw_Credence.Credence_dt,
         nw_Credence.Credence_type,
         nw_Credence.Waste_dt,
         nw_Credence.Audit_dt,
         nw_Credence.Check_flg,
         nw_Credence.Accoutnant,
         nw_Credence.waster,
         nw_Credence.Chekouter,
         nw_Credence.Auditinger,
         nw_Credence.Imputer,
         nw_Credence.Appdend_num,
         nw_CredenceItem.Item_id,
         nw_CredenceItem.Abstract,
         nw_CredenceItem.Sub_id,
         nw_CredenceItem.Sub_content,
         nw_CredenceItem.Money,
         nw_CredenceItem.Direct,
         0.00   DMoney,
         0.00 LMoney ,
          ''   visible_tag,
            '' sub_name1,
            '' sub_name2
    FROM nw_Credence,
         nw_CredenceItem
   WHERE ( nw_Credence.Unit_id = nw_CredenceItem.Unit_id ) and
         ( nw_Credence.Credence_sn = nw_CredenceItem.Credence_sn )
       and((nw_Credence.credence_sn like '200812%0004') --0004代表第四联
    or (nw_Credence.credence_sn like '200812%0004')) --0004代表第四联
and nw_Credence.credence_dt >'2008-12-28'
and nw_Credence.credence_dt <='2009-12-29'
and nw_Credence.unit_id='3401021100011';

(2)科目表：

Nw_Subject

（3）年结：

SELECT End_Balance,end_Direct ,* FROM nw_SubBalance
    WHERE     Unit_ID='3401021100011'
        AND Sub_ID='407'
        AND this_Month=12
        AND this_Year=2008 ;