public int fncAlta()
{
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, "", "Id", "Empresa,NumPrep,LinPrep", cParamXml.Emp + "," + _NumPrep + ",");
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConecProduc_Prueb);
_Id = vIdentity;
_NumPrep = 0;
_LinPrep = 0;
_Producto = "";
_Descripción = "";
_Cantidad = 0;
_Lote = "";
_CantidadServida = 0;
_CanPen = 0;
_FechaEntrega = DateTime.Now;
_PedLocal = "";
_LinPedLocal = 0;
_PedCliente = "";
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
int vNumSer = fncTraeIdDir(cParamXml.Emp, _CodCli);
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, cParamXml.strConec, "Id", "Empresa,CodCli,IdEntrega,", cParamXml.Emp + "," + _CodCli + "," + vNumSer.ToString());
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConec);
_Id = vIdentity;
//_NumPed = 0;
//_CodCli = "";
_Dirección = "";
_Población = "";
_Provincia = "";
_CP = "";
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, "", "Id", "Empresa,NumPed,LinPed", cParamXml.Emp + "," + _NumPed + ",");
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConecProduc_Prueb);
_Id = vIdentity;
_NumPed = "0";
_LinPed = 0;
_Producto = "";
_Descripción = "";
_Cantidad = 0;
_CantidadEntregada = 0;
_IVA = 0;
_Precio = 0;
_DTO = 0;
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
string vNumSer = SQLDataAccess.GenTraeNumSerie(cParamXml.NSerPedProv, true, cParamXml.strConec);
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, cParamXml.strConec, "Id", "NumPed,Empresa,Estado,FechaPedido", vNumSer.ToString() + "," + cParamXml.Emp + ",P," + DateTime.Now.ToShortDateString());
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConec);
_Id = vIdentity;
//_NumPed = 0;
_FechaPedido = DateTime.Now;
_FechaEntrega = DateTime.Now;
_CodProv = "";
_NomProv = "";
_Dirección = "";
_Población = "";
_Provincia = "";
_CP = "";
_FPago = "";
_Divisa = "";
_SuPedido = "";
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, "", "Id", "Empresa,NumAlb,Linea", cParamXml.Emp + "," + _NumAlb + ",");
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConecProduc_Prueb);
_Id = vIdentity;
_NumAlb = "0";
_Linea = 0;
_Producto = "";
_Descripción = "";
_Cantidad = 0;
_CodProv = "";
_NombreProv = "";
_Lote = "";
_RecepcionadoPor = "";
_Grabado = 0;
_NumPed = "";
_Obs = "";
_Cert = "";
_Ubi = "";
_NumSerie = "";
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
string vNumSer = SQLDataAccess.GenTraeNumSerie(cParamXml.NSerAlbProv, true, cParamXml.strConec);
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, cParamXml.strConec, "Id", "NumAlb,Empresa,Estado,FechaAlbaran", vNumSer.ToString() + "," + cParamXml.Emp + ",P," + DateTime.Now.ToShortDateString());
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConec);
_Id = vIdentity;
_FechaAlbaran = DateTime.Now;
_CodProv = "";
_NombreProv = "";
_RecepcionadoPor = "";
_NumPed = "";
_SuAlbaran = "";
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, cParamXml.strConec, "Id", "Empresa", cParamXml.Emp.ToString());
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConec);
_Id = vIdentity;
}
catch { }
return(vIdentity);
}
public int fncAlta(string vNumSerie)
{
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, cParamXml.strConec, "Id,CantidadFab", "IdOF,Empresa,Estado,Fecha,FechaEntrega",
vNumSerie + "," + cParamXml.Emp + ",Planificada," + DateTime.Now.ToShortDateString() + "," + DateTime.Now.ToShortDateString());
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConec);
_Id = vIdentity;
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, "", "Id", "Empresa,Producto,Lote", cParamXml.Emp + "," + _Producto + "," + _Lote);
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConecProduc_Prueb);
_Id = vIdentity;
_Producto = "";
_Lote = "";
_Cert = "";
}
catch { }
return(vIdentity);
}
public int fncAlta()
{
//int vNumSer = cUtil.fncTraeNumSerIntDbf("claves", "NPEDCLI", true, cParamXml.strOleDBConecDbf);
string vNumSerie = SQLDataAccess.GenTraeNumSerie(cParamXml.NSerPrep, true, cParamXml.strConec);
int vNumSer = Convert.ToInt32(vNumSerie);
string vValores = cUtil.fncCargaValoresSQLDefault(vTabla, cParamXml.strConec, "Id,Estado", "NumPrep,Empresa,FechaPrep", vNumSer.ToString() + "," + cParamXml.Emp + "," + DateTime.Now.ToShortDateString());
string vCampos = cUtil.Piece(vValores, "#", 2);
string vValoresDef = cUtil.Piece(vValores, "#", 5);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresDef;
int vIdentity = 0;
try
{
vIdentity = SQLDataAccess.GEN_ExecuteScalarIdentity(vSql, cParamXml.strConec);
_Id = vIdentity;
_Estado = "P";
//_NumPed = 0;
_FechaPrep = DateTime.Now;
_FechaEntrega = DateTime.Now;
_CodCli = "";
_NomCli = "";
_Dirección = "";
_Población = "";
_Provincia = "";
_CP = "";
_FPago = "";
_Divisa = "";
_SuPedido = "";
_DtoPP = 0;
_DtoESP = 0;
}
catch { }
return(vIdentity);
}
