学步园

using System;<br /> using System.Collections;<br /> using System.Configuration;<br /> using System.Data;<br /> using System.Linq;<br /> using System.Web;<br /> using System.Web.Security;<br /> using System.Web.UI;<br /> using System.Web.UI.HtmlControls;<br /> using System.Web.UI.WebControls;<br /> using System.Web.UI.WebControls.WebParts;<br /> using System.Xml.Linq;<br /> using Model;<br /> using DataHelp;<br /> using DAL;</p> <p>public partial class OtherDefine : System.Web.UI.Page<br /> {</p> <p> DataTable dt;<br /> DataTable dtGridView;<br /> DataTable currentTable;<br /> static string stata = "";<br /> static string id = "";<br /> static bool isNew = false;<br /> static bool isEdit = false;<br /> static bool isEmpty = false;<br /> static bool NewPermissions = false;<br /> static bool EditPermissions = false;<br /> static bool DeletePermissions = false;</p> <p> protected void Page_Load(object sender, EventArgs e)<br /> {<br /> Response.Cache.SetAllowResponseInBrowserHistory(false);<br /> Response.Cache.SetCacheability(HttpCacheability.NoCache);</p> <p> if (!IsPostBack)<br /> {</p> <p> if (Session["UserId"] == null || Session["UserName"] == null || Session["Pwd"] == null)<br /> {<br /> Response.Redirect("Login.aspx");<br /> }<br /> else<br /> {<br /> try<br /> {</p> <p> string UserId = Session["UserId"].ToString();<br /> string company = Session["Company"].ToString();<br /> string p = StringHelper.WebPath(HttpContext.Current.Request.PhysicalPath);<br /> DataRow drData = Sys_FuncationDAL.FuncationUserId(p, UserId, company);<br /> if (drData["IsShow"].ToString() != "1")//是否顯示權限<br /> {<br /> Response.Redirect("Error.htm");<br /> }<br /> if (drData["IsInsert"].ToString() == "1")//是否有添加權限<br /> {<br /> NewPermissions = true;<br /> }<br /> else<br /> {<br /> NewPermissions = false;<br /> }<br /> if (drData["IsUpdate"].ToString() == "1")//是否有修改權限<br /> {<br /> EditPermissions = true;<br /> }<br /> else<br /> {<br /> EditPermissions = false;<br /> }<br /> if (drData["IsDelete"].ToString() == "1")//是否有刪除權限<br /> {<br /> DeletePermissions = true;<br /> }<br /> else<br /> {<br /> DeletePermissions = false;<br /> }</p> <p> }<br /> catch (Exception)<br /> {<br /> Response.Redirect("Error.htm", false);<br /> }</p> <p> if (id == "")<br /> {<br /> Load();<br /> }<br /> else<br /> {<br /> Load(id);<br /> }</p> <p> }</p> <p> }</p> <p> }<br /> protected void Load()<br /> {</p> <p> BindTreeView();<br /> DataTable dt = DAL.OtherDefineDAL.GetOtherDefine();<br /> id = dt.Rows[0][0].ToString();</p> <p> BindGridView(Int32.Parse(id));<br /> DataTable dt1 = DAL.OtherDefineDAL.GetOtherDefine(Int32.Parse(id));</p> <p> txtItemCode.Text = dt1.Rows[0]["ItemCode"].ToString();<br /> txtItemCName.Text = dt1.Rows[0]["ItemCName"].ToString();<br /> txtItemEName.Text = dt1.Rows[0]["ItemEName"].ToString();</p> <p> txtItemCode.Enabled = false;<br /> txtItemCName.Enabled = false;<br /> txtItemEName.Enabled = false;<br /> btnCancel.Enabled = false;<br /> btnSave.Enabled = false;</p> <p> btnNew.Enabled = NewPermissions;<br /> btnEdit.Enabled = EditPermissions;<br /> btnDelete.Enabled = DeletePermissions;</p> <p> }</p> <p> protected void Load(string id)<br /> {</p> <p> BindTreeView();</p> <p> BindGridView(Int32.Parse(id));<br /> DataTable dt1 = DAL.OtherDefineDAL.GetOtherDefine(Int32.Parse(id));</p> <p> txtItemCode.Text = dt1.Rows[0]["ItemCode"].ToString();<br /> txtItemCName.Text = dt1.Rows[0]["ItemCName"].ToString();<br /> txtItemEName.Text = dt1.Rows[0]["ItemEName"].ToString();</p> <p> txtItemCode.Enabled = false;<br /> txtItemCName.Enabled = false;<br /> txtItemEName.Enabled = false;</p> <p> btnCancel.Enabled = false;<br /> btnSave.Enabled = false;</p> <p> btnNew.Enabled = NewPermissions;<br /> btnEdit.Enabled = EditPermissions;<br /> btnDelete.Enabled = DeletePermissions;<br /> }</p> <p> protected void BindTreeView()<br /> {<br /> if (TreeView.Nodes.Count != 0)<br /> {<br /> TreeView.Nodes.Clear();<br /> }</p> <p> dt = DAL.OtherDefineDAL.GetOtherDefine();<br /> //TreeView.DataSource = tb;<br /> //TreeView.DataBind();</p> <p> TreeNode parentNode = new TreeNode();<br /> parentNode.Text = "全部項目";<br /> parentNode.Value = "00001";</p> <p> TreeView.Nodes.Add(parentNode);<br /> if (dt.Rows.Count > 0)<br /> {<br /> for(int i=0;i<dt.Rows.Count;i++)<br /> {<br /> TreeNode tn = new TreeNode();<br /> tn.Text = dt.Rows[i]["ItemCName"].ToString();<br /> tn.Value = dt.Rows[i]["ID"].ToString();<br /> //TreeView.Nodes.Add(tn);<br /> //node.Expanded = True<br /> tn.Expanded = true;</p> <p> parentNode.ChildNodes.Add(tn);<br /> }<br /> }<br /> parentNode.Expanded = true;</p> <p> }<br /> protected void BindGridView(int ID)<br /> {<br /> dtGridView = DAL.OtherDefineDAL.GetOtherDefineB(ID);</p> <p> if (dtGridView.Rows.Count == 0)<br /> {<br /> currentTable = dtGridView.Copy();<br /> DataRow dr = currentTable.NewRow();<br /> dr["ListCode"] = "請添加數據 ";<br /> dr["ListA"] = "請添加數據";<br /> dr["ListB"] = "請添加數據";<br /> dr["ListC"] = "請添加數據";<br /> dr["ListD"] = "請添加數據";<br /> dr["ListE"] = "請添加數據";<br /> currentTable.Rows.Add(dr);</p> <p> DataRow dr1 = currentTable.NewRow();</p> <p> gvOtherDefine.DataSource = currentTable;<br /> gvOtherDefine.DataBind();<br /> Lbmessage.Text = "沒有任何數據，請點擊編輯按鈕并新增數據！";</p> <p> gvOtherDefine.Columns[6].Visible = false;<br /> gvOtherDefine.Columns[7].Visible = false;<br /> gvOtherDefine.Columns[8].Visible = false;<br /> isEmpty = true;<br /> }<br /> else<br /> {<br /> gvOtherDefine.DataSource = dtGridView;<br /> gvOtherDefine.DataBind();<br /> gvOtherDefine.Columns[6].Visible = false;<br /> gvOtherDefine.Columns[7].Visible = false;<br /> gvOtherDefine.Columns[8].Visible = false;<br /> Lbmessage.Text = "";<br /> isEmpty = false;<br /> }<br /> }</p> <p> protected void TreeView_SelectedNodeChanged(object sender, EventArgs e)<br /> {<br /> // TextBox1.Text = TreeView.SelectedNode.Value.ToString();<br /> if (TreeView.SelectedNode.Value.ToString() != "00001")<br /> {<br /> DataTable dt1 = DAL.OtherDefineDAL.GetOtherDefine(Int32.Parse(TreeView.SelectedNode.Value.ToString()));</p> <p> txtItemCode.Text = dt1.Rows[0]["ItemCode"].ToString();<br /> txtItemCName.Text = dt1.Rows[0]["ItemCName"].ToString();<br /> txtItemEName.Text = dt1.Rows[0]["ItemEName"].ToString();<br /> gvOtherDefine.EditIndex = -1;<br /> BindGridView(Int32.Parse(TreeView.SelectedNode.Value.ToString()));<br /> gvOtherDefine.Enabled = true;<br /> id = TreeView.SelectedNode.Value.ToString();<br /> Load(id);<br /> btnSave.Enabled = false;<br /> btnCancel.Enabled = false;<br /> btnNew.Enabled = NewPermissions;<br /> btnEdit.Enabled = EditPermissions;<br /> btnDelete.Enabled = DeletePermissions;<br /> }<br /> }<br /> protected void btnNew_Click(object sender, EventArgs e)<br /> {<br /> stata = "new";<br /> TreeView.Enabled = false;<br /> txtItemCode.Enabled = true;<br /> txtItemCName.Enabled = true;<br /> txtItemEName.Enabled = true;<br /> txtItemCode.Text = "";<br /> txtItemCName.Text = "";<br /> txtItemEName.Text = "";<br /> BindGridView(0);<br /> gvOtherDefine.Columns[8].Visible = true;<br /> btnEdit.Enabled = false;<br /> btnSave.Enabled = true;<br /> btnDelete.Enabled = false;<br /> btnNew.Enabled = false;<br /> btnCancel.Enabled = true;</p> <p> gvOtherDefine.Enabled = false;</p> <p> }<br /> protected void btnEdit_Click(object sender, EventArgs e)<br /> {<br /> stata = "edit";</p> <p> btnNew.Enabled = false;<br /> btnEdit.Enabled = false;<br /> btnDelete.Enabled = false;<br /> btnSave.Enabled = true;<br /> btnCancel.Enabled = true;<br /> txtItemCode.Enabled = true;<br /> txtItemCName.Enabled = true;<br /> txtItemEName.Enabled = true;</p> <p> if (gvOtherDefine.Rows.Count == 1)<br /> {<br /> //if (((TextBox)(gvOtherDefine.Rows[0].FindControl("lb1"))).Text.ToString() == "請添加數據")<br /> //if (gvOtherDefine.Rows[0].Cells[0].Text.ToString() == "請添加數據")<br /> if (isEmpty == true)<br /> {<br /> gvOtherDefine.Columns[6].Visible = false;<br /> gvOtherDefine.Columns[7].Visible = false;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> }<br /> else<br /> {<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> }<br /> }<br /> else if (gvOtherDefine.Rows.Count >1)<br /> {<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> }<br /> }</p> <p> protected void btnCancel_Click(object sender, EventArgs e)<br /> {<br /> stata = "Cancel";<br /> txtItemCode.Enabled = false;<br /> txtItemCName.Enabled = false;<br /> txtItemEName.Enabled = false;</p> <p> TreeView.Enabled = true;<br /> gvOtherDefine.Enabled = true;</p> <p> if (id == "")<br /> {<br /> Load();</p> <p> }<br /> else<br /> {<br /> Load(id);<br /> }</p> <p> }</p> <p> protected void btnSave_Click(object sender, EventArgs e)<br /> {<br /> btnNew.Enabled = NewPermissions;<br /> btnEdit.Enabled = EditPermissions;<br /> btnDelete.Enabled = DeletePermissions;<br /> btnSave.Enabled = false;<br /> btnCancel.Enabled = false;<br /> TreeView.Enabled = true;<br /> txtItemCode.Enabled = false;<br /> txtItemCName.Enabled = false;<br /> txtItemEName.Enabled = false;<br /> if (stata == "new")<br /> {<br /> int isSave= DAL.OtherDefineDAL.InsertOtherDefineA(txtItemCode.Text.Trim(), txtItemCName.Text.Trim(), txtItemEName.Text.Trim());<br /> if (isSave == 1)<br /> {<br /> Lbmessage.Text = "新增項目已成功保存,請繼續新增項目明細！";<br /> BindTreeView();<br /> DataTable dt = DAL.OtherDefineDAL.GetMaxID();<br /> string strid = dt.Rows[0][0].ToString();<br /> id = strid;</p> <p> gvOtherDefine.Enabled = true;<br /> gvOtherDefine.Columns[8].Visible = false;<br /> }<br /> else<br /> {<br /> Load(id);<br /> Lbmessage.Text = "新增失敗！";<br /> }</p> <p> }<br /> else if (stata == "edit")<br /> {<br /> int id1 =Int32.Parse(id);<br /> string ItemCode=txtItemCode.Text.ToString().Trim();<br /> string ItemCName=txtItemCName.Text.ToString().Trim();<br /> string ItemEName=txtItemEName.Text.ToString().Trim();</p> <p> int isSave = DAL.OtherDefineDAL.UpdateOtherDefineA(id1, ItemCode, ItemCName, ItemCName);<br /> if (isSave == 1)<br /> {<br /> Load(id);<br /> }<br /> else<br /> {<br /> Lbmessage.Text = "修改失敗！";<br /> }<br /> }<br /> }<br /> protected void btnDelete_Click(object sender, EventArgs e)<br /> {<br /> stata = "delete";<br /> int id1 = Int32.Parse(id);<br /> int i=DAL.OtherDefineDAL.DeleteOtherDefineA(id1);<br /> int m = DAL.OtherDefineDAL.DeleteAllOtherDefineB(id1);<br /> if (i == 1)<br /> {<br /> Lbmessage.Text = "刪除成功！";<br /> Load();<br /> }<br /> else<br /> {<br /> Lbmessage.Text = "刪除失敗！";<br /> Load(id);<br /> }</p> <p> }<br /> protected void btnPrint_Click(object sender, EventArgs e)<br /> {</p> <p> }<br /> protected void gvOtherDefine_PageIndexChanging(object sender, GridViewPageEventArgs e)<br /> {</p> <p> gvOtherDefine.PageIndex = e.NewPageIndex;<br /> BindGridView(Int32.Parse(TreeView.SelectedNode.Value.ToString()));</p> <p> }</p> <p> protected void gvOtherDefine_RowDeleting(object sender, GridViewDeleteEventArgs e)<br /> {</p> <p> int ItemNo = Int32.Parse(id);<br /> //string ListCode = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb1"))).Text.ToString().Trim();<br /> string ListCode = ((Label)(gvOtherDefine.Rows[e.RowIndex].FindControl("lb1"))).Text.ToString();<br /> int i = DAL.OtherDefineDAL.DeleteOtherDefineB(ItemNo, ListCode);<br /> if (i == 1)<br /> {<br /> Lbmessage.Text = "刪除成功！";<br /> }<br /> else<br /> {<br /> Lbmessage.Text = "刪除失敗！";<br /> }<br /> Load(id);</p> <p> }</p> <p> protected void gvOtherDefine_RowDataBound(object sender, GridViewRowEventArgs e)<br /> {<br /> if (e.Row.RowType == DataControlRowType.DataRow)<br /> {<br /> if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)<br /> {<br /> ((LinkButton)e.Row.Cells[7].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除此項數據吗?')");<br /> }</p> <p> }</p> <p> }</p> <p> protected void gvOtherDefine_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)<br /> {</p> <p> gvOtherDefine.EditIndex = -1;<br /> if (gvOtherDefine.Rows.Count == 1)<br /> {<br /> if (isEmpty == true)<br /> {<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = false;<br /> gvOtherDefine.Columns[7].Visible = false;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> }<br /> else<br /> {<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> }<br /> }<br /> else<br /> {<br /> BindGridView(int.Parse(id));<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> }</p> <p> }<br /> protected void gvOtherDefine_RowCommand(object sender, GridViewCommandEventArgs e)<br /> {<br /> //TextBox3.Text = e.CommandName.ToString()+Int32.Parse(e.CommandArgument.ToString());</p> <p> if (e.CommandName == "New")<br /> {<br /> //GridViewRow dvr = new GridViewRow(1, -1, DataControlRowType.DataRow, DataControlRowState.Edit);<br /> //TableCell tc = new TableCell();<br /> //tc.Text = "請輸入";<br /> //dvr.Cells.Add(tc);<br /> //GridView1.Controls[0].Controls.Add(dvr);<br /> isNew = true;<br /> if (gvOtherDefine.Rows.Count > 1)<br /> {<br /> BindGridView(Int32.Parse(id));<br /> DataRow dr = dtGridView.NewRow();<br /> dtGridView.Rows.Add(dr);<br /> gvOtherDefine.EditIndex = dtGridView.Rows.Count - 1;</p> <p> gvOtherDefine.DataSource = dtGridView;<br /> gvOtherDefine.DataBind();<br /> gvOtherDefine.Columns[6].Visible = true;<br /> // TreeView.Enabled = false;</p> <p> }<br /> else if (gvOtherDefine.Rows.Count ==1)<br /> {<br /> if (isEmpty==true)<br /> {<br /> gvOtherDefine.EditIndex = 0;</p> <p> BindGridView(0);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> ((TextBox)(gvOtherDefine.Rows[0].FindControl("tb1"))).Text = "";<br /> ((TextBox)(gvOtherDefine.Rows[0].FindControl("tb2"))).Text = "";<br /> ((TextBox)(gvOtherDefine.Rows[0].FindControl("tb3"))).Text = "";<br /> ((TextBox)(gvOtherDefine.Rows[0].FindControl("tb4"))).Text = "";<br /> ((TextBox)(gvOtherDefine.Rows[0].FindControl("tb5"))).Text = "";<br /> ((TextBox)(gvOtherDefine.Rows[0].FindControl("tb6"))).Text = "";<br /> }<br /> else<br /> {<br /> BindGridView(Int32.Parse(id));<br /> DataRow dr = dtGridView.NewRow();<br /> dtGridView.Rows.Add(dr);<br /> gvOtherDefine.EditIndex = dtGridView.Rows.Count - 1;</p> <p> gvOtherDefine.DataSource = dtGridView;<br /> gvOtherDefine.DataBind();<br /> gvOtherDefine.Columns[6].Visible = true;<br /> }<br /> }<br /> }</p> <p> }</p> <p> protected void gvOtherDefine_RowEditing1(object sender, GridViewEditEventArgs e)<br /> {<br /> if (gvOtherDefine.Rows.Count == 1)<br /> {<br /> if (isEmpty==true)<br /> {<br /> gvOtherDefine.EditIndex = e.NewEditIndex;<br /> // BindGridView(0);<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> isEdit = true;</p> <p> }<br /> else<br /> {</p> <p> gvOtherDefine.EditIndex = e.NewEditIndex;<br /> //BindGridView(Int32.Parse(id));<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> isEdit = true;<br /> ((TextBox)(gvOtherDefine.Rows[0].FindControl("tb1"))).Enabled = false;<br /> }<br /> }<br /> else<br /> {<br /> gvOtherDefine.EditIndex = e.NewEditIndex;<br /> BindGridView(Int32.Parse(id));<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> isEdit = true;<br /> ((TextBox)(gvOtherDefine.Rows[e.NewEditIndex].FindControl("tb1"))).Enabled = false;<br /> }<br /> }<br /> protected void gvOtherDefine_RowUpdating1(object sender, GridViewUpdateEventArgs e)<br /> {<br /> if (isNew == true)<br /> {</p> <p> gvOtherDefine.EditIndex = -1;<br /> //int ItemNo, string ListCode, string ListA, string ListB, string ListC, string ListD, string ListE)<br /> //((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() </p> <p> string ListCode = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb1"))).Text.ToString().Trim();<br /> string ListA = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb2"))).Text.ToString().Trim();<br /> string ListB = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb3"))).Text.ToString().Trim();<br /> string ListC = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb4"))).Text.ToString().Trim();<br /> string ListD = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb5"))).Text.ToString().Trim();<br /> string ListE = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb6"))).Text.ToString().Trim();<br /> int ItemNo = Int32.Parse(id);<br /> if (ListCode != "")<br /> {<br /> DataTable dt = DAL.OtherDefineDAL.GetListCode(ItemNo, ListCode);<br /> if (dt.Rows.Count == 0)<br /> {<br /> int i = DAL.OtherDefineDAL.InsertOtherDefineB(ItemNo, ListCode, ListA, ListB, ListC, ListD, ListE);<br /> if (i == 1)<br /> {<br /> Lbmessage.Text = "更新成功！";<br /> }<br /> else<br /> {<br /> Lbmessage.Text = "更新失敗！";<br /> }<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> isNew = false;<br /> }<br /> else<br /> {</p> <p> gvOtherDefine.EditIndex = -1;<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> Lbmessage.Text = "你輸入的項目編號已經存在，請重新輸入！";<br /> }<br /> }<br /> else<br /> {<br /> gvOtherDefine.EditIndex = -1;<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> Lbmessage.Text = "請輸入項目編號，項目編號不能為空！";</p> <p> }</p> <p> }<br /> else if (isEdit == true)<br /> {<br /> gvOtherDefine.EditIndex = -1;<br /> //int ItemNo, string ListCode, string ListA, string ListB, string ListC, string ListD, string ListE)<br /> //((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() </p> <p> string ListCode = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb1"))).Text.ToString().Trim();<br /> string ListA = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb2"))).Text.ToString().Trim();<br /> string ListB = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb3"))).Text.ToString().Trim();<br /> string ListC = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb4"))).Text.ToString().Trim();<br /> string ListD = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb5"))).Text.ToString().Trim();<br /> string ListE = ((TextBox)(gvOtherDefine.Rows[e.RowIndex].FindControl("tb6"))).Text.ToString().Trim();<br /> int ItemNo = Int32.Parse(id);<br /> int i = DAL.OtherDefineDAL.UpdateOtherDefineB(ItemNo, ListCode, ListA, ListB, ListC, ListD, ListE);<br /> if (i == 1)<br /> {<br /> Lbmessage.Text = "更新成功！";<br /> }<br /> else<br /> {<br /> Lbmessage.Text = "更新失敗！";<br /> }<br /> Load(id);<br /> gvOtherDefine.Columns[6].Visible = true;<br /> gvOtherDefine.Columns[7].Visible = true;<br /> gvOtherDefine.Columns[8].Visible = true;<br /> isEdit = false;<br /> }<br /> }<br /> }<br />