/// <summary> /// LogicDeleteInfo /// </summary> /// <param name="id"></param> /// <param name="loginUser"></param> /// <returns></returns> public bool LogicDeleteInfo(long id, string loginUser) { BusinessExpenseOutInfo info = dal.GetInfo(id); if (info.CheckFlag.GetValueOrDefault()) { throw new Exception("MC:0x00000329");///已对账的费用不允许删除 } if (info.PaymentFlag.GetValueOrDefault()) { throw new Exception("MC:0x00000346");///已销账的费用不允许删除 } if (info.ApprovalFlag.GetValueOrDefault()) { throw new Exception("MC:0x00000347");///已审核的费用不允许删除 } return(dal.LogicDelete(id, loginUser) > 0 ? true : false); }
/// <summary> /// InsertInfo /// </summary> /// <param name="info"></param> /// <returns></returns> public long InsertInfo(BusinessExpenseOutInfo info) { if (info.SourceBusinessFid == null) { info.SourceBusinessFid = new PlanPullOrderDAL().GetFid(info.OrderNo); info.SourceBusinessNo = info.OrderNo; } ///获取费用类型 if (!string.IsNullOrEmpty(info.ExpenseCode)) { info.ExpenseType = new ExpenseItemDAL().GetExpenseType(info.ExpenseCode); } ///流程标记默认为false,否则检索条件不能成功检索 info.CheckFlag = false; ///对账 info.PaymentFlag = false; ///销账 info.ApprovalFlag = false; ///审核 return(dal.Add(info)); }
/// <summary> /// UpdateInfo /// </summary> /// <param name="fields"></param> /// <param name="id"></param> /// <returns></returns> public bool UpdateInfo(string fields, long id) { BusinessExpenseOutInfo info = dal.GetInfo(id); if (info == null) { throw new Exception("MC:0x00000084");///数据错误 } if (info.ApprovalFlag.GetValueOrDefault()) { throw new Exception("MC:0x00000348");///已审核不允许进行修改 } ///销账->审核之间 if (info.PaymentFlag.GetValueOrDefault()) { ///审批编号 string approvalNo = CommonBLL.GetFieldValue(fields, "APPROVAL_NO"); if (string.IsNullOrEmpty(approvalNo)) { approvalNo = string.Empty; } /// string loginUser = CommonBLL.GetFieldValue(fields, "MODIFY_USER"); return(dal.UpdateInfo("[APPROVAL_NO] = N'" + approvalNo + "',[MODIFY_DATE] = GETDATE(),[MODIFY_USER] = N'" + loginUser + "'", id) > 0 ? true : false); } ///对账->销账之间 if (info.CheckFlag.GetValueOrDefault()) { ///实付金额 string actualAmount = CommonBLL.GetFieldValue(fields, "ACTUAL_AMOUNT"); if (string.IsNullOrEmpty(actualAmount)) { actualAmount = "NULL"; } ///财务凭证号 string fiDocNo = CommonBLL.GetFieldValue(fields, "FI_DOC_NO"); if (string.IsNullOrEmpty(fiDocNo)) { fiDocNo = string.Empty; } ///财务凭证号 string noInvoiceFlag = CommonBLL.GetFieldValue(fields, "NO_INVOICE_FLAG"); if (string.IsNullOrEmpty(noInvoiceFlag)) { noInvoiceFlag = "0"; } ///审批编号 string approvalNo = CommonBLL.GetFieldValue(fields, "APPROVAL_NO"); if (string.IsNullOrEmpty(approvalNo)) { approvalNo = string.Empty; } /// string loginUser = CommonBLL.GetFieldValue(fields, "MODIFY_USER"); return(dal.UpdateInfo("" + "[ACTUAL_AMOUNT] = " + actualAmount + "," + "[FI_DOC_NO] = N'" + fiDocNo + "'," + "[APPROVAL_NO] = N'" + approvalNo + "'," + "[NO_INVOICE_FLAG] = " + noInvoiceFlag + "," + "[MODIFY_DATE] = GETDATE()," + "[MODIFY_USER] = N'" + loginUser + "'", id) > 0 ? true : false); } return(dal.UpdateInfo(fields, id) > 0 ? true : false); }
/// <summary> /// InsertInfo /// </summary> /// <param name="info"></param> /// <returns></returns> public long InsertInfo(BusinessExpenseOutInfo info) { return(new BusinessExpenseOutBLL().InsertInfo(info)); }