private void MycmdExecute_Click()
{
try
{
ItemsSource.Clear();
using (SqlExcuteCommand get = new SqlExcuteCommand()
{
DBCnnStr = DBEndososCnnStr
})
{
//if (cbPartido_Item_Id > 1)
// return;
String mpartido = isPartidos == true ? cbPartido[cbPartido_Item_Id].PartidoKey : String.Empty; // cbPartido_Item.Split('-');
_MyLotsVoidTable = get.MyGetLotVoid(mpartido.ToString().Trim(), dpFchRecibo.ToString("MM/dd/yyyy"), isDuplicados, isFechaRecibo, isPartidos);
txtTotal = string.Format("{0:N0}", _MyLotsVoidTable.Rows.Count);
foreach (DataRow r in _MyLotsVoidTable.Rows)
{
infoEndososRechazados myLotsVoid = new infoEndososRechazados();
myLotsVoid.Partido = r["Partido"].ToString().Trim();
myLotsVoid.Lot = r["Lot"].ToString().Trim();
myLotsVoid.Batch = r["Batch"].ToString().Trim();
myLotsVoid.Formulario = Convert.ToInt32(r["Formulario"].ToString().Trim());
myLotsVoid.Rechazo = r["Rechazo"].ToString().Trim();
myLotsVoid.Causal = r["Causal"].ToString().Trim();
myLotsVoid.NumElec = r["NumElec"].ToString().Trim();
myLotsVoid.Status = r["Status"].ToString().Trim();
myLotsVoid.Nombre = r["Nombre"].ToString().Trim();
myLotsVoid.Paterno = r["Paterno"].ToString().Trim();
myLotsVoid.Materno = r["Materno"].ToString().Trim();
myLotsVoid.EndosoImage = (Byte[])r["EndosoImage"];
myLotsVoid.Firma_Fecha = r["Firma_Fecha"].ToString().Trim();
myLotsVoid.Fecha_Endoso = r["Fecha_Endoso"].ToString().Trim();
myLotsVoid.Fecha_Recibo = r["Fecha_Recibo"].ToString().Trim();
ItemsSource.Add(myLotsVoid);
}
}
MessageBox.Show("Done...\r\nTotal:" + string.Format("{0:N0}", _MyLotsVoidTable.Rows.Count), "Done", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
catch (Exception ex)
{
MethodBase site = ex.TargetSite;
MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void MyDoubleClickCommand()
{
try
{
if (System.DBNull.Value.Equals(dgSelectedIndex))
{
return;
}
if (dgSelectedIndex < 1)
{
return;
}
infoEndososRechazados drv = dgSelectedItem;
if (!System.DBNull.Value.Equals(drv.EndosoImage))
{
Byte[] tif = (Byte[])drv.EndosoImage;
String numelec = Guid.NewGuid().ToString(); // drv.NumElec.Trim();
if (!System.IO.Directory.Exists("c:\\SFTEMP\\"))
{
Directory.CreateDirectory("c:\\SFTEMP\\");
}
String tiffName = "c:\\SFTEMP\\" + numelec + ".tif";
_filesTmp.Add(tiffName);
File.WriteAllBytes(tiffName, tif);
System.Diagnostics.Process process = new System.Diagnostics.Process();
process.StartInfo.FileName = tiffName;
process.Start();
}
}
catch (Exception ex)
{
MethodBase site = ex.TargetSite;
MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error);
}
}