private void button1_Click(object sender, EventArgs e)
{
XDB myDB = new XDB(
"Provider=Microsoft.ACE.OLEDB.12.0; " +
"Data Source=Members.accdb; " +
"Persist Security Info=False");
string query = "select * from member where ID = '" + textBox1.Text + "' and 비밀번호 = '" + textBox2.Text + "'";
myDB.Query(query);
if (this.textBox1.Text == "")
{
MessageBox.Show("ID를 입력하지 않으셨습니다.");
}
else if (this.textBox2.Text == "")
{
MessageBox.Show("비밀번호를 입력하지 않으셨습니다.");
}
while (myDB.ReadNext())
{
if (textBox1.Text == myDB.GetData("ID") && textBox2.Text == myDB.GetData("비밀번호"))
{
this.Close();
MessageBox.Show("로그인됬습니다");
PCset pcset = new PCset();
pcset.ShowDialog();
}
}
}
public void insertUser(String USER_GROUP, String COMP_CODE, String COMP_NAME,
String COMP_NUMBER, String CEO_NAME, String PHONE_NUMBER,
String empCode, String empName, String PRICE_GROUP,
String AUTHORITY_CODE, String ACCOUNT_CODE, String MANAGER_ID,
String PREPAID_CARD, String BUSINESS_CARD, String IDCARD_TYPE,
String USE_YN, String userInfoCode)
{
String qry = "insert into kyj_emp (empCode ,empName ,COMP_NUMBER ) VALUES ('" + empCode + "' ,'" + empName + "' ,'" + COMP_NUMBER + "' ) ";
XDB.DsOpenAdo(qry);
qry = "insert into kyj_empCateInfo( empNo ,AUTHORITY_CODE ,REG_USER_ID ,REG_DATE ,MOD_USER_ID ,MOD_DATE ,USE_YN ,userInfoCode ,MEMO ,PREPAID_CARD ,BUSINESS_CARD ,IDCARD_TYPE ,PRICE_GROUP ,ACCOUNT_CODE )" +
"select " +
"(select empNo FROM kyj_emp where empCode = '" + empCode + "') " +
",'" + AUTHORITY_CODE + "' " +
",'W118166' " +
",getdate() " +
",'' " +
",'' " +
",'" + USE_YN + "' " +
",'" + userInfoCode + "' " +
",'' " +
",'" + PREPAID_CARD + "' " +
",'" + BUSINESS_CARD + "' " +
",'" + IDCARD_TYPE + "' " +
",'" + PRICE_GROUP + "' " +
",'" + ACCOUNT_CODE + "' ";
XDB.DsOpenAdo(qry);
MessageBox.Show("입력되었습니다");
}
public DataTable searchEmp(String empName, String empCode)
{
DataTable empTable = new DataTable();
String qry = "Select * FROM kyj_emp , kyj_empCateInfo where empCode like '" + empCode + "' and empName like '" + empName + "' and dbo.kyj_emp.empNo = dbo.kyj_empCateInfo.empNo";
empTable = XDB.DsOpenAdo(qry);
return(empTable);
}
public DataTable SearchCom(String code)
{
DataTable comTable = new DataTable();
String qry = "select COMP_NUMBER, COMP_CODE, COMP_NAME, CEO_NAME, PHONE_NUMBER, USER_GROUP FROM kyj_com where COMP_CODE like '" + code + "'";
comTable = XDB.DsOpenAdo(qry);
return(comTable);
}
public void insertUser(String USER_GROUP, String COMP_CODE, String COMP_NAME,
String COMP_NUMBER, String CEO_NAME, String PHONE_NUMBER,
String empCode, String empName, String PRICE_GROUP,
String AUTHORITY_CODE, String ACCOUNT_CODE, String MANAGER_ID,
String PREPAID_CARD, String BUSINESS_CARD, String IDCARD_TYPE,
String USE_YN, String userInfoCode)
{
XDB.DsOpenAdo("exec kyj_insert_user @empCode ='" + empCode + "', @empName ='" + empName + "', @COMP_NUMBER ='" + COMP_NUMBER + "', @AUTHORITY_CODE ='" + AUTHORITY_CODE + "', @USE_YN ='" + USE_YN + "', " + "@userInfoCode ='" + userInfoCode + "', @PREPAID_CARD ='" + PREPAID_CARD + "', @BUSINESS_CARD ='" + BUSINESS_CARD + "', @IDCARD_TYPE ='" + IDCARD_TYPE + "', @PRICE_GROUP ='" + PRICE_GROUP + "', @ACCOUNT_CODE ='" + ACCOUNT_CODE + "'");
MessageBox.Show("입력되었습니다");
}
public void deleteUser(String userCode)
{
String qry = "delete FROM kyj_empCateInfo WHERE empNo in (select kyj_emp.empNo FROM kyj_emp where kyj_emp.empCode='" + userCode + "')";
XDB.DsOpenAdo(qry);
qry = "delete from kyj_emp WHERE empCode='" + userCode + "'";
XDB.DsOpenAdo(qry);
MessageBox.Show("삭제가 완료되었습니다.");
}
public void userUpdate(String empCode, String empName, String COMP_NUMBER, String AUTHORITY_CODE, String USE_YN, String userInfoCode, String PREPAID_CARD,
String BUSINESS_CARD, String IDCARD_TYPE, String PRICE_GROUP, String ACCOUNT_CODE)
{
String qry = "update kyj_emp SET empName = '" + empName + "' WHERE empCode = '" + empCode + "'";
XDB.DsOpenAdo(qry);
qry = "update kyj_empCateInfo SET AUTHORITY_CODE = '" + AUTHORITY_CODE + "' ,MOD_USER_ID = 'W118166' ,MOD_DATE = getdate() ,USE_YN = '" + USE_YN + "' ,userInfoCode = '" + userInfoCode + "' " +
",PREPAID_CARD = '" + PREPAID_CARD + "' ,BUSINESS_CARD = '" + BUSINESS_CARD + "' ,IDCARD_TYPE = '" + IDCARD_TYPE + "' ,PRICE_GROUP = '" + PRICE_GROUP + "' ,ACCOUNT_CODE = '" + ACCOUNT_CODE + "' " +
" WHERE kyj_empCateInfo.empNo in (select empNo FROM kyj_emp where empCode='" + empCode + "')";
XDB.DsOpenAdo(qry);
MessageBox.Show("수정이 완료되었습니다.");
}
public DataTable getUserList(String USER_GROUP, String comCode, String comName, String empCode, String empName)
{
DataTable datatable = new DataTable();
String qry = "select * " +
"from kyj_restaurant, kyj_com, kyj_emp, kyj_empCateInfo " +
"where dbo.kyj_emp.empNo = dbo.kyj_empCateInfo.empNo " +
"and dbo.kyj_emp.COMP_NUMBER = dbo.kyj_com.COMP_NUMBER " +
"and dbo.kyj_com.USER_GROUP = dbo.kyj_restaurant.USER_GROUP " +
"and dbo.kyj_emp.empCode like '" + empCode + "' " +
"and kyj_emp.empName like '" + empName + "' " +
"and dbo.kyj_com.COMP_NAME like '" + comName + "' " +
"and dbo.kyj_restaurant.USER_GROUP like '" + USER_GROUP + "' " +
"and dbo.kyj_com.COMP_CODE like '" + comCode + "' ";
datatable = XDB.DsOpenAdo(qry);
return(datatable);
}
private void XDBLoad(object sender, DoWorkEventArgs e)
{
sw.Restart();
if (databaseFile == "")
{
return;
}
try
{
xdb?.Dispose();
GC.Collect();
xdb = new XDB(databaseFile, e.Argument.ToString(), PerortProgress);
}
catch (ReadingDataException ex)
{
_faildedOpen = true;
System.Windows.MessageBox.Show(ex.Message);
}
}
public static void setDBConnection()
{
XDB.SetSybAdoStr("172.17.10.123", "4300", "i6950v8", "delphig00d", "midsys");
}
public void userUpdate(String empCode, String empName, String COMP_NUMBER, String AUTHORITY_CODE, String USE_YN, String userInfoCode, String PREPAID_CARD,
String BUSINESS_CARD, String IDCARD_TYPE, String PRICE_GROUP, String ACCOUNT_CODE)
{
XDB.DsOpenAdo("exec kyj_user_update @empCode = '" + empCode + "', @empName ='" + empName + "', @COMP_NUMBER = '" + COMP_NUMBER + "', @AUTHORITY_CODE = '" + AUTHORITY_CODE + "', @USE_YN ='" + USE_YN + "', @userInfoCode ='" + userInfoCode + "', @PREPAID_CARD = '" + PREPAID_CARD + "', @BUSINESS_CARD ='" + BUSINESS_CARD + "', @IDCARD_TYPE ='" + IDCARD_TYPE + "', @PRICE_GROUP ='" + PRICE_GROUP + "', @ACCOUNT_CODE ='" + ACCOUNT_CODE + "'");
MessageBox.Show("수정이 완료되었습니다.");
}
public DataTable findUserCode(String userCode)
{
return(XDB.DsOpenAdo("exec kyj_find_user_code @userCode = '" + userCode + "'"));
}
public DataTable searchEmp(String empName, String empCode)
{
return(XDB.DsOpenAdo("exec kyj_search_emp @empName ='" + empName + "', @empCode ='" + empCode + "'"));
}
public DataTable SearchCom(String code)
{
return(XDB.DsOpenAdo("exec kyj_search_com @code ='" + code + "'"));;
}
public DataTable getUserList(String USER_GROUP, String comCode, String comName, String empCode, String empName)
{
return(XDB.DsOpenAdo("exec kyj_get_list @empCode ='" + empCode + "', @empName ='" + empName + "', @comName ='" + comName + "', @USER_GROUP ='" + USER_GROUP + "', @comCode ='" + comCode + "'"));
}
public DataTable findUserCode(String userCode)
{
String qry = "select empNo from kyj_emp where empCode='" + userCode + "'";
return(XDB.DsOpenAdo(qry));
}
public void deleteUser(String userCode)
{
XDB.DsOpenAdo("exec kyj_delete_user @userCode ='" + userCode + "'");
MessageBox.Show("삭제가 완료되었습니다.");
}
