public ActionResult Collection(string shoukuanid, string shoukuanshijian, string shoukuanxiangqing)
{
if (!string.IsNullOrEmpty(shoukuanid))
{
var userprovider = new UserLoginProvider();
var _user = userprovider.GetUser(User.Identity.Name);
if (_user.RuleType.Equals(RuleTypeEnum.Agents.ToString()) || _user.RuleType.Equals(RuleTypeEnum.Admin.ToString()))
{
var orderprovider = new OrderInfoProvider();
var order = orderprovider.GetOrderInfoById(Convert.ToInt16(shoukuanid));
if (order != null && order.PayStatus < (int)OrderPayStatusEnum.Recivied)
{
var alog = new SysActionLog();
alog.ActionDate = Convert.ToDateTime(shoukuanshijian);
alog.ActionDesc = shoukuanxiangqing.Trim();
alog.LogType = (int)ActionLogTypeEnum.PayAction;
alog.OrderId = order.Id;
alog.UserId = _user.Id;
alog.CreateDate = DateTime.Now;
alog.IsDelete = false;
var i = DALFactory.ActionLogDao.Insert(alog);
if (i > 0)
{
order.PayStatus = (int)OrderPayStatusEnum.Recivied;
orderprovider.UpdateOrderInfo(order);
}
}
}
}
return(Content("ok"));
}
//特别注意，如果是可空类型，建议以如下方式使用：
// var data = reader["field"];
// entity.stringData = data == null ? data : data.ToString();
//如需要手工映射，请反注释如下代码，并注意转换类型
/*
* /// <summary>
* /// 手工映射，建议使用1.2.0.5版本以上的VisitDataReader
* /// </summary>
* /// <returns>结果</returns>
* public SysActionLog OrmByHand(string sql)
* {
* try
* {
* return baseDao.VisitDataReader<SysActionLog>(sql, (reader) =>
* {
* SysActionLog entity = new SysActionLog();
* if(reader.Read())
* {
* entity.ActionDate = reader["ActionDate"];
* entity.ActionDesc = reader["ActionDesc"];
* entity.CreateDate = reader["CreateDate"];
* entity.Id = reader["Id"];
* entity.IsDelete = reader["IsDelete"];
* entity.LogType = reader["LogType"];
* entity.OrderId = reader["OrderId"];
* entity.UserId = reader["UserId"];
* }
* return entity;
* });
*
* //SysActionLog entity = new SysActionLog();
* //using(var reader = baseDao.SelectDataReader(sql))
* //{
* //if(reader.Read())
* //{
* //entity.ActionDate = reader["ActionDate"];
* //entity.ActionDesc = reader["ActionDesc"];
* //entity.CreateDate = reader["CreateDate"];
* //entity.Id = reader["Id"];
* //entity.IsDelete = reader["IsDelete"];
* //entity.LogType = reader["LogType"];
* //entity.OrderId = reader["OrderId"];
* //entity.UserId = reader["UserId"];
* //}
* //}
* //return entity;
* }
* catch (Exception ex)
* {
* throw new DalException("调用SysActionLogDao时，访问OrmByHand时出错", ex);
* }
* }
*/
/// <summary>
/// 插入SysActionLog
/// </summary>
/// <param name="sysActionLog">SysActionLog实体对象</param>
/// <returns>新增的主键,如果有多个主键则返回第一个主键</returns>
public long Insert(SysActionLog sysActionLog)
{
try
{
Object result = baseDao.Insert <SysActionLog>(sysActionLog);
long iReturn = Convert.ToInt64(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用SysActionLog时，访问Insert时出错", ex);
}
}
/// <summary>
/// 修改SysActionLog
/// </summary>
/// <param name="sysActionLog">SysActionLog实体对象</param>
/// <returns>状态代码</returns>
public int Update(SysActionLog sysActionLog)
{
try
{
Object result = baseDao.Update <SysActionLog>(sysActionLog);
int iReturn = Convert.ToInt32(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用SysActionLog时，访问Update时出错", ex);
}
}
/// <summary>
/// 检索SysActionLog，带翻页
/// </summary>
/// <param name="obj">SysActionLog实体对象检索条件</param>
/// <param name="pagesize">每页记录数</param>
/// <param name="pageNo">页码</param>
/// <returns>检索结果</returns>
public IList <SysActionLog> GetListByPage(SysActionLog obj, int pagesize, int pageNo)
{
try
{
StringBuilder sbSql = new StringBuilder(200);
sbSql.Append(@"select ActionDate, ActionDesc, CreateDate, Id, IsDelete, LogType, OrderId, UserId from SysActionLog (nolock) ");
sbSql.Append(" order by Id desc ");
sbSql.Append(string.Format("OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY", (pageNo - 1) * pagesize, pagesize));
IList <SysActionLog> list = baseDao.SelectList <SysActionLog>(sbSql.ToString());
return(list);
}
catch (Exception ex)
{
throw new DalException("调用SysActionLogDao时，访问GetListByPage时出错", ex);
}
}
