public DataTable spareDelivery_verificaOrdenes_Param(ref Ent_ttscol100 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
/* Estados
* 1: Libre
* 5. Libre
* 10. PLaneada
* 15. Liberada o release
* 20. COmpleta o Completed
* 23. Costos o Costed
* 25. Cerrada o Closed
* 35. Cancelada o Canceled
*/
paramList = new Dictionary <string, object>();
paramList.Add("p1", Parametros.orno.Trim().ToUpperInvariant());
strSentencia = recursos.readStatement("ttssoc200", method.Name, ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Service order doesn't exist or status doesn't allowed. Cannot Continue.";
}
}
catch (Exception ex)
{
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
public DataTable spareDelivery_verificaOrdenes_Param(ref Ent_ttscol100 Parametros, ref string strError)
{
//int retorno = -1;
DataTable retorno;
try
{
retorno = dal.spareDelivery_verificaOrdenes_Param(ref Parametros, ref strError);
return retorno;
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ViewState["tablaTemp"] != null)
{
DataTable tablaTemp = ViewState["tablaTemp"] as DataTable;
if (tablaTemp.Rows.Count >= 1)
{
List <Ent_ttscol100> parameterCollection = new List <Ent_ttscol100>();
for (int i = 1; i <= tablaTemp.Rows.Count; i++)
{
obj = new Ent_ttscol100();
obj.orno = txtWorkOrder.Text.Trim().ToUpperInvariant();
obj.item = tablaTemp.Rows[i - 1]["T$ITEM"].ToString();
obj.loca = tablaTemp.Rows[i - 1]["T$LOCA"].ToString();
obj.cwar = tablaTemp.Rows[i - 1]["T$CWAR"].ToString();
string toreturn = tablaTemp.Rows[i - 1]["T$QDEL"].ToString();
obj.qdel = Decimal.Parse(toreturn, System.Globalization.CultureInfo.InvariantCulture);
obj.logn = Session["user"].ToString();
obj.mess = " ";
obj.refcntd = 0;
obj.refcntu = 0;
obj.cusr = "******";
obj.conf = 2;
parameterCollection.Add(obj);
}
idal.insertarRegistro(ref parameterCollection, ref strError);
printResult.Visible = true;
if (strError != string.Empty)
{
lblResult.Text = strError;
throw new System.InvalidOperationException(strError);
}
lblResult.Text = SpareDeliverywassuccesfullyregistered;
createObjectTable();
btnAddRow.Enabled = true;
}
}
else
{
lblResult.Text = ViewStateisnullPleasecontacttosupport
;
}
}
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_ttscol100 parametros, bool blnUsarPRetorno = false)
{
method = MethodBase.GetCurrentMethod();
string strError = string.Empty;
List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>();
try
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ORNO", DbType.String, parametros.orno.ToUpperInvariant());
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$ITEM", DbType.String, parametros.item.Trim().ToUpperInvariant());
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOCA", DbType.String, parametros.loca);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWAR", DbType.String, parametros.cwar.ToUpperInvariant());
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$QDEL", DbType.Decimal, Convert.ToDecimal(parametros.qdel).ToString("#.##0,0000"));
// Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CDAT", DbType.String, parametros.cdat);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mess);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd);
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu);
if (!string.IsNullOrEmpty(parametros.logn))
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.logn);
}
if (!string.IsNullOrEmpty(parametros.cusr))
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CUSR", DbType.String, parametros.cusr);
}
if (parametros.conf > 0)
{
Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CONF", DbType.Int32, parametros.conf);
}
if (blnUsarPRetorno)
{
Ent_ParametrosDAL pDal = new Ent_ParametrosDAL();
pDal.Name = "@p_Int_Resultado";
pDal.Type = DbType.Int32;
pDal.ParDirection = ParameterDirection.Output;
parameterCollection.Add(pDal);
}
}
catch (Exception ex)
{
strError = "Error when creating parameters [scol100]. Try again or contact your administrator \n";
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(parameterCollection);
}
public static string validaInfo(string valor, string tipo, string orden = null)
{
string strSecondVal = string.Empty;
string strError = string.Empty;
string retorno = string.Empty;
DataTable resultado = new DataTable();
InterfazDAL_ttwhcol016 idal016 = new InterfazDAL_ttwhcol016();
Ent_ttwhcol016 obj016 = new Ent_ttwhcol016();
InterfazDAL_ttscol100 idal = new InterfazDAL_ttscol100();
Ent_ttscol100 obj = new Ent_ttscol100();
if (tipo == "1") // Items
{
obj.item = valor;
resultado = idal.spareDelivery_listaRegistroItem_Param(ref obj, ref strError);
if (resultado.Rows.Count > 0)
{
retorno = resultado.Rows[0]["DESCRIPCION"].ToString().Trim() + "|" +
resultado.Rows[0]["UNIDAD"].ToString().Trim() + "|" +
resultado.Rows[0]["ARTICULO"].ToString().Trim();
}
}
if (tipo == "2") // Lote
{
obj.loca = valor;
resultado = idal.spareDelivery_listaRegistroUbicacion_Param(ref obj, ref strError);
if (resultado.Rows.Count > 0)
{
retorno = resultado.Rows[0]["LOCATION"].ToString().Trim() + "|" +
resultado.Rows[0]["WAREHOUSE"].ToString().Trim();
}
}
// Validar si el numero de orden trae registros
if (strError != string.Empty)
{
return("BAAN: " + strError);
}
// if (resultado.Rows.Count > 0) { retorno = resultado.Rows[0]["DESCRIPCION"].ToString(); }
return(retorno);
}
protected void btnSave_Click(object sender, EventArgs e)
{
List <Ent_ttscol100> parameterCollection = new List <Ent_ttscol100>();
Ent_ttscol100 obj = new Ent_ttscol100();
foreach (GridViewRow fila in grdRecords.Rows)
{
DropDownList lista = ((DropDownList)fila.Cells[6].Controls[1]);
if (lista != null)
{
if (Convert.ToInt32(lista.SelectedValue) == 1)
{
obj = new Ent_ttscol100();
obj.orno = txtWorkOrder.Text.Trim();
obj.item = fila.Cells[0].Text;
obj.loca = fila.Cells[2].Text;
obj.cwar = fila.Cells[3].Text.Trim();
string toreturn = fila.Cells[4].Text;
obj.qdel = Decimal.Parse(toreturn, System.Globalization.CultureInfo.InvariantCulture);
obj.refcntd = 0;
obj.refcntu = 0;
obj.mess = " ";
obj.conf = Convert.ToInt32(lista.SelectedValue);;
obj.cusr = Session["user"].ToString();
obj.idrecord = grdRecords.DataKeys[fila.RowIndex].Value.ToString();
parameterCollection.Add(obj);
}
}
}
idal.actualizarRegistro_Param(ref parameterCollection, ref strError);
if (strError != string.Empty)
{
lblResult.Text = strError;
throw new System.InvalidOperationException(strError);
}
printResult.Visible = true;
lblResult.Text = Recordswassavedsuccesfully;
grdRecords.DataSource = Recordswassavedsuccesfully;
grdRecords.DataBind();
}
public DataTable spareDelivery_listaRegistrosOrdenParam(ref Ent_ttscol100 Parametros, ref string strError)
{
method = MethodBase.GetCurrentMethod();
paramList = new Dictionary <string, object>();
paramList.Add("p1", Parametros.orno.Trim().ToUpperInvariant());
strSentencia = recursos.readStatement(method.ReflectedType.Name, method.Name, ref owner, ref env, tabla, paramList);
try
{
consulta = DAL.BaseDAL.BaseDal.EjecutarCons("Text", strSentencia, ref parametersOut, null, true);
if (consulta.Rows.Count < 1)
{
strError = "Service order doesn't exist or status doesn't allowed. Cannot Continue.";
}
}
catch (Exception ex)
{
log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
}
return(consulta);
}
