public bool insertNewUserTypeSubClass(UserTypeSubClass u) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserTypeID", SqlDbType.Int), new SqlParameter("@SubClassName", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.NVarChar) }; parameters[0].Value = u.UserTypeID; parameters[1].Value = u.SubClassName; parameters[2].Value = u.State; SQLHelper.RunProcedure("p_UserTypeSubClass_insertNewUserTypeSubClass", parameters, out rowsAffected); List <Products> list = new List <Products>(); list = new ProductsDAL().getAllProducts(); int num2 = -1; SqlDataReader reader = SQLHelper.RunProcedure("p_UserTypeSubClass_getLastRecond", null); while (reader.Read()) { num2 = reader.GetInt32(reader.GetOrdinal("SubClassID")); } for (int i = 0; i < list.Count; i++) { ProductsUserType p = new ProductsUserType(); Products products = list[i]; p.Price = products.Price; p.ProductsID = products.ProductsID; p.SubClassID = num2; new ProductsUserTypeDAL().insertNewRecord(p); } return(1 == rowsAffected); }
/// <summary> /// 更新时 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void PriceList_RowUpdating(object sender, GridViewUpdateEventArgs e) { string price = ((TextBox)PriceList.Rows[e.RowIndex].Cells[1].FindControl("TextBox1")).Text.ToString(); // int typeid = int.Parse(PriceList.DataKeys[e.RowIndex]["SubClassID"].ToString()); int subID = int.Parse(PriceList.DataKeys[e.RowIndex]["SubClassID"].ToString()); int proID = int.Parse(PID.Text.ToString()); double ps; try { ps = double.Parse(price); } catch { Jscript.AjaxAlert(this, "输入有误!"); PriceList.EditIndex = -1; DataBand(); return; } ProductsUserType p = new ProductsUserType(); p.Price = ps; p.ProductsID = proID; p.SubClassID = subID; Leyp.SQLServerDAL.Factory.getProductsUserTypeDAL().updateNodeupdate(p); addSystemLog("商品ID:" + proID + " 调价成功"); PriceList.EditIndex = -1; DataBand(); }
/// <summary> /// 根据用户类型得到商品的价格 /// </summary> /// <param name="ProductsID"></param> private void getProductsPrice(int ProductsID) { int userType = getSubClassID();//用户类型 ProductsUserType py = Leyp.SQLServerDAL.Factory.getProductsUserTypeDAL().getByProductsIDAndSubClassID(ProductsID, userType); Response.Write(py.Price.ToString()); Response.End(); }
public bool updateNodeupdate(ProductsUserType p) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ProductsID", SqlDbType.Int), new SqlParameter("@SubClassID", SqlDbType.Int), new SqlParameter("@Price", SqlDbType.Float) }; parameters[0].Value = p.ProductsID; parameters[1].Value = p.SubClassID; parameters[2].Value = p.Price; SQLHelper.RunProcedure("p_ProductsUserType_updateNode", parameters, out rowsAffected); return(1 == rowsAffected); }
public bool insertNewProducts(Products pro) { int rowsAffected = 0; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ProductsName", SqlDbType.NVarChar), new SqlParameter("@TypeID", SqlDbType.Int), new SqlParameter("@BrandID", SqlDbType.Int), new SqlParameter("@Color", SqlDbType.NVarChar), new SqlParameter("@Weight", SqlDbType.NVarChar), new SqlParameter("@Spec", SqlDbType.NVarChar), new SqlParameter("@Cost", SqlDbType.Money), new SqlParameter("@ProductsUints", SqlDbType.NVarChar), new SqlParameter("@Material", SqlDbType.NVarChar), new SqlParameter("@UpperLimit", SqlDbType.Int), new SqlParameter("@LowerLimit", SqlDbType.Int), new SqlParameter("@BeginEnterDate", SqlDbType.NVarChar), new SqlParameter("@FinalEnterDate", SqlDbType.NVarChar), new SqlParameter("@LatelyOFSDate", SqlDbType.NVarChar), new SqlParameter("@UnshelveDate", SqlDbType.NVarChar), new SqlParameter("@LoadingDate", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@Price", SqlDbType.Float) }; parameters[0].Value = pro.ProductsName; parameters[1].Value = pro.TypeID; parameters[2].Value = pro.BrandID; parameters[3].Value = pro.Color; parameters[4].Value = pro.Weight; parameters[5].Value = pro.Spec; parameters[6].Value = pro.Cost; parameters[7].Value = pro.ProductsUints; parameters[8].Value = pro.Material; parameters[9].Value = pro.UpperLimit; parameters[10].Value = pro.LowerLimit; parameters[11].Value = pro.BeginEnterDate; parameters[12].Value = pro.FinalEnterDate; parameters[13].Value = pro.LatelyOFSDate; parameters[14].Value = pro.UnshelveDate; parameters[15].Value = pro.LoadingDate; parameters[0x10].Value = pro.Description; parameters[0x11].Value = pro.Price; SQLHelper.RunProcedure("p_Products_InsertNew", parameters, out rowsAffected); if (rowsAffected == 1) { List <UserTypeSubClass> list = new List <UserTypeSubClass>(); list = new UserTypeSubClassDAL().getAllUserTypeSubClass(); int num2 = -1; SqlDataReader reader = SQLHelper.RunProcedure("p_Products_GetLastRecond", null); while (reader.Read()) { num2 = reader.GetInt32(reader.GetOrdinal("ProductsID")); } for (int i = 0; i < list.Count; i++) { ProductsUserType p = new ProductsUserType(); UserTypeSubClass class2 = list[i]; p.Price = pro.Price; p.ProductsID = num2; p.SubClassID = class2.SubClassID; new ProductsUserTypeDAL().insertNewRecord(p); } } return(1 == rowsAffected); }
protected void DataBand() { object PID = Request.QueryString["ProductsID"]; string ProductsID = PID.ToString(); VProducts p = new VProducts(); p = new VProductsDAL().getByID(int.Parse(ProductsID)); if (p == null) { Response.Write("没有你要的数据"); Response.End(); return; } int typeid = p.TypeID; ProductsType pt = new ProductsTypeDAL().getByTypeID(typeid); if (getTypeID() != 0) { if (pt.State.Equals("NB")) { Response.Write("没有权限"); Response.End(); return; } } Label1.Text = p.BrandName; Label2.Text = p.TypeName; Label3.Text = p.ProductsUints; Label4.Text = p.Color; Label5.Text = p.Spec; Label6.Text = p.Weight; Label7.Text = p.Material; Label8.Text = ProductsID; Label9.Text = p.ProductsName; Image1.ImageUrl = "~/UploadFiles/Images/" + p.PhotoUrl + ""; ProductsUserType pu = Leyp.SQLServerDAL.Factory.getProductsUserTypeDAL().getByProductsIDAndSubClassID(int.Parse(ProductsID), 1);//按用户类型给出一个商品的标价 Label10.Text = pu.Price.ToString(); ListBand(int.Parse(ProductsID)); }
public ProductsUserType getByProductsIDAndSubClassID(int ProductsID, int SubClassID) { string s = ""; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ProductsID", SqlDbType.Int), new SqlParameter("@SubClassID", SqlDbType.Int) }; parameters[0].Value = ProductsID; parameters[1].Value = SubClassID; ProductsUserType type = new ProductsUserType(); SqlDataReader reader = SQLHelper.RunProcedure("p_ProductsUserType_getByProductsIDandSubClassID", parameters); while (reader.Read()) { s = reader.GetValue(reader.GetOrdinal("Price")).ToString(); type.Price = double.Parse(s); type.SubClassID = SubClassID; type.ProductsID = ProductsID; } return(type); }