コード例 #1
0
        DataTable ICommonBLL.GetPeopleList()
        {
            ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
            w.Append("page_index", "1");
            w.Append("page_size", "10000");
            w.Append("dep_no", "");
            w.Append("show_stop", "0");
            w.Append("keyword", "");

            Helper.IRequest req  = new Helper.Request();
            var             json = req.request("/people?t=get_list", w.ToString());

            ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
            if (r.Read("errId") != "0")
            {
                throw new Exception(r.Read("errMsg"));
            }
            else
            {
                if (r.Read("data").Length < 10)
                {
                    return(new DataTable());
                }
                IBLL.ICommonBLL bll = new BLL.CommonBLL();
                var             tb  = bll.GetDataTable(r.ReadList("data"));
                return(tb);
            }
        }
コード例 #2
0
        DataTable IBLL.IInOutBLL.GetOtherInOutList(DateTime date1, DateTime date2, string trans_no)
        {
            ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
            w.Append("date1", date1.ToString("yyyy-MM-dd"));
            w.Append("date2", date2.ToString("yyyy-MM-dd"));
            w.Append("trans_no", trans_no);
            Helper.IRequest req  = new Helper.Request();
            var             json = req.request("/inout?t=get_other_inout_list", w.ToString());

            ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
            if (r.Read("errId") != "0")
            {
                throw new Exception(r.Read("errMsg"));
            }
            else
            {
                if (r.Read("data").Length < 10)
                {
                    return(new DataTable());
                }
                IBLL.ICommonBLL bll = new BLL.CommonBLL();
                var             tb  = bll.GetDataTable(r.ReadList("data"));

                return(tb);
            }
        }
コード例 #3
0
        private void frmStockPDList_Load(object sender, EventArgs e)
        {
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //

                IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                this.txtBranch.Bind(bll2.GetBranchList(), 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");

                //
                this.dgv.AddColumn("check_status", "状态", "", 100, 1, "{0:开始盘点}");
                this.dgv.AddColumn("sheet_no", "单号", "", 110, 1, "");
                this.dgv.AddColumn("仓库", "仓库", "", 110, 1, "");
                this.dgv.AddColumn("商品类别", "商品类别", "", 100, 1, "");
                this.dgv.AddColumn("操作员", "操作员", "", 100, 1, "");
                this.dgv.AddColumn("begin_date", "起始日期", "", 100, 1, "yyyy-MM-dd");
                this.dgv.AddColumn("memo", "备注", "", 150, 1, "");
                this.dgv.MergeCell = false;

                this.txtStartTime.Text = DateTime.Now.ToString("yyyy-MM-dd");
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmCGInSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #4
0
        private void LoadTv()
        {
            string keyword = txtKeyword.Text.Trim();
            Thread th      = new Thread(() =>
            {
                Helper.GlobalData.windows.ShowLoad(this);
                try
                {
                    IBLL.ICommonBLL bll = new BLL.CommonBLL();
                    sup_list            = bll.GetSupList(keyword);
                    this.Invoke((MethodInvoker) delegate
                    {
                        Cursor.Current = Cursors.WaitCursor;

                        this.tv.Nodes.Clear();

                        TreeNode tn = new TreeNode("货商信息");

                        tn.Tag = "";
                        this.tv.Nodes.Add(tn);
                        LoadTreeView();

                        Cursor.Current = Cursors.Default;
                    });
                }
                catch (Exception ex)
                {
                    LogHelper.writeLog("SysSetting_Load", ex.ToString());
                    MsgForm.ShowFrom(ex);
                }
                Helper.GlobalData.windows.CloseLoad(this);
            });

            th.Start();
        }
コード例 #5
0
        System.Data.DataTable IBLL.ICusPriceOrder.GetList(DateTime date1, DateTime date2)
        {
            ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
            w.Append("date1", date1.ToString("yyyy-MM-dd"));
            w.Append("date2", date2.ToString("yyyy-MM-dd"));
            Helper.IRequest req  = new Helper.Request();
            var             json = req.request("/cus_price_order?t=get_list", w.ToString());

            ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
            if (r.Read("errId") != "0")
            {
                throw new Exception(r.Read("errMsg"));
            }
            else
            {
                if (r.Read("data").Length < 10)
                {
                    return(new DataTable());
                }
                IBLL.ICommonBLL bll = new BLL.CommonBLL();
                var             tb  = bll.GetDataTable(r.ReadList("data"));

                return(tb);
            }
        }
コード例 #6
0
        public frmCGOutSheetList()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            dataGrid1.AddColumn("approve_flag", "生效", "", 60, 2, "{0:,1:√}");
            dataGrid1.AddColumn("trans_no", "单据类型", "", 90, 2, "{A:进货入库,D:退货入库,F:退货出库}");
            dataGrid1.AddColumn("sale_no", "经销方式", "", 90, 2, "{A:购销,B:代销,C:联营,E:联营进货,Z:租赁}");
            dataGrid1.AddColumn("sheet_no", "退货单号", "", 120, 1, "");
            dataGrid1.AddColumn("branch_name", "仓库", "", 120, 1, "");
            dataGrid1.AddColumn("supcust_no", "供应商", "", 80, 2, "");
            dataGrid1.AddColumn("sup_name", "货商名称", "", 150, 1, "");
            dataGrid1.AddColumn("total_amount", "单据总金额", "", 90, 3, "0.00");
            dataGrid1.AddColumn("deal_man_name", "经办人", "", 80, 1, "");
            dataGrid1.AddColumn("old_no", "内部单号", "", 120, 1, "");
            dataGrid1.AddColumn("voucher_no", "入库单号", "", 90, 1, "");
            dataGrid1.AddColumn("oper_name", "操作员", "", 90, 1, "");
            dataGrid1.AddColumn("oper_date", "操作日期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("approve_man_name", "审核人", "", 100, 1, "");
            dataGrid1.AddColumn("approve_date", "审核日期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("pay_date", "限收款日", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("other1", "备注1", "", 200, 1, "");
            dataGrid1.AddColumn("other3", "备注", "", 200, 1, "");
            this.dataGrid1.DataSource = new DataTable();
            //
            dataGrid2.AddColumn("item_subno", "货号", "", 120, 1, "");
            dataGrid2.AddColumn("item_name", "商品名称", "", 150, 1, "");
            dataGrid2.AddColumn("unit_no", "单位", "", 60, 2, "{0:否,1:是}");
            dataGrid2.AddColumn("item_size", "规格", "", 80, 2, "");
            dataGrid2.AddColumn("in_qty", "数量", "", 100, 3, "");
            dataGrid2.AddColumn("valid_price", "单价", "", 100, 3, "0.00");
            //dataGrid2.AddColumn("discount", "折扣", "", 100, 3, "0.00");
            dataGrid2.AddColumn("sub_amount", "金额", "", 100, 3, "0.00");
            //dataGrid2.AddColumn("", "特价", "", 100, 3, "0.00");
            dataGrid2.AddColumn("other1", "备注", "", 200, 1, "");
            //dataGrid2.AddColumn("", "生产批号", "", 200, 1, "");
            //dataGrid2.AddColumn("valid_date", "有效期", "", 100, 1, "yyyy-MM-dd");
            //dataGrid2.AddColumn("", "库位", "", 120, 1, "");
            dataGrid2.AddColumn("price", "参考进价", "", 100, 3, "0.00");
            this.dataGrid2.DataSource = new DataTable();
            //
            this.dateTextBox1.Text = System.DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
            this.dateTextBox2.Text = System.DateTime.Now.ToString("yyyy-MM-dd");

            IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
            txt_sup_id.Bind(bll2.GetAllSupList(), 250, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
        }
コード例 #7
0
        public frmSaleSheetList()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            dataGrid1.AddColumn("approve_flag", "生效", "", 60, 2, "{0:,1:√}");
            dataGrid1.AddColumn("sheet_no", "销售单号", "", 120, 1, "");
            dataGrid1.AddColumn("branch_name", "仓库", "", 120, 1, "");
            dataGrid1.AddColumn("sup_name", "客户", "", 120, 1, "");
            dataGrid1.AddColumn("voucher_no", "订单号", "", 120, 1, "");
            dataGrid1.AddColumn("total_amount", "订单金额", "", 90, 3, "0.00");
            dataGrid1.AddColumn("sale_man_name", "业务员", "", 80, 1, "");
            dataGrid1.AddColumn("total_amount", "单据金额", "", 90, 3, "0.00");
            dataGrid1.AddColumn("real_amount", "折后金额", "", 90, 3, "0.00");
            dataGrid1.AddColumn("pay_date", "结账日期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("oper_date", "日期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("oper_name", "操作员", "", 90, 1, "");
            dataGrid1.AddColumn("approve_date", "审核日期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("approve_man_name", "审核人", "", 100, 1, "");
            dataGrid1.AddColumn("coin_no", "币种", "", 60, 1, "");
            dataGrid1.AddColumn("payfee_memo", "备注", "", 200, 1, "");
            this.dataGrid1.DataSource = new DataTable();
            //
            dataGrid2.AddColumn("item_subno", "货号", "", 120, 1, "");
            dataGrid2.AddColumn("barcode", "条码", "", 120, 1, "");
            dataGrid2.AddColumn("item_name", "商品名称", "", 150, 1, "");
            dataGrid2.AddColumn("other3", "赠送", "", 60, 2, "{0:否,1:是}");
            dataGrid2.AddColumn("unit_no", "单位", "", 60, 2, "");
            dataGrid2.AddColumn("sale_qnty", "数量", "", 100, 3, "");
            dataGrid2.AddColumn("real_price", "实际价", "", 100, 3, "0.00");
            dataGrid2.AddColumn("sale_money", "实际金额", "", 100, 3, "0.00");
            dataGrid2.AddColumn("other5", "备注明细", "", 200, 1, "");
            this.dataGrid2.DataSource = new DataTable();

            //
            this.dateTextBox1.Text = System.DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
            this.dateTextBox2.Text = System.DateTime.Now.ToString("yyyy-MM-dd");

            IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
            var             tb   = bll2.GetAllCustList();

            txt_cust_id.Bind(tb, 250, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
        }
コード例 #8
0
        private void FindServer()
        {
            Thread th = new Thread(() =>
            {
                try
                {
                    AutoResetEvent myEvent = new AutoResetEvent(false);

                    StringBuilder ls_ip = new StringBuilder(1024);
                    IvyGetValue.GetIP(ls_ip);
                    int ll_len = IvyGetValue.F_0001_0016(ls_ip);
                    StringBuilder ls_computers = new StringBuilder(ll_len);
                    IvyGetValue.F_0001_0017(ls_computers); //返回 ip + (tab) + 机器名,多部机分多行
                    ips = ls_computers.ToString().Split(',');

                    foreach (string ip in ips)
                    {
                        IBLL.ICommonBLL bll = new BLL.CommonBLL();
                        string isServer     = bll.IsServer(ips[cycleIndex], "8383");

                        if (isServer.Equals("1"))
                        {
                            //成功
                            Helper.Appsetting.ip   = ips[cycleIndex];
                            Helper.Appsetting.port = "8383";

                            this.Invoke((MethodInvoker) delegate
                            {
                                this.Close();
                            });
                        }
                    }
                }
                catch (Exception e)
                {
                    Helper.LogHelper.writeLog("findServer", e.ToString());
                    MsgForm.ShowFrom(e);
                    Application.Exit();
                }
            });

            th.IsBackground = true;
            th.Start();
        }
コード例 #9
0
        public frmSaleSSSheetList()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            dataGrid1.AddColumn("approve_flag", "生效", "", 60, 2, "{0:,1:√}");
            dataGrid1.AddColumn("sheet_no", "单据号", "", 120, 1, "");
            dataGrid1.AddColumn("branch_name", "仓库", "", 120, 1, "");
            dataGrid1.AddColumn("sup_name", "客户", "", 120, 1, "");
            dataGrid1.AddColumn("total_amount", "金额", "", 90, 3, "0.00");
            dataGrid1.AddColumn("order_man_name", "业务员", "", 80, 1, "");
            dataGrid1.AddColumn("oper_date", "订单日期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("valid_date", "有效期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("oper_name", "操作员", "", 90, 1, "");
            dataGrid1.AddColumn("approve_date", "审核日期", "", 100, 1, "yyyy-MM-dd");
            dataGrid1.AddColumn("approve_man_name", "审核人", "", 100, 1, "");
            dataGrid1.AddColumn("memo", "备注", "", 200, 1, "");
            dataGrid1.AddColumn("other2", "备注2", "", 200, 1, "");
            this.dataGrid1.DataSource = new DataTable();
            //
            dataGrid2.AddColumn("item_subno", "货号", "", 120, 1, "");
            dataGrid2.AddColumn("barcode", "条码", "", 120, 1, "");
            dataGrid2.AddColumn("item_name", "商品名称", "", 150, 1, "");
            dataGrid2.AddColumn("unit_no", "单位", "", 60, 2, "");
            dataGrid2.AddColumn("item_size", "规格", "", 60, 2, "");
            dataGrid2.AddColumn("order_qnty", "数量", "", 100, 3, "");
            dataGrid2.AddColumn("in_price", "价格", "", 100, 3, "0.00");
            dataGrid2.AddColumn("sub_amount", "金额", "", 100, 3, "0.00");
            dataGrid2.AddColumn("other1", "备注明细", "", 200, 1, "");
            this.dataGrid2.DataSource = new DataTable();

            //
            this.dateTextBox1.Text = System.DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
            this.dateTextBox2.Text = System.DateTime.Now.ToString("yyyy-MM-dd");

            IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
            var             tb   = bll2.GetAllCustList();

            txt_sup_id.Bind(tb, 250, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
        }
コード例 #10
0
        DataTable IBLL.ICheckBLL.GetCheckInitList()
        {
            Helper.IRequest req  = new Helper.Request();
            var             json = req.request("/check?t=get_check_init_list", "");

            ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
            if (r.Read("errId") != "0")
            {
                throw new Exception(r.Read("errMsg"));
            }
            else
            {
                if (r.Read("data").Length < 10)
                {
                    return(new DataTable());
                }
                IBLL.ICommonBLL bll = new BLL.CommonBLL();
                var             tb  = bll.GetDataTable(r.ReadList("data"));

                return(tb);
            }
        }
コード例 #11
0
        private void frmStockInit_Load(object sender, EventArgs e)
        {
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //

                IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                this.txtBranch.Bind(bll2.GetBranchList(), 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                IBLL.IItemCls clsbll = new BLL.ItemClsBLL();
                this.txtItemCls.Bind(clsbll.GetDataTable(), 250, 200, "item_clsno", "item_clsno:分类编号:80,item_clsname:商品分类:170", "item_clsno/item_clsname->Text");
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmCGInSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #12
0
        DataTable ICommonBLL.GetBranchList()
        {
            ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
            w.Append("code_len", "4");
            Helper.IRequest req  = new Helper.Request();
            var             json = req.request("/branch?t=get_list", w.ToString());

            ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
            if (r.Read("errId") != "0")
            {
                throw new Exception(r.Read("errMsg"));
            }
            else
            {
                if (r.Read("data").Length < 10)
                {
                    return(new DataTable());
                }
                IBLL.ICommonBLL bll = new BLL.CommonBLL();
                var             tb  = bll.GetDataTable(r.ReadList("data"));
                return(tb);
            }
        }
コード例 #13
0
        void IBLL.IInOutBLL.GetOtherInOut(string sheet_no, out DataTable tb1, out DataTable tb2)
        {
            ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
            w.Append("sheet_no", sheet_no);
            Helper.IRequest req  = new Helper.Request();
            var             json = req.request("/inout?t=get_other_inout", w.ToString());

            ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
            if (r.Read("errId") != "0")
            {
                throw new Exception(r.Read("errMsg"));
            }
            else
            {
                if (r.Read("tb1").Length < 10)
                {
                    throw new Exception("不存在单据!");
                }
                IBLL.ICommonBLL bll = new BLL.CommonBLL();
                tb1 = bll.GetDataTable(r.ReadList("tb1"));
                tb2 = bll.GetDataTable(r.ReadList("tb2"));
            }
        }
コード例 #14
0
        DataTable IBLL.ICheckBLL.GetBranchStockList(string branch_no)
        {
            Helper.IRequest req = new Helper.Request();
            ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
            w.Append("branch_no", branch_no);
            var json = req.request("/check?t=get_branch_stock_list", w.ToString());

            ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(json);
            if (r.Read("errId") != "0")
            {
                throw new Exception(r.Read("errMsg"));
            }
            else
            {
                if (r.Read("data").Length < 10)
                {
                    return(new DataTable());
                }
                IBLL.ICommonBLL bll = new BLL.CommonBLL();
                var             tb  = bll.GetDataTable(r.ReadList("data"));

                return(tb);
            }
        }
コード例 #15
0
        public frmSaleSheet()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("other3");
            tb.Columns.Add("sale_qnty", typeof(decimal));
            tb.Columns.Add("real_price", typeof(decimal));
            tb.Columns.Add("sale_money", typeof(decimal));
            tb.Columns.Add("other5");

            editGrid1.AddColumn("item_subno", "货号", "", 120, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("other3", "赠送", "", 60, 2, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("sale_qnty", "数量", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("real_price", "实际价", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("sale_money", "实际金额", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("other5", "备注明细", "", 150, 1, "", true);

            editGrid1.SetTotalColumn("sale_qnty,sale_money");//合计项
            editGrid1.DataSource = tb;
            editGrid1.BindCheck("other3");
            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //

                System.Threading.Thread th = new System.Threading.Thread(() =>
                {
                    Cursor.Current = Cursors.WaitCursor;
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        IBLL.ICommonBLL bll2 = new BLL.CommonBLL();

                        var branch = bll2.GetBranchList();
                        this.txtbranch.Invoke((MethodInvoker) delegate
                        {
                            txtbranch.Bind(branch, 300, 200, "branch_no", "branch_no:机构号:80,branch_name:机构名:140", "branch_no/branch_name->Text");
                        });

                        var sale = bll2.GetPeopleList();
                        this.txt_sale_man.Invoke((MethodInvoker) delegate
                        {
                            txt_sale_man.Bind(sale, 250, 200, "oper_id", "oper_id:职员编号:80,oper_name:姓名:80", "oper_id/oper_name->Text");
                        });

                        var cust = bll2.GetAllCustList();
                        this.txt_cust.Invoke((MethodInvoker) delegate
                        {
                            txt_cust.Bind(cust, 350, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
                        });

                        IBLL.IInOutBLL bll3 = new BLL.InOutBLL();
                        var order           = bll3.GetImportSSSheet();
                        this.txt_voucher_no.Invoke((MethodInvoker) delegate
                        {
                            this.txt_voucher_no.Bind(order, 350, 200, "sheet_no", "sheet_no:单据号:110,supcust:客户:100,branch:仓库:100,oper_date:日期:150", "sheet_no->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        IvyBack.Helper.LogHelper.writeLog("frmSaleSheet", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Cursor.Current = Cursors.Default;
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmSaleSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #16
0
        public frmOtherInOutSheet()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("other3");
            tb.Columns.Add("stock_qty", typeof(decimal));
            tb.Columns.Add("in_qty", typeof(decimal));
            tb.Columns.Add("valid_price", typeof(decimal));
            tb.Columns.Add("discount", typeof(decimal));
            tb.Columns.Add("sub_amount", typeof(decimal));
            tb.Columns.Add("other1");
            tb.Columns.Add("valid_date", typeof(DateTime));
            tb.Columns.Add("price", typeof(decimal));//参考进价

            editGrid1.AddColumn("item_subno", "货号", "", 100, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 80, 1, "", false);
            editGrid1.AddColumn("stock_qty", "库存", "", 80, 3, "0.00", false);
            editGrid1.AddColumn("in_qty", "数量", "", 80, 3, "0.00", true);
            editGrid1.AddColumn("valid_price", "单价", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("sub_amount", "金额", "", 100, 3, "0.00", false);
            //editGrid1.AddColumn("", "特价", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("other1", "备注", "", 150, 1, "", true);
            //editGrid1.AddColumn("", "生产批号", "", 120, 3, "0.00", true);
            //editGrid1.AddColumn("", "库位", "", 120, 3, "0.00", true);
            editGrid1.AddColumn("price", "参考进价", "", 100, 3, "0.00", false);
            editGrid1.SetTotalColumn("in_qty,sub_amount");//合计项
            editGrid1.DataSource = tb;

            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //

                System.Threading.Thread th = new System.Threading.Thread(() =>
                {
                    Cursor.Current = Cursors.WaitCursor;
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                        //
                        var branch = bll2.GetBranchList();

                        this.txtbranch.Invoke((MethodInvoker) delegate
                        {
                            txtbranch.Bind(branch, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                        });
                        DataTable dt2 = new DataTable();
                        dt2.Columns.Add("trans_no");
                        dt2.Columns.Add("trans_name");
                        dt2.Rows.Add("01", "其它入库");
                        dt2.Rows.Add("02", "归还");
                        dt2.Rows.Add("03", "其它出库");
                        dt2.Rows.Add("04", "领用出库");
                        dt2.Rows.Add("05", "报损出库");
                        dt2.Rows.Add("06", "借出");
                        dt2.Rows.Add("07", "报溢入库");
                        dt2.Rows.Add("09", "库存调整");

                        this.txt_trans_no.Invoke((MethodInvoker) delegate
                        {
                            txt_trans_no.Bind(dt2, 250, 200, "trans_no", "trans_no:编码:80,trans_name:业务类型:100", "trans_no/trans_name->Text");
                        });

                        var deal = bll2.GetPeopleList();
                        this.txt_deal_man.Invoke((MethodInvoker) delegate
                        {
                            txt_deal_man.Bind(deal, 250, 200, "oper_id", "oper_id:编号:80,oper_name:姓名:100", "oper_id/oper_name->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        IvyBack.Helper.LogHelper.writeLog("frmOtherInOutSheet", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Cursor.Current = Cursors.Default;
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmOtherInOutSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #17
0
        public frmSaleInSheet()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("in_qty", typeof(decimal));
            tb.Columns.Add("valid_price", typeof(decimal));
            tb.Columns.Add("sub_amount", typeof(decimal));
            tb.Columns.Add("other1");
            tb.Columns.Add("valid_date", typeof(DateTime));
            tb.Columns.Add("price", typeof(decimal));//参考进价

            editGrid1.AddColumn("item_subno", "货号", "", 100, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 80, 1, "", false);
            editGrid1.AddColumn("in_qty", "数量", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("valid_price", "单价", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("sub_amount", "金额", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("other1", "备注", "", 150, 1, "", true);
            editGrid1.AddColumn("price", "参考进价", "", 100, 3, "0.00", false);
            editGrid1.SetTotalColumn("in_qty,sub_amount");//合计项
            editGrid1.DataSource = tb;

            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //


                System.Threading.Thread th = new System.Threading.Thread(() =>
                {
                    Cursor.Current = Cursors.WaitCursor;
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        IBLL.ICommonBLL bll2 = new BLL.CommonBLL();

                        var branch = bll2.GetBranchList();
                        this.txtbranch.Invoke((MethodInvoker) delegate
                        {
                            txtbranch.Bind(branch, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                        });

                        var cust = bll2.GetAllCustList();
                        this.txt_cust.Invoke((MethodInvoker) delegate
                        {
                            txt_cust.Bind(cust, 350, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
                        });

                        var deal = bll2.GetPeopleList();
                        this.txt_deal_man.Invoke((MethodInvoker) delegate
                        {
                            txt_deal_man.Bind(deal, 250, 200, "oper_id", "oper_id:编号:80,oper_name:姓名:100", "oper_id/oper_name->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        IvyBack.Helper.LogHelper.writeLog("frmSaleInSheet", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Cursor.Current = Cursors.Default;
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmSaleInSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #18
0
        public frmCGOrder()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("order_qnty", typeof(decimal));
            tb.Columns.Add("in_price", typeof(decimal));
            tb.Columns.Add("discount", typeof(decimal));
            tb.Columns.Add("sub_amount", typeof(decimal));
            tb.Columns.Add("other1");

            editGrid1.AddColumn("item_subno", "货号", "", 120, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 60, 2, "", false);
            editGrid1.AddColumn("order_qnty", "总数量", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("in_price", "单价", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("discount", "折扣", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("sub_amount", "金额", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("other1", "备注", "", 150, 1, "", true);
            editGrid1.SetTotalColumn("order_qnty,sub_amount");//合计项
            editGrid1.DataSource = tb;
            editGrid1.IsShowIco  = true;

            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //

                Thread th = new Thread(() =>
                {
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                        var branch_tb        = bll2.GetBranchList();
                        this.txtbranch.Invoke((MethodInvoker) delegate
                        {
                            txtbranch.Bind(branch_tb, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                        });
                        var sup_tb = bll2.GetAllSupList();
                        this.txt_sup.Invoke((MethodInvoker) delegate
                        {
                            txt_sup.Bind(sup_tb, 350, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
                        });
                        var deal_tb = bll2.GetPeopleList();
                        this.txt_order_man.Invoke((MethodInvoker) delegate
                        {
                            txt_order_man.Bind(deal_tb, 250, 200, "oper_id", "oper_id:编号:80,oper_name:姓名:100", "oper_id/oper_name->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        LogHelper.writeLog("frmCGOrder", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmCGOrder()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #19
0
        public frmIOMaster()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("in_qty", typeof(decimal));
            tb.Columns.Add("valid_price", typeof(decimal));
            tb.Columns.Add("ret_qnty", typeof(decimal));
            tb.Columns.Add("sub_amount", typeof(decimal));
            tb.Columns.Add("cost_price", typeof(decimal));
            tb.Columns.Add("num1", typeof(decimal));//参考进价

            editGrid1.AddColumn("item_subno", "货号", "", 100, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 80, 1, "", false);
            editGrid1.AddColumn("in_qty", "数量", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("ret_qnty", "实拣数", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("valid_price", "调拨价", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("sub_amount", "调拨金额", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("cost_price", "调出价", "", 150, 3, "0.00", false);
            editGrid1.AddColumn("num1", "调出金额", "", 100, 3, "0.00", false);
            editGrid1.SetTotalColumn("in_qty,ret_qnty,sub_amount,num1");//合计项
            editGrid1.DataSource = tb;

            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //
                System.Threading.Thread th = new System.Threading.Thread(() =>
                {
                    Cursor.Current = Cursors.WaitCursor;
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                        var branch           = bll2.GetBranchList();
                        this.txtBranchIn.Invoke((MethodInvoker) delegate
                        {
                            txtBranchIn.Bind(branch, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                        });

                        var branchout = bll2.GetBranchList();
                        this.txt_BranchOut.Invoke((MethodInvoker) delegate
                        {
                            txt_BranchOut.Bind(branchout, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        IvyBack.Helper.LogHelper.writeLog("frmIOMaster", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Cursor.Current = Cursors.Default;
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmIOMaster()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #20
0
        public frmCGInSheet()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("other3");
            tb.Columns.Add("in_qty", typeof(decimal));
            tb.Columns.Add("valid_price", typeof(decimal));
            tb.Columns.Add("discount", typeof(decimal));
            tb.Columns.Add("sub_amount", typeof(decimal));
            tb.Columns.Add("other1");
            tb.Columns.Add("valid_date", typeof(DateTime));
            tb.Columns.Add("price", typeof(decimal));//参考进价

            editGrid1.AddColumn("item_subno", "货号", "", 100, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 80, 1, "", false);
            editGrid1.AddColumn("in_qty", "数量", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("valid_price", "单价", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("discount", "折扣", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("sub_amount", "金额", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("other1", "备注", "", 150, 1, "", true);
            editGrid1.AddColumn("valid_date", "有效期", "", 100, 1, "yyyy-MM-dd", true);
            editGrid1.AddColumn("price", "参考进价", "", 100, 3, "0.00", false);
            editGrid1.SetTotalColumn("in_qty,sub_amount");//合计项
            editGrid1.DataSource = tb;
            editGrid1.IsShowIco  = true;
            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //

                Thread th = new Thread(() =>
                {
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                        var branch_tb        = bll2.GetBranchList();
                        this.txtbranch.Invoke((MethodInvoker) delegate
                        {
                            txtbranch.Bind(branch_tb, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                        });
                        DataTable dt2 = new DataTable();
                        dt2.Columns.Add("sale_no");
                        dt2.Columns.Add("sale_name");
                        dt2.Rows.Add("A", "购销");
                        dt2.Rows.Add("B", "代销");
                        dt2.Rows.Add("C", "联营");
                        dt2.Rows.Add("E", "联营进货");
                        dt2.Rows.Add("Z", "租赁");

                        this.txt_sale_no.Invoke((MethodInvoker) delegate
                        {
                            txt_sale_no.Bind(dt2, 250, 200, "sale_no", "sale_no:编码:80,sale_name:代销方式:100", "sale_no/sale_name->Text");
                        });
                        var sup_tb = bll2.GetAllSupList();
                        this.txt_sup.Invoke((MethodInvoker) delegate
                        {
                            txt_sup.Bind(sup_tb, 350, 200, "supcust_no", "supcust_no:编号:80,sup_name:名称:200", "supcust_no/sup_name->Text");
                        });
                        var deal_tb = bll2.GetPeopleList();
                        this.txt_deal_man.Invoke((MethodInvoker) delegate
                        {
                            txt_deal_man.Bind(deal_tb, 250, 200, "oper_id", "oper_id:编号:80,oper_name:姓名:100", "oper_id/oper_name->Text");
                        });

                        IBLL.IInOutBLL bll3 = new BLL.InOutBLL();
                        var order           = bll3.GetImportCGOrder();
                        this.txt_voucher_no.Invoke((MethodInvoker) delegate
                        {
                            this.txt_voucher_no.Bind(order, 350, 200, "sheet_no", "sheet_no:单据号:110,supcust:供应商:100,branch:仓库:100,oper_date:日期:150", "sheet_no->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        LogHelper.writeLog("frmCGInSheet", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmCGInSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #21
0
        public frmScanCheckSheet(frmCheckSheet frm)
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            this.frm = frm;
            //
            tb = new DataTable();
            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("item_pack");
            tb.Columns.Add("stock_qty", typeof(decimal));
            tb.Columns.Add("real_qty", typeof(decimal));
            tb.Columns.Add("packqty", typeof(decimal));
            tb.Columns.Add("sgqty", typeof(decimal));
            tb.Columns.Add("balance_qty", typeof(decimal));
            tb.Columns.Add("in_price", typeof(decimal));
            tb.Columns.Add("real_amount", typeof(decimal));

            editGrid1.AddColumn("item_subno", "货号", "", 100, 1, "", false);
            editGrid1.AddColumn("barcode", "条码", "", 120, 1, "", false);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 80, 1, "", false);
            editGrid1.AddColumn("stock_qty", "系统库存", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("real_qty", "实际盘点数量", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("item_pack", "包装数量", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("packqty", "箱数", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("sgqty", "零数", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("balance_qty", "盈亏数量", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("in_price", "成本价", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("real_amount", "盈亏金额", "", 100, 3, "0.00", false);

            editGrid1.SetTotalColumn("stock_qty,real_qty,packqty,sgqty,balance_qty,real_amount");//合计项
            editGrid1.DataSource = tb;

            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //
                IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                tbgoods = bll2.GetGoodsList();

                editGrid1.Bind("item_subno", tbgoods, 500, 200, "item_subno", "item_subno:货号:80,item_name:品名:150," +
                               "barcode:条码:100,item_subname:拼音码:80", "item_no->item_no,item_subno->item_subno,barcode->barcode," +
                               "item_name->item_name,unit_no->unit_no,item_size->item_size,item_pack->item_pack,price->in_price");

                editGrid1.Bind("barcode", tbgoods, 500, 200, "barcode", "item_subno:货号:80,item_name:品名:150," +
                               "barcode:条码:100,item_subname:拼音码:80", "item_no->item_no,item_subno->item_subno,barcode->barcode," +
                               "item_name->item_name,unit_no->unit_no,item_size->item_size,item_pack->item_pack,price->in_price");
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmScanCheckSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #22
0
        public frmCusPriceOrder()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("price", typeof(decimal));
            tb.Columns.Add("old_price", typeof(decimal));
            tb.Columns.Add("old_price2", typeof(decimal));
            tb.Columns.Add("old_price3", typeof(decimal));
            tb.Columns.Add("new_price", typeof(decimal));
            tb.Columns.Add("new_price2", typeof(decimal));
            tb.Columns.Add("new_price3", typeof(decimal));

            editGrid1.AddColumn("item_subno", "货号", "", 90, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 110, 1, "", false);
            editGrid1.AddColumn("price", "参考成本", "", 110, 3, "0.00", false);
            editGrid1.AddColumn("old_price", "原价", "一级批发价", 90, 3, "0.00", false);
            editGrid1.AddColumn("new_price", "新价", "一级批发价", 90, 3, "0.00", true);
            editGrid1.AddColumn("old_price2", "原价", "二级批发价", 90, 3, "0.00", false);
            editGrid1.AddColumn("new_price2", "新价", "二级批发价", 90, 3, "0.00", true);
            editGrid1.AddColumn("old_price3", "原价", "三级批发价", 90, 3, "0.00", false);


            editGrid1.AddColumn("new_price3", "新价", "三级批发价", 100, 3, "0.00", true);
            editGrid1.DataSource = tb;
            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //
                System.Threading.Thread th = new System.Threading.Thread(() =>
                {
                    Cursor.Current = Cursors.WaitCursor;
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        BLL.CusPriceOrderBLL bll = new BLL.CusPriceOrderBLL();
                        IBLL.ICommonBLL bll2     = new BLL.CommonBLL();

                        var branch_tb = bll2.GetBranchList();
                        this.txtbranch.Invoke((MethodInvoker) delegate
                        {
                            txtbranch.Bind(branch_tb, 300, 200, "branch_no", "branch_no:机构号:80,branch_name:机构名:140", "branch_no/branch_name->Text");
                        });

                        var people_tb = bll2.GetPeopleList();
                        this.txtpeople.Invoke((MethodInvoker) delegate
                        {
                            txtpeople.Bind(people_tb, 250, 200, "oper_id", "oper_id:职员编号:80,oper_name:姓名:80", "oper_id/oper_name->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        IvyBack.Helper.LogHelper.writeLog("frmCusPriceOrder", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Cursor.Current = Cursors.Default;
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }
コード例 #23
0
        public frmCheckSheet()
        {
            InitializeComponent();
            //
            Helper.GlobalData.InitForm(this);
            //
            var tb = new DataTable();

            tb.Columns.Add("item_no");
            tb.Columns.Add("item_subno");
            tb.Columns.Add("barcode");
            tb.Columns.Add("item_name");
            tb.Columns.Add("unit_no");
            tb.Columns.Add("item_size");
            tb.Columns.Add("item_pack");
            tb.Columns.Add("stock_qty", typeof(decimal));
            tb.Columns.Add("real_qty", typeof(decimal));
            tb.Columns.Add("packqty", typeof(decimal));
            tb.Columns.Add("sgqty", typeof(decimal));
            tb.Columns.Add("balance_qty", typeof(decimal));
            tb.Columns.Add("in_price", typeof(decimal));
            tb.Columns.Add("real_amount", typeof(decimal));
            tb.Columns.Add("sale_price", typeof(decimal));

            editGrid1.AddColumn("item_subno", "货号", "", 100, 1, "", true);
            editGrid1.AddColumn("barcode", "条码", "", 120, 1, "", true);
            editGrid1.AddColumn("item_name", "商品名称", "", 150, 1, "", false);
            editGrid1.AddColumn("unit_no", "单位", "", 60, 2, "", false);
            editGrid1.AddColumn("item_size", "规格", "", 80, 1, "", false);
            editGrid1.AddColumn("stock_qty", "系统库存", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("real_qty", "实际盘点数量", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("item_pack", "包装数量", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("packqty", "箱数", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("sgqty", "零数", "", 100, 3, "0.00", true);
            editGrid1.AddColumn("balance_qty", "盈亏数量", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("in_price", "成本价", "", 100, 3, "0.00", false);
            editGrid1.AddColumn("real_amount", "盈亏金额", "", 100, 3, "0.00", false);

            editGrid1.SetTotalColumn("balance_qty,real_amount");//合计项
            editGrid1.DataSource = tb;

            //
            try
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
                //

                Thread th = new Thread(() =>
                {
                    Helper.GlobalData.windows.ShowLoad(this);
                    try
                    {
                        IBLL.ICommonBLL bll2 = new BLL.CommonBLL();
                        var branch_tb        = bll2.GetBranchList();
                        this.txtbranch.Invoke((MethodInvoker) delegate
                        {
                            txtbranch.Bind(branch_tb, 300, 200, "branch_no", "branch_no:编号:80,branch_name:名称:140", "branch_no/branch_name->Text");
                        });

                        var deal_tb = bll2.GetPeopleList();
                        this.txt_deal_man.Invoke((MethodInvoker) delegate
                        {
                            txt_deal_man.Bind(deal_tb, 250, 200, "oper_id", "oper_id:编号:80,oper_name:姓名:100", "oper_id/oper_name->Text");
                        });

                        IBLL.ICheckBLL bll = new BLL.CheckBLL();
                        var check_tb       = bll.GetCheckInitList();
                        this.txt_check_no.Invoke((MethodInvoker) delegate
                        {
                            txt_check_no.Bind(check_tb, 250, 200, "sheet_no", "sheet_no:单据号:120,branch_name:机构:120,oper_name:操作员:120,begin_date:起始日期:120", "sheet_no->Text");
                        });

                        this.Invoke((MethodInvoker) delegate
                        {
                            IOrder ins = this;
                            ins.Add();
                        });
                    }
                    catch (Exception ex)
                    {
                        LogHelper.writeLog("frmCheckSheet", ex.ToString());
                        MsgForm.ShowFrom(ex);
                    }
                    Helper.GlobalData.windows.CloseLoad(this);
                });
                th.Start();
            }
            catch (Exception ex)
            {
                MsgForm.ShowFrom(ex);
                Helper.LogHelper.writeLog("frmCheckSheet()", ex.ToString());
            }
            finally
            {
                System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            }
        }