public ActionResult Edit(string id)
{
UNCERTAINTYTABLEBLL ulbll = new UNCERTAINTYTABLEBLL();
var data = ulbll.GetAll();//查询数据
int zhu = Convert.ToInt32(id);
var date = data.Where(w => w.GROUPS == zhu && w.CATEGORY == "UB");
int a = date.Count();
//List<UNCERTAINTYTABLE> list = new List<UNCERTAINTYTABLE>();
METERING_STANDARD_DEVICEShow msdshow = new METERING_STANDARD_DEVICEShow();
UNCERTAINTYTABLEShow ueshow = null;
List <UNCERTAINTYTABLEShow> ueshowlist = new List <UNCERTAINTYTABLEShow>();
int GROUPS = 0;
string groups = string.Empty;
foreach (var item in date)
{
ueshow = new UNCERTAINTYTABLEShow();
ueshow.ASSESSMENTITEM = item.ASSESSMENTITEM; //评定项
ueshow.THERANGESCOPE = item.THERANGESCOPE; //量程范围起
ueshow.THEUNIT = item.THEUNIT; //起单位
ueshow.THERELATIONSHIP = item.THERELATIONSHIP; //起关系
ueshow.ENDRANGESCOPE = item.ENDRANGESCOPE; //量程范围止
ueshow.ENDUNIT = item.ENDUNIT; //止单位
ueshow.ENDRELATIONSHIP = item.ENDRELATIONSHIP; //止关系
ueshow.THEFREQUENCY = item.THEFREQUENCY; //频率范围起
ueshow.THEUNITFREQUENCY = item.THEUNITFREQUENCY; //起单位
ueshow.THERELATIONSHIPFREQUENCY = item.THERELATIONSHIPFREQUENCY; //频率起关系
ueshow.ENDFREQUENCY = item.ENDFREQUENCY; //频率范围止
ueshow.ENDUNITFREQUENCY = item.ENDUNITFREQUENCY; //频率止单位
ueshow.ENDRELATIONSHIPFREQUENCY = item.ENDRELATIONSHIPFREQUENCY; //频率止关系
ueshow.INDEX1 = item.INDEX1; //指标1
ueshow.INDEX1UNIT = item.INDEX1UNIT; //指标1单位
ueshow.INDEX2 = item.INDEX2; //指标2
ueshow.INDEX2UNIT = item.INDEX2UNIT; //指标2单位
ueshow.NOTE = item.NOTE; //备注
ueshow.CATEGORY = item.CATEGORY;
ueshow.GROUPS = GROUPS;
ueshow.ID = item.ID;
groups = item.GROUPS.ToString();
ueshowlist.Add(ueshow);
GROUPS++;
}
msdshow.UNCERTAINTYTABLEShow = ueshowlist;
ViewBag.groups = groups;
return(View(msdshow));
}
public ActionResult Edit(string id)
{
METERING_STANDARD_DEVICEShow msdshow = new METERING_STANDARD_DEVICEShow();
if (!string.IsNullOrWhiteSpace(id))
{
METERING_STANDARD_DEVICE msd = m_BLL.GetById(id.Split('^')[0]); //通过id查询数据
int GROUPS = Convert.ToInt32(id.Split('^')[1]); //组别
string IS = id.Split('^')[2];
if (IS == "A")
{
string CATEGORY = id.Split('^')[3];
var alledata = msd.ALLOWABLE_ERROR.Where(a => a.GROUPS == GROUPS && a.CATEGORY == CATEGORY); //筛选数据
var msdcdata = msd.METERING_STANDARD_DEVICE_CHECK.Where(a => a.GROUPS == GROUPS && a.CATEGORY == CATEGORY); //筛选数据
foreach (var al in alledata) //循环添加数据
{
var alladd = new ALLOWABLE_ERRORShow()
{
ID = al.ID,
THEACCURACYLEVEL = al.THEACCURACYLEVEL,
THEUNCERTAINTYVALUEK = al.THEUNCERTAINTYVALUEK,
THEUNCERTAINTYNDEXL = al.THEUNCERTAINTYNDEXL,
THEUNCERTAINTYVALUE = al.THEUNCERTAINTYVALUE,
THEUNCERTAINTY = al.THEUNCERTAINTY,
MAXVALUE = al.MAXVALUE,
MAXCATEGORIES = al.MAXCATEGORIES,
METERING_STANDARD_DEVICEID = al.METERING_STANDARD_DEVICEID,
GROUPS = al.GROUPS
};
msdshow.ALLOWABLE_ERRORShow.Add(alladd);
}
foreach (var ms in msdcdata)//循环添加数据
{
var msdcadd = new METERING_STANDARD_DEVICE_CHECKShow()
{
ID = ms.ID,
CERTIFICATEUNIT = ms.CERTIFICATEUNIT,
CERTIFICATE_NUM = ms.CERTIFICATE_NUM,
CHECK_DATE = ms.CHECK_DATE,
VALID_TO = ms.VALID_TO,
METERING_STANDARD_DEVICEID = ms.METERING_STANDARD_DEVICEID,
GROUPS = ms.GROUPS
};
msdshow.METERING_STANDARD_DEVICE_CHECKShow.Add(msdcadd);
}
}
else if (IS == "UA" || IS == "UB")
{
var undata = msd.UNCERTAINTYTABLE.Where(a => a.GROUPS == GROUPS && a.CATEGORY == IS); //筛选数据
//undata = undata.Where(b => b.UNCERTAINTYUI != null);
foreach (var al in undata) //循环添加数据
{
var unadd = new UNCERTAINTYTABLEShow()
{
ID = al.ID,
ASSESSMENTITEM = al.ASSESSMENTITEM,
ERRORSOURCES = al.ERRORSOURCES,
ERRORLIMITS = al.ERRORLIMITS,
ERRORLIMITUNIT = al.ERRORLIMITUNIT,
THEERRODISTRIBUTION = al.THEERRODISTRIBUTION,
KVALE = al.KVALE,
THERANGESCOPE = al.THERANGESCOPE,
THEUNIT = al.THEUNIT,
THERELATIONSHIP = al.THERELATIONSHIP,
ENDRANGESCOPE = al.ENDRANGESCOPE,
ENDUNIT = al.ENDUNIT,
ENDRELATIONSHIP = al.ENDRELATIONSHIP,
THEFREQUENCY = al.THEFREQUENCY,
THEUNITFREQUENCY = al.THEUNITFREQUENCY,
THERELATIONSHIPFREQUENCY = al.THERELATIONSHIPFREQUENCY,
ENDFREQUENCY = al.ENDFREQUENCY,
ENDUNITFREQUENCY = al.ENDUNITFREQUENCY,
ENDRELATIONSHIPFREQUENCY = al.ENDRELATIONSHIPFREQUENCY,
INDEX1 = al.INDEX1,
INDEX1UNIT = al.INDEX1UNIT,
INDEX2 = al.INDEX2,
INDEX2UNIT = al.INDEX2UNIT,
NOTE = al.NOTE,
METERING_STANDARD_DEVICEID = al.METERING_STANDARD_DEVICEID,
GROUPS = al.GROUPS,
UNCERTAINTYUI = al.UNCERTAINTYUI,
UNCERTAINTYUIUNIT = al.UNCERTAINTYUIUNIT
};
msdshow.UNCERTAINTYTABLEShow.Add(unadd);
}
}
msdshow.IS = IS;
msdshow.ID = msd.ID;
ViewBag.GROUPS = GROUPS.ToString();
ViewBag.CATEGORY = id.Split('^')[3];
}
return(View(msdshow));
}
