/// <summary> /// 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <bool> AddAsync(RecommendModel model) { using (var conn = MySqlHelper.GetConnection()) { return(!string.IsNullOrWhiteSpace(await conn.InsertAsync <string, RecommendModel>(model))); } }
public IActionResult Register([FromBody] RecommendModel recommendModel) { // map dto to entity var recommend = _iMapper.Map <Recommend>(recommendModel); try { // save var result = _iRecommendService.Create( recommend, recommendModel.PostId, recommendModel.ResumeId); var count = 1; if (result != null) { return(Output(new DeleteOrUpdateResponse { id = result.RecommendId, }, count)); } throw new Exception("创建失败!"); } catch (AppException ex) { // return error message if there was an exception return(BadRequest(new { message = ex.Message })); } }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <bool> UpdateAsync(RecommendModel model) { using (var conn = MySqlHelper.GetConnection()) { var result = await conn.UpdateAsync(model); return(result > 0); } }
/// <summary> /// 得到一个对象实体 /// </summary> public RecommendModel GetModel(string RecommendId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select RecommendId, RecommendMemo, ReKey, RecommendType, BgTime, EndTime, Invalid "); strSql.Append(" from Recommend "); strSql.Append(" where RecommendId=@RecommendId "); SqlParameter[] parameters = { new SqlParameter("@RecommendId", SqlDbType.VarChar, 50) }; parameters[0].Value = RecommendId; RecommendModel model = new RecommendModel(); DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.RecommendId = ds.Tables[0].Rows[0]["RecommendId"].ToString(); model.RecommendMemo = ds.Tables[0].Rows[0]["RecommendMemo"].ToString(); model.ReKey = ds.Tables[0].Rows[0]["ReKey"].ToString(); model.RecommendType = ds.Tables[0].Rows[0]["RecommendType"].ToString(); if (ds.Tables[0].Rows[0]["BgTime"].ToString() != "") { model.BgTime = DateTime.Parse(ds.Tables[0].Rows[0]["BgTime"].ToString()); } if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString()); } if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true")) { model.Invalid = true; } else { model.Invalid = false; } } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(RecommendModel model) { bool reValue = true; int reCount = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("update Recommend set "); strSql.Append(" RecommendId = @RecommendId , "); strSql.Append(" RecommendMemo = @RecommendMemo , "); strSql.Append(" ReKey = @ReKey , "); strSql.Append(" RecommendType = @RecommendType , "); strSql.Append(" BgTime = @BgTime , "); strSql.Append(" EndTime = @EndTime , "); strSql.Append(" Invalid = @Invalid "); strSql.Append(" where RecommendId=@RecommendId "); SqlParameter[] parameters = { new SqlParameter("@RecommendId", SqlDbType.VarChar, 50), new SqlParameter("@RecommendMemo", SqlDbType.VarChar, 500), new SqlParameter("@ReKey", SqlDbType.VarChar, 50), new SqlParameter("@RecommendType", SqlDbType.VarChar, 20), new SqlParameter("@BgTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@Invalid", SqlDbType.Bit, 1) }; parameters[0].Value = model.RecommendId; parameters[1].Value = model.RecommendMemo; parameters[2].Value = model.ReKey; parameters[3].Value = model.RecommendType; parameters[4].Value = model.BgTime; parameters[5].Value = model.EndTime; parameters[6].Value = model.Invalid; try {//异常处理 reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters); } catch (Exception ex) { this.helper.Close(); throw ex; } if (reCount <= 0) { reValue = false; } return(reValue); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(RecommendModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Recommend("); strSql.Append("RecommendId,RecommendMemo,ReKey,RecommendType,BgTime,EndTime,Invalid"); strSql.Append(") values ("); strSql.Append("@RecommendId,@RecommendMemo,@ReKey,@RecommendType,@BgTime,@EndTime,@Invalid"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@RecommendId", SqlDbType.VarChar, 50), new SqlParameter("@RecommendMemo", SqlDbType.VarChar, 500), new SqlParameter("@ReKey", SqlDbType.VarChar, 50), new SqlParameter("@RecommendType", SqlDbType.VarChar, 20), new SqlParameter("@BgTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@Invalid", SqlDbType.Bit, 1) }; parameters[0].Value = model.RecommendId; parameters[1].Value = model.RecommendMemo; parameters[2].Value = model.ReKey; parameters[3].Value = model.RecommendType; parameters[4].Value = model.BgTime; parameters[5].Value = model.EndTime; parameters[6].Value = model.Invalid; bool result = false; try { helper.ExecSqlReInt(strSql.ToString(), parameters); result = true; } catch (Exception ex) { this.helper.Close(); throw ex; } finally { } return(result); }
public static SaveQuoteViewModel ConverToViewModel(this RecommendModel model) { SaveQuoteViewModel vm = new SaveQuoteViewModel(); if (model != null) { vm.BoLi = model.BoLi ?? 0; //vm.CheDeng = model.CheDeng ?? 0; vm.CheSun = model.CheSun ?? 0; vm.ChengKe = model.ChengKe ?? 0; vm.DaoQiang = model.DaoQiang ?? 0; vm.HuaHen = model.HuaHen ?? 0; vm.SanZhe = model.SanZhe ?? 0; vm.SheShui = model.SheShui ?? 0; vm.SiJi = model.SiJi ?? 0; vm.BuJiMianCheSun = model.BuJiMianCheSun ?? 0; vm.BuJiMianDaoQiang = model.BuJiMianDaoQiang ?? 0; //vm.BuJiMianFuJia = model.BuJiMianFuJia ?? 0; //vm.BuJiMianRenYuan = model.BuJiMianRenYuan ?? 0; vm.BuJiMianSanZhe = model.BuJiMianSanZhe ?? 0; vm.ZiRan = model.ZiRan ?? 0; vm.Source = 0;// model.LastYearSource.Value;中心不提供 //2.1.5修改 新增8个字段 vm.BuJiMianChengKe = model.BuJiMianChengKe ?? 0; vm.BuJiMianSiJi = model.BuJiMianSiJi ?? 0; vm.BuJiMianHuaHen = model.BuJiMianHuaHen ?? 0; vm.BuJiMianSheShui = model.BuJiMianSheShui ?? 0; vm.BuJiMianZiRan = model.BuJiMianZiRan ?? 0; vm.BuJiMianJingShenSunShi = model.BuJiMianJingShenSunShi ?? 0; vm.HcSanFangTeYue = model.SanFangTeYue ?? 0; vm.HcJingShenSunShi = model.JingShenSunShi ?? 0; vm.HcXiuLiChang = (model.XiuLiChang ?? 0).ToString(CultureInfo.InvariantCulture); vm.HcXiuLiChangType = "-1"; //(model.XiuLiChangType ?? -1).ToString();中心不提供 vm.Fybc = (model.FeiYongBuChang ?? 0).ToString(CultureInfo.InvariantCulture); vm.FybcDays = "0"; //(model.FeiYongBuChangDays ?? 0).ToString();中心不提供 vm.SheBeiSunShi = (model.SheBeiSunShi ?? 0).ToString(CultureInfo.InvariantCulture); vm.BjmSheBeiSunShi = (model.BuJiMianSheBeiSunshi ?? 0).ToString(CultureInfo.InvariantCulture); //List<SheBei> sheBeis = new List<SheBei>();中心不提供 //vm.SheBeis = sheBeis; vm.SanZheJieJiaRi = (model.SanZheJieJiaRi ?? 0).ToString(); } return(vm); }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); data = new List <RecommendModel>(); SetContentView(Resource.Layout.Recommendation); ISharedPreferences prefs = PreferenceManager.GetDefaultSharedPreferences(ApplicationContext); email = prefs.GetString("email", "empty"); if (email.Equals("empty")) { StartActivity(typeof(MainActivity)); this.Finish(); } listView = FindViewById <ListView>(Resource.Id.listView1); try { Task <string> task = recommeds(); var x = JsonConvert.DeserializeObject <RecommendModel[]>(task.Result); foreach (RecommendModel a in x) { data.Add(a); } } catch (Exception e) { Toast.MakeText(this, "Error! Some Wrong Happen", ToastLength.Short).Show(); } listView.Adapter = new CusotmListAdapter(this, data); listView.ItemClick += (object sender, AdapterView.ItemClickEventArgs e) => { RecommendModel selectedFromList = data[e.Position]; ShareToBrowser(selectedFromList.url); // Create your application here }; }
public IActionResult Patch(string id, [FromBody] RecommendModel recommendModel) { // map dto to entity and set id var user = _iMapper.Map <Recommend>(recommendModel); user.RecommendId = id; var count = 1; try { // save _iRecommendService.Patch(user); return(Output(new DeleteOrUpdateResponse { id = user.RecommendId, }, count)); } catch (AppException ex) { // return error message if there was an exception return(BadRequest(new { message = ex.Message })); } }
private async Task <Tuple <RecommendModel, bool> > SimulateGet(string strUrl) { RecommendModel model = new RecommendModel(); bool isGet = false; try { string responsemsg = string.Empty; using (var client = new HttpClient()) { //设置超时时间 180秒 client.Timeout = TimeSpan.FromMilliseconds(1000 * 30); var clientResult = await client.GetAsync(strUrl); if (clientResult.IsSuccessStatusCode) { responsemsg = await clientResult.Content.ReadAsStringAsync(); //loginfo记录返回 logInfo.Info(string.Format("中心智能获取险种请求串:{0},返回:{1}", strUrl, responsemsg)); } if (!string.IsNullOrWhiteSpace(responsemsg) && responsemsg.Length > 20) { //解析对象,中心返回的对象不规则,这里得注意try,catch model = responsemsg.FromJson <RecommendModel>(); isGet = true; return(new Tuple <RecommendModel, bool>(model, isGet)); } } return(new Tuple <RecommendModel, bool>(model, isGet)); } catch (Exception ex) { logError.Info("请求中心获取智能推荐险种异常,请求串为:" + strUrl + "\n 异常信息:" + ex.Source + "\n" + ex.StackTrace + "\n" + ex.Message + "\n" + ex.InnerException); } return(new Tuple <RecommendModel, bool>(new RecommendModel(), isGet)); }
public IHttpActionResult GetRecommendPlans(string ZipCode) { RecommendModel recModel = new RecommendModel(); recModel.NewlyReleasedBundle = new List <BundleModel>(); recModel.CntryPopularBundle = new List <BundleModel>(); recModel.ZipPopularBundle = new List <BundleModel>(); recModel.SubPopularBundle = new List <BundleModel>(); var x = Data.Tables[0].AsEnumerable().FirstOrDefault(tt => (tt.Field <string>("Zipcode") == ZipCode)); var zipPop = x[zipPopular].ToString().Split(new string[] { (",") }, StringSplitOptions.RemoveEmptyEntries); var cntryPop = x[countryPopular].ToString().Split(new string[] { (",") }, StringSplitOptions.RemoveEmptyEntries); var subbndl = x[subbndlValue].ToString().Split(new string[] { (",") }, StringSplitOptions.RemoveEmptyEntries); var newlyadded = x[newlyaddedbundle].ToString().Split(new string[] { (",") }, StringSplitOptions.RemoveEmptyEntries); foreach (var popbundId in zipPop) { var row = Data.Tables[1].AsEnumerable().FirstOrDefault(d => d.Field <string>("BundleId") == popbundId.Trim()); if (row != null) { BundleModel bun = new BundleModel(); bun.BundleId = row["BundleId"].ToString(); bun.Type = row["Type"].ToString(); bun.Name = row["Name"].ToString(); bun.Price = row["Price"].ToString(); bun.DAT = row["DAT"].ToString(); bun.TV = row["TV"].ToString(); bun.VOICE = row["VOICE"].ToString(); bun.ROUTER = row["ROUTER"].ToString(); bun.Discount = row["Discount"].ToString(); bun.Keyword = row["Keyword"].ToString(); recModel.ZipPopularBundle.Add(bun); } } foreach (var popbundId in cntryPop) { var row = Data.Tables[1].AsEnumerable().FirstOrDefault(d => d.Field <string>("BundleId") == popbundId.Trim()); if (row != null) { BundleModel bun = new BundleModel(); bun.BundleId = row["BundleId"].ToString(); bun.Type = row["Type"].ToString(); bun.Name = row["Name"].ToString(); bun.Price = row["Price"].ToString(); bun.DAT = row["DAT"].ToString(); bun.TV = row["TV"].ToString(); bun.VOICE = row["VOICE"].ToString(); bun.ROUTER = row["ROUTER"].ToString(); bun.Discount = row["Discount"].ToString(); bun.Keyword = row["Keyword"].ToString(); recModel.CntryPopularBundle.Add(bun); } } foreach (var popbundId in subbndl) { var row = Data.Tables[1].AsEnumerable().FirstOrDefault(d => d.Field <string>("BundleId") == popbundId.Trim()); if (row != null) { BundleModel bun = new BundleModel(); bun.BundleId = row["BundleId"].ToString(); bun.Type = row["Type"].ToString(); bun.Name = row["Name"].ToString(); bun.Price = row["Price"].ToString(); bun.DAT = row["DAT"].ToString(); bun.TV = row["TV"].ToString(); bun.VOICE = row["VOICE"].ToString(); bun.ROUTER = row["ROUTER"].ToString(); bun.Discount = row["Discount"].ToString(); bun.Keyword = row["Keyword"].ToString(); recModel.SubPopularBundle.Add(bun); } } foreach (var popbundId in newlyadded) { var row = Data.Tables[1].AsEnumerable().FirstOrDefault(d => d.Field <string>("BundleId") == popbundId.Trim()); if (row != null) { BundleModel bun = new BundleModel(); bun.BundleId = row["BundleId"].ToString(); bun.Type = row["Type"].ToString(); bun.Name = row["Name"].ToString(); bun.Price = row["Price"].ToString(); bun.DAT = row["DAT"].ToString(); bun.TV = row["TV"].ToString(); bun.VOICE = row["VOICE"].ToString(); bun.ROUTER = row["ROUTER"].ToString(); bun.Discount = row["Discount"].ToString(); bun.Keyword = row["Keyword"].ToString(); recModel.NewlyReleasedBundle.Add(bun); } } return(Json(JsonConvert.SerializeObject(recModel))); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="pageIndex">页码</param> /// <param name="pageSize">分页大小</param> /// <param name="name">菜品名 - 搜索项</param> /// <param name="categoryId">分类id - 搜索项</param> /// <param name="createdTimeStart">发布日期起 - 搜索项</param> /// <param name="createdTimeEnd">发布日期止 - 搜索项</param> /// <returns></returns> public PageList <Domain.Mall.Recommend.RecommendModel> Get_RecommendPageList(int pageIndex, int pageSize, string name, int recommendCode) { using (DbRepository entities = new DbRepository()) { var query = entities.Recommend.AsQueryable().Where(x => x.PersonId.Equals(Client.LoginUser.UNID)); //活动名 //实例化对象 Goods goodsItem = null; Category categoryItem = null; Dictionary <string, Goods> goodsDic = new Dictionary <string, Goods>(); Dictionary <string, Category> categoryDic = new Dictionary <string, Category>(); //必须先选择活动类型 if (recommendCode != 0) { query = query.Where(x => x.RecommendCode == recommendCode); //判断活动类型 if (recommendCode == (int)RecommendCode.HomeGoods) { //遍历活动名 var targetEntities = entities.Goods; if (name.IsNotNullOrEmpty()) { goodsDic = targetEntities.Where(x => x.Name.Contains(name)).ToDictionary(x => x.UNID); var targetIdList = targetEntities.Where(x => x.Name.Contains(name)).Select(x => x.UNID).ToList(); query = query.Where(x => targetIdList.Contains(x.TargetID)); } else { goodsDic = targetEntities.ToDictionary(x => x.UNID); } } else if (recommendCode == (int)RecommendCode.HomeCategory) { //遍历活动名 var targetEntities = entities.Category; if (name.IsNotNullOrEmpty()) { categoryDic = targetEntities.Where(x => x.Name.Contains(name)).ToDictionary(x => x.UNID); var targetIdList = targetEntities.Where(x => x.Name.Contains(name)).Select(x => x.UNID).ToList(); query = query.Where(x => targetIdList.Contains(x.TargetID)); } else { categoryDic = targetEntities.ToDictionary(x => x.UNID); } } } else { return(CreatePageList(new List <RecommendModel>(), 0, 0, 0)); }; var list = new List <RecommendModel>(); var count = query.Count(); query.OrderBy(x => x.Sort).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().ForEach(x => { if (x != null) { RecommendModel model = new RecommendModel(); model.UNID = x.UNID; model.TargetCode = EnumHelper.GetEnumDescription((TargetCode)x.TargetCode); model.RecommendCode = x.RecommendCode; model.CreatedTime = x.CreatedTime; model.Sort = x.Sort; model.Title = x.Title; if (recommendCode == (int)RecommendCode.HomeGoods) { goodsDic.TryGetValue(x.TargetID, out goodsItem); model.TargetName = goodsItem.Name; model.TargetID = goodsItem.UNID; } else if (recommendCode == (int)RecommendCode.HomeCategory) { categoryDic.TryGetValue(x.TargetID, out categoryItem); model.TargetName = categoryItem.Name; model.TargetID = categoryItem.UNID; } list.Add(model); } }); return(CreatePageList(list, pageIndex, pageSize, count)); } }
public RecommendModel GetRecList(int page, int type, DateTime date, int accId) { RecommendModel reModel = new RecommendModel(); StringBuilder strSql = new StringBuilder(); StringBuilder whereSql = new StringBuilder(); int bgNumber = ((page - 1) * 15) + 1; int edNumber = (page) * 15; if (accId != -1) { //店铺Id whereSql.Append(" and (accId=@accId or recommendAccId=@accId)"); } if (type != -1) { switch (type) { case 2: //推荐成功 whereSql.Append(" and T_Recommend_Log.reStatus=1"); break; case 1: //推荐失败 whereSql.Append(" and T_Recommend_Log.reStatus=2"); break; } } if (date != DateTime.MinValue) { whereSql.Append(" and DATEDIFF(day,createTime,@creatDate)=0"); } //只显示被推荐数据 whereSql.Append(" and T_Recommend_Log.type=2"); strSql.Append(" select count(id) as rowCnt from i200.dbo.T_Recommend_Log"); strSql.Append(" where 1=1"); strSql.Append(whereSql.ToString()); reModel.RowCount = DapperHelper.ExecuteScalar <int>(strSql.ToString(), new { accId = accId, creatDate = date }); reModel.maxPage = (reModel.RowCount % 15 == 0) ? reModel.RowCount / 15 : (reModel.RowCount / 15 + 1); strSql.Clear(); strSql.Append(" SELECT * FROM ( "); strSql.Append(" SELECT ROW_NUMBER() OVER (order by i200.dbo.T_Recommend_Log.id desc"); strSql.Append(")AS Row, i200.dbo.T_Recommend_Log.id, createTime, accId, i200.dbo.T_Recommend_Log.type, recommendName, recommendValue, recommendAccId, reStatus, T_A.CompanyName as AccName, T_B.CompanyName as ReAccName from i200.dbo.T_Recommend_Log "); strSql.Append(" left outer join i200.dbo.T_Account T_A on T_A.ID=i200.dbo.T_Recommend_Log.accId"); strSql.Append(" left outer join i200.dbo.T_Account T_B on T_B.ID=i200.dbo.T_Recommend_Log.recommendAccId"); strSql.Append(" where 1=1"); strSql.Append(whereSql.ToString()); strSql.Append(" ) T where T.Row between @bgNumber and @edNumber;"); reModel.Data = DapperHelper.Query <RecommendItem>(strSql.ToString(), new { accId = accId, creatDate = date, bgNumber = bgNumber, edNumber = edNumber }).ToList(); List <int> accIdList = new List <int>(); string accids = "("; foreach (RecommendItem item in reModel.Data) { if (!accIdList.Contains(item.RecommendAccId)) { accIdList.Add(item.RecommendAccId); accids += item.RecommendAccId.ToString() + ","; } } if (accids.Length > 1) { accids = accids.Substring(0, accids.LastIndexOf(',')) + ")"; StringBuilder strEx = new StringBuilder(); strEx.Append( "select count(recommendAccId) cnt,recommendAccId from i200.dbo.T_Recommend_Log where recommendAccId in " + accids + " group by recommendAccId"); List <dynamic> countList = DapperHelper.Query <dynamic>(strEx.ToString()).ToList(); foreach (dynamic item in countList) { //if (reModel.Data.Exists(x => x.RecommendAccId == item.recommendAccId)) //{ List <RecommendItem> list = reModel.Data.FindAll(x => x.RecommendAccId == item.recommendAccId); foreach (RecommendItem findItem in list) { findItem.ReTimes = item.cnt; } //} } } return(reModel); }