private void BindGrid() { int month = 0, organizecity = 0, staff = 0; if (int.TryParse(ddl_AccountMonth.SelectedValue, out month) && int.TryParse(tr_OrganizeCity.SelectValue, out organizecity)) { string condition = "AccountMonth = " + month.ToString() + " AND TrackDate IS NULL"; int.TryParse(select_Staff.SelectValue, out staff); if (staff > 0) { string client = string.Empty; IList <CM_Client> list = CM_ClientBLL.GetModelList(" OrganizeCity =" + organizecity + " AND ClientType = 3 AND ActiveFlag = 1 AND ApproveFlag = 1 AND [MCS_SYS].[dbo].[UF_Spilt](ExtPropertys,'|',27) = '1' AND ClientManager = " + staff.ToString()); if (list != null && list.Count > 0) { foreach (CM_Client item in list) { client += item.ID.ToString() + ","; } client = client.Substring(0, client.Length - 1); } if (!string.IsNullOrEmpty(client)) { condition += " AND (Staff = " + staff.ToString() + " OR Client in(" + client + "))"; } else { condition += " AND Staff = " + staff.ToString(); } } if (organizecity > 1) { //管理片区及所有下属管理片区 Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue)); string orgcitys = orgcity.GetAllChildNodeIDs(); if (orgcitys != "") { orgcitys += ","; } orgcitys += tr_OrganizeCity.SelectValue; condition += " AND OrganizeCity IN (" + orgcitys + ")"; } if (ddl_IsSubmit.SelectedValue != "0") { condition += " AND MCS_SYS.dbo.UF_Spilt(ExtPropertys,'|',5)='" + ddl_IsSubmit.SelectedItem.Text + "'"; } gv_List.BindGrid(TC_TrackCardBLL.GetModelList(condition)); cbx_CheckAll.Checked = false; } }
private void BindGrid() { int month = 0, organizecity = 0, staff = 0; DateTime trackdate = DateTime.Today; if (int.TryParse(tr_OrganizeCity.SelectValue, out organizecity) && DateTime.TryParse(tbx_TrackDate.Text, out trackdate)) { month = AC_AccountMonthBLL.GetMonthByDate(trackdate); string condition = "TrackDate = '" + trackdate.ToString("yyyy-MM-dd") + "'"; int.TryParse(select_Staff.SelectValue, out staff); if (staff > 0) { condition += " AND Staff = " + staff.ToString(); } if (organizecity > 1) { //管理片区及所有下属管理片区 Addr_OrganizeCityBLL orgcity = new Addr_OrganizeCityBLL(int.Parse(tr_OrganizeCity.SelectValue)); string orgcitys = orgcity.GetAllChildNodeIDs(); if (orgcitys != "") { orgcitys += ","; } orgcitys += tr_OrganizeCity.SelectValue; condition += " AND OrganizeCity IN (" + orgcitys + ")"; } if (ddl_IsSubmit.SelectedValue != "0") { condition += " AND MCS_SYS.dbo.UF_Spilt(ExtPropertys,'|',5)='" + ddl_IsSubmit.SelectedItem.Text + "'"; } IList <TC_TrackCard> list = TC_TrackCardBLL.GetModelList(condition); gv_List.BindGrid <TC_TrackCard>(list); } }