.NET进销存系统开发笔记------之Gridview应用

技术2022-05-11 62

.NET进销存系统开发笔记------之Gridview应用

本人学习ASP.NET也是刚刚开始,尽管如此但还是按耐不住要把以前用ASP开发的基于WEB的进销存及OA系统用ASP.NET重写,此次重写将不仅是代码部份重写,数据库也将重新优化(主要是将会大量采用存储过程).我会将开发过程的大部分笔记和大家一起分享,本人才粗学浅,C#也是刚刚开始学习.如果有什么不对请大家不要见笑,还望多指教.

GridView应用一本文将实现Gridview上添加/编辑/删除点序号排序后添加编辑删除先看数据结构(上表的序号为Sequence字段作为排序用,不是UnitID编号)代码部分:

<% @ Page Language="C#" %> <% @ Import Namespace="System.Data.SqlClient" %> <% @ Import Namespace="DBOperate" %> <% @ Import Namespace="NgcOA.Msg" %> <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > < script src ="../Js/GridViewHelper.js" type ="text/javascript" ></ script > < script runat ="server" > protected void Page_Load(object sender, EventArgs e) { } protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.Header) AddGlyph(GridView1, e.Row); if (e.Row.RowType == DataControlRowType.DataRow) { string KeyValue = GridView1.DataKeys[e.Row.RowIndex].Value.ToString(); if (KeyValue == "0" && EditIndex == -1) // we are not editing e.Row.Attributes.Add("isadd", "1"); //string RowID = Convert.ToString(System.Web.UI.DataBinder.Eval(e.Row.DataItem, "UnitID")); //string Url = "Details.aspx?ID=" + RowID; // create the Url to be executed when the "+" is clicked (YOU WILL CUSTOMIZE THIS TO YOUR NEEDS) //e.Row.Attributes.Add("href", Url); // link to details //e.Row.Attributes.Add("open", "0"); // used by the detail table expander/contracter //e.Row.Attributes.Add("hascontent", "0"); // used to prevent excessive callbacks to the server } } public int EditIndex = -1; void AddGlyph(GridView grid, GridViewRow item) { if (grid.AllowSorting == false) return; Label glyph = new Label(); glyph.EnableTheming = false; glyph.Font.Name = "webdings"; glyph.Font.Size = FontUnit.XSmall; glyph.Text = (grid.SortDirection == SortDirection.Ascending ? "5" : " 6"); // Find the column you sorted by for (int i = 0; i < grid.Columns.Count; i++) { string colExpr = grid.Columns[i].SortExpression; if (colExpr != "" && colExpr == grid.SortExpression) { item.Cells[i].Controls.Add(glyph); } } } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string KeyValue = GridView1.DataKeys[e.RowIndex].Value.ToString(); if (KeyValue != "0") return; // key value of 0 indicates the insert row DBObject myDb = new DBObject(); myDb.SelectString = "SELECT UnitName FROM Base_ProductUnit WHERE UnitName='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[1]).Text + "'"; myDb.GetDR(); if (myDb.SelectEmpty()) { SqlDataSource ds = (SqlDataSource)FindControl(GridView1.DataSourceID); SqlConnection conn = new SqlConnection(ds.ConnectionString); conn.Open(); string s = ds.InsertCommand; SqlCommand c = new SqlCommand(s, conn); SqlParameter p; foreach (System.Collections.DictionaryEntry x in e.NewValues) { p = new SqlParameter("@" + x.Key, x.Value); c.Parameters.Add(p); } c.ExecuteNonQuery(); } else { string msg = Message.Show("您要添加的记录已经存在，无法无成此次操作！"); Response.Write(msg); } myDb.DBClose(); } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { EditIndex = e.NewEditIndex; } </ script > < html xmlns ="http://www.w3.org/1999/xhtml" > < head runat ="server" > < title > 无标题页 </ title > < link href ="../Css/System.css" rel ="STYLESHEET" type ="text/css" /> </ head > < body > < form id ="form1" runat ="server" > < div > < asp:GridView ID ="GridView1" runat ="server" AllowPaging ="True" AllowSorting ="True" AutoGenerateColumns ="False" DataSourceID ="BaseUnitDS" OnRowCreated ="GridView1_RowCreated" OnRowEditing ="GridView1_RowEditing" OnRowUpdating ="GridView1_RowUpdating" DataKeyNames ="UnitID" Width ="180px" PageSize ="20" > < Columns > < asp:CommandField ButtonType ="Image" CancelImageUrl ="~/Images/Cancel.gif" DeleteImageUrl ="~/Images/Delete.gif" EditImageUrl ="~/Images/Edit.gif" ShowDeleteButton ="True" ShowEditButton ="True" UpdateImageUrl ="~/Images/Update.gif" > < HeaderStyle BackColor ="#E0E0E0" HorizontalAlign ="Left" VerticalAlign ="Top" /> < ItemStyle HorizontalAlign ="Left" VerticalAlign ="Top" Width ="40px" /> </ asp:CommandField > < asp:BoundField DataField ="UnitID" HeaderText ="编号" InsertVisible ="False" ReadOnly ="True" SortExpression ="UnitID" Visible ="False" /> < asp:TemplateField HeaderText ="序号" SortExpression ="Sequence" > < EditItemTemplate > < asp:TextBox ID ="EditSequence" CssClass ="base_tb" runat ="server" MaxLength ="15" Text ='<%# Bind("Sequence") % > ' Width="40px"> </ asp:TextBox > < asp:CompareValidator ID ="CompareValidator1" runat ="server" ControlToValidate ="EditSequence" ErrorMessage ="*" Operator ="DataTypeCheck" Type ="Integer" ></ asp:CompareValidator > </ EditItemTemplate > < ItemStyle HorizontalAlign ="Left" VerticalAlign ="Top" Width ="60px" /> < HeaderStyle HorizontalAlign ="Left" VerticalAlign ="Top" /> < ItemTemplate > < asp:Label ID ="Sequence" runat ="server" Text ='<%# Bind("Sequence") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > < asp:TemplateField HeaderText ="单位名称" SortExpression ="UnitName" > < EditItemTemplate > < asp:TextBox ID ="EditUnitName" CssClass ="base_tb" runat ="server" MaxLength ="15" Text ='<%# Bind("UnitName") % > ' Width="40px"> </ asp:TextBox > < asp:RequiredFieldValidator ID ="UnitNameRequiredFieldValidator" runat ="server" ControlToValidate ="EditUnitName" Display ="Dynamic" ErrorMessage ="此处不能为空!" SetFocusOnError ="True" ></ asp:RequiredFieldValidator > </ EditItemTemplate > < ItemStyle HorizontalAlign ="Left" VerticalAlign ="Top" Width ="80px" /> < HeaderStyle HorizontalAlign ="Left" VerticalAlign ="Top" /> < ItemTemplate > < asp:Label ID ="UnitName" runat ="server" Text ='<%# Bind("UnitName") % > '> </ asp:Label > </ ItemTemplate > </ asp:TemplateField > </ Columns > < HeaderStyle BackColor ="#E0E0E0" /> </ asp:GridView > </ div > < asp:SqlDataSource ID ="BaseUnitDS" runat ="server" ConnectionString ="<%$ ConnectionStrings:NgcDataConnectionString %>" SelectCommand ="WM_ProductUnit_Select" SelectCommandType ="StoredProcedure" UpdateCommand ="UPDATE [Base_ProductUnit] SET [UnitName]=@UnitName,[Sequence]=@Sequence WHERE [UnitID]=@UnitID" DeleteCommand ="DELETE FROM [Base_ProductUnit] WHERE [UnitID]=@UnitID" InsertCommand ="INSERT INTO [Base_ProductUnit] ([UnitName],[Sequence]) VALUES (@UnitName,@Sequence)" > </ asp:SqlDataSource > </ form > < script type ="text/javascript" > GridViewHelper.Init(document.all.GridView1, 100, 0); </ script > </ body > </ html >

注明一下一些用到的js或类GridViewHelper.js出处:http://www.thecodeproject.com/aspnet/MasterDetail.asp代码如下:(这个js很有用,可以实现Gridview上增加新建记录的图标,嵌套从表及自适应高度和宽度,产生标题的tooltips等)

<%@ Import Namespace="DBOperate" %>借用网上一个网友的数据库控制类，自己实在懒得写，碰巧看到也就拿来自己用了(在判断添加新数据时是否重复用到)

using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Web.UI.WebControls; namespace DBOperate { /**/ /// <summary> /// 创建一个数据库对象，以实现数据操作。 /// </summary> public class DBObject { private string ConnectionString; private SqlConnection objConn; private string objSelectString; private string objInsertString; private string objUpdateString; private string objDeleteString; private SqlDataReader objDR; private SqlCommand objCmd; private string objErrMessage = null; private string tempErrMessage = null; private SqlDataAdapter objDA; private DataSet objDS; private DataView objDW; private GridView objGV; private string objViewRowFilter = null; private string objViewSort = null; public DBObject() { // // TODO: 在此处添加构造函数逻辑 // DBConn(); } private void DBConn() { ConnectionString = ConfigurationManager.ConnectionStrings["NgcDataConnectionString"].ConnectionString; objConn = new SqlConnection(ConnectionString); objConn.Open(); } public void DBClose() { objConn.Close(); } public string SelectString { set { objSelectString = value; } } public string InsertString { set { objInsertString = value; DBInsert(); } } public string UpdateString { set { objUpdateString = value; DBUpdate(); } } public string DeleteString { set { objDeleteString = value; DBDelete(); } } public string ErrMessage { get { tempErrMessage = objErrMessage; objErrMessage = null; return tempErrMessage; } } public SqlDataReader DR { get { GetDR(); return objDR; } } public void DRClose() { objDR.Close(); } public void GetDR() { try { using (objCmd = new SqlCommand(objSelectString, objConn)) { objDR = objCmd.ExecuteReader(); } } catch (System.Exception e) { objErrMessage += "数据读取出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } } public void objDRRead() { objDR.Read(); } public bool SelectEmpty() { if (objDR.Read()) return false; else return true; } public string GetDRItem(string objDRItem) { return objDR[objDRItem].ToString(); } public DataSet DS { get { try { using (objDA = new SqlDataAdapter(objSelectString, objConn)) { objDS = new DataSet(); objDA.Fill(objDS); } } catch (System.Exception e) { objErrMessage += "数据读取出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } return objDS; } } public DataView DW { get { try { using (objDA = new SqlDataAdapter(objSelectString, objConn)) { objDS = new DataSet(); objDA.Fill(objDS); objDW = new DataView(objDS.Tables[0]); objDW.RowFilter = objViewRowFilter; objDW.Sort = objViewSort; } } catch (System.Exception e) { objErrMessage += "数据读取出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } return objDW; } } public GridView DGridBindDS { set { objGV = value; BindDS(); } } public GridView DGridBindDR { set { objGV = value; BindDR(); } } public string ViewRowFilter { set { if (objViewRowFilter == null) { objViewRowFilter = value; } else { objViewRowFilter += " and "; objViewRowFilter += value; } } } public string ViewSort { set { objViewSort = value; } } private void BindDR() { try { using (objCmd = new SqlCommand(objSelectString, objConn)) { objDR = objCmd.ExecuteReader(); objGV.DataSource = objDR; objGV.DataBind(); objDR.Close(); } } catch (System.Exception e) { objErrMessage += "数据读取出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } } private void BindDS() { try { using (objDA = new SqlDataAdapter(objSelectString, objConn)) { objDS = new DataSet(); objDA.Fill(objDS); objGV.DataSource = objDS; objGV.DataBind(); } } catch (System.Exception e) { objErrMessage += "数据读取出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } } private void DBInsert() { using (objCmd = new SqlCommand(objInsertString, objConn)) { try { objCmd.ExecuteNonQuery(); } catch (System.Exception e) { objErrMessage += "数据插入出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } } } private void DBUpdate() { using (objCmd = new SqlCommand(objUpdateString, objConn)) { try { objCmd.ExecuteNonQuery(); } catch (System.Exception e) { objErrMessage += "数据更新出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } } } private void DBDelete() { using (objCmd = new SqlCommand(objDeleteString, objConn)) { try { objCmd.ExecuteNonQuery(); } catch (System.Exception e) { objErrMessage += "数据删除出错："; objErrMessage += "<br>"; objErrMessage += e.Message; objErrMessage += "<br>"; } } } }}

<%@ Import Namespace="NgcOA.Msg" %>弹出消息的类，也是用网上现成的．

using System; using System.Data; using System.Configuration; 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; namespace NgcOA.Msg { /// <summary> /// Message 的摘要说明 /// </summary> public class Message { public Message() { // // TODO: 在此处添加构造函数逻辑 // } public static string Show(string strMsg) { //这里0就指strMsg这东西,1就是指/这东西. return String.Format("<script language={1}javascript{1}>alert({1}{0}{1});</script>", strMsg, "/""); } }}

此外还将用到一个存储过程

CREATE PROCEDURE WM_ProductUnit_Select AS declare @num int begin set @num = ( SELECT isnull ( MAX (Sequence), 0 ) FROM Base_ProductUnit) + 1 SELECT ' 0 ' AS [ UnitID ] , '' AS [ UnitName ] , str ( @num ) AS [ Sequence ] UNION SELECT [ UnitID ] , [ UnitName ] , [ Sequence ] FROM [ Base_ProductUnit ] ORDER BY [ Sequence ] DESC end GO

下次将介绍实现如下的嵌套效果

发表于 2006-04-24 22:09 李振波阅读(1905) 评论(5) 编辑收藏引用网摘所属分类: .NET进销存系统开发笔记

专利

最新回复(0)