private void LoadMainMenu() { try { if (mainMenu != null) { var list = DBTranHelper.GetData <List <MainMenuDataModel> >("Auth", "GetMainMenus", "MainMenus", new DataMap() { { "USER_ID", GlobalVar.Settings.GetValue("USER_ID") }, { "MENU_GROUP", "BIZ" } }); if (list != null) { mainMenu.DataSource = list; mainMenu.ExpandAll(); mainMenu.BestFitColumns(); mainMenu.Sort(new string[] { "HIER_ID" }, new SortOrder[] { SortOrder.Ascending }); } } } catch (Exception ex) { MsgBox.Show(ex); } }
void DetailDataLoad(object id) { try { var res = DBTranHelper.GetData <InvAdjsDataModel>("InvAdjs", new DataMap() { { "ADJS_ID", id } }); txtAdjsId.EditValue = res.ADJS_ID; datAdjsDate.SetDateChar8(res.ADJS_DATE); txtProductId.EditValue = res.PRODUCT_ID; txtProductId.EditText = res.PRODUCT_NAME; spnAdjsQty.EditValue = res.ADJS_QTY; memRemarks.EditValue = res.REMARKS; txtInsTime.EditValue = res.INS_TIME; txtInsUserName.EditValue = res.INS_USER_NAME; txtUpdTime.EditValue = res.UPD_TIME; txtUpdUserName.EditValue = res.UPD_USER_NAME; SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; txtProductId.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
void DetailDataLoad(object id) { try { DataMap res = (DataMap)DBTranHelper.GetData("Base", "GetData", "SelectCalendar", new DataMap() { { "CAL_DATE", id } }).TranList[0].Data; if (res == null) { throw new Exception("조회할 데이터가 없습니다."); } datCalDate.SetDateChar8(res.GetValue("CAL_DATE")); chkHolidayYn.EditValue = res.GetValue("HOLIDAY_YN"); txtHolidayName.EditValue = res.GetValue("HOLIDAY_NAME"); memRemarks.EditValue = res.GetValue("REMARKS"); txtInsTime.EditValue = res.GetValue("INS_TIME"); txtInsUser.EditValue = res.GetValue("INS_USER_NAME"); txtUpdTime.EditValue = res.GetValue("UPD_TIME"); txtUpdUser.EditValue = res.GetValue("UPD_USER_NAME"); SetToolbarButtons(new ToolbarButtons() { Refresh = true, Save = true, Delete = true }); this.EditMode = EditModeEnum.Modify; txtHolidayName.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
void DataSaveAddress(bool reload = false) { try { DataTable dt = GetAddressData(); if (dt == null || dt.Rows.Count == 0) { if (reload) { throw new Exception("저장할 건이 없습니다."); } } else { var res = DBTranHelper.Execute("Customer", "SaveCustomerAddress", "CustomerAddress", dt, null); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } if (reload) { ShowMsgBox("저장하였습니다."); DataLoadAddress(); } } } catch (Exception ex) { ShowErrBox(ex); } }
void DetailDataLoad(object reg_id) { try { var data = DBTranHelper.GetData <SalesPriceDataModel>("Product", "GetSalesPriceData", new DataMap() { { "REG_ID", reg_id } }); txtRegId.EditValue = data.REG_ID; txtProductId.EditValue = data.PRODUCT_ID; txtProductCode.EditValue = data.PRODUCT_CODE; txtProductName.EditValue = data.PRODUCT_NAME; datBegDate.SetDateChar8(data.BEG_DATE); datEndDate.SetDateChar8(data.END_DATE); spnSalePrice.EditValue = data.SALE_PRICE; memRemarks.EditValue = data.REMARKS; txtInsTime.EditValue = data.INS_TIME; txtInsUserName.EditValue = data.INS_USER_NAME; txtUpdTime.EditValue = data.UPD_TIME; txtUpdUserName.EditValue = data.UPD_USER_NAME; SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; spnSalePrice.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { try { DataMap data = new DataMap() { { "USER_ID", txtUserId.EditValue }, { "USER_NAME", txtUserName.EditValue }, { "USER_TYPE", lupUserType.EditValue }, { "LOGIN_ID", txtLoginId.EditValue }, { "USE_YN", chkUseYn.EditValue }, { "REMARKS", memeRemarks.EditValue }, { "ROWSTATE", (this.EditMode == EditModeEnum.New)?"INSERT":"UPDATE" } }; var res = DBTranHelper.Execute("Base", "Save", "User", data, "USER_ID"); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
void doCreate() { if (MsgBox.Show("선택한 연도의 캘린더를 생성하겠습니까?", "확인!!", MessageBoxButtons.YesNo) != DialogResult.Yes) { return; } try { var res = DBTranHelper.ProcedureCall("CreateCalendar", new DataMap() { { "CAL_YEAR", datCalYear.GetDateChar4().ToIntegerNullToZero() } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("생성하였습니다."); DataLoad(null); } catch (Exception ex) { ShowErrBox(ex); } }
void DetailDataLoad(object id) { try { DataMap data = (DataMap)DBTranHelper.GetData("Base", "GetData", "SelectDictionaries", new DataMap() { { "DICTIONARY_ID", id } }).TranList[0].Data; if (data == null) { throw new Exception("조회할 데이터가 없습니다."); } txtDictionaryId.EditValue = data.GetValue("DICTIONARY_ID"); txtLogicalName.EditValue = data.GetValue("LOGICAL_NAME"); txtPhysicalName.EditValue = data.GetValue("PHYSICAL_NAME"); memDescription.EditValue = data.GetValue("DESCRIPTION"); txtInsTime.EditValue = data.GetValue("INS_TIME"); txtInsUser.EditValue = data.GetValue("INS_USER_NAME"); txtUpdTime.EditValue = data.GetValue("UPD_TIME"); txtUpdUser.EditValue = data.GetValue("UPD_USER_NAME"); SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; txtLogicalName.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { try { DataMap data = new DataMap() { { "DICTIONARY_ID", txtDictionaryId.EditValue }, { "LOGICAL_NAME", txtLogicalName.EditValue }, { "PHYSICAL_NAME", txtPhysicalName.EditValue }, { "DESCRIPTION", memDescription.EditValue }, { "ROWSTATE", (this.EditMode == EditModeEnum.New) ? "INSERT" : "UPDATE" } }; var res = DBTranHelper.Execute("Base", "Save", "Dictionary", data, "DICTIONARY_ID"); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
public static void SetData() { try { var dtDictionaries = DBTranHelper.GetData <DataTable>("Auth", "GetDictionaries", "Dictionaries", null); if (dtDictionaries != null && (dtDictionaries as DataTable).Rows.Count > 0) { foreach (DataRow dr in (dtDictionaries as DataTable).Rows) { DomainResource.Fields.SetValue(dr["NAME"].ToString(), dr["VALUE"].ToString()); } } var dtMessages = DBTranHelper.GetData <DataTable>("Auth", "GetMessages", "Messages", null); if (dtMessages != null && (dtMessages as DataTable).Rows.Count > 0) { foreach (DataRow dr in (dtMessages as DataTable).Rows) { DomainResource.Messages.SetValue(dr["NAME"].ToString(), dr["VALUE"].ToString()); } } } catch { throw; } }
void doCreate() { if (MsgBox.Show("원가마감하겠습니까?", "확인!!", MessageBoxButtons.YesNo) != DialogResult.Yes) { return; } try { var res = DBTranHelper.ProcedureCall("CreateCostPrice", new DataMap() { { "CLOSING_YM", datClosingYm.GetDateChar6() } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("생성하였습니다."); DataLoad(null); } catch (Exception ex) { ShowErrBox(ex); } }
public void SetRepositoryItemLookUpEdit(string fieldName, string valueMember, string displayMember, string serviceId, string processId, string sqlId, DataMap parameters) { RepositoryItemLookUpEdit edit = GetRepositoryItemLookUpEdit(valueMember, displayMember); edit.DataSource = DBTranHelper.GetData(serviceId, processId, sqlId, parameters).TranList[0].Data; SetRepositoryItem(fieldName, edit); }
/// <summary> /// 데이터 바인딩 /// </summary> /// <param name="serverId">서비스ID</param> /// <param name="processId">프로세스ID</param> /// <param name="sqlId">SQL ID</param> /// <param name="param">파라미터</param> /// <param name="bestFit">자동맞춤여부</param> public void BindData(string serviceId = null, string processId = null, string sqlId = null, DataMap param = null, bool bestFit = false) { try { int rowIndex = this.MainView.FocusedRowHandle; this.DataSource = DBTranHelper.GetData(serviceId, processId, sqlId, param).TranList[0].Data; if (this.DataSource == null) { this.EmptyDataTableBinding(); } else { this.MainView.FocusedRowHandle = rowIndex; this.MainView.SelectRow(rowIndex); } if (bestFit) { BestFitColumns(); } } catch (Exception ex) { MsgBox.Show(ex); } }
void DetailDataLoad(object id) { try { var data = DBTranHelper.GetData <DataMap>("Base", "GetData", "GetDepositData", new DataMap() { { "DEPOSIT_ID", id } }); txtDepositId.EditValue = data.GetValue("DEPOSIT_ID"); datDepositDate.SetDateChar8(data.GetValue("DEPOSIT_DATE")); txtCustomerId.EditValue = data.GetValue("CUSTOMER_ID"); txtCustomerId.EditText = data.GetValue("CUSTOMER_NAME"); spnDepositAmt.EditValue = data.GetValue("DEPOSIT_AMT"); memRemarks.EditValue = data.GetValue("REMARKS"); txtInsTime.EditValue = data.GetValue("INS_TIME"); txtInsUserName.EditValue = data.GetValue("INS_USER_NAME"); txtUpdTime.EditValue = data.GetValue("UPD_TIME"); txtUpdUserName.EditValue = data.GetValue("UPD_USER_NAME"); SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; txtCustomerId.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
private void LoadSystemMenu() { try { if (navBarNavigate != null && navBarNavigate.Groups.Where(x => x.Name == "navBarGroupSystem").Any()) { var navGroup = navBarNavigate.Groups.Where(x => x.Name == "navBarGroupSystem").FirstOrDefault(); navGroup.ItemLinks.Clear(); var list = DBTranHelper.GetData <List <MainMenuDataModel> >("Auth", "GetMainMenus", "MainMenus", new DataMap() { { "USER_ID", GlobalVar.Settings.GetValue("USER_ID") }, { "MENU_GROUP", "SYS" } }); if (list != null) { foreach (MainMenuDataModel model in list) { navGroup.ItemLinks.Add(navBarNavigate.Items.Add(new NavBarItem() { Caption = model.MENU_NAME.ToStringNullToEmpty(), Tag = model, SmallImage = ImageResource.menu_system_16x16, SmallImageSize = new Size(16, 16) })); } } } } catch (Exception ex) { MsgBox.Show(ex); } }
void doConfirm() { if (txtCurPwd.EditValue.IsNullOrEmpty()) { MsgBox.Show("현재 비밀번호를 입력하세요!!!"); txtCurPwd.Focus(); return; } if (txtChgPwd.EditValue.IsNullOrEmpty()) { MsgBox.Show("변경할 비밀번호를 입력하세요!!!"); txtCurPwd.Focus(); return; } if (txtChkPwd.EditValue.IsNullOrEmpty()) { MsgBox.Show("변경할 비밀번호를 비밀번호 확인란에 한번 더 입력하세요!!!"); txtCurPwd.Focus(); return; } if (txtChgPwd.EditValue.ToStringNullToEmpty() != txtChkPwd.EditValue.ToStringNullToEmpty()) { MsgBox.Show("변경할 비밀번호와 비밀번호 확인이 일치해야 합니다."); txtChgPwd.Focus(); return; } if (txtCurPwd.EditValue.ToStringNullToEmpty() == txtChgPwd.EditValue.ToStringNullToEmpty()) { MsgBox.Show("기존 비밀번호와 변경할 비밀번호가 일치합니다. 다시 입력하세요!!!"); txtChgPwd.Focus(); return; } try { var ret = DBTranHelper.Execute("Auth", "ChangePassword", null, new DataMap() { { "LOGIN_ID", GlobalVar.Settings.GetValue("LOGIN_ID") }, { "LOGIN_PW", txtCurPwd.EditValue }, { "CHG_LOGIN_PW", txtChgPwd.EditValue } }, null); if (ret.ErrorNumber != 0) { throw new Exception(ret.ErrorMessage); } MsgBox.Show("변경하였습니다."); Close(); } catch (Exception ex) { MsgBox.Show(ex); } }
private void doLogin() { try { if (txtCompanyId.EditValue.ToStringNullToEmpty() == string.Empty) { MsgBox.Show("회사코드를 입력해야 합니다."); txtCompanyId.Focus(); return; } if (txtLoginId.EditValue.ToStringNullToEmpty() == string.Empty) { MsgBox.Show("접속 아이디를 입력하세요!!!"); txtLoginId.Focus(); return; } if (txtPassword.EditValue.ToStringNullToEmpty() == string.Empty) { MsgBox.Show("비밀번호를 입력하세요!!!"); txtPassword.Focus(); return; } var data = DBTranHelper.GetData("Auth", "CheckLoginUser", null, new DataMap() { { "LOGIN_ID", txtLoginId.EditValue }, { "LOGIN_PW", txtPassword.EditValue } }).TranList[0].Data; if (data == null) { throw new Exception("로그인 사용자의 정보가 정확하지 않습니다."); } GlobalVar.Settings.SetValue("LOGIN_ID", (data as LoginUserDataModel).LOGIN_ID); GlobalVar.Settings.SetValue("USER_ID", (data as LoginUserDataModel).USER_ID); GlobalVar.Settings.SetValue("USER_NAME", (data as LoginUserDataModel).USER_NAME); if (chkRemember.Checked) { RegistryUtils.SetValue(RegiPathConsts.LOGIN_INFO, "LoginId", txtLoginId.EditValue.ToStringNullToEmpty()); RegistryUtils.SetValue(RegiPathConsts.LOGIN_INFO, "LoginPw", txtPassword.EditValue.ToStringNullToEmpty()); } SetModifiedCount(); Close(); } catch (Exception ex) { MsgBox.Show(ex); } }
public static void ShowHelp(object helpId, object menuId = null) { if (helpId == null && menuId == null) { return; } try { string textValue; string rtfValue; string helpName; DataMap data = (DataMap)DBTranHelper.GetData("Auth", "GetHelpContent", null, new DataMap() { { "HELP_ID", helpId }, { "MENU_ID", menuId } }).TranList[0].Data; if (data != null) { helpId = data.GetValue("ID"); helpName = data.GetValue("NAME").ToStringNullToEmpty(); rtfValue = data.GetValue("CONTENT_BY_RTE").ToStringNullToEmpty(); textValue = data.GetValue("CONTENT").ToStringNullToEmpty(); if (rtfValue.IsNullOrEmpty() == false || textValue.IsNullOrEmpty() == false) { HelpForm form = new HelpForm() { Name = string.Format("HELP_{0}", helpId), Text = "[도움말]", Subject = helpName }; if (rtfValue.IsNullOrEmpty()) { form.Content = textValue; } else { form.ContentByRte = rtfValue; } form.InsertDtime = data.GetValue("INS_TIME").ToStringNullToEmpty(); form.InsertUserName = data.GetValue("INS_USER_NAME").ToStringNullToEmpty(); form.UpdateDtime = data.GetValue("UPD_TIME").ToStringNullToEmpty(); form.UpdateUserName = data.GetValue("UPD_USER_ID").ToStringNullToEmpty(); form.StartPosition = FormStartPosition.CenterScreen; form.TopMost = true; form.Show(); } } } catch { throw; } }
void DetailDataLoad(object id) { try { var res = DBTranHelper.GetData("Product", new DataMap() { { "PRODUCT_ID", id } }); if (res.TranList.Length > 0) { if (res.TranList[0].Data == null) { throw new Exception("조회 데이터가 없습니다."); } ProductDataModel model = (ProductDataModel)res.TranList[0].Data; txtProductId.EditValue = model.PRODUCT_ID; txtProductCode.EditValue = model.PRODUCT_CODE; txtProductName.EditValue = model.PRODUCT_NAME; txtBarcode.EditValue = model.BARCODE; lupProductType.EditValue = model.PRODUCT_TYPE; lupCategory.EditValue = model.CATEGORY; lupUnitType.EditValue = model.UNIT_TYPE; chkUseYn.EditValue = model.USE_YN; memRemarks.EditValue = model.REMARKS; txtInsTime.EditValue = model.INS_TIME; txtInsUserName.EditValue = model.INS_USER_NAME; txtUpdTime.EditValue = model.UPD_TIME; txtUpdUserName.EditValue = model.UPD_USER_NAME; } if (res.TranList.Length > 1) { gridMaterials.DataSource = (res.TranList[1].Data as List <DataMap>).DataMapListToDataTable(); } onProductTypeChanged(); SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; txtProductName.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { if (DataValidate() == false) { return; } if (DataValidate(gridItem) == false) { return; } try { DataMap mst = lc.GroupToDataMap(lcGroupEdit1, lcGroupEdit2); mst.SetValue("ROWSTATE", (this.EditMode == EditModeEnum.New) ? "INSERT" : "UPDATE"); DataTable item = GetPurcItemData(); if (item == null || item.Rows.Count == 0) { throw new Exception("구매품목을 입력해야 합니다."); } var res = DBTranHelper.Execute(new DBTranSet() { ServiceId = "Purchase", ProcessId = "Save", TranList = new DBTranData[] { new DBTranData() { Data = mst }, new DBTranData() { Data = item } } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
public static DataTable Lookup(string parentCodeId, DataMap parameters = null) { try { if (parameters == null) { parameters = new DataMap(); } parameters.SetValue("PARENT_CODE", parentCodeId); return(DBTranHelper.GetData <DataTable>("CodeHelp", "GetCodeHelpLookup", parameters)); } catch { throw; } }
protected override void DataSave(object arg, SaveCallback callback) { try { DataMap data = new DataMap() { { "ID", txtTableId.EditValue }, { "DB_NAME", lupDbName.EditValue }, { "SCHEMA_NAME", txtSchemaName.EditValue }, { "TABLE_NAME", txtTableName.EditValue }, { "DESCRIPTION", txtDescription.EditValue }, { "REMARKS", memRemarks.EditValue }, { "ROWSTATE", (txtTableId.EditValue.IsNullOrEmpty()) ? "INSERT" : "UPDATE" } }; DataTable dtColumns = GetColumnData(); var res = DBTranHelper.Execute(new DBTranSet() { ServiceId = "Database", ProcessId = "Save", IsTransaction = true, TranList = new DBTranData[] { new DBTranData() { SqlId = "Tables", Data = data, IsMaster = true, KeyField = "ID" }, new DBTranData() { SqlId = "Columns", Data = dtColumns } } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); DataLoad(); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { try { DataTable dt = lc.GroupToDataTable(lcGroupEdit, lcGroupBizEdit) .SetValue("BIZ_REG_ID", mBizRegId) .SetValue("ADDRESS_ID", mAddressId) .SetValue("ROWSTATE", (this.EditMode == EditModeEnum.New) ? "INSERT" : "UPDATE"); var res = DBTranHelper.Execute(new DBTranSet() { ServiceId = "Customer", ProcessId = "Save", TranList = new DBTranData[] { new DBTranData() { Data = dt }, new DBTranData() { Data = GetPhoneData() }, new DBTranData() { Data = GetAddressData() } } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } txtCustomerId.EditValue = res.TranList[0].ReturnValue; DataSavePhones(); DataSaveAddress(); ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
void DataLoad(DataMap parameters) { try { var res = DBTranHelper.GetData("Purchase", parameters); if (res.TranList[0].Data == null) { throw new Exception("조회 데이터가 없습니다."); } PurcTranDataModel model = res.TranList[0].Data as PurcTranDataModel; txtPurcId.EditValue = model.PURC_ID; txtPurcNo.EditValue = model.PURC_NO; datPurcDate.SetDateChar8(model.PURC_DATE); lupPurcType.EditValue = model.PURC_TYPE; txtCustomerId.EditValue = model.CUSTOMER_ID; txtCustomerId.EditText = model.CUSTOMER_NAME; memRemarks.EditValue = model.REMARKS; txtInsTime.EditValue = model.INS_TIME; txtInsUserName.EditValue = model.INS_USER_NAME; txtUpdTime.EditValue = model.UPD_TIME; txtUpdUserName.EditValue = model.UPD_USER_NAME; this.ParamsData = model.PURC_ID; if (res.TranList.Length > 1) { gridItem.DataSource = (res.TranList[1].Data as IList <PurcTranItemDataModel>).ListToDataTable(); } SetToolbarButtons(new Models.ToolbarButtons() { Refresh = true, New = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; memRemarks.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
void DetailDataLoad(object id) { try { var res = DBTranHelper.GetData("Production", new DataMap() { { "PROD_ID", id } }); if (res.TranList.Length > 0) { ProdTranDataModel model = res.TranList[0].Data as ProdTranDataModel; txtProdId.EditValue = model.PROD_ID; datProdDate.SetDateChar8(model.PROD_DATE); txtProductId.EditValue = model.PRODUCT_ID; txtProductId.EditText = model.PRODUCT_NAME; spnProdQty.EditValue = model.PROD_QTY; memRemarks.EditValue = model.REMARKS; txtInsTime.EditValue = model.INS_TIME; txtInsUserName.EditValue = model.INS_USER_NAME; txtUpdTime.EditValue = model.UPD_TIME; txtUpdUserName.EditValue = model.UPD_USER_NAME; } if (res.TranList.Length > 1) { gridMaterialList.DataSource = (res.TranList[1].Data as List <DataMap>).DataMapListToDataTable(); } SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; txtProductId.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { try { DataMap data = new DataMap() { { "CAL_DATE", datCalDate.GetDateChar8() }, { "HOLIDAY_YN", chkHolidayYn.EditValue }, { "HOLIDAY_NAME", txtHolidayName.EditValue }, { "REMARKS", memRemarks.EditValue }, { "ROWSTATE", "UPDATE" } }; var res = DBTranHelper.Execute(new DBTranSet() { ServiceId = "Base", ProcessId = "Save", IsTransaction = true, TranList = new DBTranData[] { new DBTranData() { SqlId = "Calendar", KeyField = "CAL_DATE", Data = data } } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
void DetailDataLoad(object id) { try { var data = DBTranHelper.GetData <DataMap>("Base", "GetData", "SelectCode", new DataMap() { { "CODE_ID", id } }); txtCodeId.EditValue = data.GetValue("CODE_ID"); lupParentCode.BindData("CODE_GROUP", null, "ROOT", true); lupParentCode.EditValue = data.GetValue("PARENT_CODE"); txtCode.EditValue = data.GetValue("CODE"); txtName.EditValue = data.GetValue("NAME"); txtValue.EditValue = data.GetValue("VALUE"); spnSortSeq.EditValue = data.GetValue("SORT_SEQ"); spnMaxLength.EditValue = data.GetValue("MAX_LENGTH"); chkUseYn.EditValue = data.GetValue("USE_YN"); memDescription.EditValue = data.GetValue("DESCRIPTION"); txtOptionValue1.EditValue = data.GetValue("OPTION_VALUE1"); txtOptionValue2.EditValue = data.GetValue("OPTION_VALUE2"); txtOptionValue3.EditValue = data.GetValue("OPTION_VALUE3"); txtOptionValue4.EditValue = data.GetValue("OPTION_VALUE4"); txtOptionValue5.EditValue = data.GetValue("OPTION_VALUE5"); txtInsTime.EditValue = data.GetValue("INS_TIME"); txtInsUser.EditValue = data.GetValue("INS_USER_NAME"); txtUpdTime.EditValue = data.GetValue("UPD_TIME"); txtUpdUser.EditValue = data.GetValue("UPD_USER_NAME"); SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); this.EditMode = EditModeEnum.Modify; txtCode.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { if (DataValidate() == false) { return; } try { DataMap data = new DataMap() { { "CODE_ID", txtCodeId.EditValue }, { "PARENT_CODE", lupParentCode.EditValue }, { "CODE", txtCode.EditValue }, { "NAME", txtName.EditValue }, { "VALUE", txtValue.EditValue }, { "SORT_SEQ", spnSortSeq.EditValue }, { "MAX_LENGTH", spnMaxLength.EditValue }, { "USE_YN", chkUseYn.EditValue }, { "DESCRIPTION", memDescription.EditValue }, { "OPTION_VALUE1", txtOptionValue1.EditValue }, { "OPTION_VALUE2", txtOptionValue2.EditValue }, { "OPTION_VALUE3", txtOptionValue3.EditValue }, { "OPTION_VALUE4", txtOptionValue4.EditValue }, { "OPTION_VALUE5", txtOptionValue5.EditValue }, { "ROWSTATE", (this.EditMode == EditModeEnum.New) ? "INSERT" : "UPDATE" } }; var res = DBTranHelper.Execute("Base", "Save", "Code", data, "CODE_ID"); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
private void DataLoad() { try { var res = DBTranHelper.GetData("Sales", "GetSaleDashboard", new DataMap() { { "SALE_DATE", DateTime.Now.ToString("yyyyMMdd") } }); if (res.TranList.Length > 0) { for (int i = 0; i < chart1.Series.Count; i++) { chart1.Series[i].Points.Clear(); } var data1 = res.TranList[0].Data as List <DataMap>; foreach (DataMap data in data1) { chart1.Series[0].Points.Add(new SeriesPoint(data.GetValue("SALE_DATE").ToString().ToDateTime(), data.GetValue("SALE_AMT").ToDecimalNullToZero())); } } if (res.TranList.Length > 1) { for (int i = 0; i < chart2.Series.Count; i++) { chart2.Series[i].Points.Clear(); } var data2 = res.TranList[1].Data as List <DataMap>; foreach (DataMap data in data2) { chart2.Series[0].Points.Add(new SeriesPoint((data.GetValue("SALE_YM").ToString() + "01").ToDateTime(), data.GetValue("SALE_AMT").ToDecimalNullToZero())); } } } catch (Exception ex) { MsgBox.Show(ex); } }
void DetailDataLoad(object id) { try { DataMap data = (DataMap)(DBTranHelper.GetData("Base", "GetData", "SelectMenu", new DataMap() { { "MENU_ID", id } }).TranList[0].Data); if (data == null) { throw new Exception("조회할 데이터가 없습니다."); } txtMenuId.EditValue = data.GetValue("MENU_ID"); txtMenuName.EditValue = data.GetValue("MENU_NAME"); txtParentId.EditValue = data.GetValue("PARENT_ID"); numSortSeq.EditValue = data.GetValue("SORT_SEQ"); txtAssembly.EditValue = data.GetValue("ASSEMBLY"); txtNamespace.EditValue = data.GetValue("NAMESPACE"); txtInstance.EditValue = data.GetValue("INSTANCE"); lupFormType.EditValue = data.GetValue("FORM_TYPE"); chkUseYn.EditValue = data.GetValue("USE_YN"); memRemarks.EditValue = data.GetValue("REMARKS"); txtInsTime.EditValue = data.GetValue("INS_TIME"); txtInsUserName.EditValue = data.GetValue("INS_USER_NAME"); txtUpdTime.EditValue = data.GetValue("UPD_TIME"); txtUpdUserName.EditValue = data.GetValue("UPD_USER_NAME"); SetToolbarButtons(new ToolbarButtons() { New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true }); EditMode = EditModeEnum.Modify; txtMenuName.Focus(); } catch (Exception ex) { ShowErrBox(ex); } }