/// <summary>
/// 增加一条数据
/// </summary>
public new int Add(Sys_TagNexus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("if(exists(select * from Sys_TagNexus where acc_id=@acc_id and tag_id=@tag_id))");
strSql.Append(" begin ");
strSql.Append(" select -1; ");
strSql.Append(" end ");
strSql.Append(" else ");
strSql.Append(" begin ");
strSql.Append("insert into Sys_TagNexus(");
strSql.Append("tag_id,acc_id,insertName,insertTime");
strSql.Append(") values (");
strSql.Append("@tag_id,@acc_id,@insertName,@insertTime");
strSql.Append("); ");
strSql.Append("select @@IDENTITY;");
strSql.Append(" end ");
object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Sys_TagNexus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_TagNexus(");
strSql.Append("tag_id,acc_id,insertName,insertTime");
strSql.Append(") values (");
strSql.Append("@tag_id,@acc_id,@insertName,@insertTime");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model);
if (obj != null)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 一个店铺增加标签
/// </summary>
/// <param name="accid"></param>
/// <param name="tagid"></param>
/// <param name="inserName"></param>
/// <returns></returns>
public static int AddAccountTag(int accid, int tagid, string inserName)
{
Sys_TagNexus model = new Sys_TagNexus();
model.tag_id = tagid;
model.acc_id = accid;
model.insertName = inserName;
model.insertTime = DateTime.Now;
model.id = Sys_TagNexusBLL.Add(model);
if (model.id > 0)
{
return(model.id);
}
else if (model.id == -1)
{
return(-1);
}
else
{
return(-2);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys_TagNexus model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_TagNexus set ");
strSql.Append(" tag_id = @tag_id , ");
strSql.Append(" acc_id = @acc_id , ");
strSql.Append(" insertName = @insertName , ");
strSql.Append(" insertTime = @insertTime ");
strSql.Append(" where id=@id ");
int row = DapperHelper.Execute(strSql.ToString(), model);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Sys_TagNexus model)
{
Sys_TagNexusBaseDAL dal = new Sys_TagNexusBaseDAL();
return(dal.Update(model));
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(Sys_TagNexus model)
{
Sys_TagNexusBaseDAL dal = new Sys_TagNexusBaseDAL();
return(dal.Add(model));
}
