//---------------------------------------------------------------------- public void LoadFormData() { string strSql = "select d.uid, d.OrgID as ���c�N��, \n"; strSql += "o.OrgName as ���c�W��, d.DeptName as �����W��,\n"; strSql += "d.DeptId as �����N�� from Dept d\n"; strSql += "inner join Organization o on d.OrgID=o.OrgID\n"; strSql += "where 1=1\n"; if (txtDeptName.Text != "") { strSql += "and d.DeptName like @DeptName\n"; } if (txtDeptDesc.Text != "") { strSql += " and d.DeptDesc=@DeptDesc"; } strSql += "order by d.uid "; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("DeptName", "%" + txtDeptName.Text + "%"); dict.Add("DeptDesc", "%" + txtDeptDesc.Text + "%"); DataTable dt = NpoDB.GetDataTableS(strSql, dict); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLink = Util.RedirectByTime("Dept_Edit.aspx", "DeptUID="); lblGridList.Text = npoGridView.Render(); }
//---------------------------------------------------------------------- public void LoadFormData() { string strSql = "select uid,GroupName as 群組名稱, GroupDesc as 群組描述,\n"; strSql += "GroupArea as 群組範圍, case when IsUse=1 then '使用' else '禁用' end as 是否使用\n"; strSql += "from AdminGroup where 1=1\n"; if (txtGroupName.Text != "") { strSql += "and GroupName like @GroupName\n"; } if (txtGroupDesc.Text != "") { strSql += "and GroupDesc like @GroupDesc\n"; } strSql += "order by uid\n"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("GroupName", "%" + txtGroupName.Text.Trim() + "%"); dict.Add("GroupDesc", "%" + txtGroupDesc.Text.Trim() + "%"); DataTable dt = NpoDB.GetDataTableS(strSql, dict); NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLink = Util.RedirectByTime("AdminGroup_Edit.aspx", "Uid="); lblGridList.Text = npoGridView.Render(); }
//---------------------------------------------------------------------- public void LoadFormData() { //�I�s��ƮwGetDataTable DataTable dt = GetDataTable(); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); //npoGridView.EditLink = Util.RedirectByTime("Church_Edit.aspx", "ChurchUID="); lblGridList.Text = npoGridView.Render(); }
//---------------------------------------------------------------------- public void LoadFormData() { string strSql = "select OrgID, OrgName as ���c�W��, OrgShortName as ���c²��,\n"; strSql += "OrgID as ���c�N��, Contactor as �p���H, Tel as �q��, Address as �a�}\n"; strSql += "from Organization order by OrgID"; DataTable dt = NpoDB.GetDataTableS(strSql, null); NPOGridView GridList = new NPOGridView(); GridList.Source = NPOGridViewDataSource.fromDataTable; GridList.dataTable = dt; GridList.Keys.Add("OrgID"); GridList.DisableColumn.Add("OrgID"); GridList.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); GridList.EditLink = Util.RedirectByTime("Organization_Edit.aspx", "OrgUID="); lblGridList.Text = GridList.Render(); }
//---------------------------------------------------------------------- //QueryAction�A�d�߾��v��Ʃάd�ߤ@���� //Query�G�d�ߤ@���� //History:�d�߾��v��� public void LoadFormData() { string strSql; DataTable dt; strSql = "select News.uid, NewsSubject as ���D, NewsType as ���O, DeptName as �o�G���,NewsRegDate as �o�G���,\n"; strSql += "NewsAuthor as �o�G��, NewsBeginDate as �_�l���, NewsEndDate as ������\n"; strSql += "from News\n"; strSql += "where (IsDelete=0 or IsDelete is null)\n"; if (HFD_CurrentQuerye.Value == "Query") { strSql += "and @SysDate between NewsBeginDate and NewsEndDate\n"; } else { strSql += "and @SysDate > NewsEndDate\n"; } if (txtNewsSubject.Text != "") { strSql += "and NewsSubject like @NewsSubject)\n"; } if (ddlDept.SelectedValue != "") { strSql += " and news.DeptName=@DeptName)\n"; } strSql += "order by NewsRegDate desc\n"; string SysDate = Util.DateTime2String(DateTime.Now, DateType.yyyyMMdd, EmptyType.ReturnEmpty); Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("SysDate", SysDate); dict.Add("NewsSubject", "%" + txtNewsSubject.Text + "%"); dict.Add("DeptName", ddlDept.SelectedValue); dt = NpoDB.GetDataTableS(strSql, dict); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLink = Util.RedirectByTime("News_Edit.aspx", "NewsUID="); lblGridList.Text = npoGridView.Render(); }
//---------------------------------------------------------------------- public void LoadFormData() { //查詢字串 string strSql = " select u.Uid, u.UserID as 帳號, u.UserName as 使用者名稱,\n"; strSql += " 部門名稱=d.DeptName,使用者身份=g.GroupName,\n"; strSql += " case when u.IsUse=1 then '使用' else '停用' end as 是否使用\n"; strSql += " from AdminUser u \n"; strSql += " left join AdminGroup g on g.uid=u.GroupID \n"; strSql += " left join Dept d on (u.DeptID=d.DeptID and u.OrgID=d.OrgID) \n"; strSql += " where u.OrgID=@OrgID\n"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("OrgID", SessionInfo.OrgID); if (txtUserID.Text != "") { strSql += " and u.UserID=@UserID"; dict.Add("UserID", txtUserID.Text); } if (txtUserName.Text != "") { strSql += " and u.UserName like @UserName"; dict.Add("UserName", "%" + txtUserName.Text.Trim() + "%"); } if (ddlDept.SelectedValue != "") { strSql += " and u.DeptID=@DeptID"; dict.Add("DeptID", ddlDept.SelectedValue); } if (ddlGroup.SelectedValue != "") { strSql += " and u.GroupID=@GroupID"; dict.Add("GroupID", ddlGroup.SelectedValue); } strSql += " order by u.UserID"; DataTable dt = NpoDB.GetDataTableS(strSql, dict); NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLink = Util.RedirectByTime("AdminUser_Edit.aspx", "Uid="); lblGridList.Text = npoGridView.Render(); }
//------------------------------------------------------------------------- protected string LoadGird() { string strSql = @" Select Uid as [Uid], AssetsNum as [財產編號] , Scope as 面積, Stock as [持份] , Parting as 變動狀態, TotalPrice as 總價 , LandNum as 座落地號 ,AssetsName as 財產名稱 , convert(varchar(10), IssueDate,111) as 發狀日期 , Mark as 備註 from MoveDetail where DeleteDate is null And MoveMainUid=@Uid "; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("Uid", Request.Form["Uid"]); DataTable dt = NpoDB.GetDataTableS(strSql, dict); string Uid = Request.Form["Uid"]; //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.ShowPage = false; npoGridView.Keys.Add("Uid"); npoGridView.DisableColumn.Add("Uid"); npoGridView.EditLinkTarget = "異動資料編輯','help=no,status=yes,resizable=yes,scroll=yes,center=yes,width=900px,height=300px"; npoGridView.EditLink = Util.RedirectByTime("MoveMgrList.aspx", "Mode=MOD&MoveMainUid=" + Uid + "&Uid="); return npoGridView.Render(); }
//---------------------------------------------------------------------- public void LoadFormData() { string strSql = @"select Uid, CaseGroup as [�ﶵ�s��], CaseId as [�Ƨ�], CaseName as [�ﶵ�W��] from CaseCode where 1=1 "; if (ddlGroupName.SelectedValue != "") { strSql += " and CaseGroup = @CaseGroup "; } if (txtCaseName.Text != "") { strSql += " and CaseName=@CaseName "; } //����w����� strSql += " and (islock<>1 or islock is null) "; strSql += " order by CaseGroup ,cast( CaseId as int) "; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("CaseGroup", ddlGroupName.SelectedValue); dict.Add("CaseName", "%" + txtCaseName.Text + "%"); DataTable dt = NpoDB.GetDataTableS(strSql, dict); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLink = Util.RedirectByTime("SelectionData_Edit.aspx", "DataUID="); lblGridList.Text = npoGridView.Render(); }
private void LoadFormData2() { //呼叫資料庫GetDataTable DataTable dt = 取得當日多重登入資料(); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("Uid"); npoGridView.DisableColumn.Add("Uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage2.Value); npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("LogtimeEdit.aspx", "Uid="); lblGridList.Text = npoGridView.Render(); string fixStr = ""; fixStr += "<script language=\"javascript\" type=\"text/javascript\">\n"; fixStr += " function makeLink(){\n"; fixStr += " //kuofly2015 這個邪惡的寫法是透過抓取畫面所有的TAG為TABLE者,其中CLASSNAME=TABLE_H的\n"; fixStr += " //將每一列強迫放上script作用\n"; fixStr += " var myTable = document.getElementsByTagName(\"TABLE\");\n"; fixStr += " for (x = 0; x < myTable.length; x++) {\n"; fixStr += " if (myTable[x].className == \"table_h\") {\n"; fixStr += " var myTableRight = myTable[x];\n"; fixStr += " var myRows = myTableRight.rows.length;\n"; fixStr += " for (i = 0; i < myRows; i++) {\n"; fixStr += " if (i > 0) {\n"; fixStr += " var objRow = myTableRight.rows[i];\n"; fixStr += " objRow.onclick = function () {\n"; fixStr += " document.getElementById('txtUserName').value = this.getElementsByTagName(\"TD\")[1].getElementsByTagName(\"SPAN\")[0].outerText;\n"; fixStr += " document.getElementById('txtlogtDate').value = this.getElementsByTagName(\"TD\")[0].getElementsByTagName(\"SPAN\")[0].outerText;\n"; fixStr += " };\n"; fixStr += " }\n"; fixStr += " }\n"; fixStr += " }\n"; fixStr += " }\n"; fixStr += " }\n"; fixStr += " makeLink();\n"; fixStr += "</script>\n"; lblScript.Text = fixStr; }
//--------------------------------------------------------------------------- protected void btnQuery_Click(object sender, EventArgs e) { btnUpdate.Enabled = GetQuarterDateCount("", ""); //該季若個人班表裡沒有資料就不能作編輯(是只該日期區間有沒有資料只要日期區間不用UserID) btnAdd.Visible = false; Dictionary<string, object> dict = new Dictionary<string, object>(); string strSql = @" select convert(char(10), SchDate, 111) as SchDate, periodA,periodB,periodC ,UserName, Case when periodA <> '' and periodA is not null then UserName +'('+ periodA +')' end as 上午班, Case when periodB <> '' and periodB is not null then UserName +'('+ periodB +')' end as 下午班, Case when periodC <> '' and periodC is not null then UserName +'('+ periodC +')' end as 晚上班 from ScheduleDetail s inner join AdminUser u on s.UserID=u.UserID where 1=1 "; strSql += "and CONVERT(char(7), SchDate, 111)=@SchDate\n"; if (ddlVoluntee.SelectedValue != "") { strSql += "and s.UserID=@UserID\n"; } strSql += "order by SchDate\n"; dict.Add("UserID", ddlVoluntee.SelectedValue); dict.Add("SchDate", GetYearMonth()); DataTable dt = NpoDB.GetDataTableS(strSql, dict); Dictionary<string, ScheduleUser> UserList = new Dictionary<string, ScheduleUser>(); foreach (DataRow dr in dt.Rows) { string ScheduleDate = dr["SchDate"].ToString(); ScheduleUser User; if (UserList.ContainsKey(ScheduleDate)) { User = UserList[ScheduleDate]; } else { User = new ScheduleUser(); UserList.Add(ScheduleDate, User); } if (dr["上午班"].ToString() != "") { User.ScheduleAM += dr["上午班"].ToString() + ","; } if (dr["下午班"].ToString() != "") { User.SchedulePM += dr["下午班"].ToString() + ","; } if (dr["晚上班"].ToString() != "") { User.ScheduleNM += dr["晚上班"].ToString() + ","; } } dt = CreateQueryTable(UserList); //需自訂欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.ShowPage = false; //----------------------------------------------------------------------- //欄位為 checkbox NPOGridViewColumn col = new NPOGridViewColumn("日期"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("日期"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("星期"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("星期"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("上午班"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("上午班"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("下午班"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("下午班"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("晚上班"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("晚上班"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- lblGridList.Text = npoGridView.Render(); }
//---------------------------------------------------------------------------- public void LoadFormData() { DataTable dt = CreateTable(); string UserID = ddlVoluntee.SelectedValue; string YearMonth = GetYearMonth(); DataTable dtSchedule = Util.GetDataTable("ScheduleDetail", "UserID", UserID, "CONVERT(char(7), SchDate, 111)", YearMonth, "SchDate", ""); foreach (DataRow dr in dtSchedule.Rows) { DateTime d = (DateTime)dr["SchDate"]; dt.Rows[d.Day - 1]["上午班"] = dr["periodA"].ToString(); dt.Rows[d.Day - 1]["下午班"] = dr["periodB"].ToString(); dt.Rows[d.Day - 1]["晚上班"] = dr["periodC"].ToString(); } //需自訂欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.ShowPage = false; //----------------------------------------------------------------------- //欄位為 checkbox NPOGridViewColumn col = new NPOGridViewColumn("日期"); col.ColumnType = NPOColumnType.Textbox; col.ControlKeyColumn.Add("uid"); col.Readonly = true; col.ControlName.Add("txtScheduleDate"); col.ControlId.Add("txtScheduleDate"); //col.ControlValue.Add("1"); col.ColumnName.Add("日期"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("星期"); col.ColumnType = NPOColumnType.Textbox; col.ControlKeyColumn.Add("uid"); col.Readonly = true; col.ControlName.Add("txtDayWeek"); col.ControlId.Add("txtDayWeek"); col.ColumnName.Add("星期"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("上午班"); col.ColumnType = NPOColumnType.Dropdownlist; col.ControlKeyColumn.Add("uid"); col.ControlName.Add("chkperiodA"); col.ControlId.Add("chkperiodA"); col.ColumnName.Add("上午班"); col.ControlOptionText.Add(""); col.ControlOptionText.Add("正常班"); col.ControlOptionText.Add("加班"); col.ControlOptionText.Add("補班"); col.ControlOptionText.Add("代班"); col.ControlOptionValue.Add(""); col.ControlOptionValue.Add("正常班"); col.ControlOptionValue.Add("加班"); col.ControlOptionValue.Add("補班"); col.ControlOptionValue.Add("代班"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("下午班"); col.ColumnType = NPOColumnType.Dropdownlist; col.ControlKeyColumn.Add("uid"); col.ControlName.Add("chkperiodB"); col.ControlId.Add("chkperiodB"); col.ColumnName.Add("下午班"); col.ControlOptionText.Add(""); col.ControlOptionText.Add("正常班"); col.ControlOptionText.Add("加班"); col.ControlOptionText.Add("補班"); col.ControlOptionText.Add("代班"); col.ControlOptionValue.Add(""); col.ControlOptionValue.Add("正常班"); col.ControlOptionValue.Add("加班"); col.ControlOptionValue.Add("補班"); col.ControlOptionValue.Add("代班"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- //------------------------------------------------------------------------- col = new NPOGridViewColumn("晚上班"); col.ColumnType = NPOColumnType.Dropdownlist; col.ControlKeyColumn.Add("uid"); col.ControlName.Add("chkperiodC"); col.ControlId.Add("chkperiodC"); col.ColumnName.Add("晚上班"); col.ControlOptionText.Add(""); col.ControlOptionText.Add("正常班"); col.ControlOptionText.Add("加班"); col.ControlOptionText.Add("補班"); col.ControlOptionText.Add("代班"); col.ControlOptionValue.Add(""); col.ControlOptionValue.Add("正常班"); col.ControlOptionValue.Add("加班"); col.ControlOptionValue.Add("補班"); col.ControlOptionValue.Add("代班"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- lblGridList.Text = npoGridView.Render(); }
//------------------------------------------------------------------------- protected string LoadRentalDetail() { string strSql = @" select Uid as Uid ,RenterUid ,convert(varchar(10), PaymentDate,111) as [實收租金日] ,PaymentType as [付租方式] ,RenterPayment as [實收租金] ,FinePayment as [違約金] ,OtherPayment as [其他費用] ,Supplement as [備註] from RentalDetail where RenterUid=@RenterUid and DeleteDate is null order by PaymentDate desc "; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("RenterUid", Request.Form["Uid"]); DataTable dt = NpoDB.GetDataTableS(strSql, dict); if (dt.Rows.Count == 0) { return ""; } //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.ShowPage = false; npoGridView.Keys.Add("Uid"); npoGridView.DisableColumn.Add("Uid"); npoGridView.QuerySyting.Add("Uid"); npoGridView.Keys.Add("RenterUid"); npoGridView.DisableColumn.Add("RenterUid"); npoGridView.QuerySyting.Add("RenterUid"); npoGridView.EditLinkTarget = "租金資料編輯','help=no,status=no,resizable=no,scroll=no,center=yes,width=700px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("RentalDetail_Edit.aspx", "Mode=MOD"); return npoGridView.Render(); }
private void LoadFormData() { //呼叫資料庫GetDataTable DataTable dt = GetDataTable(); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.DisableColumn.Add("itemuid"); npoGridView.DisableColumn.Add("classuid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLink = Util.RedirectByTime("Act_Edit.aspx", "Mode=Edit&Uid="); lblGridList.Text = npoGridView.Render(); }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { //呼叫資料庫GetDataTable DataTable dt = GetDataTable(); if (dt.Rows.Count == 0) { lblGridList.Text = ""; ShowSysMsg("查無資料"); return; } //******************************************************************************************** //自訂欄位 NPOGridView npoGridView = new NPOGridView(); //來源種類 npoGridView.Source = NPOGridViewDataSource.fromDataTable; //使用的 DataTable npoGridView.dataTable = dt; //不要顯示的欄位(可以多個) npoGridView.DisableColumn.Add("uid"); npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; //npoGridView.EditLink = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); //使用的 key 欄位,用在組成 QueryString 的 key 值(EditLink 會用到) npoGridView.Keys.Add("uid"); //如果 GridView 要翻頁, 要設定 CurrentPage 的值 if (npoGridView.ShowPage == true) { npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); } NPOGridViewColumn col; col = new NPOGridViewColumn("姓名"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("姓名"); //使用欄位名稱 col.CellStyle = "width:100px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("備註"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("備註"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------- col = new NPOGridViewColumn("電話"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("電話"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); // lblGridList.Text = npoGridView.Render(); //---------------------------------------------------------- col = new NPOGridViewColumn("建檔時間"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("建檔時間"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); //---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(大類)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(大類)"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(分項)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(分項)"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); lblGridList.Text = npoGridView.Render(); //---------------------------------------------------------- //******************************************************************************************** }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { //查詢資料庫 DataTable dt = GetDataTable(); //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); //不顯示欄位 npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLinkTarget = "轉介教會資料編輯','help=no,status=yes,resizable=yes,scrollbars=yes,center=yes,width=900px,height=500px"; //npoGridView.EditLink = Util.RedirectByTime("ChangeChurchEdit.aspx", "Mode=MOD&MoveMainUid=" + Uid + "&uid="); npoGridView.EditLink = Util.RedirectByTime("CaseChangeChurchEdit.aspx", "uid="); lblGridList.Text = npoGridView.Render(); }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { string strSql = @" select case isnull(c.uid, '') when '' then 0 else 1 end as selected, c.uid, c.Name as 教會名稱, c.Area as 區號,(select name from codecity where ZipCode=cc.ZipCode ) as 縣市,cc1.Name as 區域, c.Address As 地址, c.priest as 主任牧師, c.Contact as 聯絡窗口 --,c.ChurchEmail From Church as c inner join CodeCity cc on c.City = cc.ZipCode inner join CodeCity cc1 on c.Area = cc1.ZipCode where isnull(IsDelete, '') != 'Y' "; if (ddlCity.SelectedValue != "") { strSql += " and City = @City\n"; } if (HFD_Area.Value != "") { strSql += " and Area = @Area\n"; } if (txtName.Text != "") { strSql += " and c.Name like @Name\n"; } if (txtpriest.Text != "") { strSql += " and priest like @priest\n"; } if (txtContact.Text != "") { strSql += " and Contact like @Contact\n"; } if (txtAddress.Text != "") { strSql += " and Address like @Address\n"; } strSql += "order BY City,cc.zipcode,CC1.Name \n"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("City", ddlCity.SelectedValue); dict.Add("Area", HFD_Area.Value); dict.Add("Name", "%" + txtName.Text + "%"); dict.Add("priest", "%" + txtpriest.Text + "%"); dict.Add("Contact", "%" + txtContact.Text + "%"); dict.Add("Address", "%" + txtAddress.Text + "%"); DataTable dt = NpoDB.GetDataTableS(strSql, dict); int count = dt.Rows.Count; //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.ShowPage = false; NPOGridViewColumn col; //------------------------------------------------------------------------- col = new NPOGridViewColumn("選擇"); col.ColumnType = NPOColumnType.Checkbox; col.ControlKeyColumn.Add("uid"); col.CaptionWithControl = false; col.ControlName.Add("chkSelectLand"); col.ControlId.Add("chkSelectLand"); col.ControlValue.Add("0"); col.ControlText.Add(""); col.ColumnName.Add("selected"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("教會名稱 "); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("教會名稱"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("區號"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("區號"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("縣市 "); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("縣市"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("區域 "); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("區域"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("地址"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("地址"); npoGridView.Columns.Add(col); //---------------------------------------------------------------------- col = new NPOGridViewColumn("主任牧師 "); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("主任牧師"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("聯絡窗口 "); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("聯絡窗口"); npoGridView.Columns.Add(col); //col = new NPOGridViewColumn("Email"); //col.ColumnType = NPOColumnType.NormalText; //col.ColumnName.Add("ChurchEmail"); //npoGridView.Columns.Add(col); //------------------------------------------------------------------------- lblGridList.Text = npoGridView.Render(); }
//--------------------------------------------------------------------------- public static string GetHouseList(string LandUID) { string strSql = @" select hd.uid, hd.HouseAddress as [�a�W���a�}(�Ы�)], hd.HouseNo as [�ظ�] from EstateMap m inner join HouseData hd on m.HouseUID=hd.uid where 1=1 and isnull(hd.IsDelete, '') != 'Y' and LandUID=@LandUID "; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("LandUID", LandUID); DataTable dt = NpoDB.GetDataTableS(strSql, dict); int count = dt.Rows.Count; //Grid initial //�S���ݭn�S�O�B�z������ NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.ShowPage = false; npoGridView.EditLink = Util.RedirectByTime("HouseData_Edit.aspx", "HouseUID="); NPOGridViewColumn col; //------------------------------------------------------------------------- col = new NPOGridViewColumn("�a�W���a�}(�Ы�)"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("�a�W���a�}(�Ы�)"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("�ظ�"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("�ظ�"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- return npoGridView.Render(); }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { string strSql = @" select Distinct a.uid , a.CName AS 姓名,a.Memo as 備註 ,a.Phone AS 電話 from Member a inner join Consulting b on a.uid = b.MemberUID where 1=1 and isnull(a.IsDelete, '') != 'Y' and isnull(b.IsDelete, '') != 'Y' "; if (txtServiceUser.Text.Trim() != "") { strSql += " and ServiceUser = @ServiceUser\n"; } if (HFD_Marry.Value != "") { strSql += " and Marry like @Marry\n"; } if (txtEvent.Text.Trim() != "") { strSql += " and Event like @Event\n"; } if (txtPhone.Text.Trim() != "") { strSql += " and Phone like @Phone\n"; } if (txtName.Text.Trim() != "") { strSql += " and CName like @CName\n"; } if (txtBegCreateDate.Text.Trim() != "" && txtEndCreateDate.Text.Trim() != "") { strSql += " and CONVERT(varchar(100), CreateDate, 111) Between @BegCreateDate And @EndCreateDate\n"; } if (txtZipCode.Text.Trim() != "") { strSql += " And ZipCode=@ZipCode\n"; } if (ddlCity.SelectedValue != "") { strSql += " And City=@City\n"; } if (txtAddress.Text.Trim() != "") { strSql += " and Address like @Address\n"; } if (HFD_ConsultantItem.Value != "") { strSql += " And ConsultantItem like @ConsultantItem\n"; } //是否為基督徒 20150721新增 if (rblChristian.SelectedValue == "1") { strSql += " and a.Christian = '是'"; } else if (rblChristian.SelectedValue == "2") { strSql += " and a.Christian = '否'"; } else { strSql += " "; } strSql += " Order by CName desc"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("Event", "%" + txtEvent.Text.Trim() + "%"); dict.Add("CName", "%" + txtName.Text.Trim() + "%"); dict.Add("Marry", HFD_Marry.Value.ToString().TrimEnd(',') ); dict.Add("Phone", '%' + txtPhone.Text.Trim() + '%'); dict.Add("BegCreateDate", txtBegCreateDate.Text.Trim()); dict.Add("EndCreateDate", txtEndCreateDate.Text.Trim()); dict.Add("ServiceUser", txtServiceUser.Text.Trim()); //dict.Add("EditServiceUser", SessionInfo.UserID.ToString()); dict.Add("ZipCode", txtZipCode.Text.Trim()); dict.Add("City", ddlCity.SelectedValue); dict.Add("Address", "%" + txtAddress.Text.Trim() + "%"); dict.Add("ConsultantItem", "%" + HFD_ConsultantItem.Value + "%"); DataTable dt = NpoDB.GetDataTableS(strSql, dict); //int count = dt.Rows.Count; HFD_MemberID.Value = ""; if (dt.Rows.Count == 0) { lblGridList.Text = ""; ShowSysMsg ("查無資料"); return; } else { //int i = dt.Rows.Count; //for (i = 0; i <= dt.Rows.Count - 1; i++) //{ // HFD_MemberID.Value = HFD_MemberID.Value + dt.Rows[i]["memberuid"].ToString() + ","; //} } // dr = dt.Rows[0]; //lblReport.Text = GetRptHead() + GetReport(); //報表資料 //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; //npoGridView.Keys.Add("uid"); //npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); //Response.Write(@"<script>window.parent.location.href='ConsultEdit2.aspx';</script>"); //npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("QryReport.aspx", "uid="); //lblGridList.Text = npoGridView.Render(); //使用的 key 欄位,用在組成 QueryString 的 key 值(EditLink 會用到) npoGridView.Keys.Add("uid"); //如果 GridView 要翻頁, 要設定 CurrentPage 的值 if (npoGridView.ShowPage == true) { npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); } NPOGridViewColumn col; col = new NPOGridViewColumn("姓名"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("姓名"); //使用欄位名稱 col.CellStyle = "width:100px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("備註"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("備註"); //使用欄位名稱 npoGridView.EditLink = Util.RedirectByTime("QryReport.aspx", "uid="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------- col = new NPOGridViewColumn("電話"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("電話"); //使用欄位名稱 npoGridView.EditLink = Util.RedirectByTime("QryReport.aspx", "uid="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); lblGridList.Text = npoGridView.Render(); //if (Util.GetQueryString("menu_id") == "48") //{ // lblGridList.Text = npoGridView.Render(); //} //else //{ // lblReport.Text = GetRptHead() + GetReport(); //報表資料 //} }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { string strSql = @" select case isnull(uid, '') when '' then 0 else 1 end as selected , uid, CName As 姓名,Memo as 備註,Phone As 電話 from Member where 1=1 and isnull(IsDelete, '') != 'Y' "; if (txtPhone.Text.Trim() != "") { strSql += " and Phone like @Phone\n"; } if (txtName.Text.Trim() != "") { strSql += " and CName like @CName\n"; } if (txtMemo.Text.Trim() != "") { strSql += " and Memo like @Memo\n"; } Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("CName", "%" + txtName.Text.Trim() + "%"); dict.Add("Phone", '%' + txtPhone.Text.Trim() + '%'); dict.Add("Memo", '%' + txtMemo.Text.Trim() + '%'); DataTable dt = NpoDB.GetDataTableS(strSql, dict); int count = dt.Rows.Count; //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.ShowPage = false; NPOGridViewColumn col; //------------------------------------------------------------------------- col = new NPOGridViewColumn("選擇"); col.ColumnType = NPOColumnType.Checkbox; col.ControlKeyColumn.Add("uid"); col.CaptionWithControl = false; col.ControlName.Add("chkSelectUid"); col.ControlId.Add("chkSelectUid"); col.ControlValue.Add("0"); col.ControlText.Add(""); col.ColumnName.Add("selected"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("姓名"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("姓名"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("備註"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("備註"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("電話"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("電話"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- lblGridList.Text = npoGridView.Render(); }
//------------------------------------------------------------------------------------------------------------- public static string GetLandList(string HouseUID) { string strSql = @" select ld.uid, ld.LandNo as [�g�a�a��], ld.LandArea as [�v�a���n] from EstateMap m inner join LandData ld on m.LandUID=ld.uid where 1=1 and isnull(ld.IsDelete, '') != 'Y' and HouseUID=@HouseUID "; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("HouseUID", HouseUID); DataTable dt = NpoDB.GetDataTableS(strSql, dict); int count = dt.Rows.Count; //Grid initial //�S���ݭn�S�O�B�z������ NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.ShowPage = false; npoGridView.EditLink = Util.RedirectByTime("LandData_Edit.aspx", "LandUID="); NPOGridViewColumn col; //------------------------------------------------------------------------- col = new NPOGridViewColumn("�g�a�a��"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("�g�a�a��"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- col = new NPOGridViewColumn("�v�a���n"); col.ColumnType = NPOColumnType.NormalText; col.ColumnName.Add("�v�a���n"); npoGridView.Columns.Add(col); //------------------------------------------------------------------------- return npoGridView.Render(); }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { string strSql = @" Select a.uid as uid ,CName as 姓名, CASE When ChangeChurchSta IS NULL THEN '未處理' ELSE '已處理' END AS 處理狀態 , convert(nvarchar(10), a.changeChurchDate,111) as 轉介日期 From Member a left outer join Church b on a.ChurchUid=b.uid Where 1=1 And ChurchYN = '是' And isnull(a.IsDelete, '') != 'Y' And isnull(changechurchsta,'') != '已處理' "; if (txtName.Text != "") { strSql += " and CName like @CName\n"; } if (txtchangeChurchDate.Text != "") { strSql += " and changeChurchDate = @changeChurchDate\n"; } Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("CName", "%" + txtName .Text + "%"); dict.Add("changeChurchDate", txtchangeChurchDate.Text); DataTable dt = NpoDB.GetDataTableS(strSql, dict); int count = dt.Rows.Count; if (dt.Rows.Count == 0) { //資料異常 SetSysMsg("查無資料"); // Response.Redirect("ChangeChurchQry.aspx"); return; } DataRow dr = null; dr = dt.Rows[0]; //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLinkTarget = "轉介教會資料編輯','help=no,status=yes,resizable=yes,scrollbars=yes,center=yes,width=900px,height=500px"; //npoGridView.EditLink = Util.RedirectByTime("ChangeChurchEdit.aspx", "Mode=MOD&MoveMainUid=" + Uid + "&uid="); npoGridView.EditLink = Util.RedirectByTime("ChangeChurchEdit.aspx", "uid="); lblGridList.Text = npoGridView.Render(); }
//------------------------------------------------------------------------------ public void GetConsultData() { string strSql = @" select a.uid as uid, CName As 姓名,b.Memo as 備註,Phone As 電話, convert(varchar(19), CreateDate,120) as 建檔時間, ConsultantMain as [來電諮詢別(大類)], ConsultantItem as [來電諮詢別(分項)] from Consulting a inner join Member b on a.MemberUID = b.uid where 1=1 and isnull(a.IsDelete, '') != 'Y' and isnull(b.IsDelete, '') != 'Y' And (((ISNULL(Overseas,'')='' AND ISNULL(city,'')='')) or ((ISNULL(HarassPhone,'') <> '' AND ISNULL(Special,'') <>'') AND (ISNULL(ConsultantMain,'')='' or isnull(ConsultantItem,'')='')) OR ((ISNULL(HarassPhone,'') = '' AND ISNULL(Special,'')='') AND (ISNULL(ConsultantMain,'')='' or isnull(ConsultantItem,'')='')) OR( ISNULL(CName,'')='' OR ISNULL(sex,'')='' OR ISNULL(Marry,'')='' OR ISNULL(Christian,'')='' OR ISNULL(Event,'')='' OR ISNULL(CreateDate,'')='' OR ISNULL(EndDate,'')='') ) "; strSql += " And ServiceUser=@ServiceUser "; //if (SessionInfo.GroupID != "1") //{ // strSql += " And ServiceUser=@ServiceUser "; //} strSql += " Order by CreateDate desc"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("ServiceUser", SessionInfo.UserID.ToString()); DataTable dt = NpoDB.GetDataTableS(strSql, dict); int count = dt.Rows.Count; //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; //npoGridView.dataTable = dt; //npoGridView.Keys.Add("uid"); //npoGridView.DisableColumn.Add("uid"); //npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); //Response.Write(@"<script>window.parent.location.href='ConsultEdit2.aspx';</script>"); //npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; //npoGridView.EditLink = Util.RedirectByTime("../CaseMgr/ConsultEdit2.aspx", "ConsultingUID="); //return npoGridView.Render(); //lblConsult.Text = npoGridView.Render(); //******************************************************************************************** //自訂欄位 //NPOGridView npoGridView = new NPOGridView(); //來源種類 npoGridView.Source = NPOGridViewDataSource.fromDataTable; //使用的 DataTable npoGridView.dataTable = dt; //不要顯示的欄位(可以多個) npoGridView.DisableColumn.Add("uid"); npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("../CaseMgr/ConsultEdit2.aspx", "ConsultingUID="); //使用的 key 欄位,用在組成 QueryString 的 key 值(EditLink 會用到) npoGridView.Keys.Add("uid"); //如果 GridView 要翻頁, 要設定 CurrentPage 的值 if (npoGridView.ShowPage == true) { npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); } NPOGridViewColumn col; col = new NPOGridViewColumn("姓名"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("姓名"); //使用欄位名稱 col.CellStyle = "width:100px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("備註"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("備註"); //使用欄位名稱 col.Link = Util.RedirectByTime("../CaseMgr/ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------- col = new NPOGridViewColumn("電話"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("電話"); //使用欄位名稱 col.Link = Util.RedirectByTime("../CaseMgr/ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); // lblGridList.Text = npoGridView.Render(); //---------------------------------------------------------- col = new NPOGridViewColumn("建檔時間"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("建檔時間"); //使用欄位名稱 col.Link = Util.RedirectByTime("../CaseMgr/ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); //---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(大類)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(大類)"); //使用欄位名稱 col.Link = Util.RedirectByTime("../CaseMgr/ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(分項)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(分項)"); //使用欄位名稱 col.Link = Util.RedirectByTime("../CaseMgr/ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); lblConsult.Text = npoGridView.Render(); //---------------------------------------------------------- //******************************************************************************************** }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { //呼叫資料庫GetDataTable DataTable dt = GetDataTable(); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("Uid"); npoGridView.DisableColumn.Add("Uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("LogtimeEdit.aspx", "Uid="); lblGridList.Text = npoGridView.Render(); lblScript.Text = ""; }
//人員轉介教會 Church/ChangeChurchQry.aspx private string LoadChurchMember() { string strSql = @" Select a.uid as uid ,CName as 姓名, CASE When ChangeChurchSta IS NULL THEN '未處理' ELSE '已處理' END AS 處理狀態, b.Name As 教會 From Member a left outer join Church b on a.ChurchUid=b.uid Where 1=1 And ChurchYN = '是' And isnull(a.IsDelete, '') != 'Y' "; string Name = Request.Form["Name"]; string ChangeChurchSta = Request.Form["ChangeChurchSta"]; string Church = Request.Form["Church"]; string Event = Request.Form["Event"]; string ServiceUser = Request.Form["ServiceUser"]; string Phone = Request.Form["Phone"]; string BegCreateDate = Request.Form["BegCreateDate"]; string EndCreateDate = Request.Form["EndCreateDate"]; string ZipCode = Request.Form["ZipCode"]; string City = Request.Form["City"]; string Address = Request.Form["Address"]; //if (Church != "") //{ // strSql += " and b.Name like @ChurchName\n"; //} //if (Event != "") //{ // strSql += " and Event like @Event\n"; //} //if (Name != "") //{ // strSql += " and CName like @CName\n"; //} //if (Phone != "") //{ // strSql += " and Phone = @Phone\n"; //} //if (BegCreateDate != "" && EndCreateDate != "") //{ // strSql += " and CONVERT(varchar(100), CreateDate, 111) Between @BegCreateDate And @EndCreateDate\n"; //} //if (ZipCode != "") //{ // strSql += " And ZipCode=@ZipCode\n"; //} //if (City != "") //{ // strSql += " And City=@City\n"; //} //if (Address != "") //{ // strSql += " and a.Address like @Address\n"; //} //if (Name != "") //{ // strSql += " and CName like @CName\n"; //} if (ChangeChurchSta == "已處理") { strSql += " and ChangeChurchSta = @ChangeChurchSta\n"; } else { strSql += " and isnull(changechurchsta,'') != @ChangeChurchSta\n"; } Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("CName", "%" + Name + "%"); dict.Add("Event", "%" + Event + "%"); dict.Add("ServiceUser", "%" + ServiceUser + "%"); dict.Add("Phone", "%" + Phone + "%"); dict.Add("BegCreateDate", BegCreateDate); dict.Add("EndCreateDate", EndCreateDate); dict.Add("ZipCode", ZipCode); dict.Add("City", City); dict.Add("Address", "%" + Address + "%"); dict.Add("ChurchName", "%" + Church + "%"); dict.Add("ChangeChurchSta", "已處理"); DataTable dt = NpoDB.GetDataTableS(strSql, dict); string Uid = Request.Form["Uid"]; //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.ShowPage = false; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.EditLinkTarget = "轉介教會資料編輯','help=no,status=yes,resizable=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("ChangeChurchEdit.aspx", "Mode=MOD&MoveMainUid=" + Uid + "&uid="); return npoGridView.Render(); }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { string strSql = @" select a.uid as uid, CName As 姓名,b.Memo as [備註],Phone As 電話, convert(varchar(19), CreateDate,120) as 建檔時間, REVERSE(SUBSTRING(REVERSE(ConsultantMain),CHARINDEX(',',REVERSE(ConsultantMain))+1,LEN(ConsultantMain))) [來電諮詢別(大類)], REVERSE(SUBSTRING(REVERSE(ConsultantItem),CHARINDEX(',',REVERSE(ConsultantItem))+1,LEN(ConsultantItem))) [來電諮詢別(分項)] --, ConsultantMain as [來電諮詢別(大類)], ConsultantItem as [來電諮詢別(分項)] from Consulting a inner join Member b on a.MemberUID = b.uid where 1=1 and isnull(a.IsDelete, '') != 'Y' "; if (SessionInfo.GroupName == "系統管理員") { } else { strSql += " and ServiceUser = @ServiceUser\n"; } if (txtPhone.Text.Trim() != "") { strSql += " and Phone like @Phone\n"; } if (txtName.Text.Trim() != "") { strSql += " and CName like @CName\n"; } if (txtBegCreateDate.Text.Trim() != "" && txtEndCreateDate.Text.Trim() != "") { strSql += " and CONVERT(varchar(100), CreateDate, 111) Between @BegCreateDate And @EndCreateDate\n"; } strSql += " Order by CreateDate desc"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("CName", "%" + txtName.Text.Trim() + "%"); dict.Add("Phone", '%' + txtPhone.Text.Trim() + '%'); dict.Add("BegCreateDate", txtBegCreateDate.Text.Trim()); dict.Add("EndCreateDate", txtEndCreateDate.Text.Trim()); dict.Add("ServiceUser", SessionInfo.UserID.ToString()); DataTable dt = NpoDB.GetDataTableS(strSql, dict); if (dt.Rows.Count == 0) { lblGridList.Text = ""; ShowSysMsg("查無資料"); return; } //******************************************************************************************** //自訂欄位 NPOGridView npoGridView = new NPOGridView(); //來源種類 npoGridView.Source = NPOGridViewDataSource.fromDataTable; //使用的 DataTable npoGridView.dataTable = dt; //不要顯示的欄位(可以多個) npoGridView.DisableColumn.Add("uid"); npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); //使用的 key 欄位,用在組成 QueryString 的 key 值(EditLink 會用到) npoGridView.Keys.Add("uid"); //如果 GridView 要翻頁, 要設定 CurrentPage 的值 if (npoGridView.ShowPage == true) { npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); } NPOGridViewColumn col; col = new NPOGridViewColumn("姓名"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("姓名"); //使用欄位名稱 col.CellStyle = "width:100px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("備註"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("備註"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------- col = new NPOGridViewColumn("電話"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("電話"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px;word-break: break-all;"; npoGridView.Columns.Add(col); // lblGridList.Text = npoGridView.Render(); //---------------------------------------------------------- col = new NPOGridViewColumn("建檔時間"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("建檔時間"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); //---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(大類)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(大類)"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(分項)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(分項)"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); lblGridList.Text = npoGridView.Render(); //---------------------------------------------------------- //******************************************************************************************** }
private string LoadConsultQry() { string strSql = @" select a.uid as uid, CName As 姓名,b.Memo as [備註] , Phone As 電話, convert(varchar(19), CreateDate,120) as 建檔時間, ConsultantMain as [來電諮詢別(大類)], ConsultantItem as [來電諮詢別(分項)] from Consulting a inner join Member b on a.MemberUID = b.uid where 1=1 and isnull(a.IsDelete, '') != 'Y' "; string Phone = Request.Form["Phone"]; string Event = Request.Form["Event"]; string CName = Request.Form["CName"]; string Marry = Request.Form["Marry"]; string BegCreateDate = Request.Form["BegCreateDate"]; string EndCreateDate = Request.Form["EndCreateDate"]; string City = Request.Form["City"]; string Address = Request.Form["Address"]; string ConsultantItem = Request.Form["ConsultantItem"]; string ZipCode = Request.Form["ZipCode"]; string ServiceUser = Request.Form["ServiceUser"]; string EditServiceUser = Request.Form["EditServiceUser"]; if (Phone != "") { strSql += " and Phone like @Phone\n"; } if (Event != "") { strSql += " and Event like @Event\n"; } if (CName != "") { strSql += " and CName like @CName\n"; } if (Marry != "") { strSql += " and Marry like @Marry\n"; } if (BegCreateDate != "" && EndCreateDate != "") { strSql += " and CONVERT(varchar(100), CreateDate, 111) Between @BegCreateDate And @EndCreateDate\n"; } if (City != "") { strSql += " and City = @City\n"; } if (ZipCode != "") { strSql += " And ZipCode=@ZipCode\n"; } if (Address != "") { strSql += " and a.Address like @Address\n"; } if (ConsultantItem != "") { strSql += " And ConsultantItem like @ConsultantItem\n"; } //if (ServiceUser != "") //{ // strSql += " and ServiceUser like @ServiceUser\n"; //} if (EditServiceUser != "sys") { if (EditServiceUser != "") { strSql += " and ServiceUser=@ServiceUser\n"; } } strSql += " Order by CreateDate desc"; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("CName", "%" + CName + "%"); dict.Add("Phone", "%" + Phone + "%"); dict.Add("Event", "%" + Event + "%"); dict.Add("Marry", "%" + Marry + "%"); dict.Add("BegCreateDate", "%" + BegCreateDate + "%"); dict.Add("EndCreateDate", EndCreateDate); dict.Add("City", City); dict.Add("ZipCode", ZipCode); dict.Add("Address", "%" + Address + "%"); dict.Add("ConsultantItem", "%" + ConsultantItem + "%"); //dict.Add("ServiceUser", ServiceUser ); dict.Add("ServiceUser", EditServiceUser); DataTable dt = NpoDB.GetDataTableS(strSql, dict); string Uid = Request.Form["Uid"]; //******************************************************************************************** //自訂欄位 NPOGridView npoGridView = new NPOGridView(); //來源種類 npoGridView.Source = NPOGridViewDataSource.fromDataTable; //使用的 DataTable npoGridView.dataTable = dt; //不要顯示的欄位(可以多個) npoGridView.TableID = "tblDemo"; npoGridView.DisableColumn.Add("uid"); npoGridView.EditLinkTarget = "','target=_blank,help=no,status=yes,resizable=yes,scrollbars=yes,scrolling=yes,scroll=yes,center=yes,width=900px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); //使用的 key 欄位,用在組成 QueryString 的 key 值(EditLink 會用到) npoGridView.Keys.Add("uid"); NPOGridViewColumn col; col = new NPOGridViewColumn("姓名"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("姓名"); //使用欄位名稱 col.CellStyle = "width:100px"; // col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); npoGridView.Columns.Add(col); //---------------------------------------- // npoGridView.Keys.Add("uid"); col = new NPOGridViewColumn("備註"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("備註"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //---------------------------------------------- col = new NPOGridViewColumn("電話"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("電話"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); // lblGridList.Text = npoGridView.Render(); //---------------------------------------------------------- col = new NPOGridViewColumn("建檔時間"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("建檔時間"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:150px"; npoGridView.Columns.Add(col); // lblGridList.Text = npoGridView.Render(); //---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(大類)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(大類)"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //lblGridList.Text = npoGridView.Render(); ////---------------------------------------------------------- col = new NPOGridViewColumn("來電諮詢別(分項)"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("來電諮詢別(分項)"); //使用欄位名稱 col.Link = Util.RedirectByTime("ConsultEdit2.aspx", "ConsultingUID="); col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); //******************************************************************************************** return npoGridView.Render(); }
//------------------------------------------------------------------------------------------------------------- private void LoadFormData() { //呼叫資料庫GetDataTable DataTable dt = GetDataTable(); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.DisableColumn.Add("UserID"); npoGridView.DisableColumn.Add("ClassUid"); npoGridView.DisableColumn.Add("ItemUid"); npoGridView.DisableColumn.Add("ServiceData"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); npoGridView.EditLink = Util.RedirectByTime("ServiceRecordEdit.aspx", "Mode=Edit&Uid="); lblGridList.Text = npoGridView.Render(); if (HFD_Mode.Value == "Edit") { DataRow dr = null; dr = dt.Rows[0]; //志工 ddlUserName.SelectedValue = dr["UserID"].ToString(); //服務類別 ddlClassUid.SelectedValue = dr["ClassUid"].ToString(); //服務項目 ddlItemUid.SelectedValue = dr["ItemUid"].ToString(); //服務日期 txtServiceData.Text = Util.DateTime2String(dr["ServiceData"], DateType.yyyyMMdd, EmptyType.ReturnEmpty); } }
//---------------------------------------------------------------------- public void LoadFormData() { //呼叫資料庫GetDataTable DataTable dt = GetDataTable(txtsDate.Text,txteDate.Text); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); //npoGridView.EditLink = Util.RedirectByTime("Church_Edit.aspx", "ChurchUID="); lblGridList.Text = npoGridView.Render(); string strSql = "select UserID,UserName from AdminUser"; Util.FillDropDownList(ddlUserName, strSql, "UserName", "UserID", true); }
private void LoadFormData() { //呼叫資料庫GetDataTable DataTable dt = GetDataTable(); //Grid initial NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.Keys.Add("uid"); npoGridView.DisableColumn.Add("uid"); npoGridView.DisableColumn.Add("itemuid"); npoGridView.DisableColumn.Add("classuid"); npoGridView.CurrentPage = Util.String2Number(HFD_CurrentPage.Value); // npoGridView.EditLink = Util.RedirectByTime("Act_Edit.aspx", "Mode=Edit&Uid="); //kuofly20150325調整畫面的cell NPOGridViewColumn col; col = new NPOGridViewColumn("類別"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("類別"); //使用欄位名稱 col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("項目"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("項目"); //使用欄位名稱 col.CellStyle = "width:200px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("活動日期"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("活動日期"); //使用欄位名稱 col.CellStyle = "width:50px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("人數"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("人數"); //使用欄位名稱 col.CellStyle = "width:50px"; npoGridView.Columns.Add(col); col = new NPOGridViewColumn("參加者"); //產生所需欄位及設定 Title col.ColumnType = NPOColumnType.NormalText; //設定為純顯示文字 col.ColumnName.Add("參加者"); //使用欄位名稱 col.CellStyle = "width:100px;word-wrap: break-word;"; npoGridView.Columns.Add(col); // lblGridList.Text = npoGridView.Render(); }
//------------------------------------------------------------------------- protected string LoadRentUnit() { string strSql = @" select R.Uid as Uid ,R.RenterUid as RenterUid ,H.UnitAddress as [租賃單位地址] --,R.Supplement as [備註] from RentUnitData R left join HouseUnitData H on R.HouseUnitUid=H.Uid where R.RenterUid=@RenterUid and R.DeleteDate is null order by R.Uid "; Dictionary<string, object> dict = new Dictionary<string, object>(); dict.Add("RenterUid", Request.Form["Uid"]); DataTable dt = NpoDB.GetDataTableS(strSql, dict); if (dt.Rows.Count == 0) { return ""; } //Grid initial //沒有需要特別處理的欄位時 NPOGridView npoGridView = new NPOGridView(); npoGridView.Source = NPOGridViewDataSource.fromDataTable; npoGridView.dataTable = dt; npoGridView.ShowPage = false; npoGridView.Keys.Add("Uid"); npoGridView.DisableColumn.Add("Uid"); npoGridView.QuerySyting.Add("Uid"); npoGridView.Keys.Add("RenterUid"); npoGridView.DisableColumn.Add("RenterUid"); npoGridView.QuerySyting.Add("RenterUid"); npoGridView.EditLinkTarget = "租賃單位編輯','help=no,status=no,resizable=no,scroll=no,center=yes,width=700px,height=500px"; npoGridView.EditLink = Util.RedirectByTime("SelectRentUnit.aspx", "Mode=MOD"); return npoGridView.Render(); }