5.2.4 ERP系统中C#应用实例(1)
在ERP系统中,我们使用C#开发了大量的后端类(Code Behind),例如assistantMaterial. aspx.cs,代码如下:
- using System;
- using System.Collections;
- using System.Configuration;
- using System.Data;
- using System.Linq;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.HtmlControls;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Xml.Linq;
-
- public partial class system_basisdata_treasury_
assistantMaterial : System. Web.UI.Page - {
- protected void Page_Load(object sender, EventArgs e)
- {
- DB.GridViewCoulumnWidth(GridView1);//定义列宽
-
- if (!IsPostBack)
- {
- DB db = new DB();
- string str = "select * from a_assistanMaterial ";
- this.GridView1.DataSource = db.GetDataSet(str).
Tables[0].DefaultView; - this.GridView1.DataKeyNames = new String[] { "Aid" };
- this.GridView1.DataBind();
- // this.SetVisible(false);
-
- }
-
- }
-
- protected void add_Click(object sender, EventArgs e)
- {
- Response.Redirect("assistantMaterialOper.aspx?
aid="+" "+"&info=add"); - }
- protected void delete_Click(object sender, EventArgs e)
- {
-
- DB db = new DB();
- for (int i = 0; i < GridView1.Rows.Count; i++)
- {
- string delSql = "delete from a_assistanMaterial where Aid=";
- //Response.Write("te-");
- CheckBox checkbox = (CheckBox)GridView1.Rows[i].
FindControl ("CheckBox1"); - //Response.Write(checkbox.Checked+";");
- if (checkbox.Checked == true)
- {
- int id = Convert.ToInt32(GridView1.Rows[i].Cells[1].Text);
- delSqldelSql = delSql + id;
- db.Exec(delSql);
- }
- }
-
- this.initPage();
- }
-
- protected void initPage()
- {
- DB db = new DB();
- string str = "select * from a_assistanMaterial ";
- this.GridView1.DataSource = db.GetDataSet(str).Tables[0].DefaultView;
- this.GridView1.DataKeyNames = new String[] { "Aid" };
- this.GridView1.DataBind();
- }
-
- protected void GridView_PageIndexChanging(object sender,
GridViewPage EventArgs e) - {
- GridView1.PageIndex = e.NewPageIndex;
- this.initPage();
- }
- protected void GridView_OnRowCommand(Object sender,
GridViewCommand EventArgs e) - {
- int index = Convert.ToInt32(e.CommandArgument);
- int hid = (int)GridView1.DataKeys[index].Value;
-
- if (e.CommandName == "findInfo")
- {
- Response.Redirect("assistantMaterialOper.
aspx?aid="+hid+" &info=findInfo"); -
- }
- else if(e.CommandName =="addName"){
- Response.Redirect("assistantMaterialOper.
aspx?aid="+hid+" &info=addName"); -
- }
- else if (e.CommandName == "addInfo") {
- Response.Redirect("assistantMaterialOper.
aspx?aid="+hid+ "&info=addInfo"); -
- }
- }
- }
【责任编辑:
云霞 TEL:(010)68476606】