public int InsertProject(PROJECT project)
{
var sql = string.Format(@"INSERT INTO PROJECT(IDEA_ID,EMP_ID,IDEA_TITLE,PRJECT_GRADE,KPI_NAME,KPI_UNIT,BACKGROUND,NAME,
INS_DT,PRJ_CURR,CURR_VALUE,ATTACHMENT) VALUES(@IDEA_ID,@EMP_ID,@IDEA_TITLE,@PRJECT_GRADE,@KPI_NAME,@KPI_UNIT,@BACKGROUND,@NAME,
GETDATE(),@PRJ_CURR,@CURR_VALUE,@ATTACHMENT)");
return(DBManager <PROJECT> .Execute(sql, project));
}
public string GetLastId()
{
var sql = "SELECT TOP 1 IDEA_ID FROM PROJECT ORDER BY IDEA_ID DESC";
PROJECT prj = DBManager <PROJECT> .ExecuteReader(sql).FirstOrDefault();
if (prj == null)
{
return(string.Empty);
}
return(prj.IDEA_ID);
}
public string IsExist(string ID)
{
var sql = "SELECT TOP 1 IDEA_ID FROM PROJECT WHERE IDEA_ID=@ID";
PROJECT prj = DBManager <PROJECT> .ExecuteReader(sql, new { ID = ID }).FirstOrDefault();
if (prj == null)
{
return(string.Empty);
}
return(prj.IDEA_ID);
}