Ejemplo n.º 1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MES.Server.Model.OQC_PackExfo model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into OQC_PackExfo(");
            strSql.Append("SN,TestDate,PartNumber,Result,Wave,IL_A,Refl_A,IL_B,Refl_B,ClientSN,OrderID,BatchNo,PackDate,CustomerName,ID_Key)");
            strSql.Append(" values (");
            strSql.Append("@SN,@TestDate,@PartNumber,@Result,@Wave,@IL_A,@Refl_A,@IL_B,@Refl_B,@ClientSN,@OrderID,@BatchNo,@PackDate,@CustomerName,@ID_Key)");
            SqlParameter[] parameters =
            {
                new SqlParameter("@SN",           SqlDbType.VarChar,   25),
                new SqlParameter("@TestDate",     SqlDbType.VarChar,   25),
                new SqlParameter("@PartNumber",   SqlDbType.VarChar,   50),
                new SqlParameter("@Result",       SqlDbType.VarChar,   10),
                new SqlParameter("@Wave",         SqlDbType.VarChar,   10),
                new SqlParameter("@IL_A",         SqlDbType.VarChar,   10),
                new SqlParameter("@Refl_A",       SqlDbType.VarChar,   10),
                new SqlParameter("@IL_B",         SqlDbType.VarChar,   10),
                new SqlParameter("@Refl_B",       SqlDbType.VarChar,   10),
                new SqlParameter("@ClientSN",     SqlDbType.VarChar,   25),
                new SqlParameter("@OrderID",      SqlDbType.VarChar,   35),
                new SqlParameter("@BatchNo",      SqlDbType.VarChar,   35),
                new SqlParameter("@PackDate",     SqlDbType.DateTime),
                new SqlParameter("@CustomerName", SqlDbType.VarChar,   25),
                new SqlParameter("@ID_Key",       SqlDbType.Decimal, 9)
            };
            parameters[0].Value  = model.SN;
            parameters[1].Value  = model.TestDate;
            parameters[2].Value  = model.PartNumber;
            parameters[3].Value  = model.Result;
            parameters[4].Value  = model.Wave;
            parameters[5].Value  = model.IL_A;
            parameters[6].Value  = model.Refl_A;
            parameters[7].Value  = model.IL_B;
            parameters[8].Value  = model.Refl_B;
            parameters[9].Value  = model.ClientSN;
            parameters[10].Value = model.OrderID;
            parameters[11].Value = model.BatchNo;
            parameters[12].Value = model.PackDate;
            parameters[13].Value = model.CustomerName;
            parameters[14].Value = model.ID_Key;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public MES.Server.Model.OQC_PackExfo GetModel(string SN)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 SN,TestDate,PartNumber,Result,Wave,IL_A,Refl_A,IL_B,Refl_B,ClientSN,OrderID,BatchNo,PackDate,CustomerName,ID_Key from OQC_PackExfo ");
            strSql.Append(" where SN=@SN ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@SN", SqlDbType.VarChar, 25)
            };
            parameters[0].Value = SN;

            MES.Server.Model.OQC_PackExfo model = new MES.Server.Model.OQC_PackExfo();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 3
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public MES.Server.Model.OQC_PackExfo DataRowToModel(DataRow row)
 {
     MES.Server.Model.OQC_PackExfo model = new MES.Server.Model.OQC_PackExfo();
     if (row != null)
     {
         if (row["SN"] != null)
         {
             model.SN = row["SN"].ToString();
         }
         if (row["TestDate"] != null)
         {
             model.TestDate = row["TestDate"].ToString();
         }
         if (row["PartNumber"] != null)
         {
             model.PartNumber = row["PartNumber"].ToString();
         }
         if (row["Result"] != null)
         {
             model.Result = row["Result"].ToString();
         }
         if (row["Wave"] != null)
         {
             model.Wave = row["Wave"].ToString();
         }
         if (row["IL_A"] != null)
         {
             model.IL_A = row["IL_A"].ToString();
         }
         if (row["Refl_A"] != null)
         {
             model.Refl_A = row["Refl_A"].ToString();
         }
         if (row["IL_B"] != null)
         {
             model.IL_B = row["IL_B"].ToString();
         }
         if (row["Refl_B"] != null)
         {
             model.Refl_B = row["Refl_B"].ToString();
         }
         if (row["ClientSN"] != null)
         {
             model.ClientSN = row["ClientSN"].ToString();
         }
         if (row["OrderID"] != null)
         {
             model.OrderID = row["OrderID"].ToString();
         }
         if (row["BatchNo"] != null)
         {
             model.BatchNo = row["BatchNo"].ToString();
         }
         if (row["PackDate"] != null && row["PackDate"].ToString() != "")
         {
             model.PackDate = DateTime.Parse(row["PackDate"].ToString());
         }
         if (row["CustomerName"] != null)
         {
             model.CustomerName = row["CustomerName"].ToString();
         }
         if (row["ID_Key"] != null && row["ID_Key"].ToString() != "")
         {
             model.ID_Key = decimal.Parse(row["ID_Key"].ToString());
         }
     }
     return(model);
 }
Ejemplo n.º 4
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(MES.Server.Model.OQC_PackExfo model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update OQC_PackExfo set ");
            strSql.Append("TestDate=@TestDate,");
            strSql.Append("PartNumber=@PartNumber,");
            strSql.Append("Result=@Result,");
            strSql.Append("Wave=@Wave,");
            strSql.Append("IL_A=@IL_A,");
            strSql.Append("Refl_A=@Refl_A,");
            strSql.Append("IL_B=@IL_B,");
            strSql.Append("Refl_B=@Refl_B,");
            strSql.Append("ClientSN=@ClientSN,");
            strSql.Append("OrderID=@OrderID,");
            strSql.Append("BatchNo=@BatchNo,");
            strSql.Append("PackDate=@PackDate,");
            strSql.Append("CustomerName=@CustomerName,");
            strSql.Append("ID_Key=@ID_Key");
            strSql.Append(" where SN=@SN ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@TestDate",     SqlDbType.VarChar,   25),
                new SqlParameter("@PartNumber",   SqlDbType.VarChar,   50),
                new SqlParameter("@Result",       SqlDbType.VarChar,   10),
                new SqlParameter("@Wave",         SqlDbType.VarChar,   10),
                new SqlParameter("@IL_A",         SqlDbType.VarChar,   10),
                new SqlParameter("@Refl_A",       SqlDbType.VarChar,   10),
                new SqlParameter("@IL_B",         SqlDbType.VarChar,   10),
                new SqlParameter("@Refl_B",       SqlDbType.VarChar,   10),
                new SqlParameter("@ClientSN",     SqlDbType.VarChar,   25),
                new SqlParameter("@OrderID",      SqlDbType.VarChar,   35),
                new SqlParameter("@BatchNo",      SqlDbType.VarChar,   35),
                new SqlParameter("@PackDate",     SqlDbType.DateTime),
                new SqlParameter("@CustomerName", SqlDbType.VarChar,   25),
                new SqlParameter("@ID_Key",       SqlDbType.Decimal,    9),
                new SqlParameter("@SN",           SqlDbType.VarChar, 25)
            };
            parameters[0].Value  = model.TestDate;
            parameters[1].Value  = model.PartNumber;
            parameters[2].Value  = model.Result;
            parameters[3].Value  = model.Wave;
            parameters[4].Value  = model.IL_A;
            parameters[5].Value  = model.Refl_A;
            parameters[6].Value  = model.IL_B;
            parameters[7].Value  = model.Refl_B;
            parameters[8].Value  = model.ClientSN;
            parameters[9].Value  = model.OrderID;
            parameters[10].Value = model.BatchNo;
            parameters[11].Value = model.PackDate;
            parameters[12].Value = model.CustomerName;
            parameters[13].Value = model.ID_Key;
            parameters[14].Value = model.SN;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }