protected void Btn_Cancel_Click(object sender, EventArgs e) { try { switch (this.hid_PageStatus.Value) { case "EDIT": #region 設定頁面狀態 this.hid_PageStatus.Value = "VIEW"; this.txt_PageStatus.Text = "VIEW"; #endregion #region 檢視市調商品 try { BCO.MaintainMarketSurveyRecordsDtl bco = new BCO.MaintainMarketSurveyRecordsDtl(ConnectionDB); ParameterList.Clear(); ParameterList.Add(this.hiddenID.Value); DataTable dt = bco.QuerySurveyRecDetlByPID(ParameterList); this.gvDtl.DataSource = dt; this.gvDtl.DataBind(); Session["MKT132_DTL_" + PageTimeStamp.Value] = dt; } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion break; case "VIEW": Response.Redirect("MKT131.aspx?&Code=MKT13"); break; default: break; } } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { if (this.ErrorMsgLabel.Text == "") { SetPageStatus(); } } }
}//databind_Mst /// <summary> /// 繫結資料 Dtl /// </summary> private void databind_Dtl() { #region try { #region 檢視市調商品 try { BCO.MaintainMarketSurveyRecordsDtl bco = new BCO.MaintainMarketSurveyRecordsDtl(ConnectionDB); ParameterList.Clear(); ParameterList.Add(this.hiddenID.Value); DataTable dt = bco.QuerySurveyRecDetlByPID(ParameterList); this.gvDtl.DataSource = dt; this.gvDtl.DataBind(); Session["MKT132_DTL_" + PageTimeStamp.Value] = dt; } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } #endregion }//databind_Dtl
public static string GetItemMaxPeriod(string s_ItemValue, string s_Item_Client_Id, string s_Period_Client_Id, string s_PublishDate_Client_Id, string s_SurveyTime_Client_Id) { #region 取得Item最大期別 String rtnValue = ""; if (s_ItemValue.Trim() != "") { BCO.MaintainMarketSurveyRecordsDtl bco = new BCO.MaintainMarketSurveyRecordsDtl(ConnectionDB); ParameterList.Clear(); ParameterList.Add(s_ItemValue); //取得Item最大期別 DataTable dt = bco.GetItemMaxPeriod(ParameterList); if (dt.Rows.Count > 0) { rtnValue = dt.Rows[0][0].ToString() + ";" + s_Item_Client_Id + ";" + s_Period_Client_Id + ";" + s_PublishDate_Client_Id + ";" + s_SurveyTime_Client_Id; } else { rtnValue = rtnValue = "" + ";" + s_Item_Client_Id + ";" + s_Period_Client_Id + ";" + s_PublishDate_Client_Id + ";" + s_SurveyTime_Client_Id; } } return rtnValue; #endregion }
public static string GetPeriodRelated(string s_ItemValue, string s_PeriodValue, string s_Item_Client_Id, string s_Period_Client_Id, string s_PublishDate_Client_Id, string s_SurveyTime_Client_Id, string s_Z_OValue, string s_SurveyDateValue) { #region String rtnValue = ""; String strPeriodStartDate = ""; if (s_PeriodValue.Trim() != "") { #region 根據[@品號]、[@期別],自動帶入[@上市日期]=[期別主檔].[期別開始日] BCO.MaintainMarketSurveyRecordsDtl bco = new BCO.MaintainMarketSurveyRecordsDtl(ConnectionDB); ParameterList.Clear(); ParameterList.Add(s_ItemValue); ParameterList.Add(s_PeriodValue); DataTable dt = bco.GetPeriodStartDate(ParameterList); if (dt.Rows.Count > 0) { strPeriodStartDate = (dt.Rows[0][0].ToString() == "") ? "" : ((DateTime)dt.Rows[0][0]).ToString("yyyy/MM/dd"); } else { return "ErrorPeriod" + ";" + "0" + ";" + s_Item_Client_Id + ";" + s_Period_Client_Id + ";" + s_PublishDate_Client_Id + ";" + s_SurveyTime_Client_Id; ; } #endregion #region 自動算出〔市調次數〕-->=該品項歷史次數合計+1 BCO.MaintainMarketSurveyRecordsDtl bco2 = new BCO.MaintainMarketSurveyRecordsDtl(ConnectionDB); ParameterList.Clear(); ParameterList.Add(s_Z_OValue); ParameterList.Add(s_SurveyDateValue); ParameterList.Add(s_ItemValue); ParameterList.Add(s_PeriodValue); DataTable dt2 = bco2.GetItemSurveyTime(ParameterList); if (dt2.Rows.Count > 0) { rtnValue = strPeriodStartDate +";" + dt2.Rows[0][0].ToString() + ";" + s_Item_Client_Id + ";" + s_Period_Client_Id + ";" + s_PublishDate_Client_Id + ";" + s_SurveyTime_Client_Id; } #endregion } return rtnValue; #endregion }
/// <summary> /// 繫結舊有營業所,市調日期資料 /// </summary> private void databind_Old() { #region try { 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("", "string")); //市調人員 不納入查詢條件 #endregion #region 處理查詢 BCO.MaintainMarketSurveyRecords bcoMain = new MaintainMarketSurveyRecords(ConnectionDB); Dt = bcoMain.QuerySurveyRecMain(ParameterList); #endregion if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { Session["MKT133_MAIN_OLD" + PageTimeStamp.Value] = null; return; } 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["MKT133_MAIN_" + PageTimeStamp.Value] = Dt.Copy(); Session["MKT133_MAIN_OLD" + PageTimeStamp.Value] = Dt.Copy(); #endregion BCO.MaintainMarketSurveyRecordsDtl bco = new BCO.MaintainMarketSurveyRecordsDtl(ConnectionDB); ParameterList.Clear(); ParameterList.Add(Dt.Rows[0]["ID"].ToString()); DataTable dtDtl = bco.QuerySurveyRecDetlByPID(ParameterList); //設定市調商品 column DataTable dt = new DataTable(); DataColumn dcNew; dcNew = new DataColumn("ITEM", Type.GetType("System.String")); dt.Columns.Add(dcNew); dcNew = new DataColumn("PERIOD", Type.GetType("System.String")); dt.Columns.Add(dcNew); dcNew = new DataColumn("PUBLISH_DATE", Type.GetType("System.String")); dt.Columns.Add(dcNew); dcNew = new DataColumn("SURVEY_TIME", Type.GetType("System.Int32")); dt.Columns.Add(dcNew); //產生20筆資料供編輯 for (int i = 0; i < 20; i++) { DataRow drNew; drNew = dt.NewRow(); if (i < dtDtl.Rows.Count) { drNew["ITEM"] = dtDtl.Rows[i]["ITEM"].ToString(); drNew["PERIOD"] = dtDtl.Rows[i]["PERIOD"].ToString(); //drNew["PUBLISH_DATE"] = ((DateTime)dtDtl.Rows[i]["PUBLISH_DATE"]).ToString("yyyy/MM/dd"); drNew["SURVEY_TIME"] = GetValueSetParameter(dtDtl.Rows[i]["SURVEY_TIME"].ToString(), "int"); } else { drNew["ITEM"] = ""; drNew["PERIOD"] = ""; drNew["PUBLISH_DATE"] = DBNull.Value; drNew["SURVEY_TIME"] = DBNull.Value; } dt.Rows.Add(drNew); } dt.AcceptChanges(); this.gvDtl.DataSource = dt; this.gvDtl.DataBind(); } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } #endregion }//databind_Old