public List <VOutStockDetail> getListByOutID(string OutID) { string s = ""; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@OutID", SqlDbType.NVarChar) }; parameters[0].Value = OutID; List <VOutStockDetail> list = new List <VOutStockDetail>(); SqlDataReader reader = SQLHelper.RunProcedure("p_OutStockDetail_getListByOutID", parameters); while (reader.Read()) { VOutStockDetail item = new VOutStockDetail(); item.DetailID = reader.GetInt32(reader.GetOrdinal("DetailID")); item.OutID = reader.GetString(reader.GetOrdinal("OutID")); item.Description = reader.GetString(reader.GetOrdinal("Description")); 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")); list.Add(item); } reader.Close(); return(list); }
/// <summary> /// 加载全部 /// </summary> /// <param name="ReceiptOrderID"></param> protected void loadinit(string OutID) { List <VOutStockDetail> list = new List <VOutStockDetail>(); list = Leyp.SQLServerDAL.Stock.Factory.getOutStockDetailDAL().getListByOutID(OutID); 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=\"80\">数量 </th><th width=\"80\">价格</th><th width=\"100\">金额 </th></tr>"); sb.Append(" </thead><tbody>"); for (int i = 0; i < list.Count; i++) { VOutStockDetail v = new VOutStockDetail(); v = list[i]; sb.Append("<tr><td > <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.Quantity + "</td>"); sb.Append(" <td>" + v.Price.ToString() + "</td>"); sb.Append(" <td>" + v.Quantity * v.Price + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody></table>"); Response.Write(sb.ToString()); Response.End(); }
public VOutStockDetail getByID(int DetailID) { string s = ""; VOutStockDetail detail = new VOutStockDetail(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DetailID", SqlDbType.Int) }; parameters[0].Value = DetailID; SqlDataReader reader = SQLHelper.RunProcedure("p_OutStockDetail_getByID", parameters); if (reader.Read()) { detail.DetailID = reader.GetInt32(reader.GetOrdinal("DetailID")); detail.OutID = reader.GetString(reader.GetOrdinal("OutID")); detail.Description = reader.GetString(reader.GetOrdinal("Description")); 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")); } return(detail); }