}//設定各種模式預設值 /// <summary> /// 繫結資料 MST /// </summary> private void databind_Mst() { #region try { DataTable Dt = new DataTable(); BCO.MaintainMarketSurveyRecords bco = new MaintainMarketSurveyRecords(ConnectionDB); ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_CodeFile1.Text, "string")); //營業所 ParameterList.Add(GetValueSetParameter(this.dSurveyDate.Text, "date")); //市調日期 ParameterList.Add(GetValueSetParameter("", "string")); //市調人員 不納入查詢條件 //if (Request.QueryString["Z_O_SUB"] != null) //{ // ParameterList.Add(GetValueSetParameter((SLP_CodeFile1.Text != "") ? "" : SLP_CodeFile2.Text, "string")); //營業所2 // Dt = bco.QuerySurveyRecMain_1(ParameterList); //} //else // Dt = bco.QuerySurveyRecMain(ParameterList); ParameterList.Add(GetValueSetParameter(SLP_CodeFile2.Text, "string")); //營業所(迄) Dt = bco.QuerySurveyRecMain_1(ParameterList); if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) ErrorMsgLabel.Text = "查無資料"; else this.txtInvestigator.Text = Dt.Rows[0]["INVESTIGATOR"].ToString(); #region 設定查詢結果 this.GridView1.DataSource = Dt; this.GridView1.PageSize = 20;// (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); this.GridView1.PageIndex = 0; this.GridView1.DataBind(); Session["MKT132_MAIN_" + PageTimeStamp.Value] = Dt; #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } #endregion }//databind_Mst
protected void Btn_Maintain_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; #region 資料檢查 if (string.Compare(SLP_CodeFile1.Text, SLP_CodeFile2.Text) > 0) { ErrorMsgLabel.Text = "營業所(起)不可大於營業所(迄)"; return; } if (dSurveyDate.Text == "") { ErrorMsgLabel.Text = "市調日期不可空白"; return; } #endregion DataTable Dt = new DataTable(); #region 查詢市調情報資料 //取得查詢參數: 營業所,市調日期 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_CodeFile1.Text, "string")); //營業所 ParameterList.Add(GetValueSetParameter(this.dSurveyDate.Text, "date")); //市調日期 ParameterList.Add(GetValueSetParameter(txtInvestigator.Text.Trim(), "string")); //市調人員 2010/09/29 modified //ParameterList.Add(GetValueSetParameter((SLP_CodeFile1.Text != "") ? "" : SLP_CodeFile2.Text, "string")); //營業所2 ParameterList.Add(GetValueSetParameter(SLP_CodeFile2.Text, "string")); //營業所(迄) BCO.MaintainMarketSurveyRecords bco = new MaintainMarketSurveyRecords(ConnectionDB); Dt = bco.QuerySurveyRecMain_1(ParameterList); #endregion if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { //若不存在市調情報資料 ErrorMsgLabel.Text = "不存在市調情報資料,請新增市調情報"; return; } else { //若已存在市調情報資料,至編輯檢視市調情報維護畫面 Response.Redirect(string.Format("MKT132.aspx?Mode=VIEW&Code=MKT13&Z_O={0}&SURVEY_DATE={1}&INVESTIGATOR={2}&Z_O_SUB={3}", SLP_CodeFile1.Text, dSurveyDate.Text, txtInvestigator.Text, SLP_CodeFile2.Text), false); } } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } }