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