public static NodeChiTiet getFromReader(IDataReader rd) { NodeChiTiet Item = new NodeChiTiet(); if (rd.FieldExists("NCT_ID")) { Item.ID = (Int32)(rd["NCT_ID"]); } if (rd.FieldExists("NCT_VBNODE_ID")) { Item.VBNODE_ID = (Int32)(rd["NCT_VBNODE_ID"]); } if (rd.FieldExists("NCT_CID")) { Item.CID = (Guid)(rd["NCT_CID"]); } if (rd.FieldExists("NCT_Chinh")) { Item.Chinh = (Boolean)(rd["NCT_Chinh"]); } if (rd.FieldExists("NCT_NoiDung")) { Item.NoiDung = (String)(rd["NCT_NoiDung"]); } if (rd.FieldExists("NCT_NgayTao")) { Item.NgayTao = (DateTime)(rd["NCT_NgayTao"]); } if (rd.FieldExists("NCT_NgayCapNhat")) { Item.NgayCapNhat = (DateTime)(rd["NCT_NgayCapNhat"]); } if (rd.FieldExists("NCT_NguoiTao")) { Item.NguoiTao = (String)(rd["NCT_NguoiTao"]); } if (rd.FieldExists("NCT_RowId")) { Item.RowId = (Guid)(rd["NCT_RowId"]); } if (rd.FieldExists("NCT_NgayGiaoViec")) { Item.NgayGiaoviec = (DateTime)(rd["NCT_NgayGiaoViec"]); } if (rd.FieldExists("NCT_NgayHoanThanh")) { Item.NgayHoanThanh = (DateTime)(rd["NCT_NgayHoanThanh"]); } if (rd.FieldExists("NCT_MucDo")) { Item.MucDo = (Boolean)(rd["NCT_MucDo"]); } if (rd.FieldExists("NCT_GhiChu")) { Item.GhiChu = (String)(rd["NCT_GhiChu"]); } return(Item); }
public static NodeChiTiet SelectById(Int32 NCT_ID) { NodeChiTiet Item = new NodeChiTiet(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("NCT_ID", NCT_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblNodeChiTiet_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static NodeChiTiet SelectByNodeIDUsername(Int32 VBNODE_ID, string Username) { NodeChiTiet Item = new NodeChiTiet(); SqlParameter[] obj = new SqlParameter[2]; obj[0] = new SqlParameter("VBNODE_ID", VBNODE_ID); obj[1] = new SqlParameter("Username", Username); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblNodeChiTiet_Select_SelectByNodeIDUsername_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static NodeChiTiet SelectByVBNode_IDWidthCID(Int32 VBNODE_ID, string Cid) { NodeChiTiet Item = new NodeChiTiet(); SqlParameter[] obj = new SqlParameter[2]; obj[0] = new SqlParameter("VBNODE_ID", VBNODE_ID); obj[1] = new SqlParameter("Cid", Cid); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblNodeChiTiet_Select_SelectByVBNodeIDWithCid_hungpm", obj)) { while (rd.Read()) { Item = getFromReader(rd); if (rd.FieldExists("NCT_GiaoViec")) { Item.GiaoViec = (String)rd["NCT_GiaoViec"]; } } } return(Item); }
public static NodeChiTiet Insert(NodeChiTiet Inserted) { NodeChiTiet Item = new NodeChiTiet(); SqlParameter[] obj = new SqlParameter[8]; obj[0] = new SqlParameter("NCT_VBNODE_ID", Inserted.VBNODE_ID); obj[1] = new SqlParameter("NCT_CID", Inserted.CID); obj[2] = new SqlParameter("NCT_Chinh", Inserted.Chinh); obj[3] = new SqlParameter("NCT_NoiDung", Inserted.NoiDung); obj[4] = new SqlParameter("NCT_NgayTao", Inserted.NgayTao); obj[5] = new SqlParameter("NCT_NgayCapNhat", Inserted.NgayCapNhat); obj[6] = new SqlParameter("NCT_NguoiTao", Inserted.NguoiTao); obj[7] = new SqlParameter("NCT_RowId", Inserted.RowId); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblNodeChiTiet_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }