protected void updateButton_Click(object sender, EventArgs e) { string strName = TypeName_edit.Text.ToString(); string strState = State_edit.Text.ToString(); string strDesc = Description_edit.Text.ToString(); ProductsType pb = new ProductsType(); pb.TypeName = strName; pb.Description = strDesc; pb.State = strState; pb.TypeID = int.Parse(TypeID.Text.ToString()); if (Leyp.SQLServerDAL.Factory.getProductsTypeDAL().updateProductsType(pb)) { addSystemLog("更新商品类型:" + strName); HyperLink1.Visible = true; editPanel.Visible = false; viewPanel.Visible = false; } else { HyperLink1.Text = "添加失败!可能是名称重复了!你可以返回重新试试"; HyperLink1.Visible = true; editPanel.Visible = false; viewPanel.Visible = false; } }
public void SetDiscount(ProductsType productType, double discountProcent) { if (discountProcent > 0 && discountProcent < 100) { listOfTypeProductsDiscount.Add(productType, discountProcent); } }
public async Task <bool> EditProdyctTypeAsync(ProductsType productsType, string oldHEXColor, int olpParentProductTypeId) { bool result; if (olpParentProductTypeId == 1 && productsType.ParentProductTypeId != 1) { result = await _fcdStoreContext.EditParentProductTypeToNoParent(productsType); } else { if (olpParentProductTypeId != 1 && (productsType.ParentProductTypeId == 1 || productsType.ParentProductTypeId == 2)) { result = await _fcdStoreContext.EditProductTypeToParentProductType(productsType); } else { result = await _fcdStoreContext.EditProductType(productsType); } } if (result) { _builderBackColorCSS.RefreshCSS(oldHEXColor, productsType.HexColor); _cacheService.Remove("ProductType"); _cacheService.Remove("Product"); return(true); } return(false); }
protected void Button1_Click(object sender, EventArgs e) { if (this.TextBox1.Text != null) { ProductsType s = new ProductsType(); s.TypeName = this.TextBox1.Text; s.Description = this.TextBox2.Text; //s.State = this.DropDownList2.Text; if (this.DropDownList1.Text == "正常") { s.State = "Y"; } else { s.State = "N"; } int rows = ProductsTypeManager.ProductsTypeInsert(s); if (rows > 0) { Response.Write("<script>alert('添加成功!');</script>"); this.TextBox1.Text = ""; this.TextBox2.Text = ""; this.DropDownList1.Text = "正常"; } else { Response.Write("<script>alert('添加失败!');</script>"); } } else { Response.Write("<script>alert('类型名称不能为空!');</script>"); } }
protected void submit_Click(object sender, EventArgs e) { string strName = TypeName_New.Text.ToString(); string strState = State_new.Text.ToString(); string strDesc = Description_new.Text.ToString(); ProductsType pb = new ProductsType(); pb.TypeName = strName; pb.Description = strDesc; pb.State = strState; if (Leyp.SQLServerDAL.Factory.getProductsTypeDAL().insertNewProductsType(pb)) { addSystemLog("新添商品类型:" + strName); HyperLink1.Visible = true; viewPanel.Visible = false; } else { HyperLink1.Text = "添加失败!可能是名称重复了!你可以返回重新试试"; HyperLink1.Visible = true; viewPanel.Visible = false; } }
/// <summary> /// 初始化 /// </summary> public void DataBand() { string action = Request.QueryString["action"]; if (action == null) { CollectionPager1.DataSource = Leyp.SQLServerDAL.Factory.getProductsTypeDAL().getAllProductsType();//BLL项目中List数据源 CollectionPager1.BindToControl = GridView1; GridView1.DataSource = CollectionPager1.DataSourcePaged; editPanel.Visible = false; } else if (action.Equals("edit")) { int typeID = 0; try { typeID = int.Parse(Request.QueryString["TypeID"].ToString()); } catch { Response.Write("参数有误"); Response.End(); } ProductsType pb = new ProductsType(); pb = Leyp.SQLServerDAL.Factory.getProductsTypeDAL().getByTypeID(typeID); TypeName_edit.Text = pb.TypeName; TypeID.Text = pb.TypeID.ToString();//保存编辑ID Description_edit.Text = pb.Description; State_edit.Items.FindByValue(pb.State.ToString()).Selected = true; editPanel.Visible = true; viewPanel.Visible = false; } else if (action.Equals("del")) { int typeID = 0; try { typeID = int.Parse(Request.QueryString["TypeID"].ToString()); } catch { Response.Write("参数有误"); Response.End(); } if (Leyp.SQLServerDAL.Factory.getProductsTypeDAL().deleteByTypeID(typeID)) { Response.Write("删除成功!"); Response.End(); } else { Response.Write("失败!可能该类型已经在使用中"); Response.End(); } } }
public DiscountProduct(string productName, ProductsType productType, double coast, double discountProcent = 0) : base(productName, productType, coast) { if (discountProcent > 0 && discountProcent < 100) { Discount = 1.0 - discountProcent / 100.0; this.Cost *= Discount; } }
public static int ProductsTypeUpdate(ProductsType s) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("update t_ProductsType set TypeName='{0}' , Description='{1}' , State='{2}' where TypeID='{3}'", s.TypeName, s.Description, s.State, s.TypeID); int rows = db.ExecuteNonQuery(CommandType.Text, sql); return(rows); }
public static int ProductsTypeInsert(ProductsType s) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("insert into t_ProductsType values('{0}','{1}','{2}')", s.TypeName, s.State, s.Description); int rows = db.ExecuteNonQuery(CommandType.Text, sql); return(rows); }
public static string GetAtawControlUnitsProductValue(string fControlUnitID, ProductsType databaseType, string key) { string productName = databaseType.ToString(); var database = AtawAppContext.Current.DBConfigXml.Databases.Where(a => a.IsDefault).FirstOrDefault(); AtawDebug.AssertArgumentNull(database, "默认的数据库配置不能为空", AtawAppContext.Current); string strDefaultConnstring = database.ConnectionString; if (fControlUnitID.IsEmpty()) { return(strDefaultConnstring); } var xml = AtawAppContext.Current.ProductsXml.ControlUnits; var cList = xml.Where(a => a.FControlUnitID == fControlUnitID); //IList<ControlUnitItemInfo> m = q.AsQueryable<ControlUnitItemInfo>().ToList(); if (cList.Count() == 0) { return(strDefaultConnstring); } string va = ""; foreach (var item in cList) { if (!string.IsNullOrEmpty(va)) { break; } foreach (var item2 in item.Products) { if (item2.Name == productName && item2.Key == key) { va = item2.Value; if (key == "DB") { va = GetAtawDatabaseValue(va); //返回数据库的字符串 } break; } } } if (!string.IsNullOrEmpty(va)) { return(va); } else { return(strDefaultConnstring); } //} //catch (Exception) //{ // return strDefaultConnstring; //} }
public bool insertNewProductsType(ProductsType pt) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TypeName", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.NChar), new SqlParameter("@Description", SqlDbType.NVarChar) }; parameters[0].Value = pt.TypeName; parameters[1].Value = pt.State; parameters[2].Value = pt.Description; SQLHelper.RunProcedure("p_ProductsType_InsertNew", parameters, out rowsAffected); return(1 == rowsAffected); }
public async Task <IActionResult> DeleteProductsTypes(ProductsType productsType) { if (await _dataProcessingConveyor.DeleteProductTypeAsync(productsType)) { return(RedirectToAction("ProductsTypesView")); } else { return(NotFound()); } }
public async Task <bool> AddProductsTypeAsync(ProductsType productsType) { bool result = await _fcdStoreContext.AddProductsTypeAsync(productsType); if (result) { _builderBackColorCSS.AddNewCSS(productsType.HexColor); _cacheService.Remove("ProductType"); return(true); } return(false); }
public async Task <bool> DeleteProductTypeAsync(ProductsType productsType) { bool result = await _fcdStoreContext.DeleteProductTypeAsync(productsType); if (result) { _cacheService.Remove("ProductType"); _cacheService.Remove("Product"); return(true); } return(false); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; if (context.Request["TypeName"] != null) { ProductsType s = new ProductsType(); s.TypeID = Convert.ToInt32(context.Request["TypeID"]); s.TypeName = context.Request["TypeName"]; s.State = context.Request["State"]; s.Description = context.Request["Description"]; context.Response.Write(ProductsTypeManager.ProductsTypeUpdate(s) > 0); } }
public async Task <IActionResult> NewProductsTypes(ProductsType productsType) { if (ModelState.IsValid) { if (await _dataProcessingConveyor.AddProductsTypeAsync(productsType)) { return(RedirectToAction("ProductsTypesView")); } } else { View(productsType); } return(NotFound()); }
public static List <ProductsType> ProductsTypeDrop() { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("select * from t_ProductsType"); DataSet ds = db.ExecuteDataSet(CommandType.Text, sql); List <ProductsType> ll = new List <ProductsType>(); foreach (DataRow item in ds.Tables[0].Rows) { ProductsType sh = new ProductsType(); sh.TypeID = Convert.ToInt32(item["TypeID"].ToString()); sh.TypeName = item["TypeName"].ToString(); ll.Add(sh); } return(ll); }
public async Task <IActionResult> EditProductsTypes(ProductsType productsType, string oldHEXColor, int olpParentProductTypeId) { if (ModelState.IsValid) { if (await _dataProcessingConveyor.EditProdyctTypeAsync(productsType: productsType, oldHEXColor: oldHEXColor, olpParentProductTypeId: olpParentProductTypeId)) { return(RedirectToAction("ProductsTypesView")); } else { return(NotFound()); } } return(View(productsType)); }
public static List <ProductsType> ProductsTypeID(int id) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("select * from t_ProductsType where TypeID='{0}'", id); DataSet ds = db.ExecuteDataSet(CommandType.Text, sql); List <ProductsType> ll = new List <ProductsType>(); foreach (DataRow item in ds.Tables[0].Rows) { ProductsType sh = new ProductsType(); sh.TypeName = item["TypeName"].ToString(); sh.State = item["State"].ToString(); sh.Description = item["Description"].ToString(); ll.Add(sh); } return(ll); }
public ProductsType getByTypeID(int TypeID) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@TypeID", SqlDbType.Int) }; parameters[0].Value = TypeID; ProductsType type = new ProductsType(); SqlDataReader reader = SQLHelper.RunProcedure("p_ProductsType_GetByTypeID", parameters); if (reader.Read()) { type.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); type.TypeName = reader.GetString(reader.GetOrdinal("TypeName")); type.State = reader.GetString(reader.GetOrdinal("State")); type.Description = reader.GetString(reader.GetOrdinal("Description")); } reader.Close(); return(type); }
public static List <ProductsType> ProductsTypeALL(int index, int rows) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format("select top {0} * from t_ProductsType where TypeID not in(select top {1} TypeID from t_ProductsType)", index, index * (rows - 1)); DataSet ds = db.ExecuteDataSet(CommandType.Text, sql); List <ProductsType> ll = new List <ProductsType>(); foreach (DataRow item in ds.Tables[0].Rows) { ProductsType sh = new ProductsType(); sh.TypeID = Convert.ToInt32(item["TypeID"].ToString()); sh.TypeName = item["TypeName"].ToString(); sh.State = item["State"].ToString(); sh.Description = item["Description"].ToString(); ll.Add(sh); } return(ll); }
public List <ProductsType> getAllProductsTypeCanUser() { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@sign", SqlDbType.Int) }; parameters[0].Value = 1; List <ProductsType> list = new List <ProductsType>(); SqlDataReader reader = SQLHelper.RunProcedure("p_ProductsType_GetAll", parameters); while (reader.Read()) { ProductsType item = new ProductsType(); item.TypeID = reader.GetInt32(reader.GetOrdinal("TypeID")); item.TypeName = reader.GetString(reader.GetOrdinal("TypeName")); item.State = reader.GetString(reader.GetOrdinal("State")); item.Description = reader.GetString(reader.GetOrdinal("Description")); list.Add(item); } reader.Close(); return(list); }
public static int ProductsTypeUpdate(ProductsType s) { return(ProductsTypeService.ProductsTypeUpdate(s)); }
public static int ProductsTypeInsert(ProductsType s) { return(ProductsTypeService.ProductsTypeInsert(s)); }
public Product(string productName, ProductsType productType, double cost) { ProductType = productType; Cost = cost; ProductName = productName; }
public ProductsItemStock(ProductsType type, int numberOfUnits) { _type = type; _numberOfUnits = numberOfUnits; }
public ProductsItemStock() { _type = ProductsType.None; _numberOfUnits = 0; }