public static bool sbrActuProductoMaterial()
{
bool vOk = false;
string vSql = "ALTER TABLE dbo.GC_ProductoMaterial ADD " +
"Activo int NOT NULL CONSTRAINT DF_GC_ProductoMaterial_Activo DEFAULT 1, " +
"Peso decimal(18, 4) NOT NULL CONSTRAINT DF_GC_ProductoMaterial_Peso DEFAULT 0 ";
int viOk = 1;
if (!fncExisteCampo("GC_ProductoMaterial", "Activo"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
vSql = "ALTER TABLE dbo.GC_ProductoMaterial ADD " +
"Color nvarchar(50) NOT NULL CONSTRAINT DF_GC_ProductoMaterial_Color DEFAULT ''";
viOk = 1;
if (!fncExisteCampo("GC_ProductoMaterial", "Color"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public bool fncGrabaCampo(string vCampo, string vValor)
{
bool vOk = false;
int viOk = 1;
if ((vCamposIndice.LastIndexOf("," + vCampo + ",") == -1))
{
string vSql = "";
string vWhere = " Id = " + _Id;
vSql = cConstantes.SQL_UP_Update;
vSql = vSql.Replace("[?1]", "[" + vCampo + "]");
vSql = vSql.Replace("[?2]", vValor);
vSql = vSql.Replace("[?3]", vWhere);
vSql = vSql.Replace("[?99]", vTabla);
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
}
else
{
vOk = false;
}
return(vOk);
}
public static bool sbrActuOrdenProdCajas()
{
bool vOk = false;
string vSql = "ALTER TABLE dbo.GC_OrdenProdCajas ADD " +
"Maquina nvarchar(20) NOT NULL CONSTRAINT DF_GC_OrdenProdCajas_Maquina DEFAULT '' " +
"ALTER TABLE dbo.GC_OrdenProdCajas SET (LOCK_ESCALATION = TABLE) ";
int viOk = 1;
if (!fncExisteCampo("GC_OrdenProdCajas", "Maquina"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
//vSql = "ALTER TABLE dbo.GC_ClienteProducto ADD EtiDes nvarchar(50) NOT NULL CONSTRAINT DF_GC_ClienteProducto_EtiDes DEFAULT '' " +
// "ALTER TABLE dbo.GC_ClienteProducto SET (LOCK_ESCALATION = TABLE)";
//if (!fncExisteCampo("GC_ClienteProducto", "EtiDes"))
//{
// viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
//}
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool sbrActuOperarios()
{
bool vOk = false;
string vSql = "";
int viOk = 1;
if (viOk == 1)
{
vSql = "ALTER TABLE dbo.GC_Operarios ADD " +
"TasaHR int NOT NULL CONSTRAINT DF_GC_Operarios_TasaHR DEFAULT 0 " +
"ALTER TABLE dbo.GC_Operarios SET (LOCK_ESCALATION = TABLE)";
if (!fncExisteCampo("GC_Operarios", "TasaHR"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
}
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool sbrActuClienteProducto()
{
bool vOk = false;
string vSql = "ALTER TABLE dbo.GC_ClienteProducto ADD EtiCli int NOT NULL CONSTRAINT DF_GC_ClienteProducto_EtiCli DEFAULT 0 " +
"ALTER TABLE dbo.GC_ClienteProducto SET (LOCK_ESCALATION = TABLE)";
int viOk = 1;
if (!fncExisteCampo("GC_ClienteProducto", "EtiCli"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
vSql = "ALTER TABLE dbo.GC_ClienteProducto ADD EtiDes nvarchar(50) NOT NULL CONSTRAINT DF_GC_ClienteProducto_EtiDes DEFAULT '' " +
"ALTER TABLE dbo.GC_ClienteProducto SET (LOCK_ESCALATION = TABLE)";
if (!fncExisteCampo("GC_ClienteProducto", "EtiDes"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
//public bool fncBaja(string vID)
//{
// bool vOk = false;
// string vSql = "";
// string vWhere = " Id = " + _Id;
// vSql = cConstantes.SQL_UP_Delete;
// vSql = vSql.Replace("[?1]", vWhere);
// vSql = vSql.Replace("[?99]", vTabla);
// int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
// if (viOk == 1)
// {
// vOk = true;
// aCampoModif = "";
// aValor = "";
// aValorAnt = "";
// }
// return vOk;
//}
//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 bool fncAltaLin()
{
bool vOk = false;
try
{
string vTabla = "GC_AlbCli";
string vValoresCab = cUtil.fncCargaValoresSQL(vTabla, cParamXml.strConec, "Id");
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
vDatos[i] = "";
}
int vLin = _Linea;
if (vLin == 0)
{
vLin = fncNumLinea(_NumAlb.ToString());
}
vDatos[1] = _Empresa.ToString();
vDatos[2] = _NumAlb.ToString();
vDatos[3] = vLin.ToString();
vDatos[4] = _FechaEntrega.ToShortDateString();
vDatos[5] = _Producto;
vDatos[6] = _Descripción;
vDatos[7] = _CodCli;
vDatos[8] = _NombreCli;
vDatos[9] = _Cantidad.ToString().Replace(",", ".");
vDatos[10] = _Lote;
vDatos[11] = _Grabado.ToString().Replace(",", ".");
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (vCor == 1)
{
vOk = true;
}
else
{
_Error = "Error al dar de Alta";
}
}
catch (Exception ex)
{
_Error = ex.Message;
vOk = false;
}
return(vOk);
}
public bool fncAlta0(int vIdEnt)
{
bool vOk = false;
try
{
string vTabla = "GC_DirEntregas";
string vValoresCab = cUtil.fncCargaValoresSQL(vTabla, cParamXml.strConec, "Id");
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
vDatos[i] = "";
}
string vDir = _Dirección.Replace("'", " ");
vDir = vDir.Replace(",", " ");
string vPob = _Población.Replace("'", " ");
vDir = vDir.Replace(",", " ");
string vProv = _Provincia.Replace("'", " ");
vDir = vDir.Replace(",", " ");
vDatos[1] = _Empresa.ToString();
vDatos[2] = _CodCli;
vDatos[3] = vIdEnt.ToString();
vDatos[4] = vDir;
vDatos[5] = vPob;
vDatos[6] = vProv;
vDatos[7] = _CP;
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (vCor == 1)
{
vOk = true;
}
else
{
_Error = "Error al dar de Alta";
}
}
catch (Exception ex)
{
_Error = ex.Message;
vOk = false;
}
return(vOk);
}
public bool fncAlta(DataGridViewRow dr)
{
bool vOk = false;
try
{
string vValoresCab = cUtil.fncCargaValoresSQLparaComand(vTabla, cParamXml.strConecProduc_Prueb);
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
int vCont = 1;
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
string vCampo = dr.Cells[i].OwningColumn.Name;
if (vCampo.LastIndexOf("bt") == -1)
{
string vValor = "";
if (dr.Cells[i].Value != null)
{
vValor = dr.Cells[i].Value.ToString();
}
if (vCampo == "Empresa")
{
vValor = "1";
}
vDatos[vCont] = vValor;
vCont++;
}
else
{
//vNumCampos++;
}
}
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConec);
if (vCor == 1)
{
vOk = true;
}
}
catch (Exception ex)
{
vOk = false;
}
return(vOk);
}
public bool fncAltaLin(DataRow dr)
{
bool vOk = false;
string vValores = cUtil.fncCargaValoresSQL(vTabla, cParamXml.strConecProduc_Prueb, "Id");
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValores, "#", 3));
string vCampos = cUtil.Piece(vValores, "#", 2);
vValores = cUtil.Piece(vValores, "#", 1);
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
if (i == 0)
{
vDatos[i] = "";
}
else
{
string vDato = dr[i - 1].ToString();
string vTipo = dr[i - 1].GetType().ToString();
if (vTipo == "System.Double")
{
vDato = vDato.Replace(",", ".");
}
if (vTipo == "System.String")
{
vDato = vDato.Replace("'", " ");
vDato = vDato.Replace(",", " ");
}
vDatos[i] = vDato;
}
}
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValores, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (vCor == 1)
{
vOk = true;
}
else
{
_Error = "Error al dar de Alta la linea de Pedido:" + vSql;
}
return(vOk);
}
public static bool fncAltaEnprod(int vEmp, string vOFL, string vFechaIni,
string vOper, string vNombre, string vMaq, string vDesMaq, string vLote)
{
bool vOk = false;
try
{
string vTabla = "GC_EnProducción";
string vValoresCab = cUtil.fncCargaValoresSQL(vTabla, cParamXml.strConec, "Id");
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
vDatos[i] = "";
}
vDatos[1] = vEmp.ToString();
vDatos[2] = vOFL;
vDatos[3] = vFechaIni;
vDatos[4] = vOper;
vDatos[5] = vNombre;
vDatos[6] = vMaq;
vDatos[7] = vDesMaq;
vDatos[8] = vLote;
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (vCor == 1)
{
vOk = true;
}
else
{
}
}
catch (Exception ex)
{
vOk = false;
}
return(vOk);
}
public static bool fncLanzaOF(int vEmp, string vOFL, string vCompo,
decimal vCanPor, decimal vCanProd,
decimal vCanPen, string vAlm)
{
bool vOk = false;
try
{
string vTabla = "GC_OrdenProdCompo";
string vValoresCab = cUtil.fncCargaValoresSQL(vTabla, cParamXml.strConec, "Id");
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
vDatos[i] = "";
}
vDatos[1] = vEmp.ToString();
vDatos[2] = "Lanzada";
vDatos[3] = vOFL;
vDatos[4] = vCompo;
vDatos[5] = vCanPor.ToString().Replace(",", ".");
vDatos[6] = vCanProd.ToString().Replace(",", ".");;
vDatos[7] = vCanPen.ToString().Replace(",", ".");;
vDatos[8] = vAlm;
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (vCor == 1)
{
vOk = fncCambiarEstado(vEmp.ToString(), vOFL, "Lanzada");
}
else
{
}
}
catch (Exception ex)
{
vOk = false;
}
return(vOk);
}
public bool fncAlta(int vEmpresa, string vTipo, DateTime vFecha, DateTime vFechaHora,
string vAlmacen, string vProducto, string vDescripción, string vCantidad,
string vDocumento, string vOFL, string vUbicación, string vLote)
{
bool vOk = false;
try
{
string vValoresCab = cUtil.fncCargaValoresSQLparaComand(vTabla, cParamXml.strConecProduc_Prueb);
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
int vCont = 1;
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
vDatos[i] = "";
}
vDatos[1] = vEmpresa.ToString();
vDatos[2] = vTipo;
vDatos[3] = vFecha.ToShortDateString();
vDatos[4] = vFechaHora.ToString();
vDatos[5] = vAlmacen;
vDatos[6] = vProducto;
vDatos[7] = vDescripción;
vDatos[8] = vCantidad.ToString().Replace(",", ".");
vDatos[9] = vDocumento;
vDatos[10] = vOFL;
vDatos[11] = vUbicación;
vDatos[12] = vLote;
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConec);
if (vCor == 1)
{
vOk = true;
}
}
catch (Exception ex)
{
vOk = false;
}
return(vOk);
}
public static bool fncGrabaCampoVerif(string vId, string vCampo, string vValor)
{
bool vOk = false;
int viOk = 1;
string vSql = "";
string vWhere = " Id = " + vId;
vSql = cConstantes.SQL_UP_Update;
vSql = vSql.Replace("[?1]", "[" + vCampo + "]");
vSql = vSql.Replace("[?2]", vValor);
vSql = vSql.Replace("[?3]", vWhere);
vSql = vSql.Replace("[?99]", "GC_OrdenProdVerif");
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
return(vOk);
}
public bool fncGrabaCampo(string vCampo, string vValor)
{
bool vOk = false;
int viOk = 1;
if ((vCamposIndice.LastIndexOf("," + vCampo + ",") == -1) | (aValorAnt == ""))
{
if (vValor != aValorAnt)
{
string vSql = "";
string vWhere = " Id = " + _Id;
vSql = cConstantes.SQL_UP_Update;
vSql = vSql.Replace("[?1]", "[" + vCampo + "]");
vSql = vSql.Replace("[?2]", vValor);
vSql = vSql.Replace("[?3]", vWhere);
vSql = vSql.Replace("[?99]", vTabla);
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
if (viOk == 1)
{
vOk = true;
aCampoModif = "";
aValor = "";
aValorAnt = "";
}
else
{
MessageBox.Show(SQLDataAccess.Error);
sbrRollback();
}
}
else
{
if (vValor != "")
{
MessageBox.Show(string.Format("El Campo:{0} es un indice,NO se puede Modificar", aCampoModif));
}
else
{
MessageBox.Show(string.Format("El Campo:{0} es un indice,NO se puede quedar en blanco", aCampoModif));
}
sbrRollback();
}
return(vOk);
}
public static bool sbrActuAlProv()
{
bool vOk = false;
string vSql = "CREATE TABLE GC_AlbProv " +
"( " +
"Id int NOT NULL, " +
"Empresa int NOT NULL, " +
"NumAlb nvarchar(50) NOT NULL, " +
"FechaEntrega date NOT NULL, " +
"Producto nvarchar(50) NOT NULL, " +
"Descripción nvarchar(100) NOT NULL, " +
"CodProv nvarchar(50) NOT NULL, " +
"NombreProv nvarchar(100) NOT NULL, " +
"Cantidad decimal(18, 2) NOT NULL, " +
"Lote nvarchar(50) NOT NULL, " +
"RecepcionadoPor nvarchar(50) NOT NULL " +
") ON [PRIMARY] " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_Empresa DEFAULT ((1)) FOR Empresa " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_NumAlb DEFAULT 0 FOR NumAlb " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_Producto DEFAULT ('') FOR Producto " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_Descripción DEFAULT ('') FOR Descripción " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_CodProv DEFAULT ('') FOR CodProv " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_NombreProv DEFAULT ('') FOR NombreProv " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_Cantidad DEFAULT ((0)) FOR Cantidad " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_Lote DEFAULT '' FOR Lote " +
"ALTER TABLE GC_AlbProv ADD CONSTRAINT " +
" DF_GC_AlbProv_RecepcionadoPor DEFAULT '' FOR RecepcionadoPor " +
"ALTER TABLE GC_AlbProv SET (LOCK_ESCALATION = TABLE) ";
int viOk = 1;
if (!fncExisteTabla("GC_AlbProv"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
return(vOk);
}
public bool fncAlta()
{
bool vOk = false;
try
{
string vValoresCab = cUtil.fncCargaValoresSQL(vTabla, cParamXml.strConec, "Id");
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
vDatos[i] = "";
}
vDatos[1] = _Empresa.ToString();
vDatos[2] = _CodCli;
vDatos[3] = _NomCli;
vDatos[4] = _Producto;
vDatos[5] = _Descripción;
vDatos[6] = _ProductoCli;
vDatos[7] = _EtiCli.ToString();
vDatos[8] = _EtiDes;
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (vCor == 1)
{
vOk = true;
}
else
{
_Error = "Error al dar de Alta";
}
}
catch (Exception ex)
{
_Error = ex.Message;
vOk = false;
}
return(vOk);
}
public bool fncAlta(DataTable dt)
{
bool vOk = false;
string vValores = cUtil.fncCargaValoresSQL(vTabla, cParamXml.strConecProduc_Prueb, "Id");
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValores, "#", 3));
string vCampos = cUtil.Piece(vValores, "#", 2);
vValores = cUtil.Piece(vValores, "#", 1);
foreach (DataRow dr in dt.Rows)
{
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
if (i == 0)
{
vDatos[i] = "";
}
else
{
string vDato = dr[i - 1].ToString();
vDato = vDato.Replace("'", " ");
vDato = vDato.Replace(",", " ");
vDatos[i] = vDato;
}
}
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValores, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (vCor == 1)
{
vOk = true;
}
else
{
//_Error = "Error al dar de Alta";
}
}
return(vOk);
}
public static bool fncBajaVerif(int vId)
{
bool vOk = false;
string vSql = cConstantes.SQL_UP_Delete;
vSql = vSql.Replace("[?1]", " Id = " + vId);
vSql = vSql.Replace("[?99]", "GC_OrdenProdVerif");
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public bool fncCantidadPendiente()
{
bool vOk = false;
string vSql = cConstantes.SQL_Entrega_Update_CanPendiente;
vSql = vSql.Replace("[?id]", _Id.ToString());
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool fncBajaEnprod(int vEmp, string vOFL)
{
bool vOk = false;
string vSql = cConstantes.SQL_UP_Delete;
vSql = vSql.Replace("[?1]", " Empresa = " + vEmp + " and IdOF ='" + vOFL + "' ");
vSql = vSql.Replace("[?99]", "GC_EnProducción");
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool fncAlta(int vEmpresa, string vProceso, DateTime vFecha, string vMError, string vSQL,
int vProcesado, string vUsuario, string vPC)
{
bool vOk = false;
try
{
string vValoresCab = cUtil.fncCargaValoresSQLparaComand(vTabla, cParamXml.strConecProduc_Prueb);
int vNumCampos = Convert.ToInt16(cUtil.Piece(vValoresCab, "#", 3));
string vCampos = cUtil.Piece(vValoresCab, "#", 2);
vValoresCab = cUtil.Piece(vValoresCab, "#", 1);
string vCamposRelp = vCampos.Substring(1, vCampos.Length - 2);
int vCont = 1;
string[] vDatos = new string[vNumCampos];
for (int i = 0; i < vNumCampos; i++)
{
vDatos[i] = "";
}
vDatos[1] = vEmpresa.ToString();
vDatos[2] = vProceso;
vDatos[3] = vFecha.ToString();
vDatos[4] = vMError;
vDatos[5] = vSQL;
vDatos[6] = vProcesado.ToString();
vDatos[7] = vUsuario;
vDatos[8] = vPC;
string vValoresNew = cUtil.fncReplaceValoresSQL(vDatos, vValoresCab, vNumCampos);
string vSql = "INSERT INTO " + vTabla + vCampos + " " + vValoresNew;
int vCor = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConec);
if (vCor == 1)
{
vOk = true;
}
}
catch (Exception ex)
{
vOk = false;
}
return(vOk);
}
public bool fncAlta(string vClave, string vValor)
{
bool vOk = false;
string vSql = Sql_Alta;
vSql = vSql.Replace("[?1]", vClave);
vSql = vSql.Replace("[?2]", vValor);
try
{
SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
vOk = true;
}
catch
{
vOk = false;
}
return(vOk);
}
public static bool fncCantidadFAb(string vEmpresa, string vOFL, string vCan)
{
bool vOk = false;
string vSql = cConstantes.SQL_OrdenProd_Update_Can;
vSql = vSql.Replace("[?2]", vCan);
vSql = vSql.Replace("[?3]", " Empresa = " + vEmpresa + " and IdOF ='" + vOFL + "' ");
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool fncActuCampoModes(string vEmpresa, string vMolde, string vCampo, string vValor)
{
bool vOk = false;
string vSql = cConstantes.SQL_UP_Update;
vSql = vSql.Replace("[?1]", "[" + vCampo + "]");
vSql = vSql.Replace("[?2]", vValor);
vSql = vSql.Replace("[?3]", " Empresa = " + vEmpresa + " and CodMolde ='" + vMolde + "' ");
vSql = vSql.Replace("[?99]", "GC_Moldes");
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool fncFinJornada(int vEmp, string vOper)
{
bool vOk = false;
string vSql = cConstantes.SQL_OF_FinJornada;
vSql = vSql.Replace("[?vbCr]", cConstantes.vbCtr.ToString());
vSql = vSql.Replace("[?vbLf]", cConstantes.vbLF.ToString());
vSql = vSql.Replace("[?Emp]", vEmp.ToString());
vSql = vSql.Replace("[?Oper]", vOper);
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool fncCambiarEstado(string vEmpresa, string vOFL, string vEstado)
{
bool vOk = false;
string vSql = cConstantes.SQL_UP_Update;
vSql = vSql.Replace("[?1]", "[" + "Estado" + "]");
vSql = vSql.Replace("[?2]", vEstado);
vSql = vSql.Replace("[?3]", " Empresa = " + vEmpresa + " and IdOF ='" + vOFL + "' ");
vSql = vSql.Replace("[?99]", "GC_OrdenProd");
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool sbrActuOrdenProd()
{
bool vOk = false;
string vSql = "ALTER TABLE dbo.GC_OrdenProd ADD " +
"Horas decimal(18, 4) NOT NULL CONSTRAINT DF_GC_OrdenProd_Horas DEFAULT 0, " +
"PiezasReales decimal(18, 4) NOT NULL CONSTRAINT DF_GC_OrdenProd_PiezasReales DEFAULT 0, " +
"PiezasNoOk decimal(18, 4) NOT NULL CONSTRAINT DF_GC_OrdenProd_PiezasNoOk DEFAULT 0, " +
"Kilos decimal(18, 4) NOT NULL CONSTRAINT DF_GC_OrdenProd_Kilos DEFAULT 0, " +
"Maquina nvarchar(20) NOT NULL CONSTRAINT DF_GC_OrdenProd_Maquina DEFAULT '', " +
"Ubi nvarchar(50) NOT NULL CONSTRAINT DF_GC_OrdenProd_Ubi DEFAULT '' " +
"ALTER TABLE dbo.GC_OrdenProd SET (LOCK_ESCALATION = TABLE) ";
int viOk = 1;
if (!fncExisteCampo("GC_OrdenProd", "PiezasReales"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
if (viOk == 1)
{
vSql = "ALTER TABLE dbo.GC_OrdenProd ADD " +
"NMaquina AS (replace(left([Maquina],charindex('-',[Maquina])),'-','')) " +
"ALTER TABLE dbo.GC_OrdenProd SET (LOCK_ESCALATION = TABLE) ";
if (!fncExisteCampo("GC_OrdenProd", "NMaquina"))
{
viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
}
}
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool fncGrabaCajaBolsas(string vEmpresa, string vOFL, string vCaja)
{
bool vOk = false;
string vSql = cConstantes.SQL_OF_Graba_CajaBolsas;
vSql = vSql.Replace("[?vbCr]", cConstantes.vbCtr.ToString());
vSql = vSql.Replace("[?vbLf]", cConstantes.vbLF.ToString());
vSql = vSql.Replace("[?Emp]", vEmpresa);
vSql = vSql.Replace("[?OFL]", vOFL);
vSql = vSql.Replace("[?Caja]", vCaja);
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public static bool fncBajaCajaBolsa(string vID)
{
bool vOk = false;
string vTablaCaja = "GC_OrdenProdCajas";
string vSql = "";
string vWhere = " Id = " + vID;
vSql = cConstantes.SQL_UP_Delete;
vSql = vSql.Replace("[?1]", vWhere);
vSql = vSql.Replace("[?99]", vTablaCaja);
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
}
return(vOk);
}
public bool fncBaja(string vID)
{
bool vOk = false;
string vSql = "";
string vWhere = " Id = " + _Id;
vSql = cConstantes.SQL_UP_Delete;
vSql = vSql.Replace("[?1]", vWhere);
vSql = vSql.Replace("[?99]", vTabla);
int viOk = SQLDataAccess.GEN_ExecuteNonQuery(vSql, cParamXml.strConecProduc_Prueb);
if (viOk == 1)
{
vOk = true;
aCampoModif = "";
aValor = "";
aValorAnt = "";
}
return(vOk);
}
