public EquipmentRes Reg(EquipmentReg Ereg)
{
var retItem = new EquipmentRes();
using (var context = WDbContext())
{
//首先查询数据库中是否存在
string strSql = "select MEID,MECode,LoginID,States from MeterEquipment where MECode=@MECode";
var retItems = context.Sql(strSql)
.Parameter("MECode", Ereg.MECode)
.QueryMany <EquipmentItem>();
if (retItems == null || retItems.Count == 0)
{
//插入CODE记录
strSql = " INSERT INTO MeterEquipment (MECode) VALUES (@MECode)";
context.Sql(strSql)
.Parameter("MECode", Ereg.MECode).Execute();
retItem = new EquipmentRes();
retItem.isErrMsg = false;
retItem.errMsg = "";
return(retItem);
}
else
{
if (retItems.Count == 1)
{
if (retItems[0].LoginID == null || retItems[0].States != 0)
{
retItem.isErrMsg = true;
retItem.errMsg = "该设备暂不可用";
retItem.errMsgNo = 1;
return(retItem);
}
}
else
{
retItems = retItems.Where(c => c.States == 0 && c.LoginID != null).ToList();
}
}
if (retItems == null || retItems.Count == 0)
{
retItem.isErrMsg = true;
retItem.errMsg = "没有查询到数据";
retItem.errMsgNo = 1;
}
retItem.equipmentItems = retItems;
return(retItem);
}
}
//注册手机
public EquipmentRes Reg(EquipmentReg req)
{
var logRes = cbDal.Reg(req);
return(logRes);
}
