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