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;
}
