protected void Page_Load(object sender, EventArgs e) { string id = ""; //CheckBoxList_Reciever初始化 if (!IsPostBack) { try { id = Request.QueryString[0].ToString(); this.Label1.Text = id; } catch { } if (id == "") { this.begindate.Text = DateTime.Now.ToShortDateString(); this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString(); } else { //绑定CheckBoxList前面的部分 Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll2.GetModel(int.Parse(id)); this.Name.Text = model.Name; this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString(); this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); //绑定是否显示过期 if (model.Outdisplay == "是") { this.CheckBox1.Checked = true; } //绑定CheckBoxList DataSet ds = new DataSet(); Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver(); ds = bll.W_Receiver_Mid(id); this.CheckBoxList_Reciever.DataSource = ds; CheckBoxList_Reciever.DataTextField = "Receiver"; CheckBoxList_Reciever.DataValueField = "Id"; CheckBoxList_Reciever.DataBind(); //添加选定内容 陈湘军 //修改存储过程 W_Receiver_Mid,添加dormacy字段 if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { try { CheckBoxList_Reciever.Items[i].Selected = (ds.Tables[0].Rows[i]["dormacy"].ToString() == "提交"); } catch { } } } } } }
protected void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string btn = e.CommandName; switch (btn) { case "BtnEdit": int Id1 = int.Parse(e.Item.Cells[8].Text.Trim()); Response.Redirect("AddMaterial.aspx?Id=" + Id1); break; case "BtnDel": int Id2 = int.Parse(e.Item.Cells[8].Text.Trim()); Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); bll2.Delete(Id2); Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate(); bll3.Delete(Id2); break; case "BtnManager": int Id3 = int.Parse(e.Item.Cells[8].Text.Trim()); Response.Redirect("Manager.aspx?Id=" + Id3); break; } dataBind(); }
//进行数据绑定的方法 protected void dataBind() { this.DataGrid1.AllowPaging = true; this.DataGrid1.PageSize = 11; DataSet ds = new DataSet(); Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); string key = this.TextBox1.Text.Trim(); Session["AccountsAdminKey"] = key; if (key == "") { ds = bll.GetAllList(); } else { ds = bll.GetMaterialByType(key); } int pageIndex = this.DataGrid1.CurrentPageIndex; Session["AccountsAdminPage"] = pageIndex; DataGrid1.DataSource = ds.Tables[0].DefaultView; int record_Count = ds.Tables[0].Rows.Count; int page_Size = DataGrid1.PageSize; int totalPages = int.Parse(Math.Ceiling((double)record_Count / page_Size).ToString()); if (totalPages > 0) { if (pageIndex > totalPages - 1) { pageIndex = totalPages - 1; } } else { pageIndex = 0; } DataGrid1.CurrentPageIndex = pageIndex; DataGrid1.DataBind(); //显示数量 if (this.DataGrid1.CurrentPageIndex == 0) { btnFirst.Enabled = false; btnPrev.Enabled = false; if (this.DataGrid1.PageCount == 1) { btnLast.Enabled = false; btnNext.Enabled = false; } } else if (this.DataGrid1.CurrentPageIndex == this.DataGrid1.PageCount - 1) { btnLast.Enabled = false; btnNext.Enabled = false; } this.lblpagesum.Text = totalPages.ToString(); this.lblpage.Text = (pageIndex + 1).ToString(); this.lblrowscount.Text = record_Count.ToString(); }
private void ShowNews() { Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); string strWhrere = ""; //显示没有过期的和允许过期显示的:修改人学生 strWhrere = "EndDate>'" + DateTime.Today.AddDays(-7).ToString("yyyy-MM-dd")+"'or Outdisplay='是'" ; //DataSet Ds = bll.GetList(MyintTop, strWhrere, "enddate desc"); //写入了全局变量:修改人学生 ds1=bll.GetList(MyintTop, strWhrere, "enddate desc"); this.GridView1.DataSource = ds1; this.GridView1.DataBind(); //处理记录信息 try { this.lblRowsCount.Text = ds1.Tables[0].Rows.Count.ToString(); } catch { }; this.PageDrop.Items.Clear(); for (int i = 0; i < this.GridView1.PageCount; i++) { ListItem dropitem = new ListItem(); dropitem.Value = i.ToString(); dropitem.Text = (i + 1).ToString(); this.PageDrop.Items.Add(dropitem); } if(this.PageDrop.Items.Count>0) this.PageDrop.SelectedIndex = this.GridView1.PageIndex; }
protected void btnAdd_Click(object sender, EventArgs e) { if (this.Name.Text == "") { this.Label2.Text = "请输入材料名"; return; } //对Material表的输入 DateTime begindate = Convert.ToDateTime(this.begindate.Text); DateTime enddate = Convert.ToDateTime(this.enddate.Text); string name = this.Name.Text.Trim(); string address = this.TextBox_Address.Text.Trim(); string number = this.TextBox_Number.Text.Trim(); // Maticsoft.Model.W_Material material = new Maticsoft.Model.W_Material(); Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); model.Name = name; model.Begindate = begindate; model.Enddate = enddate; model.Address = address; model.Number = number; int id; Maticsoft.Model.W_Receivestate receivestate = new Maticsoft.Model.W_Receivestate(); Maticsoft.BLL.W_Receivestate bllstate = new Maticsoft.BLL.W_Receivestate(); if (this.Label_materialId.Text == "") { //添加 id = bll.Add(model); } else //修改 { id = int.Parse(this.Label_materialId.Text.Trim()); model.Id = int.Parse(this.Label_materialId.Text.Trim()); bll.Update(model); //对W_Receivestate表的操作 添加时是否需要 bllstate.delete?? bllstate.Delete(id); } receivestate.MaterialId = id; for (int i = 0; i < this.CheckBoxList_Reciever.Items.Count; i++) { if (this.CheckBoxList_Reciever.Items[i].Selected) { receivestate.ReceiverId = this.CheckBoxList_Reciever.Items[i].Value; bllstate.Add(receivestate); } } if (id > 1) { //this.Label_Msg.Text = "提交成功!"; } Response.Redirect("ManagerMaterial.aspx"); }
private void ShowNews() { Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); string strWhrere = ""; //显示没有过期的和允许过期显示的:修改人学生 strWhrere = "EndDate>'" + DateTime.Today.AddDays(-7).ToString("yyyy-MM-dd") + "'or Outdisplay='是'"; //DataSet Ds = bll.GetList(MyintTop, strWhrere, "enddate desc"); //写入了全局变量:修改人学生 ds1 = bll.GetList(MyintTop, strWhrere, "enddate desc"); this.GridView1.DataSource = ds1; this.GridView1.DataBind(); //处理记录信息 try { this.lblRowsCount.Text = ds1.Tables[0].Rows.Count.ToString(); } catch { }; this.PageDrop.Items.Clear(); for (int i = 0; i < this.GridView1.PageCount; i++) { ListItem dropitem = new ListItem(); dropitem.Value = i.ToString(); dropitem.Text = (i + 1).ToString(); this.PageDrop.Items.Add(dropitem); } if (this.PageDrop.Items.Count > 0) { this.PageDrop.SelectedIndex = this.GridView1.PageIndex; } }
protected void Page_Load(object sender, EventArgs e) { string id = ""; //CheckBoxList_Reciever初始化 if (!IsPostBack) { try { id = Request.QueryString[0].ToString(); this.Label1.Text = id; } catch { } DataSet ds = new DataSet(); Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver(); ds = bll.GetAllList(); this.CheckBoxList_Reciever.DataSource = ds; CheckBoxList_Reciever.DataTextField = "Receiver"; CheckBoxList_Reciever.DataValueField = "Id"; CheckBoxList_Reciever.DataBind(); if (id == "") { this.TextBox_Address.Text = "http://kjc.jstu.edu.cn/news.aspx?id=205"; this.TextBox_Number.Text = "申报书一式三份,活页7份"; this.begindate.Text = DateTime.Now.ToShortDateString(); this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString(); } else { Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll2.GetModel(int.Parse( id)); this.Name.Text = model.Name; this.begindate.Text = (Convert.ToDateTime( model.Begindate)).ToShortDateString(); this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); this.TextBox_Address.Text = model.Address; this.TextBox_Number.Text = model.Number; DataSet ds2 = new DataSet(); Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate(); ds2 = bll3.GetList("MaterialId=" + id); for (int i = 0; i < ds2.Tables[0].Rows.Count; i++) { int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString()); this.CheckBoxList_Reciever.Items[j-1].Selected=true ; } } } }
protected void btnAdd_Click(object sender, EventArgs e) { if (this.Name.Text == "") { this.Label2.Text = "请输入材料名"; return; } //过期是否显示的判断 Maticsoft.BLL.W_Material bllmaterial = new Maticsoft.BLL.W_Material(); if (this.CheckBox1.Checked) { bllmaterial.ReleaseList(int.Parse(this.Label1.Text)); } else { bllmaterial.NoReleaseList((int.Parse(this.Label1.Text))); } Maticsoft.Model.W_Receivestate receivestate = new Maticsoft.Model.W_Receivestate(); Maticsoft.BLL.W_Receivestate bllstate = new Maticsoft.BLL.W_Receivestate(); //4-3修改by 陈湘军 for (int i = 0; i < this.CheckBoxList_Reciever.Items.Count; i++) { receivestate.ReceiverId = this.CheckBoxList_Reciever.Items[i].Value; receivestate.MaterialId = int.Parse(this.Label1.Text.Trim()); if (this.CheckBoxList_Reciever.Items[i].Selected) { receivestate.Dormacy = "提交"; receivestate.IssureTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString()); } else { receivestate.Dormacy = ""; } bllstate.Update(receivestate); } if (int.Parse(this.Label1.Text) > 1) { //this.Label_Msg.Text = "提交成功!"; } Response.Redirect("AllList.aspx"); }
protected void Page_Load(object sender, EventArgs e) { string id = ""; //CheckBoxList_Reciever初始化 if (!IsPostBack) { try { id = Request.QueryString[0].ToString(); this.Label1.Text = id; } catch { } DataSet ds = new DataSet(); Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver(); ds = bll.GetAllList(); this.CheckBoxList_Reciever.DataSource = ds; CheckBoxList_Reciever.DataTextField = "Receiver"; CheckBoxList_Reciever.DataValueField = "Id"; CheckBoxList_Reciever.DataBind(); if (id == "") { this.TextBox_Address.Text = "http://kjc.jstu.edu.cn/news.aspx?id=205"; this.TextBox_Number.Text = "申报书一式三份,活页7份"; this.begindate.Text = DateTime.Now.ToShortDateString(); this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString(); } else { Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll2.GetModel(int.Parse(id)); this.Name.Text = model.Name; this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString(); this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); this.TextBox_Address.Text = model.Address; this.TextBox_Number.Text = model.Number; DataSet ds2 = new DataSet(); Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate(); ds2 = bll3.GetList("MaterialId=" + id); for (int i = 0; i < ds2.Tables[0].Rows.Count; i++) { int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString()); this.CheckBoxList_Reciever.Items[j - 1].Selected = true; } } } }
//进行数据绑定的方法 protected void dataBind() { this.DataGrid1.AllowPaging = true; this.DataGrid1.PageSize = 11; DataSet ds = new DataSet(); Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); string key = this.TextBox1.Text.Trim(); Session["AccountsAdminKey"] = key; if (key == "") ds = bll.GetAllList(); else ds = bll.GetMaterialByType(key); int pageIndex = this.DataGrid1.CurrentPageIndex; Session["AccountsAdminPage"] = pageIndex; DataGrid1.DataSource = ds.Tables[0].DefaultView; int record_Count = ds.Tables[0].Rows.Count; int page_Size = DataGrid1.PageSize; int totalPages = int.Parse(Math.Ceiling((double)record_Count / page_Size).ToString()); if (totalPages > 0) { if (pageIndex > totalPages - 1) pageIndex = totalPages - 1; } else { pageIndex = 0; } DataGrid1.CurrentPageIndex = pageIndex; DataGrid1.DataBind(); //显示数量 if (this.DataGrid1.CurrentPageIndex == 0) { btnFirst.Enabled = false; btnPrev.Enabled = false; if (this.DataGrid1.PageCount == 1) { btnLast.Enabled = false; btnNext.Enabled = false; } } else if (this.DataGrid1.CurrentPageIndex == this.DataGrid1.PageCount - 1) { btnLast.Enabled = false; btnNext.Enabled = false; } this.lblpagesum.Text = totalPages.ToString(); this.lblpage.Text = (pageIndex + 1).ToString(); this.lblrowscount.Text = record_Count.ToString(); }
protected void Page_Load(object sender, EventArgs e) { string id = ""; //CheckBoxList_Reciever初始化 if (!IsPostBack) { try { id = Request.QueryString[0].ToString(); this.Label1.Text = id; } catch { } if (id == "") { this.begindate.Text = DateTime.Now.ToShortDateString(); this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString(); } else { //绑定CheckBoxList前面的部分 Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll2.GetModel(int.Parse(id)); this.Name.Text = model.Name; this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString(); this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); //绑定CheckBoxList DataSet ds = new DataSet(); Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver(); ds = bll.W_Receiver_Mid(id); this.CheckBoxList_Reciever.DataSource = ds; CheckBoxList_Reciever.DataTextField = "Receiver"; CheckBoxList_Reciever.DataValueField = "Id"; CheckBoxList_Reciever.DataBind(); } } }
protected void Bind(int Id) { Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblName.Text = model.Name; this.lblBeginDate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString(); this.lblEnddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); this.Label_Address.Text = model.Address; this.Label_Number.Text = model.Number; DataSet ds2 = new DataSet(); Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate(); ds2 = bll3.GetList("MaterialId=" + Id); for (int i = 0; i < ds2.Tables[0].Rows.Count; i++) { int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString()); Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver(); Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver(); model4 = bll4.GetModel(j); this.lblReceiver.Text += model4.Receiver + " "; } DataSet ds5 = new DataSet(); Maticsoft.BLL.W_Receivestate bll5 = new Maticsoft.BLL.W_Receivestate(); ds5 = bll5.GetList("MaterialId=" + Id + "and Dormacy = '提交'"); for (int i = 0; i < ds5.Tables[0].Rows.Count; i++) { int j = int.Parse(ds5.Tables[0].Rows[i][2].ToString()); Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver(); Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver(); model4 = bll4.GetModel(j); this.Label_IsHanded.Text += model4.Receiver + " "; } }
protected void Page_Load(object sender, EventArgs e) { string id = ""; //CheckBoxList_Reciever初始化 if (!IsPostBack) { try { id = Request.QueryString[0].ToString(); this.Label1.Text = id; } catch { } if (id == "") { this.begindate.Text = DateTime.Now.ToShortDateString(); this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString(); } else { //绑定CheckBoxList前面的部分 Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll2.GetModel(int.Parse(id)); this.Name.Text = model.Name; this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString(); this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); //绑定CheckBoxList DataSet ds = new DataSet(); Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver(); ds = bll.W_Receiver_Mid(id); this.CheckBoxList_Reciever.DataSource = ds; CheckBoxList_Reciever.DataTextField = "Receiver"; CheckBoxList_Reciever.DataValueField = "Id"; CheckBoxList_Reciever.DataBind(); } } }
protected void Bind(int Id) { Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblName.Text = model.Name; this.lblBeginDate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString(); this.lblEnddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); this.Label_Address.Text = model.Address; this.Label_Number.Text = model.Number; DataSet ds2 = new DataSet(); Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate(); ds2 = bll3.GetList("MaterialId=" + Id); for (int i = 0; i < ds2.Tables[0].Rows.Count; i++) { int j = int.Parse(ds2.Tables[0].Rows[i][2].ToString()); Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver(); Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver(); model4 = bll4.GetModel(j); this.lblReceiver.Text += model4.Receiver + " "; } DataSet ds5 = new DataSet(); Maticsoft.BLL.W_Receivestate bll5 = new Maticsoft.BLL.W_Receivestate(); ds5 = bll5.GetList("MaterialId=" + Id + "and Dormacy = '提交'"); for (int i = 0; i < ds5.Tables[0].Rows.Count; i++) { int j = int.Parse(ds5.Tables[0].Rows[i][2].ToString()); Maticsoft.BLL.W_Receiver bll4 = new Maticsoft.BLL.W_Receiver(); Maticsoft.Model.W_Receiver model4 = new Maticsoft.Model.W_Receiver(); model4 = bll4.GetModel(j); this.Label_IsHanded.Text += model4.Receiver + " "; } }
protected void btnAdd_Click(object sender, EventArgs e) { if (this.Name.Text == "") { this.Label2.Text = "请输入材料名"; return; } //过期是否显示的判断 Maticsoft.BLL.W_Material bllmaterial = new Maticsoft.BLL.W_Material(); if (this.CheckBox1.Checked) { bllmaterial.ReleaseList(int.Parse(this.Label1.Text)); } else { bllmaterial.NoReleaseList((int.Parse(this.Label1.Text))); } Maticsoft.Model.W_Receivestate receivestate = new Maticsoft.Model.W_Receivestate(); Maticsoft.BLL.W_Receivestate bllstate = new Maticsoft.BLL.W_Receivestate(); //4-3修改by 陈湘军 for (int i = 0; i < this.CheckBoxList_Reciever.Items.Count; i++) { receivestate.ReceiverId = this.CheckBoxList_Reciever.Items[i].Value; receivestate.MaterialId = int.Parse(this.Label1.Text.Trim()); if (this.CheckBoxList_Reciever.Items[i].Selected) { receivestate.Dormacy = "提交"; receivestate.IssureTime = Convert.ToDateTime(DateTime.Now.ToShortTimeString()); } else receivestate.Dormacy = ""; bllstate.Update(receivestate); } if (int.Parse(this.Label1.Text) > 1) { //this.Label_Msg.Text = "提交成功!"; } Response.Redirect("AllList.aspx"); }
protected void Page_Load(object sender, EventArgs e) { string id = ""; //CheckBoxList_Reciever初始化 if (!IsPostBack) { try { id = Request.QueryString[0].ToString(); this.Label1.Text = id; } catch { } if (id == "") { this.begindate.Text = DateTime.Now.ToShortDateString(); this.enddate.Text = DateTime.Now.AddDays(7).ToShortDateString(); } else { //绑定CheckBoxList前面的部分 Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); Maticsoft.Model.W_Material model = new Maticsoft.Model.W_Material(); model = bll2.GetModel(int.Parse(id)); this.Name.Text = model.Name; this.begindate.Text = (Convert.ToDateTime(model.Begindate)).ToShortDateString(); this.enddate.Text = (Convert.ToDateTime(model.Enddate)).ToShortDateString(); //绑定是否显示过期 if (model.Outdisplay == "是") this.CheckBox1.Checked = true; //绑定CheckBoxList DataSet ds = new DataSet(); Maticsoft.BLL.W_Receiver bll = new Maticsoft.BLL.W_Receiver(); ds = bll.W_Receiver_Mid(id); this.CheckBoxList_Reciever.DataSource = ds; CheckBoxList_Reciever.DataTextField = "Receiver"; CheckBoxList_Reciever.DataValueField = "Id"; CheckBoxList_Reciever.DataBind(); //添加选定内容 陈湘军 //修改存储过程 W_Receiver_Mid,添加dormacy字段 if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { try { CheckBoxList_Reciever.Items[i].Selected = (ds.Tables[0].Rows[i]["dormacy"].ToString() == "提交"); } catch { } } } } } }
protected void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string btn = e.CommandName; switch (btn) { case "BtnEdit": int Id1 = int.Parse(e.Item.Cells[8].Text.Trim()); Response.Redirect("AddMaterial.aspx?Id=" + Id1); break; case "BtnDel": int Id2 = int.Parse(e.Item.Cells[8].Text.Trim()); Maticsoft.BLL.W_Material bll2 = new Maticsoft.BLL.W_Material(); bll2.Delete(Id2); Maticsoft.BLL.W_Receivestate bll3 = new Maticsoft.BLL.W_Receivestate(); bll3.Delete(Id2); break; case "BtnManager": int Id3 = int.Parse(e.Item.Cells[8].Text.Trim()); Response.Redirect("Manager.aspx?Id=" + Id3); break; } dataBind(); }
protected void btnAdd_Click(object sender, EventArgs e) { if (this.Name.Text == "") { this.Label2.Text = "请输入材料名"; return; } //对Material表的输入 DateTime begindate = Convert .ToDateTime (this .begindate .Text ); DateTime enddate = Convert.ToDateTime(this.enddate .Text); string name = this.Name .Text.Trim(); string address = this.TextBox_Address.Text.Trim(); string number = this.TextBox_Number.Text.Trim(); // Maticsoft.Model.W_Material material = new Maticsoft.Model.W_Material(); Maticsoft.BLL.W_Material bll = new Maticsoft.BLL.W_Material(); model.Name = name; model.Begindate = begindate; model.Enddate = enddate; model.Address = address; model.Number = number; int id; Maticsoft.Model.W_Receivestate receivestate = new Maticsoft.Model.W_Receivestate(); Maticsoft.BLL.W_Receivestate bllstate = new Maticsoft.BLL.W_Receivestate(); if (this.Label_materialId.Text == "") //添加 id = bll.Add(model); else //修改 { id = int.Parse( this.Label_materialId.Text.Trim()); model.Id = int.Parse(this.Label_materialId.Text.Trim()); bll.Update(model); //对W_Receivestate表的操作 添加时是否需要 bllstate.delete?? bllstate.Delete(id); } receivestate.MaterialId = id; for (int i = 0; i < this.CheckBoxList_Reciever.Items.Count; i++) { if (this.CheckBoxList_Reciever.Items[i].Selected) { receivestate.ReceiverId = this.CheckBoxList_Reciever.Items[i].Value; bllstate.Add(receivestate); } } if (id > 1) { //this.Label_Msg.Text = "提交成功!"; } Response.Redirect("ManagerMaterial.aspx"); }