private void MainForm_Load(object sender, EventArgs e)
{
LoginForm loginForm = new LoginForm();
loginForm.ShowDialog();
if (loginForm.DialogResult != DialogResult.OK)
{
Application.Exit();
}
else
{
userId = loginForm.userId;
string commandText = "SELECT UserName FROM account WHERE ID=" + Convert.ToString(userId);
OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();
OleDbCommand command = connection.CreateCommand();
command.CommandText = commandText;
UserNameLabel.Text = Convert.ToString(command.ExecuteScalar());
connection.Close();
commandText = "SELECT ID, AccessoryName,price, 'грн.' as uah FROM accessory";
ShowGoods(commandText);
ShowRecomendation();
GoodsDataGrid.ClearSelection();
GoodsDataGrid.Rows[0].Cells[1].Selected = true;
int ID = (int)GoodsDataGrid[0, 0].Value;
ShowCharacteristics(ID);
ShowRating(ID);
}
}
/// <summary>
/// 绑定数据到DataGrid控件GoodsDataGrid上
/// </summary>
private void BindDataGrid()
{
//创建操作员记录数据表类实例
Goods goods = new Goods();
//获取记录数据
DataTable dt = goods.BindNodes(this.txtId.Text.Trim());//goods.Bind();
DataView dv = new DataView();
dt.TableName = "Goods";
if (dt != null)
{
dv.Table = dt;
dv.Sort = " Price DESC";
if (ViewState["Condition"] != null && ViewState["Condition"].ToString() != "")
{
dv.RowFilter = ViewState["Condition"].ToString();
}
else
{
dv = dt.DefaultView;
}
//新增ID自增值列绑定
dt.Columns.Add(new DataColumn("idno", Type.GetType("System.Int32")));
int intCountRecNum = dv.Count; //获取数据表记录数
for (int i = 0; i < intCountRecNum; i++)
{
dv[i]["idno"] = i + 1;
}
GoodsDataGrid.DataSource = dv;
int PageCount = 0;
if (intCountRecNum % GoodsDataGrid.PageSize == 0)
{
PageCount = intCountRecNum / GoodsDataGrid.PageSize;
}
else
{
PageCount = intCountRecNum / GoodsDataGrid.PageSize + 1;
}
if (PageCount != 0 && GoodsDataGrid.CurrentPageIndex >= PageCount)
{
GoodsDataGrid.CurrentPageIndex = PageCount - 1;
}
GoodsDataGrid.DataBind();
lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数
ShowStats(); //显示页数信息
}
}
protected void tvCategory_SelectedNodeChanged(object sender, EventArgs e)
{
string id = tvCategory.SelectedNode.Value;
this.txtId.Text = id;
//创建操作员记录数据表类实例
Goods goods = new Goods();
//获取记录数据
DataTable dt = goods.BindNodes(id);
DataView dv = new DataView();
dt.TableName = "Goods";
if (dt != null)
{
dv.Table = dt;
dv.Sort = " Price DESC";
//if (ViewState["Condition"] != null && ViewState["Condition"].ToString() != "")
// dv.RowFilter = ViewState["Condition"].ToString();
//else
dv = dt.DefaultView;
//新增ID自增值列绑定
dt.Columns.Add(new DataColumn("idno", Type.GetType("System.Int32")));
int intCountRecNum = dv.Count; //获取数据表记录数
for (int i = 0; i < intCountRecNum; i++)
{
dv[i]["idno"] = i + 1;
}
GoodsDataGrid.DataSource = dv;
int PageCount = 0;
if (intCountRecNum % GoodsDataGrid.PageSize == 0)
{
PageCount = intCountRecNum / GoodsDataGrid.PageSize;
}
else
{
PageCount = intCountRecNum / GoodsDataGrid.PageSize + 1;
}
if (PageCount != 0 && GoodsDataGrid.CurrentPageIndex >= PageCount)
{
GoodsDataGrid.CurrentPageIndex = PageCount - 1;
}
GoodsDataGrid.DataBind();
lblRecNum.Text = intCountRecNum.ToString(); //显示总记录数
ShowStats(); //显示页数信息
}
}
