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));
 }
Exemplo n.º 10
0
 public P_AddressApproval_View LoadAddressApprovalInfoForUpdate(Guid id)
 {
     return(PreApprovalDao.LoadAddressApprovalInfoForUpdate(id));
 }
Exemplo n.º 11
0
 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));
 }
Exemplo n.º 12
0
 public List <P_PreApproval> GetPreApprovalByUser(string UserID)
 {
     return(PreApprovalDao.GetPreApprovalByUser(UserID));
 }
Exemplo n.º 13
0
 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));
 }
Exemplo n.º 14
0
 public List <P_PreApproval> GetPreApprovalByUser()
 {
     return(PreApprovalDao.GetPreApprovalByUser());
 }
Exemplo n.º 15
0
 /// <summary>
 /// 更新预申请医院地址
 /// </summary>
 /// <param name="preApprovalId"></param>
 /// <param name="hospitalAddress"></param>
 /// <returns></returns>
 public int UpdateAddress(string preApprovalId, string hospitalAddress)
 {
     return(PreApprovalDao.UpdateAddress(preApprovalId, hospitalAddress));
 }
Exemplo n.º 16
0
 public string GetOldCostcenterByCostcenter(string Costcenter)
 {
     return(PreApprovalDao.GetOldCostcenterByCostcenter(Costcenter));
 }
Exemplo n.º 17
0
 public List <WP_QYUSER> LoadWPQYUSER()
 {
     return(PreApprovalDao.LoadWPQYUSER());
 }
Exemplo n.º 18
0
 public int InsertnewTERRITORY_TA(List <D_COSTCENTER> sus)
 {
     return(PreApprovalDao.InsertnewTERRITORY_TA(sus));
 }
Exemplo n.º 19
0
 public List <P_AddressApproveHistory> LoadAddressApprovalHistory(Guid DA_ID)
 {
     return(PreApprovalDao.LoadAddressApprovalHistory(DA_ID));
 }
Exemplo n.º 20
0
 public int AddressApprove(P_AddressApproval_View p_addressApproval_View, string reason)
 {
     return(PreApprovalDao.AddressApprove(p_addressApproval_View, reason));
 }
Exemplo n.º 21
0
 public List <P_AddressApproval> LoadAddressApprovalByDACode(string dA_CODE)
 {
     return(PreApprovalDao.LoadAddressApprovalByDACode(dA_CODE));
 }
Exemplo n.º 22
0
 //预申请上层分析
 public List <P_PreApproval_OwnBelongCountAmount> LoadPreApprovalUpData(string userId, string position, string territoryCode, string begin, string end)
 {
     return(PreApprovalDao.LoadPreApprovalUpData(userId, position, territoryCode, begin, end));
 }
Exemplo n.º 23
0
 public int PreApprovalCancel(P_PreApproval p_preApproval)
 {
     return(PreApprovalDao.PreApprovalCancel(p_preApproval));
 }
Exemplo n.º 24
0
 public V_COST_SUMMARY GetPreApprovalList(List <string> TerritoryStr, string StartDate, string EndDate)
 {
     return(PreApprovalDao.GetPreApprovalList(TerritoryStr, StartDate, EndDate));
 }
Exemplo n.º 25
0
 public int AddAddressApproveHistory(P_AddressApproveHistory p_addressApproveHistory)
 {
     return(PreApprovalDao.AddAddressApproveHistory(p_addressApproveHistory));
 }
Exemplo n.º 26
0
 public int InsertFileLink(string FilePath, string Email)
 {
     return(PreApprovalDao.InsertFileLink(FilePath, Email));
 }
Exemplo n.º 27
0
 public int SyncPreApproval()
 {
     return(PreApprovalDao.SyncPreApproval());
 }
Exemplo n.º 28
0
 public List <P_AddressApproval_View> LoadMyAddressApproveAll(string UserId, string applicant)
 {
     return(PreApprovalDao.LoadMyAddressApproveAll(UserId, applicant));
 }
Exemplo n.º 29
0
 public List <D_COSTCENTER> ExportCostCenterList()
 {
     return(PreApprovalDao.ExportCostCenterList());
 }
Exemplo n.º 30
0
 public List <P_AddressApproval> LoadInvalidAddressApplication(DateTime nowDate)
 {
     return(PreApprovalDao.LoadInvalidAddressApplication(nowDate));
 }