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);
}
}
}
