private void LoadcmbNguoiGiaoViec()
{
var cmb = cmbNguoiGiaoViec;
cmb.Tag = 0;
clsNhanSu cls = new clsNhanSu();
DataTable dt = cls.GetNhanSu(17, 0);
//dt.DefaultView.RowFilter = "Ten_BoPhan = 'Bộ phận Quản lý' AND TrangThai_DiLam = 'Đang đi làm'";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "HoTen";
cmb.Properties.ValueMember = "ID_NhanSu";
cmb.Tag = 1;
}
private void SendMaill(string ds_IDnhanvien, string noiDung)
{
var clsNs = new clsNhanSu();
var dt = clsNs.GetNhanSu(SystemModule.HeThong.GlobalVariables.uID_DonVi, 0);
var EmailName = "";
//
var mailFrom = "*****@*****.**";
var password = "******";
const string subject = "Nhắc nhở công việc của phòng tài chính kế toán";
var body = noiDung;
//
foreach (DataRow dr in dt.Rows)
{
EmailName = dr["Email_CongTy"].ToString();
if (TrongDS(ds_IDnhanvien, dr["ID_NhanSu"].ToString()))
{
MessageBox.Show("susscess");
var fromAddress = new MailAddress(mailFrom, "Phòng tài chính kế toán");
var toAddress = new MailAddress(EmailName, "To Name");
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
Credentials = new NetworkCredential(fromAddress.Address, password),
Timeout = 20000
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
smtp.Send(message);
}
}
}
}
private void LoadcmbNhanVien()
{
if ((cmbNguoiQuanLy.EditValue ?? "").ToString() == "")
{
cmbNhanVien.Properties.DataSource = null;
cmbNhanVien.EditValue = null;
return;
}
var cmb = cmbNhanVien;
cmb.Tag = 0;
var cls = new clsNhanSu();
var dt = cls.GetNhanSu(GlobalVariables.uID_DonVi, 0);
dt.DefaultView.RowFilter = "ID_NhanSu <>" + cmbNguoiQuanLy.EditValue +
" AND TrangThai_DiLam = 'Đang đi làm'";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "HoTen";
cmb.Properties.ValueMember = "ID_NhanSu";
cmb.Tag = 1;
}
private void LoadcmbCungThucHienCu()
{
if ((cmbNhanVienCu.EditValue ?? "").ToString() == "")
{
cmbNguoiTHCu.Properties.DataSource = null;
cmbNguoiTHCu.EditValue = null;
return;
}
var cmb = cmbNguoiTHCu;
cmb.Tag = 0;
clsNhanSu cls = new clsNhanSu();
DataTable dt = cls.GetNhanSu(17, 0);
//dt.DefaultView.RowFilter = "ID_NhanSu <>" + cmbNhanVienCu.EditValue + " AND Ten_BoPhan = 'Bộ phận TCKT' AND TrangThai_DiLam = 'Đang đi làm'";
dt.DefaultView.RowFilter = "ID_NhanSu <>" + cmbNhanVienCu.EditValue;
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "HoTen";
cmb.Properties.ValueMember = "ID_NhanSu";
cmb.Properties.SeparatorChar = ',';
cmb.Tag = 1;
}
private void LoadcmbNhanVien()
{
var cmb = cmbNhanVien;
cmb.Tag = 0;
clsNhanSu cls = new clsNhanSu();
DataTable dt = cls.GetNhanSu(17, 0);
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "HoTen";
cmb.Properties.ValueMember = "ID_NhanSu";
cmb.Properties.SeparatorChar = ',';
List <String> editValues = new List <String>();
foreach (DataRow dr in dt.Rows)
{
editValues.Add(dr["ID_NhanSu"].ToString());
}
string s = String.Join(",", editValues.ToArray());
cmbNhanVien.SetEditValue(s);
cmb.Tag = 1;
}