private DataTable cargar()
{
ventas2Entities db = new ventas2Entities();
DataTable dt = new DataTable();
string cnx = db.Database.Connection.ConnectionString;
con = new SqlConnection(cnx);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.Text;
string zon = Request.QueryString["zon"];
string mer = Request.QueryString["mer"];
if (zon != "" & mer == "")
{
cmd.CommandText = "select * from v_RPlanillaCobranza where DescripCorta='" + zon + "'";
}
else
{
cmd.CommandText = "select * from v_RPlanillaCobranza where DescripCorta='" + zon + "'and NombreCorto='" + mer + "'";
}
cmd.Connection = con;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
return(dt);
}
protected void Page_Load(object sender, EventArgs e)
{
ventas2Entities db = new ventas2Entities();
string cnx = db.Database.Connection.ConnectionString;
con = new SqlConnection(cnx);
if (!Page.IsPostBack)
{
renderReport();
}
}
private DataTable cargar(string id)
{
ventas2Entities db = new ventas2Entities();
DataTable dt = new DataTable();
string cnx = db.Database.Connection.ConnectionString;
con = new SqlConnection(cnx);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_NotaRecojo";
cmd.Connection = con;
cmd.Parameters.AddWithValue("@Id", id);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
return(dt);
}
private DataTable Buscar(string fechai, string fechaf, string inicio, string final, string zona, string mercado)
{
ventas2Entities db = new ventas2Entities();
string cnx = db.Database.Connection.ConnectionString;
DataTable dt = new DataTable();
con = new SqlConnection(cnx);
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.CommandText = "usp_Peso0a20";
cmd.Parameters.AddWithValue("@inicio", inicio);
cmd.Parameters.AddWithValue("@final", final);
cmd.Parameters.AddWithValue("@fechai", fechai);
cmd.Parameters.AddWithValue("@fechaf", fechaf);
cmd.Parameters.AddWithValue("@zona", zona);
cmd.Parameters.AddWithValue("@mercado", mercado);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
return(dt);
}
