Exemplo n.º 1
0
        public DAO.GroupDao selectGroupInfoWithId(string id)
        {
            string tablename = "t_group";

            string sql = "select a.*" +
                         " from " + tablename + " a where id=" + id + " ";

            DataTable _dt = this.SelectQuery(sql);

            if (_dt == null || _dt.Rows.Count <= 0)
            {
                return(null);
            }
            else
            {
                DAO.GroupDao _dao = new DAO.GroupDao();

                _dao.Grouppname   = _dt.Rows[0]["groupname"].ToString();
                _dao.Groupmanager = _dt.Rows[0]["groupmanager"].ToString();
                _dao.Managerphone = _dt.Rows[0]["managerphone"].ToString();
                _dao.Describe     = _dt.Rows[0]["desc"].ToString();

                return(_dao);
            }
        }
Exemplo n.º 2
0
        public bool updateGroupInfo(string id, DAO.GroupDao dao)
        {
            string sql = "update t_group set groupname='" + dao.Grouppname + "',groupmanager='" + dao.Groupmanager + "',managerphone='" + dao.Managerphone + "',`desc`='" + dao.Describe + "' where id=" + id + "  ";

            return(this.updateQuery(sql));
        }