コード例 #1
0
        public static List <Account_DTO> loadList()
        {
            //tạo chuỗi truy vấn
            string query = "select * from ACOUNT";

            using (SqlConnection connect = DataProvider.CONNECT())
            {
                DataTable dt = new DataTable();
                dt = DataProvider.Get_Data(query, connect);
                if (dt.Rows.Count == 0)
                {
                    return(null);
                }
                else
                {
                    List <Account_DTO> USERS = new List <Account_DTO>();
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        Account_DTO user = new Account_DTO();
                        user.Id       = dt.Rows[i]["ID"].ToString();
                        user.Username = dt.Rows[i]["USERNAME"].ToString();
                        user.Right    = dt.Rows[i]["RIGHTS"].ToString();
                        user.Password = dt.Rows[i]["PASS"].ToString();
                        user.Fullname = dt.Rows[i]["FULLNAME"].ToString();

                        USERS.Add(user);
                    }
                    return(USERS);
                }
            }
        }
コード例 #2
0
        public static bool Delete_Account(Account_DTO a)
        {
            String query = "delete from ACOUNT where ID=N'" + a.Id + "'";

            using (SqlConnection connect = DataProvider.CONNECT())
            {
                try
                {
                    DataProvider.Excute_Query(query, connect);
                    return(true);
                }
                catch (Exception ex)
                {
                    return(false);
                }
            }
        }
コード例 #3
0
        public static bool Edit_User(Account_DTO a)
        {
            String query = " update ACOUNT set ID = N'" + a.Id + "', USERNAME = '******',FULLNAME = '" + a.Fullname + " ',RIGHTS = '" + a.Right + "',PASS = '******' WHERE ID = N'" + a.Id + "'";

            using (SqlConnection connect = DataProvider.CONNECT())
            {
                try
                {
                    DataProvider.Excute_Query(query, connect);
                    return(true);
                }
                catch (Exception ex)
                {
                    return(false);
                }
            }
        }
コード例 #4
0
        public static bool Add_USER(Account_DTO a)
        {
            String query = "insert into ACOUNT values(N'" + a.Id + "',N'" + a.Username + "',N'" + a.Fullname + "',N'" + a.Right + "',N'" + a.Password + "')";

            using (SqlConnection connect = DataProvider.CONNECT())
            {
                try
                {
                    DataProvider.Excute_Query(query, connect);
                    return(true);
                }
                catch (Exception ex)
                {
                    return(false);
                }
            }
        }