public HttpResponseMessage Upload_Delete(Upload_Delete_Info info)
{
string result = string.Empty;
try
{
Model.tblReportArchive list = new Model.tblReportArchive();
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.tblReportArchive
where x.fldAutoID == info.fldAutoID
select x).ToList().FirstOrDefault();
File.Delete(list.fldPath);
db.tblReportArchive.Remove(list);
db.SaveChanges();
}
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Get_Eqia_R_Item(Get_Eqia_R_Item_Info info)
{
string result = string.Empty;
try
{
List <EMCMIS.Model.tblEQIA_R_Item> list = new List <EMCMIS.Model.tblEQIA_R_Item>();
using (EMCMIS.Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.tblEQIA_R_Item
select x).ToList();
}
if (list != null && list.Count > 0)
{
result = rule.JsonStr("ok", "", list);
}
else
{
result = rule.JsonStr("nodata", "没有数据", "");
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Upload_Data__For_ElectronicFile(Upload_Data__For_ElectronicFile_Info info)
{
string result = string.Empty;
try
{
Model.ElectronicFile list = new Model.ElectronicFile();
list.fldReport_Name = info.fldReport_Name;
list.fldReport_Type = info.fldReport_Type;
list.fldRName = info.fldRName;
list.fldUserID = info.fldUserID;
list.fldTime = DateTime.Now;
list.fldPath = info.fldPath;
list.fldFileName = info.fldFileName;
using (Model.EntityContext db = new Model.EntityContext())
{
db.ElectronicFile.Add(list);
db.SaveChanges();
}
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage AddPoint_For_ElectronicFile(AddPoint_For_ElectronicFile_Info info)
{
string result = string.Empty;
try
{
Model.ElectronicFile_Point list = new Model.ElectronicFile_Point();
list.fldPointName = info.fldPointName;
list.fldParentID = info.fldParentID;
using (Model.EntityContext db = new Model.EntityContext())
{
db.ElectronicFile_Point.Add(list);
db.SaveChanges();
}
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Import_PreData(List <Import_PreData_Info> info)
{
string result = null;
int datacount = 0;
try
{
List <Model.tblEQIW_R_Basedata_Pre> list = new List <Model.tblEQIW_R_Basedata_Pre>();
foreach (var item in info)
{
Model.tblEQIW_R_Basedata_Pre pre = new Model.tblEQIW_R_Basedata_Pre();
pre.fldSTCode = item.fldSTCode;
pre.fldRCode = item.fldRCode;
pre.fldRSCode = item.fldRSCode;
pre.fldSAMPH = item.fldSAMPH;
pre.fldSAMPR = item.fldSAMPR;
pre.fldRSC = item.fldRSC;
pre.fldYear = item.fldYear;
pre.fldMonth = item.fldMonth;
pre.fldDay = item.fldDay;
pre.fldHour = item.fldHour;
pre.fldMinute = item.fldMinute;
pre.fldItemCode = item.fldItemCode;
pre.fldItemValue = item.fldItemValue;
pre.fldFlag = 1;
pre.fldImport = 1;
pre.fldCityID_Operate = 2;
pre.fldCityID_Submit = "2";
pre.fldDate_Operate = DateTime.Now;
pre.fldUserID = 578;
pre.fldSource = 0;
pre.fldBatch = "0";
pre.fldDeleteState = 0;
list.Add(pre);
}
using (Model.EntityContext db = new Model.EntityContext())
{
db.tblEQIW_R_Basedata_Pre.AddRange(list);
datacount = db.SaveChanges();
}
result = rule.JsonStr("ok", "", datacount);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Download_File__For_ElectronicFile(string fldAutoID)
{
string result = string.Empty;
try
{
int ID = int.Parse(fldAutoID);
Model.ElectronicFile list = new Model.ElectronicFile();
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.ElectronicFile
where x.fldAutoID == ID
select x).ToList().FirstOrDefault();
}
var FilePath = list.fldPath;
var stream = new FileStream(FilePath, FileMode.Open);
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
response.Content = new StreamContent(stream);
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = list.fldFileName
};
return(response);
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Upload_Delete_For_ElectronicFile(Upload_Delete_For_ElectronicFile_Info info)
{
string result = string.Empty;
try
{
Model.ElectronicFile list = new Model.ElectronicFile();
List <Model.ElectronicFile> arr = new List <Model.ElectronicFile>();
using (Model.EntityContext db = new Model.EntityContext())
{
foreach (var item in info.fldAutoID.Split(','))
{
int t = Convert.ToInt32(item.ToString());
list = (from x in db.ElectronicFile
where x.fldAutoID == t
select x).ToList().FirstOrDefault();
if (list.fldPath != null && list.fldPath != "")
{
File.Delete(list.fldPath);
}
db.ElectronicFile.Remove(list);
arr.Add(list);
}
db.SaveChanges();
}
result = rule.JsonStr("ok", "", arr);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage DeletePoint_For_ElectronicFile(DeletePoint_For_ElectronicFile_Info info)
{
string result = string.Empty;
try
{
Model.ElectronicFile_Point list = new Model.ElectronicFile_Point();
List <Model.ElectronicFile_Point> list2 = new List <Model.ElectronicFile_Point>();
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.ElectronicFile_Point
where x.fldAutoID == info.fldAutoID
select x).FirstOrDefault();
list2 = (from x in db.ElectronicFile_Point
where x.fldAutoID == list.fldParentID
select x).ToList();
db.ElectronicFile_Point.RemoveRange(list2);
db.ElectronicFile_Point.Remove(list);
db.SaveChanges();
}
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Get_Eqiw_R_Section_Data(Get_Eqiw_R_Section_Data_Info info)
{
string result = string.Empty;
try
{
using (Model.EntityContext db = new Model.EntityContext())
{
List <Model.tblEQIW_R_Section> list = new List <Model.tblEQIW_R_Section>();
list = (from x in db.tblEQIW_R_Section
where info.fldYear == x.fldYear &&
x.fldFunType == "采测分离"
select x).ToList();
if (list != null && list.Count > 0)
{
result = rule.JsonStr("ok", "", list);
}
else
{
result = rule.JsonStr("nodata", "没有数据", "");
}
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetRawData(GetRawData_Info info)
{
string result = null;
DataTable dt = new DataTable();
using (Model.EntityContext db = new Model.EntityContext())
{
decimal?Year = decimal.Parse(info.BeginDate.Substring(0, 4));
var query = (from x in db.tblEQIW_R_Section
where x.fldYear == Year &&
x.fldFunType == "采测分离"
select x).ToList();
if (query.Count == 0)
{
result = rule.JsonStr("ok", "未获取到数据！", "");
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
foreach (var item in query)
{
info.fldRSCode += "'" + item.fldSTCode + "." + item.fldRCode + "." + item.fldRSCode + "',";
}
info.fldRSCode = info.fldRSCode.TrimEnd(',');
}
try
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@TimeType", "month"),
new SqlParameter("@BeginDate", info.BeginDate),
new SqlParameter("@EndDate", info.EndDate),
new SqlParameter("@EBeginDate", ""),
new SqlParameter("@EEndDate", ""),
new SqlParameter("@fldRSC", "0"),
new SqlParameter("@fldRSCode", info.fldRSCode),
new SqlParameter("@fldStandardName", "GB 3838-2002"),
new SqlParameter("@fldLevel", 3),
new SqlParameter("@fldItemCode", "302,315,314,316,317,311,313,434,435,318,319,320,438,436,323,437,325,326,327,328,467"),
new SqlParameter("@DecCarry", "0"),
new SqlParameter("@IsPre", 0),
new SqlParameter("@IsYear", 0),
new SqlParameter("@IsTotal", 1),
new SqlParameter("@IsDetail", 0),
new SqlParameter("@AppriseID", 0),
new SqlParameter("@SpaceID", 2),
new SqlParameter("@STatType", 3),
new SqlParameter("@Para1ID", 0),
new SqlParameter("@Para2ID", 1),
new SqlParameter("@Source", 0),
new SqlParameter("@CalculateID", 0)
};
dt = rule.RunProcedure("usp_tblEQIW_R_Report_Apprise", paras.ToList(), null);
result = rule.JsonStr("ok", "", dt);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage GetRealTimeQuery(GetRealTimeQuery_Info info)
{
string result = string.Empty;
try
{
List <string> ItemCode = new List <string>();
if (info.fldItemCode != "All")
{
ItemCode = info.fldItemCode.Split(',').ToList();
}
List <Model.tblEQIA_RPI_Basedata> list = new List <Model.tblEQIA_RPI_Basedata>();
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.tblEQIA_RPI_Basedata
select x).ToList();
if (info.fldSTCode != "-1")
{
//根据断面代码查询
list = (from x in list
where info.fldSTCode.Contains(x.fldSTCode + "." + x.fldPCode)
select x).ToList();
}
if (info.fldItemCode != "All")
{
//根据因子代码查询
list = (from x in list
where ItemCode.Contains(x.fldItemCode)
select x).ToList();
}
List <Model.tblEQIA_RPI_Basedata> list_2 = new List <Model.tblEQIA_RPI_Basedata>();
foreach (var item in list)
{
if (DateTime.TryParse(item.fldEYear + "-" + item.fldEMonth + "-" + item.fldEDay + " " + item.fldEHour + ":" + item.fldEMinute + ":00", out DateTime ret))
{
}
else
{
list_2.Add(item);
}
}
//根据时间查询
list = (from x in list
where DateTime.Parse(x.fldSYear + "-" + x.fldSMonth + "-" + x.fldSDay + " " + x.fldSHour + ":" + x.fldSMinute + ":00") >= BeginDate &&
DateTime.Parse(x.fldSYear + "-" + x.fldSMonth + "-" + x.fldSDay + " " + x.fldSHour + ":" + x.fldSMinute + ":00") <= EndDate
select x).ToList();
}
if (list.Count > 0)
{
result = rule.JsonStr("ok", "", list);
}
else
{
result = rule.JsonStr("nodata", "没有数据！", "");
}
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Upload_Query_For_ElectronicFile_V2(Upload_Query_For_ElectronicFile_V2_Info info)
{
string result = string.Empty;
try
{
List <Model.ElectronicFile> list = new List <Model.ElectronicFile>();
List <Model.ElectronicFile> listdata = new List <Model.ElectronicFile>();
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.ElectronicFile
select x).ToList();
}
if (!(info.fldUserID == "admin"))
{
list = (from x in list
where x.fldUserID == info.fldUserID
select x).ToList();
}
DateTime BeginDate = DateTime.Parse(info.fldBeginDate);
DateTime EndDate = DateTime.Parse(info.fldEndDate);
list = (from x in list
where x.fldTime >= BeginDate &&
x.fldTime <= EndDate
select x).ToList();
if (!(info.obj == "" || info.obj == null))
{
if (info.fldReport_Name != null && info.fldReport_Name != "")
{
list = (from x in list
where x.fldReport_Name.Contains(info.fldReport_Name)
select x).ToList();
}
if (info.fldReport_Type != null && info.fldReport_Type != "")
{
list = (from x in list
where x.fldReport_Type.Contains(info.fldReport_Type)
select x).ToList();
}
if (info.fldRName != null && info.fldRName != "")
{
list = (from x in list
where x.fldRName.Contains(info.fldRName)
select x).ToList();
}
if (info.fldUserID != null && info.fldUserID != "")
{
list = (from x in list
where x.fldUserID == info.fldUserID
select x).ToList();
}
if (info.fldFileName != null && info.fldFileName != "")
{
list = (from x in list
where x.fldFileName.Contains(info.fldFileName)
select x).ToList();
}
}
list = list.OrderByDescending(x => x.fldTime).ToList();
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
public HttpResponseMessage Upload_Query(Upload_Query_Info info)
{
string result = string.Empty;
try
{
List <Model.tblReportArchive> list = new List <Model.tblReportArchive>();
List <Model.tblReportArchive> listdata = new List <Model.tblReportArchive>();
using (Model.EntityContext db = new Model.EntityContext())
{
list = (from x in db.tblReportArchive
select x).ToList();
}
if (!(info.fldUserID == "admin"))
{
list = (from x in list
where x.fldUserID == info.fldUserID
select x).ToList();
}
if (!(info.obj == "" || info.obj == null))
{
var query1 = from x in list
where x.fldReport_Name.Contains(info.obj)
select x;
var query2 = from x in list
where x.fldReport_Type.Contains(info.obj)
select x;
var query3 = from x in list
where x.fldRName.Contains(info.obj)
select x;
var query4 = from x in list
where x.fldTime.Contains(info.obj)
select x;
listdata = query1.Union(query2).ToList();
listdata = listdata.Union(query3).ToList();
listdata = listdata.Union(query4).ToList();
list = listdata;
}
result = rule.JsonStr("ok", "", list);
}
catch (Exception e)
{
result = rule.JsonStr("error", e.Message, "");
}
return(new HttpResponseMessage {
Content = new StringContent(result, System.Text.Encoding.UTF8, "application/json")
});
}
