Exemple #1
0
        /// <summary>
        /// 向结存汇总信息FarPoint内加入数据
        /// </summary>
        /// <param name="pay">供货商结存实体</param>
        protected void AddPayHeadData(Neusoft.HISFC.Models.Material.Pay pay)
        {
            int rowCount = this.neuSpread1_Sheet1.Rows.Count;

            this.neuSpread1_Sheet1.Rows.Add(rowCount, 1);

            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColChoose].Value       = true;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColInvoiceNo].Text     = pay.InvoiceNo;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColInvoiceDate].Value  = pay.InvoiceTime;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColInvoiceCost].Value  = pay.PurchaseCost;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColDiscountCost].Value = pay.DiscountCost;
            //应付金额通过FarPoint公式自动设置
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColPaidUpCost].Value   = pay.PayCost;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColPayCost].Value      = pay.UnpayCost;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColDeliveryCost].Value = pay.DeliveryCost;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColPayType].Value      = pay.PayType;
            if (pay.Company.OpenBank == null || pay.Company.OpenBank == "")
            {
                this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColOpenBank].Value = this.company.OpenBank;
            }
            else
            {
                this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColOpenBank].Value = pay.Company.OpenBank;
            }
            if (pay.Company.OpenAccounts == null || pay.Company.OpenAccounts == "")
            {
                this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColOpenAccounts].Value = this.company.OpenAccounts;
            }
            else
            {
                this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColOpenAccounts].Value = pay.Company.OpenAccounts;
            }
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColDept].Value              = this.privDept.Name;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColInListCode].Value        = pay.InListCode;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColUnpayCredence].Value     = pay.UnpayCredence;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColUnpayCredence].Locked    = false;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColUnpayCredence].BackColor = System.Drawing.Color.SeaShell;

            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColUnCredenceDate].Value     = pay.UnpayCredenceTime;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColUnCredenceDate].Locked    = false;
            this.neuSpread1_Sheet1.Cells[rowCount, (int)ColPayHeadSet.ColUnCredenceDate].BackColor = System.Drawing.Color.SeaShell;

            this.neuSpread1_Sheet1.Rows[rowCount].Tag = pay;
        }
Exemple #2
0
        /// <summary>
        /// 未付款账单打印 {54092BCA-BDA1-45e8-A7C6-777282653264}
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="neuObject"></param>
        /// <returns></returns>
        public override int Print(object sender, object neuObject)
        {
            if (this.neuSpread1_Sheet1.RowCount <= 0)
            {
                MessageBox.Show("请先查询再打印!");

                return(-1);
            }

            string strTime = dtBegin.ToString() + "--" + dtEnd.ToString();
            List <Neusoft.HISFC.Models.Material.Pay> payList = new List <Neusoft.HISFC.Models.Material.Pay>();

            foreach (FarPoint.Win.Spread.Row r in this.neuSpread1_Sheet1.Rows)
            {
                Neusoft.HISFC.Models.Material.Pay pay = r.Tag as Neusoft.HISFC.Models.Material.Pay;
                payList.Add(pay);
            }

            Neusoft.HISFC.Components.Material.Pay.ucUnpayListPrint ucPrint = new Neusoft.HISFC.Components.Material.Pay.ucUnpayListPrint();
            ucPrint.SetPrintValue(strTime, this.company, this.privDept.Name, payList);
            ucPrint.Print();

            return(base.Print(sender, neuObject));
        }