01.private void getgv()
02. {
03. string stracc;
04. stracc = "SELECT CHECKINOUT.CHECKTIME,CHECKINOUT.sn, USERINFO.SSN FROM USERINFO ";
05. stracc += "Inner Join CHECKINOUT on CHECKINOUT.USERID = USERINFO.USERID ";
06. stracc += "Where SSN = '" + cb_id.EditValue + "' Order By CHECKTIME asc ";
07. ds = ojodbc1.GetDataSet(stracc, "data");
08. gvhr_time.DataSource = ds.Tables[0];
09.
10. foreach (DataRow dr in ds.Tables[0].Rows)
11. {
12. strGVm = dr["CHECKTIME"].ToString().Substring(0, 2);
13. strGVy = dr["CHECKTIME"].ToString().Substring(6, 4);
14. strGV = strGVm + "/" + strGVy;
15. dr["sn"] = strGV;
16. }
17.}
18. private void getgv2()
19. {
20. string stracc2;
21. stracc2 = "SELECT CHECKINOUT.CHECKTIME,CHECKINOUT.sn, USERINFO.SSN FROM USERINFO ";
22. stracc2 += "Inner Join CHECKINOUT on CHECKINOUT.USERID = USERINFO.USERID ";
23. stracc2 += "Where SSN = '" + cb_id.EditValue + "' and sn = '" + strmldr + "' Order By CHECKTIME asc ";
24. ds2 = ojodbc1.GetDataSet(stracc2, "data");
25. gvhr_time.DataSource = ds2.Tables[0];
26. }
