/// <summary> /// 加载全部 /// </summary> /// <param name="ReceiptOrderID"></param> protected void loadinit(string SalesReturnID) { List <VSalesReturnDetail> list = new List <VSalesReturnDetail>(); list = Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDetailDAL().getBySalesReturnID(SalesReturnID); 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=\"80\">数量 </th><th width=\"80\">价格</th><th width=\"100\">金额 </th></tr>"); sb.Append(" </thead><tbody>"); for (int i = 0; i < list.Count; i++) { VSalesReturnDetail v = new VSalesReturnDetail(); 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.Quantity + "</td>"); sb.Append(" <td>" + v.Price.ToString() + "</td>"); tatal = v.Quantity * v.Price; sb.Append(" <td>" + tatal.ToString() + "</td>"); sb.Append("</tr>"); } sb.Append("</tbody></table>"); Response.Write(sb.ToString()); Response.End(); }
/// <summary> /// 输入一个实体节点 /// </summary> public void getNode() { string str0 = Request.Form["DetailID"].ToString(); VSalesReturnDetail s = new VSalesReturnDetail(); s = Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDetailDAL().getByID(int.Parse(str0)); Response.Write(s.DetailID + "$" + s.ProductsID + "$" + s.ProductsName + "$" + s.Price + "$" + s.Quantity + "$" + s.Description); Response.End(); }
public VSalesReturnDetail getByID(int DetailID) { string s = ""; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DetailID", SqlDbType.Int) }; parameters[0].Value = DetailID; VSalesReturnDetail detail = new VSalesReturnDetail(); SqlDataReader reader = SQLHelper.RunProcedure("p_SalesReturnDetail_getByID", parameters); while (reader.Read()) { detail.DetailID = reader.GetInt32(reader.GetOrdinal("DetailID")); 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")); } reader.Close(); return(detail); }
public List <VSalesReturnDetail> getBySalesReturnID(string SalesReturnID) { string s = ""; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesReturnID", SqlDbType.NVarChar) }; parameters[0].Value = SalesReturnID; List <VSalesReturnDetail> list = new List <VSalesReturnDetail>(); SqlDataReader reader = SQLHelper.RunProcedure("p_SalesReturnDetail_getBySalesReturnID", parameters); while (reader.Read()) { VSalesReturnDetail item = new VSalesReturnDetail(); item.DetailID = reader.GetInt32(reader.GetOrdinal("DetailID")); 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); }