public bool DeleteTravelReimbursement(string[] TravelReimbursementID, ref bool FBControl)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
return(TrBll.DeleteTravelReimbursement(TravelReimbursementID, ref FBControl));
}
}
private bool IsExistTravelReimbursementBySportid(string ownerid, string sportid)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
return TrBll.IsExistTravelReimbursementBySportid(ownerid, sportid);
}
}
private bool IsExistTravelReimbursementBySportid(string ownerid, string sportid)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
return(TrBll.IsExistTravelReimbursementBySportid(ownerid, sportid));
}
}
private bool IsExistTravelReimbursement(string ownerid, string TravelReimbursementID)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
return TrBll.IsExistContractTravelReimbursement(ownerid, TravelReimbursementID);
}
}
public bool CheckTravelReimbursementByBusinesstrip(string businesstripId)
{
using (TravelReimbursementBLL trBll = new TravelReimbursementBLL())
{
return(trBll.CheckTravelReimbursementByBusinesstrip(businesstripId));
}
}
private bool IsExistTravelReimbursement(string ownerid, string TravelReimbursementID)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
return(TrBll.IsExistContractTravelReimbursement(ownerid, TravelReimbursementID));
}
}
public string TravelReimbursementAdd(T_OA_TRAVELREIMBURSEMENT TravelReimbursement, List <T_OA_REIMBURSEMENTDETAIL> portDetail)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
string returnStr = "";
if (!this.IsExistTravelReimbursementBySportid(TravelReimbursement.CLAIMSWERE, TravelReimbursement.T_OA_BUSINESSTRIP.BUSINESSTRIPID))
{
if (!this.IsExistTravelReimbursement(TravelReimbursement.CLAIMSWERE, TravelReimbursement.TRAVELREIMBURSEMENTID))
{
if (!TrBll.TravelReimbursementAdd(TravelReimbursement, portDetail))
{
returnStr = "添加数据失败";
}
}
else
{
returnStr = "出差报销已经存在,请勿重复添加";
}
}
else
{
returnStr = "出差报销已经存在,请勿重复添加";
}
return(returnStr);
}
}
public List <T_OA_TRAVELREIMBURSEMENT> GetTravelReimbursementInfo()
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
IQueryable <T_OA_TRAVELREIMBURSEMENT> TravelReimbursementList = TrBll.GetTravelReimbursement();
return(TravelReimbursementList == null ? null : TravelReimbursementList.ToList());
}
}
public T_OA_TRAVELREIMBURSEMENT GetTravelReimbursementById(string TravelReimbursementID)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
T_OA_TRAVELREIMBURSEMENT TravelReimbursement = TrBll.GetTravelReimbursementById(TravelReimbursementID);
return TravelReimbursement != null ? TravelReimbursement : null;
}
}
public T_OA_TRAVELREIMBURSEMENT GetTravelReimbursementById(string TravelReimbursementID)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
T_OA_TRAVELREIMBURSEMENT TravelReimbursement = TrBll.GetTravelReimbursementById(TravelReimbursementID);
return(TravelReimbursement != null ? TravelReimbursement : null);
}
}
public List<T_OA_TRAVELREIMBURSEMENT> GetTravelReimbursementInfo()
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
IQueryable<T_OA_TRAVELREIMBURSEMENT> TravelReimbursementList = TrBll.GetTravelReimbursement();
return TravelReimbursementList == null ? null : TravelReimbursementList.ToList();
}
}
public List <T_OA_REIMBURSEMENTDETAIL> GetTravelReimbursementDetail(string detailId)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
List <T_OA_REIMBURSEMENTDETAIL> details = TrBll.GetTravelReimbursementDetail(detailId);
return(details);
}
}
public List<T_OA_REIMBURSEMENTDETAIL> GetTravelReimbursementDetail(string detailId)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
List<T_OA_REIMBURSEMENTDETAIL> details = TrBll.GetTravelReimbursementDetail(detailId);
return details;
}
}
public string UpdateNoClaims(T_OA_TRAVELREIMBURSEMENT TravelNoClaims, List<T_OA_REIMBURSEMENTDETAIL> portDetail, string FormType)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
string result = "";
if (!TrBll.UpdateNoClaims(TravelNoClaims, portDetail, FormType))
{
result = "修改数据失败！";
}
return result;
}
}
public string UpdateNoClaims(T_OA_TRAVELREIMBURSEMENT TravelNoClaims, List <T_OA_REIMBURSEMENTDETAIL> portDetail, string FormType)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
string result = "";
if (!TrBll.UpdateNoClaims(TravelNoClaims, portDetail, FormType))
{
result = "修改数据失败！";
}
return(result);
}
}
/// <summary>
/// 修改实体审核状态
/// </summary>
/// <param name="strEntityName">实体名</param>
/// <param name="EntityKeyName">主键名</param>
/// <param name="EntityKeyValue">主键值</param>
/// <param name="CheckState">审核状态</param>
public int UpdateCheckState(string strEntityName, string EntityKeyName, string EntityKeyValue, string CheckState)
{
try
{
using (CommDaL <TEntity> dal = new CommDaL <TEntity>())
{
int intResult = 0;
Tracer.Debug("进入了COMMONBLL，实体名：" + strEntityName + "，DateTime:" + System.DateTime.Now.ToString());
Tracer.Debug("实体ID名：" + EntityKeyName + "实体主键值：" + EntityKeyValue);
Tracer.Debug("审核的状态：" + CheckState);
switch (strEntityName)
{
case "T_OA_BUSINESSTRIP": //出差申请
using (TravelmanagementBLL TravelRequestBll = new TravelmanagementBLL())
{
intResult = TravelRequestBll.UpdateTravelRequestFromEngine(EntityKeyValue, CheckState);
}
break;
//case "T_OA_BUSINESSREPORT"://出差报告
// MissionReportsBLL TravelReportBll = new MissionReportsBLL();
// intResult = TravelReportBll.UpdateTravelReportFromEngine(EntityKeyValue, CheckState);
// break;
case "T_OA_TRAVELREIMBURSEMENT": //出差报销
using (TravelReimbursementBLL TravelReimbursementBll = new TravelReimbursementBLL())
{
intResult = TravelReimbursementBll.UpdateTravelReimbursementFromEngine(EntityKeyValue, CheckState);
}
break;
case "T_OA_SENDDOC":
using (BumfCompanySendDocManagementBll sendDocBll = new BumfCompanySendDocManagementBll())
{
intResult = sendDocBll.UpdateCheckStateBumfEngine(EntityKeyValue, CheckState);
}
break;
default:
intResult = dal.UpdateCheckState(strEntityName, EntityKeyName, EntityKeyValue, CheckState);
break;
}
return(intResult);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <T_OA_TRAVELREIMBURSEMENT> GetTravelReimbursementRoomInfos()
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
List <T_OA_TRAVELREIMBURSEMENT> TravelReimbursementRoomList = TrBll.GetTravelReimbursementRooms();
if (TravelReimbursementRoomList == null)
{
return(null);
}
else
{
return(TravelReimbursementRoomList);
}
}
}
public bool DeleteTravelReimbursementByBusinesstripId(string[] TravelmanagementID, ref bool FBControl)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
var TravelReimbursementID = TrBll.GetReimbursementIDsByBusinesstripId(TravelmanagementID);
if (TravelmanagementID.Count() > 0)
{
return(TrBll.DeleteTravelReimbursement(TravelReimbursementID.ToArray(), ref FBControl));
}
else
{
SMT.Foundation.Log.Tracer.Debug("TravelReimbursermentService-DeleteTravelReimbursementByBusinesstripId TravelReimbursementID为零");
}
return(false);
}
}
public string TravelReimbursementAddSimple(T_OA_TRAVELREIMBURSEMENT TravelReimbursement, List <T_OA_REIMBURSEMENTDETAIL> portDetail, string busnid)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
string returnStr = "";
if (!TrBll.TravelReimbursementAdd(TravelReimbursement, portDetail))
{
returnStr = "添加数据失败";
}
else
{
TrBll.DeleteTheSameTravelreimbursement(busnid);
}
return(returnStr);
}
}
public string UpdateEntityXML(string Formid, string OldString, string ReplaceString)
{
try
{
TravelReimbursementBLL bll=new TravelReimbursementBLL();
ReplaceString = (from ent in bll.dal.GetObjects()
where ent.TRAVELREIMBURSEMENTID == Formid
select ent.NOBUDGETCLAIMS).FirstOrDefault();
if (string.IsNullOrEmpty(ReplaceString))
{
Tracer.Debug("出差报销提交审核替换元数据单号，获取的单号为空：" + ReplaceString);
return "";
}
//更新元数据里的报销单号
SMT.SaaS.BLLCommonServices.FlowWFService.ServiceClient client =
new SaaS.BLLCommonServices.FlowWFService.ServiceClient();
Tracer.Debug("开始调用元数据获取接口：FlowWFService.GetMetadataByFormid(" + Formid + ")");
string xml = string.Empty;
xml = client.GetMetadataByFormid(Formid);
Tracer.Debug("获取到的元数据：" + xml);
xml = xml.Replace("自动生成", ReplaceString);
Tracer.Debug("替换单号后的XML:" + xml);
bool flag = client.UpdateMetadataByFormid(Formid, xml);
if (flag)
{
Tracer.Debug("出差报销元数据替换单号成功：" + ReplaceString);
return "";
}
else
{
Tracer.Debug("出差报销元数据替换单号UpdateMetadataByFormid返回false：Formid：" + Formid
+ OldString
+ ReplaceString);
return "";
}
}
catch (Exception ex)
{
Tracer.Debug(ex.ToString());
return "";
}
}
public string UpdateEntityXML(string Formid, string OldString, string ReplaceString)
{
try
{
TravelReimbursementBLL bll = new TravelReimbursementBLL();
ReplaceString = (from ent in bll.dal.GetObjects()
where ent.TRAVELREIMBURSEMENTID == Formid
select ent.NOBUDGETCLAIMS).FirstOrDefault();
if (string.IsNullOrEmpty(ReplaceString))
{
Tracer.Debug("出差报销提交审核替换元数据单号，获取的单号为空：" + ReplaceString);
return("");
}
//更新元数据里的报销单号
SMT.SaaS.BLLCommonServices.FlowWFService.ServiceClient client =
new SaaS.BLLCommonServices.FlowWFService.ServiceClient();
Tracer.Debug("开始调用元数据获取接口：FlowWFService.GetMetadataByFormid(" + Formid + ")");
string xml = string.Empty;
xml = client.GetMetadataByFormid(Formid);
Tracer.Debug("获取到的元数据：" + xml);
xml = xml.Replace("自动生成", ReplaceString);
Tracer.Debug("替换单号后的XML:" + xml);
bool flag = client.UpdateMetadataByFormid(Formid, xml);
if (flag)
{
Tracer.Debug("出差报销元数据替换单号成功：" + ReplaceString);
return("");
}
else
{
Tracer.Debug("出差报销元数据替换单号UpdateMetadataByFormid返回false：Formid：" + Formid
+ OldString
+ ReplaceString);
return("");
}
}
catch (Exception ex)
{
Tracer.Debug(ex.ToString());
return("");
}
}
public List <V_TravelReimbursement> GetTravelReimbursementListByUserId(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string checkState, LoginUserInfo loginUserInfo)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
List <V_TravelReimbursement> ArchivesList = null;
if (checkState != ((int)CheckStates.WaittingApproval).ToString())//获取用户的提交报销信息
{
if (checkState != ((int)CheckStates.ALL).ToString())
{
ArchivesList = TrBll.GetTravelReimbursementInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, checkState, loginUserInfo.userID);
}
else
{
ArchivesList = TrBll.GetTravelReimbursementInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, "", loginUserInfo.userID);
}
return(ArchivesList != null?ArchivesList.ToList() : null);
}
else //通过工作流获取用户要审批的报销信息
{
FLOW_FLOWRECORDDETAIL_T flowInfo = new FLOW_FLOWRECORDDETAIL_T(); //审核人 操作
FLOW_FLOWRECORDDETAIL_T[] flowList = workFlowWS.GetFlowInfo("", "", "", "0", "T_OA_TRAVELREIMBURSEMENT", loginUserInfo.companyID, loginUserInfo.userID);
if (flowList == null)
{
return(null);
}
List <V_FlowAPP> flowAppList = new List <V_FlowAPP>();
for (int i = 0; i < flowList.Length; i++)
{
V_FlowAPP App = new V_FlowAPP();
App.Guid = flowList[i].FLOWRECORDDETAILID;
App.FormID = flowList[i].FLOW_FLOWRECORDMASTER_T.FORMID;
App.EditUserID = flowList[i].EDITUSERID;
App.EditUserName = flowList[i].EDITUSERNAME;
flowAppList.Add(App);
}
checkState = ((int)CheckStates.Approving).ToString();
ArchivesList = TrBll.GetTravelReimbursementInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, flowAppList, checkState, loginUserInfo.userID);
}
return(ArchivesList != null?ArchivesList.ToList() : null);
}
}
public bool DeleteTravelReimbursementByBusinesstripId(string[] TravelmanagementID, ref bool FBControl)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
var TravelReimbursementID = TrBll.GetReimbursementIDsByBusinesstripId(TravelmanagementID);
if (TravelmanagementID.Count() > 0)
{
return TrBll.DeleteTravelReimbursement(TravelReimbursementID.ToArray(), ref FBControl);
}
else
{
SMT.Foundation.Log.Tracer.Debug("TravelReimbursermentService-DeleteTravelReimbursementByBusinesstripId TravelReimbursementID为零");
}
return false;
}
}
public string TravelReimbursementAdd(T_OA_TRAVELREIMBURSEMENT TravelReimbursement, List<T_OA_REIMBURSEMENTDETAIL> portDetail)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
string returnStr = "";
if (!this.IsExistTravelReimbursementBySportid(TravelReimbursement.CLAIMSWERE, TravelReimbursement.T_OA_BUSINESSTRIP.BUSINESSTRIPID))
{
if (!this.IsExistTravelReimbursement(TravelReimbursement.CLAIMSWERE, TravelReimbursement.TRAVELREIMBURSEMENTID))
{
if (!TrBll.TravelReimbursementAdd(TravelReimbursement, portDetail))
{
returnStr = "添加数据失败";
}
}
else
{
returnStr = "出差报销已经存在,请勿重复添加";
}
}
else
{
returnStr = "出差报销已经存在,请勿重复添加";
}
return returnStr;
}
}
public string TravelReimbursementAddSimple(T_OA_TRAVELREIMBURSEMENT TravelReimbursement, List<T_OA_REIMBURSEMENTDETAIL> portDetail,string busnid)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
string returnStr = "";
if (!TrBll.TravelReimbursementAdd(TravelReimbursement, portDetail))
{
returnStr = "添加数据失败";
}
else
{
TrBll.DeleteTheSameTravelreimbursement(busnid);
}
return returnStr;
}
}
public bool CheckTravelReimbursementByBusinesstrip(string businesstripId)
{
using (TravelReimbursementBLL trBll = new TravelReimbursementBLL())
{
return trBll.CheckTravelReimbursementByBusinesstrip(businesstripId);
}
}
public List<T_OA_TRAVELREIMBURSEMENT> GetTravelReimbursementRoomInfos()
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
List<T_OA_TRAVELREIMBURSEMENT> TravelReimbursementRoomList = TrBll.GetTravelReimbursementRooms();
if (TravelReimbursementRoomList == null)
{
return null;
}
else
{
return TravelReimbursementRoomList;
}
}
}
public List<V_TravelReimbursement> GetTravelReimbursementListByUserId(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string checkState, LoginUserInfo loginUserInfo)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
List<V_TravelReimbursement> ArchivesList = null;
if (checkState != ((int)CheckStates.WaittingApproval).ToString())//获取用户的提交报销信息
{
if (checkState != ((int)CheckStates.ALL).ToString())
{
ArchivesList = TrBll.GetTravelReimbursementInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, checkState, loginUserInfo.userID);
}
else
{
ArchivesList = TrBll.GetTravelReimbursementInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, null, "", loginUserInfo.userID);
}
return ArchivesList != null ? ArchivesList.ToList() : null;
}
else //通过工作流获取用户要审批的报销信息
{
SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T flowInfo = new SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T(); //审核人 操作
SMT.SaaS.BLLCommonServices.FlowWFService.FLOW_FLOWRECORDDETAIL_T[] flowList = workFlowWS.GetFlowInfo("", "", "", "0", "T_OA_TRAVELREIMBURSEMENT", loginUserInfo.companyID, loginUserInfo.userID);
if (flowList == null)
{
return null;
}
List<V_FlowAPP> flowAppList = new List<V_FlowAPP>();
for (int i = 0; i < flowList.Length; i++)
{
V_FlowAPP App = new V_FlowAPP();
App.Guid = flowList[i].FLOWRECORDDETAILID;
App.FormID = flowList[i].FLOW_FLOWRECORDMASTER_T.FORMID;
App.EditUserID = flowList[i].EDITUSERID;
App.EditUserName = flowList[i].EDITUSERNAME;
flowAppList.Add(App);
}
checkState = ((int)CheckStates.Approving).ToString();
ArchivesList = TrBll.GetTravelReimbursementInfo(pageIndex, pageSize, sort, filterString, paras, ref pageCount, flowAppList, checkState, loginUserInfo.userID);
}
return ArchivesList != null ? ArchivesList.ToList() : null;
}
}
public bool DeleteTravelReimbursement(string[] TravelReimbursementID, ref bool FBControl)
{
using (TravelReimbursementBLL TrBll = new TravelReimbursementBLL())
{
return TrBll.DeleteTravelReimbursement(TravelReimbursementID, ref FBControl);
}
}
