/// <summary> /// 点击确定按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { //获取界面数据并验证 string subject = txtTalkSubject.Text; string detail = txtTalkDetail.Content; if (subject == "") { MLMGC.COMP.Jscript.ShowMsg("请输入标题", this); return; } else if (detail == "") { MLMGC.COMP.Jscript.ShowMsg("请输入内容", this); return; } E_Talk data = new E_Talk(); data.EnterpriseID = EnterpriceID; data.TalkSubject = txtTalkSubject.Text; data.Detail = txtTalkDetail.Content; data.Sort = Convert.ToInt32(txtSort.Text); if (type == "add") { bool flag = new T_Talk().Add(data); new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "添加话术", IP = MLMGC.COMP.Requests.GetRealIP() }); if (flag) { MLMGC.COMP.Jscript.AlertAndRedirect(this, "添加成功", "TalkList.aspx"); } else { MLMGC.COMP.Jscript.ShowMsg("添加失败", this); } } else { //data.TalkID = Convert.ToInt32(Request.QueryString["TalkID"]); data.TalkID = MLMGC.COMP.Requests.GetQueryInt("talkid", 0); bool flag = new T_Talk().Update(data); new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "修改话术", IP = MLMGC.COMP.Requests.GetRealIP() }); if (flag) { MLMGC.COMP.Jscript.AlertAndRedirect(this, "修改成功", "TalkList.aspx"); } else { MLMGC.COMP.Jscript.ShowMsg("修改失败", this); } } }
/// <summary> /// 获取话术列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-19</remarks> public DataTable GetList(E_Talk data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@PersonalID", SqlDbType.Int, 4) }; parms[0].Value = data.PersonalID; DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_Talk_ListSelect", parms); return(dt); }
/// <summary> /// 绑定数据 /// </summary> /// <param name="talkID"></param> protected void databind(int talkID) { E_Talk data = new E_Talk(); data.TalkID = talkID; data.PersonalID = PersonalID; data = new T_Talk().GetModel(data); txtTalkSubject.Text = data.TalkSubject; txtTalkDetail.Content = data.Detail; txtSort.Text = data.Sort.ToString(); }
/// <summary> /// 绑定数据 /// </summary> protected void databind() { E_Talk data = new E_Talk(); data.EnterpriseID = EnterpriceID; DataTable dt = new T_Talk().GetList(data); object o = dt.Compute("Max(Sort)", "true"); max = Convert.ToInt32(o == DBNull.Value?"0":o); rpList.DataSource = dt; rpList.DataBind(); }
/// <summary> /// 绑定数据 /// </summary> protected void databind() { E_Talk data = new E_Talk(); data.PersonalID = PersonalID; DataTable dt = new T_Talk().GetList(data); if (dt == null || dt.Rows.Count == 0) { flag = true; } rpList.DataSource = dt; rpList.DataBind(); }
/// <summary> /// 点击确定按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { //获取界面数据并验证 string subject = txtTalkSubject.Text; string detail = txtTalkDetail.Content; if (subject == "") { MLMGC.COMP.Jscript.ShowMsg("请输入标题", this); return; } else if (detail == "") { MLMGC.COMP.Jscript.ShowMsg("请输入内容", this); return; } E_Talk data = new E_Talk(); data.PersonalID = PersonalID; data.TalkSubject = txtTalkSubject.Text; data.Detail = txtTalkDetail.Content; data.Sort = Convert.ToInt32(txtSort.Text); //如果是添加新话术 if (type == "add") { bool flag = new T_Talk().Add(data); if (flag) { MLMGC.COMP.Jscript.AlertAndRedirect(this, "添加成功", "TalkList.aspx"); } else { MLMGC.COMP.Jscript.ShowMsg("添加失败", this); } } else { data.TalkID = MLMGC.COMP.Requests.GetQueryInt("talkid", 0); bool flag = new T_Talk().Update(data); if (flag) { MLMGC.COMP.Jscript.AlertAndRedirect(this, "修改成功", "TalkList.aspx"); } else { MLMGC.COMP.Jscript.ShowMsg("修改失败", this); } } }
/// <summary> /// 删除个人话术 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-19</remarks> public bool Delete(E_Talk data) { int rowsAffected = 0; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TalkID", SqlDbType.Int, 4), new SqlParameter("@PersonalID", SqlDbType.Int, 4) }; parms[0].Value = data.TalkID; parms[1].Value = data.PersonalID; DbHelperSQL.ExecProcedure("ProcPI_B_Talk_Delete", parms, out rowsAffected); return(rowsAffected > 0); }
/// <summary> /// 删除话术 /// </summary> /// <param name="talkID"></param> public void Delete(int talkID) { E_Talk data = new E_Talk(); data.TalkID = talkID; data.PersonalID = PersonalID; bool flag = new T_Talk().Delete(data); if (flag) { MLMGC.COMP.Jscript.ShowMsg("删除成功", this); } else { MLMGC.COMP.Jscript.ShowMsg("删除失败", this); } }
/// <summary> /// 获取一个话术对象 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-19</remarks> public E_Talk GetModel(E_Talk data) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TalkID", SqlDbType.Int, 4), new SqlParameter("@PersonalID", SqlDbType.Int, 4) }; parms[0].Value = data.TalkID; parms[1].Value = data.PersonalID; DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_Talk_Select", parms); if (dt != null && dt.Rows.Count == 1) { data.TalkSubject = dt.Rows[0]["TalkSubject"].ToString(); data.Detail = dt.Rows[0]["Detail"].ToString(); data.Sort = Convert.ToInt32(dt.Rows[0]["Sort"]); return(data); } return(null); }
/// <summary> /// 更新个人话术 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-19</remarks> public bool Update(E_Talk data) { int rowsAffected = 0; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TalkID", SqlDbType.Int, 4), new SqlParameter("@PersonalID", SqlDbType.Int, 4), new SqlParameter("@TalkSubject", SqlDbType.VarChar, 128), new SqlParameter("@Detail", SqlDbType.VarChar), new SqlParameter("@Sort", SqlDbType.Int) }; parms[0].Value = data.TalkID; parms[1].Value = data.PersonalID; parms[2].Value = data.TalkSubject; parms[3].Value = data.Detail; parms[4].Value = data.Sort; DbHelperSQL.ExecProcedure("ProcPI_B_Talk_Update", parms, out rowsAffected); return(rowsAffected > 0); }
/// <summary> /// 删除话术 /// </summary> /// <param name="talkID"></param> public void Delete(int talkID) { E_Talk data = new E_Talk(); data.TalkID = talkID; data.EnterpriseID = EnterpriceID; bool flag = new T_Talk().Delete(data); new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "删除话术", IP = MLMGC.COMP.Requests.GetRealIP() }); if (flag) { MLMGC.COMP.Jscript.ShowMsg("删除成功", this); } else { MLMGC.COMP.Jscript.ShowMsg("删除失败", this); } }
/// <summary> /// 新增个人话术 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2011-10-19</remarks> public bool Add(E_Talk data) { int rowsAffected = 0; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TalkID", SqlDbType.Int, 4), new SqlParameter("@PersonalID", SqlDbType.Int, 4), new SqlParameter("@TalkSubject", SqlDbType.VarChar, 128), new SqlParameter("@Detail", SqlDbType.VarChar), new SqlParameter("@Sort", SqlDbType.Int) }; parms[0].Direction = ParameterDirection.Output; parms[1].Value = data.PersonalID; parms[2].Value = data.TalkSubject; parms[3].Value = data.Detail; parms[4].Value = data.Sort; DbHelperSQL.ExecProcedure("ProcPI_B_Talk_Insert", parms, out rowsAffected); data.TalkID = parms[0].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[0].Value); return(rowsAffected > 0); }
/// <summary> /// 增加一条话术 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool Add(E_Talk data) { return(dal.Add(data)); }
/// <summary> /// 得到话术列表 /// </summary> /// <param name="data"></param> /// <returns></returns> public DataTable GetList(E_Talk data) { return(dal.GetList(data)); }
/// <summary> /// 得到一个话术 /// </summary> /// <param name="data"></param> /// <returns></returns> public E_Talk GetModel(E_Talk data) { return(dal.GetModel(data)); }
/// <summary> /// 删除一条话术 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool Delete(E_Talk data) { return(dal.Delete(data)); }
/// <summary> /// 更新一条话术 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool Update(E_Talk data) { return(dal.Update(data)); }