public void GVOder()
{
string gridtext = "select order_id,order_name from [order]";
GVList.DataSource = ConnSQL.SelectUnit(gridtext);
GVList.DataBind();
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string file = FileUpload1.FileName;
if (file.EndsWith(".xlsx"))
{
// Reading from a binary Excel file (format; *.xlsx)
string folderPath = Server.MapPath("uploads");
FileUpload1.SaveAs(folderPath + "\\" + file);
FileStream stream = File.Open(folderPath + "\\" + file, FileMode.Open, FileAccess.Read);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
DataSet result = excelReader.AsDataSet();
excelReader.Close();
GVList.DataSource = result;
GVList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sWhere = "";
Auth.CheckPermission("MASTERDATA", "WBS");
// recupera oggetto con variabili di sessione
CurrentSession = (TRSession)Session["CurrentSession"];
// Resetta indice di selezione sulle dropdwonlist per non perderlo a seguito passaggio a pagina di dettaglio
if (!IsPostBack && Session["DL_progetto"] != null)
{
DL_progetto.DataBind();
DL_progetto.SelectedValue = Session["DL_progetto"].ToString();
// sWhere = " AND p.Projects_id = " + Session["DL_progetto"].ToString();
}
// Imposta il SelectCommand in base al contenuto della lista dropdown
if (DL_progetto.SelectedValue != "")
{
sWhere = " AND p.Projects_id = " + ASPcompatility.FormatStringDb(DL_progetto.SelectedValue);
}
// admin
if (Auth.ReturnPermission("MASTERDATA", "PROJECT_ALL"))
{
DSPhase.SelectCommand = "SELECT Phase_id, Phase.PhaseCode + ' : ' + Phase.Name as NomeFase, c.name as NomeManager, Phase.Projects_id, p.ProjectCode + ' : ' + p.Name AS NomeProgetto FROM Phase INNER JOIN Projects as p ON Phase.Projects_id = p.Projects_Id " +
" INNER JOIN Persons as c ON c.persons_id = p.ClientManager_id " +
" WHERE p.active = 1 and activityON = 1 " + sWhere +
" ORDER BY Phase.Projects_id, Phase.PhaseCode ";
}
else // manager
{
DSPhase.SelectCommand = "SELECT Phase_id, Phase.PhaseCode + ' : ' + Phase.Name as NomeFase, c.name as NomeManager, Phase.Projects_id, p.ProjectCode + ' : ' + p.Name AS NomeProgetto FROM Phase INNER JOIN Projects as p ON Phase.Projects_id = p.Projects_Id " +
" INNER JOIN Persons as c ON c.persons_id = p.ClientManager_id " +
" WHERE p.active = 1 and activityON = 1 and p.clientmanager_id = " + CurrentSession.Persons_id + sWhere +
" ORDER BY Phase.Projects_id, Phase.PhaseCode ";
}
GVList.DataBind();
}
