protected void Btn_Query_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; this.hidCheckAllFlag.Value = "Y"; DataTable Dt = new DataTable(); #region 清空靜態變數 dt_Detail = null; #endregion #region 處理查詢 BCO.MaintainMarketSurveyStore bco = new MaintainMarketSurveyStore(ConntionDB); Dt = bco.QuerySelectStore(this.getParameterList()); #endregion if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { ErrorMsgLabel.Text = "查無資料"; dt_Detail = null; } else { dt_Detail = Dt.Copy(); } #region 設定查詢結果 this.GridView1.DataSource = Dt; this.GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) < 0) ? 10 : int.Parse(TextBoxPagesize.Text); this.GridView1.PageIndex = 0; this.GridView1.DataBind(); #endregion #region 將GridView的資訊寫入TempTable Set_PageValue_To_TempTable(); #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
protected void Btn_Execute_Click(object sender, EventArgs e) { try { string errMsg = ""; if (txtOldInvestigator.Text.Trim() == "") errMsg += "「原市調人員」不可空白<br \\>"; if (txtNewInvestigator.Text.Trim() == "") errMsg += "「新市調人員」不可空白"; if (errMsg != "") { ErrorMsgLabel.Text = errMsg; return; } #region 儲存新增資料 string strMsg = ""; BCO.MaintainMarketSurveyStore bco = new BCO.MaintainMarketSurveyStore(ConnectionDB); // 做資料儲存的動作 bco.ExchangeInvestigator(this.getParameterList(), null, out strMsg); if (strMsg != "") { this.ErrorMsgLabel.Text = strMsg; return; } #endregion #region 關掉POP視窗 //Response.Write("<script>alert('儲存成功');window.close();</script>"); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Window", "alert('儲存成功');window.close();", true); #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
public static string GetStoreRelatedData(string strStore) { #region 取得STORE_STATUS(關店門市狀態),SAL_ID,CHAN_NO by store String rtnValue = ""; if (strStore != "") { BCO.MaintainMarketSurveyStore bco = new BCO.MaintainMarketSurveyStore(ConnectionDB); // 取得STORE_STATUS(關店門市狀態),SAL_ID,CHAN_NO by store ParameterList.Clear(); ParameterList.Add(strStore); DataTable dt = bco.QueryRelatedStoreData(ParameterList); if (dt.Rows.Count > 0) { rtnValue = dt.Rows[0][0].ToString(); } else { rtnValue = ""; } } return rtnValue; #endregion }
protected void Btn_Save_Click(object sender, EventArgs e) { try { if (txtInvestigator.Text.Trim() == "") { ErrorMsgLabel.Text = "「市調人員」不可空白"; return; } string strErrMsg = ""; if (Session["MKT12_POP_SelectStore" + PageTimeStamp.Value] == "") { ErrorMsgLabel.Text = "請選擇新門市"; return; } #region 組合查詢條件至ArrayList string strInvestigator = this.txtInvestigator.Text; ArrayList returnList = new ArrayList(); returnList.Clear(); returnList.Add(GetValueSetParameter(strInvestigator, "string")); returnList.Add(Session["UID"].ToString()); #endregion #region 儲存新增資料 string strMsg = ""; BCO.MaintainMarketSurveyStore bco = new BCO.MaintainMarketSurveyStore(ConnectionDB); int intCount = bco.CreateMultiSurveyStore(returnList, ((DataTable)Session["MKT12_POP_SelectStore" + PageTimeStamp.Value]), null, out strMsg); //儲存異常 if (strMsg != "") { this.ErrorMsgLabel.Text = strMsg; return; } Session.Remove("MKT12_POP_SelectStore" + PageTimeStamp.Value); strErrMsg = "新增資料" + intCount.ToString() + "筆 成功"; ScriptManager.RegisterStartupScript(Page, this.GetType(), "ClientScript", "alert('"+strErrMsg+"');location.replace('MKT121.aspx?Code=MKT12');", true); #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
protected void Btn_Execute_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; string strZ_O = this.SLP_CodeFile1.Text; string strOldChanNo = this.SLP_StoreChain_OLD.Text; string strOldStore = this.SLP_Store_OLD.Text; string strSurveyDate = this.txtSURVEY_DATE.Text; string strNewChanNo = this.SLP_StoreChain_NEW.Text; string strNewStore = this.SLP_Store_NEW.Text; #region 門市 營業所Check if (SLP_CodeFile1.Text != "") { #region 原門市 營業所Check ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(strOldStore, "string")); BCO.MaintainMarketSurveyRecords bcoOldZ_O = new BCO.MaintainMarketSurveyRecords(ConnectionDB); DataTable dtZ_O = bcoOldZ_O.QueryZ_OByStore(ParameterList); if (dtZ_O == null || dtZ_O.Rows.Count == 0 || dtZ_O.Rows[0][0].ToString() != strZ_O) { ErrorMsgLabel.Text = "原門市不屬於此營業所範圍"; return; } #endregion #region 新門市 營業所Check ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(strNewStore, "string")); BCO.MaintainMarketSurveyRecords bcoNewZ_O = new BCO.MaintainMarketSurveyRecords(ConnectionDB); DataTable dtZ_ONew = bcoNewZ_O.QueryZ_OByStore(ParameterList); if (dtZ_ONew == null || dtZ_ONew.Rows.Count == 0 || dtZ_ONew.Rows[0][0].ToString() != strZ_O) { ErrorMsgLabel.Text = "新門市不屬於此營業所範圍"; return; } #endregion } #endregion #region 檢查原門市資料是否已存在市調計畫 ParameterList.Clear(); ParameterList.Add(""); ParameterList.Add(""); ParameterList.Add(GetValueSetParameter(strOldChanNo, "string")); ParameterList.Add(GetValueSetParameter(strOldStore, "string")); ParameterList.Add(GetValueSetParameter(strSurveyDate, "date")); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string")); ParameterList.Add(GetValueSetParameter(SLP_CodeFile1.Text, "string")); //營業所 BCO.MaintainMarketSurveyRecords bcoMainOld = new BCO.MaintainMarketSurveyRecords(ConnectionDB); DataTable dtExistMainOld = bcoMainOld.QueryExistPk(ParameterList); if (dtExistMainOld == null || dtExistMainOld.Rows.Count == 0) { ErrorMsgLabel.Text = "原門市資料不存在市調計畫,無法複製"; return; } #endregion #region 組合複製市調計畫條件至ArrayList ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(strOldChanNo, "string")); ParameterList.Add(GetValueSetParameter(strOldStore, "string")); ParameterList.Add(GetValueSetParameter(strNewChanNo, "string")); ParameterList.Add(GetValueSetParameter(strNewStore, "string")); ParameterList.Add(GetValueSetParameter(strSurveyDate, "date")); ParameterList.Add(GetValueSetParameter(Session["UID"].ToString(), "string")); ParameterList.Add(GetValueSetParameter(SLP_CodeFile1.Text, "string")); //營業所 #endregion #region 新門市必需存在於市調門市檔 BCO.MaintainMarketSurveyStore bco = new BCO.MaintainMarketSurveyStore(ConnectionDB); DataTable dtExist = bco.QueryExistPk(ParameterList); if (dtExist == null || dtExist.Rows.Count == 0) { ErrorMsgLabel.Text = "新門市不存在於市調門市檔"; return; } #endregion #region 檢查新門市資料是否已存在市調計畫 BCO.MaintainMarketSurveyRecords bcoMain = new BCO.MaintainMarketSurveyRecords(ConnectionDB); DataTable dtExistMain = bcoMain.QueryExistPk(ParameterList); if (dtExistMain != null && dtExistMain.Rows.Count > 0) { ErrorMsgLabel.Text = "複製市調計畫至新門市失敗, 新門市資料已存在市調計畫"; return; } #endregion #region 複製市調計畫至新門市 BCO.MaintainMarketSurveyRecords bcoCopy = new BCO.MaintainMarketSurveyRecords(ConnectionDB); // 執行複製市調計畫至新門市的動作 bcoCopy.CopyToNewStore(ParameterList, null); #endregion this.ErrorMsgLabel.Text = "複製市調計畫成功"; #region 關掉POP視窗 //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Window", "alert('儲存成功');window.close();", true); #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }
protected void Btn_Delete_Click(object sender, EventArgs e) { ErrorMsgLabel.Text = ""; if (this.hid_PageStatus.Value == "VIEW") { ErrorMsgLabel.Text = ""; #region 取得更新前舊值 #region 使用XML轉回DataSet DataSet DsMaster = new DataSet(); System.IO.StringReader srM = new System.IO.StringReader(MasterOLDData.InnerHtml); DsMaster.ReadXml(srM); DataTable dtMasterOLD = DsMaster.Tables[0]; #endregion //if (dtDetailOLD.Rows.Count == 0) //{ // throw new Exception("抓取不到舊值,更新失敗!"); //} #endregion #region 處理刪除作業 #region 組合刪除條件至ArrayList string v_Store = this.SLP_Store1.Text; string v_Investigator = this.txtInvestigator.Text; ArrayList returnList = new ArrayList(); returnList.Clear(); returnList.Add(GetValueSetParameter(v_Store, "string")); returnList.Add(GetValueSetParameter(v_Investigator, "string")); returnList.Add(Session["UID"].ToString()); //returnList.Add("1"); #endregion try { string strMsg = ""; BCO.MaintainMarketSurveyStore bco = new BCO.MaintainMarketSurveyStore(ConnectionDB); bco.DeleteSurveyStore(returnList, dtMasterOLD.Rows[0], null, out strMsg); if (strMsg != "") { //刪除異常 ScriptManager.RegisterStartupScript(Page, this.GetType(), "ClientScript", "alert('"+strMsg+"');location.replace('MKT121.aspx?Code=MKT12');", true); return; } ScriptManager.RegisterStartupScript(Page, this.GetType(), "ClientScript", "alert('刪除完成');location.replace('MKT121.aspx?Code=MKT12');", true); } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion } }
protected void Btn_Save_Click(object sender, EventArgs e) { try { SLP_User1.Text = Page.Request.Form[SLP_User1.TextBox_Code.UniqueID]; #region 資料儲存 if (txtInvestigator.Text.Trim() == "") { ErrorMsgLabel.Text = "請輸入「市調人員」"; return; } BCO.MaintainMarketSurveyStore bco = new BCO.MaintainMarketSurveyStore(ConnectionDB); { switch (this.hid_PageStatus.Value) { case "INSERT": #region 處理新增作業 { DataTable dtExist = new DataTable(); dtExist = bco.QueryExistPk(this.getParameterList()); if (dtExist != null && dtExist.Rows.Count > 0) { ErrorMsgLabel.Text = "新增失敗, 門市(" + this.SLP_Store1.Text + ")資料已存在"; return; } #region 儲存新增資料 string strMsg = ""; // 做資料儲存的動作 int vPID = bco.CreateSurveyStore(this.getParameterList(), null, out strMsg); if (strMsg != "") { //資料儲存異常 this.ErrorMsgLabel.Text = strMsg; return; } this.hiddenID.Value = Convert.ToString(vPID); #endregion } #endregion break; case "EDIT": { #region 使用XML轉回DataSet DataTable MasterOldDt = null; if (MasterOLDData.InnerHtml != "" && MasterOLDData.InnerHtml != "<NewDataSet />") { DataSet Ds = new DataSet(); System.IO.StringReader sr = new System.IO.StringReader(MasterOLDData.InnerHtml); Ds.ReadXml(sr); MasterOldDt = Ds.Tables[0]; } #endregion string strMsg = ""; // 做資料儲存的動作 bco.UpdateSurveyStore(this.getParameterList(), MasterOldDt.Rows[0], null, out strMsg); if (strMsg != "") { //資料儲存異常 this.ErrorMsgLabel.Text = strMsg; return; } break; } break; } #region 存檔後資料重新讀取 databind_Mst(); #endregion #region 存檔後狀態設定 this.hid_PageStatus.Value = "VIEW"; this.txt_PageStatus.Text = "VIEW"; #endregion } #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { SetPageStatus(); SetDefaultValue(); } }
/// <summary> /// 繫結資料 MST /// </summary> private void databind_Mst() { #region try { ErrorMsgLabel.Text = ""; BCO.MaintainMarketSurveyStore bco = new BCO.MaintainMarketSurveyStore(ConnectionDB); ParameterList.Clear(); ParameterList.Add(this.hiddenID.Value); DataTable Dt = bco.QuerySurveryStoreGetByID(ParameterList); #region 使用XML放置到前端資料 MasterOLDData.InnerHtml = Dt.DataSet.GetXml(); #endregion } catch (Exception ex) { ErrorMsgLabel.Text = ex.Message; } #endregion }//databind_Mst
/// <summary> /// 設定本次市調門市 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Btn_SurveyStore_Click(object sender, EventArgs e) { try { ErrorMsgLabel.Text = ""; DataTable Dt = new DataTable(); #region 取得查詢參數: 營業所 ParameterList.Clear(); ParameterList.Add(GetValueSetParameter(this.SLP_CodeFile1.Text, "string")); //營業所起 ParameterList.Add(GetValueSetParameter(this.SLP_CodeFile1.Text, "string")); //營業所迄 ParameterList.Add(GetValueSetParameter("", "string")); //市調人員 不納入查詢條件 ParameterList.Add(GetValueSetParameter("9999", "int")); #endregion #region 處理查詢 BCO.MaintainMarketSurveyStore bco = new MaintainMarketSurveyStore(ConnectionDB); Dt = bco.QuerySurveryStore(ParameterList); #endregion if (Dt == null || (Dt != null && Dt.Rows.Count <= 0)) { //ScriptManager.RegisterStartupScript(Page, this.GetType(), "MKT133.aspx", "alert(' 查無資料 ');", true); ErrorMsgLabel.Text = "查無資料"; } else { //dt_Detail = Dt.Copy(); } #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; #endregion } catch (Exception ex) { this.ErrorMsgLabel.Text = ex.ToString(); } finally { } }