Exemplo n.º 1
0
        private void btnReadExl_Click(object sender, EventArgs e)
        {
            string xlsPath = "";
            OpenFileDialog openFile = new OpenFileDialog();
            openFile.Filter = "xls file (*.xls)|*.xls";
            if (openFile.ShowDialog() != DialogResult.Cancel)
            {
                xlsPath = openFile.FileName;
                string conStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=" + xlsPath + ";"
                        + "Mode=ReadWrite|Share Deny None;" + "Extended Properties='Excel 8.0; HDR=YES; IMEX=1';" + "Persist Security Info=False";
                OleDbConnection con = new OleDbConnection(conStr);
                con.Open();
                OleDbCommand cmd = new OleDbCommand("SELECT * FROM [sheet1$]", con);
                var xls = cmd.ExecuteReader();
                GoodeeDAO.GoodeeDAO goodeeDAO = new GoodeeDAO.GoodeeDAO();

                while (xls.Read())
                {
                    MemberInfo member = new MemberInfo()
                    {
                        Id = xls["이메일"].ToString(),
                        Name = xls["이름"].ToString(),
                        Gender = xls["성별"].ToString() == "남자" ? 'm' : 'f',
                        BirthDate = DateTime.Parse(xls["생년월일"].ToString()),
                        Mobile = xls["휴대폰"].ToString(),
                        Address = xls["주소"].ToString(),
                        Curriculum = xls["과정명"].ToString(),
                        ClassName = xls["분류"].ToString()
                    };
                    goodeeDAO.InsertMember(member);
                } 
            }
        }
Exemplo n.º 2
0
 public static GoodeeDAO getInstance()
 {
     if (gd == null)
     {
         gd = new GoodeeDAO();
     }
     return(gd);
 }
Exemplo n.º 3
0
        private void btnWriteExl_Click(object sender, EventArgs e)
        {
            SaveFileDialog saveFile = new SaveFileDialog();
            saveFile.Filter = "Excel File (*.xls *.xlsx) | *.xls *.xlsx";
            if (saveFile.ShowDialog() != DialogResult.Cancel)
            {

                GoodeeDAO.GoodeeDAO goodeeDAO = new GoodeeDAO.GoodeeDAO();

                var list = goodeeDAO.SelectMemberList();
                var missingValue = System.Reflection.Missing.Value;
                Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
                Microsoft.Office.Interop.Excel.Workbook workbook = app.Workbooks.Add(missingValue);
                Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets.get_Item(1);
                worksheet.Cells[1][2] = "분류";
                worksheet.Cells[2][2] = "과정명";
                worksheet.Cells[3][2] = "회차";
                worksheet.Cells[4][2] = "이름";
                worksheet.Cells[5][2] = "생년월일";
                worksheet.Cells[6][2] = "성별";
                worksheet.Cells[7][2] = "휴대폰";
                worksheet.Cells[8][2] = "이메일";
                worksheet.Cells[9][2] = "주소";
                worksheet.Cells[10][2] = "학력";
                worksheet.Cells[11][2] = "최종학교";
                worksheet.Cells[12][2] = "전공";

                for (int i = 0; i < list.Count; i++)
                {
                    worksheet.Cells[1][i + 3] = list[i].Curriculum;
                    worksheet.Cells[2][i + 3] = list[i].Class_name;
                    worksheet.Cells[3][i + 3] = list[i].Class_name.Substring(list[i].Class_name.Length - 3);
                    worksheet.Cells[4][i + 3] = list[i].Name;
                    worksheet.Cells[5][i + 3] = list[i].BirthDate;
                    worksheet.Cells[6][i + 3] = list[i].Gender == "m"? "남자" : "여자";
                    worksheet.Cells[7][i + 3] = list[i].Mobile;
                    worksheet.Cells[8][i + 3] = "";
                    worksheet.Cells[9][i + 3] = list[i].Address;
                    worksheet.Cells[10][i + 3] = "학력";
                    worksheet.Cells[11][i + 3] = "최종학교";
                    worksheet.Cells[12][i + 3] = "전공";
                }
                workbook.SaveAs(saveFile.FileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, missingValue, missingValue, missingValue, missingValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, missingValue, missingValue, missingValue, missingValue, missingValue);
                workbook.Close(true, missingValue, missingValue);

                Marshal.ReleaseComObject(worksheet);
                Marshal.ReleaseComObject(workbook);
                Marshal.ReleaseComObject(app);
            }
        }
Exemplo n.º 4
0
 private void PortfolioManager_Load(object sender, EventArgs e)
 {
     GoodeeDAO.GoodeeDAO dao = new GoodeeDAO.GoodeeDAO();
     dataGridView1.DataSource              = dao.SelectMemberList();
     dataGridView1.AutoSizeColumnsMode     = DataGridViewAutoSizeColumnsMode.Fill;
     dataGridView1.Columns[0].HeaderText   = "분류";
     dataGridView1.Columns[1].HeaderText   = "과정명";
     dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
     dataGridView1.Columns[2].HeaderText   = "이름";
     dataGridView1.Columns[3].Visible      = false;
     dataGridView1.Columns[4].Visible      = false;
     dataGridView1.Columns[5].Visible      = false;
     dataGridView1.Columns[6].Visible      = false;
     dataGridView1.Columns[7].Visible      = false;
 }
Exemplo n.º 5
0
 public FrmLogin()
 {
     InitializeComponent();
     gd = GoodeeDAO.GoodeeDAO.getInstance();
 }