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); } }