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);
}
}
