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