}//databind_Dtl /// <summary> /// 繫結資料 DTL2 /// </summary> private void Load_TempDetail2() { SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB); ParameterList.Clear(); string strCategory = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); ParameterList.Add(strCategory); ParameterList.Add(DBNull.Value); ParameterList.Add(DBNull.Value); DataTable Dt = BCO.QueryTHRID(ParameterList); dt_TempDetail2 = Dt;//放入暫存檔 lblTitle.Text = "明細清單檔"; lblTab3Msg.Text = "尚未選擇明細代碼"; GridView3.DataSource = null; GridView3.DataBind(); ButtonNewLine2.Visible = false; PanelDetail2.Visible = false; txtDetail2Code.Text = ""; txtDetail2Explain.Text = ""; upTab3Title.Update(); upTab3Detail.Update(); }
/// <summary> /// 清單插入鈕 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Btn_Detail2Insert_Click(object sender, EventArgs e) { try { if (dt_TempDetail2.Rows.Count == 0) { //從DB讀取一空table回來 SYSModel.MaintainCodeFile BCO = new SYSModel.MaintainCodeFile(ConnectionDB); ParameterList.Add("X"); ParameterList.Add("X"); ParameterList.Add("X"); dt_TempDetail2 = BCO.QueryTHRID(ParameterList); } int tempID = 0; DataView tempDT = new DataView(); tempDT.Table = dt_TempDetail2.Copy(); tempDT.Sort = "ID ASC"; if (dt_TempDetail2.Rows.Count != 0) { tempID = Convert.ToInt32(tempDT[dt_TempDetail2.Rows.Count - 1]["ID"].ToString()); } //ID和PID暫自訂, 真正寫入CO時會重取 //LineItem畫面元件內容 string strCategory = ((WUI.SLP.SLPUnique)FormView1.FindControl("TextBoxCode")).Text.Trim(); int iPID = int.Parse(hdfSCODE_ID.Value); string strScode = hdfSCODE.Value; string strCode = this.txtDetail2Code.Text.Trim(); string strExplain = this.txtDetail2Explain.Text.Trim(); int iID = tempID + 1; //檢查SCODE 是否已存在Dt DataRow[] FindRows = dt_TempDetail2.Select(string.Format("CODE='{0}' AND SCODE='{1}'", strCode, strScode)); if (FindRows.Length <= 0) //1:已存在Dt 0:不存在Dt { DataRow dRow = dt_TempDetail2.NewRow(); dRow["ID"] = iID; dRow["PID"] = iPID; dRow["CREATEDATE"] = DateTime.Now; dRow["CREATEUID"] = Session["UID"].ToString(); dRow["UPDATEDATE"] = DateTime.Now; dRow["UPDATEUID"] = Session["UID"].ToString(); dRow["CATEGORY"] = strCategory; dRow["SCODE"] = strScode; dRow["CODE"] = strCode; dRow["EXPLAIN"] = strExplain; dt_TempDetail2.Rows.Add(dRow); this.txtDetail2Code.Text = ""; this.txtDetail2Explain.Text = ""; this.PanelDetail2.Visible = false; BindTempTable_Dtl2(strScode); this.ButtonNewLine2.Visible = true; } else { lblTab3Msg.Text = "清單代碼重覆!"; } } catch (Exception ex) { lblTab3Msg.Text = ex.Message; } finally { } }