/// <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); } }