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();
}
public Graph ErrorMatrix()
{
//var query = from mx in db.vErrorMatrix.AsEnumerable()
// orderby mx.Weight
// let result = new
// {
// Weight = mx.Weight,
// Line = mx.CodeWorkCenter,
// TotalBags = mx.QuantityBagsProduced,
// FontErr = mx.Error4,
// TotalErr = mx.ErrorTotal,
// FontErrRate = mx.Error4Rate,
// TotalErrRate = mx.ErrorTotalRate
// }
// select result;
DBCtrl dbCtrl = new DBCtrl();
string sql = "exec pBatchError null,3000,null,null,null";
var dt = dbCtrl.getList(sql);
//return query.ToList().ToGoogleChart();
return dt.ToGoogleChart();
}