void cargar_grilla()
{
tb_cxc_evalcredBL BL = new tb_cxc_evalcredBL();
tb_cxc_evalcred BE = new tb_cxc_evalcred();
TablaPendAprob = BL.GetAll_PendAprob(Session["ssEmpresaID"].ToString(), BE).Tables[0];
DataTable dtDatos = new DataTable();
if (TablaPendAprob.Rows.Count > 0)
{
dtDatos.Columns.Add("numdoc");
dtDatos.Columns.Add("ctactename");
dtDatos.Columns.Add("canalventaname");
dtDatos.Columns.Add("vendorname");
dtDatos.Columns.Add("imponeto");
dtDatos.Columns.Add("fecre");
string canalid = "";
string canalname = "";
for (int i = 0; i < TablaPendAprob.Rows.Count; i++)
{
DataRow dtRow = dtDatos.NewRow();
dtRow["numdoc"] = TablaPendAprob.Rows[i]["numdoc"].ToString();
dtRow["ctactename"] = TablaPendAprob.Rows[i]["ctactename"].ToString();
canalname = TablaPendAprob.Rows[i]["canalventaid"].ToString();
switch (canalid.ToString())
{
case "01":
canalname = "NO PROMOCIONALES";
break;
case "02":
canalname = "CLIENTES ESPECIALES";
break;
case "03":
canalname = "MARCAS PROMOCIONALES";
break;
default:
canalname = "NO PROMOCIONALES";
break;
}
dtRow["canalventaname"] = canalname.ToString();
dtRow["vendorname"] = TablaPendAprob.Rows[i]["vendorname"].ToString();
dtRow["imponeto"] = TablaPendAprob.Rows[i]["imponeto"].ToString();
dtRow["fecre"] = TablaPendAprob.Rows[i]["fecre"].ToString().Substring(0,10);
dtDatos.Rows.Add(dtRow);
}
GridView.DataSource = dtDatos;
GridView.DataBind();
}
}
void cargar_grilla()
{
tb_cxc_evalcredBL BL = new tb_cxc_evalcredBL();
tb_cxc_evalcred BE = new tb_cxc_evalcred();
TablaPendAprob = BL.GetAll_PendAprob("02", BE).Tables[0];
if (TablaPendAprob.Rows.Count > 0)
{
GridView.DataSource = TablaPendAprob;
GridView.DataBind();
}
}
