ado.net 写法

List<OrderSaleBodysVM> orderSaleList = new List<OrderSaleBodysVM>();

recordCount = 0;

string sqlText = string.Empty;
List<SqlParameter> paramList = new List<SqlParameter>();

//自动取消过期的订单
sqlText = @"if EXISTS(Select 1 From OrderSale Where PayUserInfoCode = @UserInfoCode and DATEDIFF(mi, CreateTime, GETDATE())>30 and PayStatus = 0 and OrderStatus = 0)
begin
Update OrderSale set OrderStatus = 6
Where PayUserInfoCode = @UserInfoCode and DATEDIFF(mi, CreateTime, GETDATE())>30 and PayStatus = 0 and OrderStatus = 0
end ";
paramList.Add(new SqlParameter("@UserInfoCode", userInfoCode));

TrSqlHelper.ExecuteNonQuery(CommandType.Text, sqlText, paramList.ToArray());

 

#region 初始化变量

string sqlText = string.Empty;
List<SqlParameter> paramList = new List<SqlParameter>();
DataTable tempTable = null;

List<MallHomeClass> mallHomeList = null;

#endregion

#region 查询数据

if (!ErrorInfo.Status)
{
sqlText = @"SELECT a.MallHomeID, a.ItemName, a.ItemType, a.JumpType, a.JumpParam, a.ImageCode, a.BeginDate, a.EndDate, a.[Priority], a.ItemStatus
FROM dbo.MallHome AS a WITH (NOLOCK)
WHERE a.ItemStatus=1 AND a.BeginDate <= GetDate() AND a.EndDate >= GetDate() AND EXISTS
(SELECT b.MallHomeID FROM dbo.MallHomeUser b WITH (NOLOCK) WHERE A.MallHomeID=b.MallHomeID AND b.PersonCategory = @PersonInfoCode)
Order by a.ItemType, a.[Priority] DESC ";

paramList.Add(new SqlParameter("@PersonInfoCode", personCategory));

tempTable = TrSqlHelper.FillDataTable(CommandType.Text, sqlText, paramList.ToArray());
mallHomeList = EntityHelper.TableToEntity<MallHomeClass>(tempTable);
}

#endregion

#region 设置返回值

if (!ErrorInfo.Status && mallHomeList != null)
{
returnVM = mallHomeList;
}

#endregion