private bool DoAdd(int user_id) { Model.buyersite_config model = new Model.buyersite_config(); BLL.buyersite_config bll = new BLL.buyersite_config(); model.user_id = user_id; model.site_type = 1; model.site_name = txtSiteName.Text.Trim(); model.site_domain = txtSiteDomain.Text.Trim(); model.site_config = txtSiteConfig.Text.Trim(); model.add_time = DateTime.Now; model.update_time = DateTime.Now; model.stat = cbIsLock.Checked == true ? 1 : 4; if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加站点:" + model.site_name); //记录日志 if (bid > 0) { new BLL.buyersite().AppliedCrement(bid, true); } return(true); } return(false); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.buyersite_config model) { string sql = "update [" + databaseprefix + @"buyersite_config] set [site_name] = @site_name, [site_domain] = @site_domain, [site_config] = @site_config, [update_time] = @update_time, [stat] = @stat WHERE [id] = @id "; List <SqlParameter> sp = new List <SqlParameter>(); sp.Add(new SqlParameter("@id", model.id)); sp.Add(new SqlParameter("@site_name", model.site_name)); sp.Add(new SqlParameter("@site_domain", model.site_domain)); sp.Add(new SqlParameter("@site_config", model.site_config)); sp.Add(new SqlParameter("@update_time", model.update_time)); sp.Add(new SqlParameter("@stat", model.stat)); return(DbHelperSQL.ExecuteSql(sql, sp.ToArray())); }
private bool DoEdit(int _id) { bool result = false; BLL.buyersite_config bll = new BLL.buyersite_config(); Model.buyersite_config model = new Model.buyersite_config() { id = _id, site_name = txtSiteName.Text.Trim(), site_domain = txtSiteDomain.Text.Trim(), site_config = txtSiteConfig.Text.Trim(), update_time = DateTime.Now, stat = cbIsLock.Checked == true ? 1 : 4 }; if (bll.Update(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改站点:" + model.site_name); //记录日志 result = true; } return(result); }
/// <summary> /// 增加,返回记录ID /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Model.buyersite_config model) { string sql = @"INSERT INTO [" + databaseprefix + @"buyersite_config] ( [user_id],[site_type],[site_name],[site_domain],[site_config],[add_time],[update_time],[stat] ) VALUES ( @user_id, @site_type, @site_name, @site_domain, @site_config, @add_time, @update_time, @stat ); SELECT SCOPE_IDENTITY();"; List <SqlParameter> sp = new List <SqlParameter>(); sp.Add(new SqlParameter("@user_id", model.user_id)); sp.Add(new SqlParameter("@site_type", model.site_type)); sp.Add(new SqlParameter("@site_name", model.site_name)); sp.Add(new SqlParameter("@site_domain", model.site_domain)); sp.Add(new SqlParameter("@site_config", model.site_config)); sp.Add(new SqlParameter("@add_time", model.add_time)); sp.Add(new SqlParameter("@update_time", model.update_time)); sp.Add(new SqlParameter("@stat", model.stat)); object obj = DbHelperSQL.GetSingle(sql, sp.ToArray()); return(obj == null ? 0 : Convert.ToInt32(obj)); }
/// <summary> /// 增加,返回记录ID /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Model.buyersite_config model) { return(dal.Add(model)); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Model.buyersite_config model) { return(dal.Update(model)); }