/// <summary>
/// 查询挡车工产量日报
/// </summary>
public JsonResult WorkerDay(string Time, string sClassName)
{
//json结果
JsonResult result = new JsonResult();
//json.data
AjaxTablePageData <LoomWorkerDay> pageData = new AjaxTablePageData <LoomWorkerDay>();
//获取班次id
int iClassId = 0;
if (string.IsNullOrEmpty(Time) || string.IsNullOrEmpty(sClassName))
{
iClassId = new LoomDAL().GetClassIdNow();
}
else
{
iClassId = new LoomDAL().GetClassId(Time, sClassName);
}
//根据当前页和行数，获取数据集
List <LoomWorkerDay> list = new LoomDAL().GetWorkerDay(iClassId);
pageData.data = list;
//允许get
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
result.Data = pageData;
return(result);
}
/// <summary>
/// 获取停台时间分析
/// </summary>
public JsonResult LoomAnalysisPie2_1(string time, string sClassName)
{
JsonResult result = new JsonResult();
List <IntData> list = new LoomDAL().LoomAnalysisPie2_1(time, sClassName);
//写入结果
result.Data = list;
return(result);
}
/// <summary>
/// 获取低效率机台
/// </summary>
public JsonResult LoomAnalysisPie4()
{
JsonResult result = new JsonResult();
List <DecimalData> list = new LoomDAL().LoomAnalysisPie4();
//写入结果
result.Data = list;
return(result);
}
/// <summary>
/// 获取车速情况
/// </summary>
public JsonResult GetLoomPie4()
{
JsonResult result = new JsonResult();
List <IntData> list = new LoomDAL().GetLoomPie4();
//写入结果
result.Data = list;
return(result);
}
/// <summary>
/// 获取低效率机台
/// </summary>
public JsonResult LoomAnalysisPie4_1(string Time, string sClassName)
{
JsonResult result = new JsonResult();
int iClassId = new LoomDAL().GetClassId(Time, sClassName);
List <DecimalData> list = new LoomDAL().LoomAnalysisPie4_1(iClassId);
//写入结果
result.Data = list;
return(result);
}
/// <summary>
/// 获取设备产量月报
/// </summary>
public JsonResult DayAnalysis2(string time)
{
JsonResult result = new JsonResult();
if (String.IsNullOrEmpty(time))
{
return(result);
}
List <DecimalData> list = new LoomDAL().DayAnalysis2(time);
//写入结果
result.Data = list;
return(result);
}
/// <summary>
/// 织机实时状态查询
/// </summary>
public JsonResult LoomStateNowQuery()
{
string varCheck = Request.QueryString["query[varCheck]"];
int machineVar = string.IsNullOrEmpty(varCheck) ? 0 : Convert.ToInt32(varCheck);
//json结果
JsonResult result = new JsonResult();
//json.data
AjaxTablePageData <LoomStateCoordinate> pageData = new AjaxTablePageData <LoomStateCoordinate>();
//根据当前页和行数，获取数据集
List <LoomStateCoordinate> list = new LoomDAL().GetLoomStateQuery(machineVar);
pageData.data = list;
//允许get
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
result.Data = pageData;
return(result);
}
/// <summary>
/// 获取班次
/// </summary>
public JsonResult GetWorkTime()
{
JsonResult result = new JsonResult();
DataTable data = new LoomDAL().GetWorkTime();
int count = data.Rows.Count;
object[] List = new object[count];
int i = 0;
foreach (DataRow row in data.Rows)
{
List[i] = new object[] { (int)row["value"], (string)row["text"] };
i++;
}
result.Data = List;
return(result);
}
/// <summary>
/// 获取停台频繁机台，各状态停台次数
/// </summary>
public JsonResult LoomAnalysisPie3_1()
{
JsonResult result = new JsonResult();
DataTable data = new LoomDAL().LoomAnalysisPie3("iAllStopTime", 0);
List <BarData> list = new List <BarData>();
list.Add(SetBarData("纬停", "iStatusTime1", data));
list.Add(SetBarData("经停", "iStatusTime2", data));
list.Add(SetBarData("绞边停", "iStatusTime3", data));
list.Add(SetBarData("耳丝停", "iStatusTime4", data));
list.Add(SetBarData("离线", "iStatusTime9", data));
list.Add(SetBarData("其他停", "iStatusTime10", data));
//写入结果
result.Data = list;
return(result);
}
/// <summary>
/// 织机实时车速图
/// </summary>
public JsonResult GetLoomStateNowGauge(string iMachineID)
{
JsonResult result = new JsonResult();
DataTable data = new LoomDAL().GetLoomStateNowGauge(iMachineID);
int count = data.Rows.Count;
object[] List = new object[count];
int i = 0;
foreach (DataRow row in data.Rows)
{
List[i] = new object[] { Convert.ToInt32((decimal)row["nBanciSpeed"]), (decimal)row["nBancieff"] };
i++;
}
result.Data = List;
return(result);
}
/// <summary>
/// 获取织机机台号
/// </summary>
public JsonResult GetLoomMachineNo()
{
JsonResult result = new JsonResult();
DataTable data = new LoomDAL().GetLoomMachineNo();
int count = data.Rows.Count;
object[] List = new object[count];
int i = 0;
foreach (DataRow row in data.Rows)
{
List[i] = new object[] { (int)row["iMachineID"], (string)row["sMachineName"] };
i++;
}
result.Data = List;
return(result);
}
/// <summary>
/// 获取停台频繁机台，机台号
/// </summary>
public JsonResult LoomAnalysisPie3_1Title()
{
JsonResult result = new JsonResult();
DataTable data = new LoomDAL().LoomAnalysisPie3("iAllStopTime", 0);
object[] List = new object[data.Rows.Count];
int i = 0;
foreach (DataRow row in data.Rows)
{
List[i] = new object[] { (int)row["iAllStopTime"], (string)row["iMachineID"] };
i++;
}
//写入结果
result.Data = List;
return(result);
}
/// <summary>
/// 获取停台频繁机台，各状态停台次数
/// </summary>
public JsonResult LoomAnalysisBar2(string time, string sClassName)
{
JsonResult result = new JsonResult();
int iClassId = new LoomDAL().GetClassId(time, sClassName);
DataTable data = new LoomDAL().LoomAnalysisPie3("iAllStopTime", iClassId);
List <BarData> list = new List <BarData>();
list.Add(SetBarData("纬停", "iStatusTime1", data));
list.Add(SetBarData("经停", "iStatusTime2", data));
list.Add(SetBarData("绞边停", "iStatusTime3", data));
list.Add(SetBarData("耳丝停", "iStatusTime4", data));
list.Add(SetBarData("离线", "iStatusTime9", data));
list.Add(SetBarData("其他停", "iStatusTime10", data));
//写入结果
result.Data = list;
return(result);
}
/// <summary>
/// 获取停台频繁机台，机台号
/// </summary>
public JsonResult LoomAnalysisBar2Title(string time, string sClassName)
{
JsonResult result = new JsonResult();
int iClassId = new LoomDAL().GetClassId(time, sClassName);
DataTable data = new LoomDAL().LoomAnalysisPie3("iAllStopTime", iClassId);
object[] List = new object[data.Rows.Count];
int i = 0;
foreach (DataRow row in data.Rows)
{
List[i] = new object[] { (int)row["iAllStopTime"], (string)row["iMachineID"] };
i++;
}
//写入结果
result.Data = List;
return(result);
}
/// <summary>
/// 织机实时状态列表查询
/// </summary>
public JsonResult LoomStateNowListQuery()
{
//获取查询
string query = Request.QueryString["query[generalSearch]"];
//获取状态
string status = Request.QueryString["query[Status]"];
//获取排序
string field = Request.QueryString["sort[field]"];
string sort = Request.QueryString["sort[sort]"];
//json结果
JsonResult result = new JsonResult();
//json.data
AjaxTablePageData <Loom> pageData = new AjaxTablePageData <Loom>();
//根据当前页和行数，获取数据集
List <Loom> list = new LoomDAL().GetLoomStateNowListQuery(query, status, field, sort);
pageData.data = list;
//允许get
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
result.Data = pageData;
return(result);
}
