/// <summary>
/// 삭제 버튼 클릭
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnRowDeleteClick(object sender, MouseButtonEventArgs e)
{
try
{
// DelEmsEqpMngr();
if (ValidationRowDelete() == false)
{
return;
}
var liHeaderCommonCodeMgmt = this.EmsEqpMngrList.Where(p => p.IsSelected == true && p.IsNew == true).ToList();
if (liHeaderCommonCodeMgmt.Count() <= 0)
{
BaseClass.MsgError("ERR_DELETE");
}
liHeaderCommonCodeMgmt.ForEach(p => EmsEqpMngrList.Remove(p));
}
catch (Exception err)
{
this.BaseClass.Error(err);
}
}
/// <summary>
/// 추가 함수
/// </summary>
private void NewEmsEqpMngr()
{
EmsEqpMngr _item = new EmsEqpMngr()
{
CENTER_CD = this.BaseClass.CenterCD,
EQP_MNGR_ID = "",
MNGR_NM = "",
MNGR_TEL_NO = "",
EMPL_DEV_CD = "DEV01",
VNDR_NM = "",
USE_YN = "Y",
RSTR_ID = this.BaseClass.UserID,
UPDR_ID = this.BaseClass.UserID,
IsNew = true,
IsSelected = true
};
EmsEqpMngrList.Add(_item);
gridMain.Focus();
gridMain.CurrentColumn = gridMain.Columns.First();
gridMain.View.FocusedRowHandle = EmsEqpMngrList.Count - 1;
}
/// <summary>
/// 저장 함수
/// </summary>
/// <returns></returns>
private bool SaveEmsEqpMngr()
{
using (BaseDataAccess da = new BaseDataAccess())
{
try
{
string _SUCCESS_CODE = "100";
var _saveItems = EmsEqpMngrList.Where(f => f.IsUpdate || f.IsNew).ToList();
//if (0 == _saveItems.Count)
if (this.EmsEqpMngrList.Where(p => p.IsSelected).Count() == 0)
{
// ERR_NO_SELECT - 선택된 데이터가 없습니다.
this.BaseClass.MsgError("ERR_NO_SELECT");
return(false);
}
// ERR_NOT_INPUT - {0}이(가) 입력되지 않았습니다.
string strInputMessage = this.BaseClass.GetResourceValue("ERR_NOT_INPUT", BaseEnumClass.ResourceType.MESSAGE);
// ASK_SAVE - 저장 하시겠습니까?
this.BaseClass.MsgQuestion("ASK_SAVE");
if (this.BaseClass.BUTTON_CONFIRM_YN == false)
{
return(false);
}
foreach (var item in _saveItems)
{
if (item.IsSelected == false)
{
continue;
}
if (string.IsNullOrWhiteSpace(item.EQP_MNGR_ID))
{
item.CellError("USER_ID", string.Format(strInputMessage, this.BaseClass.GetResourceValue("ID")));
return(false);
}
if (1 < EmsEqpMngrList.Where(f => f.EQP_MNGR_ID == item.EQP_MNGR_ID).ToList().Count)
{
// ERR_EXISTS_ID - ID가 존재합니다.
this.BaseClass.MsgError("ERR_EXISTS_ID");
return(false);
}
}
var _USER_ID = this.BaseClass.UserID;
da.BeginTransaction();
foreach (var item in _saveItems)
{
var param = new Dictionary <string, object>
{
{ "P_CENTER_CD", this.BaseClass.CenterCD },
{ "P_EQP_MNGR_ID", item.EQP_MNGR_ID }, // ID
{ "P_MNGR_NM", item.MNGR_NM }, // 이름
{ "P_MNGR_TEL_NO", item.MNGR_TEL_NO }, // 전화
{ "P_VNDR_NM", item.VNDR_NM }, // 회사명
{ "P_EMPL_DEV_CD", item.EMPL_DEV_CD }, // 고용 구분
{ "P_USE_YN", item.USE_YN },
{ "P_USER_ID", _USER_ID }
};
var strOutParam = new[] { "P_RESULT" };
string callProc = "PK_EMS_EBSE001.SP_EMS_EQP_MNGR_SAVE";
var outData = da.GetSpDataSet(
callProc // 호출 프로시저
, param // Input 파라메터
, strOutParam // Output 파라메터
);
if (outData.Tables[0].Rows.Count > 0)
{
if (outData.Tables[0].Rows[0]["CODE"].ToString() != _SUCCESS_CODE)
{
_SUCCESS_CODE = "0";
da.RollbackTransaction();
BaseClass.MsgInfo(outData.Tables[0].Rows[0]["MSG"].ToString(), BaseEnumClass.CodeMessage.MESSAGE);
break;
}
}
else
{
_SUCCESS_CODE = "0";
da.RollbackTransaction();
this.BaseClass.MsgInfo("ERR_INPUT_TYPE");
break;
}
}
if (_SUCCESS_CODE == "100")
{
da.CommitTransaction();
return(true);
}
}
catch (Exception ex)
{
da.RollbackTransaction();
this.BaseClass.Error(ex);
this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE);
}
return(false);
}
}
/// <summary>
/// 삭제 함수
/// </summary>
private void DelEmsEqpMngr()
{
var _delItems = this.EmsEqpMngrList.Where(p => p.IsSelected).ToList();
if (0 < _delItems.Count)
{
using (BaseDataAccess da = new BaseDataAccess())
{
string _SUCCESS_CODE = "100";
try
{
da.BeginTransaction();
foreach (var item in _delItems)
{
if (item.IsNew != true)
{
var param = new Dictionary <string, object>
{
{ "P_CENTER_CD", this.BaseClass.CenterCD },
{ "P_EQP_MNGR_ID", item.EQP_MNGR_ID }
};
var strOutParam = new[] { "P_RESULT" };
string callProc = "PK_EMS_EBSE001.SP_EMS_EQP_MNGR_DELETE";
var outData = da.GetSpDataSet(
callProc // 호출 프로시저
, param // Input 파라메터
, strOutParam // Output 파라메터
);
if (outData.Tables[0].Rows.Count > 0)
{
if (outData.Tables[0].Rows[0]["CODE"].ToString() != _SUCCESS_CODE)
{
_SUCCESS_CODE = "0";
da.RollbackTransaction();
BaseClass.MsgInfo(outData.Tables[0].Rows[0]["MSG"].ToString(), BaseEnumClass.CodeMessage.MESSAGE);
break;
}
}
else
{
_SUCCESS_CODE = "0";
da.RollbackTransaction();
this.BaseClass.MsgInfo("ERR_INPUT_TYPE");
break;
}
}
}
if (_SUCCESS_CODE == "100")
{
da.CommitTransaction();
foreach (var item in _delItems)
{
//if (item.IsNew != true)
EmsEqpMngrList.Remove(item);
}
gridMain.RefreshData();
}
}
catch (Exception ex)
{
da.RollbackTransaction();
this.BaseClass.Error(ex);
this.BaseClass.MsgError(ex.Message, BaseEnumClass.CodeMessage.MESSAGE);
}
}
}
else
{
// 삭제 대상을 선택하세요.
this.BaseClass.MsgInfo("INFO_SEL_DEL");
}
}
