public int _Exist(Guid ID) { var _Entity = PreApprovalDao.FindCostCenterByID(ID); string CostCenter = _Entity.TA + "-" + _Entity.Region + "(" + _Entity.CostCenter + ")"; return(PreApprovalDao._Exist(CostCenter)); }
public int ImportCostCenter(List <D_COSTCENTER> excelRows, ref List <D_COSTCENTER> fails, string adminUser) { foreach (var item in excelRows) { fails.Clear(); var count = PreApprovalDao.findCostCenter(item.TA, item.Region, item.CostCenter).CostCenterCount; fails.Add(item); if (count > 0) { PreApprovalDao.UpdateCostCenter(fails, adminUser, item.TA, item.Region, item.CostCenter); } else { if (!string.IsNullOrEmpty(item.OldCostCenter)) { count = PreApprovalDao.findCostCenter(item.TA, item.Region, item.OldCostCenter).CostCenterCount; if (count > 0) { PreApprovalDao.UpdateCostCenter(fails, adminUser, item.TA, item.Region, item.OldCostCenter); } else { PreApprovalDao.ImportCostCenter(fails, adminUser); } } else { PreApprovalDao.ImportCostCenter(fails, adminUser); } } } return(1); }
public int AddCostCenter(string sltMarket, string sltTA, string txtBUHeadName, string BUHeadMUDID, string Region, string RegionManagerName, string RegionManagerMUDID, string RDSDManagerName, string RDSDManagerMUDID, string CostCenter, string OldCostCenter, string CreateBy, DateTime CreateDateTIme) { var list = PreApprovalDao.findCostCenter(sltTA, Region, CostCenter);//查询成本中心是否存在 if (list.CostCenterCount >= 1) { return(0); } return(PreApprovalDao.AddCostCenter(sltMarket, sltTA, txtBUHeadName, BUHeadMUDID, Region, RegionManagerName, RegionManagerMUDID, RDSDManagerName, RDSDManagerMUDID, CostCenter, OldCostCenter, CreateBy, CreateDateTIme)); }
public int InvalidAddressApplication(List <Guid> guids, int state) { return(PreApprovalDao.InvalidAddressApplication(guids, state)); }
public List <P_AddressApproval_View> LoadAddressApprove(string srh_DACode, string srh_ApplierMUDID, string srh_ApproverMUDID, string srh_GskHospital, string srh_StartApplyDate, string srh_EndApplyDate, string srh_State, string srh_IsDelete, int rows, int page, out int total) { return(PreApprovalDao.LoadAddressApprove(srh_DACode, srh_ApplierMUDID, srh_ApproverMUDID, srh_GskHospital, srh_StartApplyDate, srh_EndApplyDate, srh_State, srh_IsDelete, rows, page, out total)); }
public string GetOldGskHospitalCodeByGskHospitalCode(string GskHospitalCode) { return(PreApprovalDao.GetOldGskHospitalCodeByGskHospitalCode(GskHospitalCode)); }
public int UpdatePuoReAssignByHTCode(string HtCode, string UserId, string Name, string MUDID, string HeadName) { return(PreApprovalDao.UpdatePuoReAssignByHTCode(HtCode, UserId, Name, MUDID, HeadName)); }
public List <P_AddressApproval> LoadMyAddressApproveCount(string userId, DateTime begin, DateTime end, string state, string applicant) { return(PreApprovalDao.LoadMyAddressApproveCount(userId, begin, end, state, applicant)); }
public List <P_PreApproval> GetDataByTAAndState(string TERRITORY_TA) { return(PreApprovalDao.GetDataByTAAndState(TERRITORY_TA)); }
public P_AddressApproval_View LoadAddressApprovalInfoForUpdate(Guid id) { return(PreApprovalDao.LoadAddressApprovalInfoForUpdate(id)); }
public List <P_AddressApproval_View> ExportAddressApprovalList(string srh_DACode, string srh_ApplierMUDID, string srh_ApproverMUDID, string srh_GskHospital, string srh_StartApplyDate, string srh_EndApplyDate, string srh_State, string srh_IsDelete) { return(PreApprovalDao.ExportAddressApprovalList(srh_DACode, srh_ApplierMUDID, srh_ApproverMUDID, srh_GskHospital, srh_StartApplyDate, srh_EndApplyDate, srh_State, srh_IsDelete)); }
public List <P_PreApproval> GetPreApprovalByUser(string UserID) { return(PreApprovalDao.GetPreApprovalByUser(UserID)); }
public List <P_AddressApproval> LoadMyAddressApprove(string UserId, DateTime Begin, DateTime End, string State, string Applicant, int rows, int page, out int total) { return(PreApprovalDao.LoadMyAddressApprove(UserId, Begin, End, State, Applicant, rows, page, out total)); }
public List <P_PreApproval> GetPreApprovalByUser() { return(PreApprovalDao.GetPreApprovalByUser()); }
/// <summary> /// 更新预申请医院地址 /// </summary> /// <param name="preApprovalId"></param> /// <param name="hospitalAddress"></param> /// <returns></returns> public int UpdateAddress(string preApprovalId, string hospitalAddress) { return(PreApprovalDao.UpdateAddress(preApprovalId, hospitalAddress)); }
public string GetOldCostcenterByCostcenter(string Costcenter) { return(PreApprovalDao.GetOldCostcenterByCostcenter(Costcenter)); }
public List <WP_QYUSER> LoadWPQYUSER() { return(PreApprovalDao.LoadWPQYUSER()); }
public int InsertnewTERRITORY_TA(List <D_COSTCENTER> sus) { return(PreApprovalDao.InsertnewTERRITORY_TA(sus)); }
public List <P_AddressApproveHistory> LoadAddressApprovalHistory(Guid DA_ID) { return(PreApprovalDao.LoadAddressApprovalHistory(DA_ID)); }
public int AddressApprove(P_AddressApproval_View p_addressApproval_View, string reason) { return(PreApprovalDao.AddressApprove(p_addressApproval_View, reason)); }
public List <P_AddressApproval> LoadAddressApprovalByDACode(string dA_CODE) { return(PreApprovalDao.LoadAddressApprovalByDACode(dA_CODE)); }
//预申请上层分析 public List <P_PreApproval_OwnBelongCountAmount> LoadPreApprovalUpData(string userId, string position, string territoryCode, string begin, string end) { return(PreApprovalDao.LoadPreApprovalUpData(userId, position, territoryCode, begin, end)); }
public int PreApprovalCancel(P_PreApproval p_preApproval) { return(PreApprovalDao.PreApprovalCancel(p_preApproval)); }
public V_COST_SUMMARY GetPreApprovalList(List <string> TerritoryStr, string StartDate, string EndDate) { return(PreApprovalDao.GetPreApprovalList(TerritoryStr, StartDate, EndDate)); }
public int AddAddressApproveHistory(P_AddressApproveHistory p_addressApproveHistory) { return(PreApprovalDao.AddAddressApproveHistory(p_addressApproveHistory)); }
public int InsertFileLink(string FilePath, string Email) { return(PreApprovalDao.InsertFileLink(FilePath, Email)); }
public int SyncPreApproval() { return(PreApprovalDao.SyncPreApproval()); }
public List <P_AddressApproval_View> LoadMyAddressApproveAll(string UserId, string applicant) { return(PreApprovalDao.LoadMyAddressApproveAll(UserId, applicant)); }
public List <D_COSTCENTER> ExportCostCenterList() { return(PreApprovalDao.ExportCostCenterList()); }
public List <P_AddressApproval> LoadInvalidAddressApplication(DateTime nowDate) { return(PreApprovalDao.LoadInvalidAddressApplication(nowDate)); }