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