/// <summary>
/// 修改
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool Update(T_Bllb_ProductPrintInfo_tbpp obj)
{
string sqlcmd = string.Format(@"UPDATE T_Bllb_ProductPrintInfo_tbpp SET Print1 = '{0}', Print2 = '{1}', Print3 = '{2}', Print4 = '{3}', Print5 = '{4}',TankPack='{6}', PackLabel='{7}', ProductLabel='{8}',
SmallInPack='{9}',ProductSN='{10}' WHERE ProductCode = '{5}'", obj.Print1, obj.Print2, obj.Print3, obj.Print4, obj.Print5, obj.ProductCode, obj.TankPack, obj.PackLabel, obj.ProductLabel, obj.SmallInPack, obj.ProductSN);
return(NMS.ExecTransql(PubUtils.uContext, sqlcmd));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool Insert(T_Bllb_ProductPrintInfo_tbpp obj)
{
string sqlcmd = string.Format(@"INSERT INTO T_Bllb_ProductPrintInfo_tbpp
( ProductCode ,
ProductSN ,
Print1 ,
Print2 ,
Print3 ,
Print4 ,
Print5 ,
Creator ,
CreateTime,
PackLabel,
ProductLabel,
TankPack,
SmallInPack
)
VALUES ( '{0}' ,
'{1}' ,
'{2}' ,
'{3}' ,
'{4}' ,
'{5}' ,
'{6}' ,
'{7}',
GETDATE(),
'{8}',
'{9}',
'{10}',
'{11}'
)", obj.ProductCode, obj.ProductSN, obj.Print1, obj.Print2, obj.Print3, obj.Print4, obj.Print5, PubUtils.uContext.UserID, obj.PackLabel, obj.ProductLabel, obj.TankPack, obj.SmallInPack);
return(NMS.ExecTransql(PubUtils.uContext, sqlcmd));
}
