/// <summary> /// 得到一个对象实体 /// </summary> public ShowShop.Model.Product.Deliver GetModelByID(int id) { ShowShop.Model.Product.Deliver model = new ShowShop.Model.Product.Deliver(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,name,inceptprice,inceptweight,arrivepay,description,addpriceladder,addweightladder,boundprice,isspecial,isused,putoutid,putouttyid,sort from yxs_deliver "); strSql.Append(" where [id]=@id "); SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.Read()) { model.ID = reader.GetInt32(0); model.Name = reader.GetString(1); model.InceptPrice = Convert.ToDecimal(reader["inceptprice"]); model.InceptWeight = Convert.ToDecimal(reader["inceptweight"]); model.ArrivePay = reader.GetInt32(4); model.Description = reader.GetString(5); model.AddPriceLadder = Convert.ToDecimal(reader["addpriceladder"]); model.AddWeightLadder = Convert.ToDecimal(reader["addweightladder"]); model.BoundPrice = reader.GetString(8); model.IsSpecial = reader.GetInt32(9); model.IsUsed = reader.GetInt32(10); model.PutoutId = reader.GetInt32(11); model.PutouttyId = reader.GetInt32(12); model.Sort = reader.GetInt32(13); } else { model = null; } } return model; }
protected void lbtnSave_Click(object sender, EventArgs e) { //try //{ ShowShop.BLL.Product.Deliver bll = new ShowShop.BLL.Product.Deliver(); ShowShop.Model.Product.Deliver model = new ShowShop.Model.Product.Deliver(); if (!ChangeHope.Common.ValidateHelper.IsMoney(txtInceptPrice.Text) || !ChangeHope.Common.ValidateHelper.IsNumber(txtInceptWeight.Text) || !ChangeHope.Common.ValidateHelper.IsMoney(txtAddPricelAdder.Text) || !ChangeHope.Common.ValidateHelper.IsMoney(txtAddWeightlAdder.Text) || !ChangeHope.Common.ValidateHelper.IsNumber(txtBoundU1.Text) || !ChangeHope.Common.ValidateHelper.IsNumber(txtBoundD1.Text) || !ChangeHope.Common.ValidateHelper.IsMoney(txtBoundP1.Text)) { this.ltlMsg.Text = "操作失败,请输入正确的价格或者数字"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } if (float.Parse(txtInceptPrice.Text) <= 0 || float.Parse(txtInceptWeight.Text) <= 0 || float.Parse(txtAddPricelAdder.Text) <= 0 || float.Parse(txtAddWeightlAdder.Text) <= 0 || float.Parse(txtBoundU1.Text) <= 0 || float.Parse(txtBoundD1.Text) <= 0 || float.Parse(txtBoundP1.Text)<=0 ) { this.ltlMsg.Text = "操作失败,价格与重量数不能小于或者等于0"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionErr"; return; } model.Name = this.txtName.Text.Trim(); model.InceptPrice = Convert.ToDecimal(this.txtInceptPrice.Text.Trim()); model.InceptWeight = Convert.ToDecimal(this.txtInceptWeight.Text.Trim()); model.ArrivePay = Convert.ToInt32(this.rblArrivePay.SelectedValue); model.Description = this.txtDescription.Text.Trim(); model.AddPriceLadder = Convert.ToDecimal(this.txtAddPricelAdder.Text.Trim()); model.AddWeightLadder = Convert.ToDecimal(this.txtAddWeightlAdder.Text.Trim()); model.BoundPrice = GetBoundPrice(); model.IsSpecial = Convert.ToInt32(this.rblIsSpecial.SelectedValue); model.IsUsed = Convert.ToInt32(this.rblisused.SelectedValue); model.Sort = Convert.ToInt32(this.txtSort.Text.Trim()); if (ViewState["ID"] != null)//更新 { model.ID = Convert.ToInt32(ViewState["ID"].ToString()); model.PutoutId = Convert.ToInt32(ViewState["PutoutID"]); model.PutouttyId = Convert.ToInt32(ViewState["PutoutTyID"]); bll.Amend(model); } else//添加 { ShowShop.Model.Admin.AdminInfo adminModel = (ShowShop.Model.Admin.AdminInfo)ShowShop.Common.AdministrorManager.Get(); //管理员ID model.PutoutId = adminModel.AdminId; model.PutouttyId = 0; bll.Add(model); } this.ltlMsg.Text = "操作成功,已保存该信息"; this.pnlMsg.Visible = true; this.pnlMsg.CssClass = "actionOk"; //} //catch //{ // this.ltlMsg.Text = "操作失败,请查看数据格式是否符合要求"; // this.pnlMsg.Visible = true; // this.pnlMsg.CssClass = "actionErr"; //} }
/// <summary> /// 得到指定条件的所有短消息 /// </summary> /// <param name="uid"></param> /// <returns></returns> public List<ShowShop.Model.Product.Deliver> GetAll(string strWhere) { List<ShowShop.Model.Product.Deliver> list = new List<ShowShop.Model.Product.Deliver>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,name,inceptprice,inceptweight,arrivepay,description,addpriceladder,addweightladder,boundprice,isspecial,isused,putoutid,putouttyid,sort from yxs_deliver "); if (strWhere != null && strWhere != "") { strSql.Append("where " + strWhere + " "); } strSql.Append(" order by sort asc"); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.Product.Deliver model = new ShowShop.Model.Product.Deliver(); model.ID = reader.GetInt32(0); model.Name = reader.GetString(1); model.InceptPrice = Convert.ToDecimal(reader["inceptprice"]); model.InceptWeight = Convert.ToDecimal(reader["inceptweight"]); model.ArrivePay = reader.GetInt32(4); model.Description = reader.GetString(5); model.AddPriceLadder = Convert.ToDecimal(reader["addpriceladder"]); model.AddWeightLadder = Convert.ToDecimal(reader["addweightladder"]); model.BoundPrice = reader.GetString(8); model.IsSpecial = reader.GetInt32(9); model.IsUsed = reader.GetInt32(10); model.PutoutId = reader.GetInt32(11); model.PutouttyId = reader.GetInt32(12); model.Sort = reader.GetInt32(13); list.Add(model); } } return list; }