/// <summary> /// 查询添加成功的表单查询 /// </summary> /// <returns></returns> public static List <SaveOutDetail> CheckGridView(string OutID) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format(@"select t_OutStockDetail.DetailID,ps.ProductsID,ProductsName,Quantity,Price,Price*Quantity Total from t_OutStockDetail join (select p.ProductsID,p.ProductsName from (select distinct p.ProductsID,p.ProductsName from t_OutStockDetail s join t_Products p on s.ProductsID=p.ProductsID ) p ) ps on t_OutStockDetail.ProductsID=ps.ProductsID and t_OutStockDetail.OutID ='{0}'", OutID); DataSet ds = db.ExecuteDataSet(CommandType.Text, sql); List <SaveOutDetail> list = new List <SaveOutDetail>(); foreach (DataRow item in ds.Tables[0].Rows) { SaveOutDetail s = new SaveOutDetail(); s.DetailID = int.Parse(item["DetailID"].ToString()); s.ProductsID = int.Parse(item["ProductsID"].ToString()); s.ProductsName = item["ProductsName"].ToString(); //s.SupplierName = item["SupplierName"].ToString(); s.Quantity = int.Parse(item["Quantity"].ToString()); s.Price = Convert.ToDouble(item["Price"].ToString()); s.Total = Convert.ToDouble(item["Total"].ToString()); list.Add(s); } return(list); }
/// <summary> /// 添加编辑的信息到保存表里 /// </summary> /// <param name="supplyname"></param> /// <returns></returns> public static bool AddMessage(SaveOutDetail save) { Database db = DatabaseFactory.CreateDatabase("Constr"); string sql = string.Format(@"insert into t_OutStockDetail values('{0}',{1},{2},'{3}','{4}')", save.OutID, save.ProductsID, save.Quantity, save.Price, save.Description == "" ? " " : save.Description); return(db.ExecuteNonQuery(CommandType.Text, sql) > 0); }
//点击保存 保存信息 protected void btnSave_Click(object sender, EventArgs e) { SaveOutDetail save = new SaveOutDetail(); save.OutID = this.txtOrderID.Text; save.ProductsID = int.Parse(this.ProID.Text); save.ProductsName = this.txtPro.Text; //save.SupplierID = BLL.PIntoBLL.ProIntoManager.GetSupplierID(this.txtSupply.Text); save.Quantity = int.Parse(this.txtCount.Text); save.Price = Convert.ToDouble(this.txtPrice.Text); save.Total = Convert.ToDouble(this.txtPrice.Text) * int.Parse(this.txtCount.Text); if (BLL.POutBLL.POutManager.AddMessage(save)) { this.GridViewMessage.DataSource = BLL.POutBLL.POutManager.CheckGridView(save.OutID); this.GridViewMessage.DataBind(); } else { Response.Write("<script>alert('添加信息失败')</script>"); } }
//添加编辑的信息到保存表里 public static bool AddMessage(SaveOutDetail save) { return(DAL.POutDAL.POutService.AddMessage(save)); }