/// <summary> /// 获取企业团队模型配置 /// </summary> /// <param name="data"></param> /// <returns></returns> public E_TeamModel GetTeamScale(E_TeamModel data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; DataSet ds = DbHelperSQL.RunProcedureDataSet("ProcEP_B_TeamScale_Select", parms); if (Data.DataSetIsNotNull(ds)) { data.TeamModelID = Convert.ToInt32(ds.Tables[0].Rows[0]["TeamModelID"]); data.TeamScaleXml = ds.Tables[0].Rows[0]["TeamScaleXml"].ToString(); data.LatenDay = Convert.ToInt32(ds.Tables[0].Rows[0]["LatenDay"]); data.LRemindDay = Convert.ToInt32(ds.Tables[0].Rows[0]["LRemindDay"]); data.WishDay = Convert.ToInt32(ds.Tables[0].Rows[0]["WishDay"]); data.WRemindDay = Convert.ToInt32(ds.Tables[0].Rows[0]["WRemindDay"]); data.NotTradedID = Convert.ToInt32(ds.Tables[0].Rows[0]["NotTradedID"]); } else { data = null;//尚未设置团队规模 } return(data); }
protected void databind() { T_TeamModel blltm = new T_TeamModel(); //获取企业购买用户数量 int userAmount = (int)new MLMGC.BLL.Enterprise.T_Enterprise().Get(new MLMGC.DataEntity.Enterprise.E_Enterprise() { EnterpriseID = base.EnterpriceID }).UserAmount; ltUserAmount.Text = userAmount.ToString(); //获取团队模型数据 DataSet ds = blltm.GetList(); if (ds != null) { int LeastUserAmount = 0; foreach (DataRow dr in ds.Tables[0].Rows) { RadioButton rb = (RadioButton)Page.FindControl("rbModel" + dr["TeamModelID"].ToString()); if (rb == null) { continue; } rb.Text = dr["TeamModelName"].ToString(); //li.Value = dr["TeamModelID"].ToString(); LeastUserAmount = int.Parse(dr["LeastUserAmount"].ToString()); rb.Enabled = userAmount > LeastUserAmount; } } //绑定用户设置信息 E_TeamModel data = blltm.GetTeamScale(new E_TeamModel() { EnterpriseID = base.EnterpriceID }); if (data != null) { teammodeid = data.TeamModelID; switch (data.TeamModelID) { case 2: rbModel2.Checked = true; LtSelectModel.Text = "已经选择模型:<b style=\" color:Red;\">" + rbModel2.Text + "</b>"; break; case 3: rbModel3.Checked = true; LtSelectModel.Text = "已经选择模型:<b style=\" color:Red;\">" + rbModel3.Text + "</b>"; break; case 4: rbModel4.Checked = true; LtSelectModel.Text = "已经选择模型:<b style=\" color:Red;\">" + rbModel4.Text + "</b>"; break; default: break; } } }
/// <summary> /// 获取企业团队模型下的角色列表 /// </summary> /// <param name="data"></param> /// <returns></returns> public DataSet GetEnterpriseRole(E_TeamModel data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; return(DbHelperSQL.RunProcedureDataSet("ProcEP_R_TeamModelRoleS_Select", parms)); }
/// <summary> /// 获取团队模型结构 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-12-12</remarks> public DataTable GetTeamModel(E_TeamModel data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; return(DbHelperSQL.RunProcedureTable("ProcEP_B_TeamScaleS_Select", parms)); }
/// <summary> /// 获取企业图 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>qipengfei 2011-11-28</remarks> public DataSet GetEnterpriseMap(E_TeamModel data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; return(DbHelperSQL.RunProcedureDataSet("ProcR_TeamMember_Map", parms)); }
protected void databind() { //获取企业购买用户数量 int userAmount = (int)new MLMGC.BLL.Enterprise.T_Enterprise().Get(new MLMGC.DataEntity.Enterprise.E_Enterprise() { EnterpriseID = base.EnterpriceID }).UserAmount; ltUserAmount.Text = userAmount.ToString(); T_TeamModel blltm = new T_TeamModel(); E_TeamModel data = blltm.GetTeamScale(new E_TeamModel() { EnterpriseID = base.EnterpriceID }); if (data == null) { Jscript.AlertAndRedirect(this, "请先设置团队模型", "TeamModelSetUp.aspx"); return; } XmlDocument doc = new XmlDocument(); doc.LoadXml(data.TeamScaleXml); XmlNodeList root = doc.SelectNodes("root/item"); StringBuilder sb = new StringBuilder(); sb.Append("<table>"); foreach (XmlNode n in root) //遍历所有property节点 { if (n.Attributes["roleID"].Value.Equals("6")) //录入人员 { continue; } //dt.Columns.Add(n.Attributes["key"].Value); sb.Append(string.Format("<tr><td class='name'>{0}:</td>", n.ChildNodes[0].InnerText)); //增加名称 if (n.Attributes["readonly"].Value == "true") //显示数量不修改 { sb.Append("<td>" + n.ChildNodes[1].InnerText + "个</td>"); } else//否则为输入框供管理员修改部门数量 { sb.Append(string.Format("<td><input type='text' name='txtAmount{1}' class='inputAmount txt1 w50' value='{0}'/>个</td>", n.ChildNodes[1].InnerText, n.Attributes["roleID"].Value)); } sb.Append("</tr>"); } sb.Append("</table>"); LtSetting.Text = sb.ToString(); btnSubmit.Visible = root.Count > 2; }
/// <summary> /// 设置企业团队模型 /// </summary> /// <param name="data"></param> /// <returns></returns> public int SetTeamModel(E_TeamModel data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@TeamModelID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.TeamModelID; int ReturnValue = 0; DbHelperSQL.RunProcedures("ProcEP_B_TeamScale_Update", parms, out ReturnValue); return(ReturnValue); }
/// <summary> /// 点击确定按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { int lday, lrday, wday, wrday; if (!int.TryParse(txtLatenDay.Text, out lday) || !int.TryParse(txtLRemindDay.Text, out lrday) || !int.TryParse(txtWishDay.Text, out wday) || !int.TryParse(txtWRemindDay.Text, out wrday)) { Jscript.ShowMsg("请输入正确的数字", this); return; } if (lday > 999 || wday > 999) { Jscript.ShowMsg("设置天数最大为999,请重新设置", this); return; } //数据合法性 if (lrday > 99 || wrday > 99) { Jscript.ShowMsg("提醒天数最大为99,请重新设置", this); return; } if ((lrday > 0 && lday > 0 && lrday >= lday) || (wrday >= wday && wrday > 0 && wday > 0)) { Jscript.ShowMsg("提醒天数不能大于等于设置天数,请重新设置", this); return; } if (lrday < 0 || lday < 0 || wrday < 0 || wday < 0) { Jscript.ShowMsg("设置值不能为负数,请重新设置", this); return; } E_TeamModel data = new E_TeamModel(); data.EnterpriseID = EnterpriceID; data.LatenDay = lday; data.LRemindDay = lrday; data.WishDay = wday; data.WRemindDay = wrday; data.NotTradedID = Convert.ToInt32(ddlNotTraded.SelectedValue); bool flag = new T_TeamModel().UpdateDeadLine(data); new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "共享设置", IP = MLMGC.COMP.Requests.GetRealIP() }); Jscript.ShowMsg(flag ? "修改成功" : "修改失败", this); }
/// <summary> /// 更新企业团队模型配置 各团队数量 /// </summary> /// <param name="data"></param> /// <returns></returns> public int UpdateTeamScale(E_TeamModel data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@TeamScaleXml", SqlDbType.Xml), new SqlParameter("@Child_RoleID", SqlDbType.NVarChar), new SqlParameter("@Child_RoleAmount", SqlDbType.NVarChar) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.TeamScaleXml; parms[2].Value = data.Child_RoleID; parms[3].Value = data.Child_RoleAmount; int ReturnValue = 0; DbHelperSQL.RunProcedures("ProcEP_B_TeamScaleS_UpdateTeamScale", parms, out ReturnValue); return(ReturnValue); }
/// <summary> /// 修改期限 共享 潜在客户、意向客户 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-12-31</remarks> public bool UpdateDeadLine(E_TeamModel data) { SqlParameter[] parms = { new SqlParameter("@EnterpriseID", SqlDbType.Int), new SqlParameter("@LatenDay", SqlDbType.SmallInt), new SqlParameter("@WishDay", SqlDbType.SmallInt), new SqlParameter("@LRemindDay", SqlDbType.TinyInt), new SqlParameter("@WRemindDay", SqlDbType.TinyInt), new SqlParameter("@NotTradedID", SqlDbType.Int) }; parms[0].Value = data.EnterpriseID; parms[1].Value = data.LatenDay; parms[2].Value = data.WishDay; parms[3].Value = data.LRemindDay; parms[4].Value = data.WRemindDay; parms[5].Value = data.NotTradedID; int ReturnValue; DbHelperSQL.RunProcedures("ProcEP_B_TeamScale_UpdateDeadLine", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 数据绑定 /// </summary> protected void databind() { //------绑定失败理由------ ddlNotTraded.DataSource = new T_NotTraded().GetList(new E_NotTraded() { EnterpriseID = EnterpriceID }); ddlNotTraded.DataTextField = "NotTradedName"; ddlNotTraded.DataValueField = "NotTradedID"; ddlNotTraded.DataBind(); //读取期限数据 E_TeamModel data = new E_TeamModel(); data.EnterpriseID = EnterpriceID; data = new T_TeamModel().GetTeamScale(data); if (data != null) { txtLatenDay.Text = data.LatenDay.ToString(); txtLRemindDay.Text = data.LRemindDay.ToString(); txtWishDay.Text = data.WishDay.ToString(); txtWRemindDay.Text = data.WRemindDay.ToString(); ddlNotTraded.SelectedValue = data.NotTradedID.ToString(); } }
/// <summary> /// 修改期限 共享 潜在客户、意向客户 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-12-31</remarks> public bool UpdateDeadLine(E_TeamModel data) { return(dal.UpdateDeadLine(data)); }
/// <summary> /// 获取企业图 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>qipengfei 2011-11-28</remarks> public DataSet GetEnterpriseMap(E_TeamModel data) { return(dal.GetEnterpriseMap(data)); }
/// <summary> /// 更新企业团队模型配置 各团队数量 /// </summary> /// <param name="data"></param> /// <returns></returns> public int UpdateTeamScale(E_TeamModel data) { return(dal.UpdateTeamScale(data)); }
/// <summary> /// 获取企业团队模型配置 /// </summary> /// <param name="data"></param> /// <returns></returns> public E_TeamModel GetTeamScale(E_TeamModel data) { return(dal.GetTeamScale(data)); }
/// <summary> /// 设置企业团队模型 /// </summary> /// <param name="data"></param> /// <returns></returns> public int SetTeamModel(E_TeamModel data) { return(dal.SetTeamModel(data)); }
/// <summary> /// 获取团队模型结构 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-12-12</remarks> //TODO:该方法未使用 public DataTable GetTeamModel(E_TeamModel data) { return(dal.GetTeamModel(data)); }
protected void btnSubmit_Click(object sender, EventArgs e) { T_TeamModel blltm = new T_TeamModel(); E_TeamModel data = blltm.GetTeamScale(new E_TeamModel() { EnterpriseID = base.EnterpriceID }); if (data == null) { Jscript.AlertAndRedirect(this, "请先设置团队模型", "TeamModelSetUp.aspx"); return; } int teammodeid = data.TeamModelID; List <string> aryRole = new List <string>(); List <string> aryAmount = new List <string>(); XmlDocument doc = new XmlDocument(); doc.LoadXml(data.TeamScaleXml); XmlNodeList root = doc.SelectNodes("root/item[@readonly='false']"); bool bCheck = true; int num = 0; foreach (XmlNode n in root)//遍历所有property节点 { aryRole.Add(n.Attributes["roleID"].Value); aryAmount.Add(Request.Form["txtAmount" + n.Attributes["roleID"].Value].ToString()); if (int.TryParse(Request.Form["txtAmount" + n.Attributes["roleID"].Value].ToString(), out num) && num > 0) { n.ChildNodes[1].InnerText = num.ToString(); } else { bCheck = false; } } if (!bCheck) { Jscript.ShowMsg("请输入正确的数据", this); return; } //重新赋值 data.EnterpriseID = EnterpriceID; data.TeamScaleXml = doc.InnerXml; data.Child_RoleID = string.Join(",", aryRole.ToArray()); data.Child_RoleAmount = string.Join(",", aryAmount.ToArray()); int i = blltm.UpdateTeamScale(data); //添加操作日志 new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "设置团队规模", IP = MLMGC.COMP.Requests.GetRealIP() }); switch (i) { case 1: Response.Redirect("TeamSetUp2.aspx"); break; case -1: Jscript.ShowMsg("请先清空需要删除的团队中的数据。", this); break; default: Jscript.ShowMsg("修改失败", this); break; } }