public static int deleteMT(int lineId, int partId)
{
manufacturingTimeModel data = new manufacturingTimeModel
{
lineId = lineId,
partId = partId,
};
string sql = @"delete from [ManufacturingTime] where lineId = @lineId and partId = @partId;";
return(SqlDataAccess.SaveData(sql, data));
}
public static int updateMT(int lineId, int partId, int manufacturingTime)
{
manufacturingTimeModel data = new manufacturingTimeModel
{
lineId = lineId,
partId = partId,
manufacturingTime = manufacturingTime
};
string sql = @"update [ManufacturingTime] set manufacturingTime = @manufacturingTime where lineId = @lineId and partId = @partId;";
return(SqlDataAccess.SaveData(sql, data));
}
public static List <manufacturingTimeModel> GetManufacturingTimeByPart(int partId)
{
manufacturingTimeModel data = new manufacturingTimeModel
{
partId = partId
};
string sql = @"select lineID, partId, ManufacturingTime from[ManufacturingTime] where partId = @partId order by manufacturingTime asc;";
return(SqlDataAccess.LoadData <manufacturingTimeModel>(sql, data));
}
public static int CreateMT(int lineId, int partId, int manufacturingTime)
{
manufacturingTimeModel data = new manufacturingTimeModel
{
lineId = lineId,
partId = partId,
manufacturingTime = manufacturingTime
};
string sql = @"insert into [ManufacturingTime] (lineId,partId,manufacturingTime)
values (@lineId,@partId,@manufacturingTime);";
return(SqlDataAccess.SaveData(sql, data));
}
public static List <manufacturingTimeModel> GetManufacturingTime(int lineId, int partId)
{
manufacturingTimeModel data = new manufacturingTimeModel
{
lineId = lineId,
partId = partId
};
string sql = @"select lineID,partId, ManufacturingTime from [ManufacturingTime] where lineId = @lineId and partId = @partId;";
return(SqlDataAccess.LoadData <manufacturingTimeModel>(sql, data));
}
