开发总结

.给GirdView设置主键列，然后偶获取主键列的值

gdvPO.DataKeyNames = new string[] { "F_ID", "F_YSDETAILID" };

  string id = gdvPO.DataKeys[e.RowIndex].Values["F_ID"].ToString();

给DataGrid或GirdView设置序号列

RowDataBound事件里

//设置序号

        if (e.Row.RowIndex != -1)

        {

            int id = e.Row.RowIndex + 1;

            e.Row.Cells[0].Text = id.ToString();

        }

 

鼠标移动改变GirdView背景色

        //如果是绑定数据行

        if (e.Row.RowType == DataControlRowType.DataRow)

        {

            //当鼠标停留时更改背景色

  e.Row.Attributes.Add("onmouseover","c=this.style.backgroundColor;this.style.backgroundColor='#FFFF99'");

            //当鼠标移开时还原背景色

            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");

        }

给DataGird和GirdView排序

protected void gdvPO_Sorting(object sender, GridViewSortEventArgs e)

    {

 

        // 从事件参数获取排序数据列

        string sortExpression = e.SortExpression.ToString();

        // 假定为排序方向为“顺序”

        string sortDirection = "ASC";

        // “ASC”与事件参数获取到的排序方向进行比较，进行GridView排序方向参数的修改

        if (sortExpression == this.gdvPO.Attributes["SortExpression"])

        {

            //获得下一次的排序状态

            sortDirection =(this.gdvPO.Attributes["SortDirection"].ToString()== sortDirection ? "DESC" : "ASC");

        }

        // 重新设定GridView排序数据列及排序方向

        this.gdvPO.Attributes["SortExpression"] = sortExpression;

        this.gdvPO.Attributes["SortDirection"] = sortDirection;

         this.LoadPOList();

}

protected void showMessage(string message)

{

 string js = @"<script language=javascript>

function showMessage()

{

alert(""" + message + @""");

}

</script>";

this.Response.Write(js);

}

 public void SaveSYTZ(ParamSYTZInfo param)

        {

            IDataAccess iDataAccess = DataAccessHelper.CreateDataAccess((connectionName));

            SqlParameter paramID = new SqlParameter("@F_ID", SqlDbType.Int, 4);

            paramID.Value = param.F_ID;

 

            SqlParameter paramF_SYTZBTMC = new SqlParameter("@F_SYTZBTMC", SqlDbType.VarChar, 200);

            paramF_SYTZBTMC.Value = param.F_SYTZBTMC == "" ? null : param.F_SYTZBTMC;

 

            SqlParameter paramF_SYTZNR = new SqlParameter("@F_SYTZNR", SqlDbType.Text, param.F_SYTZNR.Length);

            paramF_SYTZNR.Value = param.F_SYTZNR == "" ? null : param.F_SYTZNR;

 

            SqlParameter paramF_FBR = new SqlParameter("@F_FBR", SqlDbType.VarChar, 50);

            paramF_FBR.Value = param.F_FBR;

 

            SqlParameter paramF_NAME = new SqlParameter("@F_NAME", SqlDbType.VarChar, 200);

            paramF_NAME.Value = param.F_NAME == "" ? null : param.F_NAME;

 

            SqlParameter paramF_COUNT = new SqlParameter("@F_COUNT", SqlDbType.Image, param.F_COUNT.Length);

            paramF_COUNT.Value =   param.F_COUNT;

            SqlParameter[] list = new SqlParameter[6];

            list[0] = paramID;

            list[1] = paramF_SYTZBTMC;

            list[2] = paramF_SYTZNR;

 

            list[3] = paramF_FBR;

            list[4] = paramF_NAME;

            list[5] = paramF_COUNT;

            try

            {

                iDataAccess.ExecuteNonQuery(CommandType.StoredProcedure, P_IN_SYTZ_Save, list);

            }

            catch (SqlException ex)

            {

                ExceptionHelper.Publish("IN_01_01", ex);

            }

            catch (Exception ex)

            {

                ExceptionHelper.Publish("IN_01_01", ex, ErrorTypeDefine.INNER_ERROR);

            }

        }