/// <summary>
        /// Load danh sách chuyên mục
        /// </summary>
        private void BindData()
        {
            BOffical ctl = new BOffical();

            grvDocumentKind.DataSource = ctl.Get(0);
            grvDocumentKind.DataBind();
        }
 /// <summary>
 /// Các thao tác trên danh sách
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void grvDocumentKind_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName.Equals("cmdEdit", StringComparison.OrdinalIgnoreCase))
     {
         //BOffical ctl = new BOffical();
         //ctl.Delete(int.Parse(e.CommandArgument.ToString()));
         hdfId.Value = e.CommandArgument.ToString();
         BOffical ctl = new BOffical();
         try
         {
             OOffical obj = ctl.Get(int.Parse(hdfId.Value))[0];
             txtAddress.Text     = obj.Address;
             txtDescription.Text = obj.Description;
             txtEmail.Text       = obj.Email;
             txtFax.Text         = obj.Fax;
             txtName.Text        = obj.Name;
             txtTel.Text         = obj.Tel;
             try {
                 ddlParent.Items.FindByValue(obj.OfficalParent.ToString()).Selected = true;
             }
             catch (Exception ex)
             { }
         }
         catch (Exception ex)
         {
         }
     }
     else if (e.CommandName.Equals("cmdDelete", StringComparison.OrdinalIgnoreCase))
     {
         BOffical ctl = new BOffical();
         ctl.Delete(int.Parse(e.CommandArgument.ToString()));
         BindData();
     }
 }
        private void BindParent()
        {
            BOffical ctl = new BOffical();

            ddlParent.DataSource = ctl.Get(0);
            ddlParent.DataBind();
            ddlParent.Items.Insert(0, new ListItem("Không có cha", ""));
        }
        /// <summary>
        /// Load ra danh sách văn phòng
        /// </summary>
        private void BindOffical()
        {
            BOffical ctl = new BOffical();

            ddlOffical.ClearSelection();
            ddlOffical.DataSource = ctl.Get(0);
            ddlOffical.DataBind();
            //ddlOffical.Items.Insert(0, new ListItem("Tất cả", ""));
        }
        /// <summary>
        /// Lấy về tên lại công văn
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public string GetName(object id)
        {
            BOffical ctl = new BOffical();

            try{
                return(ctl.Get(int.Parse(id.ToString()))[0].Name);
            }catch (Exception ex)
            {
                return("");
            }
        }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            BOffical ctl = new BOffical();

            if (!string.IsNullOrEmpty(txtName.Text))
            {
                OOffical obj = new OOffical();

                if (hdfId.Value != "0")
                {
                    try
                    {
                        obj = ctl.Get(int.Parse(hdfId.Value))[0];
                    }
                    catch (Exception ex)
                    {
                        obj = new OOffical();
                    }
                }
                obj.Name        = txtName.Text;
                obj.Description = txtDescription.Text;
                obj.Address     = txtAddress.Text;
                obj.Email       = txtEmail.Text;
                obj.Fax         = txtFax.Text;
                obj.Tel         = txtTel.Text;
                try {
                    obj.OfficalParent = int.Parse(ddlParent.SelectedValue);
                }
                catch (Exception ea)
                { obj.OfficalParent = 0; }
                if (hdfId.Value != "0")
                {
                    ctl.Update(obj.OfficalID, obj.Name, obj.Description, obj.Address, obj.Tel, obj.Fax, obj.Email, obj.OfficalParent);
                    hdfId.Value = "0";
                }
                else
                {
                    ctl.Add(obj);
                    BindData();
                }
                ResetForm();
            }
        }