/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public string Add(Musercoupon model) { MwxResult mwxResult = new MwxResult() { errcode = -1 }; try { DateTime dateTimeNow = System.DateTime.Now; model.isDelete = "0"; model.isEffective = "1"; model.great_time = dateTimeNow; model.modify_time = dateTimeNow; model.id = PublicTools.GetRandomNumberByTime(); if (new UserCouponService().Add(model)) { mwxResult.errcode = 0; mwxResult.errmsg = "操作成功!"; } else { mwxResult.errmsg = "操作失败!"; } } catch (Exception ex) { mwxResult.errmsg = "操作失败!"; } return(JsonHelper.GetJson <MwxResult>(mwxResult)); }
/// <summary> /// 新增产品分类方法接口 /// </summary> /// <returns></returns> public string AddUserGroupMeth(Musercoupon model) { if (!base.CheckIsLogin()) { return("-1"); } return(new UserCouponBus().Add(model)); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Musercoupon model) { //// sql语句 string sql = "INSERT INTO usercoupon (id,userId,userName,couponId,name,price,consumAmount,effectiveStart,effectiveEnd,receiveTime,isUse,useTime,orderId,isDelete,isEffective,great_time,modify_time) " + "VALUES (?id,?userId,?userName,?couponId,?name,?price,?consumAmount,?effectiveStart,?effectiveEnd,?receiveTime,?isUse,?useTime,?orderId,?isDelete,?isEffective,?great_time,?modify_time)"; List <MySqlParameter> parameterList = GetMySqlParameterListByModel(model); //// 执行操作 return(PKMySqlHelper.ExecuteNonQuery(sql, parameterList.ToArray()) > 0); }
/// <summary> /// 根据id获取 /// </summary> /// <param name="id"></param> /// <returns></returns> public Musercoupon GetById(string id) { Musercoupon model = null; string sql = " SELECT id,userId,userName,couponId,name,price,consumAmount,effectiveStart,effectiveEnd,receiveTime,isUse,useTime,orderId,isDelete,isEffective,great_time,modify_time " + $" FROM usercoupon WHERE id=?id ; "; MySqlParameter[] parameterList = new MySqlParameter[1]; MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = id; parameterList[0] = parameter; using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList)) { if (sqlDataReader.Read()) { model = new Musercoupon(); model.id = sqlDataReader["id"] != DBNull.Value ? sqlDataReader["id"].ToString() : string.Empty; model.userId = sqlDataReader["userId"] != DBNull.Value ? sqlDataReader["userId"].ToString() : string.Empty; model.userName = sqlDataReader["userName"] != DBNull.Value ? sqlDataReader["userName"].ToString() : string.Empty; model.userName = Base64.DecodeBase64(model.userName); model.couponId = sqlDataReader["couponId"] != DBNull.Value ? sqlDataReader["couponId"].ToString() : string.Empty; model.name = sqlDataReader["name"] != DBNull.Value ? sqlDataReader["name"].ToString() : string.Empty; model.price = sqlDataReader["price"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["price"].ToString()) : 0M; model.consumAmount = sqlDataReader["consumAmount"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["consumAmount"].ToString()) : 0M; model.effectiveStart = sqlDataReader["effectiveStart"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["effectiveStart"].ToString()) : DateTime.MinValue; model.effectiveEnd = sqlDataReader["effectiveEnd"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["effectiveEnd"].ToString()) : DateTime.MinValue; model.receiveTime = sqlDataReader["receiveTime"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["receiveTime"].ToString()) : DateTime.MinValue; model.useTime = sqlDataReader["useTime"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["useTime"].ToString()) : DateTime.MinValue; model.isUse = sqlDataReader["isUse"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["isUse"].ToString()) : 0; model.orderId = sqlDataReader["orderId"] != DBNull.Value ? sqlDataReader["orderId"].ToString() : string.Empty; model.isEffective = sqlDataReader["isEffective"] != DBNull.Value ? sqlDataReader["isEffective"].ToString() : string.Empty; model.isDelete = sqlDataReader["isDelete"] != DBNull.Value ? sqlDataReader["isDelete"].ToString() : string.Empty; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue; model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue; } } return(model); }
/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Musercoupon model) { return(opertService.Add(model)); }
/// <summary> /// 获取参数化查询对象 /// </summary> /// <param name="model"></param> /// <returns></returns> private List <MySqlParameter> GetMySqlParameterListByModel(Musercoupon model) { List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?id", MySqlDbType.VarChar, 25); parameter.Value = model.id; parameterList.Add(parameter); parameter = new MySqlParameter("?userId", MySqlDbType.VarChar, 25); parameter.Value = model.userId; parameterList.Add(parameter); parameter = new MySqlParameter("?userName", MySqlDbType.VarChar, 500); parameter.Value = Base64.EncodeBase64(model.userName); parameterList.Add(parameter); parameter = new MySqlParameter("?couponId", MySqlDbType.VarChar, 25); parameter.Value = model.couponId; parameterList.Add(parameter); parameter = new MySqlParameter("?name", MySqlDbType.VarChar, 100); parameter.Value = model.name; parameterList.Add(parameter); parameter = new MySqlParameter("?price", MySqlDbType.Decimal); parameter.Value = model.price; parameterList.Add(parameter); parameter = new MySqlParameter("?consumAmount", MySqlDbType.Decimal); parameter.Value = model.consumAmount; parameterList.Add(parameter); parameter = new MySqlParameter("?effectiveStart", MySqlDbType.DateTime); parameter.Value = model.effectiveStart; parameterList.Add(parameter); parameter = new MySqlParameter("?effectiveEnd", MySqlDbType.DateTime); parameter.Value = model.effectiveEnd; parameterList.Add(parameter); parameter = new MySqlParameter("?receiveTime", MySqlDbType.DateTime); parameter.Value = model.receiveTime; parameterList.Add(parameter); parameter = new MySqlParameter("?isUse", MySqlDbType.Int16, 1); parameter.Value = model.isUse; parameterList.Add(parameter); parameter = new MySqlParameter("?useTime", MySqlDbType.DateTime); parameter.Value = model.useTime; parameterList.Add(parameter); parameter = new MySqlParameter("?couponId", MySqlDbType.VarChar, 25); parameter.Value = model.couponId; parameterList.Add(parameter); parameter = new MySqlParameter("?orderId", MySqlDbType.VarChar, 25); parameter.Value = model.orderId; parameterList.Add(parameter); parameter = new MySqlParameter("?isDelete", MySqlDbType.Int16, 1); parameter.Value = model.isDelete; parameterList.Add(parameter); parameter = new MySqlParameter("?isEffective", MySqlDbType.Int16, 1); parameter.Value = model.isEffective; parameterList.Add(parameter); DateTime dateTime = System.DateTime.Now; parameter = new MySqlParameter("?great_time", MySqlDbType.DateTime); parameter.Value = dateTime; parameterList.Add(parameter); parameter = new MySqlParameter("?modify_time", MySqlDbType.DateTime); parameter.Value = dateTime; parameterList.Add(parameter); return(parameterList); }
/// <summary> /// 分页获取新闻信息 /// </summary> /// <param name="pagIndex">页码(第一页从1 开始)</param> /// <param name="pagCount">每页数据条数</param> /// <returns></returns> public List <Musercoupon> GetPagList(string userId, int isUse, int pagIndex, int pagCount) { // 查询条件 StringBuilder sqlWhere = new StringBuilder(" 1=1 "); if (!string.IsNullOrEmpty(userId)) { sqlWhere.Append(" and userId = ?userId"); } if (isUse >= 0) { sqlWhere.Append(" and isUse = ?isUse"); } string sql = " SELECT id,userId,userName,couponId,name,price,consumAmount,effectiveStart,effectiveEnd,receiveTime,isUse,useTime,orderId,isDelete,isEffective,great_time,modify_time " + $" FROM usercoupon WHERE {sqlWhere.ToString()} and isDelete=0 ORDER BY 1 desc ,1 desc limit {((pagIndex - 1) * pagCount)}, {pagCount}; "; List <MySqlParameter> parameterList = new List <MySqlParameter>(); MySqlParameter parameter = new MySqlParameter("?userId", MySqlDbType.VarChar); parameter.Value = userId; parameterList.Add(parameter); parameter = new MySqlParameter("?isUse", MySqlDbType.Int32); parameter.Value = isUse; parameterList.Add(parameter); List <Musercoupon> listModel = null; using (MySqlDataReader sqlDataReader = PKMySqlHelper.ExecuteReader(sql, parameterList.ToArray())) { if (sqlDataReader != null) { listModel = new List <Musercoupon>(); while (sqlDataReader.Read()) { Musercoupon model = new Musercoupon(); model.id = sqlDataReader["id"] != DBNull.Value ? sqlDataReader["id"].ToString() : string.Empty; model.userId = sqlDataReader["userId"] != DBNull.Value ? sqlDataReader["userId"].ToString() : string.Empty; model.userName = sqlDataReader["userName"] != DBNull.Value ? sqlDataReader["userName"].ToString() : string.Empty; model.userName = Base64.DecodeBase64(model.userName); model.couponId = sqlDataReader["couponId"] != DBNull.Value ? sqlDataReader["couponId"].ToString() : string.Empty; model.name = sqlDataReader["name"] != DBNull.Value ? sqlDataReader["name"].ToString() : string.Empty; model.price = sqlDataReader["price"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["price"].ToString()) : 0M; model.consumAmount = sqlDataReader["consumAmount"] != DBNull.Value ? Convert.ToDecimal(sqlDataReader["consumAmount"].ToString()) : 0M; model.effectiveStart = sqlDataReader["effectiveStart"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["effectiveStart"].ToString()) : DateTime.MinValue; model.effectiveEnd = sqlDataReader["effectiveEnd"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["effectiveEnd"].ToString()) : DateTime.MinValue; model.receiveTime = sqlDataReader["receiveTime"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["receiveTime"].ToString()) : DateTime.MinValue; model.useTime = sqlDataReader["useTime"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["useTime"].ToString()) : DateTime.MinValue; model.isUse = sqlDataReader["isUse"] != DBNull.Value ? Convert.ToInt32(sqlDataReader["isUse"].ToString()) : 0; model.orderId = sqlDataReader["orderId"] != DBNull.Value ? sqlDataReader["orderId"].ToString() : string.Empty; model.isEffective = sqlDataReader["isEffective"] != DBNull.Value ? sqlDataReader["isEffective"].ToString() : string.Empty; model.isDelete = sqlDataReader["isDelete"] != DBNull.Value ? sqlDataReader["isDelete"].ToString() : string.Empty; model.great_time = sqlDataReader["great_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["great_time"].ToString()) : DateTime.MinValue; model.modify_time = sqlDataReader["modify_time"] != DBNull.Value ? Convert.ToDateTime(sqlDataReader["modify_time"].ToString()) : DateTime.MinValue; listModel.Add(model); } } } return(listModel); }