public static UCENTRIK.DATASETS.AgentDS.AgentDSDataTable GetAllAgents() { LogDS log = new LogDS(); AgentDSTableAdapter ta = new AgentDSTableAdapter(); //ta.Connection.ConnectionString = UcConnection.ConnectionString; return(ta.GetAllAgents()); }
public void LogLogInAction(LogInAction action) { LogDS logDS = new LogDS(); LogDS.LogInActionLogRow log = logDS.LogInActionLog.NewLogInActionLogRow(); log.ClientIP = action.ClientIP; log.UserName = action.UserName; log.Success = action.Success; if (log.Success) { log.StuffId = action.StuffId; log.StuffName = action.StuffName; } log.LogInTime = action.LogInTime; logDS.LogInActionLog.AddLogInActionLogRow(log); this.LogInActionLogTA.Update(logDS.LogInActionLog); }
public void LogCommonDataEditAction(CommonDataEditAction action) { LogDS logDS = new LogDS(); LogDS.CommonDataEditActionLogRow log = logDS.CommonDataEditActionLog.NewCommonDataEditActionLogRow(); log.ActionTime = action.ActionTime; log.ActionType = action.ActionType; log.DataTableName = action.DataTableName; if (action.NewValue != null) { log.NewValue = action.NewValue; } if (action.OldValue != null) { log.OldValue = action.OldValue; } if (action.StuffId != null) { log.StuffId = action.StuffId; } log.StuffName = action.StuffName; logDS.CommonDataEditActionLog.AddCommonDataEditActionLogRow(log); this.CommonDataEditActionLogTA.Update(logDS.CommonDataEditActionLog); }
public string GenerateFormAndReturnError(int i, DataRow row, LogDS.ImportFormLogDetailRow logDetailRow) { SqlTransaction transaction = null; string errorInfor = string.Empty; try { FormTableAdapter TAForm = new FormTableAdapter(); FormSaleSettlementTableAdapter TAFormSettlement = new FormSaleSettlementTableAdapter(); FormSalePaymentTableAdapter TASalePayment = new FormSalePaymentTableAdapter(); FormSalePaymentDetailTableAdapter TASalePaymentDetail = new FormSalePaymentDetailTableAdapter(); FormSettlementExpenseDetailTableAdapter TAFormSettlementExpenseDetail = new FormSettlementExpenseDetailTableAdapter(); transaction = TableAdapterHelper.BeginTransaction(TAForm); TableAdapterHelper.SetTransaction(TASalePayment, transaction); TableAdapterHelper.SetTransaction(TASalePaymentDetail, transaction); FormDS.FormDataTable tbForm = new FormDS.FormDataTable(); FormDS.FormSalePaymentDataTable tbPayment = new FormDS.FormSalePaymentDataTable(); FormDS.FormSalePaymentDetailDataTable tbPaymentDetail = new FormDS.FormSalePaymentDetailDataTable(); FormDS.FormRow rowForm = null; FormDS.FormSalePaymentRow rowPayment = null; FormDS.FormSalePaymentDetailRow rowPaymentDetail = null; string settlementFormNo = string.Empty; DateTime SubmitDate = DateTime.Now; decimal PaymentAmount = 0; bool IsValid = true; if (CheckData(row) != null) { errorInfor = "第" + (i + 1) + "行有错:" + CheckData(row); IsValid = false; } else { settlementFormNo = row[0].ToString().Trim(); SubmitDate = DateTime.Parse(row[1].ToString()); PaymentAmount = decimal.Parse(row[2].ToString().Trim()); logDetailRow.SettlementFormNo = settlementFormNo; logDetailRow.PaymentAmount = PaymentAmount; FormDS.FormDataTable tbSettlement = TAForm.GetDataByFormNo(settlementFormNo); if (tbSettlement.Rows.Count <= 0) { errorInfor = "第" + (i + 1) + "行有错:系统中找不到结案单《" + settlementFormNo + "》"; IsValid = false; } FormDS.FormRow settlementForm = tbSettlement[0]; FormDS.FormSaleSettlementRow rowSettlement = TAFormSettlement.GetDataByID(settlementForm.FormID)[0]; if (rowSettlement.PaymentTypeID != 2 && rowSettlement.PaymentTypeID != 5) { errorInfor = "第" + (i + 1) + "行有错:该单据支付方式,不是票扣或者调整因子《" + settlementFormNo + "》"; IsValid = false; } if (rowSettlement.IsClose) { errorInfor = "第" + (i + 1) + "行有错:该单据已标记为支付完成《" + settlementFormNo + "》"; IsValid = false; } if (rowSettlement.PaymentTypeID == 2 && PaymentAmount > rowSettlement.AmountRMB) { errorInfor = "第" + (i + 1) + "行有错:支付金额超过结案金额《" + settlementFormNo + "》"; IsValid = false; } if (IsValid) { //生成单据 rowForm = tbForm.NewFormRow(); rowPayment = tbPayment.NewFormSalePaymentRow(); //生成Form rowForm.SetRejectedFormIDNull(); //申请人取结案单申请人 rowForm.UserID = settlementForm.UserID; UtilityBLL utility = new UtilityBLL(); rowForm.FormNo = utility.GetFormNo(utility.GetFormTypeString((int)SystemEnums.FormType.SalePayment)); rowForm.SetProxyUserIDNull(); rowForm.SetProxyPositionIDNull(); //申请人部门取结案单申请人所在部门 rowForm.OrganizationUnitID = settlementForm.OrganizationUnitID; rowForm.PositionID = settlementForm.PositionID; rowForm.FormTypeID = (int)SystemEnums.FormType.SalePayment; rowForm.StatusID = (int)SystemEnums.FormStatus.ApproveCompleted; rowForm.SubmitDate = SubmitDate; rowForm.LastModified = SubmitDate; rowForm.InTurnUserIds = "P";//待改动 rowForm.InTurnPositionIds = "P";//待改动 rowForm.PageType = (int)SystemEnums.PageType.PaymentCash; rowForm.CostCenterID = settlementForm.CostCenterID; rowForm.ApprovedDate = SubmitDate; //是否创建凭证? rowForm.IsCreateVoucher = false; rowForm.IsExportLock = false; rowForm.IsCompletePayment = false; rowForm.IsInvoiceReturned = false; tbForm.AddFormRow(rowForm); TAForm.Update(rowForm); //生成FormPayment rowPayment.FormSalePaymentID = rowForm.FormID; rowPayment.FormSaleSettlementID = settlementForm.FormID; //生成时,不考虑预付款 rowPayment.SetFormSaleApplyIDNull(); rowPayment.InvoiceStatusID = (int)SystemEnums.InvoiceStatus.No; rowPayment.PaymentTypeID = rowSettlement.PaymentTypeID; //报销申请单备注 rowPayment.Remark = "此单据为自动生成单据。"; rowPayment.SetAttachedFileNameNull(); rowPayment.SetRealAttachedFileNameNull(); //报销金额 rowPayment.AmountRMB = PaymentAmount; rowPayment.VatTypeID = 1; rowPayment.AmountBeforeTax = rowPayment.AmountRMB; rowPayment.TaxAmount = 0; rowPayment.IsAdvanced = false; //VendorID设置什么值 rowPayment.SetVendorIDNull(); tbPayment.AddFormSalePaymentRow(rowPayment); TASalePayment.Update(rowPayment); //生成FormPaymentDetail decimal UsedAmount = 0; FormDS.FormSettlementExpenseDetailDataTable tbSettlementExpenseDetail = TAFormSettlementExpenseDetail.GetDataByFormSaleSettlementID(rowSettlement.FormSaleSettlementID); FormDS.FormSettlementExpenseDetailRow rowSettlementExpenseDetail = null; for (int j = 0; j < tbSettlementExpenseDetail.Rows.Count; j++) { rowSettlementExpenseDetail = (FormDS.FormSettlementExpenseDetailRow)tbSettlementExpenseDetail.Rows[j]; rowPaymentDetail = tbPaymentDetail.NewFormSalePaymentDetailRow(); rowPaymentDetail.FormSalePaymentID = rowPayment.FormSalePaymentID; rowPaymentDetail.FormSaleApplyID = rowSettlementExpenseDetail.FormSaleApplyID; rowPaymentDetail.FormSaleExpenseDetailID = rowSettlementExpenseDetail.FormSaleExpenseDetailID; rowPaymentDetail.ApplyFormNo = rowSettlementExpenseDetail.ApplyFormNo; rowPaymentDetail.ApplyPeriod = rowSettlementExpenseDetail.ApplyPeriod; rowPaymentDetail.ApplyProjectName = rowSettlementExpenseDetail.ApplyProjectName; rowPaymentDetail.ExpenseItemID = rowSettlementExpenseDetail.ExpenseItemID; if (!rowSettlementExpenseDetail.IsShopNameNull()) { rowPaymentDetail.ShopName = rowSettlementExpenseDetail.ShopName; } rowPaymentDetail.SKUID = rowSettlementExpenseDetail.SKUID; rowPaymentDetail.ApplyAmount = rowSettlementExpenseDetail.ApplyAmount; rowPaymentDetail.ApplyAmountRMB = rowSettlementExpenseDetail.ApplyAmountRMB; rowPaymentDetail.SettlementAmount = rowSettlementExpenseDetail.AmountRMB; rowPaymentDetail.TaxAmount = 0; //待改动 if (j == tbSettlementExpenseDetail.Rows.Count - 1) { rowPaymentDetail.AmountRMB = PaymentAmount - UsedAmount; rowPaymentDetail.AmountBeforeTax = rowPaymentDetail.AmountRMB; rowPaymentDetail.TaxAmount = rowPaymentDetail.TaxAmount; rowPaymentDetail.PayedAmount = 0; rowPaymentDetail.RemainAmount = 0; UsedAmount += rowPaymentDetail.AmountRMB; } else { rowPaymentDetail.AmountRMB = decimal.Round((rowSettlementExpenseDetail.AmountRMB / rowSettlement.AmountRMB) * PaymentAmount, 2); rowPaymentDetail.AmountBeforeTax = rowPaymentDetail.AmountRMB; rowPaymentDetail.TaxAmount = 0; rowPaymentDetail.PayedAmount = 0; rowPaymentDetail.RemainAmount = 0; UsedAmount += rowPaymentDetail.AmountRMB; } tbPaymentDetail.AddFormSalePaymentDetailRow(rowPaymentDetail); TASalePaymentDetail.Update(tbPaymentDetail); } logDetailRow.PaymentFormNo = rowForm.FormNo; } } transaction.Commit(); } catch (Exception e) { transaction.Rollback(); errorInfor = e.Message.ToString(); } finally { transaction.Dispose(); } return errorInfor; }