private void SaveInfo()
{
DdkAppsModel model = null;
if (this.CurrentId > 0)
{
model = DdkAppsBLL.Instance.GetModel(this.CurrentId);
}
else
{
model = new DdkAppsModel();
}
model.ClientId = txtClientId.Value.Trim();
model.ClientSecret = txtClientSecret.Value.Trim();
model.Status = Convert.ToInt32(ddlStatus.SelectedValue);
model.IsMain = Convert.ToInt32(ddlIsMain.SelectedValue);
model.BindAgentId = Convert.ToInt32(hidBindAgentId.Value);
if (this.CurrentId > 0)
{
DdkAppsBLL.Instance.Update(model);
MessageBoxHelper.ResponseScript(this.Page, "updateSuccessCallback();");
}
else
{
DdkAppsBLL.Instance.Add(model);
MessageBoxHelper.ResponseScript(this.Page, "addSuccessCallback();");
}
}
private void LoadDetail()
{
if (this.CurrentId > 0)
{
DdkAppsModel model = DdkAppsBLL.Instance.GetModel(this.CurrentId);
if (model != null)
{
txtClientId.Value = model.ClientId;
txtClientSecret.Value = model.ClientSecret;
hidBindAgentId.Value = model.BindAgentId.HasValue ? model.BindAgentId.ToString() : "0";
ddlStatus.SelectedValue = model.Status.ToString();
ddlIsMain.SelectedValue = model.IsMain.ToString();
}
}
}
/// <summary>
/// 从拼多多同步主题数据到数据库中
/// </summary>
/// <returns></returns>
public bool Sync(out string errMsg)
{
errMsg = "";
DdkAppsModel appInfo = DdkAppProvider.Instance.GetModelByDefault();
if (appInfo == null)
{
errMsg = "未能找到多多客应用配置信息";
return(false);
}
try
{
int pageSize = 50;
int page = 1;
int curPageItemNums = pageSize;
List <DdkThemeModel> listResult = new List <DdkThemeModel>();
while (curPageItemNums >= pageSize)
{
ThemeListJsonResult themeListJsonResult = DdkApi.GetThemeList(appInfo.ClientId, appInfo.ClientSecret, page, pageSize);
List <ThemeListItemEntity> themeList = themeListJsonResult.theme_list_get_response.theme_list;
curPageItemNums = themeList.Count;
foreach (ThemeListItemEntity entity in themeList)
{
listResult.Add(new DdkThemeModel()
{
GoodsNum = entity.goods_num,
ImageUrl = entity.image_url,
Name = entity.name,
ThemeId = (int)entity.id,
UpdateTime = DateTime.Now
});
}
page++;
}
dal.TruncateTable();
foreach (DdkThemeModel model in listResult)
{
this.Add(model);
}
return(true);
}
catch (Exception ex)
{
LogHelper.Write("DdkThemeBLL.Sync发生异常：" + ex.Message);
return(false);
}
}
public HotGoodsModel GetGoodsDetail(long goodsId, out string errMsg)
{
errMsg = "";
try
{
DdkAppsModel appInfo = DdkAppProvider.Instance.GetModelByDefault();
GoodsDetailJsonResult goodsDetailJsonResult = DdkApi.GetGoodsDetail(appInfo.ClientId, appInfo.ClientSecret, goodsId);
List <GoodsDetailItemEntity> goodsList = goodsDetailJsonResult.goods_detail_response.goods_details;
if (goodsList.Count > 0)
{
return(this.ConvertGoods(goodsList[0]));
}
return(null);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DdkAppsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HQ_Ddk_Apps set ");
strSql.Append("AgentId=@AgentId,");
strSql.Append("ClientId=@ClientId,");
strSql.Append("ClientSecret=@ClientSecret,");
strSql.Append("IsMain=@IsMain,");
strSql.Append("Status=@Status,");
strSql.Append("BindAgentId=@BindAgentId");
strSql.Append(" where AppId=@AppId");
SqlParameter[] parameters =
{
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@ClientId", SqlDbType.VarChar, 50),
new SqlParameter("@ClientSecret", SqlDbType.VarChar, 50),
new SqlParameter("@IsMain", SqlDbType.TinyInt, 1),
new SqlParameter("@Status", SqlDbType.TinyInt, 1),
new SqlParameter("@BindAgentId", SqlDbType.Int, 4),
new SqlParameter("@AppId", SqlDbType.Int, 4)
};
parameters[0].Value = model.AgentId;
parameters[1].Value = model.ClientId;
parameters[2].Value = model.ClientSecret;
parameters[3].Value = model.IsMain;
parameters[4].Value = model.Status;
parameters[5].Value = model.BindAgentId;
parameters[6].Value = model.AppId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DdkAppsModel DataRowToModel(DataRow row)
{
DdkAppsModel model = new DdkAppsModel();
if (row != null)
{
if (row["AppId"] != null && row["AppId"].ToString() != "")
{
model.AppId = int.Parse(row["AppId"].ToString());
}
if (row["AgentId"] != null && row["AgentId"].ToString() != "")
{
model.AgentId = int.Parse(row["AgentId"].ToString());
}
if (row["ClientId"] != null)
{
model.ClientId = row["ClientId"].ToString();
}
if (row["ClientSecret"] != null)
{
model.ClientSecret = row["ClientSecret"].ToString();
}
if (row["IsMain"] != null && row["IsMain"].ToString() != "")
{
model.IsMain = int.Parse(row["IsMain"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["BindAgentId"] != null && row["BindAgentId"].ToString() != "")
{
model.BindAgentId = int.Parse(row["BindAgentId"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DdkAppsModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HQ_Ddk_Apps(");
strSql.Append("AgentId,ClientId,ClientSecret,IsMain,Status,BindAgentId)");
strSql.Append(" values (");
strSql.Append("@AgentId,@ClientId,@ClientSecret,@IsMain,@Status,@BindAgentId)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AgentId", SqlDbType.Int, 4),
new SqlParameter("@ClientId", SqlDbType.VarChar, 50),
new SqlParameter("@ClientSecret", SqlDbType.VarChar, 50),
new SqlParameter("@IsMain", SqlDbType.TinyInt, 1),
new SqlParameter("@Status", SqlDbType.TinyInt, 1),
new SqlParameter("@BindAgentId", SqlDbType.Int, 4)
};
parameters[0].Value = model.AgentId;
parameters[1].Value = model.ClientId;
parameters[2].Value = model.ClientSecret;
parameters[3].Value = model.IsMain;
parameters[4].Value = model.Status;
parameters[5].Value = model.BindAgentId;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DdkAppsModel GetModel(int AppId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from HQ_Ddk_Apps ");
strSql.Append(" where AppId=@AppId");
SqlParameter[] parameters =
{
new SqlParameter("@AppId", SqlDbType.Int, 4)
};
parameters[0].Value = AppId;
DdkAppsModel model = new DdkAppsModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public HotPageData <List <HotGoodsModel> > GetGoodsList(HotGoodsSearchCondition condition, out string errMsg)
{
errMsg = "";
try
{
//排序转换
GoodsSortTypeOptions goodsSortType = GoodsSortTypeOptions.综合排序;
switch (condition.SortField)
{
case HotGoodsSortFieldOptions.默认:
goodsSortType = GoodsSortTypeOptions.综合排序;
break;
case HotGoodsSortFieldOptions.价格:
goodsSortType = condition.SortType == HotGoodsSortTypeOptions.ASC ? GoodsSortTypeOptions.价格升序 : GoodsSortTypeOptions.价格降序;
break;
case HotGoodsSortFieldOptions.优惠券金额:
goodsSortType = condition.SortType == HotGoodsSortTypeOptions.ASC ? GoodsSortTypeOptions.优惠券金额排序升序 : GoodsSortTypeOptions.优惠券金额排序降序;
break;
case HotGoodsSortFieldOptions.佣金比例:
goodsSortType = condition.SortType == HotGoodsSortTypeOptions.ASC ? GoodsSortTypeOptions.佣金比率升序 : GoodsSortTypeOptions.佣金比例降序;
break;
case HotGoodsSortFieldOptions.佣金金额:
goodsSortType = condition.SortType == HotGoodsSortTypeOptions.ASC ? GoodsSortTypeOptions.佣金金额升序排序 : GoodsSortTypeOptions.佣金金额降序排序;
break;
case HotGoodsSortFieldOptions.券后价:
goodsSortType = condition.SortType == HotGoodsSortTypeOptions.ASC ? GoodsSortTypeOptions.券后价升序排序 : GoodsSortTypeOptions.券后价降序排序;
break;
case HotGoodsSortFieldOptions.加入时间:
goodsSortType = condition.SortType == HotGoodsSortTypeOptions.ASC ? GoodsSortTypeOptions.照加入多多进宝时间升序 : GoodsSortTypeOptions.照加入多多进宝时间降序;
break;
case HotGoodsSortFieldOptions.销量:
goodsSortType = condition.SortType == HotGoodsSortTypeOptions.ASC ? GoodsSortTypeOptions.销量升序 : GoodsSortTypeOptions.销量降序;
break;
}
//接口数据拉取
DdkAppsModel appInfo = DdkAppProvider.Instance.GetModelByDefault();
GoodsSearchListJsonResult goodsSearchListJsonResult = DdkApi.GetGoodsList(appInfo.ClientId, appInfo.ClientSecret, new GoodsSearchConditionEntity()
{
cat_id = condition.CatId,
goods_id_list = condition.GoodsIdList,
keyword = condition.Keyword,
opt_id = condition.OptId,
page = condition.Page,
page_size = condition.PageSize,
range_list = null,
with_coupon = condition.WithCoupon,
sort_type = goodsSortType
});
//数据加工
GoodsSearchListEntity searchListEntity = goodsSearchListJsonResult.goods_search_response;
HotPageData <List <HotGoodsModel> > pageData = HotPageDataHelper <List <HotGoodsModel>, List <GoodsDetailItemEntity> > .Convert(
searchListEntity.goods_list,
searchListEntity.total_count,
condition.PageSize,
condition.Page,
dt =>
{
List <HotGoodsModel> list = new List <HotGoodsModel>();
foreach (GoodsDetailItemEntity item in dt)
{
list.Add(this.ConvertGoods(item));
}
return(list);
});
return(pageData);
}
catch (Exception ex)
{
errMsg = ex.Message;
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DdkAppsModel model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DdkAppsModel model)
{
return(dal.Add(model));
}
