/// <summary> /// 删除标牌 /// </summary> /// <param name="SignManageId"></param> public static void DeleteSignManage(string signManageId) { Model.SUBHSSEDB db = Funs.DB; Model.Resources_SignManage deleteSignManage = db.Resources_SignManage.FirstOrDefault(e => e.SignManageId == signManageId); if (deleteSignManage != null) { if (!string.IsNullOrEmpty(deleteSignManage.SignUrl)) { BLL.UploadFileService.DeleteFile(Funs.RootPath, deleteSignManage.SignUrl); } ////删除附件表 BLL.CommonService.DeleteAttachFileById(deleteSignManage.SignManageId); db.Resources_SignManage.DeleteOnSubmit(deleteSignManage); db.SubmitChanges(); } }
/// <summary> /// 修改标牌信息 /// </summary> /// <param name="SignManageId"></param> /// <param name="SignName"></param> /// <param name="def"></param> public static void UpdateSignManage(Model.Resources_SignManage SignManage) { Model.SUBHSSEDB db = Funs.DB; Model.Resources_SignManage updateSignManage = db.Resources_SignManage.FirstOrDefault(e => e.SignManageId == SignManage.SignManageId); if (updateSignManage != null) { updateSignManage.SignCode = SignManage.SignCode; updateSignManage.SignName = SignManage.SignName; updateSignManage.SignLen = SignManage.SignLen; updateSignManage.SignWide = SignManage.SignWide; updateSignManage.SignHigh = SignManage.SignHigh; updateSignManage.SignThick = SignManage.SignThick; updateSignManage.Material = SignManage.Material; updateSignManage.SignArea = SignManage.SignArea; updateSignManage.SignType = SignManage.SignType; updateSignManage.SignImage = SignManage.SignImage; updateSignManage.SignUrl = SignManage.SignUrl; db.SubmitChanges(); } }
/// <summary> /// 增加标牌 /// </summary> /// <param name="SignManage"></param> public static void AddSignManage(Model.Resources_SignManage SignManage) { Model.SUBHSSEDB db = Funs.DB; Model.Resources_SignManage newSignManage = new Model.Resources_SignManage { SignManageId = SignManage.SignManageId, SignCode = SignManage.SignCode, SignName = SignManage.SignName, SignLen = SignManage.SignLen, SignWide = SignManage.SignWide, SignHigh = SignManage.SignHigh, SignThick = SignManage.SignThick, Material = SignManage.Material, SignArea = SignManage.SignArea, SignType = SignManage.SignType, SignImage = SignManage.SignImage, SignUrl = SignManage.SignUrl }; db.Resources_SignManage.InsertOnSubmit(newSignManage); db.SubmitChanges(); }