public Graph GetWCData(string id)
{
DBCtrl dbCtrl = new DBCtrl();
string sql = string.Format("EXEC pGetWCData '{0}'", id);
var query = dbCtrl.getList(sql);
dbCtrl.Close();
return query.ToGoogleChart();
}
public Graph ErrRateByWeight()
{
DBCtrl db = new DBCtrl();
string sql = "EXEC pErrRateByWeight null,null";
DataTable dt = db.getList(sql);
db.Close();
return dt.ToGoogleChart();
}
public Graph ErrorByBatch(string id)
{
DBCtrl db = new DBCtrl();
string sql = "EXEC pErrByBatch null,null,'" + id + "',null,null";
DataTable dt = db.getList(sql);
db.Close();
return dt.ToGoogleChart();
}
public Graph Compare(int year, int month, int day, string line)
{
DateTime date = new DateTime(year, month, day);
DBCtrl db = new DBCtrl();
string sql = "EXEC pErrCompare '" + date.ToString("yyyy/MM/dd") + "'," + line;
DataTable dt = db.getList(sql);
db.Close();
return dt.ToGoogleChart();
}
public Graph Daily(string id)
{
DBCtrl dbCtrl = new DBCtrl();
string sql = string.Format("EXEC pGetDailyWCData '{0}'", id);
var query = dbCtrl.getList(sql);
dbCtrl.Close();
var g = query.ToGoogleChart();
g.cols[1].p = new Dictionary<string, string>();
g.cols[1].p.Add("role", "tooltip");
g.cols[1].p.Add("html", "true");
return g;
}
public Graph ErrorByBatch(int year, int month, int day, string line, string shift)
{
int range = int.Parse(line);
DateTime date = new DateTime(year, month, day);
DateTime startDate = date.AddDays(-range);
DBCtrl db = new DBCtrl();
string sql = "EXEC pErrByBatch null,null,'{0}','{1}','{2}'";
sql = string.Format(sql, shift, startDate.ToString("yyyy-MM-dd"), date.ToString("yyyy-MM-dd"));
DataTable dt = db.getList(sql);
db.Close();
return dt.ToGoogleChart();
}