public ActionResult List(PagerCondition condition)
{
if (condition == null)
{
condition = new PagerCondition()
{
PageSize = 10,
PageIndex = 1
};
}
Swoopo.Model.JsonResult json = new Swoopo.Model.JsonResult();
try
{
List<ProductEntity> list = new ProductBLL().getPaged(condition);
json.value = list;
}
catch (BllException e)
{
#if DEBUG
json.error = e.InnerException.Message;
#else
json.error = e.Message;
#endif
}
catch (DalException ex)
{
#if DEBUG
json.error = ex.InnerException.Message;
#else
json.error = ex.Message;
#endif
}
return Json(json);
}
public dynamic GetSearchProductList()
{
string name = Fun.Query("name");
ProductBLL bll = new ProductBLL();
List <P_ProductInfo> list = bll.GetSearchProductList(name);
List <ProductInfo> pList = new List <ProductInfo>();
ProductInfo p = null;
foreach (var item in list)
{
p = new ProductInfo();
p.id = item.product_id;
p.name = item.product_name.Trim();
p.state = item.product_state;
pList.Add(p);
}
return(pList);
}
/// <summary>
/// 逐个编辑
/// </summary>
protected void SingleEdit()
{
int productID = RequestHelper.GetQueryString <int>("ProductID");
ProductInfo product = ProductBLL.Read(productID);
product.ProductNumber = RequestHelper.GetQueryString <string>("ProductNumber");
product.Weight = RequestHelper.GetQueryString <int>("Weight");
product.MarketPrice = RequestHelper.GetQueryString <decimal>("MarketPrice");
product.SalePrice = RequestHelper.GetQueryString <decimal>("SalePrice");
product.SendPoint = RequestHelper.GetQueryString <int>("SendPoint");
product.TotalStorageCount = RequestHelper.GetQueryString <int>("TotalStorageCount");
product.LowerCount = RequestHelper.GetQueryString <int>("LowerCount");
product.UpperCount = RequestHelper.GetQueryString <int>("UpperCount");
ProductBLL.Update(product);
ResponseHelper.Write(ShopLanguage.ReadLanguage("UpdateOK"));
ResponseHelper.End();
}
private void GetLastWork()
{
ProductBLL pcBll = new ProductBLL();
DataTable dtb = DBHelper.ExcuteFromCmd("SELECT * FROM dbo.fc_GetAllChildProductCategory(" + DBConvert.ParseInt(categoryIdByPass) + ",1)", null);
string[] array = dtb.AsEnumerable()
.Select(row => row.Field <Int32>("id").ToString())
.ToArray();
string idFirst = string.Join(",", array);
IList <PNK_Product> lst = pcBll.GetList(LangInt, string.Empty, "1", idFirst, string.Empty, string.Empty, "1", 1, 8, out total);
if (total > 0)
{
ltrLastWork.Text = lst[0].CategoryNameDesc;
rptResult.DataSource = lst.OrderByDescending(m => m.PostDate);
rptResult.DataBind();
}
}
public dynamic GetNormalProductList()
{
ProductBLL bll = new ProductBLL();
List <P_ProductInfo> list = bll.GetNormalProductList();
List <ProductInfo> pList = new List <ProductInfo>();
ProductInfo p = null;
foreach (var item in list)
{
p = new ProductInfo();
p.id = item.product_id;
p.name = item.product_name.Trim();
p.img = item.product_img;
p.info = item.product_info;
pList.Add(p);
}
return(pList);
}
protected bool isPL = true;//是否已评论
protected override void PageLoad()
{
base.PageLoad();
int orderId = RequestHelper.GetQueryString <int>("id");
userGradeName = UserGradeBLL.Read(base.GradeID).Name;
order = OrderBLL.Read(orderId, base.UserId);
if (order.Id <= 0)
{
ScriptHelper.AlertFront("订单不存在", "/Mobile/index.html");
}
orderDetailList = OrderDetailBLL.ReadList(orderId);
int[] productIds = orderDetailList.Select(k => k.ProductId).ToArray();
if (productIds.Length > 0)
{
int count = 0;
productList = ProductBLL.SearchList(1, productIds.Length, new ProductSearchInfo {
InProductId = string.Join(",", productIds)
}, ref count);
}
#region 判断是否已评论
List <ProductCommentInfo>[] listPinfoArr = new List <ProductCommentInfo> [productList.Count];
int pi = 0;
foreach (ProductInfo item in productList)
{
ProductCommentSearchInfo psi = new ProductCommentSearchInfo();
psi.ProductId = item.Id;
psi.UserId = base.UserId;
listPinfoArr[pi] = ProductCommentBLL.SearchProductCommentList(psi);
if (listPinfoArr[pi].Count <= 0)
{
isPL = false;
}
}
#endregion
Title = "我的订单";
}
public bool UpdateProduuct(ProductBLL pro)
{
bool success = false;
SqlConnection con = new SqlConnection(myConnection);
try
{
string sql = "UPDATE tbl_products SET name=@name,category=@category,description=@description,rate=@rate,added_date=@added_date,added_by=@added_by WHERE Id=@Id";
//Sql Command to pass Values to The sql Query
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@name", pro.name);
cmd.Parameters.AddWithValue("@category", pro.category);
cmd.Parameters.AddWithValue("@description", pro.description);
cmd.Parameters.AddWithValue("@rate", pro.rate);
cmd.Parameters.AddWithValue("@qty", pro.qty);
cmd.Parameters.AddWithValue("@added_date", pro.added_date);
cmd.Parameters.AddWithValue("@added_by", pro.added_by);
cmd.Parameters.AddWithValue("@Id", pro.Id);
//Open Connectiion0
con.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
success = true;
}
else
{
success = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(success);
}
protected override void PageLoad()
{
base.PageLoad();
int id = RequestHelper.GetQueryString <int>("id");
product = ProductBLL.Read(id);
if (product.IsSale == (int)BoolType.False)
{
ScriptHelper.AlertFront("该产品未上市，不能查看");
}
//如果为移动端单独设置了内容，则取移动端内容
if (!string.IsNullOrEmpty(product.Introduction1_Mobile))
{
product.Introduction1 = product.Introduction1_Mobile;
}
if (!string.IsNullOrEmpty(product.Introduction2_Mobile))
{
product.Introduction2 = product.Introduction2_Mobile;
}
if (!string.IsNullOrEmpty(product.Introduction3_Mobile))
{
product.Introduction3 = product.Introduction3_Mobile;
}
//更新查看数量
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("ViewCount", product.ViewCount + 1);
ProductBLL.UpdatePart(ProductInfo.TABLENAME, dict, id);
if (product.BrandId > 0)
{
productBrand = ProductBrandBLL.Read(product.BrandId);
}
productPhotoList = ProductPhotoBLL.ReadList(id, 0);
attributeRecords = ProductTypeAttributeRecordBLL.ReadList(id);
standardRecords = ProductTypeStandardRecordBLL.ReadList(id);
//搜索优化
Title = product.Name;
Keywords = string.IsNullOrEmpty(product.Keywords) ? product.Name : product.Keywords;
Description = string.IsNullOrEmpty(product.Summary) ? StringHelper.Substring(StringHelper.KillHTML(product.Introduction1), 200) : product.Summary;
}
public HttpResponseMessage Post()
{
try
{
System.Threading.Tasks.Task <string> content = Request.Content.ReadAsStringAsync();
Object jobj = new object();
jobj = JObject.Parse(content.Result);
JToken product_id = JObject.Parse(jobj.ToString()).SelectToken("product_id");
JToken artist = JObject.Parse(jobj.ToString()).SelectToken("artist");
JToken year = JObject.Parse(jobj.ToString()).SelectToken("year");
JToken album = JObject.Parse(jobj.ToString()).SelectToken("album");
JToken price = JObject.Parse(jobj.ToString()).SelectToken("price");
JToken store = JObject.Parse(jobj.ToString()).SelectToken("store");
JToken thumb = JObject.Parse(jobj.ToString()).SelectToken("thumb");
JToken date = JObject.Parse(jobj.ToString()).SelectToken("date");
Product product = new Product();
product.product_id = product_id.ToString();
product.artist = artist.ToString();
product.year = Convert.ToInt32(year);
product.album = album.ToString();
product.price = Convert.ToInt32(price);
product.store = store.ToString();
product.thumb = thumb.ToString();
product.date = date.ToString();
ProductBLL bll = new ProductBLL();
if (bll.Inserir(product))
{
return(Request.CreateResponse(HttpStatusCode.OK, new { message = "Produto inserido com sucesso!" }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, new { message = "Produto já existe!" }));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, new { message = ex.Message.ToString() }));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
int queryString = RequestHelper.GetQueryString <int>("ID");
if (queryString != -2147483648)
{
base.CheckAdminPower("ReadGiftPack", PowerCheckType.Single);
this.strGiftPackID = queryString.ToString();
GiftPackInfo info = GiftPackBLL.ReadGiftPack(queryString);
this.Name.Text = info.Name;
this.Photo.Text = info.Photo;
this.StartDate.Text = info.StartDate.ToString("yyyy-MM-dd");
this.EndDate.Text = info.EndDate.ToString("yyyy-MM-dd");
this.Price.Text = info.Price.ToString();
if (info.GiftGroup != string.Empty)
{
string str = string.Empty;
int length = info.GiftGroup.Split(new char[] { '#' }).Length;
this.nameArray = new string[length];
this.countArray = new string[length];
this.productArray = new string[length];
for (int i = 0; i < length; i++)
{
string[] strArray = info.GiftGroup.Split(new char[] { '#' })[i].Split(new char[] { '|' });
this.nameArray[i] = strArray[0];
this.countArray[i] = strArray[1];
this.productArray[i] = strArray[2];
if (strArray[2] != string.Empty)
{
str = str + strArray[2] + ",";
}
}
if (str != string.Empty)
{
str = str.Substring(0, str.Length - 1);
ProductSearchInfo productSearch = new ProductSearchInfo();
productSearch.InProductID = str;
this.productList = ProductBLL.SearchProductList(productSearch);
}
}
}
}
}
public dynamic GetProduct()
{
int id = Fun.Query("id", 0);
ProductBLL bll = new ProductBLL();
P_ProductInfo p = bll.GetProduct(id);
List <P_Cubilose> list = null;
ProductInfo product = new ProductInfo();
product.id = p.product_id;
if (!string.IsNullOrEmpty(p.product_component))
{
list = new CubiloseBLL().GetCubiloseList();
string[] arr = p.product_component.Split(',');
string[] arr2 = p.component_num.Split('|');
for (int i = 0; i < arr.Length; i++)
{
product.component += "<span data-id = '" + arr[i] + "'>" + list.Where(x => x.cubilose_id == int.Parse(arr[i])).FirstOrDefault().cubilose_name.Trim() + "(" + arr2[i] + ")</span>,";
}
product.component = product.component.Substring(0, product.component.Length - 1);
}
product.componentId = p.product_component;
product.num = p.component_num;
product.name = p.product_name.Trim();
product.img = p.product_img;
product.info = p.product_info;
product.type = p.product_type;
product.mode = p.product_mode.Trim();
product.price = p.product_price;
switch (p.product_type)
{
case 1:
product.typeDescript = "月卡";
break;
case 2:
product.typeDescript = "礼盒";
break;
case 3:
product.typeDescript = "干货";
break;
}
return(product);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckAdminPower("ReadUser", PowerCheckType.Single);
string action = RequestHelper.GetQueryString <string>("Action");
int id = RequestHelper.GetQueryString <int>("Id");
if (id > 0)
{
switch (action)
{
case "Delete":
CheckAdminPower("DeleteUser", PowerCheckType.Single);
if (ProductBLL.CountByShop(id) > 0)
{
ScriptHelper.Alert("该供应商存在相关产品，不能删除。");
}
else
{
UserBLL.Delete(id);
AdminLogBLL.Add(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("User"), id);
}
break;
default:
break;
}
}
UserSearchInfo userSearch = new UserSearchInfo();
userSearch.UserName = RequestHelper.GetQueryString <string>("UserName");
userSearch.ProviderNo = RequestHelper.GetQueryString <string>("ProviderNo");
UserName.Text = userSearch.UserName;
ProviderNo.Text = userSearch.ProviderNo;
var userList = UserBLL.SearchList(new UserSearchInfo {
UserName = userSearch.UserName, ProviderNo = userSearch.ProviderNo, UserType = (int)UserType.Provider
});
Count = userList.Count;
userList = userList.Skip((CurrentPage - 1) * PageSize).Take(PageSize).ToList();
BindControl(userList, RecordList, MyPager);
}
}
private void btnAddUpdate_Click(object sender, EventArgs e)
{
DataRow itemDataRow = this.productTable.NewRow();
itemDataRow[0] = this.txtItemName.Text;
itemDataRow[1] = this.txtCode.Text;
itemDataRow[2] = ((MultiPurposeTagVM)cmbCategory.SelectedItem).Name;
itemDataRow[3] = this.productId;
itemDataRow[4] = cmbCategory.SelectedValue;
using (ProductBLL productBll = new ProductBLL())
{
ProductVM product = new ProductVM()
{
Id = this.productId,
Name = this.txtItemName.Text,
Code = this.txtCode.Text,
mpt_CategoryEnum = Convert.ToInt32(cmbCategory.SelectedValue),
mpt_StatusEnum = 1
};
int response = productBll.ManageProduct(product);
if (response > 0)
{
itemDataRow[3] = response;
if (!isProductUpdate)
{
this.productTable.Rows.Add(itemDataRow);
}
else
{
this.productGridView.Rows.Remove(this.updatedRow);
this.productTable.Rows.Add(itemDataRow);
}
this.getProducts();
this.ProductFormInputReset();
}
else
{
MessageBox.Show("Item Insert Error");
}
}
this.btnAddUpdate.Text = "Add";
this.isProductUpdate = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.IsPostBack)
{
this.BindClassBrandAttributeClassStandardType();
this.ProductClass.DataSource = ProductClassBLL.ReadProductClassUnlimitClass();
this.productID = RequestHelper.GetQueryString <int>("ID");
if (this.productID != -2147483648)
{
base.CheckAdminPower("ReadProduct", PowerCheckType.Single);
ProductInfo product = ProductBLL.ReadProduct(this.productID);
this.Name.Text = product.Name;
this.Name.Attributes.Add("style", "color:" + product.Color);
this.color = product.Color;
this.FontStyle.Text = product.FontStyle;
this.ProductNumber.Text = product.ProductNumber;
this.ProductClass.ClassIDList = product.ClassID;
this.Keywords.Text = product.Keywords;
this.BrandID.Text = product.BrandID.ToString();
this.MarketPrice.Text = product.MarketPrice.ToString();
this.SendPoint.Text = product.SendPoint.ToString();
this.Photo.Text = product.Photo;
this.Summary.Text = product.Summary;
this.Introduction.Value = product.Introduction;
this.Weight.Text = product.Weight.ToString();
this.IsSpecial.Text = product.IsSpecial.ToString();
this.IsNew.Text = product.IsNew.ToString();
this.IsHot.Text = product.IsHot.ToString();
this.IsSale.Text = product.IsSale.ToString();
this.IsTop.Text = product.IsTop.ToString();
this.Remark.Text = product.Remark;
this.AllowComment.Text = product.AllowComment.ToString();
this.TotalStorageCount.Text = product.TotalStorageCount.ToString();
this.LowerCount.Text = product.LowerCount.ToString();
this.UpperCount.Text = product.UpperCount.ToString();
this.AttributeClassID.Text = product.AttributeClassID.ToString();
this.StandardType.Text = product.StandardType.ToString();
this.sendCount = product.SendCount;
this.BindRelation(product);
this.productPhotoList = ProductPhotoBLL.ReadProductPhotoByProduct(this.productID);
}
this.userGradeList = UserGradeBLL.JoinUserGrade(this.productID);
}
}
/// <summary>
/// 页面加载方法
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override void PageLoad()
{
base.PageLoad();
int id = RequestHelper.GetQueryString <int>("ID");
groupBuy = GroupBuyBLL.ReadGroupBuy(id);
TimeSpan timeSpan = groupBuy.EndDate - RequestHelper.DateNow;
leftTime = timeSpan.Days * 24 * 3600 + timeSpan.Hours * 3600 + timeSpan.Minutes * 60 + timeSpan.Seconds;
buyCount = UserGroupBuyBLL.ReadUserGroupBuyCount(id);
product = ProductBLL.ReadProduct(groupBuy.ProductID);
Title = product.Name + " - 商品团购";
int count = 0;
GroupBuySearchInfo groupBuySearch = new GroupBuySearchInfo();
groupBuySearch.Status = GroupBuyStatus.Normal;
groupBuyList = GroupBuyBLL.ReadGroupBuyList(1, 8, groupBuySearch, ref count);
string productIDList = string.Empty;
string idList = string.Empty;
foreach (GroupBuyInfo groupBuyInfo in groupBuyList)
{
if (productIDList == string.Empty)
{
productIDList = groupBuyInfo.ProductID.ToString();
idList = groupBuyInfo.ID.ToString();
}
else
{
productIDList += "," + groupBuyInfo.ProductID.ToString();
idList += "," + groupBuyInfo.ID.ToString();
}
}
//读取商品
if (productIDList != string.Empty)
{
ProductSearchInfo productSearch = new ProductSearchInfo();
productSearch.InProductID = productIDList;
productList = ProductBLL.SearchProductList(productSearch);
}
}
private void Like()
{
string result = string.Empty;
int id = RequestHelper.GetQueryString <int>("id");
string type = RequestHelper.GetQueryString <string>("type");
if (id < 1)
{
ResponseHelper.Write("error|请选择产品");
ResponseHelper.End();
}
if (base.UserId == 0)
{
ResponseHelper.Write("error|还未登录");
ResponseHelper.End();
}
string hasLike = CookiesHelper.ReadCookieValue("like");
if (!string.IsNullOrEmpty(hasLike))
{
ResponseHelper.Write("error|您已经参与过了");
ResponseHelper.End();
}
var entity = ProductBLL.Read(id);
Dictionary <string, object> dict = new Dictionary <string, object>();
if (type == "like")
{
dict.Add("LikeNum", entity.LikeNum + 1);
}
if (type == "unlike")
{
dict.Add("UnLikeNum", entity.UnLikeNum + 1);
}
ProductBLL.UpdatePart(ProductInfo.TABLENAME, dict, id);
int num = type == "like" ? entity.LikeNum + 1 : entity.UnLikeNum + 1;
CookiesHelper.AddCookie("like", "hasLike", 1, TimeType.Day);
ResponseHelper.Write("ok|" + num);
ResponseHelper.End();
}
public List <ProductDataContract> GetAllProducts()
{
ProductBLL productBLL = new ProductBLL();
List <Product> products = productBLL.GetAllProducts();
List <ProductDataContract> svcProducts = new List <ProductDataContract>();
foreach (Product product in products)
{
ProductDataContract productDataContract = new ProductDataContract();
productDataContract.ProductID = product.ProductID;
productDataContract.ProductName = product.ProductName;
productDataContract.UnitPrice = product.UnitPrice;
productDataContract.Discontinued = product.Discontinued;
productDataContract.UnitsInstock = product.UnitsInstock;
svcProducts.Add(productDataContract);
}
return(svcProducts);
}
protected void Btn_SaveChanges_Click(object sender, EventArgs e)
{
//var list = (List<Product>)Session["ProductList"];
//list[Convert.ToInt32(Session["ProductToModifyIndex"])].Brand = Txb_brand.Text;
//list[Convert.ToInt32(Session["ProductToModifyIndex"])].Name = Txb_name.Text;
//list[Convert.ToInt32(Session["ProductToModifyIndex"])].Price = Convert.ToDouble(Txb_price.Text.Replace(",", "."));
//list[Convert.ToInt32(Session["ProductToModifyIndex"])].IsEnabled = Rdb_enabled.Checked;
//list[Convert.ToInt32(Session["ProductToModifyIndex"])].MinQuantity = Convert.ToInt32(Txb_min_quantity.Text);
//list[Convert.ToInt32(Session["ProductToModifyIndex"])].MaxQuantity = Convert.ToInt32(Txb_max_quantity.Text);
var productBLL = new ProductBLL();
productBLL.UpdateProduct(Session["SkuToModify"].ToString(), Txb_name.Text, Convert.ToDouble(Txb_price.Text), Rdb_enabled.Checked, Convert.ToInt32(Txb_min_quantity.Text), Convert.ToInt32(Txb_max_quantity.Text));
//Session["ProductList"] = list;
Response.Redirect("MainPage.aspx");
}
protected void typeone_ddl_SelectedIndexChanged(object sender, EventArgs e)
{
this.LoadTypeTwo();
ProductBLL pb = new ProductBLL();
if (!string.IsNullOrWhiteSpace(typeone_ddl.SelectedValue))
{
List <ProductTypeModel> list = new List <ProductTypeModel>();
pb.GetProductSecondLevelInfo(Convert.ToInt32(typeone_ddl.SelectedValue), out list);
foreach (ProductTypeModel model in list)
{
ListItem item = new ListItem();
item.Value = model.S_ProductTypeId.ToString();
item.Text = model.S_ProductTypeName;
typetwo_ddl.Items.Add(item);
}
}
}
public ActionResult Index()
{
int total;
MediaBLL mediaBLL = new MediaBLL();
IDictionary <int, MediaObj> flash = new Dictionary <int, MediaObj>();
flash.Add(15, mediaBLL.GetMedia(15));
flash.Add(16, mediaBLL.GetMedia(16));
flash.Add(17, mediaBLL.GetMedia(17));
flash.Add(18, mediaBLL.GetMedia(18));
flash.Add(19, mediaBLL.GetMedia(19));
flash.Add(20, mediaBLL.GetMedia(20));
flash.Add(21, mediaBLL.GetMedia(21));
flash.Add(22, mediaBLL.GetMedia(22));
flash.Add(23, mediaBLL.GetMedia(23));
flash.Add(24, mediaBLL.GetMedia(24));
flash.Add(25, mediaBLL.GetMedia(25));
flash.Add(26, mediaBLL.GetMedia(26));
flash.Add(27, mediaBLL.GetMedia(27));
flash.Add(28, mediaBLL.GetMedia(28));
flash.Add(29, mediaBLL.GetMedia(29));
flash.Add(30, mediaBLL.GetMedia(30));
flash.Add(31, mediaBLL.GetMedia(31));
ViewBag.flash = flash;
ProductBLL productBLL = new ProductBLL();
JsonArray cates = productBLL.GetProductCatesByParentID(0);
ViewBag.cates = cates;
ViewBag.cate1 = WriteProducts(productBLL.GetProducts((int)cates[0]["categoryID"], null, 0, 0, -1, -1, -1, -1, 1, 3, out total));
ViewBag.cate2 = WriteProducts(productBLL.GetProducts((int)cates[1]["categoryID"], null, 0, 0, -1, -1, -1, -1, 1, 2, out total));
ViewBag.cate3 = WriteProducts(productBLL.GetProducts((int)cates[2]["categoryID"], null, 0, 0, -1, -1, -1, -1, 1, 6, out total));
ViewBag.cate4 = WriteProducts(productBLL.GetProducts((int)cates[3]["categoryID"], null, 0, 0, -1, -1, -1, -1, 1, 6, out total));
ViewBag.cate5 = WriteProducts(productBLL.GetProducts((int)cates[4]["categoryID"], null, 0, 0, -1, -1, -1, -1, 1, 6, out total));
ViewBag.cate6 = WriteProducts(productBLL.GetProducts((int)cates[5]["categoryID"], null, 0, 0, -1, -1, -1, -1, 1, 6, out total));
ViewBag.cate7 = WriteProducts(productBLL.GetProducts((int)cates[6]["categoryID"], null, 0, 0, -1, -1, -1, -1, 1, 6, out total));
ViewBag.onSaleProducts = WriteProducts(productBLL.GetProducts(0, null, 0, 0, -1, 1, -1, -1, 1, 4, out total));
ViewBag.newProducts = WriteProducts(productBLL.GetProducts(0, null, 0, 0, 1, -1, -1, -1, 1, 3, out total));
return(View());
}
public ActionResult DeleteModel()
{
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 4))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
Validation vld = new Validation();
int modelId = vld.GetInt("modelId");
ProductBLL productBLL = new ProductBLL();
productBLL.DeleteModel(modelId);
return(Json(new { success = true }));
}
private void setProductInfo()
{
string code = Request["Code"];
if (!String.IsNullOrWhiteSpace(code))
{
List <ProductModel> olist = new List <ProductModel>();
int Count = 0;
ProductBLL pb = new ProductBLL();
pb.GetProductInfoList(1, 1, null, null, code, null, null, null, null, null, null, out Count, out olist);
if (olist.Count > 0)
{
typeone_ddl.SelectedValue = olist[0].FactoryTypeId.ToString();
code_txt.Text = olist[0].ProductCode;
memo_txt.Text = olist[0].ProductDes;
mi_ddl.SelectedValue = olist[0].Length.ToString();
}
}
}
public ActionResult Index()
{
SupplierBLL objSupplierBLL = new SupplierBLL();
List <Supplier> SupplierList = objSupplierBLL.GetAllSupplier();
ViewBag.supplierList = SupplierList;
ProductBLL objProductBll = new ProductBLL();
List <Product> ProductList = objProductBll.GetAllProduct();
ViewBag.productList = ProductList;
CustomerDetailBLL objCustomerBLL = new CustomerDetailBLL();
ViewBag.customerList = objCustomerBLL.GetAllCustomerInfo();
CountryBLL objCountryBLL = new CountryBLL();
ViewBag.countryList = objCountryBLL.GetAllCountry();
return(View());
}
public ActionResult UserExchange(int id)
{
UserObj user = AppData.SessionUser;
if (user == null)
{
return(Redirect("/Login.html"));
}
ExchangeBLL exchangeBLL = new ExchangeBLL();
var exchangeInfo = exchangeBLL.GetExchangeByID(id);
if (exchangeInfo == null)
{
return(Redirect("/Error/2.html"));
}
OrderBLL orderBLL = new OrderBLL();
ProductBLL productBLL = new ProductBLL();
AreaBLL areaBLL = new AreaBLL();
OrderObj orderObj = orderBLL.GetOrderByID(exchangeInfo.OrderID);
if (orderObj == null || user.UserID != orderObj.UserID)
{
return(Redirect("/Error/2.html"));
}
ViewBag.returnProduct = productBLL.GetProduct(exchangeInfo.ReturnProductID);
if (exchangeInfo.ExchangeProductID != 0)
{
ViewBag.exchangeProduct = productBLL.GetProduct(exchangeInfo.ExchangeProductID);
}
ViewBag.exchangeInfo = exchangeInfo;
ViewBag.order = orderObj;
ViewBag.area = areaBLL.GetAreaByRetionID(exchangeInfo.RegionID);
return(View());
}
// GET: Master/Product/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
ViewBag.CompCode = await base.CurrentUserComp();
try
{
if (_cache.TryGetValue("CACHE_MASTER_PRODUCT", out List <M_Product> c_lstProd))
{
var m_Product = c_lstProd.Find(p => p.Id == id);
if (m_Product == null)
{
return(NotFound());
}
return(PartialView(m_Product));
}
using (var prodBll = new ProductBLL())
{
var lstProd = await prodBll.GetProduct(id);
var m_Product = lstProd.First();
if (m_Product == null)
{
return(NotFound());
}
return(PartialView(m_Product));
}
}
catch (Exception ex)
{
return(BadRequest(new { success = false, message = ex.Message }));
}
}
protected override void PageLoad()
{
base.PageLoad();
if (RequestHelper.GetQueryString <string>("Action") == "Delete")
{
ProductCollectBLL.DeleteProductCollect(RequestHelper.GetQueryString <string>("ID"), base.UserID);
ResponseHelper.Write("ok");
ResponseHelper.End();
}
int queryString = RequestHelper.GetQueryString <int>("Page");
if (queryString < 1)
{
queryString = 1;
}
int pageSize = 20;
int count = 0;
this.productCollectList = ProductCollectBLL.ReadProductCollectList(queryString, pageSize, ref count, base.UserID);
this.commonPagerClass.CurrentPage = queryString;
this.commonPagerClass.PageSize = pageSize;
this.commonPagerClass.Count = count;
string str3 = string.Empty;
foreach (ProductCollectInfo info in this.productCollectList)
{
if (str3 == string.Empty)
{
str3 = info.ProductID.ToString();
}
else
{
str3 = str3 + "," + info.ProductID.ToString();
}
}
if (str3 != string.Empty)
{
ProductSearchInfo productSearch = new ProductSearchInfo();
productSearch.InProductID = str3;
this.productList = ProductBLL.SearchProductList(productSearch);
}
}
public void LoadDIN()
{
Donation e = DonationBLL.Get(DIN);
Clear();
if (e != null)
{
lblName.Text = e.People.Name;
imgDIN.ImageUrl = BarcodeBLL.Url4DIN(e.DIN, "00");
lblDINDate.Text = e.CollectedDate.ToStringVN();
if (e.Pack != null)
{
imgProduct.ImageUrl = BarcodeBLL.Url4Product(e.Pack.ProductCode);
lblProductDesc.Text = ProductBLL.GetDesc(e.Pack.ProductCode);
btnRemovePack.Visible = e.CanRemoveOriginalPack;
lblDate.Text = e.Pack.Date.ToStringVN_Hour();
txtVolume.Text = e.Pack.Volume.ToString();
if (!string.IsNullOrEmpty(e.BloodGroup))
{
ImageBloodGroup.ImageUrl = BarcodeBLL.Url4BloodGroup(e.BloodGroup);
lblBloodGroup.Text = BloodGroupBLL.GetDescription(e.BloodGroup);
}
}
else
{
btnRemovePack.Visible = false;
}
txtCollector.Text = e.Collector;
txtNote.Text = e.Note;
//btnSave.Enabled = DonationBLL.CanUpdateTestResult(e);
}
}
public ProductBLL GetProduuctIDFromName(string Name)
{
// first Create an Object of SellerCustomerBll and Return it
ProductBLL productbll = new ProductBLL();
//Static Method to Connect Database
SqlConnection con = new SqlConnection(myConnection);
//Static Method to Connect Database
//TO Hold data From Database
DataTable dtable = new DataTable();
try
{
//SQL Query to get id based on Name
string sql = "Select Id FROM tbl_products WHERE name='" + Name + "'";
//Create the SqlDataAdapter to Excute the query
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
con.Open();
//Passing the value from the adapter to the database
adapter.Fill(dtable);
// if the Query is Excuted then the value of the rows will be greater thean zero
if (dtable.Rows.Count > 0)
{
productbll.Id = int.Parse(dtable.Rows[0]["Id"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
return(productbll);
}
public ActionResult ModiftProductStatus(int id)
{
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 404))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
ProductBLL productBLL = new ProductBLL();
ProductObj productObj = productBLL.GetProduct(id);
int status = productObj.Status == 1 ? 0 : 1;
productBLL.ModifyProduct(id, status);
return(Json(new { success = true }));
}
/// <summary>
/// Get count
/// </summary>
private void GetService()
{
ProductBLL pcBll = new ProductBLL();
DataTable dtb = DBHelper.ExcuteFromCmd("SELECT * FROM dbo.fc_GetAllChildProductCategory(" + ConfigurationManager.AppSettings["parentIdService"] + ",1)", null);
if (dtb != null && dtb.Rows.Count > 0)
{
string[] array = dtb.AsEnumerable()
.Select(row => row.Field <Int32>("id").ToString())
.ToArray();
string idFirst = string.Join(",", array);
IList <PNK_Product> lst = pcBll.GetList(LangInt, string.Empty, "1", idFirst, string.Empty, string.Empty, "1", 1, 4, out total);
if (lst.Count > 0)
{
this.rptService.DataSource = lst;
this.rptService.DataBind();
}
}
}
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
RedBloodDataContext db = new RedBloodDataContext();
e.Result = db.Donations.Where(r => r.CampaignID == CampaignDetail1.CampaignID).OrderBy(r => r.DIN).ToList()
.Select(r => new
{
r.DIN,
Name = r.People.Name,
CollectedDate = r.CollectedDate.ToStringVN_Hour(),
ProductDescription = r.Pack != null ? ProductBLL.GetDesc(r.Pack.ProductCode) : "",
r.BloodGroupDesc,
Markers_HIV = r.Markers.HIV,
Markers_HCV_Ab = r.Markers.HCV_Ab,
Markers_HBs_Ag = r.Markers.HBs_Ag,
Markers_Malaria = r.Markers.Malaria,
Markers_Syphilis = r.Markers.Syphilis,
})
;
}
public ActionResult Save(ProductEntity product)
{
Swoopo.Model.JsonResult s = new Swoopo.Model.JsonResult();
try
{
product.RemainTime = product.EndTime.ToFileTime() - product.StarTime.ToFileTime();
ProductBLL proBll = new ProductBLL();
int result = proBll.Save(product);
if (result > 0)
{
s.value = 1;
}
else
{
s.error = "保存失败！";
}
}
catch (BllException e)
{
#if DEBUG
s.error = e.InnerException.StackTrace;
#else
s.error = e.Message;
#endif
}
catch (DalException ex)
{
#if DEBUG
s.error = ex.InnerException.StackTrace;
#else
s.error = ex.Message;
#endif
}
return Json(s);
}
public void ProductGetTest()
{
SettingUp();
var _P = new ProductBLL().Get(_SiteID,0, _CustomerUser.Id);
Assert.IsNotNull(_P);
}
private void SaveProduct(Product mobjProduct)
{
try
{
BLL.Component.ProductBLL objProd = new ProductBLL();
if (mobjProduct.ProductID == 0)
{
int mintReturn = objProd.AddProduct(mobjProduct);
if (mintReturn == -1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Product for the Manufacturer already exists!');", true);
return;
}
}
else
{
mobjProduct.UpdatedBy = 1;
int mintReturn = objProd.EditProduct(mobjProduct);
if (mintReturn == -1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Product for the Manufacturer already exists!');", true);
return;
}
}
Response.Redirect("Product.aspx");
}
catch (Exception ex)
{
SendMail.MailMessage("CSWeb > Error > " + (new System.Diagnostics.StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
private void PopulateData()
{
int intProductID =0;
int.TryParse(Productid.Value, out intProductID);
if (intProductID > 0)
{
bool blnIsProductAdded = false;
if (Session["PurchasedProduct"] != null)
gobjProduct = (List<PurchasedProduct>)Session["PurchasedProduct"];
for (int i = 0; i < gobjProduct.Count; i++)
{
if (gobjProduct[i].ProductID == intProductID)
{
blnIsProductAdded = true;
break;
}
}
if (!blnIsProductAdded)
{
Product objProduct = new ProductBLL().GetProductByID(intProductID);
htnProductID.Value = intProductID.ToString();
lblProduct.Text = objProduct.ProductName;
lblBarCode.Text = objProduct.BarCode;
txtBuyingPrice.Text = objProduct.BuyingPrice.ToString();
txtTax.Text = objProduct.Tax.ToString();
txtMargin.Text = objProduct.Margin.ToString();
txtSellingPrice.Text = objProduct.SellingPrice.ToString();
List<Size> lstSize = new SizeBLL().GetSize(0);
string[] arrSizeIDs = objProduct.SizeID.Split(',');
List<Size> lstSizeIDs = new List<Size>();
System.Web.UI.HtmlControls.HtmlGenericControl containerDiv;
System.Web.UI.HtmlControls.HtmlGenericControl textBoxDiv;
System.Web.UI.HtmlControls.HtmlGenericControl mainDiv;
int pos = 1;
for (int i = 0; i < arrSizeIDs.Length; i++)
{
for (int j = 0; j < lstSize.Count; j++)
{
if (arrSizeIDs[i] == lstSize[j].SizeID.ToString())
{
mainDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("div");
switch (pos)
{
case 1:
mainDiv.Attributes.Add("style", "float:left");
break;
case 2:
mainDiv.Attributes.Add("style", "float:left; padding-left:30px");
break;
case 3:
mainDiv.Attributes.Add("style", "float:right");
break;
}
pos++;
pos = pos > 3 ? 1 : pos;
containerDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("div");
containerDiv.Controls.Add(CreateLabel(lstSize[j].SizeID, lstSize[j].SizeName));
mainDiv.Controls.Add(containerDiv);
textBoxDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("div");
textBoxDiv.Controls.Add(CreateTextBox(lstSize[j].SizeID, 0));
mainDiv.Controls.Add(textBoxDiv);
plhQty.Controls.Add(mainDiv);
lstSizeIDs.Add(lstSize[j]);
break;
}
}
}
Session["ProductSizeIDs"] = lstSizeIDs;
lblError.InnerHtml = "";
ScriptManager.RegisterStartupScript(this, this.GetType(), "AddEditPurchase", "ShowModalDiv('ModalWindow1','dvInnerWindow',0);", true);
}
else
{
lblError.InnerHtml = "Product already added";
}
}
else
{
lblError.InnerHtml = "Invalid entry";
}
}
public void ProductGetByIDTest()
{
SettingUp();
var _P = new ProductBLL().GetByID(_Product.ProductID, _CustomerUser.Id);
Assert.IsNotNull(_P);
}
public void ProductUpdateTest()
{
SettingUp();
//CATEGORIES
var _PC = new List<ProductCategoryBinding>();
_PC.Add(new ProductCategoryBinding
{
CategoryID = _Category.CategoryID,
Deleting = true
});
//CURRENCIES
_ProductCurrencies[0].Price = 5000;
_ProductCurrencies[1].Price = 2;
//Updating
_Product.ProductAlias = "00 Updated";
new ProductBLL().Save(_Product, _CustomerUser.Id);
var _P = new ProductBLL().Get(_SiteID, _CustomerUser.Id);
Assert.IsNotNull(_P);
Assert.IsTrue(_P[0].ProductAlias == _Product.ProductAlias);
Assert.IsTrue(_P[0].ProductCategories.Count == 1);
Assert.IsTrue(_P[0].ProductCurrencies[0].Price == _ProductCurrencies[0].Price);
Assert.IsTrue(_P[0].ProductCurrencies[1].Price == _ProductCurrencies[1].Price);
}
protected void gvGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int intProductID = Convert.ToInt32(gvGrid.DataKeys[e.RowIndex].Values[0].ToString());
bool blnReturn = new ProductBLL().DeleteProduct(intProductID);
BindProduct();
}
private void PopulateProductByID(int ProductID)
{
try
{
BLL.Component.ProductBLL objProd = new ProductBLL();
BLL.BusinessObject.Product objProduct = objProd.GetProductByID(ProductID);
txtProductName.Text = objProduct.ProductName;
}
catch (Exception ex)
{
SendMail.MailMessage("CSWeb > Error > " + (new System.Diagnostics.StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
public void ProductSaveTest()
{
SettingUp();
var _P = new ProductBLL().Get(_SiteID, _CustomerUser.Id);
Assert.IsNotNull(_P);
Assert.IsTrue(_P[0].ProductCategories.Count == 1);
Assert.IsTrue(_P[0].ProductCurrencies.Count == 2);
}
public ActionResult Index()
{
var bll = new ProductBLL();
var models = bll.GetProductList();
return View(models);
}
public void ProductGetByQuery()
{
SettingUp();
var _P = new ProductBLL().GetByQuery(_SiteID, _Cultures[0].Name, _ProductCurrencies[0].CurrencyID,"lazos",50,1);
Assert.IsNotNull(_P);
Assert.IsTrue(_P.Count>0);
}
public void ProductSaveIconTest()
{
SettingUp();
var _FileName = "logo.png";
var _FileContent = "64base," + System.Convert.ToBase64String(System.IO.File.ReadAllBytes(_FileName));
_Product.ProductID = 0;
_Product.ProductCultures[0].IconFile = new FileRead
{
FileContent = _FileContent,
FileName = _FileName
};
_Product.ProductCultures[0].ProductName = _Product.ProductCultures[0].ProductName + DateTime.Now.ToShortTimeString();
_Product.ProductCultures[1].ProductName = _Product.ProductCultures[1].ProductName + DateTime.Now.ToShortTimeString();
_Product.ProductCultures[0].FriendlyUrl = null;
_Product.ProductCultures[1].FriendlyUrl = null;
var _PID = new ProductBLL().Save(_Product, _CustomerUser.Id);
var _P = new ProductBLL().GetByID(_PID, _CustomerUser.Id);
var _PathExpected = BaseBLL.StorageUrl + "/product-icon/" + _PID + "/" + _P.ProductCultures[0].CultureID + "/" + _FileName;
Assert.IsTrue(_P.ProductCultures[0].IconPath == _PathExpected);
}
public void ProductGetWebTest()
{
SettingUp();
var _Pr = new ProductBLL().Get(_SiteID,0, _CustomerUser.Id);
var _P = new ProductBLL().Get(_SiteID, null, null, _ProductCurrencies[0].CurrencyID, _Category.CategoryCultures[0].FriendlyUrl, 1);
Assert.IsNotNull(_P);
}
public void ProductSaveEmptyFriendlyURLTest()
{
SettingUp();
var _P = new ProductBLL().Get(_SiteID, _CustomerUser.Id);
Assert.IsNotNull(_P);
Assert.IsNotNull(_P[0].ProductCultures[0].FriendlyUrl);
}
private void LoadData(int intProductID)
{
try
{
Product objProduct = new ProductBLL().GetProductByID(intProductID);
ViewState["intProductID"] = intProductID;
if (null != objProduct)
{
txtProductName.Text = objProduct.ProductName;
txtDescription.Text = objProduct.Description;
//cmbManufacturer.SelectedValue = objProduct.ManufacturerID.ToString();
cmbCategory.SelectedValue = objProduct.CategoryID.ToString();
cmbBrand.SelectedValue = objProduct.BrandID.ToString();
ddlSeason.SelectedValue = objProduct.SeasonID.ToString();
string[] strVals = objProduct.SizeID.Split(',');
for (int i = 0; i < strVals.Length; i++)
{
for (int j = 0; j < chkSize.Items.Count; j++)
{
if (chkSize.Items[j].Value == strVals[i])
{
chkSize.Items[j].Selected = true;
break;
}
}
}
txtBuyingPrice.Text = String.Format("{0:0.00}",objProduct.BuyingPrice);
txtTax.Text = String.Format("{0:0.00}",objProduct.Tax);
txtMargin.Text = String.Format("{0:0.00}",objProduct.Margin);
txtSellingPrice.Text = String.Format("{0:0.00}",objProduct.SellingPrice);
txtBarcode.Text = objProduct.BarCode;
// ScriptManager.RegisterStartupScript(this, this.GetType(), "AddEditProduct", "ShowModalDiv('ModalWindow1','dvInnerWindow',0);", true);
}
}
catch (Exception ex)
{
SendMail.MailMessage("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
