partial void DeleteArrearage(Arrearage instance);
partial void InsertArrearage(Arrearage instance);
partial void UpdateArrearage(Arrearage instance);
/// <summary>
/// 新增收款/付款记录
/// </summary>
/// <param name="entity"></param>
public void InsertPaidRecord(tFundsRecorderInfo entity)
{
if (entity.tFundsRecorder[0].IsinputManNull())
{
entity.tFundsRecorder[0].inputMan = "System";
}
using (BalanceDataContext oContext = new BalanceDataContext(this.strConn))
{
FundsRecorder linqEntity = new FundsRecorder();
if (entity.tFundsRecorder[0].IscustomerIdNull() == false)
{
linqEntity.customerId = entity.tFundsRecorder[0].customerId;
}
else if (entity.tFundsRecorder[0].IsciIdNull() == false)
{
linqEntity.ciid = entity.tFundsRecorder[0].ciId;
}
else if (entity.tFundsRecorder[0].IstuIdNull() == false)
{
linqEntity.tuid = entity.tFundsRecorder[0].tuId;
}
linqEntity.paidup = entity.tFundsRecorder[0].paidUp;
linqEntity.type = entity.tFundsRecorder[0].type;
if (entity.tFundsRecorder[0].IscheckNoNull() == false)
{
linqEntity.checkNo = entity.tFundsRecorder[0].checkNo;
}
if (entity.tFundsRecorder[0].IsinvoiceNoNull() == false)
{
linqEntity.invoiceNo = entity.tFundsRecorder[0].invoiceNo;
}
if (entity.tFundsRecorder[0].IsremarkNull() == false)
{
linqEntity.remark = entity.tFundsRecorder[0].remark;
}
linqEntity.cash1 = entity.tFundsRecorder[0].cash1;
linqEntity.cash2 = entity.tFundsRecorder[0].cash2;
linqEntity.inputMan = entity.tFundsRecorder[0].inputMan;
Arrearage arrearageEntity = new Arrearage(); //欠款表
arrearageEntity.due = entity.tFundsRecorder[0].cash1;
arrearageEntity.@default = entity.tFundsRecorder[0].cash2;
arrearageEntity.paidUp = arrearageEntity.due - arrearageEntity.@default;
arrearageEntity.inputMan = entity.tFundsRecorder[0].inputMan;
AccountReceivable receiveEntity = null; //应收款表
if (entity.tFundsRecorder[0].type == EnumAccountType.付款.ToString() &&
entity.tFundsRecorder[0].IscustomerIdNull() == false)
{
//采购
arrearageEntity.piId = entity.tFundsRecorder[0].customerId;
var tempEntity = (from item in oContext.Arrearage
where item.piId == arrearageEntity.piId
select item).FirstOrDefault();
if (tempEntity != null)
{
tempEntity.due = arrearageEntity.due;
tempEntity.@default = arrearageEntity.@default;
tempEntity.paidUp = arrearageEntity.paidUp;
tempEntity.inputMan = arrearageEntity.inputMan;
}
else
{
oContext.Arrearage.InsertOnSubmit(arrearageEntity);
}
}
else if (entity.tFundsRecorder[0].type == EnumAccountType.运输款.ToString() &&
entity.tFundsRecorder[0].IstuIdNull() == false)
{
//运输
arrearageEntity.tuId = entity.tFundsRecorder[0].tuId;
var tempEntity = (from item in oContext.Arrearage
where item.tuId == arrearageEntity.tuId
select item).FirstOrDefault();
if (tempEntity != null)
{
tempEntity.due = arrearageEntity.due;
tempEntity.@default = arrearageEntity.@default;
tempEntity.paidUp = arrearageEntity.paidUp;
tempEntity.inputMan = arrearageEntity.inputMan;
}
else
{
oContext.Arrearage.InsertOnSubmit(arrearageEntity);
}
}
else if (entity.tFundsRecorder[0].type == EnumAccountType.备品备件.ToString() &&
entity.tFundsRecorder[0].IscustomerIdNull() == false)
{
//备品备件
arrearageEntity.piId = entity.tFundsRecorder[0].customerId;
var tempEntity = (from item in oContext.Arrearage
where item.piId == arrearageEntity.piId
select item).FirstOrDefault();
if (tempEntity != null)
{
tempEntity.due = arrearageEntity.due;
tempEntity.@default = arrearageEntity.@default;
tempEntity.paidUp = arrearageEntity.paidUp;
tempEntity.inputMan = arrearageEntity.inputMan;
}
else
{
oContext.Arrearage.InsertOnSubmit(arrearageEntity);
}
}
else if (entity.tFundsRecorder[0].type == EnumAccountType.收款.ToString() &&
entity.tFundsRecorder[0].IsciIdNull() == false)
{
//销售
receiveEntity = new AccountReceivable();
receiveEntity.ciId = entity.tFundsRecorder[0].ciId;
receiveEntity.accountReceivable1 = entity.tFundsRecorder[0].cash1;
receiveEntity.@default = entity.tFundsRecorder[0].cash2;
receiveEntity.accept = receiveEntity.accountReceivable1 - receiveEntity.@default;
receiveEntity.inputMan = entity.tFundsRecorder[0].inputMan;
var tempEntity = (from item in oContext.AccountReceivable
where item.ciId == receiveEntity.ciId
select item).FirstOrDefault();
if (tempEntity != null)
{
tempEntity.accountReceivable1 = receiveEntity.accountReceivable1;
tempEntity.@default = receiveEntity.@default;
tempEntity.accept = receiveEntity.accept;
tempEntity.inputMan = receiveEntity.inputMan;
}
else
{
oContext.AccountReceivable.InsertOnSubmit(receiveEntity);
}
}
oContext.FundsRecorder.InsertOnSubmit(linqEntity);
oContext.SubmitChanges();
}
//System.Data.SqlClient.SqlConnection sqlConn = null;
//System.Data.SqlClient.SqlTransaction sqlTrans = null;
//System.Data.SqlClient.SqlParameter[] sqlpmParams = GetTableParameters();
//SetParamsValue(entity, sqlpmParams);
//try
//{
// sqlConn = new SqlConnection(strConn);
// if (sqlConn.State != ConnectionState.Open)
// {
// sqlConn.Open();
// }
// sqlTrans = sqlConn.BeginTransaction();
// Iori.DataAccess.SQLServerDAL.SQLHelper.ExecuteNonQuery(sqlConn, CommandType.Text, INSERT_SQL, sqlpmParams); //
// sqlTrans.Commit();
//}
//catch (System.Data.SqlClient.SqlException)
//{
// if (sqlTrans != null)
// {
// sqlTrans.Rollback();
// }
//}
//finally
//{
// if (sqlConn != null && sqlConn.State != ConnectionState.Closed)
// {
// sqlConn.Close();
// }
//}
}
