public Maticsoft.Model.tsuhan_test_c SelectC(string 序列号)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tsuhan_test_c ");//型号,随工单,成品编码,客户
strSql.Append(" where 序列号=@序列号 ");
SqlParameter[] parameters =
{
new SqlParameter("@序列号", SqlDbType.NVarChar, 25)
};
parameters[0].Value = 序列号;
Maticsoft.Model.tsuhan_test_c model = new Maticsoft.Model.tsuhan_test_c();
DataSet ds = dbhelper1.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tsuhan_test_c GetModel(string 序列号)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 序列号,型号,随工单,备货单,成品编码,客户,小包装盒号,中包装盒号,大包装盒号,包装_op,Tc_c,LDλc,Pf_c,Ith_c,If_c,Vf_c,Imo_c,Es_c,Rs_c,Kink_c,Liv_判定,Liv_op,Liv_time,Cw_c,Sp_c,Smsr_c,GP_op,Gp_判定,Gp_time,Sen_c,G_c,Vbr_c,Iop_c,Io_c,Id_c,Icc_c,PTλc,Pt_op,Pt_判定,Sen_time,Pf_d from tsuhan_test_c ");
strSql.Append(" where 序列号=@序列号 ");
SqlParameter[] parameters =
{
new SqlParameter("@序列号", SqlDbType.NVarChar, 25)
};
parameters[0].Value = 序列号;
Maticsoft.Model.tsuhan_test_c model = new Maticsoft.Model.tsuhan_test_c();
DataSet ds = dbhelper1.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public Maticsoft.Model.tsuhan_test_c SelectC(string 序列号)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tsuhan_test_c ");//型号,随工单,成品编码,客户
strSql.Append(" where 序列号=@序列号 ");
SqlParameter[] parameters = {
new SqlParameter("@序列号", SqlDbType.NVarChar,25) };
parameters[0].Value = 序列号;
Maticsoft.Model.tsuhan_test_c model = new Maticsoft.Model.tsuhan_test_c();
DataSet ds = dbhelper1.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tsuhan_test_c GetModel(string 序列号)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 序列号,型号,随工单,备货单,成品编码,客户,小包装盒号,中包装盒号,大包装盒号,包装_op,Tc_c,LDλc,Pf_c,Ith_c,If_c,Vf_c,Imo_c,Es_c,Rs_c,Kink_c,Liv_判定,Liv_op,Liv_time,Cw_c,Sp_c,Smsr_c,GP_op,Gp_判定,Gp_time,Sen_c,G_c,Vbr_c,Iop_c,Io_c,Id_c,Icc_c,PTλc,Pt_op,Pt_判定,Sen_time,Pf_d from tsuhan_test_c ");
strSql.Append(" where 序列号=@序列号 ");
SqlParameter[] parameters = {
new SqlParameter("@序列号", SqlDbType.NVarChar,25) };
parameters[0].Value = 序列号;
Maticsoft.Model.tsuhan_test_c model=new Maticsoft.Model.tsuhan_test_c();
DataSet ds = dbhelper1.Query(strSql.ToString(), parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tsuhan_test_c DataRowToModel(DataRow row)
{
Maticsoft.Model.tsuhan_test_c model=new Maticsoft.Model.tsuhan_test_c();
if (row != null)
{
if(row["序列号"]!=null)
{
model.序列号=row["序列号"].ToString();
}
if(row["型号"]!=null)
{
model.型号=row["型号"].ToString();
}
if(row["随工单"]!=null)
{
model.随工单=row["随工单"].ToString();
}
if(row["备货单"]!=null)
{
model.备货单=row["备货单"].ToString();
}
if(row["成品编码"]!=null)
{
model.成品编码=row["成品编码"].ToString();
}
if(row["客户"]!=null)
{
model.客户=row["客户"].ToString();
}
if(row["小包装盒号"]!=null)
{
model.小包装盒号=row["小包装盒号"].ToString();
}
if(row["中包装盒号"]!=null)
{
model.中包装盒号=row["中包装盒号"].ToString();
}
if(row["大包装盒号"]!=null)
{
model.大包装盒号=row["大包装盒号"].ToString();
}
if(row["包装_op"]!=null)
{
model.包装_op=row["包装_op"].ToString();
}
if(row["Tc_c"]!=null && row["Tc_c"].ToString()!="")
{
model.Tc_c=decimal.Parse(row["Tc_c"].ToString());
}
if(row["LDλc"]!=null)
{
model.LDλc=row["LDλc"].ToString();
}
if(row["Pf_c"]!=null && row["Pf_c"].ToString()!="")
{
model.Pf_c=decimal.Parse(row["Pf_c"].ToString());
}
if(row["Ith_c"]!=null && row["Ith_c"].ToString()!="")
{
model.Ith_c=decimal.Parse(row["Ith_c"].ToString());
}
if(row["If_c"]!=null && row["If_c"].ToString()!="")
{
model.If_c=decimal.Parse(row["If_c"].ToString());
}
if(row["Vf_c"]!=null && row["Vf_c"].ToString()!="")
{
model.Vf_c=decimal.Parse(row["Vf_c"].ToString());
}
if(row["Imo_c"]!=null && row["Imo_c"].ToString()!="")
{
model.Imo_c=int.Parse(row["Imo_c"].ToString());
}
if(row["Es_c"]!=null && row["Es_c"].ToString()!="")
{
model.Es_c=decimal.Parse(row["Es_c"].ToString());
}
if(row["Rs_c"]!=null && row["Rs_c"].ToString()!="")
{
model.Rs_c=decimal.Parse(row["Rs_c"].ToString());
}
if(row["Kink_c"]!=null && row["Kink_c"].ToString()!="")
{
model.Kink_c=int.Parse(row["Kink_c"].ToString());
}
if(row["Liv_判定"]!=null)
{
model.Liv_判定=row["Liv_判定"].ToString();
}
if(row["Liv_op"]!=null)
{
model.Liv_op=row["Liv_op"].ToString();
}
if(row["Liv_time"]!=null && row["Liv_time"].ToString()!="")
{
model.Liv_time=DateTime.Parse(row["Liv_time"].ToString());
}
if(row["Cw_c"]!=null && row["Cw_c"].ToString()!="")
{
model.Cw_c=decimal.Parse(row["Cw_c"].ToString());
}
if(row["Sp_c"]!=null && row["Sp_c"].ToString()!="")
{
model.Sp_c=decimal.Parse(row["Sp_c"].ToString());
}
if(row["Smsr_c"]!=null && row["Smsr_c"].ToString()!="")
{
model.Smsr_c=decimal.Parse(row["Smsr_c"].ToString());
}
if(row["GP_op"]!=null)
{
model.GP_op=row["GP_op"].ToString();
}
if(row["Gp_判定"]!=null)
{
model.Gp_判定=row["Gp_判定"].ToString();
}
if(row["Gp_time"]!=null && row["Gp_time"].ToString()!="")
{
model.Gp_time=DateTime.Parse(row["Gp_time"].ToString());
}
if(row["Sen_c"]!=null && row["Sen_c"].ToString()!="")
{
model.Sen_c=decimal.Parse(row["Sen_c"].ToString());
}
if(row["G_c"]!=null && row["G_c"].ToString()!="")
{
model.G_c=decimal.Parse(row["G_c"].ToString());
}
if(row["Vbr_c"]!=null && row["Vbr_c"].ToString()!="")
{
model.Vbr_c=decimal.Parse(row["Vbr_c"].ToString());
}
if(row["Iop_c"]!=null && row["Iop_c"].ToString()!="")
{
model.Iop_c=decimal.Parse(row["Iop_c"].ToString());
}
if(row["Io_c"]!=null && row["Io_c"].ToString()!="")
{
model.Io_c=decimal.Parse(row["Io_c"].ToString());
}
if(row["Id_c"]!=null && row["Id_c"].ToString()!="")
{
model.Id_c=int.Parse(row["Id_c"].ToString());
}
if(row["Icc_c"]!=null && row["Icc_c"].ToString()!="")
{
model.Icc_c=decimal.Parse(row["Icc_c"].ToString());
}
if(row["PTλc"]!=null)
{
model.PTλc=row["PTλc"].ToString();
}
if(row["Pt_op"]!=null)
{
model.Pt_op=row["Pt_op"].ToString();
}
if(row["Pt_判定"]!=null)
{
model.Pt_判定=row["Pt_判定"].ToString();
}
if(row["Sen_time"]!=null && row["Sen_time"].ToString()!="")
{
model.Sen_time=DateTime.Parse(row["Sen_time"].ToString());
}
if(row["Pf_d"]!=null && row["Pf_d"].ToString()!="")
{
model.Pf_d=decimal.Parse(row["Pf_d"].ToString());
}
}
return model;
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.tsuhan_test_c model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tsuhan_test_c(");
strSql.Append("序列号,型号,随工单,备货单,成品编码,客户,小包装盒号,中包装盒号,大包装盒号,包装_op,Tc_c,LDλc,Pf_c,Ith_c,If_c,Vf_c,Imo_c,Es_c,Rs_c,Kink_c,Liv_判定,Liv_op,Liv_time,Cw_c,Sp_c,Smsr_c,GP_op,Gp_判定,Gp_time,Sen_c,G_c,Vbr_c,Iop_c,Io_c,Id_c,Icc_c,PTλc,Pt_op,Pt_判定,Sen_time,Pf_d)");
strSql.Append(" values (");
strSql.Append("@序列号,@型号,@随工单,@备货单,@成品编码,@客户,@小包装盒号,@中包装盒号,@大包装盒号,@包装_op,@Tc_c,@LDλc,@Pf_c,@Ith_c,@If_c,@Vf_c,@Imo_c,@Es_c,@Rs_c,@Kink_c,@Liv_判定,@Liv_op,@Liv_time,@Cw_c,@Sp_c,@Smsr_c,@GP_op,@Gp_判定,@Gp_time,@Sen_c,@G_c,@Vbr_c,@Iop_c,@Io_c,@Id_c,@Icc_c,@PTλc,@Pt_op,@Pt_判定,@Sen_time,@Pf_d)");
SqlParameter[] parameters =
{
new SqlParameter("@序列号", SqlDbType.NVarChar, 25),
new SqlParameter("@型号", SqlDbType.NVarChar, 25),
new SqlParameter("@随工单", SqlDbType.NVarChar, 25),
new SqlParameter("@备货单", SqlDbType.NVarChar, 25),
new SqlParameter("@成品编码", SqlDbType.NVarChar, 25),
new SqlParameter("@客户", SqlDbType.NVarChar, 10),
new SqlParameter("@小包装盒号", SqlDbType.NVarChar, 25),
new SqlParameter("@中包装盒号", SqlDbType.NVarChar, 25),
new SqlParameter("@大包装盒号", SqlDbType.NVarChar, 25),
new SqlParameter("@包装_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Tc_c", SqlDbType.Float, 8),
new SqlParameter("@LDλc", SqlDbType.NVarChar, 6),
new SqlParameter("@Pf_c", SqlDbType.Float, 8),
new SqlParameter("@Ith_c", SqlDbType.Float, 8),
new SqlParameter("@If_c", SqlDbType.Float, 8),
new SqlParameter("@Vf_c", SqlDbType.Float, 8),
new SqlParameter("@Imo_c", SqlDbType.Int, 4),
new SqlParameter("@Es_c", SqlDbType.Float, 8),
new SqlParameter("@Rs_c", SqlDbType.Float, 8),
new SqlParameter("@Kink_c", SqlDbType.Int, 4),
new SqlParameter("@Liv_判定", SqlDbType.NVarChar, 6),
new SqlParameter("@Liv_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Liv_time", SqlDbType.DateTime),
new SqlParameter("@Cw_c", SqlDbType.Float, 8),
new SqlParameter("@Sp_c", SqlDbType.Float, 8),
new SqlParameter("@Smsr_c", SqlDbType.Float, 8),
new SqlParameter("@GP_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Gp_判定", SqlDbType.NVarChar, 6),
new SqlParameter("@Gp_time", SqlDbType.DateTime),
new SqlParameter("@Sen_c", SqlDbType.Float, 8),
new SqlParameter("@G_c", SqlDbType.Float, 8),
new SqlParameter("@Vbr_c", SqlDbType.Float, 8),
new SqlParameter("@Iop_c", SqlDbType.Float, 8),
new SqlParameter("@Io_c", SqlDbType.Float, 8),
new SqlParameter("@Id_c", SqlDbType.Int, 4),
new SqlParameter("@Icc_c", SqlDbType.Float, 8),
new SqlParameter("@PTλc", SqlDbType.NVarChar, 8),
new SqlParameter("@Pt_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Pt_判定", SqlDbType.NVarChar, 6),
new SqlParameter("@Sen_time", SqlDbType.DateTime),
new SqlParameter("@Pf_d", SqlDbType.Float, 8)
};
parameters[0].Value = model.序列号;
parameters[1].Value = model.型号;
parameters[2].Value = model.随工单;
parameters[3].Value = model.备货单;
parameters[4].Value = model.成品编码;
parameters[5].Value = model.客户;
parameters[6].Value = model.小包装盒号;
parameters[7].Value = model.中包装盒号;
parameters[8].Value = model.大包装盒号;
parameters[9].Value = model.包装_op;
parameters[10].Value = model.Tc_c;
parameters[11].Value = model.LDλc;
parameters[12].Value = model.Pf_c;
parameters[13].Value = model.Ith_c;
parameters[14].Value = model.If_c;
parameters[15].Value = model.Vf_c;
parameters[16].Value = model.Imo_c;
parameters[17].Value = model.Es_c;
parameters[18].Value = model.Rs_c;
parameters[19].Value = model.Kink_c;
parameters[20].Value = model.Liv_判定;
parameters[21].Value = model.Liv_op;
parameters[22].Value = model.Liv_time;
parameters[23].Value = model.Cw_c;
parameters[24].Value = model.Sp_c;
parameters[25].Value = model.Smsr_c;
parameters[26].Value = model.GP_op;
parameters[27].Value = model.Gp_判定;
parameters[28].Value = model.Gp_time;
parameters[29].Value = model.Sen_c;
parameters[30].Value = model.G_c;
parameters[31].Value = model.Vbr_c;
parameters[32].Value = model.Iop_c;
parameters[33].Value = model.Io_c;
parameters[34].Value = model.Id_c;
parameters[35].Value = model.Icc_c;
parameters[36].Value = model.PTλc;
parameters[37].Value = model.Pt_op;
parameters[38].Value = model.Pt_判定;
parameters[39].Value = model.Sen_time;
parameters[40].Value = model.Pf_d;
int rows = dbhelper1.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.tsuhan_test_c DataRowToModel(DataRow row)
{
Maticsoft.Model.tsuhan_test_c model = new Maticsoft.Model.tsuhan_test_c();
if (row != null)
{
if (row["序列号"] != null)
{
model.序列号 = row["序列号"].ToString();
}
if (row["型号"] != null)
{
model.型号 = row["型号"].ToString();
}
if (row["随工单"] != null)
{
model.随工单 = row["随工单"].ToString();
}
if (row["备货单"] != null)
{
model.备货单 = row["备货单"].ToString();
}
if (row["成品编码"] != null)
{
model.成品编码 = row["成品编码"].ToString();
}
if (row["客户"] != null)
{
model.客户 = row["客户"].ToString();
}
if (row["小包装盒号"] != null)
{
model.小包装盒号 = row["小包装盒号"].ToString();
}
if (row["中包装盒号"] != null)
{
model.中包装盒号 = row["中包装盒号"].ToString();
}
if (row["大包装盒号"] != null)
{
model.大包装盒号 = row["大包装盒号"].ToString();
}
if (row["包装_op"] != null)
{
model.包装_op = row["包装_op"].ToString();
}
if (row["Tc_c"] != null && row["Tc_c"].ToString() != "")
{
model.Tc_c = decimal.Parse(row["Tc_c"].ToString());
}
if (row["LDλc"] != null)
{
model.LDλc = row["LDλc"].ToString();
}
if (row["Pf_c"] != null && row["Pf_c"].ToString() != "")
{
model.Pf_c = decimal.Parse(row["Pf_c"].ToString());
}
if (row["Ith_c"] != null && row["Ith_c"].ToString() != "")
{
model.Ith_c = decimal.Parse(row["Ith_c"].ToString());
}
if (row["If_c"] != null && row["If_c"].ToString() != "")
{
model.If_c = decimal.Parse(row["If_c"].ToString());
}
if (row["Vf_c"] != null && row["Vf_c"].ToString() != "")
{
model.Vf_c = decimal.Parse(row["Vf_c"].ToString());
}
if (row["Imo_c"] != null && row["Imo_c"].ToString() != "")
{
model.Imo_c = int.Parse(row["Imo_c"].ToString());
}
if (row["Es_c"] != null && row["Es_c"].ToString() != "")
{
model.Es_c = decimal.Parse(row["Es_c"].ToString());
}
if (row["Rs_c"] != null && row["Rs_c"].ToString() != "")
{
model.Rs_c = decimal.Parse(row["Rs_c"].ToString());
}
if (row["Kink_c"] != null && row["Kink_c"].ToString() != "")
{
model.Kink_c = int.Parse(row["Kink_c"].ToString());
}
if (row["Liv_判定"] != null)
{
model.Liv_判定 = row["Liv_判定"].ToString();
}
if (row["Liv_op"] != null)
{
model.Liv_op = row["Liv_op"].ToString();
}
if (row["Liv_time"] != null && row["Liv_time"].ToString() != "")
{
model.Liv_time = DateTime.Parse(row["Liv_time"].ToString());
}
if (row["Cw_c"] != null && row["Cw_c"].ToString() != "")
{
model.Cw_c = decimal.Parse(row["Cw_c"].ToString());
}
if (row["Sp_c"] != null && row["Sp_c"].ToString() != "")
{
model.Sp_c = decimal.Parse(row["Sp_c"].ToString());
}
if (row["Smsr_c"] != null && row["Smsr_c"].ToString() != "")
{
model.Smsr_c = decimal.Parse(row["Smsr_c"].ToString());
}
if (row["GP_op"] != null)
{
model.GP_op = row["GP_op"].ToString();
}
if (row["Gp_判定"] != null)
{
model.Gp_判定 = row["Gp_判定"].ToString();
}
if (row["Gp_time"] != null && row["Gp_time"].ToString() != "")
{
model.Gp_time = DateTime.Parse(row["Gp_time"].ToString());
}
if (row["Sen_c"] != null && row["Sen_c"].ToString() != "")
{
model.Sen_c = decimal.Parse(row["Sen_c"].ToString());
}
if (row["G_c"] != null && row["G_c"].ToString() != "")
{
model.G_c = decimal.Parse(row["G_c"].ToString());
}
if (row["Vbr_c"] != null && row["Vbr_c"].ToString() != "")
{
model.Vbr_c = decimal.Parse(row["Vbr_c"].ToString());
}
if (row["Iop_c"] != null && row["Iop_c"].ToString() != "")
{
model.Iop_c = decimal.Parse(row["Iop_c"].ToString());
}
if (row["Io_c"] != null && row["Io_c"].ToString() != "")
{
model.Io_c = decimal.Parse(row["Io_c"].ToString());
}
if (row["Id_c"] != null && row["Id_c"].ToString() != "")
{
model.Id_c = int.Parse(row["Id_c"].ToString());
}
if (row["Icc_c"] != null && row["Icc_c"].ToString() != "")
{
model.Icc_c = decimal.Parse(row["Icc_c"].ToString());
}
if (row["PTλc"] != null)
{
model.PTλc = row["PTλc"].ToString();
}
if (row["Pt_op"] != null)
{
model.Pt_op = row["Pt_op"].ToString();
}
if (row["Pt_判定"] != null)
{
model.Pt_判定 = row["Pt_判定"].ToString();
}
if (row["Sen_time"] != null && row["Sen_time"].ToString() != "")
{
model.Sen_time = DateTime.Parse(row["Sen_time"].ToString());
}
if (row["Pf_d"] != null && row["Pf_d"].ToString() != "")
{
model.Pf_d = decimal.Parse(row["Pf_d"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.tsuhan_test_c model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tsuhan_test_c set ");
strSql.Append("型号=@型号,");
strSql.Append("随工单=@随工单,");
strSql.Append("备货单=@备货单,");
strSql.Append("成品编码=@成品编码,");
strSql.Append("客户=@客户,");
strSql.Append("小包装盒号=@小包装盒号,");
strSql.Append("中包装盒号=@中包装盒号,");
strSql.Append("大包装盒号=@大包装盒号,");
strSql.Append("包装_op=@包装_op,");
strSql.Append("Tc_c=@Tc_c,");
strSql.Append("LDλc=@LDλc,");
strSql.Append("Pf_c=@Pf_c,");
strSql.Append("Ith_c=@Ith_c,");
strSql.Append("If_c=@If_c,");
strSql.Append("Vf_c=@Vf_c,");
strSql.Append("Imo_c=@Imo_c,");
strSql.Append("Es_c=@Es_c,");
strSql.Append("Rs_c=@Rs_c,");
strSql.Append("Kink_c=@Kink_c,");
strSql.Append("Liv_判定=@Liv_判定,");
strSql.Append("Liv_op=@Liv_op,");
strSql.Append("Liv_time=@Liv_time,");
strSql.Append("Cw_c=@Cw_c,");
strSql.Append("Sp_c=@Sp_c,");
strSql.Append("Smsr_c=@Smsr_c,");
strSql.Append("GP_op=@GP_op,");
strSql.Append("Gp_判定=@Gp_判定,");
strSql.Append("Gp_time=@Gp_time,");
strSql.Append("Sen_c=@Sen_c,");
strSql.Append("G_c=@G_c,");
strSql.Append("Vbr_c=@Vbr_c,");
strSql.Append("Iop_c=@Iop_c,");
strSql.Append("Io_c=@Io_c,");
strSql.Append("Id_c=@Id_c,");
strSql.Append("Icc_c=@Icc_c,");
strSql.Append("PTλc=@PTλc,");
strSql.Append("Pt_op=@Pt_op,");
strSql.Append("Pt_判定=@Pt_判定,");
strSql.Append("Sen_time=@Sen_time,");
strSql.Append("Pf_d=@Pf_d");
strSql.Append(" where 序列号=@序列号 ");
SqlParameter[] parameters =
{
new SqlParameter("@型号", SqlDbType.NVarChar, 25),
new SqlParameter("@随工单", SqlDbType.NVarChar, 25),
new SqlParameter("@备货单", SqlDbType.NVarChar, 25),
new SqlParameter("@成品编码", SqlDbType.NVarChar, 25),
new SqlParameter("@客户", SqlDbType.NVarChar, 10),
new SqlParameter("@小包装盒号", SqlDbType.NVarChar, 25),
new SqlParameter("@中包装盒号", SqlDbType.NVarChar, 25),
new SqlParameter("@大包装盒号", SqlDbType.NVarChar, 25),
new SqlParameter("@包装_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Tc_c", SqlDbType.Float, 8),
new SqlParameter("@LDλc", SqlDbType.NVarChar, 6),
new SqlParameter("@Pf_c", SqlDbType.Float, 8),
new SqlParameter("@Ith_c", SqlDbType.Float, 8),
new SqlParameter("@If_c", SqlDbType.Float, 8),
new SqlParameter("@Vf_c", SqlDbType.Float, 8),
new SqlParameter("@Imo_c", SqlDbType.Int, 4),
new SqlParameter("@Es_c", SqlDbType.Float, 8),
new SqlParameter("@Rs_c", SqlDbType.Float, 8),
new SqlParameter("@Kink_c", SqlDbType.Int, 4),
new SqlParameter("@Liv_判定", SqlDbType.NVarChar, 6),
new SqlParameter("@Liv_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Liv_time", SqlDbType.DateTime),
new SqlParameter("@Cw_c", SqlDbType.Float, 8),
new SqlParameter("@Sp_c", SqlDbType.Float, 8),
new SqlParameter("@Smsr_c", SqlDbType.Float, 8),
new SqlParameter("@GP_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Gp_判定", SqlDbType.NVarChar, 6),
new SqlParameter("@Gp_time", SqlDbType.DateTime),
new SqlParameter("@Sen_c", SqlDbType.Float, 8),
new SqlParameter("@G_c", SqlDbType.Float, 8),
new SqlParameter("@Vbr_c", SqlDbType.Float, 8),
new SqlParameter("@Iop_c", SqlDbType.Float, 8),
new SqlParameter("@Io_c", SqlDbType.Float, 8),
new SqlParameter("@Id_c", SqlDbType.Int, 4),
new SqlParameter("@Icc_c", SqlDbType.Float, 8),
new SqlParameter("@PTλc", SqlDbType.NVarChar, 8),
new SqlParameter("@Pt_op", SqlDbType.NVarChar, 8),
new SqlParameter("@Pt_判定", SqlDbType.NVarChar, 6),
new SqlParameter("@Sen_time", SqlDbType.DateTime),
new SqlParameter("@Pf_d", SqlDbType.Float, 8),
new SqlParameter("@序列号", SqlDbType.NVarChar, 25)
};
parameters[0].Value = model.型号;
parameters[1].Value = model.随工单;
parameters[2].Value = model.备货单;
parameters[3].Value = model.成品编码;
parameters[4].Value = model.客户;
parameters[5].Value = model.小包装盒号;
parameters[6].Value = model.中包装盒号;
parameters[7].Value = model.大包装盒号;
parameters[8].Value = model.包装_op;
parameters[9].Value = model.Tc_c;
parameters[10].Value = model.LDλc;
parameters[11].Value = model.Pf_c;
parameters[12].Value = model.Ith_c;
parameters[13].Value = model.If_c;
parameters[14].Value = model.Vf_c;
parameters[15].Value = model.Imo_c;
parameters[16].Value = model.Es_c;
parameters[17].Value = model.Rs_c;
parameters[18].Value = model.Kink_c;
parameters[19].Value = model.Liv_判定;
parameters[20].Value = model.Liv_op;
parameters[21].Value = model.Liv_time;
parameters[22].Value = model.Cw_c;
parameters[23].Value = model.Sp_c;
parameters[24].Value = model.Smsr_c;
parameters[25].Value = model.GP_op;
parameters[26].Value = model.Gp_判定;
parameters[27].Value = model.Gp_time;
parameters[28].Value = model.Sen_c;
parameters[29].Value = model.G_c;
parameters[30].Value = model.Vbr_c;
parameters[31].Value = model.Iop_c;
parameters[32].Value = model.Io_c;
parameters[33].Value = model.Id_c;
parameters[34].Value = model.Icc_c;
parameters[35].Value = model.PTλc;
parameters[36].Value = model.Pt_op;
parameters[37].Value = model.Pt_判定;
parameters[38].Value = model.Sen_time;
parameters[39].Value = model.Pf_d;
parameters[40].Value = model.序列号;
int rows = dbhelper1.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
