public JsonResult creatRecord(string para01, string para02, string para03)
{
var b_id = para01;
int num;
int.TryParse(para02, out num);
var date = Convert.ToDateTime(para03);
SALES_LOT sALES_LOT = new SALES_LOT();
PRODUCT pRODUCT = db.PRODUCT.Find(b_id);
sALES_LOT.PRODUCT = pRODUCT;
PRODUCT_ATTRIBUTE pRODUCT_ATTRIBUTE = db.PRODUCT_ATTRIBUTE.Find(pRODUCT.PRODUCT_ID);
sALES_LOT.BATCH_ID = b_id;
sALES_LOT.PRODUCT.PRODUCT_ID = pRODUCT.PRODUCT_ID;
sALES_LOT.PRODUCT.PRODUCT_ATTRIBUTE.PRODUCT_NAME = pRODUCT_ATTRIBUTE.PRODUCT_NAME;
sALES_LOT.LOT_NUMBER = num;
sALES_LOT.MONEY = num * pRODUCT_ATTRIBUTE.SELL_PRICE * pRODUCT.DISCOUNT;
sALES_LOT.LOT_DATE = date;
db.SALES_LOT.Add(sALES_LOT);
db.SaveChanges();
var list = db.SALES_LOT.Select(n => new { BATCH_ID = n.BATCH_ID, PRODUCT_ID = n.PRODUCT.PRODUCT_ID, PRODUCT_NAME = n.PRODUCT.PRODUCT_ATTRIBUTE.PRODUCT_NAME, LOT_NUMBER = n.LOT_NUMBER, MONEY = n.MONEY, LOT_DATE = n.LOT_DATE });
return(Json(new { code = 0, msg = "", count = 1000, data = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteConfirmed(string id)
{
SALES_LOT sALES_LOT = db.SALES_LOT.Find(id);
db.SALES_LOT.Remove(sALES_LOT);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "BATCH_ID,LOT_DATE,INCOME_ID,MONEY,LOT_NUMBER")] SALES_LOT sALES_LOT)
{
if (ModelState.IsValid)
{
db.Entry(sALES_LOT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.INCOME_ID = new SelectList(db.INCOME, "INCOME_ID", "TYPE", sALES_LOT.INCOME_ID);
return(View(sALES_LOT));
}
// GET: SALES_LOT/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SALES_LOT sALES_LOT = db.SALES_LOT.Find(id);
if (sALES_LOT == null)
{
return(HttpNotFound());
}
return(View(sALES_LOT));
}
// GET: SALES_LOT/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SALES_LOT sALES_LOT = db.SALES_LOT.Find(id);
if (sALES_LOT == null)
{
return(HttpNotFound());
}
ViewBag.INCOME_ID = new SelectList(db.INCOME, "INCOME_ID", "TYPE", sALES_LOT.INCOME_ID);
return(View(sALES_LOT));
}
