本帖最后由 jq2046 于 2010-05-18 15:56:34 编辑

解决方案 »

  1.   

    CS文件内容如下:using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Configuration;
    using System.Collections;
    using System.Web;
    using System.Web.Security;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Web.UI.WebControls.WebParts;
    using System.Web.UI.HtmlControls;public partial class DepartmentView : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                Department department = new Department();
                DataSet ds_Department = department.GetDataSet("");
    //GV_Department.DataSource = ds_Department.Tables["T_Department"];
        GV_Department.DataSource = ds_Department.Tables["hr.dbo.v_hr_bm"];
                GV_Department.DataBind();
                //lbl_Count.Text = ds_Department.Tables["T_Department"].Rows.Count.ToString();
        lbl_Count.Text = ds_Department.Tables["hr.dbo.v_hr_bm"].Rows.Count.ToString();
    SignDropDownList sign = new SignDropDownList();
    DataSet ds_Sign = sign.GetDataSet("");
    //GV_Sign.DataSource = ds_Sign.Tables["hr.dbo.hr_bz"];
    //GV_Sign.DataBind();
    }
            if (Request.Cookies["Rank_Code"] != null)
            {
                publicFunction pFunction = new publicFunction();
                String strRankCode = Request.Cookies["Rank_Code"].Value;
                String strFunctionCode = "Department";
                String strReturn = pFunction.GetPurview(strRankCode, strFunctionCode);
                if (strReturn.Contains("fail"))
                    Response.Redirect("PurviewError.aspx");
            }
        }
        protected void GV_Department_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
        {
            int Int_SelectIndex = e.NewSelectedIndex;        Response.Cookies["RowIndex"].Value = Int_SelectIndex.ToString();        Department department = new Department();
            DataSet ds_Department = department.GetDataSet("");
            GV_Department.DataSource = ds_Department.Tables["T_Department"];
            GV_Department.DataBind();
        }
        protected void GV_Department_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            int Int_RowIndex = -1;
            GV_Department.EditIndex = Int_RowIndex;        Department department = new Department();
            DataSet ds_Department = department.GetDataSet("");
            GV_Department.DataSource = ds_Department.Tables["T_Department"];
            GV_Department.DataBind();
        }
        protected void GV_Department_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int Int_RowIndex = e.RowIndex;        Department department = new Department();        //删除部门
            department.RowIndex = Int_RowIndex;
            String strReturn = department.DepartmentDelete();
            if (strReturn.Contains("ok"))
            {
                //获取新的部门信息列表
                DataSet ds_Department = new DataSet();
                ds_Department = department.GetDataSet("");
                GV_Department.DataSource = ds_Department.Tables["T_Department"];
                GV_Department.DataBind();
            }
            else if (strReturn.Contains("fail"))
            {
                Response.Write(strReturn.Replace("fail", ""));
            }
        }
        protected void lbDepartmentAdd_Click(object sender, EventArgs e)
        {
            Response.Redirect("DepartmentEdit.aspx?Command=INSERT");
        }
        protected void lbDepartmentEdit_Click(object sender, EventArgs e)
        {
            //GridView GV_Department = (GridView)this.Parent.Controls[3].Controls[1];
            Response.Redirect("DepartmentEdit.aspx?Command=UPDATE&RowIndex=" + GV_Department.SelectedIndex.ToString());
        }
    }
      

  2.   

    <asp:TemplateField HeaderText="有效标志">
                                        <ItemTemplate>
                                            <asp:DropDownList ID="ddl1" runat="server" Visible="false" ></asp:DropDownList >     
                                          </ItemTemplate>
    </asp:TemplateField>
      

  3.   

    我用的是 Editplus 在看程序 VS2008  不知道 如何在设计界面把该列该成模板列 Sorry!!!
      

  4.   

    <ItemTemplate> 
    <asp:DropDownList ID="ddlSort" runat="server" Width="98%">
      </asp:DropDownList>
     <asp:HiddenField ID="Hd_Sort" runat="server" Value='<%# Eval("BalSort")%>' />
    </ItemTemplate>
     protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
      {
      if (e.Row.RowIndex != -1)
      { if (e.Row.RowState == DataControlRowState.Edit || e.Row.RowState == (DataControlRowState.Alternate | DataControlRowState.Edit))
      {
      ((DropDownList)e.Row.FindControl("ddlSort")).SelectedValue = ((HiddenField)e.Row.FindControl("Hd_Sort")).Value;
      }
      }
      } protected void gv_RowEditing(object sender, GridViewEditEventArgs e)
      {
      gv.EditIndex = e.NewEditIndex;
      string strSort = ((DropDownList)gv.Rows[e.NewEditIndex].FindControl("ddlSort")).SelectedValue.Trim();
      gv.EditIndex = -1;
      BindData();
      }