/// <summary>
/// 微博 列表
/// </summary>
public ActionResult weibolicenseList(tb_weibolicense model)
{
int count = 0;
ViewBag.weibolicenseList = dweibolicense.GetList(model, ref count);
ViewBag.page = Utils.ShowPage(count, model.PageSize, model.PageIndex, 5);
return(View());
}
/// <summary>
/// 微博 保存
/// </summary>
public JsonResult weibolicenseSave(tb_weibolicense model)
{
if (model == null)
{
return(ResultTool.jsonResult(false, "参数错误！"));
}
if (!String.IsNullOrEmpty(model.id))
{
bool boolResult = dweibolicense.Update(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "更新失败！"));
}
else
{
model.id = Guid.NewGuid().ToString("N");
bool boolResult = dweibolicense.Add(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "添加失败！"));
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(tb_weibolicense model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from tb_weibolicense ");
strSql.Append(" where ");
using (IDbConnection conn = DapperHelper.OpenConnection())
{
int count = conn.Execute(strSql.ToString(), model);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(tb_weibolicense model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_weibolicense(");
strSql.Append("id,openid,addtime,subscribe,nickname,sex,city,country,province,language,headimgurl,subscribe_time,unionid,code,userType,userid)");
strSql.Append(" values (");
strSql.Append("@id,@openid,@addtime,@subscribe,@nickname,@sex,@city,@country,@province,@language,@headimgurl,@subscribe_time,@unionid,@code,@userType,@userid)");
using (IDbConnection conn = DapperHelper.OpenConnection())
{
int count = conn.Execute(strSql.ToString(), model);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 微博 详情
/// </summary>
public ActionResult weibolicenseInfo(tb_weibolicense model)
{
model = dweibolicense.GetInfo(model);
return(View(model ?? new tb_weibolicense()));
}
/// <summary>
/// 微博 删除
/// </summary>
public JsonResult weibolicenseDelete(tb_weibolicense model)
{
bool boolResult = dweibolicense.Delete(model);
return(ResultTool.jsonResult(boolResult, boolResult ? "成功！" : "删除失败！"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(tb_weibolicense model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder setSql = new StringBuilder();
strSql.Append("update tb_weibolicense set ");
if (!String.IsNullOrEmpty(model.id))
{
setSql.Append("id=@id,");
}
if (!String.IsNullOrEmpty(model.openid))
{
setSql.Append("openid=@openid,");
}
if (model.addtime != null)
{
setSql.Append("addtime=@addtime,");
}
if (model.subscribe != null)
{
setSql.Append("subscribe=@subscribe,");
}
if (!String.IsNullOrEmpty(model.nickname))
{
setSql.Append("nickname=@nickname,");
}
if (model.sex != null)
{
setSql.Append("sex=@sex,");
}
if (!String.IsNullOrEmpty(model.city))
{
setSql.Append("city=@city,");
}
if (!String.IsNullOrEmpty(model.country))
{
setSql.Append("country=@country,");
}
if (!String.IsNullOrEmpty(model.province))
{
setSql.Append("province=@province,");
}
if (!String.IsNullOrEmpty(model.language))
{
setSql.Append("language=@language,");
}
if (!String.IsNullOrEmpty(model.headimgurl))
{
setSql.Append("headimgurl=@headimgurl,");
}
if (!String.IsNullOrEmpty(model.subscribe_time))
{
setSql.Append("subscribe_time=@subscribe_time,");
}
if (!String.IsNullOrEmpty(model.unionid))
{
setSql.Append("unionid=@unionid,");
}
if (!String.IsNullOrEmpty(model.code))
{
setSql.Append("code=@code,");
}
if (!String.IsNullOrEmpty(model.userType))
{
setSql.Append("userType=@userType,");
}
if (!String.IsNullOrEmpty(model.userid))
{
setSql.Append("userid=@userid,");
}
strSql.Append(setSql.ToString().TrimEnd(','));
strSql.Append(" where ");
using (IDbConnection conn = DapperHelper.OpenConnection())
{
int count = conn.Execute(strSql.ToString(), model);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <tb_weibolicense> GetList(tb_weibolicense model, ref int total)
{
List <tb_weibolicense> list;
StringBuilder strSql = new StringBuilder();
StringBuilder whereSql = new StringBuilder(" where 1 = 1 ");
strSql.Append(" select ROW_NUMBER() OVER(ORDER BY desc) AS RID, * from tb_weibolicense ");
if (!String.IsNullOrEmpty(model.id))
{
whereSql.Append(" and id=@id");
}
if (!String.IsNullOrEmpty(model.openid))
{
whereSql.Append(" and openid=@openid");
}
if (model.addtime != null)
{
whereSql.Append(" and addtime=@addtime");
}
if (model.subscribe != null)
{
whereSql.Append(" and subscribe=@subscribe");
}
if (!String.IsNullOrEmpty(model.nickname))
{
whereSql.Append(" and nickname=@nickname");
}
if (model.sex != null)
{
whereSql.Append(" and sex=@sex");
}
if (!String.IsNullOrEmpty(model.city))
{
whereSql.Append(" and city=@city");
}
if (!String.IsNullOrEmpty(model.country))
{
whereSql.Append(" and country=@country");
}
if (!String.IsNullOrEmpty(model.province))
{
whereSql.Append(" and province=@province");
}
if (!String.IsNullOrEmpty(model.language))
{
whereSql.Append(" and language=@language");
}
if (!String.IsNullOrEmpty(model.headimgurl))
{
whereSql.Append(" and headimgurl=@headimgurl");
}
if (!String.IsNullOrEmpty(model.subscribe_time))
{
whereSql.Append(" and subscribe_time=@subscribe_time");
}
if (!String.IsNullOrEmpty(model.unionid))
{
whereSql.Append(" and unionid=@unionid");
}
if (!String.IsNullOrEmpty(model.code))
{
whereSql.Append(" and code=@code");
}
if (!String.IsNullOrEmpty(model.userType))
{
whereSql.Append(" and userType=@userType");
}
if (!String.IsNullOrEmpty(model.userid))
{
whereSql.Append(" and userid=@userid");
}
strSql.Append(whereSql);
string CountSql = "SELECT COUNT(1) as RowsCount FROM (" + strSql.ToString() + ") AS CountList";
string pageSqlStr = "select * from ( " + strSql.ToString() + " ) as Temp_PageData where Temp_PageData.RID BETWEEN {0} AND {1}";
pageSqlStr = string.Format(pageSqlStr, (model.PageSize * (model.PageIndex - 1) + 1).ToString(), (model.PageSize * model.PageIndex).ToString());
using (IDbConnection conn = DapperHelper.OpenConnection())
{
list = conn.Query <tb_weibolicense>(pageSqlStr, model)?.ToList();
total = conn.ExecuteScalar <int>(CountSql, model);
}
return(list);
}
