private void CancelData(bool isCancel)
{
try
{
string msg;
if (isCancel)
{
msg = MessageCode.CFM0003;
}
else
{
msg = MessageCode.CFM0004;
}
if (rMessageBox.ShowConfirmation(this, msg) == DialogResult.Yes)
{
vmRpt.CancelWorkPlaceLight(wplResult, isCancel);
if (isCancel)
{
rMessageBox.ShowInfomation(this, MessageCode.INF0004);
}
else
{
rMessageBox.ShowInfomation(this, MessageCode.INF0005);
}
this.IsDataChange = true;
wplResult = vmRpt.GetWorkPlaceLight(wplResult.ID);
RetriveData();
}
}
catch (Exception ex)
{
rMessageBox.ShowException(this, ex);
}
}
private void SaveData(bool showConfirmMsg = true)
{
try
{
this.Cursor = Cursors.WaitCursor;
if (ValidateBeforeSave())
{
if (!showConfirmMsg || rMessageBox.ShowConfirmation(this, MessageCode.CFM0001) == DialogResult.Yes)
{
int ID = vmRpt.SaveWorkPlaceLight(wplResult);
rMessageBox.ShowInfomation(this, MessageCode.INF0002);
this.IsDataChange = true;
wplResult = vmRpt.GetWorkPlaceLight(ID);
mode = ScreenMode.Edit;
RetriveData();
}
}
}
catch (Exception ex)
{
rMessageBox.ShowException(this, ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
private void LoadData()
{
result = vmRpt.GetWorkPlaceLight(this.WPL_ID);
this.dataList = vmRpt.GetWorkPlaceLightReport(this.WPL_ID);
this.HasProject = result.CUSTOMER_PROJECT_ID.HasValue;
this.HasResultDayAndNight = result.MEASURED_DATE.HasValue && result.MEASURED_DATE_NIGHT.HasValue;
}
public RPT001_WorkPlaceLightIntensity_Detail_Dialog(RPT001_WorkPlaceLightDTO data)
{
try
{
InitializeComponent();
this.result = data;
this.InitialScreen();
}
catch (Exception ex)
{
throw ex;
}
}
public RPT001_WorkPlaceLightIntensityEntry(int ID, bool isCopy = false)
{
InitializeComponent();
wplResult = vmRpt.GetWorkPlaceLight(ID);
if (isCopy)
{
mode = ScreenMode.Add;
}
else
{
mode = ScreenMode.Edit;
}
}
public RPT001_WorkPlaceLightDTO GetWorkPlaceLight(int ID)
{
var result = service.GetWorkPlaceLight(new RPT001_WorkPlaceLight_Criteria()
{
ID = ID,
SHOW_DELETE_RECORD = true,
}).FirstOrDefault();
if (result == null)
{
result = new sp_RPT001_GetWorkPlaceLight_Result();
}
RPT001_WorkPlaceLightDTO wplDTO = mapper.Map <sp_RPT001_GetWorkPlaceLight_Result, RPT001_WorkPlaceLightDTO>(result);
wplDTO.Detail = service.GetWorkPlaceLightDt(ID);
wplDTO.Instrument = service.GetWorkPlaceLightInstrument(ID);
wplDTO.User = service.GetWorkPlaceLightUser(ID);
return(wplDTO);
}
public void CancelWorkPlaceLight(RPT001_WorkPlaceLightDTO data, bool IS_CANCEL)
{
service.SaveWorkPlaceLight(data, IS_CANCEL);
}
public int SaveWorkPlaceLight(RPT001_WorkPlaceLightDTO data)
{
return(service.SaveWorkPlaceLight(data));
}
public RPT001_WorkPlaceLightIntensityEntry()
{
InitializeComponent();
wplResult = vmRpt.GetWorkPlaceLight(0);
mode = ScreenMode.Add;
}
private void RetriveData()
{
try
{
this.Cursor = Cursors.WaitCursor;
systemConfigResult = vmSys.GetSystemConfig();
if (mode == ScreenMode.Add)
{
if (wplResult == null)
{
wplResult = new RPT001_WorkPlaceLightDTO();
wplResult.CRT_DATE = DateTime.Now;
wplResult.REGISTRATION_ID = systemConfigResult.DEFAULT_REPORT_REGISTRATION_ID;
wplResult.REGISTRATION_NAME = systemConfigResult.DEFAULT_REPORT_REGISTRATION_NAME;
wplResult.LAB_SUPERVISOR_ID = systemConfigResult.DEFAULT_REPORT_LAB_SUPERVISOR_ID;
wplResult.LAB_SUPERVISOR_NAME = systemConfigResult.DEFAULT_REPORT_LAB_SUPERVISOR_NAME;
this.ToolBarSwitch = "2122222222";
CtrlUtil.EnableControls(true, cboReportCode);
}
else
{
wplResult.ID = 0;
wplResult.REPORTNUMBER = null;
wplResult.REPORT_CODE = null;
wplResult.CRT_ID = null;
wplResult.CRT_DATE = DateTime.Now;
wplResult.CRT_MACHINE = null;
wplResult.CRT_NAME = null;
wplResult.UPD_ID = null;
wplResult.UPD_DATE = null;
wplResult.UPD_MACHINE = null;
wplResult.UPD_NAME = null;
wplResult.DEL_ID = null;
wplResult.DEL_DATE = null;
wplResult.DEL_MACHINE = null;
wplResult.DEL_NAME = null;
wplResult.REGISTRATION_ID = systemConfigResult.DEFAULT_REPORT_REGISTRATION_ID;
wplResult.REGISTRATION_NAME = systemConfigResult.DEFAULT_REPORT_REGISTRATION_NAME;
wplResult.LAB_SUPERVISOR_ID = systemConfigResult.DEFAULT_REPORT_LAB_SUPERVISOR_ID;
wplResult.LAB_SUPERVISOR_NAME = systemConfigResult.DEFAULT_REPORT_LAB_SUPERVISOR_NAME;
this.ToolBarSwitch = "2122222222";
CtrlUtil.EnableControls(true, cboReportCode);
}
}
else if (wplResult.DEL_ID.IsNull())
{
this.ToolBarSwitch = "2122122102";
CtrlUtil.EnableControls(false, cboReportCode);
}
else
{
this.ToolBarSwitch = "2022022012";
CtrlUtil.EnableControls(false, cboReportCode);
}
CtrlUtil.EnableControls(!wplResult.Is_Canceled, txtCustomer, txtCustomerAddr, txtProject, txtProjectAddr, dtMeasuredDate, dtMeasuredDateTo, dtTimeFrom, dtTimeTo, dtMeasuredDateNight, dtMeasuredDateNightTo, dtTimeFromNight, dtTimeToNight, btnUpdateCustomer, btnUpdateProject, chkShowLv3EachPage, chkShowLv3Cont, chkShowLv2Cont);
CtrlUtil.EnableControls(OISDataInfo.UserInfomation.GROUP_ID == 3 && !wplResult.Is_Canceled, txtRegistration, txtLabSupervisor);
//bs.DataSource = wplResult;
BindData();
ApplySummary();
dtMeasuredDate_DateChange(null, null);
dtMeasuredDateNight_DateChange(null, null);
this.wplResult.Detail.AcceptChanges();
this.wplResult.User.AcceptChanges();
this.wplResult.Instrument.AcceptChanges();
}
catch (Exception ex)
{
rMessageBox.ShowException(this, ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public int SaveWorkPlaceLight(RPT001_WorkPlaceLightDTO data, bool IS_CANCEL = false)
{
try
{
int ID = 0;
using (OIS_RPTEntities ct = new OIS_RPTEntities())
using (TransactionScope trans = new TransactionScope())
{
ID = ct.sp_RPT001_SaveWorkPlaceLight(data.ID,
data.REPORT_CODE,
data.CUSTOMER_ID,
data.CUSTOMER_LANG,
data.CUSTOMER_NAME,
data.CUSTOMER_ADDR,
data.CUSTOMER_PROJECT_ID,
data.CUSTOMER_PROJECT_LANG,
data.CUSTOMER_PROJECT_NAME,
data.CUSTOMER_PROJECT_ADDR,
data.MEASURED_DATE,
data.MEASURED_DATE_TO,
data.MEASURED_TIME_FROM,
data.MEASURED_TIME_TO,
data.MEASURED_DATE_NIGHT,
data.MEASURED_DATE_NIGHT_TO,
data.MEASURED_TIME_FROM_NIGHT,
data.MEASURED_TIME_TO_NIGHT,
data.MEASURED_BY,
data.MEASURED_INSTRUMENT_ID,
data.REGISTRATION_ID,
data.LAB_SUPERVISOR_ID,
data.SHOW_LV3_EACH_PAGE,
data.SHOW_LV3_CONT,
data.SHOW_LV2_CONT,
data.SHOW_PROJECT_ADDR,
OISDataInfo.UserInfomation.USER_ID,
IS_CANCEL).FirstOrDefault().GetValueOrDefault();
if (data.Detail != null)
{
foreach (DataRow dr in data.Detail.Rows)
{
ct.sp_RPT001_SaveWorkPlaceLightDt(dr.Field <int?>("ID"),
ID,
null,
dr.Field <string>("LOC_NAME"),
dr.Field <string>("LOC_NAME_LV2"),
dr.Field <string>("LOC_NAME_LV3"),
dr.Field <int?>("STDLIGHT_ID"),
dr.Field <string>("STDLIGHT_NAME"),
dr.Field <int>("STDLIGHT_STANDARD"),
dr.Field <int?>("RESULT_DAY"),
dr.Field <int?>("RESULT_NIGHT"),
dr.Field <string>("CONDITION"),
OISDataInfo.UserInfomation.USER_ID,
false);
}
}
string sql = "";
if (data.Instrument != null)
{
foreach (DataRow dr in data.Instrument.Rows)
{
if (sql.Length > 0)
{
sql = sql + Environment.NewLine;
}
sql = sql + string.Format("INSERT INTO TBR_WORK_PLACE_LIGHT_INSTRUMENT VALUES ({0}, {1});", ID, dr.Field <int>("MEASURED_INSTRUMENT_ID"));
}
}
if (data.User != null)
{
foreach (DataRow dr in data.User.Rows)
{
if (sql.Length > 0)
{
sql = sql + Environment.NewLine;
}
sql = sql + string.Format("INSERT INTO TBR_WORK_PLACE_LIGHT_USER VALUES ({0}, '{1}');", ID, dr.Field <string>("MEASURED_BY"));
}
}
if (sql.Length > 0)
{
ct.Database.ExecuteSqlCommand(sql);
}
trans.Complete();
}
return(ID);
}
catch (Exception ex)
{
throw ex;
}
}
