/// <summary> /// 更改对账单 开票金额 /// </summary> /// <param name="osId"></param> /// <returns></returns> public bool UpdateOrderStatementInvoiceData(int osId) { string sql = string.Format(@"select InvoiceStatus,Sum(invoiceAmount) as InvoiceAmount from InvoiceRequire where StatementId={0} group by InvoiceStatus ", osId); DataSet ds = m_dbo.GetDataSet(sql); OrderStatement os = new OrderStatement(); os.Id = osId; os.Load(); os.InvoiceMoney = 0; os.NeedToInvoice = 0; if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { if (DBTool.GetStringFromRow(row, "InvoiceStatus", "") == CommenClass.InvoiceStatus.待开票.ToString()) { os.NeedToInvoice = DBTool.GetDoubleFromRow(row, "InvoiceAmount", 0); } else if (DBTool.GetStringFromRow(row, "InvoiceStatus", "") == CommenClass.InvoiceStatus.已开票.ToString()) { os.InvoiceMoney = DBTool.GetDoubleFromRow(row, "InvoiceAmount", 0); } } } if (os.Save() > 0) { return(true); } else { return(false); } }
/// <summary> /// 保存对账 /// </summary> /// <param name="os"></param> /// <param name="osds"></param> /// <returns></returns> public int SaveOrderStatement(OrderStatement os, OrderStatementDetail[] osds) { OrderStatement orderstatement = new OrderStatement(); orderstatement.BranchId = os.BranchId; orderstatement.ComId = os.ComId; orderstatement.Id = os.Id; orderstatement.Memo = os.Memo; orderstatement.PaidMoney = os.PaidMoney; orderstatement.PayStatus = os.PayStatus; orderstatement.PrintNum = os.PrintNum; orderstatement.SumMoney = os.SumMoney; orderstatement.UpdateTime = DateTime.Now; orderstatement.UserId = os.UserId; orderstatement.InvoiceMoney = os.InvoiceMoney; orderstatement.NeedToInvoice = os.NeedToInvoice; int osId = orderstatement.Save(); if (osId > 0) { for (int i = 0; i < osds.Length; i++) { OrderStatementDetail osd = new OrderStatementDetail(); osd.OrderStatementId = osId; osd.OrderId = osds[i].OrderId; osd.Save(); } } return(osId); }