/// <summary>
/// Update record by using primary key value on the given data variable
/// </summary>
/// <param name="database"></param>
/// <param name="data">Data with primary key value.</param>
/// <returns></returns>
public int UpdateWithoutPK(Database database, GroupScreenPermissionDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + GroupScreenPermissionDTO.eColumns.FLG_VIEW + "=:FLG_VIEW");
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.FLG_ADD + "=:FLG_ADD");
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.FLG_CHG + "=:FLG_CHG");
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.FLG_DEL + "=:FLG_DEL");
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.UPD_BY + "=:UPD_BY");
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + GroupScreenPermissionDTO.eColumns.SCREEN_CD + "=:SCREEN_CD");
sb.AppendLine(" AND " + GroupScreenPermissionDTO.eColumns.GROUP_CD + "=:GROUP_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value);
req.Parameters.Add("GROUP_CD", DataType.VarChar, data.GROUP_CD.Value);
req.Parameters.Add("FLG_VIEW", DataType.Number, data.FLG_VIEW.Value);
req.Parameters.Add("FLG_ADD", DataType.Number, data.FLG_ADD.Value);
req.Parameters.Add("FLG_CHG", DataType.Number, data.FLG_CHG.Value);
req.Parameters.Add("FLG_DEL", DataType.Number, data.FLG_DEL.Value);
req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
/// <summary>
/// Check exist before manipulate data. If found record will update data. Otherwise insert new data.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNewOrUpdate(Database database, GroupScreenPermissionDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.SCREEN_CD, data.GROUP_CD))
{
return(UpdateWithoutPK(db, data));
}
return(AddNew(db, data));
}
/// <summary>
/// Insert new record into database.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNew(Database database, GroupScreenPermissionDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + GroupScreenPermissionDTO.eColumns.SCREEN_CD);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.GROUP_CD);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.FLG_VIEW);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.FLG_ADD);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.FLG_CHG);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.FLG_DEL);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + GroupScreenPermissionDTO.eColumns.UPD_MACHINE);
sb.AppendLine(") VALUES(");
sb.AppendLine(" :SCREEN_CD");
sb.AppendLine(" ,:GROUP_CD");
sb.AppendLine(" ,:FLG_VIEW");
sb.AppendLine(" ,:FLG_ADD");
sb.AppendLine(" ,:FLG_CHG");
sb.AppendLine(" ,:FLG_DEL");
sb.AppendLine(" ,:CRT_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:CRT_MACHINE");
sb.AppendLine(" ,:UPD_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:UPD_MACHINE");
sb.AppendLine(" )");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value);
req.Parameters.Add("GROUP_CD", DataType.VarChar, data.GROUP_CD.Value);
req.Parameters.Add("FLG_VIEW", DataType.Number, data.FLG_VIEW.Value);
req.Parameters.Add("FLG_ADD", DataType.Number, data.FLG_ADD.Value);
req.Parameters.Add("FLG_CHG", DataType.Number, data.FLG_CHG.Value);
req.Parameters.Add("FLG_DEL", DataType.Number, data.FLG_DEL.Value);
req.Parameters.Add("CRT_BY", DataType.NVarChar, data.CRT_BY.Value);
req.Parameters.Add("CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value);
req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
internal void UpdateGroupScreenPermissionFlag(int objFLG_VIEW, int objFLG_ADD, int objFLG_CHG, int objFLG_DEL, string GroupCD, string ScreenCD)
{
AuthorizedMaintenanceBIZ biz = new AuthorizedMaintenanceBIZ();
GroupScreenPermissionDTO dto = new GroupScreenPermissionDTO();
dto.SCREEN_CD.Value = ScreenCD;
dto.GROUP_CD.Value = GroupCD;
dto.FLG_VIEW.Value = objFLG_VIEW;
dto.FLG_ADD.Value = objFLG_ADD;
dto.FLG_CHG.Value = objFLG_CHG;
dto.FLG_DEL.Value = objFLG_DEL;
dto.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dto.UPD_DATE.Value = DateTime.Now;
dto.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine;
biz.UpdateGroupScreenPermissionFlag(dto);
}
public int UpdateGroupScreenPermissionFlagCHG(Database database, GroupScreenPermissionDTO dto)
{
Database db = UseDatabase(database);
string sql = @"UPDATE TZ_GROUP_SCREEN_PERMISSION_MS
SET FLG_CHG = :FLG_CHG,
UPD_BY = :UPD_BY,
UPD_DATE = :UPD_DATE,
UPD_MACHINE = :UPD_MACHINE
WHERE SCREEN_CD = :SCREEN_CD
AND GROUP_CD = :GROUP_CD";
DataRequest req = new DataRequest(sql);
req.Parameters.Add("SCREEN_CD", DataType.VarChar, dto.SCREEN_CD.StrongValue);
req.Parameters.Add("GROUP_CD", DataType.VarChar, dto.GROUP_CD.StrongValue);
req.Parameters.Add("FLG_CHG", DataType.VarChar, dto.FLG_CHG.StrongValue);
req.Parameters.Add("UPD_BY", DataType.VarChar, dto.UPD_BY.StrongValue);
req.Parameters.Add("UPD_DATE", DataType.DateTime, dto.UPD_DATE.StrongValue);
req.Parameters.Add("UPD_MACHINE", DataType.VarChar, dto.UPD_MACHINE.StrongValue);
return(db.ExecuteNonQuery(req));
}
internal void UpdateGroupScreenPermissionFlagVIEW(GroupScreenPermissionDTO dto)
{
IGroupScreenPermissionDAO dao = DAOFactory.CreateGroupScreenPermissionDAO(CommonLib.Common.CurrentDatabase);
dao.UpdateGroupScreenPermissionFlagVIEW(null, dto);
}
internal void AddGroupScreenPermissionFlag(GroupScreenPermissionDTO dto)
{
IGroupScreenPermissionDAO dao = DAOFactory.CreateGroupScreenPermissionDAO(CommonLib.Common.CurrentDatabase);
dao.AddNew(null, dto);
}
