private void gxCommand1_OnOK(object sender, EventArgs e)
{
string where = " ";
List <object> args = new List <object>();
if (txtTuKhoa.Text != "")
{
where += " AND HoTen LIKE ? ";
args.Add("%" + txtTuKhoa.Text.Replace("\"", "") + "%");
}
if (txtTenCha.Text != "")
{
where += " AND HoTenCha LIKE ? ";
args.Add("%" + txtTenCha.Text.Replace("\"", "") + "%");
}
if (txtTenMe.Text != "")
{
where += " AND HoTenMe LIKE ? ";
args.Add("%" + txtTenMe.Text.Replace("\"", "") + "%");
}
if (txtSoRuaToi.Text != "")
{
where += " AND SoRuaToi = ? ";
args.Add(txtSoRuaToi.Text.Replace("\"", ""));
}
if (cbGiaoHo.MaGiaoHo > -1)
{
where += " AND GiaoDan.MaGiaoHo=" + cbGiaoHo.MaGiaoHo.ToString();
}
frmGiaoDanList frm = new frmGiaoDanList();
//frm.LoadGiaoDanList(string.Format(SqlConstants.SELECT_GIAODAN_LIST_CO_GIAOHO, where), new object[] { "%" + txtTuKhoa.Text.Replace("\"", "") + "%" });
frm.QueryString = string.Concat(SqlConstants.SELECT_GIAODAN_LIST_CO_GIAOHO, where);
frm.Arguments = args.ToArray();
if (cbGiaoHo.MaGiaoHo > -1)
{
frm.MaGiaoHo = cbGiaoHo.MaGiaoHo;
}
Memory.Instance.SetMemory(GxConstants.DangTimKiemGiaDinhGiaoDan, 1);
Dispatcher.ShowTab(frm);
this.DialogResult = DialogResult.OK;
}
private void frmReplace_OnOK(object sender, EventArgs e)
{
if ((int)sender <= 0)
{
return;
}
if (frmReplace.TableName == GiaoDanConst.TableName)
{
frmGiaoDanList frm = new frmGiaoDanList();
frm.GiaoDanList.WhereSQL = frmReplace.WhereSQL;
frm.GiaoDanList.LoadData(SqlConstants.SELECT_GIAODAN_LIST_CO_GIAOHO, null);
ShowForm(frm);
}
else if (frmReplace.TableName == GiaDinhConst.TableName)
{
frmGiaDinhList frm = new frmGiaDinhList();
frm.GiaDinhList.WhereSQL = frmReplace.WhereSQL;
frm.GiaDinhList.LoadData(SqlConstants.SELECT_GIADINH_LIST, null);
ShowForm(frm);
}
}
private void button2_Click(object sender, EventArgs e)
{
frmGiaoDanList frm = new frmGiaoDanList();
frm.Show();
}
private void buttonBar1_ItemClick(object sender, Janus.Windows.ButtonBar.ItemEventArgs e)
{
if (e.Item.Key == "itNhapGiaoHo")
{
frmGiaoHo frm = new frmGiaoHo();
ShowForm(frm);
}
else if (e.Item.Key == "itNhapGiaoDan")
{
frmGiaoDanList frm = new frmGiaoDanList();
ShowForm(frm);
}
else if (e.Item.Key == "itNhapGiaDinh")
{
frmGiaDinhList frm = new frmGiaDinhList();
ShowForm(frm);
}
else if (e.Item.Key == "itNhapGiaoXu")
{
frmGiaoXu frm = new frmGiaoXu();
ShowForm(frm);
}
else if (e.Item.Key == "itSoBiTich")
{
frmDotBiTichList frm = new frmDotBiTichList();
ShowForm(frm);
}
else if (e.Item.Key == "itThongKeChung")
{
frmThongKeChung frm = new frmThongKeChung();
ShowForm(frm);
}
else if (e.Item.Key == "itLuuTruGiaoDan")
{
frmGiaoDanLuuTruList frm = new frmGiaoDanLuuTruList();
ShowForm(frm);
}
else if (e.Item.Key == "itLuuTruGiaDinh")
{
frmGiaDinhLuuTruList frm = new frmGiaDinhLuuTruList();
ShowForm(frm);
}
else if (e.Item.Key == "itTimGiaoDan")
{
frmTimGiaoDan.ShowDialog();
}
else if (e.Item.Key == "itTimGiaDinhCuaGiaoDan")
{
frmTimGiaDinh.ShowDialog();
}
else if (e.Item.Key == "itTimThayThe")
{
frmReplace.ShowDialog();
}
else if (e.Item.Key == "itKiemTraGiaoDan")
{
frmKiemTraGiaoDanList frm = new frmKiemTraGiaoDanList();
ShowForm(frm);
}
else if (e.Item.Key == "itKiemTraGiaDinh")
{
frmKiemTraGiaDinhList frm = new frmKiemTraGiaDinhList();
ShowForm(frm);
}
}
private void LoadFunction(string key)
{
if (key == "itNhapGiaoHo")
{
frmGiaoHo frm = new frmGiaoHo();
ShowForm(frm);
}
else if (key == "itNhapGiaoDan")
{
frmGiaoDanList frm = new frmGiaoDanList();
ShowForm(frm);
}
else if (key == "itNhapGiaDinh")
{
frmGiaDinhList frm = new frmGiaDinhList();
ShowForm(frm);
}
else if (key == "itNhapGiaoXu")
{
frmGiaoXu frm = new frmGiaoXu();
ShowForm(frm);
}
else if (key == "itSoBiTich")
{
frmDotBiTichList frm = new frmDotBiTichList();
ShowForm(frm);
}
else if (key == "itThongKeChung")
{
frmThongKeChung frm = new frmThongKeChung();
ShowForm(frm);
}
else if (key == "itLuuTruGiaoDan")
{
frmGiaoDanLuuTruList frm = new frmGiaoDanLuuTruList();
ShowForm(frm);
}
else if (key == "itLuuTruGiaDinh")
{
frmGiaDinhLuuTruList frm = new frmGiaDinhLuuTruList();
ShowForm(frm);
}
else if (key == "itTimGiaoDan")
{
frmTimGiaoDan.ShowDialog();
}
else if (key == "itTimGiaDinhCuaGiaoDan")
{
frmTimGiaDinh.ShowDialog();
}
else if (key == "itTimThayThe")
{
frmReplace.ShowDialog();
}
else if (key == "itKiemTraGiaoDan")
{
frmKiemTraGiaoDanList frm = new frmKiemTraGiaoDanList();
ShowForm(frm);
}
else if (key == "itKiemTraGiaDinh")
{
frmKiemTraGiaDinhList frm = new frmKiemTraGiaDinhList();
ShowForm(frm);
}
else if (key == "itKiemTraPhienBan")
{
GxCheckVersion checkVersion = new GxCheckVersion();
checkVersion.Alert = true;
checkVersion.OnFinished += new EventHandler(checkVersion_OnFinished);
checkVersion.Execute();
}
else if (key == "itAboutUs")
{
frmAbout frm = new frmAbout();
frm.ShowDialog();
}
else if (key == "itGopY")
{
//frmGopY frm = new frmGopY();
//frm.ShowDialog();
try
{
//System.Diagnostics.Process.Start(Memory.AppPath + "HuongDan.Doc");
if (Memory.IsConnectionAvailable())
{
frmHelp frmHelp = new frmHelp();
string helpKey = "http://forum.qlgx.net/gopy";
ShowThongTinOnline(helpKey, true);
}
else
{
MessageBox.Show("Bạn không có kết nối internet, vì thế không sử dụng được chức năng này. Bạn có thể liên hệ với tác giả qua email " + GxConstants.EMAIL + "\n Xin chân thành cảm ơn!");
}
}
catch (Exception)
{
}
}
else if (key == "itHuongDan")
{
menuItem10_Click(this, EventArgs.Empty);
}
else if (key == "itRaoHonPhoi")
{
frmRaoHonPhoiList frm = new frmRaoHonPhoiList();
ShowForm(frm);
}
else if (key == "itChuanHoaDuLieuGiaoDan")
{
chuanHoaDuLieu(ProcessOptions.AutoUpperFirstCharGiaoDan);
}
else if (key == "itChuanHoaDuLieuGiaDinh")
{
chuanHoaDuLieu(ProcessOptions.AutoUpperFirstCharGiaDinh);
}
else if (key == "itChuyenHoGiaoDan")
{
frmChuyenHoGiaoDan frm = new frmChuyenHoGiaoDan();
ShowForm(frm);
}
else if (key == "itChuyenHoGiaDinh")
{
frmChuyenHoGiaDinh frm = new frmChuyenHoGiaDinh();
ShowForm(frm);
}
else if (key == "itGiaoLy")
{
GiaoLy.frmKhoiGiaoLyList frm = new GiaoLy.frmKhoiGiaoLyList();
ShowForm(frm);
}
else if (key == "itThongTinOnline")
{
//Check message from website start
if (Memory.IsConnectionAvailable())
{
GxKiemTraThongBao kiemTraThongBao = new GxKiemTraThongBao();
kiemTraThongBao.OnFinished += new EventHandler(kiemTraThongBao_OnFinished1);
ThreadStart threadStart = new ThreadStart(kiemTraThongBao.Execute);
Thread thread = new Thread(threadStart);
thread.Start();
}
else
{
MessageBox.Show("Bạn không có kết nối internet", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//Check message from website end
}
else if (key == "itLapBiTichTuDong")
{
frmTaoDotBiTich frm = new frmTaoDotBiTich();
frm.ShowDialog();
}
else if (key == "itBieuDo")
{
frmBieuDo frm = new frmBieuDo();
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog();
}
}