/// <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);
}
/// <summary>
/// ERP FOrderReceiveMoney.cs 中调用
/// </summary>
/// <returns></returns>
public bool Delete()
{
this.Load();
OrderStatement os = new OrderStatement();
os.Id = this.OrderStatementId;
string sql = string.Format(" delete from OrderReceiveMoney where Id={0} ", this.Id);
if (m_dbo.ExecuteNonQuery(sql))
{
os.UpdateStatus();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// ERP FOrderReceiveMoney.cs 中调用
/// </summary>
/// <returns></returns>
public int Save()
{
ArrayList arrayList = new ArrayList();
if (m_Id > 0)
{
arrayList.Add(new SqlParameter("@Id", m_Id));
}
arrayList.Add(new SqlParameter("@BranchId", m_BranchId));
arrayList.Add(new SqlParameter("@OrderStatementId", m_OrderStatementId));
arrayList.Add(new SqlParameter("@ReceiveMoney", Math.Round(m_ReceiveMoney, 2)));
arrayList.Add(new SqlParameter("@PayStatus", m_PayStatus));
arrayList.Add(new SqlParameter("@BankAccountId", m_BankAccountId));
arrayList.Add(new SqlParameter("@PayType", m_PayType));
arrayList.Add(new SqlParameter("@Memo", m_Memo));
arrayList.Add(new SqlParameter("@UserId", m_UserId));
arrayList.Add(new SqlParameter("@ReceiveDate", m_ReceiveDate));
arrayList.Add(new SqlParameter("@UpdateTime", m_UpdateTime));
arrayList.Add(new SqlParameter("@ChargeOff", m_ChargeOff));//add by quxiaoshan 2014-11-07
if (this.Id > 0)
{
m_dbo.UpdateData("OrderReceiveMoney", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
}
else
{
this.Id = m_dbo.InsertData("OrderReceiveMoney", (SqlParameter[])arrayList.ToArray(typeof(SqlParameter)));
}
if (this.Id > 0)
{
OrderStatement os = new OrderStatement();
os.Id = this.OrderStatementId;
os.UpdateStatus();
}
return(this.Id);
}
