DataSet ds = databind(" 1=1",user.EmpID,datestart);
ViewData["data"] = ds;
ViewBag.xcNotHS = ds.Tables[2].Rows[0][0].ToString();//取table表的数据
private DataSet databind(string filter,int xcyID,string filterdate)
{
DataSet ds = null;
SqlConnection conn = null;
SqlParameter[] paramList = new SqlParameter[] {
Common.DBHelper.CreateCommandParameter("@filter", SqlDbType.VarChar, filter),
Common.DBHelper.CreateCommandParameter("@PatrolManID",SqlDbType.Int,xcyID),
Common.DBHelper.CreateCommandParameter("@filterdate",SqlDbType.VarChar,filterdate)
};
try
{
conn = Common.DBHelper.CreateDbConnection(Common.DBHelper.DbConnectionString);
conn.Open();<