public static ToTrinh Insert(ToTrinh Inserted)
{
ToTrinh Item = new ToTrinh();
SqlParameter[] obj = new SqlParameter[37];
obj[0] = new SqlParameter("VBD_LoaiVanBan_ID", Inserted.LoaiVanBan_ID);
obj[1] = new SqlParameter("VBD_LoaiVanBan_Ten", Inserted.LoaiVanBan_Ten);
obj[2] = new SqlParameter("VBD_TrichYeu", Inserted.TrichYeu);
obj[3] = new SqlParameter("VBD_DonViThao_ID", Inserted.DonViThao_ID);
obj[4] = new SqlParameter("VBD_DonViThao_Ten", Inserted.DonViThao_Ten);
obj[5] = new SqlParameter("VBD_NguoiThao", Inserted.NguoiThao);
obj[6] = new SqlParameter("VBD_NoiNhan_ID", Inserted.NoiNhan_ID);
obj[7] = new SqlParameter("VBD_NoiNhan_Ten", Inserted.NoiNhan_Ten);
obj[8] = new SqlParameter("VBD_SoTrang", Inserted.SoTrang);
obj[9] = new SqlParameter("VBD_GhiChu", Inserted.GhiChu);
obj[10] = new SqlParameter("VBD_TrangThai", Inserted.TrangThai);
obj[11] = new SqlParameter("VBD_RowId", Inserted.RowId);
obj[12] = new SqlParameter("VBD_NguoiTao", Inserted.NguoiTao);
obj[13] = new SqlParameter("VBD_NguoiSua", Inserted.NguoiSua);
obj[14] = new SqlParameter("VBD_NgayTao", Inserted.NgayTao);
obj[15] = new SqlParameter("VBD_NgayCapNhat", Inserted.NgayCapNhat);
obj[16] = new SqlParameter("VBD_TT_So", Inserted.TT_So);
obj[17] = new SqlParameter("VBD_TT_NgayTrinh", Inserted.TT_NgayTrinh);
obj[18] = new SqlParameter("VBD_TT_LDVP_NgayTrinh", Inserted.TT_LDVP_NgayTrinh);
obj[19] = new SqlParameter("VBD_TT_LDVP_YKien", Inserted.TT_LDVP_YKien);
obj[20] = new SqlParameter("VBD_TT_LDVP_ID", Inserted.TT_LDVP_ID);
obj[21] = new SqlParameter("VBD_TT_LDVP_Username", Inserted.TT_LDVP_Username);
obj[22] = new SqlParameter("VBD_TT_LDVP_Ten", Inserted.TT_LDVP_Ten);
obj[23] = new SqlParameter("VBD_TT_LDVP_Loai_Ten", Inserted.TT_LDVP_Loai_Ten);
obj[24] = new SqlParameter("VBD_TT_LDB_NgayTrinh", Inserted.TT_LDB_NgayTrinh);
obj[25] = new SqlParameter("VBD_TT_LDB_YKien", Inserted.TT_LDB_YKien);
obj[26] = new SqlParameter("VBD_TT_LDB_ID", Inserted.TT_LDB_ID);
obj[27] = new SqlParameter("VBD_TT_LDB_Username", Inserted.TT_LDB_Username);
obj[28] = new SqlParameter("VBD_TT_LDB_Ten", Inserted.TT_LDB_Ten);
obj[29] = new SqlParameter("VBD_TT_LDB_Loai_Ten", Inserted.TT_LDB_Loai_Ten);
obj[30] = new SqlParameter("VBD_TT_LDB_NgayKy", Inserted.TT_LDB_NgayKy);
obj[31] = new SqlParameter("VBD_TT_NgayChuyenPhatHanh", Inserted.TT_NgayChuyenPhatHanh);
obj[32] = new SqlParameter("VBD_TT_LDVP_LyDoTraLai", Inserted.TT_LDVP_LyDo);
obj[33] = new SqlParameter("VBD_TT_LDVP_NgayTraLai", Inserted.TT_LDVP_NgayTraLai);
obj[34] = new SqlParameter("VBD_TT_LDB_LyDoTraLai", Inserted.TT_LDB_LyDo);
obj[35] = new SqlParameter("VBD_TT_LDB_NgayTraLai", Inserted.TT_LDB_NgayTraLai);
obj[36] = new SqlParameter("VBD_TT_TT_DonVi_So", Inserted.TT_DonVi_So);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_TT_Insert_InsertNormal_hungpm", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static ToTrinh getFromReaderDraff2(IDataReader rd)
{
ToTrinh Item = new ToTrinh();
Item.ID = (Int32)(rd["VBD_ID"]);
Item.CapDo_ID = (Int32)(rd["VBD_CapDo_ID"]);
Item.RowId = (Guid)(rd["VBD_RowId"]);
Item.NguoiTao = (String)(rd["VBD_NguoiTao"]);
Item.NguoiSua = (String)(rd["VBD_NguoiSua"]);
Item.NgayTao = (DateTime)(rd["VBD_NgayTao"]);
Item.NgayCapNhat = (DateTime)(rd["VBD_NgayCapNhat"]);
return(Item);
}
public static ToTrinh SelectDraffById(Int32 VBD_ID)
{
ToTrinh Item = new ToTrinh();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("VBD_ID", VBD_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReaderDraff2(rd);
}
}
return(Item);
}
public static ToTrinh SelectByIdView(Int32 VBD_ID)
{
ToTrinh Item = new ToTrinh();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("VBD_ID", VBD_ID);
List <Files> filelist = new List <Files>();
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_Select_SelectByIdView_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(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 ToTrinh getFromReader(IDataReader rd)
{
ToTrinh Item = new ToTrinh();
if (rd.FieldExists("VBD_ID"))
{
Item.ID = (Int32)(rd["VBD_ID"]);
}
if (rd.FieldExists("VBD_CapDo_ID"))
{
Item.CapDo_ID = (Int32)(rd["VBD_CapDo_ID"]);
}
if (rd.FieldExists("VBD_CapDo_Ten"))
{
Item.CapDo_Ten = (String)(rd["VBD_CapDo_Ten"]);
}
if (rd.FieldExists("VBD_LoaiVanBan_ID"))
{
Item.LoaiVanBan_ID = (Int32)(rd["VBD_LoaiVanBan_ID"]);
}
if (rd.FieldExists("VBD_LoaiVanBan_Ten"))
{
Item.LoaiVanBan_Ten = (String)(rd["VBD_LoaiVanBan_Ten"]);
}
if (rd.FieldExists("VBD_TrichYeu"))
{
Item.TrichYeu = (String)(rd["VBD_TrichYeu"]);
}
if (rd.FieldExists("VBD_DonViThao_ID"))
{
Item.DonViThao_ID = (Int32)(rd["VBD_DonViThao_ID"]);
}
if (rd.FieldExists("VBD_DonViThao_Ten"))
{
Item.DonViThao_Ten = (String)(rd["VBD_DonViThao_Ten"]);
}
if (rd.FieldExists("VBD_NguoiThao"))
{
Item.NguoiThao = (String)(rd["VBD_NguoiThao"]);
}
if (rd.FieldExists("VBD_NoiNhan_ID"))
{
Item.NoiNhan_ID = (Int32)(rd["VBD_NoiNhan_ID"]);
}
if (rd.FieldExists("VBD_NoiNhan_Ten"))
{
Item.NoiNhan_Ten = (String)(rd["VBD_NoiNhan_Ten"]);
}
if (rd.FieldExists("VBD_SoTrang"))
{
Item.SoTrang = (Int32)(rd["VBD_SoTrang"]);
}
if (rd.FieldExists("VBD_GhiChu"))
{
Item.GhiChu = (String)(rd["VBD_GhiChu"]);
}
if (rd.FieldExists("VBD_TrangThai"))
{
Item.TrangThai = (Byte)(rd["VBD_TrangThai"]);
}
if (rd.FieldExists("VBD_RowId"))
{
Item.RowId = (Guid)(rd["VBD_RowId"]);
}
if (rd.FieldExists("VBD_NguoiTao"))
{
Item.NguoiTao = (String)(rd["VBD_NguoiTao"]);
}
if (rd.FieldExists("VBD_NguoiSua"))
{
Item.NguoiSua = (String)(rd["VBD_NguoiSua"]);
}
if (rd.FieldExists("VBD_NgayTao"))
{
Item.NgayTao = (DateTime)(rd["VBD_NgayTao"]);
}
if (rd.FieldExists("VBD_NgayCapNhat"))
{
Item.NgayCapNhat = (DateTime)(rd["VBD_NgayCapNhat"]);
}
if (rd.FieldExists("VBD_TT_So"))
{
Item.TT_So = (Int32)(rd["VBD_TT_So"]);
}
if (rd.FieldExists("VBD_TT_NgayTrinh"))
{
Item.TT_NgayTrinh = (DateTime)(rd["VBD_TT_NgayTrinh"]);
}
if (rd.FieldExists("VBD_TT_LDVP_NgayTrinh"))
{
Item.TT_LDVP_NgayTrinh = (DateTime)(rd["VBD_TT_LDVP_NgayTrinh"]);
}
if (rd.FieldExists("VBD_TT_LDVP_YKien"))
{
Item.TT_LDVP_YKien = (String)(rd["VBD_TT_LDVP_YKien"]);
}
if (rd.FieldExists("VBD_TT_LDVP_NgayTraLai"))
{
Item.TT_LDVP_NgayTraLai = (DateTime)(rd["VBD_TT_LDVP_NgayTraLai"]);
}
if (rd.FieldExists("VBD_TT_LDVP_LyDoTraLai"))
{
Item.TT_LDVP_LyDo = (String)(rd["VBD_TT_LDVP_LyDoTraLai"]);
}
if (rd.FieldExists("VBD_TT_LDB_NgayTraLai"))
{
Item.TT_LDB_NgayTraLai = (DateTime)(rd["VBD_TT_LDB_NgayTraLai"]);
}
if (rd.FieldExists("VBD_TT_LDB_LyDoTraLai"))
{
Item.TT_LDB_LyDo = (String)(rd["VBD_TT_LDB_LyDoTraLai"]);
}
if (rd.FieldExists("VBD_TT_LDVP_ID"))
{
Item.TT_LDVP_ID = (Int32)(rd["VBD_TT_LDVP_ID"]);
}
if (rd.FieldExists("VBD_TT_LDVP_Username"))
{
Item.TT_LDVP_Username = (String)(rd["VBD_TT_LDVP_Username"]);
}
if (rd.FieldExists("VBD_TT_LDVP_Ten"))
{
Item.TT_LDVP_Ten = (String)(rd["VBD_TT_LDVP_Ten"]);
}
if (rd.FieldExists("VBD_TT_LDVP_Loai_Ten"))
{
Item.TT_LDVP_Loai_Ten = (String)(rd["VBD_TT_LDVP_Loai_Ten"]);
}
if (rd.FieldExists("VBD_TT_LDB_NgayTrinh"))
{
Item.TT_LDB_NgayTrinh = (DateTime)(rd["VBD_TT_LDB_NgayTrinh"]);
}
if (rd.FieldExists("VBD_TT_LDB_YKien"))
{
Item.TT_LDB_YKien = (String)(rd["VBD_TT_LDB_YKien"]);
}
if (rd.FieldExists("VBD_TT_LDB_ID"))
{
Item.TT_LDB_ID = (Int32)(rd["VBD_TT_LDB_ID"]);
}
if (rd.FieldExists("VBD_TT_LDB_Username"))
{
Item.TT_LDB_Username = (String)(rd["VBD_TT_LDB_Username"]);
}
if (rd.FieldExists("VBD_TT_LDB_Ten"))
{
Item.TT_LDB_Ten = (String)(rd["VBD_TT_LDB_Ten"]);
}
if (rd.FieldExists("VBD_TT_LDB_Loai_Ten"))
{
Item.TT_LDB_Loai_Ten = (String)(rd["VBD_TT_LDB_Loai_Ten"]);
}
if (rd.FieldExists("VBD_TT_LDB_NgayKy"))
{
Item.TT_LDB_NgayKy = (DateTime)(rd["VBD_TT_LDB_NgayKy"]);
}
if (rd.FieldExists("VBD_TT_NgayChuyenPhatHanh"))
{
Item.TT_NgayChuyenPhatHanh = (DateTime)(rd["VBD_TT_NgayChuyenPhatHanh"]);
}
if (rd.FieldExists("VBD_TT_NgayTrinh_Tuan"))
{
Item.NgayTrinh_Tuan = (String)(rd["VBD_TT_NgayTrinh_Tuan"]);
}
if (rd.FieldExists("VBD_TT_NgayTrinh_Thang"))
{
Item.NgayTrinh_Thang = (String)(rd["VBD_TT_NgayTrinh_Thang"]);
}
if (rd.FieldExists("VBD_TT_DonVi"))
{
Item.TT_DonVi = (String)(rd["VBD_TT_DonVi"]);
}
if (rd.FieldExists("VBD_TT_DonVi_So"))
{
Item.TT_DonVi_So = (Int32)(rd["VBD_TT_DonVi_So"]);
}
return(Item);
}
public static ToTrinh Update(ToTrinh Updated)
{
ToTrinh Item = new ToTrinh();
SqlParameter[] obj = new SqlParameter[38];
obj[0] = new SqlParameter("VBD_ID", Updated.ID);
obj[1] = new SqlParameter("VBD_LoaiVanBan_ID", Updated.LoaiVanBan_ID);
obj[2] = new SqlParameter("VBD_LoaiVanBan_Ten", Updated.LoaiVanBan_Ten);
obj[3] = new SqlParameter("VBD_TrichYeu", Updated.TrichYeu);
obj[4] = new SqlParameter("VBD_DonViThao_ID", Updated.DonViThao_ID);
obj[5] = new SqlParameter("VBD_DonViThao_Ten", Updated.DonViThao_Ten);
obj[6] = new SqlParameter("VBD_NguoiThao", Updated.NguoiThao);
obj[7] = new SqlParameter("VBD_NoiNhan_ID", Updated.NoiNhan_ID);
obj[8] = new SqlParameter("VBD_NoiNhan_Ten", Updated.NoiNhan_Ten);
obj[9] = new SqlParameter("VBD_SoTrang", Updated.SoTrang);
obj[10] = new SqlParameter("VBD_GhiChu", Updated.GhiChu);
obj[11] = new SqlParameter("VBD_TrangThai", Updated.TrangThai);
obj[12] = new SqlParameter("VBD_RowId", Updated.RowId);
obj[13] = new SqlParameter("VBD_NguoiTao", Updated.NguoiTao);
obj[14] = new SqlParameter("VBD_NguoiSua", Updated.NguoiSua);
obj[15] = new SqlParameter("VBD_NgayTao", Updated.NgayTao);
obj[16] = new SqlParameter("VBD_NgayCapNhat", Updated.NgayCapNhat);
obj[17] = new SqlParameter("VBD_TT_So", Updated.TT_So);
obj[18] = new SqlParameter("VBD_TT_NgayTrinh", Updated.TT_NgayTrinh);
string htl = string.Format("{0:dd/MM/yy}", Updated.TT_NgayTrinh);
if (htl != "01/01/01")
{
obj[18] = new SqlParameter("VBD_TT_NgayTrinh", Updated.TT_NgayTrinh);
}
else
{
obj[18] = new SqlParameter("VBD_TT_NgayTrinh", DBNull.Value);
}
obj[19] = new SqlParameter("VBD_TT_LDVP_NgayTrinh", Updated.TT_LDVP_NgayTrinh);
string htl0 = string.Format("{0:dd/MM/yy}", Updated.TT_LDVP_NgayTrinh);
if (htl0 != "01/01/01")
{
obj[19] = new SqlParameter("VBD_TT_LDVP_NgayTrinh", Updated.TT_LDVP_NgayTrinh);
}
else
{
obj[19] = new SqlParameter("VBD_TT_LDVP_NgayTrinh", DBNull.Value);
}
obj[20] = new SqlParameter("VBD_TT_LDVP_YKien", Updated.TT_LDVP_YKien);
obj[21] = new SqlParameter("VBD_TT_LDVP_ID", Updated.TT_LDVP_ID);
obj[22] = new SqlParameter("VBD_TT_LDVP_Username", Updated.TT_LDVP_Username);
obj[23] = new SqlParameter("VBD_TT_LDVP_Ten", Updated.TT_LDVP_Ten);
obj[24] = new SqlParameter("VBD_TT_LDVP_Loai_Ten", Updated.TT_LDVP_Loai_Ten);
obj[25] = new SqlParameter("VBD_TT_LDB_NgayTrinh", Updated.TT_LDB_NgayTrinh);
string htl1 = string.Format("{0:dd/MM/yy}", Updated.TT_LDB_NgayTrinh);
if (htl1 != "01/01/01")
{
obj[25] = new SqlParameter("VBD_TT_LDB_NgayTrinh", Updated.TT_LDB_NgayTrinh);
}
else
{
obj[25] = new SqlParameter("VBD_TT_LDB_NgayTrinh", DBNull.Value);
}
obj[26] = new SqlParameter("VBD_TT_LDB_YKien", Updated.TT_LDB_YKien);
obj[27] = new SqlParameter("VBD_TT_LDB_ID", Updated.TT_LDB_ID);
obj[28] = new SqlParameter("VBD_TT_LDB_Username", Updated.TT_LDB_Username);
obj[29] = new SqlParameter("VBD_TT_LDB_Ten", Updated.TT_LDB_Ten);
obj[30] = new SqlParameter("VBD_TT_LDB_Loai_Ten", Updated.TT_LDB_Loai_Ten);
obj[31] = new SqlParameter("VBD_TT_LDB_NgayKy", Updated.TT_LDB_NgayKy);
string htl2 = string.Format("{0:dd/MM/yy}", Updated.TT_LDB_NgayKy);
if (htl2 != "01/01/01")
{
obj[31] = new SqlParameter("VBD_TT_LDB_NgayKy", Updated.TT_LDB_NgayKy);
}
else
{
obj[31] = new SqlParameter("VBD_TT_LDB_NgayKy", DBNull.Value);
}
obj[32] = new SqlParameter("VBD_TT_NgayChuyenPhatHanh", Updated.TT_NgayChuyenPhatHanh);
string htl3 = string.Format("{0:dd/MM/yy}", Updated.TT_NgayChuyenPhatHanh);
if (htl3 != "01/01/01")
{
obj[32] = new SqlParameter("VBD_TT_NgayChuyenPhatHanh", Updated.TT_NgayChuyenPhatHanh);
}
else
{
obj[32] = new SqlParameter("VBD_TT_NgayChuyenPhatHanh", DBNull.Value);
}
obj[33] = new SqlParameter("VBD_TT_LDVP_LyDoTraLai", Updated.TT_LDVP_LyDo);
obj[34] = new SqlParameter("VBDTT_LDVP_NgayTraLai", Updated.TT_LDVP_NgayTraLai);
var htl4 = string.Format("{0:dd/MM/yy}", Updated.TT_LDVP_NgayTraLai);
if (htl4 != "01/01/01")
{
obj[34] = new SqlParameter("VBD_TT_LDVP_NgayTraLai", Updated.TT_LDVP_NgayTraLai);
}
else
{
obj[34] = new SqlParameter("VBD_TT_LDVP_NgayTraLai", DBNull.Value);
}
obj[35] = new SqlParameter("VBD_TT_LDB_LyDoTraLai", Updated.TT_LDB_LyDo);
obj[36] = new SqlParameter("VBD_TT_LDB_NgayTraLai", Updated.TT_LDB_NgayTraLai);
var htl5 = string.Format("{0:dd/MM/yy}", Updated.TT_LDB_NgayTraLai);
if (htl5 != "01/01/01")
{
obj[36] = new SqlParameter("VBD_TT_LDB_NgayTraLai", Updated.TT_LDB_NgayTraLai);
}
else
{
obj[36] = new SqlParameter("VBD_TT_LDB_NgayTraLai", DBNull.Value);
}
obj[37] = new SqlParameter("VBD_TT_DonVi_So", Updated.TT_DonVi_So);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblVanBanDi_TT_Update_UpdateNormal_hungpm", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}