/// <summary>
/// 新增
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static bool Insert(MdcdatProduct p)
{
string strSql = string.Format("insert into MdcdatProduct(Fguid,ProductCode,ProductName,Remark,Creator,CreateTime,UPH) values(newid(),'{0}','{1}','{2}','{3}',getdate(),'{4}')",
p.ProductCode, p.ProductName, p.Remark, PubUtils.uContext.UserID, p.UPH);
return(NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public static bool Update(MdcdatProduct p)
{
string strSql = string.Format(@"
UPDATE MdcdatProduct
SET UPH = '{1}' ,
Remark = '{2}' ,
Updator = '{3}' ,
UpdateTime = GETDATE()
WHERE ProductCode = '{0}'", p.ProductCode, p.UPH, p.Remark, PubUtils.uContext.UserID);
return(NMS.ExecTransql(PubUtils.uContext, strSql));
}
