Ejemplo n.º 1
0
        public void EditApprove(Approve ap)
        {
            string sql = string.Format(" update Approve set Title='{0}',BeginDate='{1}',EndDate='{2}',Reason='{3}' where ApproveID='{4}'"
                                       , ap.Title, ap.BeginDate, ap.EndDate, ap.Reason, ap.ApproveID);

            DBhelper.Change(sql);
        }
Ejemplo n.º 2
0
        public void AddApprove(Approve ap)
        {
            //(select ManagerID from Department  where DeptID= (select DeptID from UserInfo where UserName='******'))
            string sql = string.Format("insert into Approve values ((select userid from UserInfo where UserName='******'),'{1}','{2}','{3}','{4}',null,getdate(),null,'0',null,null)"
                                       , ap.ApplyUser, ap.Title, ap.BeginDate, ap.EndDate, ap.Reason);

            DBhelper.Change(sql);
        }