protected void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
txt_s.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
txt_s.Text = DateTime.Now.ToString("yyyy-MM-dd");
txt_e.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd'})");
txt_e.Text = DateTime.Now.ToString("yyyy-MM-dd");
DataSet dscar = car.Query("", "");
drop_car.DataSource = dscar;
drop_car.DataValueField = "carid";
drop_car.DataTextField = "carid";
drop_car.DataBind();
ListItem li = new ListItem("所有", ""); drop_car.Items.Add(li);
drop_car.SelectedIndex = drop_car.Items.Count - 1;
Query();
}
}
protected void drop_carno_SelectedIndexChanged(object sender, EventArgs e)
{
string carid = drop_carno.SelectedValue;
BLL.Car.Car car = new BLL.Car.Car();
DataSet dscar = car.Query("", carid);
if (dscar.Tables[0].Rows.Count > 0)
{
lbl_num.Text = dscar.Tables[0].Rows[0]["num"].ToString();
}
else
{
lbl_num.Text = "";
}
}
private void CreateCarChildNodes(TreeNode tnParentNode, int NodeId)
{
BLL.Car.Car car = new BLL.Car.Car();
DataSet ds = car.Query("", "");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TreeNode tnChild = new TreeNode();
tnChild.Text = ds.Tables[0].Rows[i]["carid"].ToString();
tnChild.NavigateUrl = ds.Tables[0].Rows[i]["URL"].ToString() + "?key='" + ds.Tables[0].Rows[i]["id"].ToString() + "'";
tnChild.Expanded = true;
tnParentNode.ChildNodes.Add(tnChild);
CreateChildNodes(tnChild, Int16.Parse(ds.Tables[0].Rows[i]["id"].ToString()));
}
ds.Dispose();
}
private void CleanAllText()//清空详细页面中所有的TextBox
{
lbl_num.Text = "";
txt_destn.Text = "";
txt_start.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})");
txt_start.Text = "";
txt_end.Attributes.Add("OnFocus", "javascript:WdatePicker({dateFmt:'yyyy-MM-dd HH:mm:ss'})");
txt_end.Text = "";
txt_remark.Text = "";
BLL.Car.Car car = new BLL.Car.Car();
DataSet dscar = car.Query("", "");
drop_carno.DataSource = dscar;
drop_carno.DataValueField = "carid";
drop_carno.DataTextField = "carid";
drop_carno.DataBind();
ListItem li = new ListItem("请选择", "-1");
drop_carno.Items.Add(li);
drop_carno.SelectedValue = "-1";
}
//查询并填入GridView中
private void Query()
{
DataSet ds = carobj.Query("", "");
if (ds.Tables[0].Rows.Count == 0)
{
//没有记录仍保留表头
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
int intColumnCount = grdvw_List.Rows[0].Cells.Count;
grdvw_List.Rows[0].Cells.Clear();
grdvw_List.Rows[0].Cells.Add(new TableCell());
grdvw_List.Rows[0].Cells[0].ColumnSpan = intColumnCount;
}
else
{
grdvw_List.DataSource = ds;
grdvw_List.DataBind();
}
}
