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