public void setup_generate_random1(object setup_low_rand, object setup_high_rand)
{
setup_rand_finished = false;
while (!setup_rand_finished)
{
VBMath.Randomize();
setup_random1 = IntegerType.FromObject(Conversion.Int(ObjectType.AddObj(ObjectType.MulObj(ObjectType.AddObj(setup_high_rand, 1), VBMath.Rnd()), 0)));
if (!BooleanType.FromObject(ObjectType.BitAndObj(ObjectType.ObjTst(setup_random1, setup_low_rand, false) >= 0, ObjectType.ObjTst(setup_random1, setup_high_rand, false) <= 0)))
{
continue;
}
setup_rand_finished = true;
}
}
private void cmbAceptar_Click(object sender, EventArgs e)
{
if (BooleanType.FromObject(ObjectType.BitAndObj(StringType.StrCmp(this.cbPackList.Text, Strings.Space(0), false) == 0, ObjectType.ObjTst(this.cbPackList.SelectedValue, Strings.Space(0), false) == 0)))
{
Interaction.MsgBox("Debe seleccionar packing list", 0x10, "Operador");
this.cbPackList.Focus();
}
else
{
this.cbPackList.Enabled = false;
this.cmbAceptar.Enabled = false;
Variables.gPackList = StringType.FromObject(this.cbPackList.SelectedValue);
this.Close();
}
}
private void ParseQ1(string q1Result)
{
string q1Dados = q1Result; // modVariaveis.Q1Dados;
NobreakInfo.TensaoEntrada = !(StringType.StrCmp(Strings.Mid(q1Dados, 2, 3), "@@@", false) != 0 & StringType.StrCmp(Strings.Mid(q1Dados, 6, 1), "@", false) != 0) ? -1.0 : Conversion.Val(Strings.Mid(q1Dados, 2, 3)) + Conversion.Val(Strings.Mid(q1Dados, 6, 1)) / 10.0;
NobreakInfo.TensaoEntrada2 = !(StringType.StrCmp(Strings.Mid(q1Dados, 8, 3), "@@@", false) != 0 & StringType.StrCmp(Strings.Mid(q1Dados, 12, 1), "@", false) != 0) ? -1.0 : Conversion.Val(Strings.Mid(q1Dados, 8, 3)) + Conversion.Val(Strings.Mid(q1Dados, 12, 1)) / 10.0;
NobreakInfo.TensaoSaida = !(StringType.StrCmp(Strings.Mid(q1Dados, 14, 3), "@@@", false) != 0 & StringType.StrCmp(Strings.Mid(q1Dados, 18, 1), "@", false) != 0) ? -1.0 : Conversion.Val(Strings.Mid(q1Dados, 14, 3)) + Conversion.Val(Strings.Mid(q1Dados, 18, 1)) / 10.0;
NobreakInfo.Carga = StringType.StrCmp(Strings.Mid(q1Dados, 20, 3), "@@@", false) == 0 ? -1L : checked ((long)Math.Round(Conversion.Val(Strings.Mid(q1Dados, 20, 3))));
NobreakInfo.Frequencia = !(StringType.StrCmp(Strings.Mid(q1Dados, 24, 2), "@@", false) != 0 & StringType.StrCmp(Strings.Mid(StringType.FromInteger(27), 1), "@", false) != 0) ? -1.0 : Conversion.Val(Strings.Mid(q1Dados, 24, 2)) + Conversion.Val(Strings.Mid(q1Dados, 27, 1)) / 10.0;
NobreakInfo.TensaoBateria = !(StringType.StrCmp(Strings.Mid(q1Dados, 29, 2), "@@", false) != 0 & StringType.StrCmp(Strings.Mid(q1Dados, 32, 1), "@", false) != 0) ? -1.0 : Conversion.Val(Strings.Mid(q1Dados, 29, 2)) + Conversion.Val(Strings.Mid(q1Dados, 32, 1)) / 10.0;
NobreakInfo.Temperatura = !(StringType.StrCmp(Strings.Mid(q1Dados, 34, 2), "@@", false) != 0 & StringType.StrCmp(Strings.Mid(q1Dados, 37, 1), "@", false) != 0) ? -1.0 : Conversion.Val(Strings.Mid(q1Dados, 34, 2)) + Conversion.Val(Strings.Mid(q1Dados, 37, 1)) / 10.0;
NobreakInfo.StatusUtilityFail = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 39, 1), "1", false) == 0, (object)true, (object)false));
NobreakInfo.StatusBateriaBaixa = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 40, 1), "1", false) == 0, (object)true, (object)false));
NobreakInfo.StatusBypassBoostBuckActive = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 41, 1), "1", false) == 0, (object)true, (object)false));
NobreakInfo.StatusFalhaUps = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 42, 1), "1", false) == 0, (object)true, (object)false));
NobreakInfo.StatusUpsStandBy = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 43, 1), "1", false) == 0, (object)true, (object)false));
NobreakInfo.StatusTesteEmProgresso = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 44, 1), "1", false) == 0, (object)true, (object)false));
NobreakInfo.StatusShutdownAtivo = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 45, 1), "1", false) == 0, (object)true, (object)false));
NobreakInfo.StatusBeepLigado = BooleanType.FromObject(Interaction.IIf(StringType.StrCmp(Strings.Mid(q1Dados, 46, 1), "1", false) == 0, (object)true, (object)false));
}
// Find a true element in an array and return the corresponding object.
public static Object Switch(params Object[] VarExpr)
{
if (VarExpr == null)
{
return(null);
}
int len = VarExpr.Length;
if ((len & 1) != 0)
{
throw new ArgumentException(S._("VB_MustBeEvenSized"));
}
int posn;
for (posn = 0; posn < len; posn += 2)
{
if (BooleanType.FromObject(VarExpr[posn]))
{
return(VarExpr[posn + 1]);
}
}
return(null);
}
private void ActTmp()
{
DataRow row;
long num;
SqlDataReader reader;
DateTime time2;
DateTime time3;
string str4;
DataSet dataSet = new DataSet();
DataSet set2 = new DataSet();
this.cmbSalir.Enabled = false;
this.cmbVolver.Enabled = false;
SqlConnection connection = new SqlConnection("data source=" + Variables.gServer + ";user id=scala;password=scala;initial catalog=scalaDB;persist security info=False;packet size=4096");
connection.Open();
SqlConnection connection2 = new SqlConnection("data source=" + Variables.gServer + ";user id=teleprinter;password=tele;initial catalog=Colector;persist security info=False;packet size=4096");
connection2.Open();
int num4 = new SqlCommand("delete " + Variables.gTermi + "TmpCalendario", connection2).ExecuteNonQuery();
SqlCommand command4 = new SqlCommand("delete " + Variables.gTermi + "TmpCalendarioStkComp", connection2);
num4 = command4.ExecuteNonQuery();
string str = "SELECT OR01001,OR01004,OR01016,OR01050,OR03002,OR03005,OR03006,OR03007,OR03011,OR03012,OR03051,OR04002,OR04003,OR04004,OR04005,OR04008 FROM dbo.OR010100 inner join OR030100 on OR010100.OR01001=OR030100.OR03001 inner join OR040100 on OR010100.OR01001=OR040100.OR04001 where OR010100.OR01002=6 and OR010100.OR01091=0 and OR03011-OR03012<>0 and OR03034=1 and (";
if (Variables.gIntr01)
{
str = str + "OR01004='INTR01' ";
if (Variables.gIntr02)
{
str = str + "or OR01004='INTR02' ";
}
if (Variables.gIntr03)
{
str = str + "or OR01004='INTR03' ";
}
if (Variables.gIntr04)
{
str = str + "or OR01004='INTR04' ";
}
}
else if (Variables.gIntr02)
{
str = str + "OR01004='INTR02' ";
if (Variables.gIntr03)
{
str = str + "or OR01004='INTR03' ";
}
if (Variables.gIntr04)
{
str = str + "or OR01004='INTR04' ";
}
}
else if (Variables.gIntr03)
{
str = str + "OR01004='INTR03' ";
if (Variables.gIntr04)
{
str = str + "or OR01004='INTR04' ";
}
}
else if (Variables.gIntr04)
{
str = str + "OR01004='INTR04' ";
}
SqlCommand command3 = new SqlCommand(str + ") order by OR010100.OR01016", connection);
command3.CommandTimeout = 900;
dataSet.Clear();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command3;
adapter.Fill(dataSet, "OR010100");
long num9 = dataSet.Tables["OR010100"].Rows.Count - 1;
for (num = 0L; num <= num9; num += 1L)
{
row = dataSet.Tables["OR010100"].Rows[(int)num];
str4 = "insert into " + Variables.gTermi + "TmpCalendario (FechaEnt,Cliente,ListaRec,NroOA,NroLinea,Codigo,Descripcion,Almacen,Cantidad,AsignadoA,Observaciones,ReqEsp,Horas,SinStock,Obs) values (";
CalcDates dates = new CalcDatesClass();
short daysToDue = 0;
DataRow row3 = row;
string str9 = "OR01016";
DateTime currentDate = DateType.FromObject(row3[str9]);
string dayCountType = "H";
string company = "01";
dates.WeekDate(ref daysToDue, ref currentDate, ref dayCountType, ref company);
row3[str9] = currentDate;
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj((str4 + "'" + Strings.Format(dates.MidDate, "MM/dd/yyyy")) + "','", row["OR01004"]), "','"), row["OR03051"]), "','"), row["OR01001"]), "','"), row["OR03002"]), "','"), row["OR03005"]), "','"), row["OR03006"]), " "), row["OR03007"]), "','"), row["OR01050"]), "',"), ObjectType.SubObj(row["OR03011"], row["OR03012"])), ","));
if (StringType.StrCmp(Strings.Trim(StringType.FromObject(row["OR04002"])), "0", false) == 0)
{
str4 = str4 + "'',";
}
else
{
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(str4 + "'", row["OR04002"]), "',"));
}
if (StringType.StrCmp(Strings.Trim(StringType.FromObject(row["OR04003"])), "0", false) == 0)
{
if (StringType.StrCmp(Strings.Trim(StringType.FromObject(row["OR04004"])), "0", false) == 0)
{
str4 = str4 + "'',";
}
else
{
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(str4 + "'", row["OR04004"]), "',"));
}
}
else if (StringType.StrCmp(Strings.Trim(StringType.FromObject(row["OR04004"])), "0", false) == 0)
{
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(str4 + "'", row["OR04003"]), "',"));
}
else
{
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(str4 + "'", row["OR04003"]), " "), row["OR04004"]), "',"));
}
if (StringType.StrCmp(Strings.Trim(StringType.FromObject(row["OR04005"])), "0", false) == 0)
{
str4 = str4 + "'',";
}
else
{
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(str4 + "'", row["OR04005"]), "',"));
}
command4 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(str4 + "'", row["OR04008"]), "',0,0)")), connection2);
try
{
num4 = command4.ExecuteNonQuery();
}
catch (Exception exception1)
{
ProjectData.SetProjectError(exception1);
Exception exception = exception1;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception.Message, MsgBoxStyle.OKOnly, null);
connection.Close();
connection2.Close();
this.cmbSalir.Enabled = true;
this.cmbVolver.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
command3 = new SqlCommand("SELECT distinct NroOA from " + Variables.gTermi + "TmpCalendario", connection2);
command3.CommandTimeout = 900;
dataSet.Clear();
adapter = new SqlDataAdapter();
adapter.SelectCommand = command3;
adapter.Fill(dataSet, Variables.gTermi + "TmpCalendario");
long num7 = dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows.Count - 1;
for (num = 0L; num <= num7; num += 1L)
{
row = dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows[(int)num];
SqlCommand command = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj("SELECT * from GesEnsObs where NroOE='", row["NroOA"]), "'")), connection2);
reader = command.ExecuteReader();
if (reader.Read())
{
reader.Close();
command4 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj("update " + Variables.gTermi + "TmpCalendario set Obs=1 where NroOA='", row["NroOA"]), "'")), connection2);
try
{
num4 = command4.ExecuteNonQuery();
}
catch (Exception exception8)
{
ProjectData.SetProjectError(exception8);
Exception exception2 = exception8;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception2.Message, MsgBoxStyle.OKOnly, null);
connection.Close();
connection2.Close();
this.cmbSalir.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
else
{
reader.Close();
}
}
command3 = new SqlCommand("SELECT * from " + Variables.gTermi + "TmpCalendario order by FechaEnt", connection2);
command3.CommandTimeout = 900;
dataSet.Clear();
adapter = new SqlDataAdapter();
adapter.SelectCommand = command3;
adapter.Fill(dataSet, Variables.gTermi + "TmpCalendario");
if (dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows.Count != 0)
{
row = dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows[0];
if (DateAndTime.Weekday(DateType.FromObject(row["FechaEnt"]), FirstDayOfWeek.Sunday) > 1)
{
time3 = DateAndTime.DateAdd(DateInterval.Day, (double)((DateAndTime.Weekday(DateType.FromObject(row["FechaEnt"]), FirstDayOfWeek.Sunday) - 1) * -1), DateType.FromObject(row["FechaEnt"]));
}
else
{
time3 = DateType.FromObject(row["FechaEnt"]);
}
}
command3 = new SqlCommand("SELECT * from " + Variables.gTermi + "TmpCalendario order by FechaEnt desc", connection2);
command3.CommandTimeout = 900;
dataSet.Clear();
adapter = new SqlDataAdapter();
adapter.SelectCommand = command3;
adapter.Fill(dataSet, Variables.gTermi + "TmpCalendario");
if (dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows.Count != 0)
{
row = dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows[0];
if (DateAndTime.Weekday(DateType.FromObject(row["FechaEnt"]), FirstDayOfWeek.Sunday) < 7)
{
time2 = DateAndTime.DateAdd(DateInterval.Day, (double)(7 - DateAndTime.Weekday(DateType.FromObject(row["FechaEnt"]), FirstDayOfWeek.Sunday)), DateType.FromObject(row["FechaEnt"]));
}
else
{
time2 = DateType.FromObject(row["FechaEnt"]);
}
}
while (DateTime.Compare(time3, time2) <= 0)
{
SqlCommand command2 = new SqlCommand("SELECT * FROM " + Variables.gTermi + "TmpCalendario where FechaEnt='" + Strings.Format(time3, "MM/dd/yyyy") + "'", connection2);
reader = command2.ExecuteReader();
if (reader.Read())
{
reader.Close();
}
else
{
reader.Close();
reader = new SqlCommand("SELECT * FROM dbo.SYHO0100 where SYHO001='" + Strings.Format(time3, "MM/dd/yyyy") + "'", connection).ExecuteReader();
if (reader.Read())
{
command4 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj((("insert into " + Variables.gTermi + "TmpCalendario (FechaEnt,Observaciones) values (") + "'" + Strings.Format(time3, "MM/dd/yyyy") + "',") + "'", reader["SYHO002"]), "')")), connection2);
reader.Close();
}
else
{
command4 = new SqlCommand(("insert into " + Variables.gTermi + "TmpCalendario (FechaEnt) values (") + "'" + Strings.Format(time3, "MM/dd/yyyy") + "')", connection2);
reader.Close();
}
try
{
num4 = command4.ExecuteNonQuery();
}
catch (Exception exception9)
{
ProjectData.SetProjectError(exception9);
Exception exception3 = exception9;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception3.Message, MsgBoxStyle.OKOnly, null);
connection.Close();
connection2.Close();
this.cmbSalir.Enabled = true;
this.cmbVolver.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
time3 = DateAndTime.DateAdd(DateInterval.Day, 1.0, time3);
}
command3 = new SqlCommand("SELECT * from " + Variables.gTermi + "TmpCalendario where not Codigo is null order by NroOA,NroLinea", connection2);
command3.CommandTimeout = 900;
dataSet.Clear();
adapter = new SqlDataAdapter();
adapter.SelectCommand = command3;
adapter.Fill(dataSet, Variables.gTermi + "TmpCalendario");
long num6 = dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows.Count - 1;
for (num = 0L; num <= num6; num += 1L)
{
row = dataSet.Tables[Variables.gTermi + "TmpCalendario"].Rows[(int)num];
command3 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj("SELECT OR03005,OR03006,OR03007,OR03011,OR03012,SC03003,SC03004,SC03005 FROM dbo.OR030100 inner join SC030100 on OR030100.OR03005=SC030100.SC03001 where OR03001='", row["NroOA"]), "' and OR03002='"), row["NroLinea"]), "' and OR03003<>'000' and SC03002='"), row["Almacen"]), "'")), connection);
command3.CommandTimeout = 900;
set2.Clear();
SqlDataAdapter adapter2 = new SqlDataAdapter();
adapter2.SelectCommand = command3;
adapter2.Fill(set2, "OR030100");
bool flag = false;
long num5 = set2.Tables["OR030100"].Rows.Count - 1;
for (long i = 0L; i <= num5; i += 1L)
{
DataRow row2 = set2.Tables["OR030100"].Rows[(int)i];
if (BooleanType.FromObject(ObjectType.BitOrObj(ObjectType.ObjTst(row2["SC03003"], 0, false) <= 0, ObjectType.ObjTst(ObjectType.AddObj(row2["SC03004"], row2["SC03005"]), row2["SC03003"], false) > 0)))
{
flag = true;
}
if (ObjectType.ObjTst(ObjectType.AddObj(row2["SC03004"], row2["SC03005"]), row2["SC03003"], false) > 0)
{
reader = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj("SELECT PC03043,PC03044,PC03016 FROM dbo.PC030100 where PC03005='", row2["OR03005"]), "' and PC03043<PC03044 and PC03029=1 ")) + "and PC03035='", row["Almacen"]), "' order by PC03016")), connection).ExecuteReader();
if (reader.Read())
{
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj("insert into " + Variables.gTermi + "TmpCalendarioStkComp (NroOA,NroLinea,CodComp,DescComp,Cantidad,StkFisico,StkComprometido,FechaOC,CantOC) values ('", row["NroOA"]), "','"), row["NroLinea"]), "','"), row2["OR03005"]), "','"), row2["OR03006"]), " "), row2["OR03007"]), "',"), ObjectType.SubObj(row2["OR03011"], row2["OR03012"])), ","), row2["SC03003"]), ","), ObjectType.AddObj(row2["SC03004"], row2["SC03005"])), ",'"), Strings.Format(RuntimeHelpers.GetObjectValue(reader["PC03016"]), "MM/dd/yyyy")), "',"), ObjectType.SubObj(reader["PC03044"], reader["PC03043"])), ")"));
reader.Close();
command4 = new SqlCommand(str4, connection2);
try
{
num4 = command4.ExecuteNonQuery();
}
catch (Exception exception10)
{
ProjectData.SetProjectError(exception10);
Exception exception4 = exception10;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception4.Message, MsgBoxStyle.OKOnly, null);
connection.Close();
connection2.Close();
this.cmbSalir.Enabled = true;
this.cmbVolver.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
else
{
reader.Close();
command4 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj("insert into " + Variables.gTermi + "TmpCalendarioStkComp (NroOA,NroLinea,CodComp,DescComp,Cantidad,StkFisico,StkComprometido) values ('", row["NroOA"]), "','"), row["NroLinea"]), "','"), row2["OR03005"]), "','"), row2["OR03006"]), " "), row2["OR03007"]), "',"), ObjectType.SubObj(row2["OR03011"], row2["OR03012"])), ","), row2["SC03003"]), ","), ObjectType.AddObj(row2["SC03004"], row2["SC03005"])), ")")), connection2);
try
{
num4 = command4.ExecuteNonQuery();
}
catch (Exception exception11)
{
ProjectData.SetProjectError(exception11);
Exception exception5 = exception11;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception5.Message, MsgBoxStyle.OKOnly, null);
connection.Close();
connection2.Close();
this.cmbSalir.Enabled = true;
this.cmbVolver.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
}
else
{
command4 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj("insert into " + Variables.gTermi + "TmpCalendarioStkComp (NroOA,NroLinea,CodComp,DescComp,Cantidad,StkFisico,StkComprometido) values ('", row["NroOA"]), "','"), row["NroLinea"]), "','"), row2["OR03005"]), "','"), row2["OR03006"]), " "), row2["OR03007"]), "',"), ObjectType.SubObj(row2["OR03011"], row2["OR03012"])), ","), row2["SC03003"]), ","), ObjectType.AddObj(row2["SC03004"], row2["SC03005"])), ")")), connection2);
try
{
num4 = command4.ExecuteNonQuery();
}
catch (Exception exception12)
{
ProjectData.SetProjectError(exception12);
Exception exception6 = exception12;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception6.Message, MsgBoxStyle.OKOnly, null);
connection.Close();
connection2.Close();
this.cmbSalir.Enabled = true;
this.cmbVolver.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
}
if (flag)
{
command4 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj("update " + Variables.gTermi + "TmpCalendario set SinStock=1 where NroOA='", row["NroOA"]), "'")), connection2);
try
{
num4 = command4.ExecuteNonQuery();
}
catch (Exception exception13)
{
ProjectData.SetProjectError(exception13);
Exception exception7 = exception13;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception7.Message, MsgBoxStyle.OKOnly, null);
connection.Close();
connection2.Close();
this.cmbSalir.Enabled = true;
this.cmbVolver.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
}
connection.Close();
connection2.Close();
}
private void cmbAceptar_Click(object sender, EventArgs e)
{
DataSet dataSet = new DataSet();
DataSet set2 = new DataSet();
bool flag = false;
if (BooleanType.FromObject(ObjectType.BitAndObj(StringType.StrCmp(this.cbAlmacen.Text, Strings.Space(0), false) == 0, ObjectType.ObjTst(this.cbAlmacen.SelectedValue, Strings.Space(0), false) == 0)))
{
Interaction.MsgBox("Debe seleccionar almac\x00e9n", MsgBoxStyle.Critical, "Operador");
this.cbAlmacen.Focus();
}
else if (((StringType.StrCmp(this.editDesdeRack.Text, Strings.Space(0), false) == 0) & (StringType.StrCmp(this.editHastaRack.Text, Strings.Space(0), false) != 0)) | ((StringType.StrCmp(this.editDesdeRack.Text, Strings.Space(0), false) != 0) & (StringType.StrCmp(this.editHastaRack.Text, Strings.Space(0), false) == 0)))
{
Interaction.MsgBox("Debe indicar desde y hasta rack", MsgBoxStyle.Critical, "Operador");
this.editDesdeRack.Focus();
}
else
{
this.cmbAceptar.Enabled = false;
this.cmbSalir.Enabled = false;
Variables.gFechaInv = this.dtpFechaInv.Value;
Variables.gCodAlmacen = StringType.FromObject(this.cbAlmacen.SelectedValue);
Variables.gNomAlmacen = this.cbAlmacen.Text;
Variables.gDesdeRack = Strings.Trim(this.editDesdeRack.Text);
Variables.gHastaRack = Strings.Trim(this.editHastaRack.Text);
string connectionString = "data source=" + Variables.gServer + ";user id=teleprinter;password=tele;initial catalog=Colector;persist security info=False;packet size=4096";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
flag = true;
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM dbo.RepDifInv where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' and DesdeRack='" + Variables.gDesdeRack + "' and HastaRack='" + Variables.gHastaRack + "' and Almacen='" + Variables.gCodAlmacen + "'", connectionString);
adapter.Fill(dataSet, "RepDifInv");
if (dataSet.Tables["RepDifInv"].Rows.Count != 0)
{
Interaction.MsgBox("Ya se gener\x00f3 diferencia de inventario sobre estos datos", MsgBoxStyle.Critical, "Operador");
if (flag)
{
transaction.Rollback();
flag = false;
}
connection.Close();
this.cmbAceptar.Enabled = true;
this.cmbSalir.Enabled = true;
this.cmbAceptar.Focus();
}
else
{
dataSet.Tables["RepDifInv"].Rows.Clear();
adapter = new SqlDataAdapter("SELECT Fecha FROM dbo.Inventario where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "'", connectionString);
adapter.Fill(dataSet, "Inventario");
if (dataSet.Tables["Inventario"].Rows.Count == 0)
{
Interaction.MsgBox("No se realizo inventario f\x00edsico en la fecha indicada", MsgBoxStyle.Critical, "Operador");
if (flag)
{
transaction.Rollback();
flag = false;
}
connection.Close();
this.cmbAceptar.Enabled = true;
this.cmbSalir.Enabled = true;
this.cmbAceptar.Focus();
}
else
{
DataRow row;
long num;
int num2;
SqlCommand command3;
string str;
string str2;
dataSet.Tables["Inventario"].Rows.Clear();
if (Strings.Len(Variables.gDesdeRack) == 2)
{
str = "SELECT SC03001,SC03002,SC03003,SC01002,SC01003,SC03013 FROM dbo.SC030100 INNER JOIN SC010100 on SC03001=SC01001 where SC03003<>0 and SC03002='" + Variables.gCodAlmacen + "' and substring(SC03013,3,2)>='" + Variables.gDesdeRack + "' and substring(SC03013,3,2)<='" + Variables.gHastaRack + "'";
}
else if (Strings.Len(Variables.gDesdeRack) == 1)
{
str = "SELECT SC03001,SC03002,SC03003,SC01002,SC01003,SC03013 FROM dbo.SC030100 INNER JOIN SC010100 on SC03001=SC01001 where SC03003<>0 and SC03002='" + Variables.gCodAlmacen + "' and substring(SC03013,3,1)>='" + Variables.gDesdeRack + "' and substring(SC03013,3,1)<='" + Variables.gHastaRack + "'";
}
else
{
str = "SELECT SC03001,SC03002,SC03003,SC01002,SC01003,SC03013 FROM dbo.SC030100 INNER JOIN SC010100 on SC03001=SC01001 where SC03003<>0 and SC03002='" + Variables.gCodAlmacen + "'";
}
SqlCommand command = new SqlCommand(str, connection);
command.CommandTimeout = 500;
command.Transaction = transaction;
SqlDataAdapter adapter3 = new SqlDataAdapter();
adapter3.SelectCommand = command;
adapter3.Fill(dataSet, "SC030100");
this.Label1.Visible = true;
this.Label1.Refresh();
this.txtCodProd.Visible = true;
long num4 = dataSet.Tables["SC030100"].Rows.Count - 1;
for (num = 0L; num <= num4; num += 1L)
{
row = dataSet.Tables["SC030100"].Rows[(int)num];
this.txtCodProd.Text = StringType.FromObject(row["SC03001"]);
this.txtCodProd.Refresh();
adapter = new SqlDataAdapter(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj("SELECT Codigo,sum(Cantidad) as Cantidad,Posicion FROM dbo.Inventario where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' and Codigo='", row["SC03001"]), "' and Posicion='"), row["SC03013"]), "' group by Codigo,Posicion")), connectionString);
adapter.Fill(dataSet, "Inventario");
try
{
DataRow row2;
string str4;
if (dataSet.Tables["Inventario"].Rows.Count != 0)
{
row2 = dataSet.Tables["Inventario"].Rows[0];
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj((("insert into RepDifInv (FechaInv,DesdeRack,HastaRack,Almacen,Posicion,Codigo,Desc1,Desc2,Cantidad,PosSist,CantSist,Aceptar,Rechazar) values ('" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "','" + Variables.gDesdeRack) + "','" + Variables.gHastaRack) + "','", row["SC03002"]), "','"), row2["Posicion"]), "','"), row["SC03001"]), "','"), row["SC01002"]), "','"), row["SC01003"]), "',"), row2["Cantidad"]), ",'"), row["SC03013"]), "',"), row["SC03003"]), ",0,0)"));
dataSet.Tables["Inventario"].Rows.Clear();
}
else
{
dataSet.Tables["Inventario"].Rows.Clear();
new SqlDataAdapter(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj("SELECT Codigo,sum(Cantidad) as Cantidad,Posicion FROM dbo.Inventario where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' and Codigo='", row["SC03001"]), "' group by Codigo,Posicion")), connectionString).Fill(dataSet, "Inventario");
if (dataSet.Tables["Inventario"].Rows.Count != 0)
{
row2 = dataSet.Tables["Inventario"].Rows[0];
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj((("insert into RepDifInv (FechaInv,DesdeRack,HastaRack,Almacen,Posicion,Codigo,Desc1,Desc2,Cantidad,PosSist,CantSist,Aceptar,Rechazar) values ('" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "','" + Variables.gDesdeRack) + "','" + Variables.gHastaRack) + "','", row["SC03002"]), "','"), row2["Posicion"]), "','"), row["SC03001"]), "','"), row["SC01002"]), "','"), row["SC01003"]), "',"), row2["Cantidad"]), ",'"), row["SC03013"]), "',"), row["SC03003"]), ",0,0)"));
dataSet.Tables["Inventario"].Rows.Clear();
}
else
{
str4 = StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj((("insert into RepDifInv (FechaInv,DesdeRack,HastaRack,Almacen,Posicion,Codigo,Desc1,Desc2,Cantidad,PosSist,CantSist,Aceptar,Rechazar) values ('" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "','" + Variables.gDesdeRack) + "','" + Variables.gHastaRack) + "','", row["SC03002"]), "',' ','"), row["SC03001"]), "','"), row["SC01002"]), "','"), row["SC01003"]), "',0,'"), row["SC03013"]), "',"), row["SC03003"]), ",0,0)"));
}
command3 = new SqlCommand(str4, connection);
command3.Transaction = transaction;
}
num2 = command3.ExecuteNonQuery();
}
catch (Exception exception1)
{
ProjectData.SetProjectError(exception1);
Exception exception = exception1;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception.Message, MsgBoxStyle.OKOnly, null);
if (flag)
{
transaction.Rollback();
flag = false;
}
connection.Close();
this.cmbAceptar.Enabled = true;
this.cmbSalir.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
if (Strings.Len(Variables.gDesdeRack) == 2)
{
str2 = "SELECT Posicion,Codigo,Desc1,Desc2,sum(Cantidad) as Cantidad FROM dbo.Inventario where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' and substring(Posicion,3,2)>='" + Variables.gDesdeRack + "' and substring(Posicion,3,2)<='" + Variables.gHastaRack + "' group by Posicion,Codigo,Desc1,Desc2";
}
else if (Strings.Len(Variables.gDesdeRack) == 1)
{
str2 = "SELECT Posicion,Codigo,Desc1,Desc2,sum(Cantidad) as Cantidad FROM dbo.Inventario where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' and substring(Posicion,3,1)>='" + Variables.gDesdeRack + "' and substring(Posicion,3,1)<='" + Variables.gHastaRack + "' group by Posicion,Codigo,Desc1,Desc2";
}
else
{
str2 = "SELECT Posicion,Codigo,Desc1,Desc2,sum(Cantidad) as Cantidad FROM dbo.Inventario where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' group by Posicion,Codigo,Desc1,Desc2";
}
new SqlDataAdapter(str2, connectionString).Fill(dataSet, "Inventario");
long num3 = dataSet.Tables["Inventario"].Rows.Count - 1;
for (num = 0L; num <= num3; num += 1L)
{
row = dataSet.Tables["Inventario"].Rows[(int)num];
this.txtCodProd.Text = StringType.FromObject(row["Codigo"]);
this.txtCodProd.Refresh();
try
{
command3 = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(ObjectType.StrCatObj(((("insert into RepDifInv (FechaInv,DesdeRack,HastaRack,Almacen,Posicion,Codigo,Desc1,Desc2,Cantidad,PosSist,CantSist,Aceptar,Rechazar) values ('" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "','" + Variables.gDesdeRack) + "','" + Variables.gHastaRack) + "','" + Variables.gCodAlmacen) + "','", row["Posicion"]), "','"), row["Codigo"]), "','"), row["Desc1"]), "','"), row["Desc2"]), "',"), row["Cantidad"]), ",' ',0,0,0)")), connection);
command3.Transaction = transaction;
num2 = command3.ExecuteNonQuery();
}
catch (SqlException exception4)
{
ProjectData.SetProjectError(exception4);
SqlException exception2 = exception4;
if (exception2.Number != 0xa43)
{
Interaction.MsgBox("Se ha producido el siguiente error:" + exception2.Message, MsgBoxStyle.OKOnly, null);
if (flag)
{
transaction.Rollback();
flag = false;
}
connection.Close();
this.cmbAceptar.Enabled = true;
this.cmbSalir.Enabled = true;
ProjectData.ClearProjectError();
return;
}
ProjectData.ClearProjectError();
}
catch (Exception exception5)
{
ProjectData.SetProjectError(exception5);
Exception exception3 = exception5;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception3.Message, MsgBoxStyle.OKOnly, null);
if (flag)
{
transaction.Rollback();
flag = false;
}
connection.Close();
this.cmbAceptar.Enabled = true;
this.cmbSalir.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
}
transaction.Commit();
flag = false;
connection.Close();
Variables.gGenDifInv = true;
frmGenDifInv1 inv = new frmGenDifInv1();
this.Hide();
inv.Show();
}
}
}
}
public void FromObject(bool expected, object value)
{
Assert.Equal(expected, BooleanType.FromObject(value));
}
public void InvalidCastObject(object value)
{
Assert.Throws <InvalidCastException>(() => BooleanType.FromObject(value));
}
private void cmbAceptar_Click(object sender, EventArgs e)
{
if (BooleanType.FromObject(ObjectType.BitAndObj(StringType.StrCmp(this.cbPackList.Text, Strings.Space(0), false) == 0, ObjectType.ObjTst(this.cbPackList.SelectedValue, Strings.Space(0), false) == 0)))
{
Interaction.MsgBox("Debe seleccionar packing list", 0x10, "Operador");
this.cbPackList.Focus();
}
else if (StringType.StrCmp(this.txtDespacho.Text, Strings.Space(0), false) == 0)
{
Interaction.MsgBox("Debe ingresar Despacho", 0x10, "Operador");
this.txtDespacho.Focus();
}
else if (StringType.StrCmp(this.txtCodAduana.Text, Strings.Space(0), false) == 0)
{
Interaction.MsgBox("Debe ingresar C\x00f3digo de Aduana", 0x10, "Operador");
this.txtCodAduana.Focus();
}
else
{
this.cbPackList.Enabled = false;
this.cmbAceptar.Enabled = false;
this.GroupBox2.Enabled = false;
Variables.gDespacho = this.txtDespacho.Text;
Variables.gFechaImp = this.dtpFechaImp.Value;
Variables.gCodAduana = this.txtCodAduana.Text;
string connectionString = "data source=" + Variables.gServer + ";user id=teleprinter;password=tele;initial catalog=Colector;persist security info=True;packet size=4096";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlDataReader reader = new SqlCommand(StringType.FromObject(ObjectType.StrCatObj(ObjectType.StrCatObj("select * from Recepcion where PackList='", this.cbPackList.SelectedValue), "'")), connection).ExecuteReader();
if (reader.Read())
{
reader.Close();
connection.Close();
Interaction.MsgBox("Este packing list ya fue procesado", 0x40, "Operador");
this.cbPackList.Enabled = true;
this.cmbAceptar.Enabled = true;
this.GroupBox2.Enabled = true;
this.cbPackList.Focus();
}
else
{
reader.Close();
Variables.gPackList = StringType.FromObject(this.cbPackList.SelectedValue);
string selectCommandText = "select * from Despachos where Despacho='" + Variables.gDespacho + "' order by NroFCProv";
this.Adap = new SqlDataAdapter(selectCommandText, connectionString);
this.CB = new SqlCommandBuilder(this.Adap);
this.Adap.Fill(this.DS, "FCProv");
this.dgFcProv.DataSource = this.DS.Tables["FCProv"];
DataGridTableStyle table = new DataGridTableStyle();
table.MappingName = "FCProv";
DataGridTextBoxColumn column = new DataGridTextBoxColumn();
column = new DataGridTextBoxColumn();
DataGridTextBoxColumn column2 = column;
column2.HeaderText = "Factura Proveedor";
column2.MappingName = "NroFCProv";
column2.Width = 150;
column2 = null;
table.GridColumnStyles.Add(column);
this.dgFcProv.TableStyles.Add(table);
this.dgFcProv.Refresh();
this.GroupBox1.Visible = true;
this.editNroFC.Focus();
}
}
}
// Inner version of "Print" and "Write".
private static void Print(File file, Object[] Output,
CultureInfo culture, bool print)
{
NumberFormatInfo nfi = culture.NumberFormat;
if (Output == null)
{
return;
}
bool first = true;
foreach (Object obj in Output)
{
if (!first && !print)
{
file.Write(",");
}
else
{
first = false;
}
if (obj == null)
{
if (!print)
{
file.Write("#NULL#");
}
continue;
}
if (obj is TabInfo)
{
file.Tab((TabInfo)obj);
continue;
}
else if (obj is SpcInfo)
{
file.Space((SpcInfo)obj);
continue;
}
else if (obj is char[])
{
file.Write(new String((char[])obj));
continue;
}
else if (obj is ErrObject)
{
if (print)
{
file.Write(String.Format("Error {0}",
((ErrObject)obj).Number));
}
else
{
file.Write(String.Format("#ERROR {0}#",
((ErrObject)obj).Number));
}
continue;
}
switch (ObjectType.GetTypeCode(obj))
{
case TypeCode.DBNull:
{
if (print)
{
file.Write("Null");
}
else
{
file.Write("#NULL#");
}
}
break;
case TypeCode.Boolean:
{
bool b = BooleanType.FromObject(obj);
if (print)
{
file.Write(b.ToString(culture));
}
else if (b)
{
file.Write("#TRUE#");
}
else
{
file.Write("#FALSE#");
}
}
break;
case TypeCode.Byte:
{
byte by = ByteType.FromObject(obj);
file.Write(by.ToString(nfi));
}
break;
case TypeCode.Int16:
{
short s = ShortType.FromObject(obj);
file.Write(s.ToString(nfi));
}
break;
case TypeCode.Int32:
{
int i = IntegerType.FromObject(obj);
file.Write(i.ToString(nfi));
}
break;
case TypeCode.Int64:
{
long l = LongType.FromObject(obj);
file.Write(l.ToString(nfi));
}
break;
case TypeCode.Single:
{
float f = SingleType.FromObject(obj, nfi);
file.Write(f.ToString(nfi));
}
break;
case TypeCode.Double:
{
double d = DoubleType.FromObject(obj, nfi);
file.Write(d.ToString(nfi));
}
break;
case TypeCode.Decimal:
{
Decimal dc = DecimalType.FromObject(obj, nfi);
file.Write(dc.ToString(nfi));
}
break;
case TypeCode.DateTime:
{
DateTime dt = DateType.FromObject(obj);
if (print)
{
file.Write(StringType.FromDate(dt) + " ");
}
else
{
String format;
long dayTicks = dt.Ticks % TimeSpan.TicksPerDay;
if (dt.Ticks == dayTicks)
{
format = "T";
}
else if (dayTicks == 0)
{
format = "d";
}
else
{
format = "F";
}
file.Write(dt.ToString
(format, culture.DateTimeFormat));
}
}
break;
case TypeCode.String:
{
file.Write(StringType.FromObject(obj));
}
break;
default:
{
Utils.ThrowException(5); // ArgumentException.
}
break;
}
}
}
private void cmbAceptar_Click(object sender, EventArgs e)
{
DataSet dataSet = new DataSet();
DataSet set2 = new DataSet();
if (BooleanType.FromObject(ObjectType.BitAndObj(StringType.StrCmp(this.cbAlmacen.Text, Strings.Space(0), false) == 0, ObjectType.ObjTst(this.cbAlmacen.SelectedValue, Strings.Space(0), false) == 0)))
{
Interaction.MsgBox("Debe seleccionar almac\x00e9n", 0x10, "Operador");
this.cbAlmacen.Focus();
}
else if (((StringType.StrCmp(this.editDesdeRack.Text, Strings.Space(0), false) == 0) & (StringType.StrCmp(this.editHastaRack.Text, Strings.Space(0), false) != 0)) | ((StringType.StrCmp(this.editDesdeRack.Text, Strings.Space(0), false) != 0) & (StringType.StrCmp(this.editHastaRack.Text, Strings.Space(0), false) == 0)))
{
Interaction.MsgBox("Debe indicar desde y hasta rack", 0x10, "Operador");
this.editDesdeRack.Focus();
}
else if (StringType.StrCmp(this.editReferencia.Text, Strings.Space(0), false) == 0)
{
Interaction.MsgBox("Debe ingresar referencia", 0x10, "Operador");
this.editReferencia.Focus();
}
else
{
this.cmbAceptar.Enabled = false;
this.cmbSalir.Enabled = false;
Variables.gFechaInv = this.dtpFechaInv.Value;
Variables.gCodAlmacen = StringType.FromObject(this.cbAlmacen.SelectedValue);
Variables.gNomAlmacen = this.cbAlmacen.Text;
Variables.gDesdeRack = Strings.Trim(this.editDesdeRack.Text);
Variables.gHastaRack = Strings.Trim(this.editHastaRack.Text);
Variables.gReferencia = Strings.Trim(this.editReferencia.Text);
string connectionString = "data source=" + Variables.gServer + ";user id=teleprinter;password=tele;initial catalog=Colector;persist security info=False;packet size=4096";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
new SqlDataAdapter("SELECT * FROM dbo.RepDifInv where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' and DesdeRack='" + Variables.gDesdeRack + "' and HastaRack='" + Variables.gHastaRack + "' and Almacen='" + Variables.gCodAlmacen + "'", connectionString).Fill(dataSet, "RepDifInv");
if (dataSet.Tables["RepDifInv"].Rows.Count == 0)
{
Interaction.MsgBox("No se gener\x00f3 diferencia de inventario sobre estos datos", 0x10, "Operador");
connection.Close();
this.cmbAceptar.Enabled = true;
this.cmbSalir.Enabled = true;
this.cmbAceptar.Focus();
}
else
{
dataSet.Tables["RepDifInv"].Rows.Clear();
SqlCommand command3 = new SqlCommand("delete " + Variables.gTermi + "TmpInventario", connection);
int num2 = command3.ExecuteNonQuery();
command3 = new SqlCommand("insert into " + Variables.gTermi + "TmpInventario select Almacen,Posicion,Codigo,Desc1,Desc2,Cantidad,PosSist,CantSist,Aceptar,Rechazar from RepDifInv where FechaInv='" + Strings.Format(Variables.gFechaInv, "MM/dd/yyyy") + "' and DesdeRack='" + Variables.gDesdeRack + "' and HastaRack='" + Variables.gHastaRack + "' and Almacen='" + Variables.gCodAlmacen + "' and (Cantidad<>CantSist or Posicion<>PosSist)", connection);
try
{
num2 = command3.ExecuteNonQuery();
}
catch (Exception exception1)
{
ProjectData.SetProjectError(exception1);
Exception exception = exception1;
Interaction.MsgBox("Se ha producido el siguiente error:" + exception.Message, 0, null);
connection.Close();
this.cmbAceptar.Enabled = true;
this.cmbSalir.Enabled = true;
ProjectData.ClearProjectError();
return;
ProjectData.ClearProjectError();
}
connection.Close();
frmRepDifInv2 inv = new frmRepDifInv2();
this.Hide();
inv.Show();
}
}
}