/// <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;
}
}
