public static VanbanNode Insert(VanbanNode Inserted) { VanbanNode Item = new VanbanNode(); SqlParameter[] obj = new SqlParameter[13]; obj[0] = new SqlParameter("VBNODE_VB_ID", Inserted.VB_ID); obj[1] = new SqlParameter("VBNODE_NODE_ID", Inserted.NODE_ID); obj[2] = new SqlParameter("VBNODE_Active", Inserted.Active); obj[3] = new SqlParameter("VBNODE_KetThuc", Inserted.KetThuc); obj[4] = new SqlParameter("VBNODE_BatDau", Inserted.BatDau); obj[5] = new SqlParameter("VBNODE_NguoiTao", Inserted.NguoiTao); obj[6] = new SqlParameter("VBNODE_NgayTao", Inserted.NgayTao); obj[7] = new SqlParameter("VBNODE_NgayCapNhat", Inserted.NgayCapNhat); obj[8] = new SqlParameter("VBNODE_RowId", Inserted.RowId); obj[9] = new SqlParameter("VBNODE_ThongBao", Inserted.ThongBao); obj[10] = new SqlParameter("VBNODE_ThuTu", Inserted.ThuTu); obj[11] = new SqlParameter("VBNODE_Doc", Inserted.Doc); obj[12] = new SqlParameter("VBNODE_XuLy", Inserted.XuLy); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanbanNode_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static VanbanNode SelectById(Int32 VBNODE_ID) { VanbanNode Item = new VanbanNode(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("VBNODE_ID", VBNODE_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanbanNode_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static Nodes SelectByVanBan(Int32 VB_ID) { Nodes Item = new Nodes(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("VB_ID", VB_ID); VanbanNode item = new VanbanNode(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblNodes_Select_SelectByVanBan_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); item = VanbanNodeDal.getFromReader(rd); } } Item.vanBanNode = item; return(Item); }
public static VanbanNode getFromReader(IDataReader rd) { VanbanNode Item = new VanbanNode(); Item.ID = (Int32)(rd["VBNODE_ID"]); Item.VB_ID = (Int32)(rd["VBNODE_VB_ID"]); Item.NODE_ID = (Int32)(rd["VBNODE_NODE_ID"]); Item.Active = (Boolean)(rd["VBNODE_Active"]); Item.KetThuc = (Boolean)(rd["VBNODE_KetThuc"]); Item.BatDau = (Boolean)(rd["VBNODE_BatDau"]); Item.NguoiTao = (String)(rd["VBNODE_NguoiTao"]); Item.NgayTao = (DateTime)(rd["VBNODE_NgayTao"]); Item.NgayCapNhat = (DateTime)(rd["VBNODE_NgayCapNhat"]); Item.RowId = (Guid)(rd["VBNODE_RowId"]); Item.ThongBao = (Boolean)(rd["VBNODE_ThongBao"]); Item.ThuTu = (Int32)(rd["VBNODE_ThuTu"]); Item.Doc = (Boolean)(rd["VBNODE_Doc"]); Item.XuLy = (Boolean)(rd["VBNODE_XuLy"]); return(Item); }