private bool DoAdd()
{
RTBcms.Web.Plugin.OnlineService.Model.online_service online_service = new RTBcms.Web.Plugin.OnlineService.Model.online_service();
RTBcms.Web.Plugin.OnlineService.BLL.online_service online_service2 = new RTBcms.Web.Plugin.OnlineService.BLL.online_service();
online_service.site_path = this.ddlSitePath.SelectedValue;
online_service.service_template = this.txtService_template.Text.Trim();
online_service.service_title = this.txtService_title.Text.Trim();
online_service.sort_id = Utils.StrToInt(this.txtSortId.Text.Trim(), 99);
if (this.cbIsLock.Checked)
{
online_service.is_lock = 1;
}
else
{
online_service.is_lock = 0;
}
bool result;
if (online_service2.Add(online_service) > 0)
{
CacheHelper.Remove("dt_cache_http_domain");
base.AddAdminLog(3.ToString(), "添加在线客服:" + online_service.service_template);
result = true;
}
else
{
result = false;
}
return(result);
}
private bool DoEdit(int _id)
{
bool result = false;
RTBcms.Web.Plugin.OnlineService.BLL.online_service online_service = new RTBcms.Web.Plugin.OnlineService.BLL.online_service();
RTBcms.Web.Plugin.OnlineService.Model.online_service model = online_service.GetModel(_id);
model.site_path = this.ddlSitePath.SelectedValue;
model.service_template = this.txtService_template.Text.Trim();
model.service_title = this.txtService_title.Text.Trim();
model.sort_id = Utils.StrToInt(this.txtSortId.Text.Trim(), 99);
if (this.cbIsLock.Checked)
{
model.is_lock = 1;
}
else
{
model.is_lock = 0;
}
if (online_service.Update(model))
{
CacheHelper.Remove("dt_cache_http_domain");
base.AddAdminLog(4.ToString(), "修改在线客服:" + model.service_template);
result = true;
}
return(result);
}
public RTBcms.Web.Plugin.OnlineService.Model.online_service GetModel(int id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id,service_template,service_title,sort_id,is_lock,add_time,site_path from " + this.databaseprefix + "online_service ");
stringBuilder.Append(" where id=@id");
OleDbParameter[] parameters =
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = id;
RTBcms.Web.Plugin.OnlineService.Model.online_service online_service = new RTBcms.Web.Plugin.OnlineService.Model.online_service();
DataSet dataSet = DbHelperOleDb.Query(stringBuilder.ToString(), parameters);
RTBcms.Web.Plugin.OnlineService.Model.online_service result;
if (dataSet.Tables[0].Rows.Count > 0)
{
if (dataSet.Tables[0].Rows[0]["id"] != null && dataSet.Tables[0].Rows[0]["id"].ToString() != "")
{
online_service.id = int.Parse(dataSet.Tables[0].Rows[0]["id"].ToString());
}
if (dataSet.Tables[0].Rows[0]["service_template"] != null && dataSet.Tables[0].Rows[0]["service_template"].ToString() != "")
{
online_service.service_template = dataSet.Tables[0].Rows[0]["service_template"].ToString();
}
if (dataSet.Tables[0].Rows[0]["service_title"] != null && dataSet.Tables[0].Rows[0]["service_title"].ToString() != "")
{
online_service.service_title = dataSet.Tables[0].Rows[0]["service_title"].ToString();
}
if (dataSet.Tables[0].Rows[0]["sort_id"] != null && dataSet.Tables[0].Rows[0]["sort_id"].ToString() != "")
{
online_service.sort_id = int.Parse(dataSet.Tables[0].Rows[0]["sort_id"].ToString());
}
if (dataSet.Tables[0].Rows[0]["is_lock"] != null && dataSet.Tables[0].Rows[0]["is_lock"].ToString() != "")
{
online_service.is_lock = int.Parse(dataSet.Tables[0].Rows[0]["is_lock"].ToString());
}
if (dataSet.Tables[0].Rows[0]["add_time"] != null && dataSet.Tables[0].Rows[0]["add_time"].ToString() != "")
{
online_service.add_time = DateTime.Parse(dataSet.Tables[0].Rows[0]["add_time"].ToString());
}
if (dataSet.Tables[0].Rows[0]["site_path"] != null && dataSet.Tables[0].Rows[0]["site_path"].ToString() != "")
{
online_service.site_path = dataSet.Tables[0].Rows[0]["site_path"].ToString();
}
result = online_service;
}
else
{
result = null;
}
return(result);
}
private void ShowInfo(int _id)
{
RTBcms.Web.Plugin.OnlineService.BLL.online_service online_service = new RTBcms.Web.Plugin.OnlineService.BLL.online_service();
RTBcms.Web.Plugin.OnlineService.Model.online_service model = online_service.GetModel(_id);
this.ddlSitePath.SelectedValue = model.site_path;
this.txtService_template.Text = model.service_template;
this.txtService_title.Text = model.service_title;
this.txtSortId.Text = model.sort_id.ToString();
if (model.is_lock == 1)
{
this.cbIsLock.Checked = true;
}
else
{
this.cbIsLock.Checked = false;
}
}
public int Add(RTBcms.Web.Plugin.OnlineService.Model.online_service model)
{
int newId;
using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString))
{
conn.Open();
using (OleDbTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into " + this.databaseprefix + "online_service(");
stringBuilder.Append("service_template,service_title,sort_id,is_lock,add_time,site_path)");
stringBuilder.Append(" values (");
stringBuilder.Append("@service_template,@service_title,@sort_id,@is_lock,@add_time,@site_path)");
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@service_template", OleDbType.VarChar, 100),
new OleDbParameter("@service_title", OleDbType.VarChar, 100),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_lock", OleDbType.Integer, 1),
new OleDbParameter("@add_time", OleDbType.Date),
new OleDbParameter("@site_path", OleDbType.VarChar, 200)
};
parameters[0].Value = model.service_template;
parameters[1].Value = model.service_title;
parameters[2].Value = model.sort_id;
parameters[3].Value = model.is_lock;
parameters[4].Value = model.add_time;
parameters[5].Value = model.site_path;
DbHelperOleDb.ExecuteSql(conn, trans, stringBuilder.ToString(), parameters);
//取得新插入的ID
newId = GetMaxId(conn, trans);
trans.Commit();
}
catch
{
trans.Rollback();
return(-1);
}
}
}
return(newId);
}
public bool Update(RTBcms.Web.Plugin.OnlineService.Model.online_service model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update " + this.databaseprefix + "online_service set ");
stringBuilder.Append("service_template=@service_template,");
stringBuilder.Append("service_title=@service_title,");
stringBuilder.Append("sort_id=@sort_id,");
stringBuilder.Append("is_lock=@is_lock,");
stringBuilder.Append("add_time=@add_time,");
stringBuilder.Append("site_path=@site_path");
stringBuilder.Append(" where id=@id");
OleDbParameter[] parameters = new OleDbParameter[]
{
new OleDbParameter("@service_template", OleDbType.VarChar, 100),
new OleDbParameter("@service_title", OleDbType.VarChar, 100),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@is_lock", OleDbType.Integer, 1),
new OleDbParameter("@add_time", SqlDbType.DateTime),
new OleDbParameter("@site_path", OleDbType.VarChar, 200),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
parameters[0].Value = model.service_template;
parameters[1].Value = model.service_title;
parameters[2].Value = model.sort_id;
parameters[3].Value = model.is_lock;
parameters[4].Value = model.add_time;
parameters[5].Value = model.site_path;
parameters[6].Value = model.id;
int rows = DbHelperOleDb.ExecuteSql(stringBuilder.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Update(RTBcms.Web.Plugin.OnlineService.Model.online_service model)
{
return(this.dal.Update(model));
}
public int Add(RTBcms.Web.Plugin.OnlineService.Model.online_service model)
{
return(this.dal.Add(model));
}
