//
// GET: /Awards/
public ActionResult Index(AwardsListEntity objEntity)
{
ViewBag.userInfoPar = objEntity;
var page = _awardsListLogic.GetAwardsListpageList(objEntity);
var pv = new PageResult <AwardsListEntity>();
pv.PageIndex = objEntity.PageIndex;
pv.PageSize = objEntity.PageSize;
pv.DataList = page ?? new List <AwardsListEntity>();
pv.Total = page != null && page.Count >= 0 ? Convert.ToInt32(page[0].Total) : 0;
pv.RequestUrl = objEntity.RequetUrl;
return(View(pv));
}
/// <summary>
/// 获取奖品设置等级分页列表
/// </summary>
/// <param name="objEntity"></param>
/// <returns></returns>
public List <AwardsListEntity> GetAwardsListpageList(AwardsListEntity objEntity)
{
var wheresql = " where 1=1";
if (!string.IsNullOrEmpty(objEntity.Awards))
{
wheresql += @" And Awards=@Awards";
}
if (!string.IsNullOrEmpty(objEntity.AwardsGoods))
{
wheresql += @" And AwardsGoods=@AwardsGoods";
}
var paras = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@Awards", DbType = DbType.String, Value = objEntity.Awards
},
new SQLiteParameter()
{
ParameterName = "@AwardsGoods", DbType = DbType.String, Value = objEntity.AwardsGoods
},
};
var strsql = @"select* from (select(select count(1) from AwardsList a";
strsql += wheresql;
strsql += @") As Total,a.* from AwardsList a";
strsql += wheresql;
strsql += @") as A order by ID desc";
strsql = string.Format(strsql + " limit {0} offset {0}*{1}", objEntity.PageSize, objEntity.PageIndex - 1);
using (IDataReader dReader = SQLiteHelper.ExecuteReader(strsql, paras))
{
List <AwardsListEntity> userlist = GlobalFunction.GetEntityList <AwardsListEntity>(dReader);
return(userlist);
}
}
public int InsertAwards(AwardsListEntity objEntity)
{
var sql =
@"insert into AwardsList(Awards,AwardsNum,UsedNum,AwardsGoods,CreateTime) values(@Awards,@AwardsNum,@UsedNum,@AwardsGoods,@CreateTime)";
try
{
var paras = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@Awards", DbType = DbType.String, Value = objEntity.Awards
},
new SQLiteParameter()
{
ParameterName = "@AwardsNum", DbType = DbType.Int64, Value = objEntity.AwardsNum
},
new SQLiteParameter()
{
ParameterName = "@UsedNum", DbType = DbType.Int64, Value = objEntity.UsedNum
},
new SQLiteParameter()
{
ParameterName = "@AwardsGoods", DbType = DbType.String, Value = objEntity.AwardsGoods
},
new SQLiteParameter()
{
ParameterName = "@CreateTime", DbType = DbType.DateTime, Value = DateTime.Now
},
};
var data = SQLiteHelper.ExecuteNonQuery(sql, paras);
return(data);
}
catch (Exception)
{
return(-1);
}
}
public object InsertAwards(string Awards, int AwardsNum, string AwardsGoods)
{
if (string.IsNullOrEmpty(Awards))
{
return(Json(new { status = -1, msg = "奖品等级不能为空！" }));
}
lock (_lockobject)
{
var resp = _awardsListLogic.GetAwardsListByAwards(Awards);
if (resp != null)
{
return(Json(new { status = -1, msg = "该奖品等级已经设置过！" }));
}
var m = new AwardsListEntity()
{
Awards = Awards,
AwardsNum = AwardsNum,
UsedNum = AwardsNum,
AwardsGoods = AwardsGoods
};
var data = _awardsListLogic.InsertAwards(m);
return(data > 0 ? Json(new { status = 1, msg = "奖品设置成功" }) : Json(new { status = -1, msg = "奖品设置失败" }));
}
}
public List <AwardsListEntity> GetAwardsListpageList(AwardsListEntity objEntity)
{
var data = _awardsListData.GetAwardsListpageList(objEntity);
return(data);
}
public int InsertAwards(AwardsListEntity objEntity)
{
var data = _awardsListData.InsertAwards(objEntity);
return(data);
}
