public static bool Update(Model.MdcDatUPH model_UPH) { string strSql = string.Format(@"update MdcDatUPH set UPH='{0}',note='{1}',BoradCnt='{2}',Updator='{3}',UpdateTime=getdate() where Fguid='{4}' ", model_UPH.UPH, model_UPH.note, model_UPH.BoradCnt, PubUtils.uContext.UserName, model_UPH.Fguid); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }
public static bool Insert(Model.MdcDatUPH model_UPH) { string strSql = string.Format(@"insert into MdcDatUPH(Fguid,ProductName,Line,BoardType,LaneNo,note,UPH,Creator,CreateTime,BoradCnt) values(newid(),'{0}','{1}','{2}','{3}','{4}','{5}','{6}',getdate(),'{7}')", model_UPH.ProductName, model_UPH.Line, model_UPH.BoardType, model_UPH.LaneNo, model_UPH.note, model_UPH.UPH, model_UPH.Creator, model_UPH.BoradCnt); return(NMS.ExecTransql(PubUtils.uContext, strSql)); }