/// <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;
}
}
