/// <summary>
/// 提交QQ号码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Value == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('客服名称不能为空!');", true);
return;
}
if (txtQQnumber.Value == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('客服号码不能为空!');", true);
return;
}
lgk.Model.tb_serviceQQ model = new lgk.Model.tb_serviceQQ();
model.ServiceName = txtName.Value.Trim();
model.QQnum = txtQQnumber.Value.Trim();
//if (chkGroup.Checked == true)
//{
// model.QQType = 1;
//}
//else
{
model.QQType = 0;
}
if (qqBLL.Add(model) > 0)
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('添加成功!');window.location.href='QQSet.aspx';", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('添加失败!');", true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
spd.jumpAdminUrl1(this.Page, 1);//跳转三级密码
if (txtName.Value == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('客服名称不能为空!');", true);
return;
}
if (txtQQNumber.Value == "")
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('客服号码不能为空!');", true);
return;
}
lgk.Model.tb_serviceQQ model = qqBLL.GetModel(getIntRequest("id"));
model.ServiceName = txtName.Value.Trim();
model.QQnum = txtQQNumber.Value.Trim();
//if (chkGroup.Checked == true)
//{
// model.QQType = 1;
//}
//else
{
model.QQType = 0;
}
if (qqBLL.Update(model))
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('设置成功!');window.location.href='QQSet.aspx';", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "info", "alert('设置失败!');", true);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_serviceQQ GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,ServiceName,QQnum,QQ001,QQ002,QQ003,QQType from tb_serviceQQ ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt)
};
parameters[0].Value = ID;
lgk.Model.tb_serviceQQ model = new lgk.Model.tb_serviceQQ();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["ServiceName"] != null && ds.Tables[0].Rows[0]["ServiceName"].ToString() != "")
{
model.ServiceName = ds.Tables[0].Rows[0]["ServiceName"].ToString();
}
if (ds.Tables[0].Rows[0]["QQnum"] != null && ds.Tables[0].Rows[0]["QQnum"].ToString() != "")
{
model.QQnum = ds.Tables[0].Rows[0]["QQnum"].ToString();
}
if (ds.Tables[0].Rows[0]["QQ001"] != null && ds.Tables[0].Rows[0]["QQ001"].ToString() != "")
{
model.QQ001 = ds.Tables[0].Rows[0]["QQ001"].ToString();
}
if (ds.Tables[0].Rows[0]["QQ002"] != null && ds.Tables[0].Rows[0]["QQ002"].ToString() != "")
{
model.QQ002 = ds.Tables[0].Rows[0]["QQ002"].ToString();
}
if (ds.Tables[0].Rows[0]["QQ003"] != null && ds.Tables[0].Rows[0]["QQ003"].ToString() != "")
{
model.QQ003 = ds.Tables[0].Rows[0]["QQ003"].ToString();
}
if (ds.Tables[0].Rows[0]["QQType"] != null && ds.Tables[0].Rows[0]["QQType"].ToString() != "")
{
model.QQType = int.Parse(ds.Tables[0].Rows[0]["QQType"].ToString());
}
return(model);
}
else
{
return(null);
}
}
private void BindData(int p)
{
lgk.Model.tb_serviceQQ model = qqBLL.GetModel(p);
txtName.Value = model.ServiceName;
this.txtQQNumber.Value = model.QQnum;
//if (model.QQType == 0)
//{
// this.chkGroup.Checked = false;
//}
//else
//{
// this.chkGroup.Checked = true;
//}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_serviceQQ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_serviceQQ set ");
strSql.Append("ServiceName=@ServiceName,");
strSql.Append("QQnum=@QQnum,");
strSql.Append("QQ001=@QQ001,");
strSql.Append("QQ002=@QQ002,");
strSql.Append("QQ003=@QQ003,");
strSql.Append("QQType=@QQType");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ServiceName", SqlDbType.VarChar, 50),
new SqlParameter("@QQnum", SqlDbType.VarChar, 50),
new SqlParameter("@QQ001", SqlDbType.VarChar, 100),
new SqlParameter("@QQ002", SqlDbType.VarChar, 50),
new SqlParameter("@QQ003", SqlDbType.VarChar, 50),
new SqlParameter("@QQType", SqlDbType.VarChar, 50),
new SqlParameter("@ID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.ServiceName;
parameters[1].Value = model.QQnum;
parameters[2].Value = model.QQ001;
parameters[3].Value = model.QQ002;
parameters[4].Value = model.QQ003;
parameters[5].Value = model.QQType;
parameters[6].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_serviceQQ model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_serviceQQ(");
strSql.Append("ServiceName,QQnum,QQ001,QQ002,QQ003,QQType)");
strSql.Append(" values (");
strSql.Append("@ServiceName,@QQnum,@QQ001,@QQ002,@QQ003,@QQType)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ServiceName", SqlDbType.VarChar, 50),
new SqlParameter("@QQnum", SqlDbType.VarChar, 50),
new SqlParameter("@QQ001", SqlDbType.VarChar, 100),
new SqlParameter("@QQ002", SqlDbType.VarChar, 50),
new SqlParameter("@QQ003", SqlDbType.VarChar, 50),
new SqlParameter("@QQType", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.ServiceName;
parameters[1].Value = model.QQnum;
parameters[2].Value = model.QQ001;
parameters[3].Value = model.QQ002;
parameters[4].Value = model.QQ003;
parameters[5].Value = model.QQType;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
