private void lookUpEdit1_EditValueChanged(object sender, EventArgs e)
{
O_SIGNIN si = lSignIn.GetSelectedDataRow() as O_SIGNIN;
if (si != null)
{
iHangBay.EditValue = si.HangBay;
iSignIn.EditValue = si.SignIn;
iChinh.Checked = si.Chinh;
}
}
private void GVSI_DoubleClick(object sender, EventArgs e)
{
if (DuLieuTaoSan.Q.SignInThemSua)
{
_index = GVSI.GetFocusedDataSourceRowIndex();
_SignInO = GVSI.GetRow(GVSI.GetSelectedRows()[0]) as O_SIGNIN;
if (_SignInO != null)
{
new frmSignInThem(_SignInO).ShowDialog(this);
}
}
}
private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
O_SIGNIN si = GVSI.GetRow(GVSI.GetSelectedRows()[0]) as O_SIGNIN;
if (si != null)
{
_lstSIChinh.Remove(si);
GCSI.DataSource = null;
GCSI.DataSource = _lstSIChinh;
GVSI.ExpandAllGroups();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (_lstSIChinh.Where(w => w.SignIn.Equals(iSignIn.Text) && iSignIn.Text.Length > 0).Count() == 0)
{
GCSI.DataSource = null;
List <KiemTra> kiemTras = new List <KiemTra>();
kiemTras.Add(new KiemTra()
{
_Control = icmb, _Tu = 1, _Den = 50
});
kiemTras.Add(new KiemTra()
{
_Control = iHangBay, _Tu = 1, _Den = 50
});
kiemTras.Add(new KiemTra()
{
_Control = iSignIn, _Tu = 1, _Den = 50, _ChoQuaThang = icmb.SelectedIndex == 0
});
XuLyGiaoDien.KiemTra(kiemTras, dxValidationProvider1);
if (!dxValidationProvider1.Validate())
{
XuLyGiaoDien.Alert("Thông tin không hợp lệ", Form_Alert.enmType.Warning);
return;
}
O_SIGNIN si = new O_SIGNIN();
si.CanLam = icmb.SelectedIndex;
si.DaiLy = (int)iIDKhachHang.EditValue;
si.HangBay = (int)iHangBay.EditValue;
si.SignIn = iSignIn.Text;
si.MatKhau = iMatKhau.Text;
si.Chinh = iChinh.Checked;
_lstSIChinh.Add(si);
GCSI.DataSource = _lstSIChinh;
GVSI.ExpandAllGroups();
XulyDulieuKhiThem();
iMatKhau.Text = RandomPassword();
iSignIn.Text = "";
}
}
private void btnNhapExcel_Click(object sender, EventArgs e)
{
XtraOpenFileDialog ofd = new XtraOpenFileDialog();
ofd.Title = "Mở File";
ofd.Filter = "Excel File (*.xlsx, *.xls) | *.xlsx; *.xls";
ofd.DefaultExt = ".xlsx";
if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string ChuoiKetNoi = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ofd.FileName + "; Extended Properties='Excel 12.0 Xml;HDR=YES';";
using (OleDbConnection conn = new OleDbConnection(ChuoiKetNoi))
{
conn.Open();
DataTable dbSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string CauTruyVan = "SELECT * FROM [" + dbSchema.Rows[0].Field <string>("TABLE_NAME").Replace("'", string.Empty) + ']';
OleDbDataAdapter da = new OleDbDataAdapter(CauTruyVan, conn);
DataTable dt = new DataTable();
da.Fill(dt);
_lstSIChinh.Clear();
foreach (DataRow row in dt.Rows)
{
O_SIGNIN signInO = new O_SIGNIN();
signInO.DaiLy = _lstDL.Where(w => w.TenTam.ToUpper().Equals(row[0].ToString().ToUpper())).First().ID;
signInO.HangBay = _lstHB.Where(w => w.TenTat.Equals(row[1].ToString())).First().ID;
signInO.SignIn = ((row[2] ?? null) ?? string.Empty).ToString();
signInO.MatKhau = row[3].ToString();
signInO.Chinh = row[4].ToString() != "False";
signInO.CanLam = int.Parse(row[5].ToString());
signInO.End = row[6].ToString() != "False";
_lstSIChinh.Add(signInO);
}
GCSI.DataSource = null;
GCSI.DataSource = _lstSIChinh;
_lstSIChinh = _lstSIChinh.OrderBy(w => w.HangBay).OrderBy(w => w.Khoa).ToList();
XulyDulieuKhiThem();
GVSI.ExpandAllGroups();
}
}
}
public frmSignInThem(O_SIGNIN si)
{
InitializeComponent();
_SignInO = si;
Text += " sửa";
}
