public Ob_Material(Ob_Material ob) { this.m_MaTH = ob.MaTH; this.m_TenTH = ob.TenTH; this.m_TenSP = ob.TenSP; this.m_GiaSP = ob.GiaSP; this.m_TTSP = ob.TTSP; this.m_DVTSP = ob.DVTSP; this.m_NguoiDK = ob.NguoiDK; this.m_NgayDK = ob.NgayDK; this.m_GhiChu = ob.GhiChu; }
public static int Delete(Ob_Material ob) { SqlParameter sqlPar; SqlCommand comm = new SqlCommand(); comm.CommandText = "DELETE FROM HRM_NhanThan WHERE(Ma = @K_Ma)"; sqlPar = new SqlParameter(); sqlPar.ParameterName = "K_Ma"; sqlPar.SqlDbType = System.Data.SqlDbType.Float; sqlPar.Size = 0; sqlPar.Value = ob.Ma; comm.Parameters.Add(sqlPar); return(DBStaticHRM.SqlExcuteNonQuery(comm)); }
public static int Insert(Ob_Material ob, SqlCommand comm) { //Ma, Ten, QuanHe, CMND, NgaySinh, DiaChi, DienThoai, NgheNgiep, GhiChu, PhuThuoc, NguoiDK, NgayDK, TTChung SqlParameter sqlPar; comm = new SqlCommand(); comm.CommandText = " INSERT INTO HRM_NhanThan (Ma, Ten, MaNV, QuanHe, CMND, NgaySinh, DiaChi, DienThoai, NgheNgiep, GhiChu, PhuThuoc, NguoiDK, NgayDK, TTChung) VALUES(@Ma, @Ten, @MaNV, @QuanHe, @CMND, @NgaySinh, @DiaChi, @DienThoai, @NgheNgiep, @GhiChu, @PhuThuoc, @NguoiDK, @NgayDK, @TTChung)"; sqlPar = new SqlParameter(); sqlPar.ParameterName = "Ma"; sqlPar.SqlDbType = System.Data.SqlDbType.Int; sqlPar.Size = 0; sqlPar.Value = ob.Ma; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "Ten"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 50; sqlPar.Value = ob.Ten; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "MaNV"; sqlPar.SqlDbType = System.Data.SqlDbType.Int; sqlPar.Size = 0; sqlPar.Value = ob.MaNV; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "QuanHe"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 50; sqlPar.Value = ob.QuanHe; comm.Parameters.Add(sqlPar); //Ma, Ten, QuanHe, CMND, NgaySinh, DiaChi, DienThoai, NgheNgiep, GhiChu, PhuThuoc, NguoiDK, NgayDK, TTChung sqlPar = new SqlParameter(); sqlPar.ParameterName = "CMND"; sqlPar.SqlDbType = System.Data.SqlDbType.VarChar; sqlPar.Size = 50; sqlPar.Value = ob.CMND; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NgaySinh"; sqlPar.SqlDbType = System.Data.SqlDbType.DateTime; sqlPar.Size = 0; sqlPar.Value = ob.NgaySinh; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "DiaChi"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 100; sqlPar.Value = ob.DiaChi; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "DienThoai"; sqlPar.SqlDbType = System.Data.SqlDbType.VarChar; sqlPar.Size = 50; sqlPar.Value = ob.DienThoai; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NgheNgiep"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 100; sqlPar.Value = ob.NgheNgiep; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "GhiChu"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 200; sqlPar.Value = ob.GhiChu; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "PhuThuoc"; sqlPar.SqlDbType = System.Data.SqlDbType.Bit; sqlPar.Size = 0; sqlPar.Value = ob.PhuThuoc; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NguoiDK"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 50; sqlPar.Value = ob.NguoiDK; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NgayDK"; sqlPar.SqlDbType = System.Data.SqlDbType.VarChar; sqlPar.Size = 50; sqlPar.Value = ob.NgayDK; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "TTChung"; sqlPar.SqlDbType = System.Data.SqlDbType.Image; sqlPar.Size = 0; int st1 = -1; if (null != ob.TTChung) { try { //trueyn Kieu Image cho SqlParameter System.Runtime.Serialization.Formatters.Binary.BinaryFormatter bf = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); MemoryStream stream = new MemoryStream(); bf.Serialize(stream, ob.TTChung); sqlPar.Size = (int)stream.Length; sqlPar.Value = stream.ToArray(); st1 = 0; } catch { st1 = -1; } } if (st1 == -1) { sqlPar.Size = 1; sqlPar.Value = new byte[] { 1 }; } comm.Parameters.Add(sqlPar); return(DBStaticHRM.SqlExcuteNonQuery(comm)); }
public static int Update(Ob_Material ob, SqlCommand comm) { SqlParameter sqlPar; comm.Parameters.Clear(); //SqlCommand comm = new SqlCommand(); comm.CommandText = " UPDATE HRM_NhanThan SET Ten =@Ten, MaNV = @MaNV, QuanHe =@QuanHe, CMND =@CMND, NgaySinh =@NgaySinh, DiaChi =@DiaChi, DienThoai =@DienThoai, NgheNgiep =@NgheNgiep, GhiChu =@GhiChu, PhuThuoc =@PhuThuoc, NguoiDK =@NguoiDK, NgayDK =@NgayDK, TTChung = @TTChung WHERE ( Ma = @K_Ma)"; sqlPar = new SqlParameter(); sqlPar.ParameterName = "Ten"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 50; sqlPar.Value = ob.Ten; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "MaNV"; sqlPar.SqlDbType = System.Data.SqlDbType.Int; sqlPar.Size = 0; sqlPar.Value = ob.MaNV; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "QuanHe"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 50; sqlPar.Value = ob.QuanHe; comm.Parameters.Add(sqlPar); //Ma, Ten, QuanHe, CMND, NgaySinh, DiaChi, DienThoai, NgheNgiep, GhiChu, PhuThuoc, NguoiDK, NgayDK, TTChung sqlPar = new SqlParameter(); sqlPar.ParameterName = "CMND"; sqlPar.SqlDbType = System.Data.SqlDbType.VarChar; sqlPar.Size = 50; sqlPar.Value = ob.CMND; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NgaySinh"; sqlPar.SqlDbType = System.Data.SqlDbType.DateTime; sqlPar.Size = 0; sqlPar.Value = ob.NgaySinh; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "DiaChi"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 100; sqlPar.Value = ob.DiaChi; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "DienThoai"; sqlPar.SqlDbType = System.Data.SqlDbType.VarChar; sqlPar.Size = 50; sqlPar.Value = ob.DienThoai; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NgheNgiep"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 100; sqlPar.Value = ob.NgheNgiep; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "GhiChu"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 200; sqlPar.Value = ob.GhiChu; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "PhuThuoc"; sqlPar.SqlDbType = System.Data.SqlDbType.Bit; sqlPar.Size = 0; sqlPar.Value = ob.PhuThuoc; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NguoiDK"; sqlPar.SqlDbType = System.Data.SqlDbType.NVarChar; sqlPar.Size = 50; sqlPar.Value = ob.NguoiDK; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "NgayDK"; sqlPar.SqlDbType = System.Data.SqlDbType.VarChar; sqlPar.Size = 50; sqlPar.Value = ob.NgayDK; comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "TTChung"; sqlPar.SqlDbType = System.Data.SqlDbType.Image; sqlPar.Size = 0; int st1 = -1; if (null != ob.TTChung) { try { System.Runtime.Serialization.Formatters.Binary.BinaryFormatter bf = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); MemoryStream stream = new MemoryStream(); bf.Serialize(stream, ob.TTChung); sqlPar.Size = (int)stream.Length; sqlPar.Value = stream.ToArray(); st1 = 0; } catch { try { System.Runtime.Serialization.Formatters.Binary.BinaryFormatter bf = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); MemoryStream stream = new MemoryStream(); bf.Serialize(stream, ob.TTChung); sqlPar.Size = (int)stream.Length; sqlPar.Value = stream.ToArray(); st1 = 0; } catch { st1 = -1; } } } if (st1 == -1) { sqlPar.Size = 1; sqlPar.Value = new byte[] { 1 }; } comm.Parameters.Add(sqlPar); sqlPar = new SqlParameter(); sqlPar.ParameterName = "K_Ma"; sqlPar.SqlDbType = System.Data.SqlDbType.Float; sqlPar.Value = ob.Ma; comm.Parameters.Add(sqlPar); return(DBStaticHRM.SqlExcuteNonQuery(comm)); }
public static List <Ob_Material> GetListOb(int manv) { //Ma, Ten, QuanHe, CMND, NgaySinh, DiaChi, DienThoai, NgheNgiep, GhiChu, PhuThuoc, NguoiDK, NgayDK, TTChung List <Ob_Material> listOb = new List <Ob_Material>(); SqlCommand comm = new SqlCommand(); comm.CommandText = "SELECT * FROM HRM_NhanThan WHERE MaNV = @MaNV"; SqlParameter sqlPar; sqlPar = new SqlParameter(); sqlPar.ParameterName = "MaNV"; sqlPar.SqlDbType = System.Data.SqlDbType.Int; sqlPar.Size = 0; sqlPar.Value = manv; comm.Parameters.Add(sqlPar); SqlDataReader data; data = DBStaticHRM.SqlExcuteQuery(comm); if (null == data) { return(null); } while (data.Read()) { Ob_Material ob = new Ob_Material(); if (!data.IsDBNull(0)) { ob.Ma = data.GetInt32(0); } if (!data.IsDBNull(1)) { ob.Ten = data.GetString(1); } if (!data.IsDBNull(2)) { ob.MaNV = data.GetInt32(2); } if (!data.IsDBNull(3)) { ob.QuanHe = data.GetString(3); } if (!data.IsDBNull(4)) { ob.CMND = data.GetString(4); } if (!data.IsDBNull(5)) { ob.NgaySinh = data.GetDateTime(5); } if (!data.IsDBNull(6)) { ob.DiaChi = data.GetString(6); } if (!data.IsDBNull(7)) { ob.DienThoai = data.GetString(7); } if (!data.IsDBNull(8)) { ob.NgheNgiep = data.GetString(8); } if (!data.IsDBNull(9)) { ob.GhiChu = data.GetString(9); } if (!data.IsDBNull(10)) { ob.PhuThuoc = data.GetBoolean(10); } if (!data.IsDBNull(11)) { ob.NguoiDK = data.GetString(11); } if (!data.IsDBNull(12)) { ob.NgayDK = data.GetString(12); } ; if (!data.IsDBNull(13)) { byte[] blob = (byte[])data.GetValue(13); if (blob.Length > 1) { try { System.Runtime.Serialization.Formatters.Binary.BinaryFormatter bf = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); MemoryStream stream = new MemoryStream(blob); ob.TTChung = (Cls_TTHRM_NhanThan)bf.Deserialize(stream); } catch { } } } listOb.Add(ob); } data.Close(); return(listOb); }