Example #1
0
        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));
        }
Example #2
0
        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));
        }