public ActionResult Add(YG_InsiderRltsList obj)
{
obj.CreateOn = DateTime.Now;
var result = insiderrltsListService.CreateModel(obj) ? SuccessTip("新增成功!") : ErrorTip("新增失败!");
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult GetRelationData(string Post, string RepartyNm)
{
YG_InsiderRltsList rltsList = new YG_InsiderRltsList();
rltsList.InsiderPs = Post;
rltsList.InsiderNm = RepartyNm;
PageInfo pageInfo = new PageInfo();
pageInfo.limit = 50;
pageInfo.page = 1;
JsonResult js = Json(insiderrltsservice.GetListByFilter(rltsList, pageInfo));
string json = Newtonsoft.Json.JsonConvert.SerializeObject(js);
JObject jo = JObject.Parse(json);
IEnumerable <dynamic> dynamics = jo.Values().Values().Values().Children();
int count = dynamics.Count();
dynamic[] arrays = dynamics.ToArray();
int i;
var data = " [{\"name\": \"" + RepartyNm + "\",\"des\": \"" + RepartyNm + "\",\"symbolSize\": 70,\"category\": 0},";
var link = "[";
for (i = 0; i < count - 1; i++)
{
data += "{ \"name\": \"" + arrays[i]["RltsNm"] + "\",\"des\": \"" + arrays[i]["RltsNm"] + "\",\"symbolSize\": 50,\"category\": 1},";
link += "{\"source\": \"" + RepartyNm + "\",\"target\": \"" + arrays[i]["RltsNm"] + "\",\"name\": \"" + arrays[i]["Relationship"] + "\",\"des\": \"" + arrays[i]["Relationship"] + "\"}, ";
}
data += "{ \"name\": \"" + arrays[i]["RltsNm"] + "\",\"des\": \"" + arrays[i]["RltsNm"] + "\",\"symbolSize\": 50,\"category\": 1}]";
link += "{\"source\": \"" + RepartyNm + "\",\"target\": \"" + arrays[i]["RltsNm"] + "\",\"name\": \"" + arrays[i]["Relationship"] + "\",\"des\": \"" + arrays[i]["Relationship"] + "\"}]";
return(Json(new
{
data = data,
link = link
}));
}
public ActionResult Edit(YG_InsiderRltsList obj)
{
var result = insiderrltsListService.UpdateModel(obj) ? SuccessTip("编辑成功!") : ErrorTip("编辑失败!");
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult List(YG_InsiderRltsList filter, PageInfo pageInfo)
{
var result = insiderrltsListService.GetListByFilter(filter, pageInfo);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult Import()
{
string FileUrl;
WorkbookDesigner designer;
Worksheet sheet;
try
{
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase file = files[0];
string extName = Path.GetExtension(file.FileName).ToLower(); //获取文件名后缀
if (string.IsNullOrEmpty(file.FileName) || extName != ".xls")
{
return(Json(new
{
Result = false,
Data = "请选择一个EXCEL文件！"
}));
}
string path = Server.MapPath("/Upload/file/insiderrlts/"); //获取保存目录的物理路径
//生成新文件的名称，guid保证某一时刻内文件名唯一（文件不会被覆盖）
string fileNewName = Guid.NewGuid().ToString();
FileUrl = path + fileNewName + extName;
file.SaveAs(FileUrl); //SaveAs将文件保存到指定文件夹中
designer = new WorkbookDesigner();
designer.Workbook = new Workbook(FileUrl);
sheet = designer.Workbook.Worksheets[1];
if (sheet.Name != "内部人近亲属")
{
return(Json(new
{
Result = false,
Data = "请选择模板导入！"
}));
}
}
catch (Exception exception)
{
return(Json(new
{
Result = false,
Data = exception.Message
}));
}
Cells cells = sheet.Cells;
DataTable dt = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn, true);
if (dt == null || dt.Rows.Count == 0)
{
return(Json(new
{
Result = false,
Data = "该文件无具体数据项!"
}));
}
dt.Rows.RemoveAt(0); //去掉表格第一行
dt.Rows.RemoveAt(0); //去掉表格第二行
dt.Rows.RemoveAt(0); //去掉表格第三行
foreach (DataRow dr in dt.Rows)
{
if (string.IsNullOrEmpty(dr["InsiderPs"].ToString()))
{
continue;
}
YG_InsiderRltsList obj = new YG_InsiderRltsList();
if (!string.IsNullOrEmpty(dr["InsiderPs"].ToString()))
{
obj.InsiderPs = dr["InsiderPs"].ToString();
}
if (!string.IsNullOrEmpty(dr["InsiderNm"].ToString()))
{
obj.InsiderNm = dr["InsiderNm"].ToString();
}
if (!string.IsNullOrEmpty(dr["RltsNm"].ToString()))
{
obj.RltsNm = dr["RltsNm"].ToString();
}
if (!string.IsNullOrEmpty(dr["IdentityCd"].ToString()))
{
obj.IdentityCd = dr["IdentityCd"].ToString();
}
if (!string.IsNullOrEmpty(dr["Relationship"].ToString()))
{
obj.Relationship = dr["Relationship"].ToString();
}
if (!string.IsNullOrEmpty(dr["CompanyNm"].ToString()))
{
obj.CompanyNm = dr["CompanyNm"].ToString();
}
if (!string.IsNullOrEmpty(dr["SocialCreditCode"].ToString()))
{
obj.SocialCreditCode = dr["SocialCreditCode"].ToString();
}
if (!string.IsNullOrEmpty(dr["Controller"].ToString()))
{
obj.Controller = dr["Controller"].ToString();
}
if (!string.IsNullOrEmpty(dr["ControllerRlts"].ToString()))
{
obj.ControllerRlts = dr["ControllerRlts"].ToString();
}
obj.CreateOn = DateTime.Now;
var result = insiderrltsListService.CreateModel(obj);
if (result == false)
{
return(Json(new
{
Result = false,
Data = "上传失败!"
}));
}
}
return(Json(new
{
Result = true,
Data = "上传成功!"
}));
}
