public bool AgregarDetalleMOLines(int idmolines, DataTable dtCharge)
{
List <wh_molinesdetalles> lista = new List <wh_molinesdetalles>();
foreach (DataRow row in dtCharge.Rows)
{
wh_molinesdetalles linea = new wh_molinesdetalles();
linea.Type = row[2].ToString();
linea.Line = row[3].ToString();
linea.TransactionType = row[4].ToString();
linea.Item = row[5].ToString();
linea.Rev = row[6].ToString();
linea.SourceSubinv = row[7].ToString();
linea.SourceLocator = row[8].ToString();
linea.DestinationSubinv = row[9].ToString();
linea.DestinationLocator = row[10].ToString();
linea.UOM = row[17].ToString();
linea.TransactionQty = int.Parse(row[18].ToString());
linea.RequestedQty = int.Parse(row[19].ToString());
linea.AllocatedQty = int.Parse(row[22].ToString());
linea.DateRequired = DateTime.Parse(row[30].ToString());
linea.Reason = row[31].ToString();
linea.Reference = row[32].ToString();
linea.LineStatus = row[40].ToString();
linea.StatusDate = DateTime.Parse(row[41].ToString());
linea.CreatedBy = row[42].ToString();
linea.wh_molines_Id = idmolines;
lista.Add(linea);
}
db.wh_molinesdetalles.AddRange(lista);
db.SaveChanges();
return(true);
}
public ActionResult VistaDetalles(string mo)
{
List <wh_molinesdetalles> listaMalos = new List <wh_molinesdetalles>();
var motemp = db.wh_LineasMO.Where(x => x.wh_moveorder.NumOrder.Equals(mo)).ToList();
var linemo = db.wh_molinesdetalles.Where(x => x.wh_molines.NumOrder.Equals(mo)).ToList();
foreach (var item in linemo)
{
var skutemp = motemp.Where(x => x.Item.Contains(item.Item)).FirstOrDefault();
wh_molinesdetalles wh = new wh_molinesdetalles();
if (skutemp == null)
{
wh.Item = item.Item;
wh.AllocatedQty = item.AllocatedQty;
wh.TransactionQty = 0;
listaMalos.Add(wh);
}
else
{
int?qtymoline = item.AllocatedQty;
int qtymo = motemp.Where(x => x.Item.Contains(item.Item)).Sum(x => int.Parse(x.Qty));
if (qtymo != qtymoline)
{
wh.Item = item.Item;
wh.AllocatedQty = qtymoline;
wh.TransactionQty = qtymo;
listaMalos.Add(wh);
}
}
}
return(View(listaMalos));
}
public ActionResult ObtenerMOLines()
{
var Draw = Request.Form.GetValues("draw").FirstOrDefault();
var Start = Request.Form.GetValues("start").FirstOrDefault();
var Length = Request.Form.GetValues("length").FirstOrDefault();
var SortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault();
var SortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var orden = Request.Form.GetValues("columns[0][search][value]").FirstOrDefault();
int PageSize = Length != null?Convert.ToInt32(Length) : 0;
int Skip = Start != null?Convert.ToInt32(Start) : 0;
int TotalRecords = 0;
List <wh_molinesdetalles> lista = new List <wh_molinesdetalles>();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionGlobal"].ToString()))
{
con.Open();
string sql = "exec [SP_MOLinesIndex_ParametrosOpcionales] @numeroorden";
var query = new SqlCommand(sql, con);
if (orden != "")
{
query.Parameters.AddWithValue("@numeroorden", orden);
}
else
{
query.Parameters.AddWithValue("@numeroorden", DBNull.Value);
}
using (var dr = query.ExecuteReader())
{
while (dr.Read())
{
// facturas
var linea = new wh_molinesdetalles();
linea.Id = Convert.ToInt32(dr["Id"]);
linea.MoNumber = dr["NumOrder"].ToString();
linea.Type = dr["Type"].ToString();
linea.Line = dr["Line"].ToString();
linea.TransactionType = dr["TransactionType"].ToString();
linea.Item = dr["Item"].ToString();
linea.Rev = dr["Rev"].ToString();
linea.SourceSubinv = dr["SourceSubinv"].ToString();
linea.SourceLocator = dr["SourceLocator"].ToString();
linea.DestinationSubinv = dr["DestinationSubinv"].ToString();
linea.DestinationLocator = dr["DestinationLocator"].ToString();
linea.UOM = dr["UOM"].ToString();
linea.TransactionQty = int.Parse(dr["TransactionQty"].ToString());
linea.RequestedQty = int.Parse(dr["RequestedQty"].ToString());
linea.AllocatedQty = int.Parse(dr["AllocatedQty"].ToString());
//linea.DateRequired = dr["DateRequired"].ToString();
linea.Reason = dr["Reason"].ToString();
linea.Reference = dr["Reference"].ToString();
linea.LineStatus = dr["LineStatus"].ToString();
//linea.StatusDate = dr["StatusDate"].ToString();
linea.CreatedBy = dr["CreatedBy"].ToString();
lista.Add(linea);
}
}
}
if (!(string.IsNullOrEmpty(SortColumn) && string.IsNullOrEmpty(SortColumnDir)))
{
lista = lista.OrderBy(SortColumn + " " + SortColumnDir).ToList();
}
TotalRecords = lista.ToList().Count();
var NewItems = lista.Skip(Skip).Take(PageSize == -1 ? TotalRecords : PageSize).ToList();
return(Json(new { draw = Draw, recordsFiltered = TotalRecords, recordsTotal = TotalRecords, data = NewItems }, JsonRequestBehavior.AllowGet));
}