/// <summary> /// 查询录像信息 /// </summary> public void RecShow(string currentPage) { RecQueryStatement qs = new RecQueryStatement(); if (RecChannelName.Text != "") { qs.CameraID = DeviceIDs; } switch (comboBox2.Text) { case "手动录像": qs.RecType = "1"; break; case "自动录像": qs.RecType = "2"; break; case "报警录像": qs.RecType = "3"; break; } if (comboBox3.Text != "") { qs.UserName = comboBox3.Text; } if (checkBox1.Checked) { qs.RecStartDate = page1_startDate.Text.ToString(); } if (checkBox4.Checked) { qs.RecStartTime = page1_startTime.Text.ToString(); } if (checkBox2.Checked) { qs.RecEndDate = page1_endDate.Text.ToString(); } if (checkBox3.Checked) { qs.RecEndTime = page1_endTime.Text.ToString(); } string errorInfo = ""; RecCount = RecFileClass.GetRecPageCount(qs, ref errorInfo); if (RecCount == -1) { MessageBox.Show(errorInfo); return; } DataSet ds = RecFileClass.SelectRecInfo(currentPage, comboBox1.Text, qs, ref errorInfo); dataGridView1.DataSource = ds; dataGridView1.DataMember = "RecFileList"; RecPageBtn.Text = currentPage; label2.Text = "当前页" + dataGridView1.Rows.Count + "条记录 / 共" + RecCount + "条记录"; }
public void TestMethod1() { RecQueryStatement qs = new RecQueryStatement(); qs.RecType = "3"; //DataSet ds = RecFileClass.SelectRecInfo("1", "30",qs); //DateTime dt = DateTime.Now; //RecFileList recFileList = new RecFileList(); //recFileList.CameraID = "7000"; //recFileList.RecName = "7000_120180628093008自动.mp4"; //recFileList.RecRecFile = @"d:\7000_120180628093008自动.mp4"; //recFileList.RecStartDate = dt.ToString("yyyy-MM-dd"); //recFileList.RecStartTime = dt.ToString("HH:mm:ss"); //recFileList.RecType = "3"; //RecFileClass.AddStartTime(recFileList); }