public HttpResponseMessage GetData_EQISO(Info_EQISO info)
{
string result = null;
try
{
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQISO_Midd> query = new List <tblHM_EQISO_Midd>();
query = (from x in db.tblHM_EQISO_Midd
select x).ToList();
ReturnData2 rd = new ReturnData2();
rd.dangqi = query;
if (info.IsYear == "1")
{
int year = int.Parse(info.fldYear) - 1;
List <tblHM_EQISO_Midd> query2 = new List <tblHM_EQISO_Midd>();
query2 = (from x in db.tblHM_EQISO_Midd
select x).ToList();
rd.tongqi = query2;
}
result = rule.JsonStr("ok", "", rd);
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage ExeCacheData_EQISO(Info_EQISO info)
{
string result = null;
DataTable dt = new DataTable();
try
{
//第一步
#region 初始化变量
tblHM_EQISO_Info_Midd info_Midd = new tblHM_EQISO_Info_Midd();
DateTime BeginDate = DateTime.Parse(info.BeginDate);
DateTime EndDate = DateTime.Parse(info.EndDate);
#endregion
//第二步
#region 处理参数表，检查此条件下是否已经进行过缓存
using (MiddleContext db = new MiddleContext())
{
var query = (from x in db.tblHM_EQISO_Info_Midd
where x.BeginDate == BeginDate &&
x.EndDate == EndDate &&
x.fldPCode == info.fldPCode &&
x.fldStandardName == info.fldStandardName &&
x.fldLevel == info.fldLevel &&
x.fldItemCode == info.fldItemCode &&
x.DecCarry == info.DecCarry
select x).Count();
if (query > 0)
{
result = rule.JsonStr("ok", "此条件下已经进行过数据缓存。", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
}
#endregion
//第三步
#region 执行通用存储过程，返回数据
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@fldPCode", info.fldPCode),
new SqlParameter("@fldStandardName", info.fldStandardName),
new SqlParameter("@fldLevel", info.fldLevel),
new SqlParameter("@fldItemCode", info.fldItemCode),
new SqlParameter("@DecCarry", info.DecCarry)
};
dt = rule.RunProcedure_V2("usp_tblEQISO_Report_LevelApprise", paras.ToList(), null, "HMEntityContext");
if (dt == null || dt.Rows.Count == 0)
{
result = rule.JsonStr("ok", "此条件集合下并未返回数据", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
#endregion
//第四步
#region 如果存储过程返回数据，那么将条件写入参数表
using (MiddleContext db = new MiddleContext())
{
info_Midd.BeginDate = BeginDate;
info_Midd.EndDate = EndDate;
info_Midd.fldPCode = info.fldPCode;
info_Midd.fldStandardName = info.fldStandardName;
info_Midd.fldLevel = info.fldLevel;
info_Midd.fldItemCode = info.fldItemCode;
info_Midd.DecCarry = info.DecCarry;
db.tblHM_EQISO_Info_Midd.Add(info_Midd);
db.SaveChanges();
}
#endregion
//第五步
#region 相关数据处理
if (true)
{
using (MiddleContext db = new MiddleContext())
{
List <tblHM_EQISO_Midd> list = new List <tblHM_EQISO_Midd>();
foreach (DataRow item in dt.Rows)
{
tblHM_EQISO_Midd data = new tblHM_EQISO_Midd();
//将参数实体的主键值，设置给数据表的FKID，从而确定数据是从哪个参数下生成的
data.fldFKID = info_Midd.fldAutoID;
data.fldSTName = item["fldSTName"].ToString();
data.fldPCount = item["fldPCount"].ToString();
data.fldScale = item["fldScale"].ToString();
data.fldRange = item["fldRange"].ToString();
data.fldPiAvg = item["fldPiAvg"].ToString();
data.fld1Level = item["fld1Level"].ToString();
data.fld2Level = item["fld2Level"].ToString();
list.Add(data);
}
db.tblHM_EQISO_Midd.AddRange(list);
db.SaveChanges();
}
}
#endregion
result = rule.JsonStr("ok", "执行成功！", info_Midd.fldAutoID);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
