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);
}
}
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 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
{
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 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
{
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 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);
}
}
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;
}
}
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);
}
}
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);
}
}
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);
}
}
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;
}
}
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;
}
}
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);
}
}
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);
}
}
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);
}
}
protected override void DataLoad(object param = null)
{
try
{
DataMap p = new DataMap();
p.SetValue("ST_SALE_DATE", datSaleDate.DateFrEdit.GetDateChar8());
p.SetValue("ED_SALE_DATE", datSaleDate.DateToEdit.GetDateChar8());
var res = DBTranHelper.GetData("Sales", "GetSaleStat", p);
if (res.TranList.Length == 0)
{
throw new Exception("조회 데이터가 없습니다.");
}
if (res.TranList.Length > 0)
{
gridSaleProduct.DataSource = (res.TranList[0].Data as List <DataMap>).DataMapListToDataTable("Data1");
}
if (res.TranList.Length > 1)
{
gridSaleCustomer.DataSource = (res.TranList[1].Data as List <DataMap>).DataMapListToDataTable("Data2");
}
if (res.TranList.Length > 2)
{
gridSaleCategory.DataSource = (res.TranList[2].Data as List <DataMap>).DataMapListToDataTable("Data3");
}
if (res.TranList.Length > 3)
{
gridSalePayType.DataSource = (res.TranList[3].Data as List <DataMap>).DataMapListToDataTable("Data4");
}
}
catch (Exception ex)
{
ShowErrBox(ex);
}
}
private void GetSaleAmount()
{
try
{
var res = DBTranHelper.GetData("Sales", "GetSaleSumData", null);
if (res.TranList.Length > 0)
{
if (res.TranList[0].Data == null)
{
throw new Exception("조회 데이터가 없습니다.");
}
SaleSumDataModel model = res.TranList[0].Data as SaleSumDataModel;
esDaySaleCount.Text = string.Format("{0:N0}", model.SALE_DAY_COUNT);
esDaySaleAmount.Text = string.Format("{0:N0}", model.SALE_DAY_AMOUNT);
esMonSaleAmount.Text = string.Format("{0:N0}", model.SALE_MON_AMOUNT);
}
}
catch (Exception ex)
{
ShowErrBox(ex);
}
}
void DetailDataLoad(object id)
{
try
{
DataMap data = (DataMap)DBTranHelper.GetData("Base", "GetData", "SelectUsers", new DataMap()
{
{ "USER_ID", id }
}).TranList[0].Data;
if (data == null)
{
throw new Exception("조회할 데이터가 없습니다.");
}
txtUserId.EditValue = data.GetValue("USER_ID");
txtUserName.EditValue = data.GetValue("USER_NAME");
lupUserType.EditValue = data.GetValue("USER_TYPE");
txtLoginId.EditValue = data.GetValue("LOGIN_ID");
chkUseYn.EditValue = data.GetValue("USE_YN");
memeRemarks.EditValue = data.GetValue("REMARKS");
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;
txtUserName.Focus();
}
catch (Exception ex)
{
ShowErrBox(ex);
}
}
private void InputEnter()
{
try
{
if (SaleInputMode == SaleInputMode.Item)
{
if (txtInput.EditValue.ToStringNullToEmpty().IsNullOrEmpty() == false)
{
var res = DBTranHelper.GetData <DataMap>("Product", "GetDataByBarcode", new DataMap()
{
{ "BARCODE", txtInput.EditValue }
});
if (res == null)
{
throw new Exception("데이터가 정확하지 않습니다.");
}
SetSaleItem(new SaleTranItemDataModel()
{
PRODUCT_ID = res.GetValue("PRODUCT_ID").ToIntegerNullToZero(),
PRODUCT_CODE = res.GetValue("PRODUCT_CODE").ToStringNullToEmpty(),
PRODUCT_NAME = res.GetValue("PRODUCT_NAME").ToStringNullToEmpty(),
SALE_PRICE = res.GetValue("SALE_PRICE").ToIntegerNullToZero(),
DISC_RATE = 0,
DISC_PRICE = res.GetValue("SALE_PRICE").ToIntegerNullToZero(),
SALE_QTY = (lupSaleType.EditValue.ToString() == "0") ? 1 : -1,
SALE_AMT = res.GetValue("SALE_PRICE").ToIntegerNullToZero(),
DISC_AMT = 0,
NPAY_AMT = res.GetValue("SALE_PRICE").ToIntegerNullToZero(),
DISC_TYPE = "00"
});
txtInput.Focus();
}
}
else if (SaleInputMode == SaleInputMode.ChangeQty)
{
if (txtInput.EditValue.ToStringNullToEmpty().IsNumeric() == false)
{
ShowMsgBox("변경할 수량을 숫자로 입력하세요.");
txtInput.Clear();
txtInput.Focus();
}
else
{
if (gridItems.FocusedRowHandle < 0)
{
return;
}
int rowIndex = gridItems.FocusedRowHandle;
int qty = txtInput.EditValue.ToIntegerNullToZero();
gridItems.SetValue(rowIndex, "SALE_QTY", qty);
gridItems.UpdateCurrentRow();
CalcSaleItem(gridItems.FocusedRowHandle);
SetSaleInputMode(SaleInputMode.Item);
txtInput.Clear();
txtInput.Focus();
}
}
else if (SaleInputMode == SaleInputMode.DiscountRate)
{
if (txtInput.EditValue.ToStringNullToEmpty().IsNumeric() == false)
{
ShowMsgBox("할인율은 숫자로 입력해야 합니다.");
txtInput.Clear();
txtInput.Focus();
}
else
{
if (gridItems.FocusedRowHandle < 0)
{
return;
}
int rowIndex = gridItems.FocusedRowHandle;
int dcRate = txtInput.EditValue.ToIntegerNullToZero();
gridItems.SetValue(rowIndex, "DISC_RATE", dcRate);
gridItems.SetValue(rowIndex, "DISC_TYPE", "10");
gridItems.UpdateCurrentRow();
CalcSaleItem(gridItems.FocusedRowHandle);
SetSaleInputMode(SaleInputMode.Item);
txtInput.Clear();
txtInput.Focus();
}
}
else if (SaleInputMode == SaleInputMode.DiscountAmount)
{
if (txtInput.EditValue.ToStringNullToEmpty().IsNumeric() == false)
{
ShowMsgBox("할인액은 숫자로 입력해야 합니다.");
txtInput.Clear();
txtInput.Focus();
}
else
{
if (gridItems.FocusedRowHandle < 0)
{
return;
}
int rowIndex = gridItems.FocusedRowHandle;
int discAmt = txtInput.EditValue.ToIntegerNullToZero();
gridItems.SetValue(rowIndex, "DISC_RATE", 0);
gridItems.SetValue(rowIndex, "DISC_AMT", discAmt);
gridItems.SetValue(rowIndex, "DISC_TYPE", "20");
gridItems.UpdateCurrentRow();
CalcSaleItem(gridItems.FocusedRowHandle);
SetSaleInputMode(SaleInputMode.Item);
txtInput.Clear();
txtInput.Focus();
}
}
}
catch (Exception ex)
{
ShowErrBox(ex);
}
}
void DetailDataLoad(object id)
{
try
{
var res = DBTranHelper.GetData("Customer", new DataMap()
{
{ "CUSTOMER_ID", id }
});
if (res == null)
{
throw new Exception("처리결과를 수신하지 못했습니다.");
}
if (res.ErrorNumber != 0)
{
throw new Exception(res.ErrorMessage);
}
if (res.TranList == null || res.TranList.Length == 0)
{
throw new Exception("처리결과 데이터가 없습니다.");
}
if (res.TranList.Length > 0)
{
if (res.TranList[0].Data == null)
{
throw new Exception("조회할 데이터가 없습니다.");
}
DataMap data = res.TranList[0].Data as DataMap;
txtCustomerId.EditValue = data.GetValue("CUSTOMER_ID");
txtCustomerName.EditValue = data.GetValue("CUSTOMER_NAME");
lupCustomerType.EditValue = data.GetValue("CUSTOMER_TYPE");
txtEmail.EditValue = data.GetValue("EMAIL");
txtHpage.EditValue = data.GetValue("HPAGE");
chkUseYn.EditValue = data.GetValue("USE_YN");
memRemarks.EditValue = data.GetValue("REMARKS");
mBizRegId = data.GetValue("BIZ_REG_ID");
txtBizRegNo.EditValue = data.GetValue("BIZ_REG_NO");
txtBizName.EditValue = data.GetValue("BIZ_NAME");
txtRepName.EditValue = data.GetValue("REP_NAME");
txtBizType.EditValue = data.GetValue("BIZ_TYPE");
txtBizItem.EditValue = data.GetValue("BIZ_ITEM");
mAddressId = data.GetValue("ADDRESS_ID");
txtPostNo.EditValue = data.GetValue("POST_NO");
txtZoneNo.EditValue = data.GetValue("ZONE_NO");
txtAddress1.EditValue = data.GetValue("ADDRESS1");
txtAddress2.EditValue = data.GetValue("ADDRESS2");
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");
}
if (res.TranList.Length > 1)
{
gridPhones.DataSource = (res.TranList[1].Data as List <DataMap>).DataMapListToDataTable();
}
if (res.TranList.Length > 2)
{
gridAddress.DataSource = (res.TranList[2].Data as List <DataMap>).DataMapListToDataTable();
}
btnAddressSave.Enabled =
btnPhoneSave.Enabled = true;
SetToolbarButtons(new ToolbarButtons()
{
New = true, Refresh = true, Save = true, SaveAndNew = true, Delete = true
});
this.EditMode = EditModeEnum.Modify;
txtCustomerName.Focus();
}
catch (Exception ex)
{
ShowErrBox(ex);
}
}
public static void Init()
{
try
{
Logger.Debug("Setting Start!!");
GlobalVar.DatabaseId = "REAL";
GlobalVar.ServerUrl = ServerConsts.REAL;
GlobalVar.Settings.SetValue("IS_USESKIN", SkinConsts.IS_USESKIN);
GlobalVar.Settings.SetValue("MAIN_SKIN", SkinConsts.MAIN_SKIN);
GlobalVar.Settings.SetValue("FORM_SKIN", SkinConsts.FORM_SKIN);
GlobalVar.Settings.SetValue("GRID_SKIN", SkinConsts.GRID_SKIN);
GlobalVar.Settings.SetValue("GRID_EVEN_AND_ODD", SkinConsts.GRID_EVEN_AND_ODD);
if (FontFamily.Families.Where(x => x.Name == SkinConsts.FONT_NAME).Any())
{
GlobalVar.Settings.SetValue("FONT_NAME", SkinConsts.FONT_NAME);
}
else
{
GlobalVar.Settings.SetValue("FONT_NAME", SystemFonts.DefaultFont.Name);
}
GlobalVar.Settings.SetValue("FONT_SIZE", SkinConsts.FONT_SIZE);
AppearanceObject.DefaultFont = new Font(GlobalVar.Settings.GetValue("FONT_NAME").ToStringNullToEmpty(), (float)GlobalVar.Settings.GetValue("FONT_SIZE"));
GlobalVar.Settings.SetValue("VISIBLE_TOOLBAR_NAME", "YES");
GlobalVar.Settings.SetValue("COMPANY_NAME", "JW.Play");
GlobalVar.Settings.SetValue("DEPARTMENT_NAME", "Development Division");
GlobalVar.Settings.SetValue("USER_NAME", "Manager");
GlobalVar.Settings.SetValue("MAINFORM_WINDOW_STATE", FormWindowState.Maximized);
SplashUtils.ShowWait("리소스 데이터를 생성하는 중입니다... 잠시만...");
DomainUtils.Init();
try
{
DataTable data = (DataTable)DBTranHelper.GetData("Auth", "GetSettings", "Setting", new DataMap()).TranList[0].Data;
if (data != null && data.Rows.Count > 0)
{
foreach (DataRow row in data.Rows)
{
GlobalVar.Settings.SetValue(row["CODE"].ToString(), row["VALUE"]);
}
}
}
catch (Exception ex)
{
MsgBox.Show(ex);
}
try
{
DomainUtils.SetData();
}
catch (Exception ex)
{
MsgBox.Show(ex);
}
SplashUtils.CloseWait();
Logger.Debug("Setting End!!");
}
catch (Exception ex)
{
MsgBox.Show(ex);
}
}