public JsonResult GetInfo(string ID) { var mql2 = TF_PersonnelFile_Transmitting_InSet.SelectAll().Where(TF_PersonnelFile_Transmitting_InSet.Id.Equal(ID)); TF_PersonnelFile_Transmitting_In Rmodel = OPBiz.GetEntity(mql2); var mql3 = TF_PersonnelFile_Transmitting_In_ItemSet.SelectAll().Where(TF_PersonnelFile_Transmitting_In_ItemSet.OwnerId.Equal(ID)); var ItemBlist = OPItemBiz.GetEntities(mql3); var df = new { inmode = Rmodel, InItem = ItemBlist }; // groupsBiz.Add(rol); return(Json(df, JsonRequestBehavior.AllowGet)); }
public FileResult CommonExportWordIn(string id) { var mql2 = TF_PersonnelFile_Transmitting_InSet.SelectAll().Where(TF_PersonnelFile_Transmitting_InSet.Id.Equal(id)); TF_PersonnelFile_Transmitting_In Rmodel = tfpftBiz.GetEntity(mql2); Dictionary <string, string> dir = new Dictionary <string, string>(); dir.Add("Series", Rmodel.Series); // dir.Add("Nos", Rmodel.Nos); dir.Add("Series2", Rmodel.Series); // dir.Add("Nos2", Rmodel.Nos); var mql3 = TF_PersonnelFile_Transmitting_In_ItemSet.SelectAll().Where(TF_PersonnelFile_Transmitting_In_ItemSet.OwnerId.Equal(id)); var listItem = OPBiz.GetDictionaryList(mql3); string filename = Guid.NewGuid().ToString() + ".docx"; string loadfilename = Server.MapPath("~/tempword/干部人事档案材料转递单.docx"); WordHelper.ExportWord(listItem, dir, Server.MapPath("~/temp/" + filename), loadfilename, 2); // var ff = Exporter.Instance(Server.MapPath("~/temp/" + filename)).Download(); return(File(Server.MapPath("~/temp/" + filename), "application/ms-word", string.Format("{0}.docx", "干部人事档案材料转递单"))); }
public JsonResult AdminEditInfo(TF_PersonnelFile_Transmitting_In EidModle) { HttpReSultMode ReSultMode = new HttpReSultMode(); bool IsAdd = false; if (!(EidModle.Id != null && !EidModle.Id.ToString().Equals("00000000-0000-0000-0000-000000000000")))//id为空,是添加 { IsAdd = true; } if (IsAdd) { EidModle.Id = Guid.NewGuid(); EidModle.CreateMan = UserData.UserName; EidModle.CreateManId = UserData.Id; EidModle.CreateTime = DateTime.Now; EidModle.isDeleted = false; EidModle.States = 0; try { List <TF_PersonnelFile_Transmitting_In_Item> listItem = JsonHelper.JSONToList <TF_PersonnelFile_Transmitting_In_Item>(EidModle.FistName); int OriginalCount = 0; int DuplicateCount = 0; int MaterialCount = 0; string allname = ""; if (listItem != null && listItem.Count > 0) { EidModle.FistName = listItem[0].RealName; allname += listItem[0].RealName + "、"; for (int i = 0; i < listItem.Count; i++) { OriginalCount += listItem[i].OriginalCount; DuplicateCount += listItem[i].DuplicateCount; MaterialCount += listItem[i].MaterialCount;//统计数 listItem[i].Id = Guid.NewGuid();; listItem[i].OwnerId = EidModle.Id; OPItemBiz.Add(listItem[i]);//添加项 } EidModle.OriginalCount = OriginalCount; EidModle.DuplicateCount = DuplicateCount; EidModle.MaterialCount = MaterialCount; EidModle.NumberS = listItem.Count; } allname = allname.TrimEnd('、'); EidModle.FileName = allname; OPBiz.Add(EidModle); ReSultMode.Code = 11; ReSultMode.Data = EidModle.Id.ToString(); ReSultMode.Msg = "添加成功"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.新增, "档案转入--新增", true, WebClientIP, "档案转入"); } catch (Exception e) { ReSultMode.Code = -11; ReSultMode.Data = e.ToString(); ReSultMode.Msg = "添加失败"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.新增, "档案转入--新增", false, WebClientIP, "档案转入"); } } else { EidModle.WhereExpression = TF_PersonnelFile_Transmitting_InSet.Id.Equal(EidModle.Id); List <TF_PersonnelFile_Transmitting_In_Item> listItem = JsonHelper.JSONToList <TF_PersonnelFile_Transmitting_In_Item>(EidModle.FistName); // EidModle.ChangedMap.Remove("id");//移除主键值 EidModle.FistName = listItem[0].RealName; // EidModle.TransmittingMan = UserData.UserName; EidModle.TransmittingTime = DateTime.Now; if (EidModle.signatureimage == null || EidModle.signatureimage.Length == 0) { byte[] myByteArray = new byte[1]; EidModle.signatureimage = myByteArray; } if (OPBiz.Update(EidModle) > 0) { int OriginalCount = 0; int DuplicateCount = 0; int MaterialCount = 0; if (listItem != null && listItem.Count > 0) { EidModle.FistName = listItem[0].RealName; for (int i = 0; i < listItem.Count; i++) { // OriginalCount += listItem[i].OriginalCount; // DuplicateCount += listItem[i].DuplicateCount; // MaterialCount += listItem[i].MaterialCount;//统计数 // listItem[i].Id = listItem[i].Id; ; // listItem[i].OwnerId = EidModle.Id; listItem[i].WhereExpression = TF_PersonnelFile_Transmitting_In_ItemSet.Id.Equal(listItem[i].Id); OPItemBiz.Update(listItem[i]);//添加项 } } ReSultMode.Code = 11; ReSultMode.Data = ""; ReSultMode.Msg = "修改成功"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.修改, "档案转入--修改", true, WebClientIP, "档案转入"); } else { ReSultMode.Code = -13; ReSultMode.Data = ""; ReSultMode.Msg = "修改失败"; SysOperateLogBiz.AddSysOperateLog(UserData.Id.ToString(), UserData.UserName, e3net.Mode.OperatEnumName.修改, "档案转入--修改", false, WebClientIP, "档案转入"); } } return(Json(ReSultMode, JsonRequestBehavior.AllowGet)); }