/// <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));
}
