/// <summary> /// Create a new BeautyPrice /// </summary> /// <param name="newBeautyPrice">new BeautyPrice</param> /// <returns>new BeautyPrice id</returns> public Guid Create(BeautyPrice newBeautyPrice) { string sql = string.Format("EXEC sp_Price_c {0},{1},{2},{3},{4},{5},{6},{7},{8}" , ToQuote(newBeautyPrice.ID) , ToQuote(newBeautyPrice.Pricename) , ToQuote(newBeautyPrice.Price) , ToQuote(newBeautyPrice.PromotionPrice) , ToQuote(CurrentUserName) , ToQuote(DateTime.Now) , ToQuote(CurrentUserName) , ToQuote(DateTime.Now) , ToQuote(newBeautyPrice.Statues) ); try { int rowcount = SqlHelper.ExecuteNonQuery(ConnectStr, CommandType.Text, sql); if (rowcount == 1) { return(newBeautyPrice.ID); } else { throw new Exception("SQL execution failed"); } } catch (Exception ex) { throw new Exception("SQL execution failed", ex); } }
/// <summary> /// Delete an existing BeautyPrice /// </summary> /// <param name="thisBeautyPrice">BeautyPrice</param> /// <returns>bool</returns> public bool Delete(BeautyPrice thisBeautyPrice) { string sql = string.Format("exec dbo.sp_Price_d {0} " , ToQuote(thisBeautyPrice.ID) ); try { int rowcount = SqlHelper.ExecuteNonQuery(ConnectStr, CommandType.Text, sql); if (rowcount >= 1) { return(true); } else { throw new Exception("SQL execution failed"); } } catch (Exception ex) { throw new Exception("SQL execution failed", ex); } }
public ActionResult PriceEdit(string id) { BeautyPrice price = iprice.Get(new Guid(id)); WebPrice webprice = AutoMapper.Mapper.Map <WebPrice>(price); return(View(webprice)); }
public ActionResult PriceEdit(WebPrice webprice) { BeautyPrice price = AutoMapper.Mapper.Map <BeautyPrice>(webprice); price.Statues = 1; bool isupdate = iprice.Update(price); if (isupdate) { return(RedirectToAction("Pricesetting")); } return(View()); }
/// <summary> /// Don't repeat yourself! This private function is for shared by all query public functions /// </summary> /// <param name="sql"></param> /// <param name="page"></param> /// <param name="pg"></param> /// <returns></returns> IList <BeautyPrice> GetBeautyPrices(string sql, int page, string sortKey, out PaginationInfo paging) { using (DataSet ds = SqlHelper.ExecuteDataset(ConnectStr, CommandType.Text, sql)) { if (ds == null || ds.Tables.Count != 2) { throw new Exception("SQL execution failed"); } else { List <BeautyPrice> Comments = new List <BeautyPrice>(); foreach (DataRow dr in ds.Tables[0].Rows) { BeautyPrice Comment = new BeautyPrice() { ID = new Guid(dr["id"].ToString()), Price = ParseDecimal(dr["Price"].ToString()), Pricename = ParseStr(dr["Pricename"]), PromotionPrice = ParseNDecimal(dr["PromotionPrice"].ToString()), Statues = ParseInt(dr["Statues"]), Createby = ParseStr(dr["Createby"]), Createtime = ParseStr(dr["Createtime"]), Updateby = ParseStr(dr["Updateby"]), Updatetime = ParseStr(dr["Updatetime"]) }; Comments.Add(Comment); } paging = new PaginationInfo() { Current = page, Size = ParseInt(ds.Tables[1].Rows[0]["pagesize"]), TotalRecords = ParseInt(ds.Tables[1].Rows[0]["totalrecords"]), TotalPages = (int)Math.Ceiling(ParseInt(ds.Tables[1].Rows[0]["totalrecords"]) / ParseFloat(ds.Tables[1].Rows[0]["pagesize"])) }; return(Comments); } } }
public ActionResult PriceCreate(WebPrice model) { if (string.IsNullOrEmpty(model.Pricename)) { ModelState.AddModelError("", "产品名称不能空"); } if (ModelState.IsValid) { BeautyPrice price = AutoMapper.Mapper.Map <BeautyPrice>(model); price.Statues = 1; price.ID = Guid.NewGuid(); Guid id = iprice.Create(price); if (id == price.ID) { return(RedirectToAction("Pricesetting")); } } return(View()); }