namespace
GRLC.DAL
{
public
class
SystemCodeDAL
{
static
SystemCodeDAL systemCodeDAL =
new
SystemCodeDAL();
private
SystemCodeDAL()
{ }
public
static
SystemCodeDAL GetInstance()
{
return
systemCodeDAL;
}
public
int
AddSystemCode(SystemCodeEntity systemCodeEntity,
string
userID)
{
using
(BonusEntities bonusEntities =
new
BonusEntities())
{
Codes code =
new
Codes();
code.ename = systemCodeEntity.Ename;
code.cname = systemCodeEntity.Cname;
code.data = systemCodeEntity.Data;
code.display_content = systemCodeEntity.DisplayContent;
code.create_time = DateTime.Now;
code.lastmodify_date = DateTime.Now;
code.lastmodifier = userID;
code.create_person = userID;
bonusEntities.Codes.Add(code);
return
bonusEntities.SaveChanges();
}
}
public
int
UpdateSystemCode(SystemCodeEntity systemCodeEntity,
string
userID)
{
using
(BonusEntities bonusEntities =
new
BonusEntities())
{
Codes code =
new
Codes();
code.ename = systemCodeEntity.Ename;
code.cname = systemCodeEntity.Cname;
code.data = systemCodeEntity.Data;
code.display_content = systemCodeEntity.DisplayContent;
code.lastmodify_date = DateTime.Now;
code.lastmodifier = userID;
bonusEntities.Entry(code).State = EntityState.Modified;
return
bonusEntities.SaveChanges();
}
}
public
bool
CheckIfEnameExists(
string
ename)
{
using
(BonusEntities bonusEntities =
new
BonusEntities())
{
return
bonusEntities.Codes.Any(c => c.ename == ename);
}
}
public
bool
CheckIfDataExists(
string
ename,
string
data)
{
using
(BonusEntities bonusEntities =
new
BonusEntities())
{
return
bonusEntities.Codes.Any(c => c.ename == ename && c.data == data);
}
}
public
bool
CheckIfDisplayContentExists(
string
ename,
string
displayContent)
{
using
(BonusEntities bonusEntities =
new
BonusEntities())
{
return
bonusEntities.Codes.Any(c => c.ename == ename && c.display_content == displayContent);
}
}
public
List<SystemCodeEntity> GetSytemCodeEntityList()
{
List<SystemCodeEntity> systemCodeEntityList =
new
List<SystemCodeEntity>();
using
(BonusEntities bonusEntities =
new
BonusEntities())
{
SystemCodeEntity systemCodeEntity =
null
;
List<Codes> codeList = bonusEntities.Codes.ToList();
foreach
(
var
code
in
codeList)
{
systemCodeEntity =
new
SystemCodeEntity();
systemCodeEntity.Cname = code.cname;
systemCodeEntity.Ename = code.ename;
systemCodeEntity.Data = code.data;
systemCodeEntity.DisplayContent = code.display_content;
systemCodeEntityList.Add(systemCodeEntity);
}
}
return
systemCodeEntityList;
}
}
}