/// <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, UserScreenPermissionDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + UserScreenPermissionDTO.eColumns.FLG_VIEW + "=:FLG_VIEW");
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_ADD + "=:FLG_ADD");
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_CHG + "=:FLG_CHG");
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_DEL + "=:FLG_DEL");
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_BY + "=:UPD_BY");
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + UserScreenPermissionDTO.eColumns.SCREEN_CD + "=:SCREEN_CD");
sb.AppendLine(" AND " + UserScreenPermissionDTO.eColumns.USER_CD + "=:USER_CD");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value);
req.Parameters.Add("USER_CD", DataType.VarChar, data.USER_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, UserScreenPermissionDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.SCREEN_CD, data.USER_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, UserScreenPermissionDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + UserScreenPermissionDTO.eColumns.SCREEN_CD);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.USER_CD);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_VIEW);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_ADD);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_CHG);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_DEL);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_MACHINE);
sb.AppendLine(") VALUES(");
sb.AppendLine(" :SCREEN_CD");
sb.AppendLine(" ,:USER_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("USER_CD", DataType.VarChar, data.USER_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 UpdateUserScreenPermissionFlagDEL(int objFLG_DEL, string UserCD, string ScreenCD)
{
AuthorizedMaintenanceBIZ biz = new AuthorizedMaintenanceBIZ();
UserScreenPermissionDTO dto = new UserScreenPermissionDTO();
dto.SCREEN_CD.Value = ScreenCD;
dto.USER_CD.Value = UserCD;
//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.UpdateUserScreenPermissionFlagDEL(dto);
}
public int UpdateUserScreenPermissionFlagADD(Database database, UserScreenPermissionDTO dto)
{
Database db = UseDatabase(database);
string sql = @"UPDATE TZ_USER_SCREEN_PERMISSION_MS
SET FLG_ADD = :FLG_ADD,
UPD_BY = :UPD_BY,
UPD_DATE = :UPD_DATE,
UPD_MACHINE = :UPD_MACHINE
WHERE SCREEN_CD = :SCREEN_CD
AND USER_CD = :USER_CD";
DataRequest req = new DataRequest(sql);
req.Parameters.Add("SCREEN_CD", DataType.VarChar, dto.SCREEN_CD.StrongValue);
req.Parameters.Add("USER_CD", DataType.VarChar, dto.USER_CD.StrongValue);
req.Parameters.Add("FLG_ADD", DataType.VarChar, dto.FLG_ADD.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 UpdateUserScreenPermissionFlagDEL(UserScreenPermissionDTO dto)
{
IUserScreenPermissionDAO dao = DAOFactory.CreateUserScreenPermissionDAO(CommonLib.Common.CurrentDatabase);
dao.UpdateUserScreenPermissionFlagDEL(null, dto);
}
