/// <summary> /// 获取该项目的人员列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-16</remarks> public DataTable GetMemberList(E_ItemMember data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@EnterpriseID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; return(DbHelperSQL.RunProcedureTable("ProcEP_B_ItemMember_SelectList", parms)); }
/// <summary> /// 总监删除个人用户 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-18</remarks> public bool Delete(E_ItemMember data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.Int), }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.UserID; int ReturnValue; DbHelperSQL.RunProcedures("ProcEP_B_ItemMemberS_Delete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 总监删除个人用户 /// </summary> private void DeleteMember() { int uid; if (!int.TryParse(nv["uid"], out uid)) { HttpContext.Current.Response.Write("0"); return; } //判断是否为总监,若不是则返回。 if (bp.RoleID != ((int)MLMGC.DataEntity.User.EnumRole.总监)) { HttpContext.Current.Response.Write("0"); return; } E_ItemMember data = new E_ItemMember(); data.EnterpriseID = bp.EnterpriceID; data.UserID = uid; bool flag = new T_ItemMember().Delete(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
/// <summary> /// 总监删除个人用户 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-18</remarks> public bool Delete(E_ItemMember data) { return(dal.Delete(data)); }
/// <summary> /// 获取该项目的人员列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-16</remarks> public DataTable GetMemberList(E_ItemMember data) { return(dal.GetMemberList(data)); }
/// <summary> /// 绑定页面加载数据 /// </summary> protected void databind() { //------绑定失败理由------ ddlScrap.DataSource = new T_Scrap().GetList(new E_Scrap() { EnterpriseID = EnterpriceID }); ddlScrap.DataTextField = "ScrapName"; ddlScrap.DataValueField = "ScrapID"; ddlScrap.DataBind(); ddlScrap.Items.Insert(0, new ListItem("", "-1")); //------绑定用户列表------ E_ItemMember dataT = new E_ItemMember(); dataT.EnterpriseID = EnterpriceID; DataTable dt = new T_ItemMember().GetMemberList(dataT); ddlObject.DataSource = dt; ddlObject.DataTextField = "RealName"; ddlObject.DataValueField = "UserID"; ddlObject.DataBind(); //插入一个“全部”选项 ddlObject.Items.Insert(0, new ListItem("全部", "0")); //-------查询对象------------ ddlObject.SelectedValue = Requests.GetQueryString("objid"); //----------查询结果----------- //获取名录属性信息 E_Property dataProperty = new T_Property().Get(new E_Property() { EnterpriseID = EnterpriceID }); TradeFlag = Convert.ToBoolean((int)dataProperty.TradeFlag); AreaFlag = Convert.ToBoolean((int)dataProperty.AreaFlag); SourceFlag = Convert.ToBoolean((int)dataProperty.SourceFlag); E_ItemClientInfo data = new E_ItemClientInfo(); data.EnterpriseID = EnterpriceID; data.Status = MLMGC.DataEntity.Item.EnumClientStatus.报废客户; data.UserID = Convert.ToInt32(ddlObject.SelectedValue); //data.EPUserTMRID = Convert.ToInt32(ddlObject.SelectedValue); data.ClientName = Requests.GetQueryString("name"); txtName.Text = data.ClientName; data.Property = dataProperty; data.SourceID = Requests.GetQueryInt("sourceid", -1); data.TradeID = Requests.GetQueryInt("tradeid", -1); data.AreaID = Requests.GetQueryInt("areaid", -1); Property1.SourceID = data.SourceID; Property1.TradeID = data.TradeID; Property1.AreaID = data.AreaID; data.ScrapID = Requests.GetQueryInt("scrapid", -1); ddlScrap.SelectedValue = data.ScrapID.ToString(); //分页参数 data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageSize = pageSize; data.Page.PageIndex = pageIndex; //绑定数据 rpList.DataSource = new T_ItemClientInfo().LeaderScrapList(data); rpList.DataBind(); //设置分页样式 pageList1.PageSize = pageSize; pageList1.CurrentPageIndex = pageIndex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; //----------------------------- }
/// <summary> /// 绑定页面加载数据 /// </summary> protected void databind() { //------初始化查询日期------ txtStartDate.Text = DateTime.Now.ToString("yyyy-MM-01"); txtEndDate.Text = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); //------绑定用户列表------ E_ItemMember dataT = new E_ItemMember(); dataT.EnterpriseID = EnterpriceID; DataTable dt = new T_ItemMember().GetMemberList(dataT); ddlObject.DataSource = dt; ddlObject.DataTextField = "RealName"; ddlObject.DataValueField = "UserID"; ddlObject.DataBind(); //插入一个“全部”选项 ddlObject.Items.Insert(0, new ListItem("全部", "0")); //-------查询对象------------ ddlObject.SelectedValue = Requests.GetQueryString("objid"); //----------查询结果----------- //获取名录属性信息 E_Property dataProperty = new T_Property().Get(new E_Property() { EnterpriseID = EnterpriceID }); TradeFlag = Convert.ToBoolean((int)dataProperty.TradeFlag); AreaFlag = Convert.ToBoolean((int)dataProperty.AreaFlag); SourceFlag = Convert.ToBoolean((int)dataProperty.SourceFlag); E_ItemClientInfo data = new E_ItemClientInfo(); data.EnterpriseID = EnterpriceID; data.Status = MLMGC.DataEntity.Item.EnumClientStatus.成交客户; data.UserID = Convert.ToInt32(ddlObject.SelectedValue); //data.EPUserTMRID = Convert.ToInt32(ddlObject.SelectedValue); data.ClientName = Requests.GetQueryString("name"); txtName.Text = data.ClientName; data.Property = dataProperty; data.SourceID = Requests.GetQueryInt("sourceid", -1); data.TradeID = Requests.GetQueryInt("tradeid", -1); data.AreaID = Requests.GetQueryInt("areaid", -1); Property1.SourceID = data.SourceID; Property1.TradeID = data.TradeID; Property1.AreaID = data.AreaID; //分页参数 data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageSize = pageSize; data.Page.PageIndex = pageIndex; string start = Requests.GetQueryString("start"); string end = Requests.GetQueryString("end"); if (!string.IsNullOrEmpty(start)) { data.Page.StartDate = Convert.ToDateTime(start); txtStartDate.Text = Convert.ToDateTime(start).ToShortDateString(); } else { txtStartDate.Text = DateTime.Now.ToString("yyyy-MM-01"); data.Page.StartDate = Convert.ToDateTime(txtStartDate.Text); } if (!string.IsNullOrEmpty(end)) { data.Page.EndDate = Convert.ToDateTime(end); txtEndDate.Text = Convert.ToDateTime(end).ToShortDateString(); } else { txtEndDate.Text = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"); data.Page.EndDate = Convert.ToDateTime(txtEndDate.Text); } //绑定数据 rpList.DataSource = new T_ItemClientInfo().LeaderTradedList(data); rpList.DataBind(); //设置分页样式 pageList1.PageSize = pageSize; pageList1.CurrentPageIndex = pageIndex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; //----------------------------- }