/// <summary>
/// Update record by using the table's primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="data">Data which to update.</param>
/// <param name="oldSCREEN_CD">Old Key #1</param>
/// <param name="oldCONTROL_CD">Old Key #2</param>
/// <returns></returns>
public int UpdateWithPK(Database database, ScreenDetailDTO data, NZString oldSCREEN_CD, NZString oldCONTROL_CD)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + ScreenDetailDTO.eColumns.SCREEN_CD + "=:SCREEN_CD");
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.CONTROL_CD + "=:CONTROL_CD");
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.CONTROL_TYPE + "=:CONTROL_TYPE");
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.UPD_BY + "=:UPD_BY");
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.UPD_DATE + "=SYSDATE");
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE");
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.ORIGINAL_TITLE + "=:ORIGINAL_TITLE");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ScreenDetailDTO.eColumns.SCREEN_CD + "=:oldSCREEN_CD");
sb.AppendLine(" AND " + ScreenDetailDTO.eColumns.CONTROL_CD + "=:oldScreenDetail");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value);
req.Parameters.Add("CONTROL_CD", DataType.VarChar, data.CONTROL_CD.Value);
req.Parameters.Add("CONTROL_TYPE", DataType.VarChar, data.CONTROL_TYPE.Value);
req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
req.Parameters.Add("ORIGINAL_TITLE", DataType.NVarChar, data.ORIGINAL_TITLE.Value);
req.Parameters.Add("oldSCREEN_CD", DataType.VarChar, oldSCREEN_CD.Value);
req.Parameters.Add("oldCONTROL_CD", DataType.VarChar, oldCONTROL_CD.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, ScreenDetailDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.SCREEN_CD, data.CONTROL_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, ScreenDetailDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + ScreenDetailDTO.eColumns.SCREEN_CD);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.CONTROL_CD);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.CONTROL_TYPE);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.UPD_MACHINE);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.ORIGINAL_TITLE);
sb.AppendLine(" ," + ScreenDetailDTO.eColumns.IS_USED);
sb.AppendLine(") VALUES(");
sb.AppendLine(" :SCREEN_CD");
sb.AppendLine(" ,:CONTROL_CD");
sb.AppendLine(" ,:CONTROL_TYPE");
sb.AppendLine(" ,:CRT_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:CRT_MACHINE");
sb.AppendLine(" ,:UPD_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:UPD_MACHINE");
sb.AppendLine(" ,:ORIGINAL_TITLE");
sb.AppendLine(" ,1");
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("CONTROL_CD", DataType.VarChar, data.CONTROL_CD.Value);
req.Parameters.Add("CONTROL_TYPE", DataType.VarChar, data.CONTROL_TYPE.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);
req.Parameters.Add("ORIGINAL_TITLE", DataType.NVarChar, data.ORIGINAL_TITLE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
public void UpdateIsUsed(Database database, ScreenDetailDTO argScreenDetailDTO)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
sb.AppendLine(" UPDATE TZ_SCREEN_DETAIL_MS ");
sb.AppendLine(" SET IS_USED = 1 ");
sb.AppendLine(" WHERE SCREEN_CD = :pSCREEN_CD");
sb.AppendLine(" AND CONTROL_CD = :pCONTROL_CD");
DataRequest req = new DataRequest(sb.ToString());
req.Parameters.Add("@pSCREEN_CD", argScreenDetailDTO.SCREEN_CD.Value);
req.Parameters.Add("@pCONTROL_CD", argScreenDetailDTO.CONTROL_CD.Value);
db.ExecuteNonQuery(req);
}
private void AddControlDetailtoDatabase(List <LangDTO> langDTOList, string ScreenCD, Control control, string controlName, List <ScreenDetailDTO> screenDetailDTOList, List <ScreenDetailLangDTO> screenDetailLangDTOList)
{
ScreenDetailDTO dtoScreenDetail = new ScreenDetailDTO();
// add all control id to screen detail
//
dtoScreenDetail.SCREEN_CD.Value = ScreenCD;
dtoScreenDetail.CONTROL_CD.Value = controlName;
dtoScreenDetail.CONTROL_TYPE.Value = control.GetType().Name;
dtoScreenDetail.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetail.CRT_DATE.Value = DateTime.Now;
dtoScreenDetail.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenDetail.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetail.UPD_DATE.Value = DateTime.Now;
dtoScreenDetail.UPD_MACHINE.Value = Environment.MachineName;
screenDetailDTOList.Add(dtoScreenDetail);
if (langDTOList.Count > 0)
{
foreach (LangDTO langdto in langDTOList)
{
ScreenDetailLangDTO dtoScreenDetailLang = new ScreenDetailLangDTO();
dtoScreenDetailLang.SCREEN_CD.Value = ScreenCD;
dtoScreenDetailLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetailLang.CRT_DATE.Value = DateTime.Now;
dtoScreenDetailLang.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenDetailLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetailLang.UPD_DATE.Value = DateTime.Now;
dtoScreenDetailLang.UPD_MACHINE.Value = Environment.MachineName;
dtoScreenDetailLang.CONTROL_CD.Value = controlName;
dtoScreenDetailLang.CONTROL_CAPTION.Value = control.Text;
dtoScreenDetailLang.LANG_CD = langdto.LANG_CD;
screenDetailLangDTOList.Add(dtoScreenDetailLang);
}
}
}
public void ImportData(List <ScreenImportUIDM> ScreenImportList, List <ScreenDetailUIDM> UIDMScreenDetailList)
{
LangBIZ bizLang = new LangBIZ();
LangDTO dtoLang = new LangDTO();
ScreenDetailBIZ bizScreenDetail = new ScreenDetailBIZ();
List <ScreenDTO> screenDTOList = new List <ScreenDTO>();
List <ScreenLangDTO> screenLangDTOList = new List <ScreenLangDTO>();
List <ScreenDetailDTO> screenDetailDTOList = new List <ScreenDetailDTO>();
List <ScreenDetailLangDTO> screenDetailLangDTOList = new List <ScreenDetailLangDTO>();
// count lang detail
List <LangDTO> langDTOList = bizLang.LoadAll();
#region Collect Data
foreach (ScreenImportUIDM ScreenImport in ScreenImportList)
{
// check if screen is never been import then import to screen ms
if (ScreenImport.ImportStatus.StrongValue.ToUpper() == "NOTIMPORT")
{
ScreenDTO dtoScreen = new ScreenDTO();
dtoScreen.SCREEN_CD = ScreenImport.ScreenCD;
dtoScreen.SCREEN_NAME = ScreenImport.ScreenName;
dtoScreen.ORIGINAL_TITLE = ScreenImport.ScreenName;
dtoScreen.IMAGE_CD.Value = "DEFAULT";
dtoScreen.SCREEN_TYPE = ScreenImport.ScreenType;
dtoScreen.SCREEN_ACTION.Value = 0;
dtoScreen.EXT_PROGRAM.Value = string.Empty;
dtoScreen.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreen.CRT_DATE.Value = DateTime.Now;
dtoScreen.CRT_MACHINE.Value = Environment.MachineName;
dtoScreen.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreen.UPD_DATE.Value = DateTime.Now;
dtoScreen.UPD_MACHINE.Value = Environment.MachineName;
screenDTOList.Add(dtoScreen);
if (langDTOList.Count > 0)
{
foreach (LangDTO langdto in langDTOList)
{
ScreenLangDTO dtoScreenLang = new ScreenLangDTO();
// add multilang for screen name
dtoScreenLang.SCREEN_CD = ScreenImport.ScreenCD;
dtoScreenLang.SCREEN_DESC = ScreenImport.ScreenName;
dtoScreenLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenLang.CRT_DATE.Value = DateTime.Now;
dtoScreenLang.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenLang.UPD_DATE.Value = DateTime.Now;
dtoScreenLang.UPD_MACHINE.Value = Environment.MachineName;
dtoScreenLang.LANG_CD = langdto.LANG_CD;
//bizScreenLang.AddNew(dtoScreenLang);
screenLangDTOList.Add(dtoScreenLang);
}
}
}
}
foreach (ScreenDetailUIDM ScreenDetail in UIDMScreenDetailList)
{
ScreenDetailDTO dtoScreenDetail = new ScreenDetailDTO();
dtoScreenDetail.SCREEN_CD = ScreenDetail.ScreenCD;
dtoScreenDetail.CONTROL_TYPE = ScreenDetail.ControlType;
dtoScreenDetail.ORIGINAL_TITLE = ScreenDetail.ControlCaption;
dtoScreenDetail.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetail.CRT_DATE.Value = DateTime.Now;
dtoScreenDetail.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenDetail.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetail.UPD_DATE.Value = DateTime.Now;
dtoScreenDetail.UPD_MACHINE.Value = Environment.MachineName;
dtoScreenDetail.CONTROL_CD = ScreenDetail.ControlCD;
screenDetailDTOList.Add(dtoScreenDetail);
if (langDTOList.Count > 0)
{
foreach (LangDTO langdto in langDTOList)
{
ScreenDetailLangDTO dtoScreenDetailLang = new ScreenDetailLangDTO();
// add spread column to screen detail ms
dtoScreenDetailLang.SCREEN_CD = ScreenDetail.ScreenCD;
dtoScreenDetailLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetailLang.CRT_DATE.Value = DateTime.Now;
dtoScreenDetailLang.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenDetailLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetailLang.UPD_DATE.Value = DateTime.Now;
dtoScreenDetailLang.UPD_MACHINE.Value = Environment.MachineName;
// add multilang for spread column
dtoScreenDetailLang.CONTROL_CD = ScreenDetail.ControlCD; //.Value = fpsspread.Name + ".Column[" + i.ToString() + "]";
dtoScreenDetailLang.CONTROL_CAPTION = ScreenDetail.ControlCaption; //.Value = fpsspread.Sheets[0].Columns[i].Label;
dtoScreenDetailLang.LANG_CD = langdto.LANG_CD;
screenDetailLangDTOList.Add(dtoScreenDetailLang);
}
}
}
#endregion
ImportScreenBIZ bizImportScreen = new ImportScreenBIZ();
bizImportScreen.ImportData(screenDTOList, screenLangDTOList, screenDetailDTOList, screenDetailLangDTOList);
}
public int AddNew(ScreenDetailDTO dtoScreenDetail)
{
IScreenDetailDAO dao = DAOFactory.CreateScreenDetailDAO(CommonLib.Common.CurrentDatabase);
return(dao.AddNew(null, dtoScreenDetail));
}
