/// <summary>
/// 创建店铺管理日志
/// </summary>
/// <param name="uid">用户id</param>
/// <param name="nickName">用户昵称</param>
/// <param name="storeId">店铺id</param>
/// <param name="storeName">店铺名称</param>
/// <param name="ip">ip</param>
/// <param name="operation">操作行为</param>
/// <param name="description">操作描述</param>
public static void CreateStoreAdminLog(int uid, string nickName, int storeId, string storeName, string ip, string operation, string description)
{
StoreAdminLogInfo storeAdminLogInfo = new StoreAdminLogInfo
{
Uid = uid,
NickName = nickName,
StoreId = storeId,
StoreName = storeName,
IP = ip,
OperateTime = DateTime.Now,
Operation = operation,
Description = description
};
BrnMall.Data.StoreAdminLogs.CreateStoreAdminLog(storeAdminLogInfo);
}
/// <summary>
/// 获得店铺管理日志列表
/// </summary>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="condition">条件</param>
/// <returns></returns>
public static List<StoreAdminLogInfo> GetStoreAdminLogList(int pageSize, int pageNumber, string condition)
{
List<StoreAdminLogInfo> storeAdminLogList = new List<StoreAdminLogInfo>();
IDataReader reader = BrnMall.Core.BMAData.RDBS.GetStoreAdminLogList(pageSize, pageNumber, condition);
while (reader.Read())
{
StoreAdminLogInfo storeAdminLogInfo = new StoreAdminLogInfo();
storeAdminLogInfo.LogId = TypeHelper.ObjectToInt(reader["logid"]);
storeAdminLogInfo.Uid = TypeHelper.ObjectToInt(reader["uid"]);
storeAdminLogInfo.NickName = reader["nickname"].ToString();
storeAdminLogInfo.StoreId = TypeHelper.ObjectToInt(reader["storeid"]);
storeAdminLogInfo.StoreName = reader["storename"].ToString();
storeAdminLogInfo.Operation = reader["operation"].ToString();
storeAdminLogInfo.Description = reader["description"].ToString();
storeAdminLogInfo.IP = reader["ip"].ToString();
storeAdminLogInfo.OperateTime = TypeHelper.ObjectToDateTime(reader["operatetime"]);
storeAdminLogList.Add(storeAdminLogInfo);
}
reader.Close();
return storeAdminLogList;
}
/// <summary>
/// 创建店铺管理日志
/// </summary>
public void CreateStoreAdminLog(StoreAdminLogInfo storeAdminLogInfo)
{
DbParameter[] parms = {
GenerateInParam("@uid", SqlDbType.Int, 4, storeAdminLogInfo.Uid),
GenerateInParam("@nickname", SqlDbType.NVarChar, 20, storeAdminLogInfo.NickName),
GenerateInParam("@storeid", SqlDbType.Int, 4, storeAdminLogInfo.StoreId),
GenerateInParam("@storename", SqlDbType.NVarChar, 60, storeAdminLogInfo.StoreName),
GenerateInParam("@operation", SqlDbType.NVarChar, 100, storeAdminLogInfo.Operation),
GenerateInParam("@description", SqlDbType.NVarChar, 200, storeAdminLogInfo.Description),
GenerateInParam("@ip", SqlDbType.VarChar, 15, storeAdminLogInfo.IP),
GenerateInParam("@operatetime", SqlDbType.DateTime, 8, storeAdminLogInfo.OperateTime)
};
string commandText = string.Format("INSERT INTO [{0}storeadminlogs]([uid],[nickname],[storeid],[storename],[operation],[description],[ip],[operatetime]) VALUES(@uid,@nickname,@storeid,@storename,@operation,@description,@ip,@operatetime)",
RDBSHelper.RDBSTablePre);
RDBSHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
/// <summary>
/// 创建店铺管理日志
/// </summary>
public static void CreateStoreAdminLog(StoreAdminLogInfo storeAdminLogInfo)
{
BrnMall.Core.BMAData.RDBS.CreateStoreAdminLog(storeAdminLogInfo);
}
