public int OrderReadMessage(int userid, int infoid)
{
try
{
int result = 0;
string sql = @"select count(1) from InformationRead where UserId=@userid and InformationId=@InfoId";
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@userid", userid);
parameters.Append("@InfoId", infoid);
bool isRead = DbSFO2ORead.ExecuteScalar(CommandType.Text, sql, parameters).ToString() == "0" ? false : true;
//如果已读表不存在词条数据，则插入
if (!isRead)
{
sql = @"INSERT INTO [InformationRead]([UserId],[InformationId],[CreateTime])VALUES (@userid,@InfoId,GETDATE())";
parameters.Clear();
parameters.Append("@userid", userid);
parameters.Append("@InfoId", infoid);
result = DbSFO2OMain.ExecuteNonQuery(CommandType.Text, sql, parameters);
}
return(result);
}
catch (Exception ex)
{
LogHelper.Error(ex);
return(-1);
}
}
/// <summary>
/// 获取用户所在地区
/// </summary>
/// <param name="userid">用户id</param>
/// <returns>1.大陆 2.中华人民共和国大陆地区</returns>
public int GetUserRegion(int userid)
{
string sql = @"select case RegionCode when '86' then 1 else 2 end as 'SendID' from Customer where ID=@UserID";
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@UserID", userid);
return(Convert.ToInt32(DbSFO2ORead.ExecuteScalar(CommandType.Text, sql, parameters)));
}
public int GetUserTempByUserName(string UserName)
{
string sql = "SELECT COUNT(1) FROM CustomerTemp AS c WHERE c.UserName = @UserName ";
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@UserName", UserName);
return(Convert.ToInt32(DbSFO2ORead.ExecuteScalar(CommandType.Text, sql, parameters)));
}
/// <summary>
/// 生成结算单顺序号
/// </summary>
/// <param name="refundCode"></param>
/// <returns></returns>
public int GetSettleCodeNo(string orderCode)
{
string sql = "Select Count(1) From SettlementOrderInfo Where OrderCode=@OrderCode";
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@OrderCode", orderCode);
object obj = DbSFO2ORead.ExecuteScalar(CommandType.Text, sql, parameters);
return(obj == null ? 0 : Convert.ToInt32(obj));
}
public bool getOrderInfoCount(int userId, string startTime, string endTime)
{
string sql = @"SELECT count(1) FROM OrderInfo AS oi LEFT JOIN TeamInfo AS ti ON ti.TeamCode = oi.TeamCode AND ti.UserId = oi.UserId
WHERE ti.TeamStatus=3 AND ti.UserID=@userId AND ti.StartTime>=@startTime AND ti.StartTime<=@endTime AND oi.OrderStatus=4";
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@userId", userId);
parameters.Append("@startTime", startTime);
parameters.Append("@endTime", endTime);
object returnValue = DbSFO2ORead.ExecuteScalar(CommandType.Text, sql, parameters);
return(returnValue == null ? false : Convert.ToInt32(returnValue) > 0);
}
/// <summary>
/// 用户名是否已经存在
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public bool IsExistsUserName(string userName, string regionCode)
{
try
{
string sql = "Select Count(0) From Customer (nolock) Where UserName=@UserName And RegionCode=@RegionCode";
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@UserName", userName);
parameters.Append("@RegionCode", regionCode);
object obj = DbSFO2ORead.ExecuteScalar(CommandType.Text, sql, parameters);
return(int.Parse(obj.ToString()) > 0);
}
catch (Exception ex)
{
LogHelper.Error(ex);
return(false);
}
}
public decimal GetGiftCardValueById(int userId, int id)
{
//为了保险起见，防止传过来的id被篡改，进行一下简单的过滤
string sql = @"select CardSum from GiftCard g where g.UserId=@uid and g.Id=@id and g.[Status]=0 and (GETDATE()>g.BeginTime and GETDATE()<g.EndTime)";
try
{
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@uid", userId);
parameters.Append("@id", id);
return(Convert.ToDecimal(DbSFO2ORead.ExecuteScalar(CommandType.Text, sql, parameters)));
}
catch (Exception ex)
{
LogHelper.Error(ex);
return(0M);
}
}