private void btnSave_Click(object sender, EventArgs e) { string strSQL = ""; strSQL += " SELECT [Ma_DoiTac] ,[Name] ,[Address] ,[Phones] ,[Fax] ,[Email] ,[TiLeHoaHongNoiTinh] ,[TiLeHoaHongNgoaiTinh] ,[Notes] "; strSQL += " ,[IsActive],FK_MaNhanVien,TenNhanVien,Vung,NgayKyKet,NgayKetThuc, CT.TenCongTy, DT.FK_CongTyID CongTyID "; strSQL += " ,[SoNha] ,[TenDuong] ,[CreatedBy] ,[CreatedDate] ,[UpdatedBy] ,[UpdatedDate],KinhDo,ViDo "; strSQL += " FROM [dbo].[T_DOITAC] DT LEFT JOIN T_DMCONGTY CT ON DT.FK_CongTyID = CT.PK_CongTyID "; if (radMaDoiTac.Checked) { strSQL += " WHERE Ma_DoiTac = '" + StringTools.TrimSpace(editThongTinTimKiem.Text) + "'"; } else if (radTenDoiTac.Checked) { strSQL += " WHERE Name LIKE N'%" + StringTools.TrimSpace(editThongTinTimKiem.Text) + "%'"; } else if (radDienThoại.Checked) { strSQL += " WHERE Phones LIKE '%" + StringTools.TrimSpace(editThongTinTimKiem.Text) + "%'"; } else if (radDiaChi.Checked) { strSQL += " WHERE Address LIKE '%" + StringTools.TrimSpace(editThongTinTimKiem.Text) + "%'"; } mListOfDoiTac = DoiTac.GetDoiTacs(strSQL); this.DialogResult = DialogResult.OK; this.Close(); }