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 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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
protected override void DataSave(object arg, SaveCallback callback) { try { DataMap map = lcGroupEdit.ItemToDataMap(); map.SetValue("ROWSTATE", (this.EditMode == EditModeEnum.New) ? "INSERT" : "UPDATE"); var res = DBTranHelper.Execute("InvAdjs", "Save", map, "ADJS_ID"); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataDelete(object arg, DeleteCallback callback) { try { DataMap data = new DataMap() { { "CAL_DATE", datCalDate.GetDateChar8() }, { "ROWSTATE", "DELETE" } }; 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); } }
public static int SaveAddress(DataMap map) { try { var res = DBTranHelper.Execute("Base", "Save", "Address", map, "ADDRESS_ID"); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } if (res.TranList[0].ReturnValue == null) { throw new Exception("반환값이 정확하지 않습니다."); } return(res.TranList[0].ReturnValue.ToIntegerNullToZero()); } catch { throw; } }
private void ClearPassword() { try { DataMap data = new DataMap() { { "USER_ID", txtUserId.EditValue } }; var res = DBTranHelper.Execute("Auth", "ClearPassword", null, data, null); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("비밀번호를 초기화 하였습니다."); } catch (Exception ex) { ShowErrBox(ex); } }
void DataSaveMaterials() { try { DataTable dt = GetMaterialData(); if (dt == null || dt.Rows.Count == 0) { throw new Exception("저장할 건이 없습니다."); } var res = DBTranHelper.Execute(new DBTranSet() { ServiceId = "Base", ProcessId = "Save", TranList = new DBTranData[] { new DBTranData() { SqlId = "ProductMaterial", Data = dt } } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); DataLoadMaterials(); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataDelete(object arg, DeleteCallback callback) { try { DataMap data = new DataMap() { { "ADJS_ID", txtAdjsId.EditValue }, { "ROWSTATE", "DELETE" } }; var res = DBTranHelper.Execute("InvAdjs", "Save", data, null); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("삭제하였습니다."); callback(arg, null); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { try { DataMap map = lcGroupEdit.ItemToDataMap(); map.SetValue("ROWSTATE", (this.EditMode == EditModeEnum.New) ? "INSERT" : "UPDATE"); var res = DBTranHelper.Execute(new DBTranSet() { ServiceId = "Product", ProcessId = "Save", TranList = new DBTranData[] { new DBTranData() { Data = map }, new DBTranData() { Data = GetMaterialData() } } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataDelete(object arg, DeleteCallback callback) { try { DataMap map = new DataMap() { { "PURC_ID", txtPurcId.EditValue }, { "ROWSTATE", "DELETE" } }; var res = DBTranHelper.Execute("Purchase", "Delete", map, null); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("삭제하였습니다."); callback(arg, null); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { if (gridMenus.RowCount > 0) { gridMenus.PostEditor(); gridMenus.UpdateCurrentRow(); } try { DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("USER_ID", typeof(int)), new DataColumn("MENU_ID", typeof(int)), new DataColumn("VIEW_YN", typeof(string)), new DataColumn("EDIT_YN", typeof(string)), new DataColumn("INS_USER", typeof(int)), new DataColumn("ROWSTATE", typeof(string)) }); foreach (DataRow row in gridMenus.GetDataTable().Rows) { if (row.RowState == DataRowState.Modified && ( row["VIEW_YN"].ToString() != row["VIEW_YN", DataRowVersion.Original].ToString() || row["EDIT_YN"].ToString() != row["EDIT_YN", DataRowVersion.Original].ToString() )) { dt.Rows.Add( gridUsers.GetValue(gridUsers.MainView.FocusedRowHandle, "USER_ID"), row["MENU_ID"], row["VIEW_YN"], row["EDIT_YN"], GlobalVar.Settings.GetValue("USER_ID"), "UPSERT"); } } if (dt == null || dt.Rows.Count == 0) { ShowMsgBox("저장할 내역이 없습니다."); return; } var res = DBTranHelper.Execute("Base", "Save", "UserMenus", dt, null); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); int rowhandle = gridUsers.MainView.FocusedRowHandle; object userId = gridUsers.GetValue(rowhandle, "USER_ID"); DataLoad(); gridUsers.MainView.FocusedRowHandle = rowhandle; DetailLoad(userId); } catch (Exception ex) { ShowErrBox(ex); } }
protected override void DataSave(object arg, SaveCallback callback) { gridItems.PostEditor(); gridItems.UpdateCurrentRow(); if (DataValidate() == false) { return; } if (DataValidate(gridItems) == false) { return; } if (lupPayType.EditValue.ToString() == "30" && txtCustomer.EditValue.ToStringNullToEmpty() == "") { ShowMsgBox("외상거래의 경우 거래처를 입력해야 합니다."); return; } try { DataTable mastData = new DataTable(); mastData.Columns.AddRange(new DataColumn[] { new DataColumn("SALE_DATE", typeof(string)), new DataColumn("SALE_TYPE", typeof(string)), new DataColumn("PAY_TYPE", typeof(string)), new DataColumn("CUSTOMER_ID", typeof(int)), new DataColumn("ROWSTATE", typeof(string)) }); mastData.Rows.Add( DateTime.Now.ToString("yyyyMMdd"), lupSaleType.EditValue, lupPayType.EditValue, txtCustomer.Tag, "INSERT" ); DataTable itemData = GetSaleItemData(); if (itemData == null || itemData.Rows.Count == 0) { throw new Exception("품목을 입력해야 합니다."); } var res = DBTranHelper.Execute(new DBTranSet() { ServiceId = "Sales", ProcessId = "Save", TranList = new DBTranData[] { new DBTranData() { Data = mastData }, new DBTranData() { Data = itemData } } }); if (res.ErrorNumber != 0) { throw new Exception(res.ErrorMessage); } ShowMsgBox("저장하였습니다."); callback(arg, res.TranList[0].ReturnValue); } catch (Exception ex) { ShowErrBox(ex); } }