/// <summary>
/// 开始一次测试
/// </summary>
/// <param name="ProductCalID"></param>
/// <returns></returns>
public string InsertOneTest(string ProductCalID)
{
string sql = string.Format(" select * from dbo.ProductCalDetail where State='进行中' and ProductCalID='{0}' ", ProductCalID);
DataTable dt = ProductCalre.FindTableBySql(sql);
if (dt.Rows.Count > 0)
{
//表示已经有在进行中的检测，当前状态不允许再新开一条检测
return("0");
}
else
{
ProductCal maine = ProductCalre.FindEntity(ProductCalID);
ProductCalDetail entity = new ProductCalDetail();
entity.ProductCalDID = CommonHelper.GetGuid;
entity.ProductCalID = ProductCalID;
entity.StartDate = DateTime.Now;
entity.State = "进行中";
entity.UpdateMan = ManageProvider.Provider.Current().UserName;
ProductCalDetailre.Insert(entity);
//插入一条新的检测记录
//循环插入5条空的检测录入记录,取消每次录入的按钮，改为一次性录入5条数据
for (int i = 0; i < maine.GroupNum; i++)
{
ProductCalData entityData = new ProductCalData();
entityData.ProductDataID = CommonHelper.GetGuid;
entityData.ProductCalDID = entity.ProductCalDID;
entityData.ProductCalID = ProductCalID;
ProductCalDatare.Insert(entityData);
}
return("1");
}
}
public ActionResult InsertInputData(string ProductCalID, string Num)
{
try
{
string sqldatacount = string.Format(@"select case when (select groupnum from ProductCal where ProductCalID='{0}')>
(select COUNT(1) from dbo.ProductCalData where ProductCalDID in (
select ProductCalDID from dbo.ProductCalDetail where State='进行中' and ProductCalID='{0}'))
then 'success' else 'error' end ", ProductCalID);
DataTable dtdatacount = ProductCalre.FindTableBySql(sqldatacount);
if (dtdatacount.Rows[0][0].ToString() == "success") //表示成功，可以输入检测数据
{
string sql = string.Format(" select ProductCalDID from dbo.ProductCalDetail where State='进行中' and ProductCalID='{0}' ", ProductCalID);
DataTable dt = ProductCalre.FindTableBySql(sql);
if (dt.Rows.Count > 0)
{
string ProductCalDID = dt.Rows[0][0].ToString();
ProductCalData entity = new ProductCalData();
entity.ProductDataID = CommonHelper.GetGuid;
entity.ProductCalDID = ProductCalDID;
entity.ProductCalID = ProductCalID;
entity.InputValue = Convert.ToDouble(Num);
ProductCalDatare.Insert(entity);
return(Content(new JsonMessage {
Success = true, Code = "1", Message = "数据录入成功"
}.ToString()));
}
else
{
return(Content(new JsonMessage {
Success = true, Code = "1", Message = "异常，没有正在进行中的检测"
}.ToString()));
}
}
else
{
return(Content(new JsonMessage {
Success = true, Code = "1", Message = "本次的检测数据已经全部输入完成，无法再录入数据，请结束本次检测，重新开始下次检测"
}.ToString()));
}
}
catch (Exception ex)
{
return(Content(new JsonMessage {
Success = false, Code = "-1", Message = "操作失败：" + ex.Message
}.ToString()));
}
}
