/// <summary> /// 添加养护附件 /// </summary> /// <param name="model"></param> public void AddFile(YH_FileModel model) { using (Entities db = new Entities()) { yh_files yhmodel = new yh_files(); //yhmodel.fileid = model.fileid; yhmodel.filesource = model.filesource; yhmodel.sourceid = model.sourceid; yhmodel.filename = model.filename; yhmodel.filetype = model.filetype; yhmodel.filepath = model.filepath; yhmodel.filesize = model.filesize; db.yh_files.Add(yhmodel); db.SaveChanges(); } }
public int DeleteContractInf(int contractid) { using (Entities db = new Entities()) { yh_contracts model = db.yh_contracts.SingleOrDefault(t => t.contractid == contractid); if (model != null) { db.yh_contracts.Remove(model); } //删除附件 do { yh_files file_model = db.yh_files.FirstOrDefault(a => a.sourceid == contractid && a.filesource == 1); if (file_model != null) { db.yh_files.Remove(file_model); } }while (db.SaveChanges() > 0); return(db.SaveChanges()); } }
public int ModifyContractInf(YH_ContractModel model, List <FileUploadClass> list) { bool info = false, file = false; using (Entities db = new Entities()) { yh_contracts bags_model = db.yh_contracts.FirstOrDefault(a => a.contractid == model.contractid); if (bags_model != null) { bags_model.contractname = model.contractname; bags_model.patrolexplain = model.patrolexplain; bags_model.contractnum = model.contractnum; bags_model.jfdw = model.jfdw; bags_model.jfdb = model.jfdb; bags_model.yfdw = model.yfdw; bags_model.yfdb = model.yfdb; bags_model.jldw = model.jldw; bags_model.starttime = model.starttime; bags_model.endtime = model.endtime; bags_model.signdate = model.signdate; bags_model.summoney = model.summoney; bags_model.htzxzt = model.htzxzt; bags_model.currentmoney = model.currentmoney; bags_model.contactendtime = model.contactendtime; bags_model.contacttype = model.contacttype; bags_model.contracttype = model.contracttype; bags_model.yhmoney = model.yhmoney; bags_model.patrolemoney = model.patrolemoney; if (db.SaveChanges() > 0) { info = true; } } foreach (var item in list) { yh_files filemodel = new yh_files(); filemodel.filesource = 1; //1合同2日志3单位 filemodel.filename = item.OriginalName; filemodel.filepath = item.OriginalPath; filemodel.filesize = item.size; filemodel.filetype = item.OriginalType; filemodel.sourceid = bags_model.contractid; db.yh_files.Add(filemodel); } if (db.SaveChanges() > 0) { file = true; } if (info && file) { return(1); } else { return(0); } } }
/// <summary> /// 添加养护合同 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddContract(YH_ContractModel model, List <FileClass> list) { bool info = false, file = false; using (Entities db = new Entities()) { yh_contracts yhmodel = new yh_contracts(); yhmodel.contractid = model.contractid; yhmodel.contractname = model.contractname; yhmodel.patrolexplain = model.patrolexplain; yhmodel.contractnum = model.contractnum; yhmodel.jfdw = model.jfdw; yhmodel.jfdb = model.jfdb; yhmodel.yfdw = model.yfdw; yhmodel.yfdb = model.yfdb; yhmodel.jldw = model.jldw; yhmodel.starttime = model.starttime; yhmodel.endtime = model.endtime; yhmodel.signdate = model.signdate; yhmodel.summoney = model.summoney; yhmodel.htzxzt = model.htzxzt; yhmodel.currentmoney = model.currentmoney; yhmodel.contactendtime = model.contactendtime; yhmodel.contacttype = model.contacttype; yhmodel.contracttype = model.contracttype; yhmodel.yhmoney = model.yhmoney; yhmodel.patrolemoney = model.patrolemoney; yhmodel.createuserid = model.createuserid; yhmodel.createtime = DateTime.Now; db.yh_contracts.Add(yhmodel); if (db.SaveChanges() > 0) { info = true; } foreach (var item in list) { yh_files filemodel = new yh_files(); filemodel.filesource = 1; //1合同 2日志 3单位 filemodel.filename = item.OriginalName; filemodel.filepath = item.OriginalPath; filemodel.filesize = item.size; filemodel.filetype = item.OriginalType; filemodel.sourceid = yhmodel.contractid; db.yh_files.Add(filemodel); } if (db.SaveChanges() > 0) { file = true; } if (info || (info && file)) { return(1); } else { return(0); } } }