public IList <Hashtable> getNoticeList()
{
Hashtable _param = new Hashtable();
_param.Add("MESSAGE_KB", "0");
IList <Hashtable> _list = _sel.GetListHashData(_param, "getBoarderList");
return(_list);
}
private void login_process()
{
if (txtPass.Text == null || txtPass.Text == "")
{
MessageBox.Show("패스워드를 입력하세요.");
return;
}
HashAlgorithm hash = new SHA256Managed();
byte[] plainTextBytes = System.Text.Encoding.UTF8.GetBytes(txtPass.Text);
byte[] hashBytes = hash.ComputeHash(plainTextBytes);
//in this string you got the encrypted password
string hashValue = Convert.ToBase64String(hashBytes);
Hashtable _param = new Hashtable();
_param.Add("MGS_USERID", txtUserId.Text.Trim());
_param.Add("PASSWD", hashValue);
_Sel _sel = new _Sel();
IList <Hashtable> _list = _sel.GetListHashData(_param, "getLoginUserInfo");
String[] login_user_info = new string[12];
if (_list.Count > 0)
{
var user = _list[0];
login_user_info[0] = txtUserId.Text.Trim();
login_user_info[1] = _cu.rtnHtS(user["SWCD"]);
login_user_info[2] = _cu.rtnHtS(user["NAME"]);
login_user_info[3] = _cu.rtnHtS(user["LEVEL_CD"]);
login_user_info[4] = _cu.rtnHtS(user["ADMIN"]);
login_user_info[5] = _cu.rtnHtS(user["ORG_CD"]);
login_user_info[6] = _cu.rtnHtS(user["GROUP_ID"]);
login_user_info[7] = _cu.rtnHtS(user["BADMIN"]);
login_user_info[8] = txtPass.Text;
login_user_info[9] = serverIP.Text;
login_user_info[10] = serverPort.Text;
login_user_info[11] = txtPass.Text;
MainProg.Instance.ConfigWriteProfile(login_user_info[0], login_user_info[9], login_user_info[10]);
MainProg.CConf.userId = login_user_info[0];
this.Visible = false;
MainForm mf = new MainForm(login_user_info);
mf.Show();
}
else
{
MessageBox.Show("패스워드를 다시 입력하세요.");
return;
}
}
//공지사항
//처음 로그인 시에만 않읽은 공지사항이 있으면 팝업처리한다.
public void ShowBoard(Boolean initFg)
{
lv_notice.Items.Clear();
lv_notice.View = View.Details;
lv_notice.GridLines = true;
lv_notice.FullRowSelect = true;
Hashtable _param = new Hashtable();
_param.Add("MESSAGE_KB", "0");
IList <Hashtable> _list = _sel.GetListHashData(_param, "getBoarderList");
if (_list.Count > 0)
{
foreach (Hashtable _item in _list)
{
String[] _boardItem =
{
_cu.rtnHtS(_item["C_INDEX"]),
_cu.rtnHtS(_item["TITLE"]),
_cu.rtnHtS(_item["NAME"]),
_cu.ToYYYYMMDD(_cu.rtnHtS(_item["REGI_DT"]),true),
_cu.rtnHtS(_item["REGI_ID"])
};
ListViewItem _itemList = new ListViewItem(_boardItem);
lv_notice.Items.Add(_itemList);
}
}
//새로운 공지사항을 팝업으로 띄운다.
if (initFg)
{
IList <Hashtable> _newnoticeList = _list.Where(w => !_cu.rtnHtS(w["ID_READER"]).Split(',').Contains(MainProg.GetUserId())).ToList <Hashtable>();
foreach (Hashtable _item in _newnoticeList)
{
NoticeView nv = new NoticeView(_cu.rtnHtS(_item["C_INDEX"]));
nv.Show();
}
}
}
private void viewBorderDetail(String noticeNum)
{
Hashtable _param = new Hashtable();
_param.Add("C_INDEX", noticeNum);
_param.Add("MESSAGE_KB", "0");
IList <Hashtable> _list = _sel.GetListHashData(_param, "getBoarderList");
if (_list.Count > 0)
{
txt_NoticeTItle.Text = _cu.rtnHtS(_list[0]["TITLE"]);
NoticeBody.DocumentText = _cu.rtnHtS(_list[0]["CONTEXT"]);
lvFileList.View = View.Details;
lvFileList.HeaderStyle = ColumnHeaderStyle.None;
lvFileList.BeginUpdate();
if (!_cu.rtnHtS(_list[0]["FILE_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE1_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE1_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE1_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE2_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE2_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE2_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE3_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE3_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE3_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE4_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE4_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE4_"]));
lvFileList.Items.Add(lvi);
}
lvFileList.EndUpdate();
}
}
private void showMessageLIst()
{
Hashtable _param = new Hashtable();
_param.Add("MESSAGE_KB", "1");
_param.Add("REGI_ID", MainProg.GetUserId());
IList <Hashtable> _list = _sel.GetListHashData(_param, "getBoarderRcvList");
IList <Hashtable> _slist = _list.Where(w => w["REGI_ID"].ToString().Equals(MainProg.GetUserId())).ToList <Hashtable>();
IList <Hashtable> _rlist = _list.Where(w => !w["REGI_ID"].ToString().Equals(MainProg.GetUserId())).ToList <Hashtable>();
//보낸 리스트
if (_slist.Count > 0)
{
foreach (Hashtable _item in _slist)
{
String _rcvUserNm = String.Empty;
String[] _usersNm = _cu.rtnHtS(_item["ID_READER"]).Split(',');
foreach (String _user in _usersNm)
{
if (_user.Equals(""))
{
continue;
}
StringBuilder sb = new StringBuilder();
sb.Append(MainProg.getUserInfoByKey("MEMBERID", _user).MEMBERNAME);
sb.Append(";");
_rcvUserNm += sb.ToString();
}
String[] _boardItem =
{
_cu.rtnHtS(_item["C_INDEX"]),
_rcvUserNm,
_cu.ToYYYYMMDD(_cu.rtnHtS(_item["REGI_DT"]), true)
};
ListViewItem _itemList = new ListViewItem(_boardItem);
lvSend.Items.Add(_itemList);
}
if (lvSend.Items.Count > 0)
{
lvSend.Items[0].Selected = true;
}
}
//받은 리스트
if (_rlist.Count > 0)
{
foreach (Hashtable _item in _rlist)
{
String _rcvUserNm = String.Empty;
StringBuilder sb = new StringBuilder();
sb.Append(MainProg.getUserInfoByKey("MEMBERID", _cu.rtnHtS(_item["REGI_ID"])).MEMBERNAME);
sb.Append(";");
_rcvUserNm += sb.ToString();
String[] _boardItem =
{
_cu.rtnHtS(_item["C_INDEX"]),
_rcvUserNm,
_cu.ToYYYYMMDD(_cu.rtnHtS(_item["REGI_DT"]), true)
};
ListViewItem _itemList = new ListViewItem(_boardItem);
lvRcv.Items.Add(_itemList);
}
if (lvRcv.Items.Count > 0)
{
lvRcv.Items[0].Selected = true;
}
}
}
private void viewMessageDetail(String messageNum)
{
Hashtable _param = new Hashtable();
_param.Add("C_INDEX", messageNum);
_param.Add("MESSAGE_KB", "1");
IList <Hashtable> _message = _sel.GetListHashData(_param, "getBoarderList");
foreach (Hashtable _item in _message)
{
String _rcvUserNm = String.Empty;
String[] _usersNm = _cu.rtnHtS(_item["ID_READER"]).Split(',');
foreach (String _user in _usersNm)
{
if (_user.Equals(""))
{
continue;
}
StringBuilder sb = new StringBuilder();
sb.Append(MainProg.getUserInfoByKey("MEMBERID", _user).MEMBERNAME);
sb.Append(";");
_rcvUserNm += sb.ToString();
}
lb_userNm.Text = MainProg.getUserInfoByKey("MEMBERID", _cu.rtnHtS(_item["REGI_ID"])).MEMBERNAME;
lb_date.Text = _cu.ToYYYYMMDD(_cu.rtnHtS(_item["REGI_DT"]), true);
messageBody.DocumentText = _cu.rtnHtS(_item["CONTEXT"]);
lvFileList.View = View.Details;
lvFileList.HeaderStyle = ColumnHeaderStyle.None;
lvFileList.BeginUpdate();
if (!_cu.rtnHtS(_item["FILE_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_item["FILE_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_item["FILE_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_item["FILE1_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_item["FILE1_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_item["FILE1_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_item["FILE2_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_item["FILE2_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_item["FILE2_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_item["FILE3_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_item["FILE3_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_item["FILE3_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_item["FILE4_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_item["FILE4_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_item["FILE4_"]));
lvFileList.Items.Add(lvi);
}
lvFileList.EndUpdate();
}
}
private void viewBorderDetail(String noticeNum)
{
Hashtable _param = new Hashtable();
_param.Add("C_INDEX", noticeNum);
_param.Add("MESSAGE_KB", "0");
_param.Add("ID_READER", MainProg.GetUserId());
//읽음으로 표시
_Ins.UpdatetHashData(_param, "mergeNoticeMessageMsgDetail");
IList <Hashtable> _list = _sel.GetListHashData(_param, "getBoarderList");
if (_list.Count > 0)
{
NoticeTitle.Text = _cu.rtnHtS(_list[0]["TITLE"]);
NoticeBody.DocumentText = _cu.rtnHtS(_list[0]["CONTEXT"]);
NoticeName.Text = _cu.rtnHtS(_list[0]["NAME"]);
NoticeDay.Text = _cu.ToYYYYMMDD(_cu.rtnHtS(_list[0]["REGI_DT"]), true);
lvFileList.View = View.Details;
lvFileList.HeaderStyle = ColumnHeaderStyle.None;
lvFileList.BeginUpdate();
if (!_cu.rtnHtS(_list[0]["FILE_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE1_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE1_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE1_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE2_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE2_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE2_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE3_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE3_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE3_"]));
lvFileList.Items.Add(lvi);
}
if (!_cu.rtnHtS(_list[0]["FILE4_"]).Equals(""))
{
ListViewItem lvi = new ListViewItem(_cu.rtnHtS(_list[0]["FILE4_ORIGIN"]));
lvi.SubItems.Add(_cu.rtnHtS(_list[0]["FILE4_"]));
lvFileList.Items.Add(lvi);
}
lvFileList.EndUpdate();
}
}
