示例#1
0
        public static int DeleteProfile(HopDongObj qh)
        {
            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@ma", qh.MaHD)
            };

            return(ConectToSQL_Datvd.Execute_NonQuery("XoaHopDong", para));
        }
示例#2
0
        public static int DeleteProfile(HeSoLuong qh)
        {
            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@bac", qh.BacLuong)
            };

            return(ConectToSQL_Datvd.Execute_NonQuery("XoaLuong", para));
        }
示例#3
0
        public static int UpdateProfile(HeSoLuong qh)
        {
            SqlParameter[] para = new SqlParameter[]
            { new SqlParameter("@bac", qh.BacLuong),
              new SqlParameter("@luongcb", qh.LuongCB),
              new SqlParameter("@luongtangca", qh.LuongTangCa) };

            return(ConectToSQL_Datvd.Execute_NonQuery("SuaLuong", para));
        }
示例#4
0
        public static int UpdateProfile(HopDongObj qh)
        {
            SqlParameter[] para = new SqlParameter[]
            { new SqlParameter("@ma", qh.MaHD),
              new SqlParameter("@ten", qh.TenHD),
              new SqlParameter("@loai", qh.LoaiHD),
              new SqlParameter("@ngaybatdau", qh.NgayBatDau),
              new SqlParameter("@ngayketthuc", qh.NgayKetThuc),
              new SqlParameter("@bac", qh.BacLuong) };

            return(ConectToSQL_Datvd.Execute_NonQuery("SuaHopDong", para));
        }
示例#5
0
 public static DataTable GetData()
 {
     try
     {
         DataTable dt  = new DataTable();
         string    sql = " select * from HopDong ";
         conn = ConectToSQL_Datvd.Connect();
         SqlDataAdapter da = new SqlDataAdapter(sql, conn);
         da.Fill(dt);
         conn.Close();
         return(dt);
     }
     catch
     {
         conn.Close();
         return(null);
     }
 }