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; }