/// <summary> /// 根据主键删除 /// </summary> /// <param name="drillPlanHalfYearReportItemId"></param> public static void DeleteDrillPlanHalfYearReportItemById(string drillPlanHalfYearReportItemId) { Model.SUBHSSEDB db = Funs.DB; Model.InformationProject_DrillPlanHalfYearReportItem drillPlanHalfYearReportItem = db.InformationProject_DrillPlanHalfYearReportItem.FirstOrDefault(e => e.DrillPlanHalfYearReportItemId == drillPlanHalfYearReportItemId); if (drillPlanHalfYearReportItem != null) { db.InformationProject_DrillPlanHalfYearReportItem.DeleteOnSubmit(drillPlanHalfYearReportItem); db.SubmitChanges(); } }
/// <summary> /// 修改 /// </summary> /// <param name="drillPlanHalfYearReportItem"></param> public static void UpdateDrillPlanHalfYearReportItem(Model.InformationProject_DrillPlanHalfYearReportItem drillPlanHalfYearReportItem) { Model.SUBHSSEDB db = Funs.DB; Model.InformationProject_DrillPlanHalfYearReportItem newDrillPlanHalfYearReportItem = db.InformationProject_DrillPlanHalfYearReportItem.FirstOrDefault(e => e.DrillPlanHalfYearReportItemId == drillPlanHalfYearReportItem.DrillPlanHalfYearReportItemId); if (newDrillPlanHalfYearReportItem != null) { newDrillPlanHalfYearReportItem.DrillPlanName = drillPlanHalfYearReportItem.DrillPlanName; newDrillPlanHalfYearReportItem.OrganizationUnit = drillPlanHalfYearReportItem.OrganizationUnit; newDrillPlanHalfYearReportItem.DrillPlanDate = drillPlanHalfYearReportItem.DrillPlanDate; newDrillPlanHalfYearReportItem.AccidentScene = drillPlanHalfYearReportItem.AccidentScene; newDrillPlanHalfYearReportItem.ExerciseWay = drillPlanHalfYearReportItem.ExerciseWay; newDrillPlanHalfYearReportItem.SortIndex = drillPlanHalfYearReportItem.SortIndex; db.SubmitChanges(); } }
/// <summary> /// 添加 /// </summary> /// <param name="drillPlanHalfYearReportItem"></param> public static void AddDrillPlanHalfYearReportItem(Model.InformationProject_DrillPlanHalfYearReportItem drillPlanHalfYearReportItem) { Model.SUBHSSEDB db = Funs.DB; Model.InformationProject_DrillPlanHalfYearReportItem newDrillPlanHalfYearReportItem = new Model.InformationProject_DrillPlanHalfYearReportItem { DrillPlanHalfYearReportItemId = drillPlanHalfYearReportItem.DrillPlanHalfYearReportItemId, DrillPlanHalfYearReportId = drillPlanHalfYearReportItem.DrillPlanHalfYearReportId, DrillPlanName = drillPlanHalfYearReportItem.DrillPlanName, OrganizationUnit = drillPlanHalfYearReportItem.OrganizationUnit, DrillPlanDate = drillPlanHalfYearReportItem.DrillPlanDate, AccidentScene = drillPlanHalfYearReportItem.AccidentScene, ExerciseWay = drillPlanHalfYearReportItem.ExerciseWay, SortIndex = drillPlanHalfYearReportItem.SortIndex }; db.InformationProject_DrillPlanHalfYearReportItem.InsertOnSubmit(newDrillPlanHalfYearReportItem); db.SubmitChanges(); }