protected void BtnRetrieveGR_Click(object sender, EventArgs e)
{
statusMessage.Text = string.Empty;
PurchasingLogic pl = new PurchasingLogic();
int grNumber = Utility.Utility.GetValidPrimaryKeyInt(TxtGRNumber.Text);
GoodReceipt goodReceipt = pl.GetGoodsReceipt(grNumber);
List <GoodReceiptDetail> grDetailList = pl.GetGoodsReceiptDetails(grNumber);
if (grDetailList.Count == 0 || grNumber == -1)
{
ClearAllControls();
statusMessage.Text = "No such Goods Receipt number exist.";
statusMessage.ForeColor = Color.Red;
DisplayEmptyGrid();
}
else
{
LblDoNumber.Text = goodReceipt.DONumber;
LblPoNumber.Text = goodReceipt.PONumber.ToString();
LblClerkName.Text = goodReceipt.ReceivedBy;
LblGRDate.Text = ((DateTime)goodReceipt.DateProcessed).ToString("d");
GridViewGR.DataSource = grDetailList;
GridViewGR.DataBind();
}
}
//Method for Posting GR
public int CreateGoodsReceipt(DateTime dateProcessed, int poNumber, string receivedBy, string doNumber)
{
using (SA45Team12AD ctx = new SA45Team12AD())
{
GoodReceipt goodReceipt = new GoodReceipt
{
PONumber = poNumber,
ReceivedBy = receivedBy,
DateProcessed = dateProcessed,
DONumber = doNumber
};
ctx.GoodReceipts.Add(goodReceipt);
ctx.SaveChanges();
return(goodReceipt.GRNumber);
}
}
public ActionResult IssueReceipt(GoodReceipt gr)
{
try
{
using (sithar_dbEntities1 db = new sithar_dbEntities1())
{
db.GoodReceipts.Add(gr);
db.SaveChanges();
}
// TODO: Add insert logic here
return(RedirectToAction("Initial"));
}
catch
{
return(View());
}
}
static void Main(string[] args)
{
Console.WriteLine("Товары в наличие: ");
Sales s = new Sales(1, "Table", 5, 500, true);
s.Print();
Console.WriteLine("");
Console.WriteLine("Осталось на складе: ");
Stored st = new Stored(1, "Table", 3, 500, true, 2);
st.Print();
Console.WriteLine("");
Console.WriteLine("Перемещено товара");
Moving m = new Moving(1, "Table", 2, "Shop");
m.Print();
Console.WriteLine("");
Console.WriteLine("Получено товара: ");
GoodReceipt gr = new GoodReceipt(1, "Table", 3, 400.5);
gr.Print();
}
public override void OnBeforeSave(object sender, EventArgs <GoodReceipt> args)
{
try
{
GoodReceipt good = args.Item;
var lstDetail = good.Details;
string query = string.Format("select U_PerentOfQuantity from CfgEnterprise");
int count = iVendQuery.iVendRunQuery(query);
var message = new StringBuilder();
foreach (var item in lstDetail)
{
var orderQuantity = item.QuantityOrdered;
var receiptQuanty = item.QuantityReceivable;
var orderQty1 = orderQuantity - count;
var orderQty2 = orderQuantity + count;
if (orderQty1 > receiptQuanty || receiptQuanty > orderQty2)
{
if (message.Length == 0)
{
message.AppendLine("Số lượng mặt hàng nhận không được ít hơn hoặc vượt quá " + count + " so với số lượng đặt hàng:");
}
message.AppendLine(" - Sản phẩm " + item.ProductId + ": " + item.ProductDescription);
}
}
if (message.Length > 0)
{
XtraMessageBox.Show(message.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
args.Cancel = true;
return;
}
}
catch (System.Exception ex)
{
var className = this.GetType().FullName + "." + System.Reflection.MethodBase.GetCurrentMethod().Name;
LogGoodReceip.WriteLog(LogType.ERROR, className, ex.Message);
}
}
