private void ChargeEditItem(string IDPEDDET) { FillDDLEditItem(); PedDet.GetItem getItem = new PedDet.GetItem(ID, IDPEDDET, true); if (getItem.IsGot) { object[] Param = new object[] { ID, IDPEDDET, true }; string[] ParamName = new string[] { "IDPEDIDO", "IDPEDDET", "ESTADO" }; SelectRows select = new SelectRows("PLABAL", "ECOM_PEDSUBDET", "IDPEDSUBDET,ALFAKCODE", "IDPEDDET=@IDPEDDET AND IDPEDIDO=@IDPEDIDO AND ESTADO=@ESTADO", Param, ParamName); TxtEditRef.Text = getItem.Item.REFERENCIA; TxtEditAlto.Text = getItem.Item.ALTO.ToString(); TxtEditAncho.Text = getItem.Item.ANCHO.ToString(); TxtEditCant.Text = getItem.Item.CANT.ToString(); if (select.IsGot) { PnlAddDicc.Visible = false; DataRow dr; dr = select.Datos.Rows[0]; DDLEditCREX.SelectedValue = dr[1].ToString(); HdnCREXDET.Value = dr[1].ToString(); HdnIDSUBDETCREEX.Value = dr[0].ToString(); dr = select.Datos.Rows[1]; DDLEditSEP.SelectedValue = dr[1].ToString(); HdnSEPDET.Value = dr[1].ToString(); HdnIDSUBDETSEP.Value = dr[0].ToString(); dr = select.Datos.Rows[2]; DDLEditCRIN.SelectedValue = dr[1].ToString(); HdnCRINDET.Value = dr[1].ToString(); HdnIDSUBDETCRIN.Value = dr[0].ToString(); } else { PnlAddDicc.Visible = true; ChkAddTerminologia.Text = " Agregar al diccionario el término \"" + getItem.Item.TERMINOLOGIA + "\" al Diccionario."; ChkAddTerminologia.Checked = true; } } }
protected void BtnEditItemGo_Click(object sender, EventArgs e) { double Alto; double Ancho; int Cant; bool DoUpdate = true; if (!double.TryParse(TxtEditAlto.Text, out Alto)) { DoUpdate = false; } if (!double.TryParse(TxtEditAncho.Text, out Ancho)) { DoUpdate = false; } if (!int.TryParse(TxtEditCant.Text, out Cant)) { DoUpdate = false; } if (DoUpdate) { object[] Param; string[] ParamName; Getm2yPerim getm2 = new Getm2yPerim(Ancho, Alto); Param = new object[] { TxtEditRef.Text, Cant, Ancho, Alto, HdnIdItemSelected.Value, true, getm2.M2, getm2.M2 *Cant, getm2.Perimetro, getm2.Perimetro *Cant }; ParamName = new string[] { "REFERENCIA", "CANT", "ANCHO", "ALTO", "IDPEDDET", "ESTADO", "M2UN", "M2ITM", "PERIMUN", "PERIMITM" }; UpdateRow update = new UpdateRow("PLABAL", "ECOM_PEDDET", "REFERENCIA=@REFERENCIA,CANT=@CANT,ANCHO=@ANCHO,ALTO=@ALTO,M2UN=@M2UN,M2ITM=@M2ITM,PERIMUN=@PERIMUN,PERIMITM=@PERIMITM", "IDPEDDET=@IDPEDDET AND ESTADO=@ESTADO", Param, ParamName); if (update.Actualizado) { PedDet.GetItem getItem = new PedDet.GetItem(ID, HdnIdItemSelected.Value, true); if (!string.IsNullOrEmpty(HdnAddTerminologia.Value)) { string[] Codigos = new string[] { DDLEditCREX.SelectedValue, DDLEditSEP.SelectedValue, DDLEditCRIN.SelectedValue, "909" }; if (ChkAddTerminologia.Checked) { /*Agregar al diccionario*/ PedDet.AddDiccionario addDiccionario = new PedDet.AddDiccionario(HdnAddTerminologia.Value, Page.User.Identity.Name, rut, Codigos); } /*Ingreso de uno del diccionario*/ PedSubDet.InsertSub insertSub = new PedSubDet.InsertSub(getItem.Item, Codigos, Pedido, Cliente.Margen); if (insertSub.Insertados) { UpdatePLABALRow updatePLABALRow = new UpdatePLABALRow("ECOM_PEDDET", "IDPEDDET", HdnIdItemSelected.Value, "GOTFDICC", true); } } else { /*Actualizacion*/ PedSubDet Sub; bool IsChanged = false; if (HdnCREXDET.Value != "") { IsChanged = true; PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditCREX.SelectedValue, getItem.Item); Sub = costos.Subdets.First(); Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETCREEX.Value, Sub.DESCRIPCION }; ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" }; update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName); } if (HdnCRINDET.Value != "") { IsChanged = true; PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditCRIN.SelectedValue, getItem.Item); Sub = costos.Subdets.First(); Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETCRIN.Value, Sub.DESCRIPCION }; ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" }; update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName); } if (HdnSEPDET.Value != "") { IsChanged = true; PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditSEP.SelectedValue, getItem.Item); Sub = costos.Subdets.First(); Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETSEP.Value, Sub.DESCRIPCION }; ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" }; update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName); } if (IsChanged) { Param = new object[] { HdnIdItemSelected.Value, ID, true }; ParamName = new string[] { "IDPEDDET", "IDPEDIDO", "ESTADO" }; SelectRows select = new SelectRows("PLABAL", "ECOM_PEDSUBDET", "DESCRIPCION", "IDPEDDET=@IDPEDDET AND IDPEDIDO=@IDPEDIDO AND ESTADO=@ESTADO", Param, ParamName); string[] Descrip = new string[select.Datos.Rows.Count]; for (int i = 0; i < 3; i++) { Descrip[i] = select.Datos.Rows[i][0].ToString(); } UpdatePLABALRow updateP = new UpdatePLABALRow("ECOM_PEDDET", "IDPEDDET", HdnIdItemSelected.Value, "DESCRIPCION", string.Join(" || ", Descrip)); } PedDet.Calculos calculos = new PedDet.Calculos(getItem.Item, Pedido, Cliente.Margen); } Response.Redirect("~/View/Cliente/IngresoPedidos/Termopanel.aspx?RUT=" + rut + "&ID=" + ID + "&TOKEN=" + TOKEN); } } }