protected void Page_Load(object sender, EventArgs e)
{
string type = Request["type"];
id = this.Request["id"];
formField = bllTableFieldMap.GetTableFieldMapByWebsite(bllTableFieldMap.WebsiteOwner, "ZCJ_JuActivityInfo", Request["type"], null, "0", null);
typeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, type);
string colName = "JuActivityID,UserLongitude,UserLatitude";
if (formField.Count > 0)
{
colName = colName + "," + ZentCloud.Common.MyStringHelper.ListToStr(formField.Select(p => p.Field).Distinct().ToList(), "", ",");
}
if (id != "0")
{
nInfo = bll.GetColByKey <JuActivityInfo>("JuActivityID", id, colName);
if (nInfo == null)
{
this.Response.Redirect("List.aspx?type=" + type, true);
}
}
nInfoJtoken = JToken.FromObject(nInfo);
List <ArticleCategory> list = bllArticleCategory.GetList <ArticleCategory>(string.Format("WebsiteOwner='{0}' And CategoryType='{1}'", bllArticleCategory.WebsiteOwner, type));
sbCategory.Append(new MySpider.MyCategories().GetSelectOptionHtml(list, "AutoID", "PreID", "CategoryName", cateRootId, "ddlCate", "width:200px", ""));
}
protected void Page_Load(object sender, EventArgs e)
{
nCategoryTypeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, Request["type"]);
MetaTable metaTable = DALEngine.GetMetas().Tables["ZCJ_JuActivityInfo"];
fieldList = metaTable.Columns.Keys.Where(p => !limitForeach.Contains(p)).ToList();
}
protected void Page_Load(object sender, EventArgs e)
{
WebsiteInfo model = bllWeisite.GetWebsiteInfo();
if (model != null && !string.IsNullOrEmpty(model.WeiXinBindDomain))
{
strDomain = model.WeiXinBindDomain;
}
formField = bllTableFieldMap.GetTableFieldMapByWebsite(bllTableFieldMap.WebsiteOwner, "ZCJ_JuActivityInfo", Request["type"], null, "0", null);
typeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, Request["type"]);
}
protected void Page_Load(object sender, EventArgs e)
{
typeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, Request["type"]);
List <TableFieldMapping> formField = bllTableFieldMap.GetTableFieldMapByWebsite(bllTableFieldMap.WebsiteOwner, "ZCJ_JuActivityInfo", Request["type"], null, "0", null);
if (!string.IsNullOrWhiteSpace(typeConfig.Ex1))
{
searchField = formField.Where(p => !string.IsNullOrWhiteSpace(p.Options) && typeConfig.Ex1.Split(',').Contains(p.Field)).ToList();
}
if (!string.IsNullOrWhiteSpace(typeConfig.Ex4))
{
listField = formField.Where(p => typeConfig.Ex4.Split(',').Contains(p.Field)).ToList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string type = Request["type"];
string id = this.Request["id"];
List <TableFieldMapping> fields = bllTableFieldMap.GetTableFieldMapByWebsite(bllTableFieldMap.WebsiteOwner, "ZCJ_JuActivityInfo", type, null, "0", null);
typeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, type);
if (!string.IsNullOrWhiteSpace(typeConfig.Ex5))
{
formField = fields.Where(p => typeConfig.Ex5.Split(',').Contains(p.Field)).ToList();
}
if (typeConfig.TimeSetMethod == 1 || typeConfig.TimeSetMethod == 2)
{
formField.Add(new TableFieldMapping()
{
Field = "UserLongitude"
});
formField.Add(new TableFieldMapping()
{
Field = "UserLatitude"
});
}
if (id != "0")
{
string colName = ZentCloud.Common.MyStringHelper.ListToStr(formField.Select(p => p.Field).Distinct().ToList(), "", ",");
if (!colName.Contains("JuActivityID"))
{
colName = "JuActivityID," + colName;
}
JuActivityInfo nInfo = bll.GetColByKey <JuActivityInfo>("JuActivityID", id, colName);
if (nInfo == null)
{
this.Response.Redirect("List.aspx?type=" + type, true);
}
JToken ttoken = JToken.FromObject(nInfo);
foreach (var item in formField)
{
nInfoJtoken[item.Field] = ttoken[item.Field];
}
}
}
public void ProcessRequest(HttpContext context)
{
JuActivityInfo ninfo = new JuActivityInfo();
ninfo.WebsiteOwner = bll.WebsiteOwner;
ninfo.UserID = currentUserInfo.UserID;
ninfo.ArticleType = context.Request["ArticleType"];
#region 字段检查
ArticleCategoryTypeConfig typeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, ninfo.ArticleType);
if (typeConfig.TimeSetMethod == 1 || typeConfig.TimeSetMethod == 2)
{
ninfo.UserLongitude = context.Request["UserLongitude"];
ninfo.UserLatitude = context.Request["UserLatitude"];
}
List <TableFieldMapping> listFieldList = bllTableFieldMap.GetTableFieldMapByWebsite(bllTableFieldMap.WebsiteOwner, "ZCJ_JuActivityInfo", ninfo.ArticleType, null, "0", null);
List <string> DefFields = new List <string>()
{
"JuActivityID"
};
JObject jtCurUser = JObject.FromObject(ninfo);
List <string> listPropertys = jtCurUser.Properties().Select(p => p.Name).ToList();
foreach (var item in listFieldList.Where(p => !DefFields.Contains(p.Field) && listPropertys.Contains(p.Field)).OrderBy(p => p.Sort))
{
string nValue = context.Request[item.Field];
if (item.FieldIsNull == 1 && string.IsNullOrWhiteSpace(nValue))
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "请完善" + item.MappingName;
bllTableFieldMap.ContextResponse(context, apiResp);
return;
}
if (!string.IsNullOrWhiteSpace(item.FormatValiFunc))
{
#region 检查数据格式
//检查数据格式
if (item.FormatValiFunc == "number")
{
if (!MyRegex.IsNumber(nValue))
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = string.Format("{0}格式不正确", item.MappingName);
bllTableFieldMap.ContextResponse(context, apiResp);
return;
}
}
if (item.FormatValiFunc == "phone")//email检查
{
if (!MyRegex.PhoneNumLogicJudge(nValue))
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = string.Format("{0}格式不正确", item.MappingName);
bllTableFieldMap.ContextResponse(context, apiResp);
return;
}
}
if (item.FormatValiFunc == "email")//email检查
{
if (!MyRegex.EmailLogicJudge(nValue))
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = string.Format("{0}格式不正确", item.MappingName);
bllTableFieldMap.ContextResponse(context, apiResp);
return;
}
}
if (item.FormatValiFunc == "url") //url检查
{
System.Text.RegularExpressions.Regex regUrl = new System.Text.RegularExpressions.Regex(@"http(s)?://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?"); //网址
System.Text.RegularExpressions.Match match = regUrl.Match(nValue);
if (!match.Success)
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = string.Format("{0}格式不正确", item.MappingName);
bllTableFieldMap.ContextResponse(context, apiResp);
return;
}
}
#endregion
}
ninfo = bll.ConvertToModel <JuActivityInfo>(ninfo, item.Field, nValue);
}
#endregion
ninfo.JuActivityID = int.Parse(bll.GetGUID(BLLJIMP.TransacType.AddOutlets));
if (bll.Add(ninfo))
{
apiResp.status = true;
apiResp.msg = "提交成功";
apiResp.code = (int)APIErrCode.IsSuccess;
}
else
{
apiResp.msg = "提交失败";
apiResp.code = (int)APIErrCode.OperateFail;
}
bll.ContextResponse(context, apiResp);
}
protected void Page_Load(object sender, EventArgs e)
{
nCategoryTypeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, Request["type"]);
}
public void ProcessRequest(HttpContext context)
{
Dictionary <string, string> equals = new Dictionary <string, string>();
Dictionary <string, string> contains = new Dictionary <string, string>();
Dictionary <string, string> keywords = new Dictionary <string, string>();
List <string> colFields = new List <string>()
{
"JuActivityID"
};
int rows = Convert.ToInt32(context.Request["rows"]);
int page = Convert.ToInt32(context.Request["page"]);
string type = context.Request["type"];
string onlyLngLatIsNull = context.Request["OnlyLngLatIsNull"];
ArticleCategoryTypeConfig typeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, type);
if (!string.IsNullOrWhiteSpace(typeConfig.ListFields))
{
foreach (var item in typeConfig.ListFields.Split(','))
{
if (!string.IsNullOrWhiteSpace(item) && !string.IsNullOrWhiteSpace(context.Request[item]))
{
equals.Add(item, context.Request[item]);
}
}
}
if (!string.IsNullOrWhiteSpace(typeConfig.EditFields))
{
foreach (var item in typeConfig.EditFields.Split(','))
{
if (!string.IsNullOrWhiteSpace(item) && !string.IsNullOrWhiteSpace(context.Request[item]))
{
contains.Add(item, context.Request[item]);
}
}
}
if (!string.IsNullOrWhiteSpace(typeConfig.NeedFields) && !string.IsNullOrWhiteSpace(context.Request["Keyword"]))
{
string keyword = context.Request["Keyword"];
foreach (var item in typeConfig.NeedFields.Split(','))
{
if (!string.IsNullOrWhiteSpace(item))
{
keywords.Add(item, keyword);
}
}
}
int total = 0;
string colName = typeConfig.Ex3;
if (!colName.Contains("Sort"))
{
colName = "Sort," + colName;
}
if (typeConfig.TimeSetMethod == 1 || typeConfig.TimeSetMethod == 2)
{
if (!colName.Contains("UserLongitude"))
{
colName = "UserLongitude," + colName;
}
if (!colName.Contains("UserLatitude"))
{
colName = "UserLatitude," + colName;
}
}
if (!colName.Contains("JuActivityID"))
{
colName = "JuActivityID," + colName;
}
List <JuActivityInfo> list = bll.GetCommOutletsList(rows, page, bll.WebsiteOwner, type, false, typeConfig.TimeSetMethod, equals, contains, keywords, null, null, null, colName, out total, onlyLngLatIsNull);
apiResp.result = new {
totalcount = total,
list = list
};
apiResp.status = true;
apiResp.msg = "查询完成";
apiResp.code = (int)APIErrCode.IsSuccess;
bll.ContextResponse(context, apiResp);
}
public void ProcessRequest(HttpContext context)
{
Dictionary <string, string> equals = new Dictionary <string, string>();
Dictionary <string, string> contains = new Dictionary <string, string>();
Dictionary <string, string> keywords = new Dictionary <string, string>();
int page = Convert.ToInt32(context.Request["page"]);
int rows = Convert.ToInt32(context.Request["rows"]);
string type = context.Request["type"];
ArticleCategoryTypeConfig typeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, type);
if (!string.IsNullOrWhiteSpace(typeConfig.Ex1))
{
foreach (var item in typeConfig.Ex1.Split(','))
{
if (!string.IsNullOrWhiteSpace(item) && !string.IsNullOrWhiteSpace(context.Request[item]))
{
equals.Add(item, context.Request[item]);
}
}
}
if (!string.IsNullOrWhiteSpace(typeConfig.Ex2) && !string.IsNullOrWhiteSpace(context.Request["keyword"]))
{
string keyword = context.Request["keyword"];
foreach (var item in typeConfig.Ex2.Split(','))
{
if (!string.IsNullOrWhiteSpace(item))
{
keywords.Add(item, keyword);
}
}
}
int total = 0;
string colName = typeConfig.Ex4;
if (!colName.Contains("JuActivityID"))
{
colName = "JuActivityID," + colName;
}
if (!colName.Contains("Sort"))
{
colName = colName + ",Sort";
}
if (typeConfig.TimeSetMethod == 1 || typeConfig.TimeSetMethod == 2)
{
colName = "UserLongitude,UserLatitude," + colName;
}
colName = colName.TrimStart(',').TrimEnd(',');
List <JuActivityInfo> list = bll.GetCommOutletsList(rows, page, bll.WebsiteOwner, type, false, typeConfig.TimeSetMethod, equals, contains, keywords, context.Request["longitude"], context.Request["latitude"], null, colName, out total);
JArray jrList = new JArray();
if (list.Count > 0)
{
if (typeConfig.TimeSetMethod == 1 || typeConfig.TimeSetMethod == 2)
{
colName = colName + ",Distance";
}
JArray jList = JArray.FromObject(list);
List <string> colFieldList = colName.Split(',').ToList();
foreach (JToken item in jList)
{
JToken jr = new JObject();
foreach (var field in colFieldList)
{
jr[field] = item[field];
}
jrList.Add(jr);
}
}
apiResp.result = new
{
totalcount = total,
list = jrList
};
apiResp.status = true;
apiResp.msg = "查询完成";
apiResp.code = (int)APIErrCode.IsSuccess;
bll.ContextResponse(context, apiResp);
}
public void ProcessRequest(HttpContext context)
{
string type = context.Request["type"];
string cate_id = context.Request["cate_id"];
string keyword = context.Request["keyword"];
string sort = context.Request["sort"];
string rows = context.Request["rows"];
string page = context.Request["page"];
int total = 0;
var data = bllMall.GetProductList(keyword, cate_id, null, sort,
page, rows, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, out total, 0, false, type);
bool isAdded = type.Contains("Added");
ArticleCategoryTypeConfig nCategoryTypeConfig = bllArticleCategory.GetArticleCategoryTypeConfig(bllArticleCategory.WebsiteOwner, type);
if (nCategoryTypeConfig == null)
{
nCategoryTypeConfig = new ArticleCategoryTypeConfig();
}
List <dynamic> list = new List <dynamic>();
foreach (var item in data)
{
List <WXMallProductInfo> relList = new List <WXMallProductInfo>();
if (!string.IsNullOrWhiteSpace(item.RelationProductId))
{
string pIDStrings = "'" + item.RelationProductId.Replace(",", "','") + "'";
relList = bllMall.GetColMultListByKey <WXMallProductInfo>(int.MaxValue, 1, "PID", pIDStrings, "PID,PName,Price,Unit");
}
List <ProductSku> skuList = bllMall.GetColList <ProductSku>(int.MaxValue, 1, string.Format("ProductId={0}", item.PID), "SkuId,ProductId,PropValueIdEx1,PropValueIdEx2,PropValueIdEx3,Price");
list.Add(new
{
product_id = item.PID,
category_name = bllMall.GetArticleCategoryName(item.CategoryId),
title = item.PName,
summary = item.Summary,
access_level = item.AccessLevel,
count = item.Stock,
price = item.Price,
img = item.RecommendImg,
imgs = item.ShowImage,
unit = item.Unit,
relation_products = from p in relList
select new {
product_id = p.PID,
title = p.PName,
price = p.Price,
unit = p.Unit,
sku_id = bllMall.GetProductSkuId(p.PID)
},
sku_list = from p in skuList.Where(p => checkEx(isAdded, nCategoryTypeConfig.TimeSetMethod, p)).OrderBy(p => p.PropValueIdEx1)
select new
{
sku_id = p.SkuId,
product_id = p.ProductId,
price = p.Price,
ex1 = p.PropValueIdEx1,
ex2 = p.PropValueIdEx2,
ex3 = p.PropValueIdEx3
},
sku_id = skuList.Count == 0? 0: skuList[0].SkuId
});
}
apiResp.result = new
{
totalcount = total,
list = list
};
apiResp.status = true;
apiResp.code = (int)APIErrCode.IsSuccess;
bllMall.ContextResponse(context, apiResp);
}
