/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout(string type, string status) { try { DataTable DT = new DataTable(); Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; string sendid = ""; if (null != user_model) { sendid = user_model.ID; } else { sendid = "1"; } //string sqlWhere = " DELFLAG=0 and ProjectID=" + Session["Work_ProjectId"] + " and Status = " + status + " and SendUserID = '" + sendid + "' and AppType = '" + type + "'"; //string sqlWhere = " DELFLAG=0 and ProjectID=" + DDL_project.SelectedValue.ToString() + " and Status = " + status + " and SendUserID = '" + sendid + "' and AppType = '" + type + "'"; string sqlWhere = ""; if (status == "") { sqlWhere = " DELFLAG=0 and SendUserID = '" + sendid + "' and AppType = '" + type + "'"; } else { sqlWhere = " DELFLAG=0 and Status = " + status + " and SendUserID = '" + sendid + "' and AppType = '" + type + "'"; } int count = pageControl.tableRowCout(sqlWhere, "vProject_Apply", "ID"); dtrowsHidden.Value = count.ToString(); } catch { } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout() { try { Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"]; string sqlWhere1 = ""; if (DDL_Status.SelectedValue.ToString().Equals("")) { sqlWhere1 = "DELFLAG=0 and ProjectID=" + Session["Work_ProjectId"]; } else { sqlWhere1 = "DELFLAG=0 and ProjectID=" + Session["Work_ProjectId"] + "and Status=" + DDL_Status.SelectedValue; } //必须是登陆者参与的项目或者登陆者自己创建的项目登陆者才能看到。 // sqlWhere1 = sqlWhere1 + " AND (UserInfo LIKE '%" + user_model.REALNAME + "(" + user_model.USERNAME + ")" + "%' OR SendUserID ='"+user_model.ID+"') "; //根据2010年12月14日的需求,要所有人都能看到任务,但是没有参与的人员,则不给可以选择的按钮 DataTable DT = new DataTable(); int count = pageControl.tableRowCout(sqlWhere1, "Project_Task", "ID"); dtrowsHidden.Value = count.ToString(); } catch { } }
/// <summary> /// 根据当前页的搜索条件、留言属于那个模块、模块中信息的ID /// </summary> /// <param name="key">搜索条件</param> private void setRowCout(string key) { try { DataTable dt = new DataTable(); string sqlwhere1 = ""; sqlwhere1 = sqlWhere(key); int count = PageControl.tableRowCout(sqlwhere1, "GUESTBOOK_MAIN", "ID"); if (count > 0) { dtrowsHidden.Value = count.ToString(); } } catch { } }
///// <summary> ///// 获取到当前栏目Dropdownlist记录 ///// </summary> //protected void MakeDropdownlist(string key) //{ // //Model.SessionUser sessionUser = new Dianda.Model.SessionUser(); // //sessionUser = (Model.SessionUser)Session["sessionUserModel"]; // string WRITER = Session["USERID_SYSUSER"].ToString();// sessionUser.USERID.ToString();//Session["USERNAME"].ToString();//发布者 // DataTable DT = new DataTable(); // string sqlwhere1 = ""; // sqlwhere1 = " (delflag='0') AND(ID IN (SELECT ColumnsID FROM NEWS_USERID_COLUMNSID WHERE (UserID='" + WRITER + "') AND (ISAdd = 1))) order by COLUMNSPATH"; // DT = ColumnsBll.GetAllList(sqlwhere1).Tables[0]; // for (int i = 0; i < DT.Rows.Count; i++) // { // string parentid = DT.Rows[i]["PARENTID"].ToString(); // string path = DT.Rows[i]["COLUMNSPATH"].ToString(); // if (parentid != "-1") // { // string kg = null; // for (int x = 0; x < (path.Length) / 32; x++) // { // kg += " "; // } // DT.Rows[i]["NAME"] = kg + "|--" + DT.Rows[i]["NAME"].ToString(); // } // ListItem L1 = new ListItem(); // L1.Text = DT.Rows[i]["NAME"].ToString(); // L1.Value = DT.Rows[i]["ID"].ToString(); // DropDownList_keys.Items.Add(L1); // } // if (DT.Rows.Count > 0) // { // } // else // { // DropDownList_keys.Visible = false; // } //} /// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout(string key, string KeySel) { try { DataTable dt = new DataTable(); string sqlwhere1 = " delflag='0'"; sqlwhere1 = sqlWhere(key, KeySel); // dt =DOC_transport_FromBll.GetList(sqlwhere1).Tables[0]; int count = PageControl.tableRowCout(sqlwhere1, "DOC_transport_From", "ID"); // int count = dt.Rows.Count; if (count > 0) { dtrowsHidden.Value = count.ToString(); } } catch { } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void SetRowCount() { try { int count = pageControl.tableRowCout("", "vBudget_Department_Statistical", "1"); if (count > 0) { dtrowsHidden.Value = count.ToString(); } else { dtrowsHidden.Value = "0"; } } catch { } }
/// <summary> /// 获取到当前数据集中总共有多少条记录 /// </summary> private void setRowCout() { try { UserModel = (Dianda.Model.USER_Users)Session["USER_Users"]; DataTable dt = new DataTable(); string sqlwhere1 = " delflag='0' and UserID = '" + UserModel.ID + "'"; // dt = NewsBll.GetAllList(sqlwhere1).Tables[0]; int count = PageControl.tableRowCout(sqlwhere1, "Personal_Notepad", "UserID"); // int count = dt.Rows.Count; if (count > 0) { dtrowsHidden.Value = count.ToString(); } } catch { } }