protected void lvDataList_ItemCommand(object sender, ListViewCommandEventArgs e) { //取得Key值 string Get_DataID = ((HiddenField)e.Item.FindControl("hf_DataID")).Value; //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); try { //----- 方法:刪除資料 ----- if (false == _data.Delete(Get_DataID, out ErrMsg)) { CustomExtension.AlertMsg("刪除失敗", thisPage); return; } else { //導向本頁 Response.Redirect(thisPage); } } catch (Exception) { throw; } finally { _data = null; } }
/// <summary> /// 取得類別資料 /// </summary> /// <param name="ddl">下拉選單object</param> /// <param name="type">1:會議室</param> /// <param name="rootName">第一選項顯示名稱</param> private void Get_ClassList(DropDownList ddl, string type, string rootName) { //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); //----- 原始資料:取得所有資料 ----- var query = _data.GetClassItem(type, Req_Lang, out ErrMsg); //----- 資料整理 ----- ddl.Items.Clear(); if (!string.IsNullOrEmpty(rootName)) { ddl.Items.Add(new ListItem(rootName, "")); } foreach (var item in query) { string fullLabel = item.Label; ddl.Items.Add(new ListItem(fullLabel, item.ID.ToString())); } query = null; }
private void LookupData_Detail2() { //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); try { //----- 原始資料:取得所有資料 ----- var query = _data.GetCheckInList_NoName(Req_DataID, out ErrMsg); //----- 資料整理:繫結 ----- lvList_unNamedList.DataSource = query; lvList_unNamedList.DataBind(); query = null; } catch (Exception) { throw; } finally { //Release _data = null; } }
/// <summary> /// 資料新增 /// </summary> private void Add_Data() { //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); try { //----- 設定:資料欄位 ----- //產生Guid string guid = CustomExtension.GetGuid(); string _traceID = NewTraceID(); string _subject = tb_Subject.Text; string _disp = rbl_Display.SelectedValue; Int32 _sort = Convert.ToInt32(tb_Sort.Text); string _startTime = tb_StartTime.Text; string _endTime = tb_EndTime.Text; Int32 _place = Convert.ToInt32(ddl_Place.SelectedValue); string _otherPlace = tb_OtherPlace.Text; //instance var data = new BaseData { Data_ID = new Guid(guid), TraceID = _traceID, Subject = _subject, Display = _disp, Sort = _sort, StartTime = _startTime, EndTime = _endTime, Place = _place, OtherPlace = _otherPlace }; //----- 方法:新增資料 ----- if (!_data.Create(data, out ErrMsg)) { ph_ErrMessage.Visible = true; lt_ShowMsg.Text = ErrMsg; CustomExtension.AlertMsg("新增失敗", ""); return; } else { //導向本頁 string url = FuncPath() + "/Edit/" + guid + "#section1"; Response.Redirect(url); } } catch (Exception) { throw; } finally { _data = null; } }
/// <summary> /// 資料修改 /// </summary> private void Edit_Data() { //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); try { //----- 設定:資料欄位 ----- string _dataID = hf_DataID.Value; string _subject = tb_Subject.Text; string _disp = rbl_Display.SelectedValue; Int32 _sort = Convert.ToInt32(tb_Sort.Text); string _startTime = tb_StartTime.Text; string _endTime = tb_EndTime.Text; Int32 _place = Convert.ToInt32(ddl_Place.SelectedValue); string _otherPlace = tb_OtherPlace.Text; //instance var data = new BaseData { Subject = _subject, Display = _disp, Sort = _sort, StartTime = _startTime, EndTime = _endTime, Place = _place, OtherPlace = _otherPlace }; //----- 方法:更新資料 ----- if (!_data.Update(_dataID, data, out ErrMsg)) { ph_ErrMessage.Visible = true; lt_ShowMsg.Text = ErrMsg; CustomExtension.AlertMsg("更新失敗", ""); return; } else { //導向本頁 Response.Redirect(thisPage); } } catch (Exception) { throw; } finally { _data = null; } }
/// <summary> /// 名單設定 /// </summary> protected void btn_Setting_Click(object sender, EventArgs e) { //----- 判斷 ----- //[欄位檢查] - 權限編號 string inputValue = tree_Values.Text; if (string.IsNullOrEmpty(inputValue)) { CustomExtension.AlertMsg("名單未勾選任何人,請確認!", ""); return; } //[取得參數值] - 編號組合 string[] strAry = Regex.Split(inputValue, @"\,{1}"); var query = from el in strAry select new { Val = el.ToString().Trim() }; //----- 宣告 ----- List <NameList> dataList = new List <NameList>(); foreach (var item in query) { //加入項目 var data = new NameList { Who = item.Val }; //將項目加入至集合 dataList.Add(data); } //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); //----- 方法:更新資料 ----- if (false == _data.CreateDetail(Req_DataID, dataList, out ErrMsg)) { CustomExtension.AlertMsg("名單設定失敗", ""); return; } else { //導向本頁 Response.Redirect(thisPage + "#section1"); } }
protected void lvList_NameList_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { /* * (看實際情況)下一版本改為ajax處理, 不然跳頁會不好用 */ //取得Key值 string _SignWho = ((HiddenField)e.Item.FindControl("hf_NameID")).Value; //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); try { //instance var data = new CheckIn { SignWho = _SignWho, SignTime = DateTime.Now.ToString().ToDateString("yyyy/MM/dd HH:mm:ss"), FromIP = "", IsAgent = "Y" }; //do Check if (_data.CheckSign(Req_DataID, data, out ErrMsg)) { CustomExtension.AlertMsg("重複簽到", thisPage); return; } //do Create if (false == _data.CreateSign(Req_DataID, data, out ErrMsg)) { CustomExtension.AlertMsg("代簽失敗", ""); return; } //導向本頁 Response.Redirect(thisPage + "#section2"); } catch (Exception) { throw; } finally { //Release _data = null; } } }
protected void lvList_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.Item.ItemType == ListViewItemType.DataItem) { //取得Key值 string _SignWho = fn_Param.MemberID; string _GetIP = CustomExtension.GetIP(); //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); try { //instance var data = new CheckIn { SignWho = _SignWho, SignTime = DateTime.Now.ToString().ToDateString("yyyy/MM/dd HH:mm:ss"), FromIP = _GetIP, IsAgent = "N" }; //do Check if (_data.CheckSign(Req_DataID, data, out ErrMsg)) { CustomExtension.AlertMsg("重複簽到", FuncPath()); return; } //do Create if (false == _data.CreateSign(Req_DataID, data, out ErrMsg)) { CustomExtension.AlertMsg("簽到失敗", thisPage); return; } //導向首頁 Response.Redirect(FuncPath()); } catch (Exception) { throw; } finally { //Release _data = null; } } }
/// <summary> /// 取得資料 /// </summary> private void LookupDataList() { //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); Dictionary <string, string> search = new Dictionary <string, string>(); try { #region >> 條件篩選 << search.Add("Who", fn_Param.MemberID); #endregion //----- 原始資料:取得所有資料 ----- var query = _data.GetMeetingList(search, out ErrMsg); //----- 資料整理:繫結 ----- lvList.DataSource = query; lvList.DataBind(); //----- 資料整理:顯示分頁(放在DataBind之後) ----- if (query.Rows.Count == 0) { ph_EmptyData.Visible = true; ph_Data.Visible = false; } else { ph_EmptyData.Visible = false; ph_Data.Visible = true; } } catch (Exception) { throw; } finally { _data = null; } }
/// <summary> /// 取得資料 /// </summary> private void LookupDataList() { //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); Dictionary <string, string> search = new Dictionary <string, string>(); try { #region >> 條件篩選 << search.Add("Who", fn_Param.MemberID); search.Add("DataID", Req_DataID); #endregion //----- 原始資料:取得所有資料 ----- var query = _data.GetMeetingList(search, out ErrMsg); //----- 資料整理:繫結 ----- lvList.DataSource = query; lvList.DataBind(); //No data if (query.Rows.Count == 0) { Response.Redirect(FuncPath()); return; } } catch (Exception) { throw; } finally { _data = null; } }
/// <summary> /// 取得資料 /// </summary> private void LookupData() { //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); Dictionary <string, string> search = new Dictionary <string, string>(); try { //----- 原始資料:取得所有資料 ----- search.Add("DataID", Req_DataID); var query = _data.GetOne(search, out ErrMsg).FirstOrDefault(); //----- 資料整理:繫結 ----- if (query == null) { CustomExtension.AlertMsg("無法取得資料,即將返回列表頁.", Page_SearchUrl); return; } #region >> 欄位填寫 << hf_DataID.Value = query.Data_ID.ToString(); lb_TraceID.Text = query.TraceID; rbl_Display.SelectedValue = query.Display; tb_Sort.Text = query.Sort.ToString(); tb_Subject.Text = query.Subject; tb_StartTime.Text = query.StartTime.ToDateString("yyyy/MM/dd HH:mm"); tb_EndTime.Text = query.EndTime.ToDateString("yyyy/MM/dd HH:mm"); ddl_Place.SelectedValue = query.Place.ToString(); tb_OtherPlace.Text = query.OtherPlace; //Details ph_Details.Visible = true; //與會名單tree / list ph_DetailJS.Visible = true; //tree js ph_tip1.Visible = false; //提示建立資料 #endregion //維護資訊 info_Creater.Text = query.Create_Name; info_CreateTime.Text = query.Create_Time; info_Updater.Text = query.Update_Name; info_UpdateTime.Text = query.Update_Time; //簽到判斷, 大於0, 鎖住部份欄位 Int32 _signCnt = query.SignCnt; if (_signCnt > 0) { tb_StartTime.Enabled = false; tb_EndTime.Enabled = false; ddl_Place.Enabled = false; tb_OtherPlace.Enabled = false; ph_LockMessage.Visible = true; } //載入單身 LookupData_Detail1(); LookupData_Detail2(); } catch (Exception) { throw; } finally { //Release _data = null; } }
/// <summary> /// 取得資料 /// </summary> private void LookupDataList(int pageIndex) { //----- 宣告:網址參數 ----- int RecordsPerPage = 10; //每頁筆數 int StartRow = (pageIndex - 1) * RecordsPerPage; //第n筆開始顯示 int TotalRow = 0; //總筆數 int DataCnt = 0; ArrayList PageParam = new ArrayList(); //分類暫存條件參數 //----- 宣告:資料參數 ----- SignDataRepository _data = new SignDataRepository(); Dictionary <string, string> search = new Dictionary <string, string>(); try { #region >> 條件篩選 << //[查詢條件] - Keyword if (!string.IsNullOrWhiteSpace(Req_Keyword)) { search.Add("Keyword", Req_Keyword); PageParam.Add("k=" + Server.UrlEncode(Req_Keyword)); filter_Keyword.Text = Req_Keyword; } //[查詢條件] - Place if (!string.IsNullOrWhiteSpace(Req_Place)) { search.Add("Place", Req_Place); PageParam.Add("place=" + Server.UrlEncode(Req_Place)); filter_place.SelectedValue = Req_Place; } //[取得/檢查參數] - Date between string _today = DateTime.Today.ToShortDateString(); string _sDate = Req_sDate.Equals("") ? _today : Req_sDate; string _eDate = Req_eDate.Equals("") ? _today : Req_eDate; //網址參數 PageParam.Add("sDate=" + Server.UrlEncode(_sDate)); filter_sDate.Text = _sDate; PageParam.Add("eDate=" + Server.UrlEncode(_eDate)); filter_eDate.Text = _eDate; //參數,日期區間 search.Add("sDate", Req_sDate); //代入SQL Param search.Add("eDate", Req_eDate); //代入SQL Param search.Add("dateSection", "Y"); #endregion //----- 原始資料:取得所有資料 ----- var query = _data.GetList(search, StartRow, RecordsPerPage , out DataCnt, out ErrMsg); //----- 資料整理:取得總筆數 ----- TotalRow = DataCnt; //----- 資料整理:頁數判斷 ----- if (pageIndex > ((TotalRow / RecordsPerPage) + ((TotalRow % RecordsPerPage) > 0 ? 1 : 0)) && TotalRow > 0) { StartRow = 0; pageIndex = 1; } //----- 資料整理:繫結 ----- lvDataList.DataSource = query; lvDataList.DataBind(); //----- 資料整理:顯示分頁(放在DataBind之後) ----- if (query.Count() == 0) { ph_EmptyData.Visible = true; ph_Data.Visible = false; //Clear CustomExtension.setCookie("SignManage", "", -1); } else { ph_EmptyData.Visible = false; ph_Data.Visible = true; //分頁設定 string getPager = CustomExtension.Pagination(TotalRow, RecordsPerPage, pageIndex, 5 , thisPage, PageParam, false, true); Literal lt_Pager = (Literal)this.lvDataList.FindControl("lt_Pager"); lt_Pager.Text = getPager; //重新整理頁面Url string reSetPage = "{0}?page={1}{2}".FormatThis( thisPage , pageIndex , (PageParam.Count == 0 ? "" : "&") + string.Join("&", PageParam.ToArray())); //暫存頁面Url, 給其他頁使用 CustomExtension.setCookie("SignManage", Server.UrlEncode(reSetPage), 1); } } catch (Exception) { throw; } finally { _data = null; } }