public static VanBan UpdateVanBan(VanBan Updated) { VanBan Item = new VanBan(); SqlParameter[] obj = new SqlParameter[32]; obj[0] = new SqlParameter("VB_ID", Updated.ID); obj[1] = new SqlParameter("VB_SoDen", Updated.SoDen); obj[2] = new SqlParameter("VB_PhanLoai_ID", Updated.PhanLoai_ID); obj[3] = new SqlParameter("VB_CapGui_ID", Updated.CapGui_ID); obj[4] = new SqlParameter("VB_CapGui_Ten", Updated.CapGui_Ten); obj[5] = new SqlParameter("VB_NgayNhan", Updated.NgayNhan); obj[6] = new SqlParameter("VB_NgayTrenVanBan", Updated.NgayTrenVanBan); obj[7] = new SqlParameter("VB_SoKyHieu", Updated.SoKyHieu); obj[8] = new SqlParameter("VB_LoaiVanBan_ID", Updated.LoaiVanBan_ID); obj[9] = new SqlParameter("VB_LoaiVanBan_Ten", Updated.LoaiVanBan_Ten); obj[10] = new SqlParameter("VB_NoiGui_ID", Updated.NoiGui_ID); obj[11] = new SqlParameter("VB_NoiGui_Ten", Updated.NoiGui_Ten); obj[12] = new SqlParameter("VB_TrichYeu", Updated.TrichYeu); obj[13] = new SqlParameter("VB_NgayCapNhat", Updated.NgayCapNhat); obj[14] = new SqlParameter("VB_PhucDap", Updated.PhucDap); obj[15] = new SqlParameter("VB_PhucDap_ID", Updated.PhucDap_ID); obj[16] = new SqlParameter("VB_Draff", Updated.Draff); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBan_Update_UpdateVanBan_linhnx", obj)) { while (rd.Read()) { Item = getFromReaderDraff(rd); } } return(Item); }
public static VanBan getFromReaderDraff(IDataReader rd) { VanBan Item = new VanBan(); Item.ID = (Int32)(rd["VB_ID"]); Item.SoDen = rd["VB_SoDen"].ToString(); return(Item); }
public static VanBan getFromReaderSearchCongVan(IDataReader rd) { VanBan Item = new VanBan(); Item.ID = (Int32)(rd["VB_ID"]); Item.SoDen = (String)(rd["VB_SoDen"]); Item.SoKyHieu = (String)(rd["VB_SoKyHieu"]); Item.TrichYeu = (String)(rd["VB_TrichYeu"]); return(Item); }
public static VanBan getFromReaderDraff2(IDataReader rd) { VanBan Item = new VanBan(); Item.ID = (Int32)(rd["VB_ID"]); Item.SoDen = rd["VB_SoDen"].ToString(); Item.NgayTao = Convert.ToDateTime(rd["VB_NgayTao"]); Item.NgayCapNhat = Convert.ToDateTime(rd["VB_NgayCapNhat"]); Item.NguoiTao = rd["VB_NguoiTao"].ToString(); return(Item); }
public static VanBan SelectDraffById(Int32 VB_ID) { VanBan Item = new VanBan(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("VB_ID", VB_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBan_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReaderDraff2(rd); } } return(Item); }
public static VanBan Update(VanBan Updated) { VanBan Item = new VanBan(); SqlParameter[] obj = new SqlParameter[32]; obj[0] = new SqlParameter("VB_ID", Updated.ID); obj[1] = new SqlParameter("VB_WF_ID", Updated.WF_ID); obj[2] = new SqlParameter("VB_Ten", Updated.Ten); obj[3] = new SqlParameter("VB_SoDen", Updated.SoDen); obj[4] = new SqlParameter("VB_PhanLoai_ID", Updated.PhanLoai_ID); obj[5] = new SqlParameter("VB_CapGui_ID", Updated.CapGui_ID); obj[6] = new SqlParameter("VB_CapGui_Ten", Updated.CapGui_Ten); obj[7] = new SqlParameter("VB_NgayNhan", Updated.NgayNhan); obj[8] = new SqlParameter("VB_NgayTrenVanBan", Updated.NgayTrenVanBan); obj[9] = new SqlParameter("VB_SoKyHieu", Updated.SoKyHieu); obj[10] = new SqlParameter("VB_LoaiVanBan_ID", Updated.LoaiVanBan_ID); obj[11] = new SqlParameter("VB_LoaiVanBan_Ten", Updated.LoaiVanBan_Ten); obj[12] = new SqlParameter("VB_NoiGui_ID", Updated.NoiGui_ID); obj[13] = new SqlParameter("VB_NoiGui_Ten", Updated.NoiGui_Ten); obj[14] = new SqlParameter("VB_TrichYeu", Updated.TrichYeu); obj[15] = new SqlParameter("VB_NgayTao", Updated.NgayTao); obj[16] = new SqlParameter("VB_NguoiTao", Updated.NguoiTao); obj[17] = new SqlParameter("VB_NgayCapNhat", Updated.NgayCapNhat); obj[18] = new SqlParameter("VB_RowId", Updated.RowId); obj[19] = new SqlParameter("VB_PhucDap", Updated.PhucDap); obj[20] = new SqlParameter("VB_PhucDap_ID", Updated.PhucDap_ID); obj[21] = new SqlParameter("VB_Den", Updated.Den); obj[22] = new SqlParameter("VB_TrangThai", Updated.TrangThai); obj[23] = new SqlParameter("VB_CQ_ID", Updated.CQ_ID); obj[24] = new SqlParameter("VB_CQ_Ten", Updated.CQ_Ten); obj[25] = new SqlParameter("VB_MEM_Username", Updated.MEM_Username); obj[26] = new SqlParameter("VB_MEM_Ten", Updated.MEM_Ten); obj[27] = new SqlParameter("VB_LichSu", Updated.LichSu); obj[28] = new SqlParameter("VB_CVBNODE_ID", Updated.CVBNODE_ID); obj[29] = new SqlParameter("VB_Draff", Updated.Draff); obj[30] = new SqlParameter("VB_Moi", Updated.Moi); obj[31] = new SqlParameter("VB_CVBNODE_Ten", Updated.CVBNODE_Ten); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBan_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReaderDraff(rd); } } return(Item); }
public static VanBan InsertDraff(VanBan Inserted) { VanBan Item = new VanBan(); SqlParameter[] obj = new SqlParameter[5]; obj[0] = new SqlParameter("VB_NgayTao", Inserted.NgayTao); obj[1] = new SqlParameter("VB_NguoiTao", Inserted.NguoiTao); obj[2] = new SqlParameter("VB_NgayCapNhat", Inserted.NgayCapNhat); obj[3] = new SqlParameter("VB_RowId", Inserted.RowId); obj[4] = new SqlParameter("VB_Draff", Inserted.Draff); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBan_Insert_InsertDraff_linhnx", obj)) { while (rd.Read()) { Item = getFromReaderDraff(rd); } } return(Item); }
public static VanBan getFromReaderTiny(IDataReader rd) { VanBan Item = new VanBan(); Item.ID = (Int32)(rd["VB_ID"]); Item.SoDen = (String)(rd["VB_SoDen"]); Item.PhanLoai_ID = (String)(rd["VB_PhanLoai_ID"]); Item.CapGui_Ten = (String)(rd["VB_CapGui_Ten"]); Item.NgayNhan = (DateTime)(rd["VB_NgayNhan"]); Item.NgayTrenVanBan = (DateTime)(rd["VB_NgayTrenVanBan"]); Item.SoKyHieu = (String)(rd["VB_SoKyHieu"]); Item.LoaiVanBan_Ten = (String)(rd["VB_LoaiVanBan_Ten"]); Item.NoiGui_Ten = (String)(rd["VB_NoiGui_Ten"]); Item.TrichYeu = (String)(rd["VB_TrichYeu"]); Item.NgayTao = (DateTime)(rd["VB_NgayTao"]); Item.NguoiTao = (String)(rd["VB_NguoiTao"]); Item.TrangThai = (Int32)(rd["VB_TrangThai"]); Item.CQ_ID = (Int32)(rd["VB_CQ_ID"]); Item.CQ_Ten = (String)(rd["VB_CQ_Ten"]); return(Item); }
public static VanBan SelectByIdView(Int32 VB_ID) { VanBan Item = new VanBan(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("VB_ID", VB_ID); List <Files> filelist = new List <Files>(); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBan_Select_SelectByIdView_hungpm", obj)) { while (rd.Read()) { Item = getFromReaderTiny(rd); Files item = new Files(); item.Ten = rd["F_Ten"].ToString(); item.ID = Convert.ToInt32(rd["F_ID"]); item.NguoiTao = rd["F_NguoiTao"].ToString(); filelist.Add(item); } } Item.Filelist = filelist; return(Item); }
public static VanBan getFromReaderXuLy(IDataReader rd) { VanBan Item = new VanBan(); Nodes _Nodes = new Nodes(); if (rd.FieldExists("VB_ID")) { Item.ID = (Int32)(rd["VB_ID"]); } if (rd.FieldExists("VB_SoDen")) { Item.SoDen = (String)(rd["VB_SoDen"]); } if (rd.FieldExists("VB_PhanLoai_ID")) { Item.PhanLoai_ID = (String)(rd["VB_PhanLoai_ID"]); } if (rd.FieldExists("VB_CapGui_Ten")) { Item.CapGui_Ten = (String)(rd["VB_CapGui_Ten"]); } if (rd.FieldExists("VB_NgayNhan")) { Item.NgayNhan = (DateTime)(rd["VB_NgayNhan"]); } if (rd.FieldExists("VB_NgayTrenVanBan")) { Item.NgayTrenVanBan = (DateTime)(rd["VB_NgayTrenVanBan"]); } if (rd.FieldExists("VB_SoKyHieu")) { Item.SoKyHieu = (String)(rd["VB_SoKyHieu"]); } if (rd.FieldExists("VB_LoaiVanBan_Ten")) { Item.LoaiVanBan_Ten = (String)(rd["VB_LoaiVanBan_Ten"]); } if (rd.FieldExists("VB_NoiGui_Ten")) { Item.NoiGui_Ten = (String)(rd["VB_NoiGui_Ten"]); } if (rd.FieldExists("VB_TrichYeu")) { Item.TrichYeu = (String)(rd["VB_TrichYeu"]); } if (rd.FieldExists("VB_NgayTao")) { Item.NgayTao = (DateTime)(rd["VB_NgayTao"]); } if (rd.FieldExists("VB_NguoiTao")) { Item.NguoiTao = (String)(rd["VB_NguoiTao"]); } if (rd.FieldExists("VB_TrangThai")) { Item.TrangThai = (Int32)(rd["VB_TrangThai"]); } if (rd.FieldExists("VB_CQ_ID")) { Item.CQ_ID = (Int32)(rd["VB_CQ_ID"]); } if (rd.FieldExists("VB_CQ_Ten")) { Item.CQ_Ten = (String)(rd["VB_CQ_Ten"]); } if (rd.FieldExists("VB_LichSu")) { Item.LichSu = (String)(rd["VB_LichSu"]); } if (rd.FieldExists("VB_CVBNODE_ID")) { Item.CVBNODE_ID = (Int32)(rd["VB_CVBNODE_ID"]); } if (rd.FieldExists("VB_WF_ID")) { Item.WF_ID = (Int32)(rd["VB_WF_ID"]); } if (rd.FieldExists("NODE_AddMember")) { _Nodes.AddMember = (Boolean)(rd["NODE_AddMember"]); } if (rd.FieldExists("NODE_AddCoQuan")) { _Nodes.AddCoQuan = (Boolean)(rd["NODE_AddCoQuan"]); } if (rd.FieldExists("NODE_ChuyenTiep")) { _Nodes.ChuyenTiep = (Boolean)(rd["NODE_ChuyenTiep"]); } if (rd.FieldExists("NODE_ChuyenNguoc")) { _Nodes.ChuyenNguoc = (Boolean)(rd["NODE_ChuyenNguoc"]); } if (rd.FieldExists("NODE_AddAllMember")) { _Nodes.AddAllMember = (Boolean)(rd["NODE_AddAllMember"]); } if (rd.FieldExists("NODE_KetThuc")) { _Nodes.KetThuc = (Boolean)(rd["NODE_KetThuc"]); } if (rd.FieldExists("NODE_BatDau")) { _Nodes.BatDau = (Boolean)(rd["NODE_BatDau"]); } Item.nodes = _Nodes; return(Item); }
public static VanBan getFromReaderPager(IDataReader rd) { VanBan Item = new VanBan(); if (rd.FieldExists("VB_ID")) { Item.ID = (Int32)(rd["VB_ID"]); } if (rd.FieldExists("VB_SoDen")) { Item.SoDen = (String)(rd["VB_SoDen"]); } if (rd.FieldExists("VB_PhanLoai_ID")) { Item.PhanLoai_ID = (String)(rd["VB_PhanLoai_ID"]); } //Item.CapGui_ID = (Int32)(rd["VB_CapGui_ID"]); //Item.CapGui_Ten = (String)(rd["VB_CapGui_Ten"]); if (rd.FieldExists("VB_LanhDaoBo")) { Item.LanhDaoBo = (String)(rd["VB_LanhDaoBo"]); } if (rd.FieldExists("VB_NgayNhan")) { Item.NgayNhan = (DateTime)(rd["VB_NgayNhan"]); } if (rd.FieldExists("VB_NgayTrenVanBan")) { Item.NgayTrenVanBan = (DateTime)(rd["VB_NgayTrenVanBan"]); } if (rd.FieldExists("VB_SoKyHieu")) { Item.SoKyHieu = (String)(rd["VB_SoKyHieu"]); } if (rd.FieldExists("VB_NoiGui_ID")) { Item.NoiGui_ID = (Int32)(rd["VB_NoiGui_ID"]); } if (rd.FieldExists("VB_NoiGui_Ten")) { Item.NoiGui_Ten = (String)(rd["VB_NoiGui_Ten"]); } if (rd.FieldExists("VB_TrichYeu")) { Item.TrichYeu = (String)(rd["VB_TrichYeu"]); } if (rd.FieldExists("VB_NgayTao")) { Item.NgayTao = (DateTime)(rd["VB_NgayTao"]); } if (rd.FieldExists("VB_Draff")) { Item.Draff = (Boolean)(rd["VB_Draff"]); } if (rd.FieldExists("VB_PhucDap")) { Item.PhucDap = (Boolean)(rd["VB_PhucDap"]); } if (rd.FieldExists("VB_PhucDap_ID")) { Item.PhucDap_ID = (Int32)(rd["VB_PhucDap_ID"]); } if (rd.FieldExists("VB_TrangThai")) { Item.TrangThai = (Int32)(rd["VB_TrangThai"]); } if (rd.FieldExists("VB_CQ_ID")) { Item.CQ_ID = (Int32)(rd["VB_CQ_ID"]); } if (rd.FieldExists("VB_CQ_Ten")) { Item.CQ_Ten = (String)(rd["VB_CQ_Ten"]); } if (rd.FieldExists("VB_MEM_Username")) { Item.MEM_Username = (String)(rd["VB_MEM_Username"]); } if (rd.FieldExists("VB_MEM_Ten")) { Item.MEM_Ten = (String)(rd["VB_MEM_Ten"]); } if (rd.FieldExists("VB_NguoiTao")) { Item.NguoiTao = rd["VB_NguoiTao"].ToString(); } if (rd.FieldExists("VB_Doc")) { Item.Doc = (Boolean)(rd["VB_Doc"]); } if (rd.FieldExists("VB_XuLy")) { Item.XuLy = (Boolean)(rd["VB_XuLy"]); } if (rd.FieldExists("VB_Chinh")) { Item.Chinh = (Boolean)(rd["VB_Chinh"]); } return(Item); }
public static VanBan getFromReader(IDataReader rd) { VanBan Item = new VanBan(); if (rd.FieldExists("VB_ID")) { Item.ID = (Int32)(rd["VB_ID"]); } if (rd.FieldExists("VB_WF_ID")) { Item.WF_ID = (Int32)(rd["VB_WF_ID"]); } if (rd.FieldExists("VB_Ten")) { Item.Ten = (String)(rd["VB_Ten"]); } if (rd.FieldExists("VB_SoDen")) { Item.SoDen = (String)(rd["VB_SoDen"]); } if (rd.FieldExists("VB_PhanLoai_ID")) { Item.PhanLoai_ID = (String)(rd["VB_PhanLoai_ID"]); } if (rd.FieldExists("VB_CapGui_ID")) { Item.CapGui_ID = (Int32)(rd["VB_CapGui_ID"]); } if (rd.FieldExists("VB_CapGui_Ten")) { Item.CapGui_Ten = (String)(rd["VB_CapGui_Ten"]); } if (rd.FieldExists("VB_NgayNhan")) { Item.NgayNhan = (DateTime)(rd["VB_NgayNhan"]); } if (rd.FieldExists("VB_NgayTrenVanBan")) { Item.NgayTrenVanBan = (DateTime)(rd["VB_NgayTrenVanBan"]); } if (rd.FieldExists("VB_SoKyHieu")) { Item.SoKyHieu = (String)(rd["VB_SoKyHieu"]); } if (rd.FieldExists("VB_LoaiVanBan_ID")) { Item.LoaiVanBan_ID = (Int32)(rd["VB_LoaiVanBan_ID"]); } if (rd.FieldExists("VB_LoaiVanBan_Ten")) { Item.LoaiVanBan_Ten = (String)(rd["VB_LoaiVanBan_Ten"]); } if (rd.FieldExists("VB_NoiGui_ID")) { Item.NoiGui_ID = (Int32)(rd["VB_NoiGui_ID"]); } if (rd.FieldExists("VB_NoiGui_Ten")) { Item.NoiGui_Ten = (String)(rd["VB_NoiGui_Ten"]); } if (rd.FieldExists("VB_TrichYeu")) { Item.TrichYeu = (String)(rd["VB_TrichYeu"]); } if (rd.FieldExists("VB_NgayTao")) { Item.NgayTao = (DateTime)(rd["VB_NgayTao"]); } if (rd.FieldExists("VB_NguoiTao")) { Item.NguoiTao = (String)(rd["VB_NguoiTao"]); } if (rd.FieldExists("VB_LanhDaoBo")) { Item.LanhDaoBo = (String)(rd["VB_LanhDaoBo"]); } if (rd.FieldExists("VB_NgayCapNhat")) { Item.NgayCapNhat = (DateTime)(rd["VB_NgayCapNhat"]); } if (rd.FieldExists("VB_RowId")) { Item.RowId = (Guid)(rd["VB_RowId"]); } if (rd.FieldExists("VB_PhucDap")) { Item.PhucDap = (Boolean)(rd["VB_PhucDap"]); } if (rd.FieldExists("VB_PhucDap_ID")) { Item.PhucDap_ID = (Int32)(rd["VB_PhucDap_ID"]); } if (rd.FieldExists("VB_Den")) { Item.Den = (Boolean)(rd["VB_Den"]); } if (rd.FieldExists("VB_TrangThai")) { Item.TrangThai = (Int32)(rd["VB_TrangThai"]); } if (rd.FieldExists("VB_CQ_ID")) { Item.CQ_ID = (Int32)(rd["VB_CQ_ID"]); } if (rd.FieldExists("VB_CQ_Ten")) { Item.CQ_Ten = (String)(rd["VB_CQ_Ten"]); } if (rd.FieldExists("VB_MEM_Username")) { Item.MEM_Username = (String)(rd["VB_MEM_Username"]); } if (rd.FieldExists("VB_MEM_Ten")) { Item.MEM_Ten = (String)(rd["VB_MEM_Ten"]); } if (rd.FieldExists("VB_LichSu")) { Item.LichSu = (String)(rd["VB_LichSu"]); } if (rd.FieldExists("VB_CVBNODE_ID")) { Item.CVBNODE_ID = (Int32)(rd["VB_CVBNODE_ID"]); } if (rd.FieldExists("VB_Draff")) { Item.Draff = (Boolean)(rd["VB_Draff"]); } if (rd.FieldExists("VB_Moi")) { Item.Moi = (Boolean)(rd["VB_Moi"]); } if (rd.FieldExists("VB_CVBNODE_Ten")) { Item.CVBNODE_Ten = (String)(rd["VB_CVBNODE_Ten"]); } if (rd.FieldExists("VB_Doc")) { Item.Doc = (Boolean)(rd["VB_Doc"]); } if (rd.FieldExists("VB_XuLy")) { Item.XuLy = (Boolean)(rd["VB_XuLy"]); } if (rd.FieldExists("VB_Chinh")) { Item.Chinh = (Boolean)(rd["VB_Chinh"]); } if (rd.FieldExists("VB_So_DonVi")) { Item.MucDo = (Boolean)(rd["VB_So_DonVi"]); } if (rd.FieldExists("VB_MucDo")) { Item.MucDo = (Boolean)(rd["VB_MucDo"]); } if (rd.FieldExists("VB_GhiChu")) { Item.GhiChu = (String)(rd["VB_GhiChu"]); } if (rd.FieldExists("VB_So_Phieu")) { Item.GhiChu = (String)(rd["VB_So_Phieu"]); } return(Item); }