/// <summary>
/// 修改tsuhan_sg_gt表信息
/// </summary>
/// <param name="mogt"></param>
/// <returns></returns>
public bool Update(tsuhan_sg_gt mogt)
{
return(gtdal.Update(mogt));
}
/// <summary>
/// 新增tsuhan_sg_gt表信息
/// </summary>
/// <param name="mogt"></param>
/// <returns></returns>
public bool Add(tsuhan_sg_gt mogt)
{
return(gtdal.Add(mogt));
}
/// <summary>
/// 新增tsuhan_sg_gt表信息
/// </summary>
/// <param name="mogt"></param>
/// <returns></returns>
public bool Add(tsuhan_sg_gt model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tsuhan_sg_gt(");
strSql.Append("备货单号,交货日期,下单日期,表格编号,合同编号,规格书编号,产品名称,备货单数量,随工卡数量,产品图号,产品类型,成品编码,BK_A,BK_B,BK_C,LD_LDjj,GX_hjfs,OH_hqPomin,OH_hqPomax,OH_hqBFB,OH_hhPomin,OH_hhPomax,OH_hhBFB,DM_dmzl,PT_rqgl,PT_gdlmin,PT_gdlmax,GDW_xhcs,LD_CSPomin,LD_CSPomax,LD_CSBFB,LD_LDKINK,LD_PDKINK,PT_CStj,PT_CSpl,PT_LMd,PT_LMd2,PT_ICCmin,PT_ICCmax,BZ_QJbq,GD_if,GD_ccglMin,GD_ccglMax,GD_imoMin,GD_imoMax,GD_ithMin,GD_ithMax,GD_vfMin,GD_vfMax,GD_ptsl,GD_vbrMin,GD_vbrMax,JX_wdMin,JX_wdMax,JX_zz,JX_pthigh,JX_ptwwj,JX_ldgj,JX_ptgj,fh产品名称,Description,物料代码,型号属性,Specification,客户型号,LD芯片型号,PT芯片型号,Quantity1,Quantity2,数量,计划编制,技术审核,生产审核,录入员,录入时间,客户代码,生产日期)");
strSql.Append(" values (");
strSql.Append("@备货单号,@交货日期,@下单日期,@表格编号,@合同编号,@规格书编号,@产品名称,@备货单数量,@随工卡数量,@产品图号,@产品类型,@成品编码,@BK_A,@BK_B,@BK_C,@LD_LDjj,@GX_hjfs,@OH_hqPomin,@OH_hqPomax,@OH_hqBFB,@OH_hhPomin,@OH_hhPomax,@OH_hhBFB,@DM_dmzl,@PT_rqgl,@PT_gdlmin,@PT_gdlmax,@GDW_xhcs,@LD_CSPomin,@LD_CSPomax,@LD_CSBFB,@LD_LDKINK,@LD_PDKINK,@PT_CStj,@PT_CSpl,@PT_LMd,@PT_LMd2,@PT_ICCmin,@PT_ICCmax,@BZ_QJbq,@GD_if,@GD_ccglMin,@GD_ccglMax,@GD_imoMin,@GD_imoMax,@GD_ithMin,@GD_ithMax,@GD_vfMin,@GD_vfMax,@GD_ptsl,@GD_vbrMin,@GD_vbrMax,@JX_wdMin,@JX_wdMax,@JX_zz,@JX_pthigh,@JX_ptwwj,@JX_ldgj,@JX_ptgj,@fh产品名称,@Description,@物料代码,@型号属性,@Specification,@客户型号,@LD芯片型号,@PT芯片型号,@Quantity1,@Quantity2,@数量,@计划编制,@技术审核,@生产审核,@录入员,@录入时间,@客户代码,@生产日期)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@备货单号", SqlDbType.NVarChar, 30),
new SqlParameter("@交货日期", SqlDbType.DateTime),
new SqlParameter("@下单日期", SqlDbType.DateTime),
new SqlParameter("@表格编号", SqlDbType.NVarChar, 20),
new SqlParameter("@合同编号", SqlDbType.NVarChar, 40),
new SqlParameter("@规格书编号", SqlDbType.NVarChar, 40),
new SqlParameter("@产品名称", SqlDbType.NVarChar, 50),
new SqlParameter("@备货单数量", SqlDbType.Int, 4),
new SqlParameter("@随工卡数量", SqlDbType.Int, 4),
new SqlParameter("@产品图号", SqlDbType.NVarChar, 20),
new SqlParameter("@产品类型", SqlDbType.NVarChar, 10),
new SqlParameter("@成品编码", SqlDbType.NVarChar, 40),
new SqlParameter("@BK_A", SqlDbType.NVarChar, 40),
new SqlParameter("@BK_B", SqlDbType.NVarChar, 40),
new SqlParameter("@BK_C", SqlDbType.NVarChar, 40),
new SqlParameter("@LD_LDjj", SqlDbType.Float, 8),
new SqlParameter("@GX_hjfs", SqlDbType.NVarChar, 15),
new SqlParameter("@OH_hqPomin", SqlDbType.Float, 8),
new SqlParameter("@OH_hqPomax", SqlDbType.Float, 8),
new SqlParameter("@OH_hqBFB", SqlDbType.Int, 4),
new SqlParameter("@OH_hhPomin", SqlDbType.Float, 8),
new SqlParameter("@OH_hhPomax", SqlDbType.Float, 8),
new SqlParameter("@OH_hhBFB", SqlDbType.Int, 4),
new SqlParameter("@DM_dmzl", SqlDbType.NVarChar, 40),
new SqlParameter("@PT_rqgl", SqlDbType.Int, 4),
new SqlParameter("@PT_gdlmin", SqlDbType.NVarChar, 20),
new SqlParameter("@PT_gdlmax", SqlDbType.NVarChar, 20),
new SqlParameter("@GDW_xhcs", SqlDbType.Int, 4),
new SqlParameter("@LD_CSPomin", SqlDbType.Float, 8),
new SqlParameter("@LD_CSPomax", SqlDbType.Float, 8),
new SqlParameter("@LD_CSBFB", SqlDbType.Int, 4),
new SqlParameter("@LD_LDKINK", SqlDbType.Int, 4),
new SqlParameter("@LD_PDKINK", SqlDbType.Int, 4),
new SqlParameter("@PT_CStj", SqlDbType.NVarChar, 20),
new SqlParameter("@PT_CSpl", SqlDbType.Float, 8),
new SqlParameter("@PT_LMd", SqlDbType.NVarChar, 10),
new SqlParameter("@PT_LMd2", SqlDbType.NVarChar, 10),
new SqlParameter("@PT_ICCmin", SqlDbType.Int, 4),
new SqlParameter("@PT_ICCmax", SqlDbType.Int, 4),
new SqlParameter("@BZ_QJbq", SqlDbType.NVarChar, 20),
new SqlParameter("@GD_if", SqlDbType.NVarChar, 10),
new SqlParameter("@GD_ccglMin", SqlDbType.Float, 8),
new SqlParameter("@GD_ccglMax", SqlDbType.Float, 8),
new SqlParameter("@GD_imoMin", SqlDbType.Int, 4),
new SqlParameter("@GD_imoMax", SqlDbType.Int, 4),
new SqlParameter("@GD_ithMin", SqlDbType.Int, 4),
new SqlParameter("@GD_ithMax", SqlDbType.Int, 4),
new SqlParameter("@GD_vfMin", SqlDbType.Float, 8),
new SqlParameter("@GD_vfMax", SqlDbType.Float, 8),
new SqlParameter("@GD_ptsl", SqlDbType.NVarChar, 10),
new SqlParameter("@GD_vbrMin", SqlDbType.Int, 4),
new SqlParameter("@GD_vbrMax", SqlDbType.Int, 4),
new SqlParameter("@JX_wdMin", SqlDbType.Int, 4),
new SqlParameter("@JX_wdMax", SqlDbType.Int, 4),
new SqlParameter("@JX_zz", SqlDbType.NVarChar, 10),
new SqlParameter("@JX_pthigh", SqlDbType.NVarChar, 20),
new SqlParameter("@JX_ptwwj", SqlDbType.NVarChar, 20),
new SqlParameter("@JX_ldgj", SqlDbType.NVarChar, 2),
new SqlParameter("@JX_ptgj", SqlDbType.NVarChar, 2),
new SqlParameter("@fh产品名称", SqlDbType.NVarChar, 50),
new SqlParameter("@Description", SqlDbType.NVarChar, 50),
new SqlParameter("@物料代码", SqlDbType.NVarChar, 30),
new SqlParameter("@型号属性", SqlDbType.NVarChar, 30),
new SqlParameter("@Specification", SqlDbType.NVarChar, 30),
new SqlParameter("@客户型号", SqlDbType.NVarChar, 50),
new SqlParameter("@LD芯片型号", SqlDbType.NVarChar, 20),
new SqlParameter("@PT芯片型号", SqlDbType.NVarChar, 20),
new SqlParameter("@Quantity1", SqlDbType.NVarChar, 50),
new SqlParameter("@Quantity2", SqlDbType.NVarChar, 50),
new SqlParameter("@数量", SqlDbType.NVarChar, 10),
new SqlParameter("@计划编制", SqlDbType.NVarChar, 10),
new SqlParameter("@技术审核", SqlDbType.NVarChar, 10),
new SqlParameter("@生产审核", SqlDbType.NVarChar, 10),
new SqlParameter("@录入员", SqlDbType.NVarChar, 10),
new SqlParameter("@录入时间", SqlDbType.DateTime),
new SqlParameter("@客户代码", SqlDbType.NVarChar, 10),
new SqlParameter("@生产日期", SqlDbType.DateTime)
};
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.产品图号;
parameters[10].Value = model.产品类型;
parameters[11].Value = model.成品编码;
parameters[12].Value = model.BK_A;
parameters[13].Value = model.BK_B;
parameters[14].Value = model.BK_C;
parameters[15].Value = model.LD_LDjj;
parameters[16].Value = model.GX_hjfs;
parameters[17].Value = model.OH_hqPomin;
parameters[18].Value = model.OH_hqPomax;
parameters[19].Value = model.OH_hqBFB;
parameters[20].Value = model.OH_hhPomin;
parameters[21].Value = model.OH_hhPomax;
parameters[22].Value = model.OH_hhBFB;
parameters[23].Value = model.DM_dmzl;
parameters[24].Value = model.PT_rqgl;
parameters[25].Value = model.PT_gdlmin;
parameters[26].Value = model.PT_gdlmax;
parameters[27].Value = model.GDW_xhcs;
parameters[28].Value = model.LD_CSPomin;
parameters[29].Value = model.LD_CSPomax;
parameters[30].Value = model.LD_CSBFB;
parameters[31].Value = model.LD_LDKINK;
parameters[32].Value = model.LD_PDKINK;
parameters[33].Value = model.PT_CStj;
parameters[34].Value = model.PT_CSpl;
parameters[35].Value = model.PT_LMd;
parameters[36].Value = model.PT_LMd2;
parameters[37].Value = model.PT_ICCmin;
parameters[38].Value = model.PT_ICCmax;
parameters[39].Value = model.BZ_QJbq;
parameters[40].Value = model.GD_if;
parameters[41].Value = model.GD_ccglMin;
parameters[42].Value = model.GD_ccglMax;
parameters[43].Value = model.GD_imoMin;
parameters[44].Value = model.GD_imoMax;
parameters[45].Value = model.GD_ithMin;
parameters[46].Value = model.GD_ithMax;
parameters[47].Value = model.GD_vfMin;
parameters[48].Value = model.GD_vfMax;
parameters[49].Value = model.GD_ptsl;
parameters[50].Value = model.GD_vbrMin;
parameters[51].Value = model.GD_vbrMax;
parameters[52].Value = model.JX_wdMin;
parameters[53].Value = model.JX_wdMax;
parameters[54].Value = model.JX_zz;
parameters[55].Value = model.JX_pthigh;
parameters[56].Value = model.JX_ptwwj;
parameters[57].Value = model.JX_ldgj;
parameters[58].Value = model.JX_ptgj;
parameters[59].Value = model.fh产品名称;
parameters[60].Value = model.Description;
parameters[61].Value = model.物料代码;
parameters[62].Value = model.型号属性;
parameters[63].Value = model.Specification;
parameters[64].Value = model.客户型号;
parameters[65].Value = model.LD芯片型号;
parameters[66].Value = model.PT芯片型号;
parameters[67].Value = model.Quantity1;
parameters[68].Value = model.Quantity2;
parameters[69].Value = model.数量;
parameters[70].Value = model.计划编制;
parameters[71].Value = model.技术审核;
parameters[72].Value = model.生产审核;
parameters[73].Value = model.录入员;
parameters[74].Value = model.录入时间;
parameters[75].Value = model.客户代码;
parameters[76].Value = model.生产日期;
int rows = dbhelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
