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