public string fnInsert(ProgramD programD)
{
string sSql =
" INSERT INTO [MNDTprogram_details] " +
" ([program_id] " +
" ,[group_id] " +
" ,[read] " +
" ,[write] " +
" ,[execute] " +
" ,[create_id] " +
" ,[create_datetime] " +
" ,[modify_id] " +
" ,[modify_datetime]) " +
" VALUES " +
" ('" + programD.program_id + "' " +
" ,'" + programD.group_id + "' " +
" ,'" + programD.read + "' " +
" ,'" + programD.write + "' " +
" ,'" + programD.execute + "' " +
" ,'" + programD.create_id + "' " +
" ,GETDATE() " +
" ,'" + programD.create_id + "' " +
" ,GETDATE()) ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnDelete(ProgramD programD)
{
string sSql = " DELETE [MNDTprogram_details] " +
" WHERE [group_id] = '" + programD.group_id + "' " +
" AND [program_id] = '" + programD.program_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public DataTable fnSelects(ProgramD programD)
{
string sSql = " SELECT [program_id] " +
" ,CASE [read] WHEN 'Y' THEN 'checked' ELSE '' END [read] " +
" ,CASE [write] WHEN 'Y' THEN 'checked' ELSE '' END [write] " +
" ,CASE [execute] WHEN 'Y' THEN 'checked' ELSE '' END [execute] " +
" FROM [MNDTprogram_details] " +
" WHERE [group_id] = '" + programD.group_id + "' ";
return(PublicApi.fnGetDt(sSql, "MNDT"));
}
public string fnUpdate(ProgramD programD)
{
string sSql =
" UPDATE [MNDTprogram_details] " +
" SET [read] = '" + programD.read + "' " +
" ,[write] = '" + programD.write + "' " +
" ,[execute] = '" + programD.execute + "' " +
" ,[modify_id] = '" + programD.create_id + "' " +
" ,[modify_datetime] = GETDATE() " +
" WHERE [program_id] = '" + programD.program_id + "' " +
" AND [group_id] = '" + programD.group_id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}