예제 #1
0
파일: InData.cs 프로젝트: smilelhh/TM
        private void buttonYes_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("大量数据导入耗时较长,是否导入?", "友情提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                try
                {
                    ExcelOutputSql es = new ExcelOutputSql();

                    DataSet ds = es.ImportFromExcel(filePath);
                    DataTable dt = ds.Tables[0];
                    string connString = "Data Source=.;Initial Catalog=zfk;Integrated Security=True;Pooling=False";
                    SqlConnection conn = new SqlConnection(connString);
                    try
                    {
                        conn.Open();
                        string strInsertComm;
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            strInsertComm = "";
                            strInsertComm = "Insert INTO T_LeftInstitute([leftInstituteCode],[leftInstituteName],[leftDeadline])";
                            strInsertComm += " values(";
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                if (j > 0)
                                {
                                    strInsertComm += ",'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                                else
                                {
                                    strInsertComm += "'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                            }
                            strInsertComm += ")";
                            SqlCommand cmd = new SqlCommand(strInsertComm, conn);
                            cmd.ExecuteNonQuery();
                        }
                        MessageBox.Show("导入数据成功", "友情提示");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    finally
                    {
                        conn.Close();
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("!导入数据库失败", "友情提示");
                }
            }
            else
            {
                MessageBox.Show("!系统初始化没有完成", "友情提示");
            }
        }
예제 #2
0
파일: InData.cs 프로젝트: qq5013/TM
        private void buttonYes_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("大量数据导入耗时较长,是否导入?", "友情提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                try
                {
                    ExcelOutputSql es = new ExcelOutputSql();

                    DataSet       ds         = es.ImportFromExcel(filePath);
                    DataTable     dt         = ds.Tables[0];
                    string        connString = "Data Source=.;Initial Catalog=zfk;Integrated Security=True;Pooling=False";
                    SqlConnection conn       = new SqlConnection(connString);
                    try
                    {
                        conn.Open();
                        string strInsertComm;
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            strInsertComm  = "";
                            strInsertComm  = "Insert INTO T_LeftInstitute([leftInstituteCode],[leftInstituteName],[leftDeadline])";
                            strInsertComm += " values(";
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                if (j > 0)
                                {
                                    strInsertComm += ",'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                                else
                                {
                                    strInsertComm += "'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                            }
                            strInsertComm += ")";
                            SqlCommand cmd = new SqlCommand(strInsertComm, conn);
                            cmd.ExecuteNonQuery();
                        }
                        MessageBox.Show("导入数据成功", "友情提示");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    finally
                    {
                        conn.Close();
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("!导入数据库失败", "友情提示");
                }
            }
            else
            {
                MessageBox.Show("!系统初始化没有完成", "友情提示");
            }
        }
예제 #3
0
        private void buttonInputNewData_Click(object sender, EventArgs e)
        {
            string connString = "Data Source=.;Initial Catalog=zfk;Integrated Security=True;Pooling=False";
            SqlConnection conn1 = new SqlConnection(connString);
            try
            {
                conn1.Open();
                string sql = "delete FROM T_TempStore";
                SqlCommand cmd = new SqlCommand(sql, conn1);
                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                MessageBox.Show("!删除T_TempStore表失败", "友情提示");
            }
            finally
            {
                conn1.Close();
            }

            OpenFileDialog ofd = new OpenFileDialog();
            ofd.ShowDialog();
            textBoxFilePath.Text = ofd.FileName;
            filePath = textBoxFilePath.Text.Trim();
            if (MessageBox.Show("大量数据导入耗时较长,请耐心等待,是否导入?", "友情提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                try
                {
                    ExcelOutputSql es = new ExcelOutputSql();

                    DataSet ds = es.ImportFromExcel(filePath);
                    DataTable dt = ds.Tables[0];

                    SqlConnection conn2 = new SqlConnection(connString);
                    try
                    {
                        conn2.Open();
                        string strInsertComm;
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            strInsertComm = "";
                            strInsertComm = "Insert INTO T_TempStore([leftInstituteCode],[leftInstituteName],[leftDeadline])";
                            strInsertComm += " values(";
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                if (j > 0)
                                {
                                    strInsertComm += ",'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                                else
                                {
                                    strInsertComm += "'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                            }
                            strInsertComm += ")";
                            SqlCommand cmd = new SqlCommand(strInsertComm, conn2);
                            cmd.ExecuteNonQuery();
                        }
                        MessageBox.Show("导入数据成功", "友情提示");
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("!插入数据库失败", "友情提示");
                    }
                    finally
                    {
                        conn2.Close();
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("!导入数据失败", "友情提示");
                }
            }
            else
            {
                MessageBox.Show("!本月数据导入没有完成", "友情提示");
            }
        }
예제 #4
0
파일: SearchCountCH.cs 프로젝트: qq5013/TM
        private void buttonInputNewData_Click(object sender, EventArgs e)
        {
            string        connString = "Data Source=.;Initial Catalog=zfk;Integrated Security=True;Pooling=False";
            SqlConnection conn1      = new SqlConnection(connString);

            try
            {
                conn1.Open();
                string     sql = "delete FROM T_TempStore";
                SqlCommand cmd = new SqlCommand(sql, conn1);
                cmd.ExecuteNonQuery();
            }
            catch (Exception)
            {
                MessageBox.Show("!删除T_TempStore表失败", "友情提示");
            }
            finally
            {
                conn1.Close();
            }

            OpenFileDialog ofd = new OpenFileDialog();

            ofd.ShowDialog();
            textBoxFilePath.Text = ofd.FileName;
            filePath             = textBoxFilePath.Text.Trim();
            if (MessageBox.Show("大量数据导入耗时较长,请耐心等待,是否导入?", "友情提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                try
                {
                    ExcelOutputSql es = new ExcelOutputSql();

                    DataSet   ds = es.ImportFromExcel(filePath);
                    DataTable dt = ds.Tables[0];

                    SqlConnection conn2 = new SqlConnection(connString);
                    try
                    {
                        conn2.Open();
                        string strInsertComm;
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            strInsertComm  = "";
                            strInsertComm  = "Insert INTO T_TempStore([leftInstituteCode],[leftInstituteName],[leftDeadline])";
                            strInsertComm += " values(";
                            for (int j = 0; j < dt.Columns.Count; j++)
                            {
                                if (j > 0)
                                {
                                    strInsertComm += ",'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                                else
                                {
                                    strInsertComm += "'" + dt.Rows[i][j].ToString().Trim() + "'";
                                }
                            }
                            strInsertComm += ")";
                            SqlCommand cmd = new SqlCommand(strInsertComm, conn2);
                            cmd.ExecuteNonQuery();
                        }
                        MessageBox.Show("导入数据成功", "友情提示");
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("!插入数据库失败", "友情提示");
                    }
                    finally
                    {
                        conn2.Close();
                    }
                }
                catch (Exception)
                {
                    MessageBox.Show("!导入数据失败", "友情提示");
                }
            }
            else
            {
                MessageBox.Show("!本月数据导入没有完成", "友情提示");
            }
        }