File name
Commit message
Commit date
File name
Commit message
Commit date
using DevExpress.XtraEditors;
using PublicLib;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace KHSCALE_TP
{
public partial class FormLogin : Form
{
U3Database u3Database = new U3Database();
string m_COMP_CD = "";
string Login_ID = "";
string Login_NM = "";
public FormLogin(string COMP_CD)
{
InitializeComponent();
m_COMP_CD = COMP_CD;
DataView grpUser = new DataView(GetUserTable());
UtilClass.SetLookup(this.lookUpEdit_User, grpUser, "USR_ID", "USR_NM", true);
}
private DataTable GetUserTable()
{
try
{
return u3Database.OpenSQL("select a.USR_ID, a.USR_NM from dbo.T_SYS_USER a where a.COMP_CD = '" + m_COMP_CD + "' and isnull(a.DEL_YN,'N') = 'N' and isnull(a.PRODUCTION_YN,'N') = 'Y' order by a.USR_NM"
+ "");
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
return null;
}
private void simpleButton_Cancel_Click(object sender, EventArgs e)
{
this.Close();
}
private void simpleButton_Number_Click(object sender, EventArgs e)
{
bool bCehck = false;
if (textEdit_PIN.Text.Length <= 3)
{
textEdit_PIN.Text += ((SimpleButton)sender).Text;
textEdit_PIN.ForeColor = Color.Black;
bCehck = true;
}
if (textEdit_PIN.Text.Length == 4 && bCehck)
{
InputCheck();
}
}
private void simpleButton1_X_Click(object sender, EventArgs e)
{
textEdit_PIN.Text = "";
textEdit_PIN.ForeColor = Color.Black;
}
private void simpleButton_Backspace_Click(object sender, EventArgs e)
{
if (textEdit_PIN.Text.Length < 1) return;
textEdit_PIN.Text = textEdit_PIN.Text.Substring(0, textEdit_PIN.Text.Length - 1);
textEdit_PIN.ForeColor = Color.Black;
}
private void InputCheck()
{
try
{
this.Cursor = Cursors.WaitCursor;
DataTable dt = u3Database.OpenSQL("select a.USR_ID, a.USR_NM from dbo.T_SYS_USER a where a.COMP_CD = '" + m_COMP_CD + "' and isnull(a.DEL_YN,'N') = 'N' and isnull(a.PRODUCTION_YN,'N') = 'Y'" +
" and '" + this.lookUpEdit_User.EditValue + "' = a.USR_ID and TOUCH_PIN_NO = '" + textEdit_PIN.Text + "'" +
" order by a.USR_NM"
+ "");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
ConstClass._USR_ID = dt.Rows[0]["USR_ID"].ToString();
ConstClass._USR_NM = dt.Rows[0]["USR_NM"].ToString();
this.DialogResult = DialogResult.Yes;
}
else
{
textEdit_PIN.ForeColor = Color.Red;
}
}
}
catch (Exception ex)
{
this.Cursor = Cursors.Arrow;
XtraMessageBox.Show(ex.Message);
}
this.Cursor = Cursors.Arrow;
}
}
}