public bool insertSalesDetailFrist(string SalesOrderID, string SalesOutID)
{
try
{
List <VSalesDetail> list = new List <VSalesDetail>();
SalesOutDetailDAL ldal = new SalesOutDetailDAL();
list = new SalesDetailDAL().getBySalesOrderID(SalesOrderID);
for (int i = 0; i < list.Count; i++)
{
SalesOutDetail b = new SalesOutDetail();
VSalesDetail detail2 = list[i];
b.ProductsID = detail2.ProductsID;
b.Quantity = detail2.Quantity;
b.SalesOutID = SalesOutID;
b.DiscountRate = detail2.DiscountRate;
b.Description = detail2.Description;
b.Price = detail2.Price;
ldal.insertNewEitity(b);
}
return(true);
}
catch
{
return(false);
}
}
public bool insertNewEntity(SalesOut s)
{
int rowsAffected = 0;
float num2 = float.Parse("0.00");
List <VSalesOutDetail> list = new SalesOutDetailDAL().getBySalesOutID(s.SalesOutID);
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail detail = list[i];
num2 += (detail.Price * detail.Quantity) * (1f - (detail.DiscountRate / 100f));
}
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesOutID", SqlDbType.NVarChar), new SqlParameter("@SalesOrderID", SqlDbType.NVarChar), new SqlParameter("@CreateDate", SqlDbType.NVarChar), new SqlParameter("@Consignee", SqlDbType.NVarChar), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@TotalPrice", SqlDbType.Float), new SqlParameter("@Deposits", SqlDbType.Float), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@DeliveryID", SqlDbType.Int), new SqlParameter("@AccountsID", SqlDbType.NVarChar) };
parameters[0].Value = s.SalesOutID;
parameters[1].Value = s.SalesOrderID;
parameters[2].Value = s.CreateDate;
parameters[3].Value = s.Consignee;
parameters[4].Value = s.TradeDate;
parameters[5].Value = num2;
parameters[6].Value = s.Deposits;
parameters[7].Value = s.UserName;
parameters[8].Value = s.Description;
parameters[9].Value = s.State;
parameters[10].Value = s.DeliveryID;
parameters[11].Value = s.AccountsID;
SQLHelper.RunProcedure("p_SalesOut_insertNewEntity", parameters, out rowsAffected);
if (rowsAffected == 1)
{
new SalesOrderDAL().updateSate(2, s.SalesOrderID);
}
return(1 == rowsAffected);
}
public bool insertNewEntity(SalesReturn s)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesReturnID", SqlDbType.NVarChar), new SqlParameter("@SalesOutID", SqlDbType.NVarChar), new SqlParameter("@CreateDate", SqlDbType.NVarChar), new SqlParameter("@ReturnType", SqlDbType.NVarChar), new SqlParameter("@StoreHouseID", SqlDbType.Int), new SqlParameter("@HouseDetailID", SqlDbType.Int), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@TotalPrice", SqlDbType.Float), new SqlParameter("@Deposits", SqlDbType.Float), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int) };
parameters[0].Value = s.SalesReturnID;
parameters[1].Value = s.SalesOutID;
parameters[2].Value = s.CreateDate;
parameters[3].Value = s.ReturnType;
parameters[4].Value = s.StoreHouseID;
parameters[5].Value = s.HouseDetailID;
parameters[6].Value = s.TradeDate;
parameters[7].Value = s.TotalPrice;
parameters[8].Value = s.Deposits;
parameters[9].Value = s.UserName;
parameters[10].Value = s.Description;
parameters[11].Value = s.State;
SQLHelper.RunProcedure("p_SalesReturn_insertNewEntity", parameters, out rowsAffected);
List <VSalesOutDetail> list = new List <VSalesOutDetail>();
SalesReturnDetailDAL ldal = new SalesReturnDetailDAL();
list = new SalesOutDetailDAL().getBySalesOutID(s.SalesOutID);
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail detail = list[i];
SalesReturnDetail b = new SalesReturnDetail();
b.Price = detail.Price;
b.ProductsID = detail.ProductsID;
b.Quantity = detail.Quantity;
b.Description = "";
b.SalesReturnID = s.SalesReturnID;
ldal.insertNewEitity(b);
}
return(1 == rowsAffected);
}
public bool AuditingSalesOutOrder(string SalesOutID)
{
bool flag = false;
try
{
VSalesOut @out = new VSalesOut();
List <VSalesOutDetail> list = new List <VSalesOutDetail>();
ProductsStockDAL kdal = new ProductsStockDAL();
@out = new SalesOutDAL().getByID(SalesOutID);
list = new SalesOutDetailDAL().getBySalesOutID(SalesOutID);
for (int i = 0; i < list.Count; i++)
{
ProductsStock stock;
SalesOutDetail detail = list[i];
if (kdal.isHaveEitity(detail.HouseDetailID, detail.ProductsID))
{
stock = new ProductsStock();
stock.HouseDetailID = detail.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = detail.Quantity;
kdal.updateCutNum(stock);
}
else
{
stock = new ProductsStock();
stock.HouseDetailID = detail.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = -detail.Quantity;
kdal.insertNewEitity(stock);
}
}
flag = true;
}
catch
{
}
return(flag);
}