public ActionResult CreateCard(int pkId = 0, int supplierId = 1) { WeixinCardModel cardmodelInfo = new WeixinCardModel(); WeixinCardTotalModel totalModel = new WeixinCardTotalModel(); if (pkId == 0) { SupplierInfo supplier = new SupplierInfo(); TimeSpan ts = DateTime.Now - new DateTime(1970, 1, 1); TimeSpan ts1 = DateTime.Now.AddDays(30) - new DateTime(1970, 1, 1); List <SupplierInfo> supplierInfoList = WeiXinCardManager.GetSupplierInfo(supplierId); if (supplierInfoList != null && supplierInfoList.FirstOrDefault() != null) { supplier = supplierInfoList.First(); } totalModel = new WeixinCardTotalModel() { base_info = new WeixinCardBaseInfo() { logo_url = supplier.logo_url, brand_name = supplier.brand_name, colorid = 2, date_info = new DateInfo() { begin_time = DateTime.Now, end_time = DateTime.Now.AddDays(10), begin_timestamp = (UInt64)ts.Seconds, end_timestamp = (UInt64)ts.Seconds, // (DateTime.Now.AddDays(30) - new DateTime(1970, 1, 1) type = "DATE_TYPE_FIX_TERM" // end_timestamp =Convert.ToUInt32(ts.TotalSeconds), }, sku = new SKUQuantity() { quantity = 0 }, // center_title = "途虎养车网", // center_url = "https://www.tuhu.cn", service_phone = "4001118868" }, advanced_info = new WeixinCardAdvancedInfo() { abstractinfo = new AbstractInfo(), use_condition = new ConditionalUse() } }; cardmodelInfo.total_info = totalModel; } else { WeixinCardModel model = null; var list = WeiXinCardManager.GetWeixinCardModelList(pkId); if (list != null && list.FirstOrDefault() != null) { model = list.First(); } cardmodelInfo = model; } return(View(cardmodelInfo)); }
public static List <WeixinCardModel> GetWeixinCardModelList(int pkid = -1) { List <WeixinCardModel> list = new List <WeixinCardModel>(); var dt = DALWeiXinCard.GetWeiXinCardList(pkid); try { if (dt != null && dt.Rows != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { var dateinfo = new DateInfo() { begin_time = Convert.IsDBNull(row["begin_time"]) ? new DateTime(1970, 1, 1) : Convert.ToDateTime(row["begin_time"]), end_time = Convert.IsDBNull(row["end_time"]) ? new DateTime(1970, 1, 1) : Convert.ToDateTime(row["end_time"]), begin_timestamp = Convert.IsDBNull(row["begin_timestamp"]) ? null : (ulong?)Convert.ToUInt64(row["begin_timestamp"]), end_timestamp = Convert.IsDBNull(row["end_timestamp"]) ? null : (ulong?)Convert.ToUInt64(row["end_timestamp"]), fixed_begin_term = Convert.IsDBNull(row["fixed_begin_term"]) ? null : (Int32?)Convert.ToInt32(row["fixed_begin_term"]), fixed_term = Convert.IsDBNull(row["fixed_term"]) ? null : (Int32?)Convert.ToInt32(row["fixed_term"]), // type=(TimeType)Enum.Parse(typeof(TimeType),row["type"].ToString()) type = Convert.IsDBNull(row["type"]) ? null : row["type"].ToString() }; var skuobj = new SKUQuantity() { quantity = Convert.IsDBNull(row["quantity"]) ? null : (Int32?)Convert.ToInt32(row["quantity"]) }; var baseinfo = new WeixinCardBaseInfo() { title = Convert.IsDBNull(row["title"]) ? null : row["title"].ToString(), colorid = Convert.IsDBNull(row["color"]) ? 1 : Colors.Where(q => q.ColorValue == row["color"].ToString()).FirstOrDefault() != null?Colors.Where(q => q.ColorValue == row["color"].ToString()).First().ColorIndex : 2, notice = Convert.IsDBNull(row["notice"]) ? null : row["notice"].ToString(), description = Convert.IsDBNull(row["description"]) ? null : row["description"].ToString(), supplierId = Convert.IsDBNull(row["supplierId"]) ? 1 : (Int32?)Convert.ToInt32(row["supplierId"]), center_title = Convert.IsDBNull(row["center_title"]) ? null : row["center_title"].ToString(), center_sub_title = Convert.IsDBNull(row["center_sub_title"]) ? null : row["center_sub_title"].ToString(), center_url = Convert.IsDBNull(row["center_url"]) ? null : row["center_url"].ToString(), custom_url = Convert.IsDBNull(row["custom_url"]) ? null : row["custom_url"].ToString(), custom_url_name = Convert.IsDBNull(row["custom_url_name"]) ? null : row["custom_url_name"].ToString(), custom_url_sub_title = Convert.IsDBNull(row["custom_url_sub_title"]) ? null : row["custom_url_sub_title"].ToString(), promotion_url = Convert.IsDBNull(row["promotion_url"]) ? null : row["promotion_url"].ToString(), promotion_url_name = Convert.IsDBNull(row["promotion_url_name"]) ? null : row["promotion_url_name"].ToString(), promotion_url_sub_title = Convert.IsDBNull(row["promotion_url_sub_title"]) ? null : row["promotion_url_sub_title"].ToString(), service_phone = Convert.IsDBNull(row["service_phone"]) ? null : row["service_phone"].ToString(), get_limit = Convert.IsDBNull(row["get_limit"]) ? null : (Int32?)Convert.ToInt32(row["get_limit"]), use_limit = Convert.IsDBNull(row["use_limit"]) ? null : (Int32?)Convert.ToInt32(row["use_limit"]), can_share = Convert.IsDBNull(row["can_share"]) ? false : Convert.ToBoolean(row["can_share"]), can_give_friend = Convert.IsDBNull(row["can_give_friend"]) ? false : Convert.ToBoolean(row["can_give_friend"]), use_all_locations = Convert.IsDBNull(row["use_all_locations"]) ? false : Convert.ToBoolean(row["use_all_locations"]), // location_id_list= row["location_id_list"].ToString(), source = Convert.IsDBNull(row["source"]) ? null : row["source"].ToString(), use_custom_code = Convert.IsDBNull(row["use_custom_code"]) ? false : Convert.ToBoolean(row["use_custom_code"]), get_custom_code_mode = Convert.IsDBNull(row["get_custom_code_mode"]) ? null : row["get_custom_code_mode"].ToString(), bind_openid = Convert.IsDBNull(row["bind_openid"]) ? false : Convert.ToBoolean(row["bind_openid"]), sku = skuobj, date_info = dateinfo }; var usecondition = new ConditionalUse() { accept_category = Convert.IsDBNull(row["accept_category"]) ? null : row["accept_category"].ToString(), reject_category = Convert.IsDBNull(row["reject_category"]) ? null : row["accept_category"].ToString(), least_cost = Convert.IsDBNull(row["use_condition_least_cost"]) ? null : (Int32?)Convert.ToInt32(row["use_condition_least_cost"]), object_use_for = Convert.IsDBNull(row["object_use_for"]) ? null : row["object_use_for"].ToString(), can_use_with_other_discount = Convert.IsDBNull(row["can_use_with_other_discount"]) ? false : Convert.ToBoolean(row["can_use_with_other_discount"]) }; var icon_url_list = Convert.IsDBNull(row["icon_url_list"]) ? string.Empty : row["icon_url_list"].ToString(); List <string> icons = icon_url_list.Split(new char[] { ';' }).Where(q => q != null).ToList(); var imagetextstr = Convert.IsDBNull(row["text_image_list"]) ? string.Empty : row["text_image_list"].ToString(); List <ImageText> imageTextList = JsonConvert.DeserializeObject <List <ImageText> >(imagetextstr); var abstractinfo = new AbstractInfo(); abstractinfo.abstractstr = Convert.IsDBNull(row["abstract"]) ? null : row["abstract"].ToString(); if (icons != null && icons.Any()) { icons = icons.Where(q => !string.IsNullOrWhiteSpace(q)).ToList(); if (icons.Count() == 5) { abstractinfo.icon1 = icons[0]; abstractinfo.icon2 = icons[1]; abstractinfo.icon3 = icons[2]; abstractinfo.icon4 = icons[3]; abstractinfo.icon5 = icons[4]; } else if (icons.Count() == 4) { abstractinfo.icon1 = icons[0]; abstractinfo.icon2 = icons[1]; abstractinfo.icon3 = icons[2]; abstractinfo.icon4 = icons[3]; } else if (icons.Count() == 3) { abstractinfo.icon1 = icons[0]; abstractinfo.icon2 = icons[1]; abstractinfo.icon3 = icons[2]; } else if (icons.Count() == 2) { abstractinfo.icon1 = icons[0]; abstractinfo.icon2 = icons[1]; } else if (icons.Count() == 1) { abstractinfo.icon1 = icons[0]; } } if (imageTextList != null && imageTextList.Any()) { imageTextList = imageTextList.Where(q => q != null).ToList(); if (imageTextList.Count() == 5) { abstractinfo.imageText1 = imageTextList[0]; abstractinfo.imageText2 = imageTextList[1]; abstractinfo.imageText3 = imageTextList[2]; abstractinfo.imageText4 = imageTextList[3]; abstractinfo.imageText5 = imageTextList[4]; } else if (imageTextList.Count() == 4) { abstractinfo.imageText1 = imageTextList[0]; abstractinfo.imageText2 = imageTextList[1]; abstractinfo.imageText3 = imageTextList[2]; abstractinfo.imageText4 = imageTextList[3]; } else if (imageTextList.Count() == 3) { abstractinfo.imageText1 = imageTextList[0]; abstractinfo.imageText2 = imageTextList[1]; abstractinfo.imageText3 = imageTextList[2]; } else if (imageTextList.Count() == 2) { abstractinfo.imageText1 = imageTextList[0]; abstractinfo.imageText2 = imageTextList[1]; } else if (imageTextList.Count() == 1) { abstractinfo.imageText1 = imageTextList[0]; } } var advancedinfo = new WeixinCardAdvancedInfo() { abstractinfo = abstractinfo, use_condition = usecondition }; var totalinfo = new WeixinCardTotalModel() { deal_detail = Convert.IsDBNull(row["deal_detail"]) ? null : row["deal_detail"].ToString(), least_cost = Convert.IsDBNull(row["least_cost"]) ? null : (Int32?)Convert.ToInt32(row["least_cost"]), reduce_cost = Convert.IsDBNull(row["reduce_cost"]) ? null : (Int32?)Convert.ToInt32(row["reduce_cost"]), discount = Convert.IsDBNull(row["discount"]) ? null : (Int32?)Convert.ToInt32(row["discount"]), gift = Convert.IsDBNull(row["gift"]) ? null : row["gift"].ToString(), default_detail = Convert.IsDBNull(row["default_detail"]) ? null : row["default_detail"].ToString(), base_info = baseinfo, advanced_info = advancedinfo }; var model = new WeixinCardModel() { total_info = totalinfo, card_id = Convert.IsDBNull(row["card_id"]) ? null : row["card_id"].ToString(), PKID = Convert.IsDBNull(row["PKID"]) ? null : (Int32?)Convert.ToInt32(row["PKID"]), PushedCount = Convert.IsDBNull(row["PushedCount"]) ? null : (Int32?)Convert.ToInt32(row["PushedCount"]), card_type = (CardTypeEnum)Enum.Parse(typeof(CardTypeEnum), row["card_type"].ToString()) }; list.Add(model); } } } catch (Exception ex) { } return(list); }