private void AyudaProducto(String lpdescrlike)
{
try
{
var modd = string.Empty;
var BL = new sys_moduloBL();
var BE = new tb_sys_modulo();
var dt = new DataTable();
BE.dominioid = dominio;
BE.moduloid = modulo;
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2)
{
modd = dt.Rows[0]["moduloshort"].ToString().Trim();
var frmayuda = new Ayudas.Form_help_gridproducto();
frmayuda.tipoo = "sql";
frmayuda.titulo = "<< AYUDA PRODUCTO >>";
if (modulo == "0500")
{
// CAMBIAMOS COSTO ULTIMO X COSTO PROMEDIO
frmayuda.sqlquery = " select tb1.productid, tb1.productname,tb1.unmed, "+
" SUM(IIF(mdet.almacaccionid = '10',mdet.cantidad * 1,mdet.cantidad *-1)) AS stock, " +
" tb2.costopromed as precventa, tb2.[local],tb1.nserie from tb_" + modd + "_productos tb1 ";
}
else
{
//frmayuda.sqlquery = " select tb1.productid, tb1.productname,tb1.unmed, "+
// " SUM(IIF(mdet.almacaccionid = '10',mdet.cantidad * 1,mdet.cantidad *-1)) AS stock, " +
// " tb2.costoultimo as precventa, tb2.[local] from tb_" + modd + "_productos tb1 ";
frmayuda.sqlquery = " select tb1.productid, tb1.productname,tb1.unmed, " +
" tb2.stock, " +
" tb2.costopromed as precventa, tb2.[local] from tb_" + modd + "_productos tb1 ";
}
if (modulo == "0500")
{
frmayuda.sqlinner = " LEFT JOIN tb_" + modd + "_local_stock tb2 on tb1.moduloid = tb2.moduloid " +
" AND tb1.productid = tb2.productid "+
" LEFT JOIN tb_" + modd + "_movimientosdet mdet ON tb1.productid = mdet.productid " +
" AND tb2.local = mdet.local ";
}
else {
frmayuda.sqlinner = " LEFT JOIN tb_" + modd + "_local_stock tb2 on tb1.moduloid = tb2.moduloid " +
" AND tb1.productid = tb2.productid ";
//+" LEFT JOIN tb_" + modd + "_movimientosdet mdet ON tb1.productid = mdet.productid "+
//" AND tb2.local = mdet.local ";
}
if (modulo == "0500")
{
frmayuda.sqlwhere = "where tb2.[local] ='" + local + "' ";
}
else
{
frmayuda.sqlwhere = "where tb2.[local] ='" + local + "' and tb1.status = '0' ";
}
frmayuda.sqland = "and";
if (modulo == "0500")
{
frmayuda.sqlgroupby = " GROUP BY tb1.productid " +
", tb1.productname " +
", tb1.unmed " +
", tb2.costopromed " +
", tb2.local " +
", tb1.nserie ";
//frmayuda.sqlgroupby = "";
}
else {
//frmayuda.sqlgroupby = " GROUP BY tb1.productid " +
// ", tb1.productname " +
// ", tb1.unmed " +
// ", tb2.costopromed " +
// ", tb2.[local] ";
frmayuda.sqlgroupby = "";
}
frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" };
frmayuda.columbusqueda = "tb1.productname,tb1.productid";
frmayuda.returndatos = "0,1,2,6";
frmayuda.Owner = this;
frmayuda.PasaProveedor = RecibeProductoRollo;
frmayuda.ShowDialog();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void AyudaProducto(String lpdescrlike)
{
try
{
var modd = string.Empty;
var BL = new sys_moduloBL();
var BE = new tb_sys_modulo();
var dt = new DataTable();
BE.dominioid = "60";
BE.moduloid = cboModuloID.SelectedValue.ToString();
dt = BL.GetAll(EmpresaID, BE).Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["moduloshort"].ToString().Trim().Length == 2)
{
modd = dt.Rows[0]["moduloshort"].ToString().Trim();
var frmayuda = new Ayudas.Form_help_gridproducto();
frmayuda.xfamiliaid = familiaid.Text;
frmayuda.xmoduloid = modulo.ToString();
frmayuda.tipoo = "sql";
frmayuda.titulo = "<< AYUDA TABLA PRODUCTOS >>";
frmayuda.sqlquery = "select tb1.productid, tb1.productname,tb1.unmed,tb2.stock, tb2.costoultimo as precventa, tb2.[local] from tb_" + modd + "_productos tb1 ";
frmayuda.sqlinner = "left join tb_" + modd + "_local_stock tb2 on tb1.moduloid=tb2.moduloid and tb1.productid=tb2.productid";
frmayuda.sqlwhere = "where local ='" + local + "' and tb1.status = '0' ";
frmayuda.sqland = "and";
frmayuda.criteriosbusqueda = new string[] { "PRODUCTO", "CODIGO" };
frmayuda.columbusqueda = "tb1.productname,tb1.productid";
frmayuda.returndatos = "0,1";
frmayuda.Owner = this;
frmayuda.PasaProveedor = RecibeProductos;
frmayuda.ShowDialog();
}
}
}
catch (Exception ex)
{
}
}
