protected void btn_Confirm_Click(object sender, EventArgs e) { #region try { if (GetStringLen(txt_Memo.Text.Trim()) > 200) { hiddenFocusCtrlID.Value = txt_Memo.ClientID; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ClientScript", "alert('備註限制100中文字');", true); } else { #region DateTime dtProcessing = DateTime.Now; string strUID = Session["UID"].ToString(); string strChan = SLP_StoreChain3.Text.Trim(); string strStore = SLP_Store3.Text.Trim(); string strPattern = SLP_Pattern3.Text.Trim(); string strChanName = ""; string strStoreName = ""; string strPatternName = ""; ArrayList ParameterList = new ArrayList();//20091112 int iRowIndex = 0; ALOModel.MaintainStoreRank BCO = new ALOModel.MaintainStoreRank(ConnectionDB); ParameterList.Clear(); ParameterList.Add(strChan); ParameterList.Add(strStore); ParameterList.Add(strPattern); ParameterList.Add(dtProcessing); ParameterList.Add(strUID); ParameterList.Add(dtProcessing); ParameterList.Add(strUID); ParameterList.Add(null); ParameterList.Add(strRankCode2); ParameterList.Add(SLP_SLPNumber1.Text.Trim()); ParameterList.Add(txt_RankLevel.Text.Trim()); ParameterList.Add(txt_Memo.Text.Trim()); ParameterList.Add(s_PROCNO); BCO.ADD_STORERANK_AFTERQUERY(ParameterList, null); //todo gridview binding #region //chan_name ParameterList.Clear(); ParameterList.Add(strChan); STMModel.MaintainStoreChain BCO_STM1 = new STMModel.MaintainStoreChain(ConnectionDB); DataTable dt_stm1 = BCO_STM1.QueryStoreChainByCode(ParameterList); strChanName = ((dt_stm1 != null && dt_stm1.Rows.Count > 0) ? dt_stm1.Rows[0]["NAME"].ToString() : "查無資料"); //store_name ParameterList.Clear(); ParameterList.Add(strStore); ParameterList.Add(strChan); ParameterList.Add(null); STMModel.MaintainStoreUnique BCO_STM2 = new STMModel.MaintainStoreUnique(ConnectionDB); DataTable dt_stm2 = BCO_STM2.QueryForSLP2(ParameterList); strStoreName = ((dt_stm2 != null && dt_stm2.Rows.Count > 0) ? dt_stm2.Rows[0]["STORE_NAME"].ToString() : "查無資料"); //pattern_name ParameterList.Clear(); ParameterList.Add(strPattern); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ITMModel.MaintainItemClassify BCO_ITM1 = new ITMModel.MaintainItemClassify(ConnectionDB); DataTable dt_itm1 = BCO_ITM1.QueryPatternForSLP(ParameterList); strPatternName = ((dt_itm1 != null && dt_itm1.Rows.Count > 0) ? dt_itm1.Rows[0]["PATTERN_NAME"].ToString() : "查無資料"); #endregion #region Insert New Row string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); DataTable dt1 = (DataTable)Session[SessionIDName]; DataView dv = dt1.DefaultView; if (ViewState["SortingCondition"] != null) { dv.Sort = ViewState["SortingCondition"].ToString(); } DataTable dt2 = dv.ToTable(); //判斷是否已存在目前DataTable中 if (CheckDataIsExistedInCurrentDataTable(strChan, strStore, strPattern, dt2, out iRowIndex)) { #region 如存在則刪除畫面上舊資料 dt2.Rows.RemoveAt(iRowIndex); #endregion } #region 新增一筆 DataRow dr = dt2.NewRow(); dr["PATTERN_NO"] = strPattern; dr["PATTERN_NAME"] = strPatternName; dr["CHAN_NO"] = strChan; dr["CHAN_NAME"] = strChanName; dr["STORE"] = strStore; dr["STORE_NAME"] = strStoreName; dr["RANK_CODE"] = ((DropDownList)SLP_Rank2.FindControl("D1")).SelectedItem.Value; dr["RANK_NAME"] = ((DropDownList)SLP_Rank2.FindControl("D1")).SelectedItem.Text; dr["RANK_VALUE"] = SLP_SLPNumber1.Text.Trim(); dr["RANK_LEVEL"] = txt_RankLevel.Text.Trim(); dr["MEMO"] = txt_Memo.Text.Trim(); //2010/09/20 added //dr["c_start_date"] = SLP_SLPDate1.Text.Trim();//暫不顯示 //dr["c_end_date"] = SLP_SLPDate2.Text.Trim();//暫不顯示 dr["update_date"] = DateTime.Now.ToString("yyyy/MM/dd"); dr["user_name"] = ((DataTable)Session["UserInfo"]).Rows[0]["Name"].ToString(); dt2.Rows.InsertAt(dr, 0); #endregion Session[SessionIDName] = dt2; GridView1.DataSource = dt2; GridView1.DataBind(); #endregion PanelG3.Visible = false; hiddenFocusCtrlID.Value = ""; ResultMsgLabel.Text = "新增成功"; #endregion } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }
public string GetPatternName(string Code, string RootNo, string PMA, string Category, string SortOut ) { string Name = ""; string ConnectionDBStr = ((DatabaseSettings)ConfigurationManager.GetSection("dataConfiguration")).DefaultDatabase; MaintainItemClassify bco = new MaintainItemClassify(ConnectionDBStr); if (Code != "") { ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(Code); ParameterList.Add(RootNo); ParameterList.Add(PMA); ParameterList.Add(Category); ParameterList.Add(SortOut); DataTable dt = bco.QueryPatternForSLP(ParameterList); Name = ((dt.Rows.Count > 0) ? dt.Rows[0]["PATTERN_NAME"].ToString() : "查無資料"); } return Name; }