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);
}
