partial void DeleteFundsRecorder(FundsRecorder instance);
partial void InsertFundsRecorder(FundsRecorder instance);
partial void UpdateFundsRecorder(FundsRecorder 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(); // } //} }