protected void Page_Load(object sender, EventArgs e) { HtmlTable a = new HtmlTable(); APEnableActionBonusesForStatus.Controls.Add(a); if (!IsPostBack) { NewStartDate.Date = DateTime.Now.Date.AddDays(5); Session.Timeout = 30; try { Session["Connection"] = new OracleConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]); UpdateVariables(); Connection.AutoCommit = false; Connection.Open(); current.PrepareAudit(Connection); // ������� ����� QueryResult SetsQR = Query.Execute(Connection, @"select s.SetID, s.Name, cc.Code as CCCode, cc.LongName as CCName, tc.Code as TCCode, tc.LongName as TCName from ActionParamSets s, Currencies cc, Currencies tc where cc.ID = s.CardCurrencyID and tc.ID = TerminalCurrencyID order by s.SetID", null, null); Session["ParamSets"] = new List<ParamSet>(); UpdateVariables(); ParamSets.Clear(); for (int i = 0; i < SetsQR.Rows.Count; i++) { ParamSet PS = new ParamSet(Functions.ConvertToInt32(SetsQR[i, "SetID"]), string.Format("{0} ({1}-{2})", Functions.ConvertToString(SetsQR[i, "Name"]), Functions.ConvertToString(SetsQR[i, "CCCode"]), Functions.ConvertToString(SetsQR[i, "TCCode"]))); ParamSets.Add(PS); ListItem li = new ListItem(PS.Name); SetsList.Items.Add(li); } Products = new ActionProducts(Connection); Session["Products"] = Products; SetsList.SelectedIndex = SetsQR.Rows.Count > 0 ? 0 : -1; SetsList_SelectedIndexChanged(sender, e); } finally { Connection.Close(); } } ShowError(""); ShowHolidayError(""); ShowGoodsChargingError(""); ShowGoodsPaymentError(""); ShowOk(""); ShowHolidayOk(""); ShowGoodsChargingOk(""); ShowGoodsPaymentOk(""); }
void UpdateVariables() { Connection = Session["Connection"] as OracleConnection; ParamSets = Session["ParamSets"] as List<ParamSet>; SelectedParamSet = Session["SelectedParamSet"] as ParamSet; SelectedParamValue = Session["SelectedParamValue"] as ParamValue; Products = Session["Products"] as ActionProducts; current = Session["Current"] as Current; }