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();
}
}
