private async Task <bool> UpdateSP_SKU_UPD(SkuInfoMgmt _item, BaseDataAccess _da)
{
#region + 파라미터 변수 선언 및 값 할당
bool isRtnValue = true;
DataTable dtRtnValue = null;
var strProcedureName = "PK_C1012.SP_SKU_UPD";
Dictionary <string, object> dicInputParam = new Dictionary <string, object>();
string[] arrOutputParam = { "O_RSLT" };
var strCSTCD = this.uCtrlCst.CodeCst.Trim(); // CST_CD
var strSKUCD = _item.SKU_CD; // SKU_CD
var strSKUNM = _item.SKU_NM; // SKU_NM
var boxInQTY = _item.BOX_IN_QTY; // BOX_IN_QTY
var skuWGT = _item.SKU_WGT; // SKU_WGT
var boxWGT = _item.BOX_WGT; // BOX_WGT
var wgtUOM = _item.WGT_UOM; // WGT_UOM
var lenUOM = _item.LEN_UOM; // LEN_UOM
var cbmUOM = _item.CBM_UOM; // CBM_UOM
var skuCLS = _item.SKU_CLS; // SKU_CLS
var skuWthLEN = _item.SKU_WTH_LEN; // SKU_WTH_LEN
var skuVertLEN = _item.SKU_VERT_LEN; // SKU_VERT_LEN
var skuHgtLEN = _item.SKU_HGT_LEN; // SKU_HGT_LEN
var skuCBM = _item.SKU_CBM; // SKU_CBM
var boxWthLEN = _item.BOX_WTH_LEN; // BOX_WTH_LEN
var boxVertLEN = _item.BOX_VERT_LEN; // BOX_VERT_LEN
var boxHgtLEN = _item.BOX_HGT_LEN; // BOX_HGT_LEN
var boxCBM = _item.BOX_CBM; // BOX_CBM
var skuTmptTypeCD = _item.SKU_TMPT_TYPE_CD; // SKU_TMPT_TYPE_CD
var cellTypeCD = _item.CELL_TYPE_CD; // CELL_TYPE_CD
var useYN = _item.USE_YN; // USE_YN
#endregion
#region + Input 파라메터
dicInputParam.Add("P_CST_CD", strCSTCD);
dicInputParam.Add("P_SKU_CD", strSKUCD);
dicInputParam.Add("P_SKU_NM", strSKUNM);
dicInputParam.Add("P_BOX_IN_QTY", boxInQTY);
dicInputParam.Add("P_SKU_WGT", skuWGT);
dicInputParam.Add("P_BOX_WGT", boxWGT);
dicInputParam.Add("P_WGT_UOM", wgtUOM);
dicInputParam.Add("P_LEN_UOM", lenUOM);
dicInputParam.Add("P_CBM_UOM", cbmUOM);
dicInputParam.Add("P_SKU_CLS", skuCLS);
dicInputParam.Add("P_SKU_WTH_LEN", skuWthLEN);
dicInputParam.Add("P_SKU_VERT_LEN", skuVertLEN);
dicInputParam.Add("P_SKU_HGT_LEN", skuHgtLEN);
dicInputParam.Add("P_SKU_CBM", skuCBM);
dicInputParam.Add("P_BOX_WTH_LEN", boxWthLEN);
dicInputParam.Add("P_BOX_VERT_LEN", boxVertLEN);
dicInputParam.Add("P_BOX_HGT_LEN", boxHgtLEN);
dicInputParam.Add("P_BOX_CBM", boxCBM);
dicInputParam.Add("P_SKU_TMPT_TYPE_CD", skuTmptTypeCD);
dicInputParam.Add("P_CELL_TYPE_CD", cellTypeCD);
dicInputParam.Add("P_USE_YN", useYN);
dicInputParam.Add("P_USER_ID", this.BaseClass.UserID);
#endregion
#region + 데이터 저장
await System.Threading.Tasks.Task.Run(() =>
{
dtRtnValue = _da.GetSpDataTable(strProcedureName, dicInputParam, arrOutputParam);
}).ConfigureAwait(true);
if (dtRtnValue != null)
{
if (dtRtnValue.Rows.Count > 0)
{
if (dtRtnValue.Rows[0]["CODE"].ToString().Equals("0") == false)
{
this.BaseClass.MsgError(dtRtnValue.Rows[0]["MSG"].ToString(), BaseEnumClass.CodeMessage.MESSAGE);
isRtnValue = false;
}
}
else
{
this.BaseClass.MsgError("ERR_SAVE");
isRtnValue = false;
}
}
#endregion
return(isRtnValue);
}
private void BtnRowAdd_SkuInfo_PreviewMouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
if (this.uCtrlCst.CodeCst == string.Empty)
{
this.BaseClass.MsgError("고객사를 먼저 선택해주세요.", BaseEnumClass.CodeMessage.MESSAGE);
}
else if (isSearched == false)
{
this.BaseClass.MsgError("SKU리스트를 먼저 조회해주세요.", BaseEnumClass.CodeMessage.MESSAGE);
}
else
{
SkuInfoMgmt new_item = new SkuInfoMgmt
{
SKU_CD = string.Empty
,
SKU_NM = string.Empty
,
SKU_WTH_LEN = 0
,
SKU_VERT_LEN = 0
,
SKU_HGT_LEN = 0
,
SKU_CBM = 0
,
SKU_CLS = string.Empty
,
SKU_TMPT_TYPE_CD = string.Empty
,
BOX_IN_QTY = 0
,
BOX_WGT = 0
,
BOX_WTH_LEN = 0
,
BOX_VERT_LEN = 0
,
BOX_CBM = 0
,
WGT_UOM = string.Empty
,
LEN_UOM = string.Empty
,
CBM_UOM = string.Empty
,
CELL_TYPE_CD = string.Empty
,
CRT_SPR_CD = string.Empty
,
USE_YN = "Y"
,
IsSelected = true
,
IsNew = true
,
Checked = true
};
this.SkuInfoMgmtList.Add(new_item);
this.skuListGrid.Focus();
this.skuListGrid.CurrentColumn = this.skuListGrid.Columns.First();
this.skuListGrid.View.FocusedRowHandle = this.SkuInfoMgmtList.Count - 1;
this.SkuInfoMgmtList[this.SkuInfoMgmtList.Count - 1].BackgroundBrush = new SolidColorBrush(Colors.White);
this.SkuInfoMgmtList[this.SkuInfoMgmtList.Count - 1].BaseBackgroundBrush = new SolidColorBrush(Colors.White);
}
}
private static void View_ShowingEditor(object sender, ShowingEditorEventArgs e)
{
TableView tv = sender as TableView;
if (tv.Name.Equals("tvMasterGrid_First"))
{
SkuInfoMgmt dataMember = tv.Grid.CurrentItem as SkuInfoMgmt;
if (dataMember == null)
{
return;
}
switch (e.Column.FieldName)
{
// 컬럼이 행추가 상태 (신규 Row 추가)가 아닌 경우
// 센터코드, DB 접속 정보 컬럼은 수정이 되지 않도록 처리한다.
case "CRT_SPR_CD":
if (dataMember.IsNew == false)
{
e.Cancel = true;
}
break;
case "SKU_CD":
if (dataMember.IsNew == false)
{
e.Cancel = true;
}
break;
default: break;
}
}
else
{
SkuBcrInfoMgmt dataMember = tv.Grid.CurrentItem as SkuBcrInfoMgmt;
if (dataMember == null)
{
return;
}
switch (e.Column.FieldName)
{
// 컬럼이 행추가 상태 (신규 Row 추가)가 아닌 경우
// 센터코드, DB 접속 정보 컬럼은 수정이 되지 않도록 처리한다.
case "BCR_NO":
if (dataMember.IsNew == false)
{
e.Cancel = true;
}
break;
case "SKU_CD":
if (dataMember.IsNew == false)
{
e.Cancel = true;
}
break;
case "CRT_SPR_CD":
if (dataMember.IsNew == false)
{
e.Cancel = true;
}
break;
default: break;
}
}
}
