/// <summary>
/// 화면 사용내역 저장
/// </summary>
/// <param name="loginscreen"></param>
/// <returns></returns>
public bool InsertLogin_Screen_History(Login_Screen_HistoryVO loginscreen)
{
try
{
using (SqlCommand com = new SqlCommand())
{
com.Connection = new SqlConnection(Connstr);
com.CommandText = @"insert into Login_Screen_History (Session_ID,Open_Day,Open_Date,User_ID,Screen_Code)
values(@Session_ID,@Open_Day,@Open_Date,@User_ID,@Screen_Code)";
com.CommandType = CommandType.Text;
com.Parameters.AddWithValue("@Session_ID", loginscreen.Session_ID);
// com.Parameters.AddWithValue("@Seg", loginscreen.Seg);
com.Parameters.AddWithValue("@Open_Day", loginscreen.Open_Day);
com.Parameters.AddWithValue("@Open_Date", loginscreen.Open_Date);
com.Parameters.AddWithValue("@User_ID", loginscreen.User_ID);
com.Parameters.AddWithValue("@Screen_Code", loginscreen.Screen_Code);
com.Connection.Open();
int resault = Convert.ToInt32(com.ExecuteNonQuery());
com.Connection.Close();
return(resault > 0);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 새로운 폼 생성
/// </summary>
/// <param name="formName">폼이름</param>
public void newForm(string formName, string formText)
{
try
{
if (userinfoScreenItem.Count(item => item.Screen_Code.Trim().Equals(formName.Trim())) > 0)
{
string nameSpace = "Axxen"; //네임스페이스 명
Assembly cuasm = Assembly.GetExecutingAssembly();
//string Format 의 따옴표와 마침표 주의!!
string childFormName = string.Format("{0}.{1}", nameSpace, formName);
frm = (Form)cuasm.CreateInstance(childFormName);
foreach (Form childForm in Application.OpenForms)
{
if (childForm.Tag.ToString().Trim().Equals(formName.Trim()))
{
ScreenItem_AuthorityVO screentype = new ScreenItem_AuthorityVO();
screentype = userinfoScreenItem.Find(item => item.Screen_Code == formName.Trim());
if (screentype != null)
{
if (screentype.Pre_Type[0] == 'Y')
{
tsbInsert.Enabled = true;
}
else
{
tsbInsert.Enabled = false;
}
if (screentype.Pre_Type[2] == 'Y')
{
tsbtnUpdate.Enabled = true;
}
else
{
tsbtnUpdate.Enabled = false;
}
if (screentype.Pre_Type[3] == 'Y')
{
tsbtnDelete.Enabled = true;
}
else
{
tsbtnDelete.Enabled = false;
}
}
for (int i = 0; i < tabControl2.TabPages.Count; i++) //활성화된 메뉴의 탭페이지눌릴수 있도록
{
if (tabControl2.TabPages[i].Tag.Equals(formName))
{
tabControl2.SelectedIndex = i;
break;
}
}
childForm.Activate();
return;
}
}
frm.MdiParent = this;
frm.WindowState = FormWindowState.Maximized;
frm.SizeChanged += Frm_SizeChanged;
//frm.Text = "";
frm.Tag = formName;
TabPage newTab = new TabPage();
newTab.Tag = formName;
newTab.Text = formText;
tabControl2.TabPages.Add(newTab);
tabControl2.SelectedTab = newTab; //새로연 메뉴의 화면 텝페이지 눌릴 수 있도록
frm.Show();
/////////////////// 메뉴클릭시
foreach (Form childForm in Application.OpenForms)
{
ScreenItem_AuthorityVO screentype = new ScreenItem_AuthorityVO();
screentype = userinfoScreenItem.Find(item => item.Screen_Code == formName.Trim());
if (screentype != null)
{
if (screentype.Pre_Type[0] == 'Y')
{
tsbInsert.Enabled = true;
}
else
{
tsbInsert.Enabled = false;
}
if (screentype.Pre_Type[2] == 'Y')
{
tsbtnUpdate.Enabled = true;
}
else
{
tsbtnUpdate.Enabled = false;
}
if (screentype.Pre_Type[3] == 'Y')
{
tsbtnDelete.Enabled = true;
}
else
{
tsbtnDelete.Enabled = false;
}
break;
}
}
//////////////////////////////////////////
// tabControl2.TabPages.Tag=formName;
// MessageBox.Show(tabControl2.SelectedTab.Tag.ToString());
// SegCnt++;
Login_Screen_HistoryVO loginscreen = new Login_Screen_HistoryVO()
{
Session_ID = UserInfo.Session_ID,
// Seg =SegCnt,
Open_Day = Convert.ToDateTime(DateTime.Now.ToShortDateString()),
Open_Date = DateTime.Now,
User_ID = UserInfo.User_ID,
Screen_Code = formName
};
userservice.InsertLogin_Screen_History(loginscreen);
lblSubtitle.Text = screenitemlist.Find(item => item.Screen_Code == formName.ToString()).Screen_Path.ToString();
}
else
{
MessageBox.Show("사용권한이 없는 메뉴입니다." + formName);
}
}
catch (Exception err)
{
MessageBox.Show("사용할 수 없는 메뉴" + err.Message + formName);
throw;
}
}
public void InsertLogin_Screen_History(Login_Screen_HistoryVO loginscreen)
{
dac.InsertLogin_Screen_History(loginscreen);
}
