protected void DataBind(decimal staffid, DateTime sdate, DateTime edate, int pageIndex)
{
hidStaffid.Value = staffid.ToString();
hidSdate.Value = sdate.ToString("yyyy-MM-dd HH:mm:ss");
hidEdate.Value = edate.ToString("yyyy-MM-dd HH:mm:ss");
V_USERCHECKINOUT ckVal = new V_USERCHECKINOUT();
ckVal._USERID = 0;
ckVal.NAME = "";
ckVal.STAFF_ID = 0;
ckVal.STAFF_NAME = "";
ckVal.STAFF_NO = "";
ckVal._VERIFYCODE = 0;
ckVal._CHECKTIME = DateTime.MinValue;
ckVal._CHECKTYPE = "";
ckVal._SENSORID = "";
V_USERCHECKINOUT ckCon = new V_USERCHECKINOUT();
ckCon.STAFF_ID = staffid;
//ckCon.Where(" {0}.{1} >= '{2}' and {3}.{4} <= '{5}' ", ckCon._ZhName, HR_CHECKINOUT.Attribute.CHECKTIME.FieldName, sdate.ToString("yyyy-MM-dd"), ckCon._ZhName, HR_CHECKINOUT.Attribute.CHECKTIME, edate.ToString("yyyy-MM-dd"));
ckCon.Where(" {0} >= '{1}' and {2} <= '{3}' ", V_USERCHECKINOUT.Attribute.CHECKTIME.FieldName, sdate.ToString("yyyy-MM-dd"), V_USERCHECKINOUT.Attribute.CHECKTIME, edate.ToString("yyyy-MM-dd"));
int rcount = -1;
List<V_USERCHECKINOUT> ckList = BLLTable<V_USERCHECKINOUT>.Factory(conn).SelectByPage(ckVal, ckCon, aspPager.PageSize, pageIndex, ref rcount);
aspPager.RecordCount = rcount;
repList.DataSource = ckList;
repList.DataBind();
}
protected void DataBind(decimal staffid, DateTime sdate, DateTime edate, int pageIndex)
{
hidStaffid.Value = staffid.ToString();
hidSdate.Value = sdate.ToString("yyyy-MM-dd HH:mm:ss");
hidEdate.Value = edate.ToString("yyyy-MM-dd HH:mm:ss");
V_USERCHECKINOUT ckVal = new V_USERCHECKINOUT();
ckVal._USERID = 0;
ckVal.NAME = "";
ckVal.STAFF_ID = 0;
ckVal.STAFF_NAME = "";
ckVal.STAFF_NO = "";
ckVal._VERIFYCODE = 0;
ckVal._CHECKTIME = DateTime.MinValue;
ckVal._CHECKTYPE = "";
ckVal._SENSORID = "";
V_USERCHECKINOUT ckCon = new V_USERCHECKINOUT();
ckCon.STAFF_ID = staffid;
//ckCon.Where(" {0}.{1} >= '{2}' and {3}.{4} <= '{5}' ", ckCon._ZhName, HR_CHECKINOUT.Attribute.CHECKTIME.FieldName, sdate.ToString("yyyy-MM-dd"), ckCon._ZhName, HR_CHECKINOUT.Attribute.CHECKTIME, edate.ToString("yyyy-MM-dd"));
ckCon.Where(" {0} >= '{1}' and {2} <= '{3}' ", V_USERCHECKINOUT.Attribute.CHECKTIME.FieldName, sdate.ToString("yyyy-MM-dd"), V_USERCHECKINOUT.Attribute.CHECKTIME, edate.ToString("yyyy-MM-dd"));
int rcount = -1;
List <V_USERCHECKINOUT> ckList = BLLTable <V_USERCHECKINOUT> .Factory(conn).SelectByPage(ckVal, ckCon, aspPager.PageSize, pageIndex, ref rcount);
aspPager.RecordCount = rcount;
repList.DataSource = ckList;
repList.DataBind();
}
