public ActionResult InserOrder(T_OrderHeaderModel T_Orderheader, List <T_OrderDetailModel> T_OrderDetail) { Order_InputBL oib = new Order_InputBL(); DataTable dtorderdetail = new DataTable(); using (var reader = ObjectReader.Create(T_OrderDetail, "OrderID", "AdminCD", "OrderItem", "StockItem", "SalePrice", "TotalAmount", "Memo", "AvailableShippingDate")) { dtorderdetail.Load(reader); } if (dtorderdetail.Rows.Count > 0) { if (Session["CompanyCD"] != null) { string CompanyCD = Session["CompanyCD"].ToString(); T_Orderheader.UpdateOperator = CompanyCD; } T_Orderheader.AccessPC = System.Environment.MachineName; if (oib.Order_Input_Insert(T_Orderheader, dtorderdetail)) { Session["Error"] = null; return(Json(new { orderid = T_Orderheader.OrderID }, JsonRequestBehavior.AllowGet)); //return View();//RedirectToAction("../Order/Order_History/" + T_Orderheader.OrderID); } else { Session["Error"] = "Error"; return(Json(new { msg = "Error" })); } } else { Session["Error"] = "Error"; return(Json(new { msg = "Error" })); } }
public string Order_Input_M_SKU_Select(string id) { //String MakerItem = Session["MakerItem"] as string; DataSet dsk = new DataSet(); dsk = Session["dtsmitem"] as DataSet; Order_InputBL oib = new Order_InputBL(); DataTable dt = new DataTable(); //string[] itemcd = MakerItem.Split(','); int i = Convert.ToInt32(id); if (dsk.Tables.Count > i && dsk.Tables["Table" + id].Rows.Count > 0) { DataTable dttemp = dsk.Tables["Table" + id].Copy(); string mcd = dttemp.Rows[0]["MakerItemCD"].ToString(); //itemcd[i].ToString(); dt = oib.Order_Input_M_SKU(mcd); if (dt.Rows.Count > 0) { string jsonresult; jsonresult = JsonConvert.SerializeObject(dt); return(jsonresult); } } return(null); }
public ActionResult Order_Input(string id) { Order_InputBL obl = new Order_InputBL(); M_JobTimeableModel Mjob = new M_JobTimeableModel(); DataSet dst = new DataSet(); // string ItemCD = "cps-test,cd"; dst = obl.Order_Input_M_Item_Data(id); DataSet dsnew = new DataSet(); String Img_Name = ""; if (dst.Tables.Count > 0) { int tabcount = 0; int count = dst.Tables.Count; for (int i = 0; i < count; i++) { if (dst.Tables[i].Rows.Count == 0) { dst.Tables.RemoveAt(i); count--; i--; } else { DataTable dtnew = dst.Tables[i]; Img_Name += dtnew.Rows[0]["ImageName"].ToString() + ","; dtnew.Columns.Remove("ImageName"); dtnew.TableName = "Table" + tabcount; tabcount++; //dsnew.Tables.Add(dst.Tables[i].Copy()); dsnew.Tables.Add(dtnew.Copy()); } } } if (!string.IsNullOrWhiteSpace(Img_Name) && Img_Name.Contains(",")) { Img_Name = Img_Name.Remove(Img_Name.Length - 1); } ViewBag.ImageName = Img_Name; Session["MakerItem"] = id; ViewBag.count = dsnew.Tables.Count; Session["dtsmitem"] = dsnew; if (Session["CompanyCD"] != null) { Mjob.CompanyCD = Session["CompanyCD"].ToString(); ViewData["JobTime"] = obl.JobTimeTable_Select(Mjob); return(View()); } else { ViewData["JobTime"] = Mjob; return(View()); } }
public string ShippingName_Select(string id) { DataTable dt = new DataTable(); Order_InputBL oib = new Order_InputBL(); string jsonresult; string CompanyCD = ""; if (Session["CompanyCD"] != null) { CompanyCD = Session["CompanyCD"].ToString(); } dt = oib.ShippingName_Select(CompanyCD, Convert.ToInt32(id)); jsonresult = JsonConvert.SerializeObject(dt); return(jsonresult); }
public ActionResult Order_Portal() { M_JobTimeableModel Mjob = new M_JobTimeableModel(); if (Session["CompanyCD"] != null) { Order_InputBL obl = new Order_InputBL(); Mjob.CompanyCD = Session["CompanyCD"].ToString(); ViewData["JobTime"] = obl.JobTimeTable_Select(Mjob); return(View()); } else { ViewData["JobTime"] = Mjob; return(View()); } }