U8API——向U8数据库表导入数据

一、打开API资源管理器

替换两个引用

打开应用实例，选择相应的功能

复制相应的封装类到自己的目录下

在数据库新建临时表，与目标表相同

 

数据导入：

思路：先将要导入的数据导入到与U8目标表相同的临时表，再用API从临时表导入到U8目标表

//导入临时表-产成品入库、销售发货
        public void ImportU8RdDis()
        {
            lb_info.Items.Add(DateTime.Now + "  生成开始.....");
            lb_state.Text = "当前状态：正在生成数据，请勿操作...";

            //从过磅记录表里查询所有未导入U8数据库的记录
            List<ShippingInquiries> siListRdrecord = new List<ShippingInquiries>();
            siListRdrecord = u8api.SelectAllNOu8Rdrecord10();
            List<ShippingInquiries> siListSales = new List<ShippingInquiries>();
            siListSales = u8api.SelectAllNOu8Sales();

            //将榜单数据中未进行推送的数据，送到临时表，并执行导入U8
            u8api.DeleteTemporaryTable();//插入临时表前清空之前的记录
            //产成品入库
            foreach (ShippingInquiries si in siListRdrecord)
            {
                int i = u8api.InsertU8Rdrecord10(si);//导入临时表
                if (i > 0)
                {
                    lb_info.Items.Add(DateTime.Now + "  正在生成过磅单的U8 <产成品> 单据,磅单编号为:" + si.NO);
                    bool ok_Rdrecord = U8Rdrecord10(i);//从临时表导入U8
                    if (ok_Rdrecord)
                    {
                        lb_info.Items.Add(DateTime.Now + "  磅单编号为:" + si.NO + "单据，生单成功");
                        u8api.UpdateToU8State(si.NO);
                    }
                    else
                    {
                        lb_info.Items.Add(DateTime.Now + "  磅单编号为:" + si.NO + "单据，生单失败！");
                    }
                }
            }
            //发货单
            foreach (ShippingInquiries si in siListSales)
            {
                int i = u8api.InsertU8Sales(si);//导入临时表
                if (i > 0)
                {
                    lb_info.Items.Add(DateTime.Now + "  正在生成过磅单的U8 <发货单> 单据,磅单编号为:" + si.NO);
                    bool ok_Sales = U8Sales(i);//从临时表导入U8
                    if(ok_Sales)
                    {
                        lb_info.Items.Add(DateTime.Now + "  磅单编号为:" + si.NO + "单据，生单成功");
                        u8api.UpdateToU8State(si.NO);
                    }
                    else
                    {
                        lb_info.Items.Add(DateTime.Now + "  磅单编号为:" + si.NO + "单据，生单失败！");
                    }
                }
            }
            lb_info.Items.Add(DateTime.Now + "  生成结束");
            lb_state.Text = "当前状态：生成数据完成，等待下一次生成开始";
        }

先导入临时表，再导入U8

导入临时表代码

//将数据导入临时表-发货单表
        public int InsertU8Sales(ShippingInquiries si)
        {
            int i = 0;
            conn.Open();
            try
            {
                cmd.CommandText = "insert into TWKF_Sales_T(ivouchstate,csysbarcode,bsaleoutcreatebill,cbustype,ivtid,cdlcode,cvouchtype,cvouchname,cstcode,cstname,ddate,cdepcode,cdepname,ccuscode,ccusabbname,cexch_name,iexchrate,itaxrate,cdefine1,cDefine2,breturnflag,cverifier,cmaker,icuscreline,bfirst,sbvid,dverifydate,isale,ccusname,clastcusname,clastcustname,cauthid,brequestsign,iflowid,billafterlosssettle,bcusinvlimited,bbillbluesalelist,bbillredsalelist,bcredit,bcreditdate,bmustbook,ccreditcuscode,ccreditcusname,ioutgolden,iverifystate,iswfcontrolled,dcreatesystime,dverifysystime,bcashsale,bsigncreate,bneedbill,iprintcount,cinvoicecompany,cinvoicecompanyabbname,baccswitchflag,ccccode,bcal,zdsum,linenum,bnottogoldtax) values(@ivouchstate,@csysbarcode,@bsaleoutcreatebill,@cbustype,@ivtid,@cdlcode,@cvouchtype,@cvouchname,@cstcode,@cstname,@ddate,@cdepcode,@cdepname,@ccuscode,@ccusabbname,@cexch_name,@iexchrate,@itaxrate,@cdefine1,@cDefine2,@breturnflag,@cverifier,@cmaker,@icuscreline,@bfirst,@sbvid,@dverifydate,@isale,@ccusname,@clastcusname,@clastcustname,@cauthid,@brequestsign,@iflowid,@billafterlosssettle,@bcusinvlimited,@bbillbluesalelist,@bbillredsalelist,@bcredit,@bcreditdate,@bmustbook,@ccreditcuscode,@ccreditcusname,@ioutgolden,@iverifystate,@iswfcontrolled,@dcreatesystime,@dverifysystime,@bcashsale,@bsigncreate,@bneedbill,@iprintcount,@cinvoicecompany,@cinvoicecompanyabbname,@baccswitchflag,@ccccode,@bcal,@zdsum,@linenum,@bnottogoldtax);select @@IDENTITY;";
                cmd.Parameters.Clear();
                cmd.Parameters.Add("@ivouchstate", "Approved");//单据状态
                cmd.Parameters.Add("@csysbarcode", "||SA01|0000000001");//单据条码
                cmd.Parameters.Add("@bsaleoutcreatebill","0");//销售出库开票标识
                cmd.Parameters.Add("@cbustype", "普通销售");//业务类型 
                cmd.Parameters.Add("@ivtid", "71");//单据模版号
                cmd.Parameters.Add("@cdlcode", "0000000001");//发货退货单号
                cmd.Parameters.Add("@cvouchtype", "05");//单据类型编码
                cmd.Parameters.Add("@cvouchname", "发货单");//单据类型名称
                cmd.Parameters.Add("@cstcode", "1");//销售类型编码
                cmd.Parameters.Add("@cstname", "西坡石厂销售");//销售类型名称
                cmd.Parameters.Add("@ddate", si.GrossWeightTime);//单据日期 
                cmd.Parameters.Add("@cdepcode", si.cInvCode.Substring(0, 2));//部门编码
                cmd.Parameters.Add("@cdepname", "总经办");//部门名称//通过哪个表由部门编码查询部门名称▲▲▲▲▲▲▲▲
                cmd.Parameters.Add("@ccuscode", si.cCusCode);//客户编码
                cmd.Parameters.Add("@ccusabbname", si.ReceivingUnit);//客户简称
                cmd.Parameters.Add("@cexch_name", "人民币");//币种名称
                cmd.Parameters.Add("@iexchrate", "1");//汇率
                cmd.Parameters.Add("@itaxrate", "0");//表头税率
                cmd.Parameters.Add("@cDefine1", si.ReceivingUnit);//收货单位
                cmd.Parameters.Add("@cDefine2", si.NO);//榜单单号
                cmd.Parameters.Add("@breturnflag", "0");//退货标志
                cmd.Parameters.Add("@cverifier", "demo");//审核人
                cmd.Parameters.Add("@cmaker", "demo");//制单人
                cmd.Parameters.Add("@icuscreline", "0");//信用额度 
                cmd.Parameters.Add("@bfirst", "0");//销售期初标志
                cmd.Parameters.Add("@sbvid", "0");//销售发票主表标识 
                cmd.Parameters.Add("@dverifydate