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