//
public HttpResponseMessage ItemSave(eqiw_dsavedata data)
{
string result = string.Empty;
int result2 = 0;
try
{
using (EntityContext db = new EntityContext())
{
var query = from x in data.fldItemData
select x;
DateTime time = DateTime.Parse(data.BeginDate);
foreach (var item in query)
{
var tbl = new tblEQIW_DT_Basedata_Pre()
{
fldItemCode = item.itemcode,
fldItemValue = decimal.Parse(item.itemvalue),
fldYear = time.Year,
fldMonth = time.Month,
fldDay = time.Day,
fldHour = time.Hour,
fldMinute = time.Minute,
fldUserID = int.Parse(data.fldUserID),
fldCityID_Operate = int.Parse(data.fldCityID_Operate),
fldCityID_Submit = data.fldCityID_Submit,
fldSTCode = data.fldCountyCode,
fldRCode = data.fldRCode,
fldRSCode = data.fldRSCode,
fldRSC = data.fldRSC,
fldFlag = 0,
fldImport = 0,
fldSAMPH = "0",
fldSAMPR = "0",
fldDate_Operate = DateTime.Now,
fldSource = 0,
fldBatch = "0",
fldDeleteState = 0
};
db.tblEQIW_DT_Basedata_Pre.Add(tbl);
}
result2 = db.SaveChanges();
}
if (result2 > 0)
{
result = rule.JsonStr("ok", "保存成功！", "");
}
else
{
result = rule.JsonStr("no", "保存失败！", "");
}
}
catch (InputException ex)
{
result = rule.JsonStr("error", "数据保存失败，" + ex.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
//
public HttpResponseMessage ItemSave(eqiw_dsavedata data)
{
string result = string.Empty;
int result2 = 0;
try
{
using (EntityContext db = new EntityContext())
{
var query = from x in data.fldItemData
select x;
DateTime time = DateTime.Parse(data.Date);
string fldSTCode = null;
if (data.fldCountyCode != null)
{
fldSTCode = data.fldCountyCode;
}
else
{
fldSTCode = data.fldSTCode;
}
foreach (var item in query)
{
if (data.type == "eqib_czp")
{
var tbl = new tblEQIBCZPBaseData_Pre()
{
fldPCode = item.fldPCode,
fldCTypeCode = item.fldCTypeCode,
fldWaterTyoe = item.fldWaterTyoe,
fldPickVolume = decimal.Parse(item.fldPickVolume),
fldConcentrate = decimal.Parse(item.fldConcentrate),
fldDensity = decimal.Parse(item.fldDensity),
fldYear = time.Year,
fldMonth = time.Month,
fldDay = time.Day,
fldHour = time.Hour,
fldMinute = time.Minute,
fldUserID = int.Parse(data.fldUserID),
fldCityID_Operate = int.Parse(data.fldCityID_Operate),
fldCityID_Submit = data.fldCityID_Submit,
fldSTCode = fldSTCode,
fldFlag = 0,
fldImport = "0",
fldDate_Operate = DateTime.Now,
fldBatch = "0",
fldSource = 0,
fldRCode = data.fldRCode,
fldRSCode = data.fldRSCode,
fldSAMPH = data.fldSAMPH,
fldSAMPR = data.fldSAMPR,
fldRSC = data.fldRSC,
fldTypeCode = "无值"
};
db.tblEQIBCZPBaseData_Pre.Add(tbl);
}
else if (data.type == "eqib_czc")
{
var tbl = new tblEQIBCZCBaseData_Pre()
{
fldPCode = item.fldPCode,
fldCTypeCode = item.fldCTypeCode,
fldNetTyoe = item.fldNetTyoe,
fldPickVolume = decimal.Parse(item.fldPickVolume),
fldConcentrate = decimal.Parse(item.fldConcentrate),
fldDensity = decimal.Parse(item.fldDensity),
fldYear = time.Year,
fldMonth = time.Month,
fldDay = time.Day,
fldHour = time.Hour,
fldMinute = time.Minute,
fldUserID = int.Parse(data.fldUserID),
fldCityID_Operate = int.Parse(data.fldCityID_Operate),
fldCityID_Submit = data.fldCityID_Submit,
fldSTCode = fldSTCode,
fldFlag = 0,
fldImport = "0",
fldDate_Operate = DateTime.Now,
fldBatch = "0",
fldSource = 0,
fldRCode = data.fldRCode,
fldRSCode = data.fldRSCode,
fldSAMPH = data.fldSAMPH,
fldSAMPR = data.fldSAMPR,
fldRSC = data.fldRSC,
fldTypeCode = "无值"
};
db.tblEQIBCZCBaseData_Pre.Add(tbl);
}
else if (data.type == "eqib_cd")
{
var tbl = new tblEQIBCDBaseData_Pre()
{
fldPCode = item.fldPCode,
fldCTypeCode = item.fldCTypeCode,
fldAcreage = decimal.Parse(item.fldAcreage),
fldAmount = decimal.Parse(item.fldAmount),
fldDensity = decimal.Parse(item.fldDensity),
fldYear = time.Year,
fldMonth = time.Month,
fldDay = time.Day,
fldHour = time.Hour,
fldMinute = time.Minute,
fldUserID = int.Parse(data.fldUserID),
fldCityID_Operate = int.Parse(data.fldCityID_Operate),
fldCityID_Submit = data.fldCityID_Submit,
fldSTCode = fldSTCode,
fldFlag = 0,
fldImport = "0",
fldDate_Operate = DateTime.Now,
fldBatch = "0",
fldSource = 0,
fldRCode = data.fldRCode,
fldRSCode = data.fldRSCode,
fldSAMPH = data.fldSAMPH,
fldSAMPR = data.fldSAMPR,
fldRSC = data.fldRSC,
fldTypeCode = "无值"
};
db.tblEQIBCDBaseData_Pre.Add(tbl);
}
else if (data.type == "eqib_cwc")
{
var tbl = new tblEQIBCWCBaseData_Pre()
{
fldPCode = item.fldPCode,
fldCTypeCode = item.fldCTypeCode,
fldAcreage = decimal.Parse(item.fldAcreage),
fldDensity = decimal.Parse(item.fldDensity),
fldYear = time.Year,
fldMonth = time.Month,
fldDay = time.Day,
fldHour = time.Hour,
fldMinute = time.Minute,
fldUserID = int.Parse(data.fldUserID),
fldCityID_Operate = int.Parse(data.fldCityID_Operate),
fldCityID_Submit = data.fldCityID_Submit,
fldSTCode = fldSTCode,
fldFlag = 0,
fldImport = "0",
fldDate_Operate = DateTime.Now,
fldBatch = "0",
fldSource = 0,
fldRCode = data.fldRCode,
fldRSCode = data.fldRSCode,
fldSAMPH = data.fldSAMPH,
fldSAMPR = data.fldSAMPR,
fldRSC = data.fldRSC,
fldTypeCode = "无值"
};
db.tblEQIBCWCBaseData_Pre.Add(tbl);
}
else if (data.type == "eqib_cwp")
{
var tbl = new tblEQIBCWPBaseData_Pre()
{
fldPCode = item.fldPCode,
fldCTypeCode = item.fldCTypeCode,
fldDilution = decimal.Parse(item.fldDilution),
fldDensity = decimal.Parse(item.fldDensity),
fldYear = time.Year,
fldMonth = time.Month,
fldDay = time.Day,
fldHour = time.Hour,
fldMinute = time.Minute,
fldUserID = int.Parse(data.fldUserID),
fldCityID_Operate = int.Parse(data.fldCityID_Operate),
fldCityID_Submit = data.fldCityID_Submit,
fldSTCode = fldSTCode,
fldFlag = 0,
fldImport = "0",
fldDate_Operate = DateTime.Now,
fldBatch = "0",
fldSource = 0,
fldRCode = data.fldRCode,
fldRSCode = data.fldRSCode,
fldSAMPH = data.fldSAMPH,
fldSAMPR = data.fldSAMPR,
fldRSC = data.fldRSC,
fldTypeCode = "无值"
};
db.tblEQIBCWPBaseData_Pre.Add(tbl);
}
}
result2 = db.SaveChanges();
}
if (result2 > 0)
{
result = rule.JsonStr("ok", "保存成功！", "");
}
else
{
result = rule.JsonStr("no", "保存失败！", "");
}
}
catch (Exception e)
{
result = rule.JsonStr("error", "数据保存失败，" + e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
