李泥兒

 public ReportDB(string DBPath)
        {
            GetConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + DBPath + ";";//Uid=Admin;Pwd=t040";
            //GetConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:\share\MTF.mdb;";
        } 

public bool UpdateInfineraDReport(string strSN, string Model, double IL, double d1dB, double d20dB, double d2dB, double d3dB, double PDL,
            double WSE, double FR, double WDL, double TDL, string testID, string customer)
        {
            string strSQL = @"UPDATE test_data_MTF SET  IL=@IL ,Model=@Model,1dB=@1dB,20dB=@20dB,2dB=@2dB,3dB=@3dB,
                PDL=@PDL,WSE=@WSE,FR=@FR,WDL=@WDL,TDL=@TDL,testID=@testID,customer=@customer,

               dated=@dated  WHERE SN=@SN";
          
            OleDbConnection cn = new OleDbConnection(GetConnectionString);
           
            using (cn)
            {
                cn.Open();

                OleDbCommand dc = new OleDbCommand();
                dc.Connection = cn;
                dc.CommandText = strSQL;
                //dc.CommandType = CommandType.StoredProcedure;
                dc.Parameters.Add(new OleDbParameter("@WL", OleDbType.Single)).Value = IL;
                dc.Parameters.Add(new OleDbParameter("@Model", OleDbType.Char)).Value = Model;
              
                dc.Parameters.Add(new OleDbParameter("@1dB", OleDbType.Single)).Value = d1dB;
                dc.Parameters.Add(new OleDbParameter("@20dB", OleDbType.Single)).Value = d20dB;
                dc.Parameters.Add(new OleDbParameter("@2dB", OleDbType.Single)).Value = d2dB;
                dc.Parameters.Add(new OleDbParameter("@3dB", OleDbType.Single)).Value = d3dB;
                dc.Parameters.Add(new OleDbParameter("@PDL", OleDbType.Single)).Value = PDL;
                dc.Parameters.Add(new OleDbParameter("@WSE", OleDbType.Single)).Value = WSE;
                dc.Parameters.Add(new OleDbParameter("@FR", OleDbType.Single)).Value = FR;
              
                dc.Parameters.Add(new OleDbParameter("@WDL", OleDbType.Single)).Value = WDL;
                dc.Parameters.Add(new OleDbParameter("@TDL", OleDbType.Single)).Value = TDL;
                dc.Parameters.Add(new OleDbParameter("@testID", OleDbType.Char)).Value = testID;
                dc.Parameters.Add(new OleDbParameter("@customer", OleDbType.Char)).Value = customer;
                dc.Parameters.Add(new OleDbParameter("@dated", OleDbType.Date)).Value = DateTime.Now.ToShortDateString();
                dc.Parameters.Add(new OleDbParameter("@SN", OleDbType.Char)).Value = strSN;

                //參數順序要與strSQL相同,否則是無法寫入資料庫
            

                try
                {
                    dc.ExecuteNonQuery();
                    return true;
                }
                catch (Exception)
                {
                    //throw new System.Exception("AddConfigure", ex);
                    return false;
                  
                }

            }

        }