public List <PUInvoiceDetailFixedAssetEntity> PUInvoiceDetailFixedAssets(List <PUInvoiceDetailFixedAsset> details, string refid)
{
List <PUInvoiceDetailFixedAssetEntity> lstDetailEntities = new List <PUInvoiceDetailFixedAssetEntity>();
foreach (var result in details)
{
var newresult = new PUInvoiceDetailFixedAssetEntity();
newresult.RefDetailId = result.RefDetailID.ToString();
newresult.RefId = refid;
newresult.FixedAssetId = result.FixedAsset == null ? null : result.FixedAsset.FixedAssetID.ToString();
newresult.Description = result.Description;
newresult.DepartmentId = result.Department == null ? null : result.Department.DepartmentID.ToString();
newresult.DebitAccount = result.DebitAccount;
newresult.CreditAccount = result.CreditAccount;
newresult.Amount = result.Amount;
newresult.TaxRate = result.TaxRate ?? 0;
newresult.TaxAmount = result.TaxAmount;
newresult.TaxAccount = result.TaxAccount;
newresult.InvDate = result.InvDate;
newresult.InvSeries = result.InvSeries;
newresult.InvNo = result.InvNo;
newresult.InvType = result.InvType ?? 0;
newresult.InvoiceTypeCode = result.InvoiceTypeCode;
newresult.PurchasePurposeId = result.PurchasePurpose == null ? null : result.PurchasePurpose.PurchasePurposeID.ToString();
newresult.FreightAmount = result.FreightAmount;
newresult.OrgPrice = result.OrgPrice;
newresult.BudgetSourceId = result.BudgetSource == null ? null : result.BudgetSource.BudgetSourceID.ToString();
newresult.BudgetChapterCode = result.BudgetChapterCode;
newresult.BudgetKindItemCode = result.BudgetKindItemCode;
newresult.BudgetSubKindItemCode = result.BudgetSubKindItemCode;
newresult.BudgetItemCode = result.BudgetItemCode;
newresult.BudgetSubItemCode = result.BudgetSubItemCode;
newresult.MethodDistributeId = result.MethodDistributeID ?? 0;
newresult.CashWithDrawTypeId = ConvertCash.ConvertCash(result.CashWithDrawTypeID);
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.ActivityId = result.Activity == null ? null : result.Activity.ActivityID.ToString();
newresult.ProjectId = result.Project == null ? null : result.Project.ProjectID.ToString();
newresult.ProjectActivityId = result.Project1 == null ? null : result.Project1.ProjectID.ToString();
newresult.ProjectExpenseId = result.ProjectExpense == null?null:result.ProjectExpense.ProjectExpenseID.ToString();
newresult.TaskId = result.Task == null ? null : result.Task.TaskID.ToString();
newresult.ListItemId = result.ListItem == null ? null : result.ListItem.ListItemID.ToString();
newresult.Approved = result.Approved;
newresult.SortOrder = result.SortOrder ?? 0;
newresult.BudgetDetailItemCode = result.BudgetDetailItemCode;
newresult.OrgRefNo = result.OrgRefNo;
newresult.OrgRefDate = result.OrgRefDate;
newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString();
newresult.BankAccount = result.BankAccount;
newresult.ProjectExpenseEAId = result.ProjectExpense1 == null?null:result.ProjectExpense1.ProjectExpenseID.ToString();
newresult.ProjectActivityEAId = result.Project2 == null ? null : result.Project2.ProjectID.ToString();
newresult.BudgetProvIdeCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode;
newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString();
//newresult.BudgetExpenseId = result.budgete;
lstDetailEntities.Add(newresult);
}
return(lstDetailEntities);
}
private static object[] Take(PUInvoiceDetailFixedAssetEntity pUInvoiceDetailFixedAssetEntity)
{
return(new object[]
{
"@RefDetailID", pUInvoiceDetailFixedAssetEntity.RefDetailId,
"@RefID", pUInvoiceDetailFixedAssetEntity.RefId,
"@FixedAssetID", pUInvoiceDetailFixedAssetEntity.FixedAssetId,
"@Description", pUInvoiceDetailFixedAssetEntity.Description,
"@DepartmentID", pUInvoiceDetailFixedAssetEntity.DepartmentId,
"@DebitAccount", pUInvoiceDetailFixedAssetEntity.DebitAccount,
"@CreditAccount", pUInvoiceDetailFixedAssetEntity.CreditAccount,
"@Amount", pUInvoiceDetailFixedAssetEntity.Amount,
"@TaxRate", pUInvoiceDetailFixedAssetEntity.TaxRate,
"@TaxAmount", pUInvoiceDetailFixedAssetEntity.TaxAmount,
"@TaxAccount", pUInvoiceDetailFixedAssetEntity.TaxAccount,
"@InvDate", pUInvoiceDetailFixedAssetEntity.InvDate,
"@InvSeries", pUInvoiceDetailFixedAssetEntity.InvSeries,
"@InvNo", pUInvoiceDetailFixedAssetEntity.InvNo,
"@InvType", pUInvoiceDetailFixedAssetEntity.InvType,
"@InvoiceTypeCode", pUInvoiceDetailFixedAssetEntity.InvoiceTypeCode,
"@PurchasePurposeID", pUInvoiceDetailFixedAssetEntity.PurchasePurposeId,
"@FreightAmount", pUInvoiceDetailFixedAssetEntity.FreightAmount,
"@OrgPrice", pUInvoiceDetailFixedAssetEntity.OrgPrice,
"@BudgetSourceID", pUInvoiceDetailFixedAssetEntity.BudgetSourceId,
"@BudgetChapterCode", pUInvoiceDetailFixedAssetEntity.BudgetChapterCode,
"@BudgetKindItemCode", pUInvoiceDetailFixedAssetEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", pUInvoiceDetailFixedAssetEntity.BudgetSubKindItemCode,
"@BudgetItemCode", pUInvoiceDetailFixedAssetEntity.BudgetItemCode,
"@BudgetSubItemCode", pUInvoiceDetailFixedAssetEntity.BudgetSubItemCode,
"@MethodDistributeID", pUInvoiceDetailFixedAssetEntity.MethodDistributeId,
"@CashWithDrawTypeID", pUInvoiceDetailFixedAssetEntity.CashWithDrawTypeId,
"@AccountingObjectID", pUInvoiceDetailFixedAssetEntity.AccountingObjectId,
"@ActivityID", pUInvoiceDetailFixedAssetEntity.ActivityId,
"@ProjectID", pUInvoiceDetailFixedAssetEntity.ProjectId,
"@ProjectActivityID", pUInvoiceDetailFixedAssetEntity.ProjectActivityId,
"@ProjectExpenseID", pUInvoiceDetailFixedAssetEntity.ProjectExpenseId,
"@TaskID", pUInvoiceDetailFixedAssetEntity.TaskId,
"@ListItemID", pUInvoiceDetailFixedAssetEntity.ListItemId,
"@Approved", pUInvoiceDetailFixedAssetEntity.Approved,
"@SortOrder", pUInvoiceDetailFixedAssetEntity.SortOrder,
"@BudgetDetailItemCode", pUInvoiceDetailFixedAssetEntity.BudgetDetailItemCode,
"@OrgRefNo", pUInvoiceDetailFixedAssetEntity.OrgRefNo,
"@OrgRefDate", pUInvoiceDetailFixedAssetEntity.OrgRefDate,
"@FundStructureID", pUInvoiceDetailFixedAssetEntity.FundStructureId,
"@BankAccount", pUInvoiceDetailFixedAssetEntity.BankAccount,
"@ProjectExpenseEAID", pUInvoiceDetailFixedAssetEntity.ProjectExpenseEAId,
"@ProjectActivityEAID", pUInvoiceDetailFixedAssetEntity.ProjectActivityEAId,
"@BudgetProvideCode", pUInvoiceDetailFixedAssetEntity.BudgetProvIdeCode,
"@TopicID", pUInvoiceDetailFixedAssetEntity.TopicId,
"@BudgetExpenseID", pUInvoiceDetailFixedAssetEntity.BudgetExpenseId,
});
}
public string UpdatePUInvoiceDetailFixedAsset(PUInvoiceDetailFixedAssetEntity entity)
{
const string procedures = @"uspInsert_PUInvoiceDetailFixedAsset";
return(Db.Insert(procedures, true, Take(entity)));
}
