/// <summary> /// 繫結資料到控制項 /// </summary> /// <param name="vdb"></param> private void QueryData() { #region string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value); MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB); DataTable dt = null; dt = BCO.QUERY_UN_TAG_STORE(GetQueryParams()); Session[SessionIDName] = dt; Int32 iRowCount = 0; aryParamsPKey.Clear(); GridView1.DataSource = dt; GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text); GridView1.PageIndex = 0; GridView1.DataBind(); if (dt != null && dt.Rows.Count > 0) { iRowCount = dt.Rows.Count; foreach (DataRow dr in dt.Rows) { #region aryParamsPKey.Add(dr["ID"].ToString()); #endregion } } else { ErrorMsgLabel.Text = "查無資料"; } Session[string.Format("{0}_{1}", strPreFixed, PageTimeStamp.Value)] = aryParamsPKey; LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount); #endregion }
protected void btn_StoreSelect_Click(object sender, EventArgs e) { #region try { dtMultiSaveMKT21 = dtMKT21_POP_SelectStore; //(加入之前尚未存檔的選擇項目) if (dtMKT21_POP_SelectStore_old != null && dtMKT21_POP_SelectStore == null) { dtMultiSaveMKT21 = dtMKT21_POP_SelectStore_old; } if (dtMultiSaveMKT21.Rows.Count > 0) { //STEP 1.扣除已存在前次新增之資料 #region if (dtMKT21_POP_SelectStore_old != null && dtMKT21_POP_SelectStore_old.Rows.Count > 0) { for (Int32 i = dtMultiSaveMKT21.Rows.Count - 1; i >= 0; i--) { for (Int32 k = 0; k <= dtMKT21_POP_SelectStore_old.Rows.Count - 1; k++) { if (dtMultiSaveMKT21.Rows[i]["code"].ToString().Trim() == dtMKT21_POP_SelectStore_old.Rows[k]["code"].ToString().Trim()) { dtMultiSaveMKT21.Rows.RemoveAt(i); break; } } } } #endregion //STEP 2.與前次新增之DATATABLE合併 #region if (dtMKT21_POP_SelectStore_old != null && dtMKT21_POP_SelectStore_old.Rows.Count > 0) { dtMultiSaveMKT21.Merge(dtMKT21_POP_SelectStore_old); } #endregion //STEP 3.扣除已存在DB之資料 #region MKTModel.VDS_MKT21_BCO BCO = new MKTModel.VDS_MKT21_BCO(ConnectionDB); ArrayList ParameterList = new ArrayList(); ParameterList.Clear(); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(null); ParameterList.Add(9999); DataTable Dt = BCO.QUERY_UN_TAG_STORE(ParameterList); if (Dt.Rows.Count > 0) { for (Int32 i = dtMultiSaveMKT21.Rows.Count - 1; i >= 0; i--) { for (Int32 k = 0; k <= Dt.Rows.Count - 1; k++) { if (dtMultiSaveMKT21.Rows[i]["code"].ToString().Trim() == Dt.Rows[k]["code"].ToString().Trim()) { dtMultiSaveMKT21.Rows.RemoveAt(i); break; } } } } #endregion } //將舊資料存到old dtMKT21_POP_SelectStore_old = dtMultiSaveMKT21; //Binding 到GridView GridView1.DataSource = dtMultiSaveMKT21; GridView1.DataBind(); UpdatePanel1.Update(); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }