public string SearchAccountName(string accountCode) { using (ERPEntities entities = new ERPEntities()) { return(entities.계정과목.Where(x => x.계정과목코드번호 == accountCode).ToList().Select(x => x.계정과목명).FirstOrDefault()); } }
public 계정과목등록 Search(string key) { using (ERPEntities entities = new ERPEntities()) { return(entities.계정과목등록.Where(x => x.CodeNum == key).ToList().FirstOrDefault()); } }
public string NormalSearch(string Code) { using (ERPEntities entities = new ERPEntities()) { return(entities.일반거래처등록.Where(x => x.일반거래처코드 == Code).ToList().Select(x => x.거래처명).FirstOrDefault()); } }
public List <사원등록> Get사원정보(string 사원코드, string 사원명) { using (ERPEntities context = new ERPEntities()) { var query = from x in context.사원등록 select x; if (string.IsNullOrEmpty(사원코드) == false) { var query1 = from x in context.사원등록 where x.부서코드 == 사원코드 select x; if (string.IsNullOrEmpty(사원명) == false) { var query2 = from x in context.사원등록 where x.사원명 == 사원명 select x; return(query2.ToList()); } return(query1.ToList()); } else { if (string.IsNullOrEmpty(사원명) == false) { var query2 = from x in query where x.사원명 == 사원명 select x; return(query2.ToList()); } return(query.ToList()); } } }
public List <제품> SearchByCode(string text) { using (ERPEntities entities = new ERPEntities()) { return(entities.제품.Where(x => x.제품번호.StartsWith(text)).ToList()); } }
public List <T> GetAll() { using (ERPEntities entities = new ERPEntities()) { return(entities.Set <T>().ToList()); } }
public List <S> Select <S>(Expression <Func <T, S> > selector) { using (ERPEntities entities = new ERPEntities()) { return(entities.Set <T>().Select(selector).ToList()); } }
public List <발주서> Search발주서(string 거래처이름, DateTime OrderFirstDate, DateTime OrderLastDate, DateTime DeliveryFirstDate, DateTime DeliveryLastDate) { using (ERPEntities context = new ERPEntities()) { var query = from x in context.발주서 where x.주문날짜 <= OrderLastDate && x.주문날짜 >= OrderFirstDate && x.납기일 <= DeliveryLastDate && x.납기일 >= DeliveryFirstDate select x; if (string.IsNullOrEmpty(거래처이름) == false) { var query1 = from x in query where x.공급업체번호 == context.일반거래처등록.Where(y => y.거래처명 == 거래처이름). Select(y => y.거래처코드번호).FirstOrDefault().ToString() select x; return(query1.ToList()); } else { return(query.ToList()); } } }
public 고정자산 SearchCode(string code) { using (ERPEntities entities = new ERPEntities()) { return(entities.고정자산.Where(x => x.고정자산코드 == code).ToList().FirstOrDefault()); } }
public 사업장등록 GetDetails(string code) { using (ERPEntities entities = new ERPEntities()) { return(entities.사업장등록.Where(x => x.사업장코드 == code).FirstOrDefault()); } }
public string SearchCode(string name) { using (ERPEntities entities = new ERPEntities()) { return(entities.관할세무서.Where(x => x.관할세무서명.StartsWith(name)).Select(x => x.관할세무서코드).FirstOrDefault()); } }
public string SearchangedValue(string value) { using (ERPEntities entities = new ERPEntities()) { return(entities.고정자산계정과목.Where(x => x.고정자산과목코드 == value).ToList().Select(x => x.고정자산과목명).FirstOrDefault()); } }
public string FindParentKey(string name) { using (ERPEntities entities = new ERPEntities()) { return(entities.계정과목.Where(x => x.계정과목코드번호 == name).ToList().Select(x => x.그룹코드번호).FirstOrDefault()); } }
public bool IsUpdateAccountCode(계정과목 계정과목) { using (ERPEntities entities = new ERPEntities()) { foreach (계정과목 item in entities.계정과목) { if (계정과목.계정과목코드번호 == item.계정과목코드번호) { if (계정과목.계정과목명 != item.계정과목명 || 계정과목.출력계정명 != item.출력계정명 || 계정과목.관련계정코드 != item.관련계정코드 || 계정과목.계정구분 != item.계정구분 || 계정과목.차대구분 != item.차대구분 || 계정과목.입력구분 != item.입력구분 || 계정과목.필수입력여부 != item.필수입력여부 || 계정과목.비고 != item.비고) { return(false); } } } return(true); } }
public 일반거래처등록 SearchCode(string code) { using (ERPEntities entities = new ERPEntities()) { return(entities.일반거래처등록.Where(x => x.일반거래처코드 == code).ToList().FirstOrDefault()); } }
public List <회사등록> 회사검색(string code) { using (ERPEntities entities = new ERPEntities()) { return(entities.회사등록.Where(x => x.회사명 == code).ToList()); } }
public void Delete(T entity) { using (ERPEntities entities = new ERPEntities()) { try { entities.Entry(entity).State = EntityState.Deleted; entities.SaveChanges(); } catch (DbEntityValidationException e) { Exception raise = e; foreach (var eve in e.EntityValidationErrors) { foreach (var ve in eve.ValidationErrors) { string message = string.Format("{0}:{1}", eve.Entry.Entity.ToString(), ve.ErrorMessage); raise = new InvalidOperationException(message, raise); } } throw raise; } } }
public List <고정자산> 검색(string code) { using (ERPEntities entities = new ERPEntities()) { return(entities.고정자산.Where(x => x.계정과목코드번호 == code).ToList()); } }
public int GetCount() { using (ERPEntities entities = new ERPEntities()) { return(entities.Set <T>().Count()); } }
public List <일반거래처등록> 검색(string code) { using (ERPEntities entities = new ERPEntities()) { return(entities.일반거래처등록.Where(x => x.거래처명 == code).ToList()); } }
public static void SetMenuItemsByAccount(this TreeView treeView, out List <계정과목등록> MenuItems) { using (ERPEntities entity = new ERPEntities()) { MenuItems = entity.계정과목등록.ToList(); foreach (var item in MenuItems) { if (item.PrentKey == null) { treeView.Nodes.Add(item.CodeNum, item.Title); } } foreach (var item in MenuItems) { int check = treeView.Nodes.Find(item.PrentKey, true).Length; if (check > 0) { int inputNum = treeView.Nodes.Find(item.PrentKey, true).Length - 1; treeView.Nodes.Find(item.PrentKey, true)[inputNum].Nodes.Add(item.CodeNum, item.Title); } } } }
public void Search(string customerCode, out string name, out string number) { using (ERPEntities entities = new ERPEntities()) { string code = entities.거래처.Where(x => x.거래처코드번호 == customerCode).ToList().Select(x => x.거래처코드번호).FirstOrDefault(); DB.금융거래처.Search(code, out bool isEqual1, out string name1, out string number1); DB.일반거래처.Search(code, out bool isEqual2, out string name2, out string number2); name = null; number = null; if (isEqual1 == true) { name = name1; number = number1; } if (isEqual2 == true) { name = name2; number = number2; } } }
public List <전표> GetAllMatchedMonth(DateTime firstDay, DateTime lastDay) { using (ERPEntities entities = new ERPEntities()) { return(entities.전표.Where(x => firstDay.Date <= x.입력날짜 && x.입력날짜 <= lastDay).ToList()); } }
public string Search(string code) { using (ERPEntities entities = new ERPEntities()) { return(entities.회사등록.Where(x => x.회사코드 == code).ToList().Select(x => x.회사명).FirstOrDefault()); } }
public string SearchChangedValue(string value) { using (ERPEntities entities = new ERPEntities()) { return(entities.회사등록.Where(x => x.회사코드 == value).Select(x => x.회사명).First()); } }
public void Check(string id, string pwd, out int employeeCnt) { using (ERPEntities entity = new ERPEntities()) { employeeCnt = entity.사원등록.Where(x => x.사원코드 == id && x.암호 == pwd).ToList().Count; } }
public string SearchChangedValue(string value) { using (ERPEntities entities = new ERPEntities()) { return(entities.부서등록.Where(x => x.부서코드 == value).ToList().Select(x => x.부서명).FirstOrDefault()); } }
public bool IsEmailExist(string email) { using (ERPEntities dc = new ERPEntities()) { var v = dc.Users.Where(a => a.Email == email).FirstOrDefault(); return(v != null); } }
public void Delete(T entity) { using (ERPEntities entities = new ERPEntities()) { entities.Entry(entity).State = EntityState.Deleted; entities.SaveChanges(); } }
public void Update(T entity) { using (ERPEntities entities = new ERPEntities()) { entities.Entry(entity).State = EntityState.Modified; entities.SaveChanges(); } }