/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SysRpt_WebDayInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysRpt_WebDayInfo set ");
strSql.Append(" saleMoney = @saleMoney , ");
strSql.Append(" memSaleNum = @memSaleNum , ");
strSql.Append(" memSaleMoney = @memSaleMoney , ");
strSql.Append(" retailSaleNum = @retailSaleNum , ");
strSql.Append(" retailSaleMoney = @retailSaleMoney , ");
strSql.Append(" orderNum = @orderNum , ");
strSql.Append(" orderMoney = @orderMoney , ");
strSql.Append(" orderAccount = @orderAccount , ");
strSql.Append(" loginNum = @loginNum , ");
strSql.Append(" loginPaidNum = @loginPaidNum , ");
strSql.Append(" S_Date = @S_Date , ");
strSql.Append(" reg_Attention = @reg_Attention , ");
strSql.Append(" registration = @registration , ");
strSql.Append(" moodNum = @moodNum , ");
strSql.Append(" unknownNum = @unknownNum , ");
strSql.Append(" activeNum = @activeNum , ");
strSql.Append(" faithfulNum = @faithfulNum , ");
strSql.Append(" dormancyNum = @dormancyNum , ");
strSql.Append(" outflowNum = @outflowNum , ");
strSql.Append(" outlayNum = @outlayNum , ");
strSql.Append(" outlayMoney = @outlayMoney , ");
strSql.Append(" accountNum = @accountNum , ");
strSql.Append(" addGoodsNum = @addGoodsNum , ");
strSql.Append(" saleGoodsNum = @saleGoodsNum , ");
strSql.Append(" feedBackCnt = @feedBackCnt , ");
strSql.Append(" addTime = @addTime , ");
strSql.Append(" clientLogNum = @clientLogNum , ");
strSql.Append(" acc_Rep = @acc_Rep , ");
strSql.Append(" acc_RepCount = @acc_RepCount , ");
strSql.Append(" Attention = @Attention , ");
strSql.Append(" NewAccNum = @NewAccNum , ");
strSql.Append(" userNum = @userNum , ");
strSql.Append(" smsNum = @smsNum , ");
strSql.Append(" freeSmsNum = @freeSmsNum , ");
strSql.Append(" sysSmsNum = @sysSmsNum , ");
strSql.Append(" saleNum = @saleNum ");
strSql.Append(" where id=@id ");
int row = DapperHelper.Execute(strSql.ToString(), model);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(SysRpt_WebDayInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SysRpt_WebDayInfo(");
strSql.Append("saleMoney,memSaleNum,memSaleMoney,retailSaleNum,retailSaleMoney,orderNum,orderMoney,orderAccount,loginNum,loginPaidNum,S_Date,reg_Attention,registration,moodNum,unknownNum,activeNum,faithfulNum,dormancyNum,outflowNum,outlayNum,outlayMoney,accountNum,addGoodsNum,saleGoodsNum,feedBackCnt,addTime,clientLogNum,acc_Rep,acc_RepCount,Attention,NewAccNum,userNum,smsNum,freeSmsNum,sysSmsNum,saleNum");
strSql.Append(") values (");
strSql.Append("@saleMoney,@memSaleNum,@memSaleMoney,@retailSaleNum,@retailSaleMoney,@orderNum,@orderMoney,@orderAccount,@loginNum,@loginPaidNum,@S_Date,@reg_Attention,@registration,@moodNum,@unknownNum,@activeNum,@faithfulNum,@dormancyNum,@outflowNum,@outlayNum,@outlayMoney,@accountNum,@addGoodsNum,@saleGoodsNum,@feedBackCnt,@addTime,@clientLogNum,@acc_Rep,@acc_RepCount,@Attention,@NewAccNum,@userNum,@smsNum,@freeSmsNum,@sysSmsNum,@saleNum");
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>
public static bool Update(SysRpt_WebDayInfo model)
{
SysRpt_WebDayInfoBaseDAL dal = new SysRpt_WebDayInfoBaseDAL();
return(dal.Update(model));
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(SysRpt_WebDayInfo model)
{
SysRpt_WebDayInfoBaseDAL dal = new SysRpt_WebDayInfoBaseDAL();
return(dal.Add(model));
}