public List <BUTransferDetailFixedAssetEntity> BUTransferDetailFixedAssets(List <BUTransferDetailFixedAsset> details, string refid) { List <BUTransferDetailFixedAssetEntity> lstDetailEntities = new List <BUTransferDetailFixedAssetEntity>(); foreach (var result in details) { var newresult = new BUTransferDetailFixedAssetEntity(); 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 = Convert.ToInt32(result.TaxRate ?? 0); newresult.TaxAmount = result.TaxAmount; 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; 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.ProjectActivityID.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; newresult.BudgetDetailItemCode = result.BudgetDetailItemCode; newresult.OrgRefNo = result.OrgRefNo; newresult.OrgRefDate = result.OrgRefDate; newresult.FundStructureId = result.FundStructure == null ? null : result.FundStructure.FundStructureID.ToString(); newresult.ProjectExpenseEAId = result.ProjectExpense1 == null ? null : result.ProjectExpense1.ProjectExpenseID.ToString(); newresult.ProjectActivityEAId = result.Project1 == null ? null : result.Project1.ProjectID.ToString(); newresult.BudgetProvideCode = result.BudgetProvidence == null ? null : result.BudgetProvidence.BudgetProvideCode; newresult.TopicId = result.Topic == null ? null : result.Topic.TopicID.ToString(); //newresult.CreatedDate = result.cre; //newresult.BudgetExpenseId = result.BudgetE; //newresult.BankId = result.BankID; lstDetailEntities.Add(newresult); } return(lstDetailEntities); }
/// <summary> /// Takes the specified entity. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> private static object[] Take(BUTransferDetailFixedAssetEntity bUTransferDetailFixedAssetEntity) { return(new object[] { "@RefDetailID", bUTransferDetailFixedAssetEntity.RefDetailId, "@RefID", bUTransferDetailFixedAssetEntity.RefId, "@FixedAssetID", bUTransferDetailFixedAssetEntity.FixedAssetId, "@Description", bUTransferDetailFixedAssetEntity.Description, "@DepartmentID", bUTransferDetailFixedAssetEntity.DepartmentId, "@DebitAccount", bUTransferDetailFixedAssetEntity.DebitAccount, "@CreditAccount", bUTransferDetailFixedAssetEntity.CreditAccount, "@Amount", bUTransferDetailFixedAssetEntity.Amount, "@TaxRate", bUTransferDetailFixedAssetEntity.TaxRate, "@TaxAmount", bUTransferDetailFixedAssetEntity.TaxAmount, "@FreightAmount", bUTransferDetailFixedAssetEntity.FreightAmount, "@OrgPrice", bUTransferDetailFixedAssetEntity.OrgPrice, "@BudgetSourceID", bUTransferDetailFixedAssetEntity.BudgetSourceId, "@BudgetChapterCode", bUTransferDetailFixedAssetEntity.BudgetChapterCode, "@BudgetKindItemCode", bUTransferDetailFixedAssetEntity.BudgetKindItemCode, "@BudgetSubKindItemCode", bUTransferDetailFixedAssetEntity.BudgetSubKindItemCode, "@BudgetItemCode", bUTransferDetailFixedAssetEntity.BudgetItemCode, "@BudgetSubItemCode", bUTransferDetailFixedAssetEntity.BudgetSubItemCode, "@MethodDistributeID", bUTransferDetailFixedAssetEntity.MethodDistributeId, "@CashWithdrawTypeID", bUTransferDetailFixedAssetEntity.CashWithdrawTypeId, "@AccountingObjectID", bUTransferDetailFixedAssetEntity.AccountingObjectId, "@ActivityID", bUTransferDetailFixedAssetEntity.ActivityId, "@ProjectID", bUTransferDetailFixedAssetEntity.ProjectId, "@ProjectActivityID", bUTransferDetailFixedAssetEntity.ProjectActivityId, "@ProjectExpenseID", bUTransferDetailFixedAssetEntity.ProjectExpenseId, "@TaskID", bUTransferDetailFixedAssetEntity.TaskId, "@ListItemID", bUTransferDetailFixedAssetEntity.ListItemId, "@Approved", bUTransferDetailFixedAssetEntity.Approved, "@SortOrder", bUTransferDetailFixedAssetEntity.SortOrder, "@BudgetDetailItemCode", bUTransferDetailFixedAssetEntity.BudgetDetailItemCode, "@OrgRefNo", bUTransferDetailFixedAssetEntity.OrgRefNo, "@OrgRefDate", bUTransferDetailFixedAssetEntity.OrgRefDate, "@FundStructureID", bUTransferDetailFixedAssetEntity.FundStructureId, "@ProjectExpenseEAID", bUTransferDetailFixedAssetEntity.ProjectExpenseEAId, "@ProjectActivityEAID", bUTransferDetailFixedAssetEntity.ProjectActivityEAId, "@BudgetProvideCode", bUTransferDetailFixedAssetEntity.BudgetProvideCode, "@TopicID", bUTransferDetailFixedAssetEntity.TopicId, "@CreatedDate", bUTransferDetailFixedAssetEntity.CreatedDate, "@BankID", bUTransferDetailFixedAssetEntity.BankId, "@BudgetExpenseID", bUTransferDetailFixedAssetEntity.BudgetExpenseId, }); }
public string InsertBUTransferDetailFixedAsset(BUTransferDetailFixedAssetEntity entity) { const string procedures = @"uspInsert_BUTransferDetailFixedAsset"; return(Db.Insert(procedures, true, Take(entity))); }