/// <summary>
/// 报废费用申请单
/// </summary>
/// <param name="expCode">费用申请单编号</param>
/// <param name="strCompanyCD">公司编号</param>
/// <param name="UserID">用户账号</param>
/// <param name="strMsg">返回操作信息</param>
/// <returns></returns>
public static bool ScrapExpenses(string expCode, string strCompanyCD, string UserID, out string strMsg)
{
return(ExpensesDBHelper.ScrapExpenses(expCode, strCompanyCD, UserID, out strMsg));
}
/// <summary>
/// 根据单据编号获取单据ID
/// </summary>
/// <param name="strCode"></param>
/// <param name="strCompanyCD"></param>
/// <returns></returns>
public static int GetExpApplyID(string strCode, string strCompanyCD)
{
return(ExpensesDBHelper.GetExpApplyID(strCode, strCompanyCD));
}
/// <summary>
/// 确认费用申请单
/// </summary>
/// <param name="expCode"></param>
/// <param name="strCompanyCD"></param>
/// <param name="strMsg"></param>
/// <returns></returns>
public static bool ConfirmExpApply(string expCode, string strCompanyCD, string EmployeeName, int EmployeeID, string UserID, out string strMsg)
{
return(ExpensesDBHelper.ConfirmExpApply(expCode, strCompanyCD, EmployeeName, EmployeeID, UserID, out strMsg));
}
/// <summary>
/// 取消确认费用申请单
/// </summary>
/// <param name="expCode"></param>
/// <param name="strCompanyCD"></param>
/// <param name="strMsg"></param>
/// <returns></returns>
public static bool UnConfirmExpApply(string expCode, string strCompanyCD, string UserID, out string strMsg)
{
return(ExpensesDBHelper.UnConfirmExpApply(expCode, strCompanyCD, UserID, out strMsg));
}
/// 根据查询条件获取已审批的费用申请单列表
public static DataTable GetExpensesApplyAuditList(ExpensesApplyModel expApplyModel, int empid, DateTime?AriseDate1, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return(ExpensesDBHelper.GetExpensesApplyAuditList(expApplyModel, empid, AriseDate1, pageIndex, pageCount, ord, ref TotalCount));
}
/// <summary>
/// 修改费用申请单
/// </summary>
/// <param name="expApplyModel">费用主表Model</param>
/// <param name="expDetailModelList">费用明细表Model</param>
/// <param name="strMsg">消息字符串</param>
/// <returns></returns>
public static bool UpdateExpensesApply(ExpensesApplyModel expApplyModel, List <ExpDetailsModel> expDetailModelList, out string strMsg)
{
return(ExpensesDBHelper.UpdateExpensesApply(expApplyModel, expDetailModelList, out strMsg));
}
/// <summary>
/// 获取费用申请打印子表信息
/// </summary>
/// <param name="expCode">费用申请编号</param>
/// <returns></returns>
public static DataTable GetRepExpApplyDetail(string expCode, string strCompanyCD)
{
return(ExpensesDBHelper.GetRepExpApplyDetail(expCode, strCompanyCD));
}
//根据员工ID获取员工所在部门
public static DataTable GetDeptIDByEmployeeID(int ApplyorID, string strCompanyCD)
{
return(ExpensesDBHelper.GetDeptIDByEmployeeID(ApplyorID, strCompanyCD));
}
/// <summary>
/// 根据公司编号获取该公司的员工Name、ID
/// </summary>
/// <param name="strCompany"></param>
/// <returns></returns>
public static DataTable GetEmployeeName(string strCompany)
{
return(ExpensesDBHelper.GetEmployeeName(strCompany));
}
/// <summary>
/// 删除已选择的费用申请单
/// </summary>
/// <param name="expID">费用申请单ID</param>
/// <param name="strCompanyCD">公司编码</param>
/// <param name="strMsg"></param>
/// <param name="strFieldText"></param>
/// <returns></returns>
public static bool DelExpensesApply(string expID, string strCompanyCD, out string strMsg, out string strFieldText)
{
return(ExpensesDBHelper.DelExpensesApply(expID, strCompanyCD, out strMsg, out strFieldText));
}
/// <summary>
/// 获取该公司的费用大类
/// </summary>
/// <param name="strCompanyCD"></param>
/// <returns></returns>
public static DataTable GetExpBigType(string strCompanyCD, string flagType, string flagCode)
{
return(ExpensesDBHelper.GetExpBigType(strCompanyCD, flagType, flagCode));
}
/// <summary>
/// 根据费用申请单ID获取子表费用明细信息
/// </summary>
/// <param name="expID">费用申请单ID</param>
/// <param name="strCompanyCD">公司编码</param>
/// <returns></returns>
public static DataTable GetExpDetailsByExpID(int expID, string strCompanyCD)
{
return(ExpensesDBHelper.GetExpDetailsByExpID(expID, strCompanyCD));
}
/// <summary>
/// 根据查询条件，获取所以符合条件记录的金额合计
/// </summary>
/// <param name="expApplyMOdel">ExpensesApplyModel实体</param>
/// <param name="empid"></param>
/// <param name="AriseDate1"></param>
/// <param name="FlowStatus"></param>
/// <returns></returns>
public static DataTable GetExpSumTotal(ExpensesApplyModel expApplyMOdel, int empid, DateTime?AriseDate1, string FlowStatus)
{
return(ExpensesDBHelper.GetExpSumTotal(expApplyMOdel, empid, AriseDate1, FlowStatus));
}