public InterruptOrCancelReimburses(Account loginUser, int reimburseID, ReimburseStatusEnum statusEnum, IReimburse iReimburseMock)
{
_DalReimburse = iReimburseMock;
_ReimburseID = reimburseID;
_LoginUser = loginUser;
_StatusEnum = statusEnum;
}
public static string GetReimburseStatusNameByReimburseStatus(ReimburseStatusEnum reimburseStatus)
{
switch (reimburseStatus)
{
case ReimburseStatusEnum.Added:
return("新增");
case ReimburseStatusEnum.Reimbursing:
return("提交中");
case ReimburseStatusEnum.Reimbursed:
return("已报销");
case ReimburseStatusEnum.Return:
return("退回");
case ReimburseStatusEnum.Auditing:
return("通过审核");
case ReimburseStatusEnum.WaitAudit:
return("待财务审核");
default:
return("");
}
}
/// <summary>
/// 查询客户维护
/// </summary>
/// <param name="loginUser"></param>
/// <param name="employeename"></param>
/// <param name="departmentid"></param>
/// <param name="statusEnum"></param>
/// <param name="reimburseCategoriesEnumID"></param>
/// <param name="totalcostfrom"></param>
/// <param name="totalcostto"></param>
/// <param name="applydateFrom"></param>
/// <param name="applydateTo"></param>
/// <param name="billtimeFrom"></param>
/// <param name="billtimeTo"></param>
/// <param name="companyID"></param>
/// <param name="auth"></param>
/// <param name="finishStatus"></param>
/// <param name="isCustomerFilled"></param>
/// <returns></returns>
public List <Model.Reimburse> GetReimburseForCustomerByCondition(Account loginUser, string employeename, int departmentid,
ReimburseStatusEnum statusEnum,
int reimburseCategoriesEnumID, decimal?totalcostfrom,
decimal?totalcostto, DateTime?applydateFrom,
DateTime?applydateTo, DateTime?billtimeFrom, DateTime?billtimeTo,
int companyID, int auth, int finishStatus, int isCustomerFilled)
{
List <Model.Reimburse> reimburses =
GetReimburseByCondition(loginUser, employeename, departmentid, statusEnum, reimburseCategoriesEnumID,
totalcostfrom, totalcostto, applydateFrom, applydateTo, billtimeFrom, billtimeTo,
companyID, auth, finishStatus);
reimburses = RemoveReimburseByStatus(reimburses, ReimburseStatusEnum.Added);
//匹配IsCustomerNull条件
for (int i = 0; i < reimburses.Count; i++)
{
if (isCustomerFilled == 1 && string.IsNullOrEmpty(reimburses[i].CustomerContentShow))
{
reimburses.RemoveAt(i);
i--;
}
if (isCustomerFilled == 0 && !string.IsNullOrEmpty(reimburses[i].CustomerContentShow))
{
reimburses.RemoveAt(i);
i--;
}
}
return(reimburses);
}
public static List <Reimburse> GetReimburseByCondition(Account loginUser, string employeename, int departmentid,
ReimburseStatusEnum statusEnum, ReimburseStatusEnum?exceptStatusEnum, bool?isFillCustomer,
int reimburseCategoriesEnumID, decimal?totalcostfrom,
decimal?totalcostto, DateTime?applydateFrom,
DateTime?applydateTo, DateTime?billtimeFrom,
DateTime?billtimeTo,
int companyID, int finishStatus, int auth,
PagerEntity pagerEntity)
{
List <int> departmentids = new List <int>();
if (departmentid != -1)
{
List <Department> departments = BllInstance.DepartmentBllInstance.GetChildDeptList(departmentid);
departmentids.Add(departmentid);
departmentids.AddRange(departments.Select(x => x.DepartmentID).ToList());
}
var reimburseentities = ReimburseDA.GetReimburseByCondition(departmentids, statusEnum, exceptStatusEnum, isFillCustomer,
reimburseCategoriesEnumID,
totalcostfrom, totalcostto, applydateFrom,
applydateTo, billtimeFrom, billtimeTo,
companyID, finishStatus);
var reimburses = reimburseentities.Select(ReimburseEntity.ConvertToReimburse).ToList();
List <Account> accounts =
BllInstance.AccountBllInstance.GetAccountByBaseCondition(employeename, departmentid, -1, null, true,
null);
accounts = Tools.RemoteUnAuthAccount(accounts, AuthType.HRMIS, loginUser, auth);
for (int i = reimburses.Count - 1; i >= 0; i--)
{
if (!IsContainsAccount(accounts, reimburses[i].ApplierID))
{
reimburses.RemoveAt(i);
}
}
var reimbursesids = new List <int>();
for (int i = pagerEntity.PageIndex * pagerEntity.PageSize;
i < (pagerEntity.PageIndex + 1) * pagerEntity.PageSize && i < reimburses.Count;
i++)
{
Account account = BllInstance.AccountBllInstance.GetAccountById(reimburses[i].ApplierID);
reimburses[i].ApplerName = account.Name;
reimburses[i].Department.DepartmentName = account.Dept.DepartmentName;
reimbursesids.Add(reimburses[i].ReimburseID);
}
var items = ReimburseItemDA.GetReimburseItemByReimburseID(reimbursesids);
for (int i = pagerEntity.PageIndex * pagerEntity.PageSize;
i < (pagerEntity.PageIndex + 1) * pagerEntity.PageSize && i < reimburses.Count;
i++)
{
reimburses[i].ReimburseItems =
items.Where(x => x.ReimburseID == reimburses[i].ReimburseID).Select(ReimburseItemEntity.ConvertTo).
ToList();
}
return(reimburses);
}
public static void UpdateReimburseStatus(int id, ReimburseStatusEnum status)
{
using (var dataOperator = new DataOperator(SqlHelper.HrmisConnectionString))
{
dataOperator.CommandText = "Update TReimburse set ReimburseStatus=@ReimburseStatus where PKID=@PKID";
dataOperator.SetParameter("@ReimburseStatus", (int)status, SqlDbType.Int);
dataOperator.SetParameter("@PKID", id, SqlDbType.Int);
dataOperator.ExecuteNonQuery();
}
}
public List <Model.Reimburse> GetReimburseByCondition(Account loginUser, string employeename, int departmentid,
ReimburseStatusEnum statusEnum,
int reimburseCategoriesEnumID, decimal?totalcostfrom,
decimal?totalcostto, DateTime?applydateFrom,
DateTime?applydateTo, DateTime?billtimeFrom, DateTime?billtimeTo,
int companyID, int auth, int finishStatus)
{
List <Model.Reimburse> reimburses = new List <Model.Reimburse>();
if (departmentid != -1)
{
reimburses =
_DalReimburse.GetReimburseByCondition(departmentid, statusEnum, reimburseCategoriesEnumID,
totalcostfrom,
totalcostto, applydateFrom, applydateTo, billtimeFrom,
billtimeTo, companyID, finishStatus);
List <Department> departments = _IGetDepartment.GetChildDeptList(departmentid);
foreach (Department department in departments)
{
reimburses.AddRange(
_DalReimburse.GetReimburseByCondition(department.Id, statusEnum, reimburseCategoriesEnumID,
totalcostfrom,
totalcostto, applydateFrom, applydateTo, billtimeFrom,
billtimeTo, companyID, finishStatus));
}
}
else
{
reimburses = _DalReimburse.GetReimburseByCondition(departmentid, statusEnum, reimburseCategoriesEnumID,
totalcostfrom,
totalcostto, applydateFrom, applydateTo, billtimeFrom,
billtimeTo, companyID, finishStatus);
}
List <Account> accounts =
BllInstance.AccountBllInstance.GetAccountByBaseCondition(employeename, departmentid, -1, null, true, null);
accounts = Tools.RemoteUnAuthAccount(accounts, AuthType.HRMIS, loginUser, auth);
for (int i = reimburses.Count - 1; i >= 0; i--)
{
if (!IsContainsAccount(accounts, reimburses[i].ApplierID))
{
reimburses.RemoveAt(i);
}
else
{
Account account = BllInstance.AccountBllInstance.GetAccountById(reimburses[i].ApplierID);
reimburses[i].ApplerName = account.Name;
reimburses[i].Department.DepartmentName = account.Dept.DepartmentName;
}
}
return(reimburses);
}
public List <Reimburse> GetReimburseByCondition(Account loginUser, string employeename, int departmentid,
ReimburseStatusEnum statusEnum, int reimburseCategoriesEnumID,
decimal?totalcostfrom, decimal?totalcostto,
DateTime?applydateFrom, DateTime?applydateTo,
DateTime?billtimeFrom, DateTime?billtimeTo, int companyID,
int auth, int finishStatus)
{
return
(new GetReimburse().GetReimburseByCondition(loginUser, employeename, departmentid, statusEnum,
reimburseCategoriesEnumID, totalcostfrom, totalcostto,
applydateFrom, applydateTo, billtimeFrom, billtimeTo,
companyID, auth, finishStatus));
}
private void Execute(ReimburseStatusEnum reimburseStatusEnum)
{
hrmisModel.Reimburse reimburse = _IReimburseView.Reimburse;
reimburse.ReimburseStatus = reimburseStatusEnum;
if (reimburseStatusEnum == ReimburseStatusEnum.Reimbursing)
{
reimburse.CommitTime = DateTime.Now.ToString();
}
reimburse.ReimburseID = _ReimburseID;
reimburse.Department = _LoginUser.Dept;
reimburse.ReimburseCategoriesEnum =
ReimburseCategoriesEnum.GetById(Convert.ToInt32(_IReimburseView.ReimburseCategoriesEnumID));
DateTime consumeDateFrom = Convert.ToDateTime(_IReimburseView.ConsumeDateFrom);
DateTime consumeDateTo = Convert.ToDateTime(_IReimburseView.ConsumeDateTo);
reimburse.ConsumeDateFrom = new DateTime(consumeDateFrom.Year, consumeDateFrom.Month, consumeDateFrom.Day,
Convert.ToInt32(_IReimburseView.ConsumeDateFromHour),
Convert.ToInt32(_IReimburseView.ConsumeDateFromMinute), 0);
reimburse.ConsumeDateTo = new DateTime(consumeDateTo.Year, consumeDateTo.Month, consumeDateTo.Day,
Convert.ToInt32(_IReimburseView.ConsumeDateToHour),
Convert.ToInt32(_IReimburseView.ConsumeDateToMinute), 0);
reimburse.PaperCount = Convert.ToInt32(_IReimburseView.PaperCount);
reimburse.Destinations = _IReimburseView.Destinations;
reimburse.ExchangeRateID = _IReimburseView.ExchangeRateID;
//reimburse.CustomerID = string.Empty;
reimburse.ProjectName = _IReimburseView.ProjectName;
reimburse.Discription = _IReimburseView.Discription;
//UpdateReimburse updateReimburse = new UpdateReimburse(_EmployeeID, reimburse);
//try
//{
// updateReimburse.Excute();
// ToMyReimbursePage(null, null);
//}
//catch (ApplicationException ae)
//{
// _IReimburseView.Message = ae.Message;
//}
try
{
_IReimburseFacade.UpdateReimburse(_LoginUser.Id, reimburse);
ToMyReimbursePage(null, null);
}
catch (ApplicationException ae)
{
_IReimburseView.Message = ae.Message;
}
}
public static List <ReimburseEntity> GetReimburseByCondition(List <int> departmentId, ReimburseStatusEnum statusEnum, ReimburseStatusEnum?exceptStatusEnum, bool?isFillCustomer, int reimburseCategoriesEnumID,
decimal?totalcostfrom,
decimal?totalcostto, DateTime?applydateFrom,
DateTime?applydateTo, DateTime?billtimeFrom, DateTime?billtimeTo,
int companyID, int finishStatus)
{
using (var dataOperator = new DataOperator(SqlHelper.HrmisConnectionString))
{
dataOperator.CommandText = @"SELECT a.*,b.Name as ExchangeRateName,b.Symbol as ExchangeSymbol,b.Rate as ExchangeRate
from TReimburse as a with(nolock) left join TExchangeRate as b with(nolock) on a.ExchangeRateID=b.PKID WHERE 1=1 ";
if (departmentId != null && departmentId.Count > 0)
{
dataOperator.CommandText += string.Format(" and DepartmentID in ({0})", string.Join(",", departmentId));
}
if ((int)statusEnum != -1)
{
dataOperator.CommandText += " and ReimburseStatus=@ReimburseStatus";
dataOperator.SetParameter("@ReimburseStatus", (int)statusEnum, SqlDbType.Int);
}
if (exceptStatusEnum != null)
{
dataOperator.CommandText += " and ReimburseStatus<>@ExceptReimburseStatus";
dataOperator.SetParameter("@ExceptReimburseStatus", (int)exceptStatusEnum, SqlDbType.Int);
}
if (isFillCustomer != null)
{
dataOperator.CommandText += " and a.PKID in (select ReimburseID from TReimburseItem with(nolock) where CustomerID" + (isFillCustomer.Value ? "<>" : "=") + "0)";
}
if (reimburseCategoriesEnumID != -1)
{
dataOperator.CommandText += " and ReimburseCategoriesEnum=@ReimburseCategoriesEnum";
dataOperator.SetParameter("@ReimburseCategoriesEnum", reimburseCategoriesEnumID, SqlDbType.Int);
}
if (companyID != -1)
{
dataOperator.CommandText += " and EmployeeId in (select AccountID from TEmployee where CompanyID=@CompanyID) ";
dataOperator.SetParameter("@CompanyID", companyID, SqlDbType.Int);
}
if (finishStatus != -1)
{
if (finishStatus == 0)
{
dataOperator.CommandText += " and Reimbursestatus<>2";
}
if (finishStatus == 1)
{
dataOperator.CommandText += " and Reimbursestatus=2";
}
}
if (totalcostfrom != null)
{
dataOperator.CommandText += " and TotalCost>=@TotalCostFrom";
dataOperator.SetParameter("@TotalCostFrom", totalcostfrom, SqlDbType.Decimal);
}
if (totalcostto != null)
{
dataOperator.CommandText += " and TotalCost<=@TotalCostTo";
dataOperator.SetParameter("@TotalCostTo", totalcostto, SqlDbType.Decimal);
}
if (applydateFrom != null)
{
dataOperator.CommandText += " and ApplyDate>=@ApplyDateFrom";
dataOperator.SetParameter("@ApplyDateFrom", applydateFrom.GetValueOrDefault().Date, SqlDbType.DateTime);
}
if (applydateTo != null)
{
dataOperator.CommandText += " and ApplyDate<@ApplyDateTo";
dataOperator.SetParameter("@ApplyDateTo", applydateTo.GetValueOrDefault().AddDays(1).Date, SqlDbType.DateTime, 2);
}
if (billtimeFrom != null)
{
dataOperator.CommandText += " and BillingTime>=@BillingTimeFrom";
dataOperator.SetParameter("@BillingTimeFrom", billtimeFrom.GetValueOrDefault().Date, SqlDbType.DateTime);
}
if (billtimeTo != null)
{
dataOperator.CommandText += " and BillingTime<@BillingTimeTo";
dataOperator.SetParameter("@BillingTimeTo", billtimeTo.GetValueOrDefault().AddDays(1).Date, SqlDbType.DateTime);
}
dataOperator.CommandText += " order By ApplyDate desc ";
return(dataOperator.ExecuteEntityList <ReimburseEntity>());
}
}
public InterruptOrCancelReimburses(Account loginUser, int reimburseID, ReimburseStatusEnum statusEnum)
{
_ReimburseID = reimburseID;
_LoginUser = loginUser;
_StatusEnum = statusEnum;
}
public Reimburse(DateTime applyDate, ReimburseStatusEnum reimburseStatus)
{
_ApplyDate = applyDate;
_ReimburseStatus = reimburseStatus;
}
public static void AddReimburseStatusValueAndNameIntoDictionary(Dictionary <string, string> dictionaryData,
ReimburseStatusEnum reimburseStatusEnum)
{
dictionaryData.Add(((int)reimburseStatusEnum).ToString(),
GetReimburseStatusNameByReimburseStatus(reimburseStatusEnum));
}
private List <Model.Reimburse> RemoveReimburseByStatus(List <Model.Reimburse> reimburseList, ReimburseStatusEnum reimburseStatusEnum)
{
List <Model.Reimburse> returnList = new List <Model.Reimburse>();
foreach (Model.Reimburse reimburse in reimburseList)
{
if (!reimburse.ReimburseStatus.Equals(reimburseStatusEnum))
{
returnList.Add(reimburse);
}
}
return(returnList);
}
public ReimburseFlow(Employee _operator, DateTime operatorTime, ReimburseStatusEnum reimburseStatusEnum)
{
_Operator = _operator;
_OperationTime = operatorTime;
_ReimburseStatusEnum = reimburseStatusEnum;
}
