Exemple #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (tB_Serial.Text == "")
            {
                MessageBox.Show("产品序列号不能为空!");
                return;
            }

            pi.sn   = tB_Serial.Text;
            pi.type = tB_Type.Text;
            pi.time = DateTime.Now.ToString();

            if (cb_UpLoad.Checked)
            {
                try
                {
                    string path = App_Configure.Cnfgs.Path_Rpt_Pim + "\\" + "pdf\\" + pi.sn + "_" + pi.device + "_" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss") + ".pdf";
                    if (!del_SavePdf(path))
                    {
                        MessageBox.Show("save faile");
                        return;
                    }
                    FtpWeb ftp = new FtpWeb(si.ftpaddr, "", si.ftpuser, si.ftppw);
                    ftp.Upload(path);
                    pi.savepdf = "True";
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return;
                }
            }

            try
            {
                SqlConnection conn = new SqlConnection();
                //conn.ConnectionString = "Data Source=SAN-PC;Initial Catalog=Jointcom;User Id=sa;Password=sa";
                conn.ConnectionString = "Data Source=" + si.sqladdr + ";Initial Catalog=" + si.sqlname + ";User Id=" + si.sqluser + ";Password="******"insert into " + pi.device + " (SN,Type,Op,Pim,Result,Fpim,\"Power\",Mode,\"Order\",Band,Limit,Time,Remark) "
                             + "values('"
                             + pi.sn + "','"
                             + pi.type + "','"
                             + pi.tester + "','"
                             + pi.pim + "','"
                             + pi.result + "','"
                             + pi.fpim + "','"
                             + pi.power + "','"
                             + pi.mode + "','"
                             + pi.order + "','"
                             + band + "','"
                             + pi.limit + "','"
                             + pi.time + "','"
                             + pi.savepdf + "')";
                SqlCommand cmd = new SqlCommand(sql, conn);
                int        n   = cmd.ExecuteNonQuery();

                conn.Close();
                MessageBox.Show("Success!");
                this.DialogResult = DialogResult.OK;
            }
            catch (Exception ex)
            {
                MessageBox.Show("数据库连接失败:" + ex.Message);
            }
        }