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;
}
}
