Ejemplo n.º 1
0
        public static DeTaiDuAn SelectById(Int32 DTDA_ID)
        {
            DeTaiDuAn Item = new DeTaiDuAn();

            SqlParameter[] obj = new SqlParameter[1];
            obj[0] = new SqlParameter("DTDA_ID", DTDA_ID);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDeTaiDuAn_Select_SelectById_linhnx", obj))
            {
                while (rd.Read())
                {
                    Item = getFromReader(rd);
                }
            }
            return(Item);
        }
Ejemplo n.º 2
0
        public static DeTaiDuAn SelectDraff(string DTDA_Ma, string userName)
        {
            DeTaiDuAn Item = new DeTaiDuAn();

            SqlParameter[] obj = new SqlParameter[2];
            obj[0] = new SqlParameter("DTDA_Ma", DTDA_Ma);
            obj[1] = new SqlParameter("Username", userName);
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDeTaiDuAn_Select_SelectDraff_hungpm", obj))
            {
                while (rd.Read())
                {
                    Item = getFromReader(rd);
                }
            }
            return(Item);
        }
Ejemplo n.º 3
0
        public static DeTaiDuAn SelectByIdView(Int32 DTDA_ID)
        {
            DeTaiDuAn Item = new DeTaiDuAn();

            SqlParameter[] obj = new SqlParameter[1];
            obj[0] = new SqlParameter("DTDA_ID", DTDA_ID);
            List <Files> filelist = new List <Files>();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDeTaiDuAn_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);
        }
Ejemplo n.º 4
0
        public static DeTaiDuAn getFromReader(IDataReader rd)
        {
            DeTaiDuAn Item = new DeTaiDuAn();

            if (rd.FieldExists("DTDA_ID"))
            {
                Item.ID = (Int32)(rd["DTDA_ID"]);
            }
            if (rd.FieldExists("DTDA_Loai_ID"))
            {
                Item.Loai_ID = (Int32)(rd["DTDA_Loai_ID"]);
            }
            if (rd.FieldExists("DTDA_Loai_Ten"))
            {
                Item.Loai_Ten = (String)(rd["DTDA_Loai_Ten"]);
            }
            if (rd.FieldExists("DTDA_ChuongTrinh_ID"))
            {
                Item.ChuongTrinh_ID = (Int32)(rd["DTDA_ChuongTrinh_ID"]);
            }
            if (rd.FieldExists("DTDA_ChuongTrinh_Ten"))
            {
                Item.ChuongTrinh_Ten = (String)(rd["DTDA_ChuongTrinh_Ten"]);
            }
            if (rd.FieldExists("DTDA_XuatXu_ID"))
            {
                Item.XuatXu_ID = (Int32)(rd["DTDA_XuatXu_ID"]);
            }
            if (rd.FieldExists("DTDA_XuatXu_Ten"))
            {
                Item.XuatXu_Ten = (String)(rd["DTDA_XuatXu_Ten"]);
            }
            if (rd.FieldExists("DTDA_CapThiet"))
            {
                Item.CapThiet = (String)(rd["DTDA_CapThiet"]);
            }
            if (rd.FieldExists("DTDA_MucTieu"))
            {
                Item.MucTieu = (String)(rd["DTDA_MucTieu"]);
            }
            if (rd.FieldExists("DTDA_NoiDung"))
            {
                Item.NoiDung = (String)(rd["DTDA_NoiDung"]);
            }
            if (rd.FieldExists("DTDA_SanPham"))
            {
                Item.SanPham = (String)(rd["DTDA_SanPham"]);
            }
            if (rd.FieldExists("DTDA_KhaNang"))
            {
                Item.KhaNang = (String)(rd["DTDA_KhaNang"]);
            }
            if (rd.FieldExists("DTDA_DiaChi"))
            {
                Item.DiaChi = (String)(rd["DTDA_DiaChi"]);
            }
            if (rd.FieldExists("DTDA_KinhPhi"))
            {
                Item.KinhPhi = (Decimal)(rd["DTDA_KinhPhi"]);
            }
            if (rd.FieldExists("DTDA_KP_NganSach"))
            {
                Item.KP_NganSach = (Decimal)(rd["DTDA_KP_NganSach"]);
            }
            if (rd.FieldExists("DTDA_KP_Khac"))
            {
                Item.KP_Khac = (Decimal)(rd["DTDA_KP_Khac"]);
            }
            if (rd.FieldExists("DTDA_CaNhanDeXuat"))
            {
                Item.CaNhanDeXuat = (String)(rd["DTDA_CaNhanDeXuat"]);
            }
            if (rd.FieldExists("DTDA_ThuTruong"))
            {
                Item.ThuTruong = (String)(rd["DTDA_ThuTruong"]);
            }
            if (rd.FieldExists("DTDA_ThoiGian"))
            {
                Item.ThoiGian = (Int32)(rd["DTDA_ThoiGian"]);
            }
            if (rd.FieldExists("DTDA_LinhVuc_ID"))
            {
                Item.LinhVuc_ID = (Int32)(rd["DTDA_LinhVuc_ID"]);
            }
            if (rd.FieldExists("DTDA_LinhVuc_Ten"))
            {
                Item.LinhVuc_Ten = (String)(rd["DTDA_LinhVuc_Ten"]);
            }
            if (rd.FieldExists("DTDA_RowId"))
            {
                Item.RowId = (Guid)(rd["DTDA_RowId"]);
            }
            if (rd.FieldExists("DTDA_NgayTao"))
            {
                Item.NgayTao = (DateTime)(rd["DTDA_NgayTao"]);
            }
            if (rd.FieldExists("DTDA_NgayCapNhat"))
            {
                Item.NgayCapNhat = (DateTime)(rd["DTDA_NgayCapNhat"]);
            }
            if (rd.FieldExists("DTDA_NguoiTao"))
            {
                Item.NguoiTao = (String)(rd["DTDA_NguoiTao"]);
            }
            if (rd.FieldExists("DTDA_NguoiCapNhat"))
            {
                Item.NguoiCapNhat = (String)(rd["DTDA_NguoiCapNhat"]);
            }
            if (rd.FieldExists("DTDA_Ten"))
            {
                Item.Ten = (String)(rd["DTDA_Ten"]);
            }

            if (rd.FieldExists("DTDA_DeTaiDuAn_ID"))
            {
                Item.DeTaiDuAn_ID = (Int32)(rd["DTDA_DeTaiDuAn_ID"]);
            }

            if (rd.FieldExists("DTDA_DeTaiDuAn_Ten"))
            {
                Item.DeTaiDuAn_Ten = (String)(rd["DTDA_DeTaiDuAn_Ten"]);
            }
            if (rd.FieldExists("DTDA_TrangThai_ID"))
            {
                Item.TrangThai_ID = (Int32)(rd["DTDA_TrangThai_ID"]);
            }
            if (rd.FieldExists("DTDA_TrangThai_Ten"))
            {
                Item.TrangThai_Ten = (String)(rd["DTDA_TrangThai_Ten"]);
            }
            if (rd.FieldExists("DTDA_SoTT"))
            {
                Item.SoTT = (Int32)(rd["DTDA_SoTT"]);
            }
            if (rd.FieldExists("DTDA_CQ_ID"))
            {
                Item.CQ_ID = (Int32)(rd["DTDA_CQ_ID"]);
            }
            if (rd.FieldExists("DTDA_CQ_Ma"))
            {
                Item.CQ_Ma = (String)(rd["DTDA_CQ_Ma"]);
            }
            if (rd.FieldExists("DTDA_TuNgay"))
            {
                Item.TuNgay = (DateTime)(rd["DTDA_TuNgay"]);
            }
            if (rd.FieldExists("DTDA_DenNgay"))
            {
                Item.DenNgay = (DateTime)(rd["DTDA_DenNgay"]);
            }
            return(Item);
        }
Ejemplo n.º 5
0
        public static DeTaiDuAn Update(DeTaiDuAn Updated)
        {
            DeTaiDuAn Item = new DeTaiDuAn();

            SqlParameter[] obj = new SqlParameter[35];
            obj[0]  = new SqlParameter("DTDA_ID", Updated.ID);
            obj[1]  = new SqlParameter("DTDA_Loai_ID", Updated.Loai_ID);
            obj[2]  = new SqlParameter("DTDA_Loai_Ten", Updated.Loai_Ten);
            obj[3]  = new SqlParameter("DTDA_ChuongTrinh_ID", Updated.ChuongTrinh_ID);
            obj[4]  = new SqlParameter("DTDA_ChuongTrinh_Ten", Updated.ChuongTrinh_Ten);
            obj[5]  = new SqlParameter("DTDA_XuatXu_ID", Updated.XuatXu_ID);
            obj[6]  = new SqlParameter("DTDA_XuatXu_Ten", Updated.XuatXu_Ten);
            obj[7]  = new SqlParameter("DTDA_CapThiet", Updated.CapThiet);
            obj[8]  = new SqlParameter("DTDA_MucTieu", Updated.MucTieu);
            obj[9]  = new SqlParameter("DTDA_NoiDung", Updated.NoiDung);
            obj[10] = new SqlParameter("DTDA_SanPham", Updated.SanPham);
            obj[11] = new SqlParameter("DTDA_KhaNang", Updated.KhaNang);
            obj[12] = new SqlParameter("DTDA_DiaChi", Updated.DiaChi);
            obj[13] = new SqlParameter("DTDA_KinhPhi", Updated.KinhPhi);
            obj[14] = new SqlParameter("DTDA_KP_NganSach", Updated.KP_NganSach);
            obj[15] = new SqlParameter("DTDA_KP_Khac", Updated.KP_Khac);
            obj[16] = new SqlParameter("DTDA_CaNhanDeXuat", Updated.CaNhanDeXuat);
            obj[17] = new SqlParameter("DTDA_ThuTruong", Updated.ThuTruong);
            obj[18] = new SqlParameter("DTDA_ThoiGian", Updated.ThoiGian);
            obj[19] = new SqlParameter("DTDA_LinhVuc_ID", Updated.LinhVuc_ID);
            obj[20] = new SqlParameter("DTDA_LinhVuc_Ten", Updated.LinhVuc_Ten);
            obj[21] = new SqlParameter("DTDA_RowId", Updated.RowId);
            string htl = string.Format("{0:dd/MM/yy}", Updated.TuNgay);

            if (htl != "01/01/01")
            {
                obj[22] = new SqlParameter("DTDA_NgayTao", Updated.NgayTao);
            }
            else
            {
                obj[22] = new SqlParameter("DTDA_NgayTao", DBNull.Value);
            }

            string htl1 = string.Format("{0:dd/MM/yy}", Updated.NgayCapNhat);

            if (htl1 != "01/01/01")
            {
                obj[23] = new SqlParameter("DTDA_NgayCapNhat", Updated.NgayCapNhat);
            }
            else
            {
                obj[23] = new SqlParameter("DTDA_NgayCapNhat", DBNull.Value);
            }
            obj[24] = new SqlParameter("DTDA_NguoiTao", Updated.NguoiTao);
            obj[25] = new SqlParameter("DTDA_NguoiCapNhat", Updated.NguoiCapNhat);
            obj[26] = new SqlParameter("DTDA_Ten", Updated.Ten);
            obj[27] = new SqlParameter("DTDA_DeTaiDuAn_ID", Updated.DeTaiDuAn_ID);
            obj[28] = new SqlParameter("DTDA_DeTaiDuAn_Ten", Updated.DeTaiDuAn_Ten);
            obj[29] = new SqlParameter("DTDA_TrangThai_ID", Updated.TrangThai_ID);
            obj[30] = new SqlParameter("DTDA_TrangThai_Ten", Updated.TrangThai_Ten);
            obj[31] = new SqlParameter("DTDA_SoTT", Updated.SoTT);
            obj[32] = new SqlParameter("DTDA_Draff", Updated.Draff);
            string htl2 = string.Format("{0:dd/MM/yy}", Updated.TuNgay);

            if (htl2 != "01/01/01")
            {
                obj[33] = new SqlParameter("DTDA_TuNgay", Updated.TuNgay);
            }
            else
            {
                obj[33] = new SqlParameter("DTDA_TuNgay", DBNull.Value);
            }
            string htl3 = string.Format("{0:dd/MM/yy}", Updated.DenNgay);

            if (htl3 != "01/01/01")
            {
                obj[34] = new SqlParameter("DTDA_DenNgay", Updated.DenNgay);
            }
            else
            {
                obj[34] = new SqlParameter("DTDA_DenNgay", DBNull.Value);
            }
            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblDeTaiDuAn_Update_UpdateNormal_linhnx", obj))
            {
                while (rd.Read())
                {
                    Item = getFromReader(rd);
                }
            }
            return(Item);
        }