/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SysRpt_ShopInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SysRpt_ShopInfo set ");
strSql.Append(" accountid = @accountid , ");
strSql.Append(" AgentId = @AgentId , ");
strSql.Append(" userNum = @userNum , ");
strSql.Append(" allUserNum = @allUserNum , ");
strSql.Append(" smsNum = @smsNum , ");
strSql.Append(" freeSmsNum = @freeSmsNum , ");
strSql.Append(" allSmsNum = @allSmsNum , ");
strSql.Append(" integral = @integral , ");
strSql.Append(" goodsNum = @goodsNum , ");
strSql.Append(" registration = @registration , ");
strSql.Append(" regIntegral = @regIntegral , ");
strSql.Append(" moodNum = @moodNum , ");
strSql.Append(" saleNum = @saleNum , ");
strSql.Append(" saleMoney = @saleMoney , ");
strSql.Append(" orderNum = @orderNum , ");
strSql.Append(" orderMoney = @orderMoney , ");
strSql.Append(" outlayNum = @outlayNum , ");
strSql.Append(" outlayMoney = @outlayMoney , ");
strSql.Append(" active = @active , ");
strSql.Append(" maxActive = @maxActive , ");
strSql.Append(" srsaId = @srsaId , ");
strSql.Append(" allLoginNum = @allLoginNum , ");
strSql.Append(" regTime = @regTime , ");
strSql.Append(" memSaleNum = @memSaleNum , ");
strSql.Append(" memSaleMoney = @memSaleMoney , ");
strSql.Append(" retailSaleNum = @retailSaleNum , ");
strSql.Append(" retailSaleMoney = @retailSaleMoney , ");
strSql.Append(" lastLoginTime = @lastLoginTime , ");
strSql.Append(" loginType = @loginType , ");
strSql.Append(" ContinuousDay = @ContinuousDay , ");
strSql.Append(" updateTime = @updateTime , ");
strSql.Append(" taskStat = @taskStat , ");
strSql.Append(" acc_Rep = @acc_Rep , ");
strSql.Append(" useVoucher = @useVoucher , ");
strSql.Append(" useIntegral = @useIntegral , ");
strSql.Append(" shopAssistant = @shopAssistant , ");
strSql.Append(" subbranch = @subbranch , ");
strSql.Append(" serviceNumber = @serviceNumber ");
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_ShopInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SysRpt_ShopInfo(");
strSql.Append("accountid,AgentId,userNum,allUserNum,smsNum,freeSmsNum,allSmsNum,integral,goodsNum,registration,regIntegral,moodNum,saleNum,saleMoney,orderNum,orderMoney,outlayNum,outlayMoney,active,maxActive,srsaId,allLoginNum,regTime,memSaleNum,memSaleMoney,retailSaleNum,retailSaleMoney,lastLoginTime,loginType,ContinuousDay,updateTime,taskStat,acc_Rep,useVoucher,useIntegral,shopAssistant,subbranch,serviceNumber");
strSql.Append(") values (");
strSql.Append("@accountid,@AgentId,@userNum,@allUserNum,@smsNum,@freeSmsNum,@allSmsNum,@integral,@goodsNum,@registration,@regIntegral,@moodNum,@saleNum,@saleMoney,@orderNum,@orderMoney,@outlayNum,@outlayMoney,@active,@maxActive,@srsaId,@allLoginNum,@regTime,@memSaleNum,@memSaleMoney,@retailSaleNum,@retailSaleMoney,@lastLoginTime,@loginType,@ContinuousDay,@updateTime,@taskStat,@acc_Rep,@useVoucher,@useIntegral,@shopAssistant,@subbranch,@serviceNumber");
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_ShopInfo model)
{
SysRpt_ShopInfoBaseDAL dal = new SysRpt_ShopInfoBaseDAL();
return(dal.Update(model));
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(SysRpt_ShopInfo model)
{
SysRpt_ShopInfoBaseDAL dal = new SysRpt_ShopInfoBaseDAL();
return(dal.Add(model));
}
