/// <summary> /// 加载全部 /// </summary> /// <param name="ReceiptOrderID"></param> protected void loadinit(string ReceiptOrderID) { List <VBuyReceiptDetail> list = new List <VBuyReceiptDetail>(); list = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDetailDAL().getBuyReceiptDetailByReceiptOrderID(ReceiptOrderID); float tatal = float.Parse("0.00"); StringBuilder sb = new StringBuilder(); sb.Append("<table class=\"flexme2\"><thead><tr><th width=\"70\">操作</th><th width=\"80\">商品编号</th><th width=\"100\">商品名称</th><th width=\"90\">供应商</th><th width=\"80\">数量 </th><th width=\"80\">采购额</th><th width=\"80\">折扣额 </th><th width=\"80\">税额</th><th width=\"100\">金额 </th></tr>"); sb.Append(" </thead><tbody>"); for (int i = 0; i < list.Count; i++) { VBuyReceiptDetail v = new VBuyReceiptDetail(); v = list[i]; sb.Append("<tr><td ><img src=\"../images/tbtn_amend.gif\" onclick=\"editDetail(" + v.DetailID + ")\"; /> <img src=\"../images/tbtn_delete.gif\" onclick=\"javascript:if(!confirm('您确定要删除吗'))return false;deleteDetail(" + v.DetailID + ")\"; /> </td>"); sb.Append(" <td>" + v.ProductsID + "</td>"); sb.Append(" <td>" + v.ProductsName + "</td>"); sb.Append(" <td>" + v.SupplierName + "</td>"); sb.Append(" <td>" + v.Quantity + "</td>"); sb.Append(" <td>" + v.Price.ToString() + "</td>"); sb.Append(" <td>" + v.DiscountRate.ToString() + "</td>"); sb.Append(" <td>" + v.TaxRate.ToString() + "</td>"); tatal = (v.Quantity * v.Price * (100 + v.TaxRate) / 100) - (v.Quantity * v.Price * v.DiscountRate / 100); sb.Append(" <td>" + tatal.ToString() + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody></table>"); Response.Write(sb.ToString()); Response.End(); }
public VBuyReceiptDetail getByID(int DetailID) { string s = ""; VBuyReceiptDetail detail = new VBuyReceiptDetail(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DetailID", SqlDbType.Int) }; parameters[0].Value = DetailID; SqlDataReader reader = SQLHelper.RunProcedure("p_BuyReceiptDetail_getByID", parameters); if (reader.Read()) { detail.DetailID = reader.GetInt32(reader.GetOrdinal("DetailID")); detail.ReceiptOrderID = reader.GetString(reader.GetOrdinal("ReceiptOrderID")); detail.Description = reader.GetString(reader.GetOrdinal("Description")); s = reader.GetValue(reader.GetOrdinal("DiscountRate")).ToString(); detail.DiscountRate = float.Parse(s); s = reader.GetValue(reader.GetOrdinal("Price")).ToString(); detail.Price = float.Parse(s); detail.ProductsID = reader.GetInt32(reader.GetOrdinal("ProductsID")); detail.ProductsName = reader.GetString(reader.GetOrdinal("ProductsName")); detail.Quantity = reader.GetInt32(reader.GetOrdinal("Quantity")); detail.SupplierID = reader.GetInt32(reader.GetOrdinal("SupplierID")); detail.SupplierName = reader.GetString(reader.GetOrdinal("SupplierName")); s = reader.GetValue(reader.GetOrdinal("TaxRate")).ToString(); detail.TaxRate = float.Parse(s); } return(detail); }
public List <VBuyReceiptDetail> getBuyReceiptDetailByReceiptOrderID(string ReceiptOrderID) { string s = ""; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ReceiptOrderID", SqlDbType.NVarChar) }; parameters[0].Value = ReceiptOrderID; List <VBuyReceiptDetail> list = new List <VBuyReceiptDetail>(); SqlDataReader reader = SQLHelper.RunProcedure("p_BuyReceiptDetail_getReceiptOrderID", parameters); while (reader.Read()) { VBuyReceiptDetail item = new VBuyReceiptDetail(); item.DetailID = reader.GetInt32(reader.GetOrdinal("DetailID")); item.ReceiptOrderID = reader.GetString(reader.GetOrdinal("ReceiptOrderID")); item.Description = reader.GetString(reader.GetOrdinal("Description")); s = reader.GetValue(reader.GetOrdinal("DiscountRate")).ToString(); item.DiscountRate = float.Parse(s); s = reader.GetValue(reader.GetOrdinal("Price")).ToString(); item.Price = float.Parse(s); item.ProductsID = reader.GetInt32(reader.GetOrdinal("ProductsID")); item.ProductsName = reader.GetString(reader.GetOrdinal("ProductsName")); item.Quantity = reader.GetInt32(reader.GetOrdinal("Quantity")); item.SupplierID = reader.GetInt32(reader.GetOrdinal("SupplierID")); item.SupplierName = reader.GetString(reader.GetOrdinal("SupplierName")); s = reader.GetValue(reader.GetOrdinal("TaxRate")).ToString(); item.TaxRate = float.Parse(s); list.Add(item); } reader.Close(); return(list); }
/// <summary> /// 输出一个VBuyReceiptDetail /// </summary> public void getNode(int DetailID) { VBuyReceiptDetail v = new VBuyReceiptDetail(); v = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDetailDAL().getByID(DetailID); StringBuilder sb = new StringBuilder(); sb.Append(v.ProductsName + "$" + v.ProductsID + "$" + v.Price + "$" + v.Quantity + "$" + v.TaxRate + "$" + v.DiscountRate + "$" + v.SupplierName + "$" + v.SupplierID + "$" + v.Description + "$" + v.DetailID); Response.Write(sb.ToString()); Response.End(); }
public bool insertNewEntity(BuyReturn b) { int rowsAffected = 0; float num2 = float.Parse("0.00"); if (b.Identitys == 0) { BuyReturnDetailDAL ldal = new BuyReturnDetailDAL(); List <VBuyReceiptDetail> list = new List <VBuyReceiptDetail>(); list = new BuyReceiptDetailDAL().getBuyReceiptDetailByReceiptOrderID(b.ReceiptOrderID); for (int i = 0; i < list.Count; i++) { BuyReturnDetail detail = new BuyReturnDetail(); VBuyReceiptDetail detail2 = list[i]; detail.Description = detail2.Description; detail.Price = detail2.Price; detail.ProductsID = detail2.ProductsID; detail.Quantity = detail2.Quantity; detail.SupplierID = detail2.SupplierID; detail.BuyReturnID = b.BuyReturnID; ldal.insertNewEitity(detail); num2 += detail.Quantity * detail.Price; } } SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@BuyReturnID", SqlDbType.NVarChar), new SqlParameter("@BuyReturnDate", SqlDbType.NVarChar), new SqlParameter("@StoreHouseID", SqlDbType.Int), new SqlParameter("@HouseDetailID", SqlDbType.Int), new SqlParameter("@ReceiptOrderID", SqlDbType.NVarChar), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@TotalPrice", SqlDbType.Money), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@Identitys", SqlDbType.Int), new SqlParameter("@AlreadyPay", SqlDbType.Money), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int) }; parameters[0].Value = b.BuyReturnID; parameters[1].Value = b.BuyReturnDate; parameters[2].Value = b.StoreHouseID; parameters[3].Value = b.HouseDetailID; parameters[4].Value = b.ReceiptOrderID; parameters[5].Value = b.UserName; parameters[6].Value = num2; parameters[7].Value = b.TradeDate; parameters[8].Value = b.Identitys; parameters[9].Value = b.AlreadyPay; parameters[10].Value = b.Description; parameters[11].Value = b.State; SQLHelper.RunProcedure("p_BuyReturn_insertNewEntity", parameters, out rowsAffected); return(1 == rowsAffected); }