/// <summary> /// get process card list by id /// </summary> /// <param name="id"></param> /// <returns></returns> public static Guid AddProcesPlanningData(PlanningCardRelation planningCardRelation) { try { string strsql = @" INSERT INTO [dbo].[PlanningCardRelation] ([PlanningCardRelationId] ,[ProcessPlanningId] ,[ProcessCardId] ,[CardSort]) VALUES (@PlanningCardRelationId ,@ProcessPlanningId ,@ProcessCardId ,@CardSort);"; int cardSort = GetMaxCardSort(planningCardRelation.ProcessPlanningId); using (DbCommand cmd = db.GetSqlStringCommand(strsql)) { db.AddInParameter(cmd, "@PlanningCardRelationId", DbType.Guid, planningCardRelation.PlanningCardRelationId); db.AddInParameter(cmd, "@ProcessPlanningId", DbType.Guid, planningCardRelation.ProcessPlanningId); db.AddInParameter(cmd, "@ProcessCardId", DbType.Guid, planningCardRelation.ProcessCardId); db.AddInParameter(cmd, "@CardSort", DbType.Int32, cardSort); db.ExecuteScalar(cmd); return(planningCardRelation.PlanningCardRelationId); } } catch (Exception ex) { throw ex; } }
public static Guid AddProcesPlanningData(PlanningCardRelation planningCardRelation) { try { Guid id = PlanningCardRelationDAL.AddProcesPlanningData(planningCardRelation); return(id); } catch { throw; } }