protected void init()
{
string action = Request.Form["action"].ToString();
if (action.Equals("addDetail"))//明细添加
{
string str0 = Request.Form["SalesReturnID"].ToString();
string str1 = Request.Form["ProductsID"].ToString();
string str2 = Request.Form["Price"].ToString();
string str3 = Request.Form["Quantity"].ToString();
string str4 = Request.Form["Descriptions"].ToString();
SalesReturnDetail d = new SalesReturnDetail();
d.SalesReturnID = str0;
d.ProductsID = int.Parse(str1);
d.Price = float.Parse(str2);
d.Quantity = int.Parse(str3);
d.Description = str4;
Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDetailDAL().insertNewEitity(d);
Response.Write("00");
Response.End();
}
else if (action.Equals("LoadDetail"))//加载明细BY SalesOrderID
{
string str0 = Request.Form["SalesReturnID"].ToString();
loadinit(str0);
}
else if (action.Equals("delDetail"))//delete
{
string str0 = Request.Form["DetailID"].ToString();
Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDetailDAL().deleteEitity(int.Parse(str0));
Response.Write("00");
Response.End();
}
else if (action.Equals("getNode"))//得到编辑节点
{
getNode();
}
else if (action.Equals("editDetail"))//编辑节点
{
string str0 = Request.Form["SalesReturnID"].ToString();
string str1 = Request.Form["ProductsID"].ToString();
string str2 = Request.Form["Price"].ToString();
string str3 = Request.Form["Quantity"].ToString();
string str4 = Request.Form["Descriptions"].ToString();
string str5 = Request.Form["DetailID"].ToString();
SalesReturnDetail d = new SalesReturnDetail();
d.SalesReturnID = str0;
d.ProductsID = int.Parse(str1);
d.Price = float.Parse(str2);
d.Quantity = int.Parse(str3);
d.Description = str4;
d.DetailID = int.Parse(str5);
Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDetailDAL().updateEitity(d);
Response.Write("00");
Response.End();
}
}
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 void InsertSalesReturn(SalesReturnColumnModel model)
{
try
{
using (this.unitOfWork)
{
SalesReturn item = new SalesReturn()
{
MemoNumber = model.MemoNumber,
CustomerId = model.CustomerId,
ReturnDate = model.ReturnDate,
AmountReturn = model.AmountReturn,
Adjustment = model.Adjustment,
TotalCreditAmount = model.TotalCreditAmount,
Remarks = model.Remarks,
IsDeleted = model.IsDeleted,
RecordedBy = model.RecordedByUser,
ApprovedBy = model.ApprovedByUser,
AmountUsed = 0
};
if (model.Details.Count > 0)
{
foreach (SalesReturnDetailModel d in model.Details)
{
SalesReturnDetail detail = new SalesReturnDetail()
{
PartDetailId = d.PartDetailId,
InvoiceNumber = d.InvoiceNumber,
Quantity = d.Quantity,
UnitPrice = d.UnitPrice,
TotalAmount = d.TotalAmount,
Balance = d.TotalAmount
};
item.SalesReturnDetail.Add(detail);
AutoPartDetail autoDetail = db.AutoPartDetail.FirstOrDefault(a => a.Id == d.PartDetailId);
if (autoDetail != null)
{
autoDetail.Quantity += d.Quantity;
}
}
}
this.unitOfWork.Context.AddToSalesReturn(item);
string action = string.Format("Added new Sales Return - {0}", item.MemoNumber);
this.actionLogController.AddToLog(action, UserInfo.UserId);
this.unitOfWork.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool insertNewEitity(SalesReturnDetail b)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesReturnID", SqlDbType.NVarChar), new SqlParameter("@ProductsID", SqlDbType.Int), new SqlParameter("@Quantity", SqlDbType.Int), new SqlParameter("@Price", SqlDbType.Money), new SqlParameter("@Description", SqlDbType.NVarChar) };
parameters[0].Value = b.SalesReturnID;
parameters[1].Value = b.ProductsID;
parameters[2].Value = b.Quantity;
parameters[3].Value = b.Price;
parameters[4].Value = b.Description;
SQLHelper.RunProcedure("p_SalesReturnDetail_insertNewEntity", parameters, out rowsAffected);
return(1 == rowsAffected);
}
public void SaveUpdateSalesReturnDetail(SalesReturnDetail obS_R_Detail, SqlConnection con, SqlTransaction trans)
{
SqlCommand com = null;
try
{
com = new SqlCommand("spSaveUpdateSalesReturnDetail", con, trans);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@ReturnDID", SqlDbType.Int).Value = obS_R_Detail.ReturnDID;
com.Parameters.Add("@ReturnMID", SqlDbType.Int).Value = obS_R_Detail.ReturnMID;
com.Parameters.Add("@ItemID", SqlDbType.Int).Value = obS_R_Detail.ItemID;
com.Parameters.Add("@ReturnQty", SqlDbType.Money).Value = obS_R_Detail.ReturnQty;
com.Parameters.Add("@UnitID", SqlDbType.Int).Value = obS_R_Detail.UnitID;
com.Parameters.Add("@UnitPrice", SqlDbType.Money).Value = obS_R_Detail.UnitPrice;
com.Parameters.Add("@ReturnAmount", SqlDbType.Money).Value = obS_R_Detail.ReturnAmount;
com.Parameters.Add("@Remarks", SqlDbType.VarChar, 500).Value = obS_R_Detail.Remarks;
com.Parameters.Add("@ColorCode", SqlDbType.VarChar, 50).Value = obS_R_Detail.ColorCode;
com.Parameters.Add("@Labdip", SqlDbType.VarChar, 50).Value = obS_R_Detail.Labdip;
if (obS_R_Detail.CountID <= 0)
{
com.Parameters.Add("@CountID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@CountID", SqlDbType.Int).Value = obS_R_Detail.CountID;
}
if (obS_R_Detail.SizeID <= 0)
{
com.Parameters.Add("@SizeID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@SizeID", SqlDbType.Int).Value = obS_R_Detail.SizeID;
}
if (obS_R_Detail.ColorID <= 0)
{
com.Parameters.Add("@ColorID", SqlDbType.Int).Value = DBNull.Value;
}
else
{
com.Parameters.Add("@ColorID", SqlDbType.Int).Value = obS_R_Detail.ColorID;
}
com.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult ReturnItems(FormCollection coll)
{
List <SalesReturnDetail> details = new List <SalesReturnDetail>();
var counter = Convert.ToInt32(coll["counter"]);
//attributes required for SalesReturn
decimal total = Convert.ToDecimal(coll["SubTotal"]);
decimal discount = Convert.ToDecimal(coll["Discount"]);
decimal netTotal = Convert.ToDecimal(coll["NetTotal"]);
int salesID = Convert.ToInt32(coll["SalesID"]);
//populating through each of the occurance of the ReturnedItems
for (int i = 1; i <= counter; i++)
{
var value = coll["Qty_" + i];
if (!string.IsNullOrEmpty(value) && value != "0")
{
SalesReturnDetail srd = new SalesReturnDetail
{
StockID = Convert.ToInt32(coll["StockID_" + i]),
BatchNo = coll["BatchNo_" + i],
Qty = Convert.ToInt32(coll["Qty_" + i]),
Rate = Convert.ToDecimal(coll["Rate_" + i]),
Amount = Convert.ToDecimal(coll["Amount_" + i])
};
details.Add(srd);
}
}
//populating Sales Return
SalesReturn _SalesReturn = new SalesReturn
{
SalesID = salesID,
Subtotal = total,
Discount = discount,
NetTotal = netTotal,
SalesReturnDetails = details,
Description = "n/a",
ReturnedDate = DateTime.Today
};
//Add in Sales And save changes
salRetRepo.Add(_SalesReturn);
// db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool AuditingSalesOutOrder(string SalesReturnID)
{
bool flag = false;
try
{
VSalesReturn return2 = new VSalesReturn();
List <VSalesReturnDetail> list = new List <VSalesReturnDetail>();
ProductsStockDAL kdal = new ProductsStockDAL();
return2 = new SalesReturnDAL().getByID(SalesReturnID);
list = new SalesReturnDetailDAL().getBySalesReturnID(SalesReturnID);
for (int i = 0; i < list.Count; i++)
{
ProductsStock stock;
SalesReturnDetail detail = list[i];
if (kdal.isHaveEitity(return2.HouseDetailID, detail.ProductsID))
{
stock = new ProductsStock();
stock.HouseDetailID = return2.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = detail.Quantity;
kdal.updateAddNum(stock);
}
else
{
stock = new ProductsStock();
stock.HouseDetailID = return2.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = detail.Quantity;
kdal.insertNewEitity(stock);
}
}
flag = true;
}
catch
{
}
return(flag);
}
public static string SelectSingleSalesReturn(long sales_return_id)
{
try
{
if (sales_return_id == 0)
{
return("'Null'");
}
List <SalesReturn> _salesReturn = new List <SalesReturn>();
var data = Database._SalesReturnSelect(sales_return_id);
foreach (var d in data)
{
SalesReturn _sr = new SalesReturn();
_sr.ID = d.ID;
_sr.CustomerID = d.CustomerID.Value;
_sr.CustomerName = d.CustomerName;
_sr.Address = d.Address;
_sr.ForwarderID = d.DeliverToID.Value;
_sr.SalesmanID = d.SalesmanID.Value;
_sr.PoNO = d.PONo;
_sr.TermID = d.TermID.Value;
_sr.RefNo = d.RefNo;
_sr.RefSerial = d.RefNoSerial;
_sr.Date = d.CreatedDate.Value;
_sr.Notes = d.Notes;
_sr.TotalAmount = d.TotalAmount.Value;
var salesReturnDetails = Database._SalesReturnDetailsSelect(d.ID);
List <SalesReturnDetail> salesReturnDetail = new List <SalesReturnDetail>();
foreach (var srd in salesReturnDetails)
{
SalesReturnDetail _srd = new SalesReturnDetail();
_srd.ID = srd.ID;
_srd.ProductID = srd.ProductID.Value;
_srd.ProductName = srd.ProductName;
_srd.LocationID = srd.LocationID.Value;
_srd.LocationName = srd.LocationName;
_srd.Quantity = srd.Quantity.Value;
_srd.Unit = srd.UnitName;
_srd.UnitPrice = srd.UnitPrice.Value;
_srd.Discount = srd.Discount;
_srd.Amount = srd.Amount.Value;
salesReturnDetail.Add(_srd);
}
_sr.SalesReturnDetails = salesReturnDetail;
//--------------------------
var salesReturnPayment = Database._invoicePaymentSalesReturns.Where(x => x.SalesReturnID == d.ID);
List <ApplyList> ApplyLists = new List <ApplyList>();
foreach (var srp in salesReturnPayment)
{
ApplyList _al = new ApplyList();
_al.InvoiceID = srp.InvoiceID.Value;
_al.RefNo = Database._Invoices.SingleOrDefault(x => x.ID == srp.InvoiceID).RefNo + Database._Invoices.SingleOrDefault(x => x.ID == srp.InvoiceID).RefNoSerial;
_al.Date = Database._Invoices.SingleOrDefault(x => x.ID == srp.InvoiceID).CreatedDate.Value;
_al.Description = "Invoices";
var salesman_id = Database._Invoices.SingleOrDefault(x => x.ID == srp.InvoiceID.Value).SalesmanID;
_al.Salesman = Database._Employees.SingleOrDefault(x => x.ID == salesman_id).EmployeeName;
_al.Balance = (Database._Invoices.SingleOrDefault(x => x.ID == srp.InvoiceID).TotalAmount.Value - srp.Amount.Value);
_al.AppliedAmount = srp.Amount.Value;
ApplyLists.Add(_al);
}
_sr.ApplyLists = ApplyLists;
_salesReturn.Add(_sr);
}
if (_salesReturn.Count <= 0)
{
return("'Null'");
}
else
{
return(JsonConvert.SerializeObject(_salesReturn, Newtonsoft.Json.Formatting.None));
}
}
catch (Exception)
{
return(string.Empty);
}
}
public void UpdateSalesReturn(SalesReturnColumnModel model)
{
try
{
using (this.unitOfWork)
{
var item = FetchSalesReturnById(model.Id);
if (item != null)
{
//Delete old details
if (item.SalesReturnDetail.Any())
{
foreach (var d in item.SalesReturnDetail.ToList())
{
AutoPartDetail detail = db.AutoPartDetail.FirstOrDefault(a => a.Id == d.PartDetailId);
detail.Quantity -= d.Quantity;
foreach (var payment in d.SalesPayments.ToList())
{
item.AmountUsed -= payment.Amount;
db.DeleteObject(payment);
}
db.DeleteObject(d);
}
}
//Update details
item.MemoNumber = model.MemoNumber;
item.CustomerId = model.CustomerId;
item.ReturnDate = model.ReturnDate;
item.AmountReturn = model.AmountReturn;
item.Adjustment = model.Adjustment;
item.TotalCreditAmount = model.TotalCreditAmount;
item.Remarks = model.Remarks;
item.IsDeleted = model.IsDeleted;
item.RecordedBy = model.RecordedByUser;
item.ApprovedBy = model.ApprovedByUser;
//Add the new items
if (model.Details.Count > 0)
{
foreach (SalesReturnDetailModel d in model.Details)
{
var autoPart = db.AutoPartDetail.FirstOrDefault(a => a.Id == d.PartDetailId);
autoPart.Quantity += d.Quantity;
SalesReturnDetail detail = new SalesReturnDetail()
{
SalesReturn = item,
AutoPartDetail = autoPart,
InvoiceNumber = d.InvoiceNumber,
Quantity = d.Quantity,
UnitPrice = d.UnitPrice,
TotalAmount = d.TotalAmount,
Balance = d.TotalAmount
};
}
}
}
string action = string.Format("Updated Sales Return - {0}", item.MemoNumber);
this.actionLogController.AddToLog(action, UserInfo.UserId);
this.unitOfWork.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
