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);
}